Order query

SELECT entity_id FROM `sales_order` WHERE `status` = 'processing' AND `created_at` >= '2018-11-22 00:00:00' AND `created_at` <= '2018-11-22 23:59:59' AND entity_id NOT IN(select orderId from ERPORDERS)