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