Mind the Gaps - Gallery elaborati
u.id_joomla AS i_id_j,
u.id_scuola AS i_id_s,
sc.id AS sc_id
FROM jos_users AS u JOIN
sc_scuole AS s JOIN
cross_schede AS sc JOIN
jos_downloads_log AS d
WHERE sc.id_user = u.id AND
u.id_scuola = s.id AND
sc.pubblicato = '1' AND
sc.id_file = '36257' AND
sc.id_classe = d.id
AND date >= '2017-9-01'
ORDER BY sc.date DESC >