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