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')='2013-07' group by user order by jr_user.creation_date+0

Journals with Due Date: July 2013

Username

Name

Due Date

Creation Date

The last entry