SELECT 
  l0_.id AS id_0, 
  l0_.old_id AS old_id_1, 
  l0_.limitrofi AS limitrofi_2, 
  l0_.lft AS lft_3, 
  l0_.lvl AS lvl_4, 
  l0_.rgt AS rgt_5, 
  l0_.root AS root_6, 
  l0_.slug AS slug_7, 
  l0_.pubblico AS pubblico_8, 
  l0_.titolo AS titolo_9, 
  l0_.h1 AS h1_10, 
  l0_.h2 AS h2_11, 
  l0_.meta_title AS meta_title_12, 
  l0_.meta_keyword AS meta_keyword_13, 
  l0_.meta_description AS meta_description_14, 
  l0_.descrizione AS descrizione_15, 
  l0_.testo AS testo_16, 
  l0_.created_at AS created_at_17, 
  l0_.updated_at AS updated_at_18, 
  l1_.id AS id_19, 
  l1_.old_id AS old_id_20, 
  l1_.limitrofi AS limitrofi_21, 
  l1_.lft AS lft_22, 
  l1_.lvl AS lvl_23, 
  l1_.rgt AS rgt_24, 
  l1_.root AS root_25, 
  l1_.slug AS slug_26, 
  l1_.pubblico AS pubblico_27, 
  l1_.titolo AS titolo_28, 
  l1_.h1 AS h1_29, 
  l1_.h2 AS h2_30, 
  l1_.meta_title AS meta_title_31, 
  l1_.meta_keyword AS meta_keyword_32, 
  l1_.meta_description AS meta_description_33, 
  l1_.descrizione AS descrizione_34, 
  l1_.testo AS testo_35, 
  l1_.created_at AS created_at_36, 
  l1_.updated_at AS updated_at_37, 
  l0_.padre_id AS padre_id_38, 
  l0_.copertina_id AS copertina_id_39, 
  l1_.padre_id AS padre_id_40, 
  l1_.copertina_id AS copertina_id_41 
FROM 
  lmn_categoria l0_ 
  LEFT JOIN lmn_categoria l1_ ON l0_.padre_id = l1_.id 
WHERE 
  l0_.slug = ?

SELECT 
  DISTINCT (l0_.id) AS sclr_0 
FROM 
  lmn_vetrina l0_ 
  INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id 
  INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id 
  LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id 
WHERE 
  l0_.pubblico = 1 
  AND l3_.tipo IN (2, 3) 
  AND l1_.id = ? 
ORDER BY 
  l0_.id DESC

SELECT 
  DISTINCT (l0_.id) AS sclr_0 
FROM 
  lmn_vetrina l0_ 
  INNER JOIN lmn_vetrina_categoria_rel l2_ ON l0_.id = l2_.vetrina_id 
  INNER JOIN lmn_categoria l1_ ON l1_.id = l2_.categoria_id 
  LEFT JOIN lmn_vetrina_tipi l3_ ON l0_.vetrina_tipo_id = l3_.id 
WHERE 
  l0_.pubblico = 1 
  AND l3_.tipo NOT IN (2, 3) 
  AND l1_.id = ? 
  AND l0_.updated_at < ? 
ORDER BY 
  l0_.id DESC

SELECT 
  l0_.id AS id_0, 
  l0_.countdown AS countdown_1, 
  l0_.lft AS lft_2, 
  l0_.lvl AS lvl_3, 
  l0_.rgt AS rgt_4, 
  l0_.root AS root_5, 
  l0_.box_categorie_operatori AS box_categorie_operatori_6, 
  l0_.titolo_breve AS titolo_breve_7, 
  l0_.slug AS slug_8, 
  l0_.pubblico AS pubblico_9, 
  l0_.titolo AS titolo_10, 
  l0_.h1 AS h1_11, 
  l0_.h2 AS h2_12, 
  l0_.meta_title AS meta_title_13, 
  l0_.meta_keyword AS meta_keyword_14, 
  l0_.meta_description AS meta_description_15, 
  l0_.descrizione AS descrizione_16, 
  l0_.testo AS testo_17, 
  l0_.created_at AS created_at_18, 
  l0_.updated_at AS updated_at_19, 
  l0_.padre_id AS padre_id_20, 
  l0_.categoria_id AS categoria_id_21, 
  l0_.geo_id AS geo_id_22, 
  l0_.newsTag_id AS newsTag_id_23, 
  l0_.forumTag_id AS forumTag_id_24, 
  l0_.copertina_id AS copertina_id_25 
FROM 
  lmn_organizzazione_categoria l0_ 
WHERE 
  l0_.padre_id = ? 
ORDER BY 
  l0_.titolo ASC

SELECT 
  l0_.id AS id_0, 
  l0_.titolo_breve AS titolo_breve_1, 
  l0_.testoOM AS testoOM_2, 
  l0_.col_sx AS col_sx_3, 
  l0_.slug AS slug_4, 
  l0_.pubblico AS pubblico_5, 
  l0_.titolo AS titolo_6, 
  l0_.h1 AS h1_7, 
  l0_.h2 AS h2_8, 
  l0_.meta_title AS meta_title_9, 
  l0_.meta_keyword AS meta_keyword_10, 
  l0_.meta_description AS meta_description_11, 
  l0_.descrizione AS descrizione_12, 
  l0_.testo AS testo_13, 
  l0_.created_at AS created_at_14, 
  l0_.updated_at AS updated_at_15, 
  l0_.categoria_id AS categoria_id_16, 
  l0_.categoriaOM_id AS categoriaOM_id_17, 
  l0_.copertina_id AS copertina_id_18 
FROM 
  lmn_gallery l0_ 
WHERE 
  l0_.pubblico = 1 
ORDER BY 
  l0_.titolo ASC