I have a table with structure
id | item | order_date | delivery_date
And I have an array of dates, for example
$dates = array('2015-06-01', '2015-06-11', '2015-06-26');
What I need to do is to find count of items which where ordered, but not delivered yet on each date. Because of my code complexity, it is impossible to foreach array and search for each date separately.
There is an example of what I think the query should look like, but I am starting wondering if it is even possible to make it work this way (without foreaching each date).
SELECT SUM(id) FROM orders WHERE order_date > IN({implode(",", $dates)}) AND delivery_date < IN ({implode(",", $dates)}) GROUP BY ???
Notice: I would like to GROUP BY each date given in an array.