Suchergebnis
Laubschöne Rhododendren
SELECT DISTINCT p.products_id, p.products_image, pd.products_name from tx_multishop_products p, tx_multishop_products_description pd, tx_multishop_products_to_categories pc , tx_multishopext_products_description epd where
p.products_id = pd.products_id
and p.products_id = pc.products_id
and pd.products_name > '' and pc.categories_id > 0 and epd.products_id = p.products_id and epd.beautiful_leaves=1 and epd.products_id = p.products_id and p.products_status = 1 order by pd.products_name limit 36,12
kein Artikel gefunden