SELECT * FROM prod WHERE 1=1 and vis =1 and (cid = "1404" or
cid_2 = "1404" or
cid_3 = "1404" or
cid_4 = "1404" or
cid_5 = "1404" or
cid2 = "1404" or
cid2_2 = "1404" or
cid2_3 = "1404" or
cid2_4 = "1404" or
cid2_5 = "1404") ORDER BY brand Translators - Fesco Distributors