SELECT DISTINCT(p.name), p.price, s2.stock,sh.issue FROM .stock s JOIN .shirts sh ON sh.id = s.shirt_id JOIN .ppsd_products p ON p.name = sh.issue LEFT JOIN .stock s2 ON s.shirt_id = s2.shirt_id AND s2.stock > 0 WHERE (s.size_id = 13615121512136141124) AND s.stock > 0 AND p.price > 37 AND p.no_list_in_cart != '1' ORDER BY sh.issue DESC