#3000001
SELECT p.id FROM produkt p LEFT OUTER JOIN spieleshop_produkt_vk_kategorie_2021 pvk ON (pvk.produkt_id = p.id) LEFT OUTER JOIN spieleshop_kategorien_2021 k ON (k.id = pvk.kategorie_id) WHERE p.status = 'aktiv' AND p.vk_preis > '0' AND (p.parentid = '0' OR p.parentid = '') AND p.id IN (SELECT produkt_id FROM produkt_bilder WHERE bk != '') AND p.shopanzeige_spieleshop_ch = 'y' AND ( (p.marke = 'Thinkfun') ) AND ( ) GROUP BY p.id;