SELECT tmp.`sku`, tmp.title, COUNT(tmp.id) - IFNULL(vitrina.c, 0) AS stock
FROM (
SELECT p.`sku`, p.model, p.title, p.id, pst.product_item_id FROM product AS p
    LEFT JOIN product_site AS ps ON ps.`product_id` = p.`id`
    LEFT JOIN product_stock AS pst ON p.`id` = pst.`product_id`
    LEFT JOIN storage_address AS sa ON sa.`id` = pst.`storage_address_id`
    LEFT JOIN storage_address_group AS sag ON sag.id = sa.storage_address_group_id
    LEFT JOIN `storage` s ON s.id = sag.storage_id
    LEFT JOIN site_storage ss ON ss.storage_id = s.id AND ss.site_id = ps.site_id
    LEFT JOIN order_item AS oi ON pst.`product_item_id` = oi.`product_item_id`
    LEFT JOIN product_item_movement pim ON pim.product_item_id = pst.product_item_id
WHERE ps.`site_id` = 4
  AND ps.`price` >= 1000
  AND ss.id IS NOT NULL
  AND oi.id IS NULL
  AND pim.movement_type_id != 17
 AND p.brand_id in(1,5,7,19,30,36,58,95,96,114,210,211,221,264,277,287,344,400,411,445,675)
#AND (p.width <= 1800
#AND p.depth <= 1800
#AND p.height <= 1800)
  GROUP BY pst.id) tmp
  LEFT JOIN (
        SELECT pst.product_id, COUNT(pst.product_item_id) AS c, pst.product_item_id FROM product_stock AS pst
        LEFT JOIN storage_address AS sa ON sa.`id` = pst.`storage_address_id`
        LEFT JOIN storage_address_group AS sag ON sag.id = sa.storage_address_group_id
        WHERE sag.storage_id = 2 GROUP BY pst.product_id HAVING c = 1
  ) AS vitrina ON tmp.product_item_id = vitrina.product_item_id GROUP BY tmp.id')