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