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');