Hi, if I order the Documents by the 'Revision Date' field, no rows are selected.
This is the sql executed:

SELECT documents.id , documents_cstm.*, documents.document_revision_id , documents.document_name , documents.category_id , documents.subcategory_id , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , 'Users' created_by_name_mod, documents.active_date , documents.exp_date , documents.created_by
FROM documents
LEFT JOIN documents_cstm ON documents.id = documents_cstm.id_c
LEFT JOIN users jt0 ON jt0.id= documents.created_by AND jt0.deleted=0 AND jt0.deleted=0
where documents.deleted=0
ORDER BY last_rev_create_date ASC LIMIT 0,21

The problem is that the 'last_rev_create_date' field doesn't exists.

Any idea?

TIA
Ciao
Leonardo Cosmai.