Mind the Gaps - Gallery elaborati
i.id AS i_id,
i.id_joomla AS i_id_j,
i.id_scuola1 AS i_id_s,
sc.id AS sc_id
FROM jos_users AS u JOIN
sc_insegnanti_new AS i 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 = i.id_joomla AND
i.id_scuola1 = s.id AND
sc.pubblicato = '1' AND
sc.id_file = '36257' AND
sc.id_classe = d.id
AND date >= '2017-09-01'
ORDER BY sc.date DESC >