Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.creato AS creato_2,
  t0.modificato AS modificato_3,
  t0.username AS username_4,
  t0.password AS password_5,
  t0.email AS email_6,
  t0.token AS token_7,
  t0.token_creato AS token_creato_8,
  t0.prelogin AS prelogin_9,
  t0.prelogin_creato AS prelogin_creato_10,
  t0.abilitato AS abilitato_11,
  t0.spid AS spid_12,
  t0.ultimo_accesso AS ultimo_accesso_13,
  t0.otp AS otp_14,
  t0.ultimo_otp AS ultimo_otp_15,
  t0.dispositivo AS dispositivo_16,
  t0.nome AS nome_17,
  t0.cognome AS cognome_18,
  t0.sesso AS sesso_19,
  t0.data_nascita AS data_nascita_20,
  t0.comune_nascita AS comune_nascita_21,
  t0.provincia_nascita AS provincia_nascita_22,
  t0.codice_fiscale AS codice_fiscale_23,
  t0.citta AS citta_24,
  t0.provincia AS provincia_25,
  t0.indirizzo AS indirizzo_26,
  t0.numeri_telefono AS numeri_telefono_27,
  t0.notifica AS notifica_28,
  t0.rappresentante AS rappresentante_29,
  t0.dati AS dati_30,
  t0.ruolo,
  t0.tipo AS tipo_31,
  t0.segreteria AS segreteria_32,
  t0.sede_id AS sede_id_33,
  t0.responsabile_bes AS responsabile_bes_34,
  t0.rspp AS rspp_35,
  t0.responsabile_bes_sede_id AS responsabile_bes_sede_id_36,
  t0.sede_id AS sede_id_37,
  t0.bes AS bes_38,
  t0.note_bes AS note_bes_39,
  t0.autorizza_entrata AS autorizza_entrata_40,
  t0.autorizza_uscita AS autorizza_uscita_41,
  t0.note AS note_42,
  t0.frequenza_estero AS frequenza_estero_43,
  t0.religione AS religione_44,
  t0.credito3 AS credito3_45,
  t0.credito4 AS credito4_46,
  t0.giustifica_online AS giustifica_online_47,
  t0.richiesta_certificato AS richiesta_certificato_48,
  t0.foto AS foto_49,
  t0.classe_id AS classe_id_50,
  t0.giustifica_online AS giustifica_online_51,
  t0.alunno_id AS alunno_id_52
FROM
  gs_utente t0
WHERE
  t0.id = ?
  AND t0.ruolo IN (
    'UTE', 'AMM', 'ATA', 'DOC', 'STA', 'PRE',
    'ALU', 'GEN'
  )

SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.username AS username_4, t0.password AS password_5, t0.email AS email_6, t0.token AS token_7, t0.token_creato AS token_creato_8, t0.prelogin AS prelogin_9, t0.prelogin_creato AS prelogin_creato_10, t0.abilitato AS abilitato_11, t0.spid AS spid_12, t0.ultimo_accesso AS ultimo_accesso_13, t0.otp AS otp_14, t0.ultimo_otp AS ultimo_otp_15, t0.dispositivo AS dispositivo_16, t0.nome AS nome_17, t0.cognome AS cognome_18, t0.sesso AS sesso_19, t0.data_nascita AS data_nascita_20, t0.comune_nascita AS comune_nascita_21, t0.provincia_nascita AS provincia_nascita_22, t0.codice_fiscale AS codice_fiscale_23, t0.citta AS citta_24, t0.provincia AS provincia_25, t0.indirizzo AS indirizzo_26, t0.numeri_telefono AS numeri_telefono_27, t0.notifica AS notifica_28, t0.rappresentante AS rappresentante_29, t0.dati AS dati_30, t0.ruolo, t0.tipo AS tipo_31, t0.segreteria AS segreteria_32, t0.sede_id AS sede_id_33, t0.responsabile_bes AS responsabile_bes_34, t0.rspp AS rspp_35, t0.responsabile_bes_sede_id AS responsabile_bes_sede_id_36, t0.sede_id AS sede_id_37, t0.bes AS bes_38, t0.note_bes AS note_bes_39, t0.autorizza_entrata AS autorizza_entrata_40, t0.autorizza_uscita AS autorizza_uscita_41, t0.note AS note_42, t0.frequenza_estero AS frequenza_estero_43, t0.religione AS religione_44, t0.credito3 AS credito3_45, t0.credito4 AS credito4_46, t0.giustifica_online AS giustifica_online_47, t0.richiesta_certificato AS richiesta_certificato_48, t0.foto AS foto_49, t0.classe_id AS classe_id_50, t0.giustifica_online AS giustifica_online_51, t0.alunno_id AS alunno_id_52 FROM gs_utente t0 WHERE t0.id = 9 AND t0.ruolo IN ('UTE', 'AMM', 'ATA', 'DOC', 'STA', 'PRE', 'ALU', 'GEN');

