Errant query: SELECT distinct cid, sid, image_name, large_image, small_image, ifnull(description1,'') description1, ifnull(description2,'') description2, ifnull(description3,'') description3, ifnull(description4,'') description4 from products where sid in ('10081','10083','10085','10088','10094','10096','10100','10101','10103','10104','10105','10106','3092','3095','3100','3108','3113','2803','2843','2844','2981','2990','3025','3051','3053','3067','3069','3070','6820','6823') AND show_cat!='on' order by sort