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='Australi��' or proSmaak like '%Australi��%,' or proAroma like '%Australi��%,' or proDruif like '%Australi��%,' or proGerecht like '%Australi��%,' or lanTitel like '%Australi��%' or afsTitel like '%Australi��%' or kleTitel like '%Australi��%' or wijTitel like '%Australi��%' or strTitel like '%Australi��%' or proTitel like '%Australi��%' or proKoptekst like '%Australi��%' or proId like '%Australi��%') and gdc_cat_producten.publiceren=1 group by proTitel order by gdc_cat_producten.volgnummer,proId