> ERROR > SELECT u.id AS u_id, u.name AS u_name,
u.cb_ordineegrado AS c_ordineegrado,
u.cb_nomeistituto AS c_nomeistituto, u.cb_city AS c_city, u.state AS c_state,

u.id_joomla AS i_id_j,
u.id_scuola AS i_id_s,

sc.id AS sc_id, sc.pubblicato AS sc_pubblicato, sc.date AS sc_date,
sc.img1 AS sc_img1, sc.titolo AS sc_titolo, sc.tema AS sc_tema,
sc.aree AS sc_aree, sc.descrizione AS sc_descrizione, sc.strumento AS sc_strumento

FROM jos_users AS u JOIN
cross_schede AS sc JOIN
jos_downloads_log AS d

WHERE sc.id_user = u.id AND
sc.id_file = '102180' AND
sc.id_classe = d.id

AND sc.pubblicato >= 1

AND c.cb_ordineegrado = 'Secondaria di Primo Grado'
AND sc.id != '23'
AND sc.pubblicato = 2






ORDER BY sc.date DESC > ERROR > SELECT u.id AS u_id, u.name AS u_name,

c.cb_ordineegrado AS c_ordineegrado,
c.cb_nomeistituto AS c_nomeistituto, c.cb_city AS c_city, c.state AS c_state,

i.id AS i_id,
i.id_joomla AS i_id_j,
i.id_scuola1 AS i_id_s,

sc.id AS sc_id, sc.pubblicato AS sc_pubblicato, sc.date AS sc_date,
sc.img1 AS sc_img1, sc.titolo AS sc_titolo, sc.tema AS sc_tema,
sc.aree AS sc_aree, sc.descrizione AS sc_descrizione, sc.strumento AS sc_strumento

FROM jos_users AS u JOIN
cross_schede AS sc JOIN
jos_downloads_log AS d

WHERE sc.id_user = u.id AND
sc.id_file = '102180' AND
sc.id_classe = d.id

AND sc.pubblicato >= 1

AND c.cb_ordineegrado = 'Primaria'


AND sc.id = '23'



ORDER BY sc.date DESC > ERROR > SELECT u.id AS u_id, u.name AS u_name,

c.cb_ordineegrado AS c_ordineegrado,
c.cb_nomeistituto AS c_nomeistituto, c.cb_city AS c_city, c.state AS c_state,

i.id AS i_id,
i.id_joomla AS i_id_j,
i.id_scuola1 AS i_id_s,

sc.id AS sc_id, sc.pubblicato AS sc_pubblicato, sc.date AS sc_date,
sc.img1 AS sc_img1, sc.titolo AS sc_titolo, sc.tema AS sc_tema,
sc.aree AS sc_aree, sc.descrizione AS sc_descrizione, sc.strumento AS sc_strumento

FROM jos_users AS u JOIN
cross_schede AS sc JOIN
jos_downloads_log AS d

WHERE sc.id_user = u.id AND
sc.id_file = '102180' AND
sc.id_classe = d.id

AND sc.pubblicato >= 1

AND c.cb_ordineegrado = 'Secondaria di Primo Grado'


AND sc.id = '23'



ORDER BY sc.date DESC > ERROR > SELECT u.id AS u_id, u.name AS u_name,

c.cb_ordineegrado AS c_ordineegrado,
c.cb_nomeistituto AS c_nomeistituto, c.cb_city AS c_city, c.state AS c_state,

i.id AS i_id,
i.id_joomla AS i_id_j,
i.id_scuola1 AS i_id_s,

sc.id AS sc_id, sc.pubblicato AS sc_pubblicato, sc.date AS sc_date,
sc.img1 AS sc_img1, sc.titolo AS sc_titolo, sc.tema AS sc_tema,
sc.aree AS sc_aree, sc.descrizione AS sc_descrizione, sc.strumento AS sc_strumento

FROM jos_users AS u JOIN
cross_schede AS sc JOIN
jos_downloads_log AS d

WHERE sc.id_user = u.id AND
sc.id_file = '102180' AND
sc.id_classe = d.id

AND sc.pubblicato >= 1

AND c.cb_ordineegrado = 'Secondaria di Secondo Grado'


AND sc.id = '23'



ORDER BY sc.date DESC >