Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *, IF(`stock` > 0, 1, 0) AS is_stock, stock
- FROM `product_marketplace` `t`
- WHERE (((marketplace_id=12) AND (STATUS LIKE '%1%')) AND (marketplace_sku_approved=0)) AND (suggestion_status=1) AND t.suggestion_sku is null and marketplace_sku is null
- ORDER BY stock DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement