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')='2015-10'
group by user order by jr_user.creation_date+0
Journals with Due Date: October 2015
Username |
Name |
Due Date |
Creation Date |
The last entry |
|