gistfile1.txt

SELECT me.content_item_id, me.content_queue_id, me.client_id, me.client_service_id, me.supported_service_id, me.content_source_id, me.score, me.is_published, me.is_expired, me.is_deleted, me.failed_to_publish, me.must_publish, me.dont_send, me.is_scored, me.meta, me.content, me.status, me.create_date
  FROM content_item me
  LEFT JOIN content_item_scheduled_date schedule_date
    ON schedule_date.content_item_id = me.content_item_id
WHERE ( ( schedule_date.scheduled_date BETWEEN '2016-05-01T04:00:00' AND '2016-05-08T04:00:00' ) OR status = 'Optimize' ) AND ( client_service_id = '2179' OR client_service_id = '2638' ) AND ( content_queue_id = '1537' OR content_queue_id = '1853' ) AND is_deleted = '0' AND is_expired = '0' AND is_published = '0' AND ( status = 'Optimize' OR status = 'Schedule' )