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