vitrina

SELECT
   tmp.`original_sku`, GREATEST(COUNT(tmp.id), IFNULL(tmp.supplier_stock, 0))-vitrina.c AS stock
FROM (
SELECT pm.`original_sku`, pm.id, pss.stock AS supplier_stock, pst.product_item_id FROM product_marketplace AS pm
    LEFT JOIN sites_marketplace AS sm ON sm.`id` = pm.`marketplace_id`
    LEFT JOIN product_site AS ps ON ps.`product_id` = pm.`product_id` AND ps.`site_id` = sm.`site_id`
    LEFT JOIN product_supplier_stock AS pss ON pm.`product_id` = pss.`product_id`
    LEFT JOIN product_stock AS pst ON pm.`product_id` = pst.`product_id`
    LEFT JOIN storage_address AS sa ON sa.`id` = pst.`storage_address_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 pm.`marketplace_id` = 12 AND pm.`status` = 1
  AND IF(pm.`price` > 0, pm.`price`, ps.`price`) >= 1000
  AND (pst.`storage_address_id` NOT IN (118,1991,1992,1993,1994,1995,1989,2364,2462,3249) OR pst.`storage_address_id` IS NULL)
  AND (sa.`storage_address_group_id` NOT IN(27,59,60,63,64,65,78,79,80,81,88,89) OR sa.`storage_address_group_id` IS NULL)
  AND oi.id IS NULL
  AND pim.movement_type_id != 17
  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