select distinct p.products_model, p.MPN, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, p.products_date_available, cd.categories_name, m.manufacturers_id, p.trasportogratis, p.colore1,p.colore2,pi.products_image1,p.products_forsale,
p.products_submodel,p.products_id, pd.products_name, pd.canonical,pd.products_url,pd.products_description,p2c.categories_id,c.categories_tree,p.MPN,
p.products_price_gross ,p.products_price, p.products_price_listino,p.listino,p.products_tax_class_id,
IF(s.status, s.specials_new_products_price_gross, NULL) as specials_new_products_price_gross,
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(c.parent_id>0,concat(cdp.categories_name,'/',cd.categories_name),cd.categories_name) as cpath_name, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join manufacturers m using(manufacturers_id)
left join specials s on (p.products_id = s.products_id and s.status=1 and (s.date_inizio<=now() or s.date_inizio is null) and (s.expires_date>now() or s.expires_date is null))
inner join products_description pd on p.products_id=pd.products_id
inner join products_to_categories p2c on p.products_id=p2c.products_id AND (p2c.main=1 OR (p2c.main=0 AND p2c.categories_id=318))
inner join categories c on c.categories_id=p2c.categories_id
inner join categories_description cd on c.categories_id=cd.categories_id
LEFT JOIN categories_description cdp ON c.parent_id=cdp.categories_id
left join products_images pi on pi.products_id = p.products_id
where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (p.products_quantity > '0' or (p.products_quantity<=0 and m.da_escludere=0 and c.categories_id <> 320)) and p.products_price_gross > 0 and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '4' and c.categories_tree like '%;178;%' group by p.products_model order by p.products_last_modified desc
Calandra bordatrice manuale con matrici METALLKRAFT SBM 110-08
Il presente sito utilizza cookies propri e di terze parti per finalità tecniche, di analisi, statistica e di profilazione e remarketing. Maggiori informazioni e modalità di gestione delle Sue preferenze sui cookies di terze parti sono disponibili al link Note legali e Privacy. Cliccando il testo "prosegui", lei acconsente all’uso dei cookies di terze parti, per le finalità indicate nell’informativa. Prosegui
I NOSTRI PRODOTTI
+39 0434 630602
+39 366 377 5259
