query=SELECT jr_user.id FROM jr_user_entry RIGHT JOIN jr_user ON user_id=jr_user.id WHERE date_format(duedate, '%Y-%m')='2014-07'
group by user order by jr_user.creation_date+0
Journals with Due Date: July 2014
Username |
Name |
Due Date |
Creation Date |
The last entry |
|