Advertisement
vlnovikova

Untitled

Jun 18th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT
  2. o.id,
  3. ocg.order_id,
  4. DATE(ot.in_accept) accepted
  5.  
  6. FROM orders o
  7. LEFT JOIN orders_cost_general ocg ON o.id = ocg.order_id
  8. LEFT JOIN orders_time ot ON o.id = ot.order_id
  9. LEFT JOIN customers c ON o.customer_id = c.id
  10. WHERE
  11. ot.in_accept >= "2017-01-01"
  12. AND c.id NOT IN (160971, 165890, 45885, 112435)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement