SELECT DAY(data) AS date_dd, MONTH(data) AS date_mm, YEAR(data) AS date_yy, traduzione, file_name, file_name_userfriendly
FROM download
LEFT JOIN voci_lingua ON (voci_lingua.idvoce = download.idvoce_titolo AND voci_lingua.idlingua = 1)
LEFT JOIN uploaded_files_language ON (uploaded_files_language.id_uploaded_file = download.id_uploaded_file AND uploaded_files_language.idlingua = 1)
ORDER BY data DESC, id_download DESC
-
08 May 2017
File type: PDF - File size: 1.5 MB
-
16 April 2016
File type: PDF - File size: 13.7 KB