select distinct p.products_image, pd.products_mis as misname, p.products_misid as mis, pd.products_conf as conf, p.products_id as id, p.products_model as model, pg.customers_group_price as pricer, pd.products_uv as uv, p.xcd as xcd from products_groups pg, products p, products_to_categories p2c, products_description pd where p.products_misid = '40' and pg.products_id = pd.products_id and pg.customers_group_id = '10000' and p.products_status = '1' and p.products_id = pd.products_id and p.products_id = p2c.products_id and pd.language_id = '4' and p2c.categories_id LIKE '8082289%' and p.products_misid= '40' order by p.products_model ASC Confezioni disponibili
I cookie usati su questo sito sono strettamente necessari al funzionamento ed
all'erogazione del servizio: attività di salvataggio delle preferenze, di salvataggio del carrello e di statistica
effettuata dal gestore del sito in forma aggregata 63008768 visite