Errant query:  SELECT distinct p.sid, p.image_name, p.large_image, p.small_image, ifnull(p.description1,'') description1, ifnull(p.description2,'') description2, ifnull(p.description3,'') description3, ifnull(p.description4,'') description4, ov.value as fabric FROM products p INNER JOIN products_attributes pa ON pa.sid = p.sid INNER JOIN options_values ov ON pa.value_id = ov.value_id inner join options o on o.option_id = pa.option_id WHERE ov.option_id = 1 and cid = 28 AND show_cat!='on' order by sort