a guest Jan 18th, 2019 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- select o.orders_id from orders o
- join facturi f on f.orders_id=o.orders_id
- join orders_total ot on ot.orders_id=o.orders_id
- where f.data_facturii BETWEEN '2018-12-01' AND '2018-12-31'
- AND o.site IN ('librariaonline.ro','librariileonline.ro', 'procarti.ro', 'librarultau.ro', 'universulcartii.ro')
- and o.orders_status in ('1000002', '1000003', '1000005', '1000006','1000030');
RAW Paste Data