Für Heidepflanzen gilt eine Mindestbestellmenge von 5 Pflanzen
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 = 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 p.products_status = 1 order by pd.products_name limit 204,12