SELECT
  g0_.categoria AS categoria_0,
  g0_.parametro AS parametro_1,
  g0_.valore AS valore_2
FROM
  gs_configurazione g0_

SELECT g0_.categoria AS categoria_0, g0_.parametro AS parametro_1, g0_.valore AS valore_2 FROM gs_configurazione g0_;

SELECT
  t0.id AS id_1,
  t0.creato AS creato_2,
  t0.modificato AS modificato_3,
  t0.tipo AS tipo_4,
  t0.tipo_sigla AS tipo_sigla_5,
  t0.nome AS nome_6,
  t0.nome_breve AS nome_breve_7,
  t0.email AS email_8,
  t0.pec AS pec_9,
  t0.url_sito AS url_sito_10,
  t0.url_registro AS url_registro_11,
  t0.firma_preside AS firma_preside_12,
  t0.email_amministratore AS email_amministratore_13,
  t0.email_notifiche AS email_notifiche_14
FROM
  gs_istituto t0

SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.tipo AS tipo_4, t0.tipo_sigla AS tipo_sigla_5, t0.nome AS nome_6, t0.nome_breve AS nome_breve_7, t0.email AS email_8, t0.pec AS pec_9, t0.url_sito AS url_sito_10, t0.url_registro AS url_registro_11, t0.firma_preside AS firma_preside_12, t0.email_amministratore AS email_amministratore_13, t0.email_notifiche AS email_notifiche_14 FROM gs_istituto t0;

SELECT
  g0_.nome AS nome_0,
  g0_.nome_breve AS nome_breve_1,
  g0_.citta AS citta_2,
  g0_.indirizzo1 AS indirizzo1_3,
  g0_.indirizzo2 AS indirizzo2_4,
  g0_.telefono AS telefono_5
FROM
  gs_sede g0_
ORDER BY
  g0_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.nome_breve AS nome_breve_1, g0_.citta AS citta_2, g0_.indirizzo1 AS indirizzo1_3, g0_.indirizzo2 AS indirizzo2_4, g0_.telefono AS telefono_5 FROM gs_sede g0_ ORDER BY g0_.ordinamento ASC;

SELECT
  g0_.selettore AS selettore_0,
  g0_.nome AS nome_1,
  g0_.descrizione AS descrizione_2
FROM
  gs_menu g0_

SELECT g0_.selettore AS selettore_0, g0_.nome AS nome_1, g0_.descrizione AS descrizione_2 FROM gs_menu g0_;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'help' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'user' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'info' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'main' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'sistema' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'scuola' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'ata' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'docenti' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'alunni' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.id AS id_0
FROM
  gs_classe g0_
WHERE
  g0_.coordinatore_id = ?

SELECT g0_.id AS id_0 FROM gs_classe g0_ WHERE g0_.coordinatore_id = 9;

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_richiesta_colloquio g0_
  INNER JOIN gs_colloquio g1_ ON g0_.colloquio_id = g1_.id
WHERE
  g0_.stato = ?
  AND g1_.docente_id = ?
  AND g1_.abilitato = ?
  AND g1_.data >= ?

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_richiesta_colloquio g0_ INNER JOIN gs_colloquio g1_ ON g0_.colloquio_id = g1_.id WHERE g0_.stato = 'R' AND g1_.docente_id = 9 AND g1_.abilitato = 1 AND g1_.data >= '2026-06-10';

