Advertisement
Guest User

Untitled

a guest
Sep 17th, 2014
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.44 KB | None | 0 0
  1.  
  2.     SELECT SUM(s.quantity) - r.reserved
  3.     FROM stock s
  4.     INNER JOIN (
  5.         SELECT COUNT(r.id_reservation) reserved
  6.         FROM stock s
  7.         LEFT JOIN reservation r ON r.fk_stock = s.id_stock
  8.         WHERE s.simple_sku IN (SELECT csi.sku FROM catalog_simple csi WHERE csi.fk_catalog_config = id_catalog_config)
  9.     ) r
  10.     WHERE s.simple_sku IN (SELECT csi.sku FROM catalog_simple csi WHERE csi.fk_catalog_config = id_catalog_config)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement