Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT q.product_id, pq.qty as total_qty FROM cataloginventory_stock_item q JOIN cataloginventory_stock_item pq ON pq.product_id = q.product_id WHERE q.is_in_stock = 1 AND ((q.use_config_manage_stock = 1 AND 1 = 1) OR (q.use_config_manage_stock = 0 AND q.manage_stock = 1)) AND ((q.use_config_backorders = 1 AND 0 = 0) OR (q.use_config_backorders = 0 AND q.backorders = 0)) AND q.product_id IN (103768) GROUP BY pq.product_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement