SELECT r.FileID, r.ContentID, r.DocTitle, r.UploadDate, d.ContentPath as pdfURL FROM tbl_FSPro_Repository r, qryContentFullPathLookup d WHERE r.ContainerID = AND r.ContainerType = 'FSPro' AND r.linkId = AND r.linkType = 'SKU' AND r.OwnerType = AND r.OwnerID = AND r.ContentID = d.ContentID ORDER BY r.UploadDate desc