Download

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 = 2) LEFT JOIN uploaded_files_language ON (uploaded_files_language.id_uploaded_file = download.id_uploaded_file AND uploaded_files_language.idlingua = 2) ORDER BY data DESC, id_download DESC