Suchergebnis

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 , tx_multishopext_products_to_heather_bloom_period eph where p.products_id = pd.products_id and p.products_id = pc.products_id and pd.products_name > '' and (pc.categories_id = 9 or pc.categories_id in (select categories_id from tx_multishop_categories where parent_id = 9)) and epd.products_id = p.products_id and eph.products_id = p.products_id and (eph.heather_bloom_period = 3 ) and p.products_status = 1 order by pd.products_name limit 24,12