SELECT DISTINCT twk_document.*, twk_document_type.title AS document_type, COUNT(*) AS interestcount FROM twk_xlink LEFT JOIN twk_document ON twk_xlink.lft = twk_document.document_id LEFT JOIN twk_document_type ON twk_document.document_type_id = twk_document_type.document_type_id WHERE twk_xlink.type = 102 AND twk_xlink.rgt IN () AND NOT twk_xlink.lft = 404 GROUP BY document_id ORDER BY twk_document.last_modified DESC LIMIT 0,6
CRF - Library -
