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','10082','10083','10084','10085','10086','10087','10088','10090','10091','10092','10094','10095','10096','10098','10099','10100','10106','10108','3084','3089','3093','3095','3096','3098','3100','3103','3104','3105','3111','3114','6807','6805','3072','3066','3061','3060','3058','3057','2820','2822','2875','2898','2904','2908','2909','2910','2915','2918','2929','2952','2961','2962','2966','2972','2974','2976','2979','2982','2986','2989','2994','2995','3006','3011','3021','3028','3041') AND show_cat!='on' order by sort