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