SELECT
document.filename,
document.did,
document.title,
document.ts,
document.pwd,
document.private,
document.filesize,
documentcat.title AS ctitle
FROM
document
LEFT JOIN
documentcat
ON
document.dcid = documentcat.dcid
WHERE
document.live=1
ORDER BY
document.ts DESC