query=SELECT jr_user.id, isnull(jr_user_entry.creation_date) as is_null,
max(jr_user_entry.creation_date) as maxdate FROM jr_user_entry RIGHT JOIN jr_user ON user_id=jr_user.id WHERE is_browse=1 and (prv_passw is null or prv_passw='')
group by user
order by is_null, maxdate desc, hit_cnt desc limit 200
Last Updated Journals
Username |
Name |
Last Updated |
Due Date |
The last entry |
|