Advertisement
rdfx

no_suggestions

May 6th, 2021
964
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None | 0 0
  1. SELECT *, IF(`stock` > 0, 1, 0) AS is_stock, stock
  2. FROM `product_marketplace` `t`
  3. 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
  4. ORDER BY stock DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement