select * from gdc_cat_producten,mod_winkelform_btwcodes,landen,streek,wijnhuis,kleurtype,afsluiting where afsId=proAfsluiting and kleId=proKleurType and wijId=proWijnhuis and strId=proStreek and lanId=proLand and proBtw=btwId and ( proReferentienummer='Cataloni��' or proSmaak like '%Cataloni��%,' or proAroma like '%Cataloni��%,' or proDruif like '%Cataloni��%,' or proGerecht like '%Cataloni��%,' or lanTitel like '%Cataloni��%' or afsTitel like '%Cataloni��%' or kleTitel like '%Cataloni��%' or wijTitel like '%Cataloni��%' or strTitel like '%Cataloni��%' or proTitel like '%Cataloni��%' or proKoptekst like '%Cataloni��%' or proId like '%Cataloni��%') and gdc_cat_producten.publiceren=1 group by proTitel order by gdc_cat_producten.volgnummer,proId