SELECT archimedercitems.id as id,archimedercitems.category as category, archimedercitemsDetail.itemTitle as itemTitle,archimedercimages.file FROM archimedercitems LEFT JOIN archimedercitemsDetail ON (archimedercitemsDetail.item = archimedercitems.id) LEFT JOIN archimedercimages ON (archimedercitemsDetail.id = archimedercimages.item) WHERE archimedercimages.del = 0 AND archimedercimages.active = 1 AND archimedercitems.del = 0 AND archimedercitemsDetail.active = 1 AND lang = '1' AND archimedercitemsDetail.del = 0 AND category = 66 GROUP BY archimedercitems.id
Aerei elettrici
Ordina per:
Aereo a scoppio
Codice :
0,00
iva esclusa € 0,00
DISPONIBILITÁ:


Aereo a scoppio


E-mail:
Password:
In aggiornamento