SELECT
  g0_.appuntamento AS appuntamento_0,
  g0_.messaggio AS messaggio_1,
  g1_.tipo AS tipo_2,
  g1_.data AS data_3,
  g1_.luogo AS luogo_4,
  g2_.nome AS nome_5,
  g2_.cognome AS cognome_6,
  g2_.sesso AS sesso_7,
  g2_.data_nascita AS data_nascita_8,
  g3_.anno AS anno_9,
  g3_.sezione AS sezione_10,
  g3_.gruppo AS gruppo_11
FROM
  gs_richiesta_colloquio g0_
  INNER JOIN gs_utente g2_ ON g0_.alunno_id = g2_.id
  AND g2_.ruolo IN ('ALU')
  INNER JOIN gs_classe g3_ ON g2_.classe_id = g3_.id
  INNER JOIN gs_colloquio g1_ ON g0_.colloquio_id = g1_.id
WHERE
  g0_.stato = ?
  AND g1_.docente_id = ?
  AND g1_.abilitato = ?
  AND g1_.data BETWEEN ?
  AND ?
ORDER BY
  g1_.data ASC,
  g0_.appuntamento ASC

SELECT g0_.appuntamento AS appuntamento_0, g0_.messaggio AS messaggio_1, g1_.tipo AS tipo_2, g1_.data AS data_3, g1_.luogo AS luogo_4, g2_.nome AS nome_5, g2_.cognome AS cognome_6, g2_.sesso AS sesso_7, g2_.data_nascita AS data_nascita_8, g3_.anno AS anno_9, g3_.sezione AS sezione_10, g3_.gruppo AS gruppo_11 FROM gs_richiesta_colloquio g0_ INNER JOIN gs_utente g2_ ON g0_.alunno_id = g2_.id AND g2_.ruolo IN ('ALU') INNER JOIN gs_classe g3_ ON g2_.classe_id = g3_.id INNER JOIN gs_colloquio g1_ ON g0_.colloquio_id = g1_.id WHERE g0_.stato = 'C' AND g1_.docente_id = 9 AND g1_.abilitato = 1 AND g1_.data BETWEEN '2026-06-10' AND '2026-06-13' ORDER BY g1_.data ASC, g0_.appuntamento ASC;

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
  INNER JOIN gs_comunicazione_utente g1_ ON (g1_.comunicazione_id = g0_.id)
WHERE
  (
    g1_.utente_id = ?
    AND g1_.letto IS NULL
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ INNER JOIN gs_comunicazione_utente g1_ ON (g1_.comunicazione_id = g0_.id) WHERE (g1_.utente_id = 9 AND g1_.letto IS NULL) AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione_utente g0_
  INNER JOIN gs_comunicazione g1_ ON (
    g0_.comunicazione_id = g1_.id
    AND g0_.utente_id = ?
  )
  AND g1_.categoria IN ('C')
WHERE
  g0_.letto IS NULL
  AND g1_.stato = 'P'

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione_utente g0_ INNER JOIN gs_comunicazione g1_ ON (g0_.comunicazione_id = g1_.id AND g0_.utente_id = 9) AND g1_.categoria IN ('C') WHERE g0_.letto IS NULL AND g1_.stato = 'P';

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
WHERE
  (
    g0_.tipo = ?
    AND g0_.autore_id = ?
    AND g0_.data = ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ WHERE (g0_.tipo = 'V' AND g0_.autore_id = 9 AND g0_.data = '2026-06-10') AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
  INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id
  INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id)
  INNER JOIN gs_cattedra g3_ ON (
    g3_.classe_id = g1_.classe_id
    AND g3_.docente_id = ?
    AND g3_.alunno_id = g2_.utente_id
  )
WHERE
  (
    g0_.autore_id <> ?
    AND g0_.tipo = ?
    AND g0_.data = ?
    AND g3_.attiva = ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id) INNER JOIN gs_cattedra g3_ ON (g3_.classe_id = g1_.classe_id AND g3_.docente_id = 9 AND g3_.alunno_id = g2_.utente_id) WHERE (g0_.autore_id <> 9 AND g0_.tipo = 'V' AND g0_.data = '2026-06-10' AND g3_.attiva = 1) AND g0_.categoria IN ('A');