select `vendor` as fld from Message2001 as a where Catalogue_ID = '576' AND Checked = 1 AND (( a.name like '%004_00001%' OR a.Keyword like '%004_00001%' OR a.art like '%004_00001%' OR a.art2 like '%004_00001%' OR a.artnull like '%004_00001%' OR a.vendor like '%004_00001%' OR a.analog like '%004_00001%' OR a.tags like '% 004_00001 %' OR a.tags like '004_00001' OR a.tags like '004_00001,%' OR a.tags like '004_00001 %' OR a.tags like '% 004_00001,%' OR a.tags like '%,004_00001,%' OR a.tags like '% 004_00001' OR a.tags like '%,004_00001' OR a.var2 like '%004_00001%' OR a.var3 like '%004_00001%' OR a.var4 like '%004_00001%' OR a.var5 like '%004_00001%' OR a.var6 like '%004_00001%' OR a.var7 like '%004_00001%' OR a.var8 like '%004_00001%' OR a.var9 like '%004_00001%' OR a.var10 like '%004_00001%' OR a.var11 like '%004_00001%' OR a.var12 like '%004_00001%' OR a.var13 like '%004_00001%' OR a.var14 like '%004_00001%' OR a.var15 like '%004_00001%' )) ORDER by `vendor`filters