Q&A for Joomla! administrators, users, developers and designers
SELECT TOP ##number## Id, url = 'site://q/' + CAST(Id AS varchar), Score FROM PostsWithDeleted WHERE (PostTypeId = 2) and (Deletiondate IS NOT NULL) ORDER BY Score ASC