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 = 858765441316153152383) AND s.stock > 0 AND p.price > 37 AND p.no_list_in_cart != '1'
ORDER BY sh.issue DESC