SELECT 
  w0_.ID AS ID_0, 
  w0_.post_name AS post_name_1, 
  w0_.post_title AS post_title_2, 
  w0_.post_content AS post_content_3, 
  w0_.post_excerpt AS post_excerpt_4, 
  w0_.post_date AS post_date_5, 
  w1_.meta_value AS meta_value_6, 
  w2_.meta_value AS meta_value_7, 
  w3_.meta_value AS meta_value_8, 
  l4_.titolo AS titolo_9, 
  l4_.slug AS slug_10 
FROM 
  lmn_geo l4_ 
  INNER JOIN lmn_geo l5_ ON l4_.regione_id = l5_.id, 
  wp_posts w0_ 
  INNER JOIN wp_postmeta w1_ ON w0_.ID = w1_.post_id 
  INNER JOIN wp_postmeta w2_ ON w0_.ID = w2_.post_id 
  INNER JOIN wp_postmeta w3_ ON w0_.ID = w3_.post_id 
WHERE 
  w0_.post_status = 'publish' 
  AND w1_.meta_key = 'data_inizio_evento' 
  AND w2_.meta_key = 'data_fine_evento' 
  AND w3_.meta_key = 'id_provincia_evento' 
  AND w3_.meta_value = l4_.id 
  AND l5_.url = ? 
  AND l5_.tipo = 2 
ORDER BY 
  w1_.meta_value DESC 
LIMIT 
  15 OFFSET 0

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

SELECT 
  DISTINCT w0_.ID AS ID_0, 
  w0_.post_name AS post_name_1, 
  w0_.post_title AS post_title_2, 
  w0_.post_excerpt AS post_excerpt_3, 
  w0_.post_content AS post_content_4, 
  w0_.post_date AS post_date_5, 
  w1_.meta_value AS meta_value_6, 
  w2_.meta_value AS meta_value_7, 
  w3_.meta_value AS meta_value_8, 
  l4_.titolo AS titolo_9, 
  l4_.url AS url_10, 
  w5_.meta_value AS meta_value_11, 
  l6_.titolo AS titolo_12 
FROM 
  wp_posts w0_ 
  LEFT JOIN wp_postmeta w7_ ON w0_.ID = w7_.post_id 
  AND (w7_.meta_key = 'thumb') 
  INNER JOIN wp_postmeta w1_ ON w0_.ID = w1_.post_id 
  AND (
    w1_.meta_key = 'data_inizio_evento'
  ) 
  INNER JOIN wp_postmeta w2_ ON w0_.ID = w2_.post_id 
  AND (
    w2_.meta_key = 'data_fine_evento'
  ) 
  INNER JOIN wp_postmeta w8_ ON w0_.ID = w8_.post_id 
  AND (
    w8_.meta_key = 'is_evento' 
    AND w8_.meta_value = 1
  ) 
  INNER JOIN wp_postmeta w3_ ON w0_.ID = w3_.post_id 
  AND (
    w3_.meta_key = 'id_provincia_evento'
  ) 
  LEFT JOIN lmn_geo l4_ ON (l4_.id = w3_.meta_value) 
  INNER JOIN wp_postmeta w5_ ON w0_.ID = w5_.post_id 
  AND (w5_.meta_key = 'id_geo_evento') 
  LEFT JOIN lmn_geo l6_ ON (l6_.id = w5_.meta_value) 
WHERE 
  w0_.post_status = ? 
  AND w2_.meta_value >= ? 
ORDER BY 
  w1_.meta_value ASC 
LIMIT 
  100 OFFSET 0

SELECT 
  count(l0_.id) AS sclr_0 
FROM 
  lmn_vetrina l0_ 
WHERE 
  l0_.pubblico = 1

SELECT 
  DISTINCT w0_.ID AS ID_0, 
  w0_.post_name AS post_name_1, 
  w0_.post_title AS post_title_2, 
  w0_.post_date AS post_date_3, 
  w0_.post_excerpt AS post_excerpt_4, 
  w1_.meta_value AS meta_value_5 
FROM 
  wp_posts w0_ 
  INNER JOIN wp_postmeta w1_ ON w0_.ID = w1_.post_id 
  AND (w1_.meta_key = 'thumb') 
  INNER JOIN wp_postmeta w2_ ON w0_.ID = w2_.post_id 
  AND (
    w2_.meta_key = 'is_news' 
    AND w2_.meta_value = 1
  ) 
  INNER JOIN wp_postmeta w3_ ON w0_.ID = w3_.post_id 
  AND (
    w3_.meta_key = 'sticky_hp' 
    AND w3_.meta_value = 1
  ) 
WHERE 
  w0_.post_status = ? 
ORDER BY 
  w0_.post_date DESC 
LIMIT 
  1

SELECT 
  l0_.id AS id_0 
FROM 
  lmn_vetrina_top l1_ 
  INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id 
  INNER JOIN lmn_sezione_topposition_rel l3_ ON l1_.id = l3_.vetrinatop_id 
  INNER JOIN lmn_sezione l2_ ON l2_.id = l3_.sezione_id 
WHERE 
  l2_.slug = ? 
  AND l1_.data_inizio < ? 
  AND l1_.data_fine > ? 
  AND l0_.pubblico = 1 
ORDER BY 
  l1_.posizione ASC

SELECT 
  DISTINCT l0_.id AS id_0 
FROM 
  lmn_vetrina_recapito l1_ 
  INNER JOIN lmn_vetrina l0_ ON l1_.vetrina_id = l0_.id 
  INNER JOIN lmn_geo l2_ ON l1_.geo_id = l2_.id 
  INNER JOIN lmn_geo l3_ ON l2_.provincia_id = l3_.id 
  INNER JOIN lmn_vetrina_categoria_rel l5_ ON l0_.id = l5_.vetrina_id 
  INNER JOIN lmn_categoria l4_ ON l4_.id = l5_.categoria_id 
  INNER JOIN lmn_media_foto l6_ ON l0_.boximage_id = l6_.id 
WHERE 
  l0_.pubblico = 1 
  AND l6_.id > 0 
  AND l0_.listing_id IS NULL 
  AND l0_.updated_at > ?

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 l0_.geo_id = 10399 
ORDER BY 
  l0_.id DESC

SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.premium AS premium_2, 
  l0_.slug AS slug_3, 
  l0_.titolo AS titolo_4, 
  l0_.h1 AS h1_5, 
  l0_.descrizione AS descrizione_6, 
  l1_.id AS id_7, 
  l2_.id AS id_8, 
  l2_.tipo AS tipo_9, 
  l2_.url AS url_10, 
  l2_.titolo AS titolo_11, 
  l2_.h1 AS h1_12, 
  l3_.id AS id_13, 
  l3_.tipo AS tipo_14, 
  l3_.url AS url_15, 
  l3_.titolo AS titolo_16, 
  l3_.h1 AS h1_17, 
  l4_.id AS id_18, 
  l5_.id AS id_19, 
  l5_.titolo AS titolo_20, 
  l6_.id AS id_21, 
  l6_.titolo AS titolo_22, 
  l7_.id AS id_23, 
  l7_.attivo AS attivo_24, 
  l8_.id AS id_25, 
  l8_.tipo AS tipo_26, 
  l9_.id AS id_27, 
  l9_.slug AS slug_28, 
  l9_.titolo AS titolo_29, 
  l9_.h1 AS h1_30, 
  l10_.id AS id_31, 
  l10_.titolo AS titolo_32, 
  l11_.id AS id_33, 
  l11_.tipo AS tipo_34, 
  l11_.url AS url_35, 
  l11_.titolo AS titolo_36, 
  l11_.h1 AS h1_37, 
  l12_.id AS id_38, 
  l12_.name AS name_39, 
  l13_.id AS id_40, 
  l13_.name AS name_41 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_vetrina_recapito l1_ ON l0_.recapito_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l1_.geo_id = l2_.id 
  INNER JOIN lmn_geo l3_ ON l2_.provincia_id = l3_.id 
  LEFT JOIN lmn_vetrina_recapito l4_ ON l0_.id = l4_.vetrina_id 
  LEFT JOIN lmn_geo l5_ ON l4_.geo_id = l5_.id 
  INNER JOIN lmn_geo l6_ ON l5_.provincia_id = l6_.id 
  LEFT JOIN lmn_premiums_vetrina l7_ ON l0_.listing_id = l7_.id 
  LEFT JOIN lmn_vetrina_tipi l8_ ON l0_.vetrina_tipo_id = l8_.id 
  INNER JOIN lmn_categoria l9_ ON l0_.categoria_id = l9_.id 
  LEFT JOIN lmn_vetrina_geo_rel l14_ ON l0_.id = l14_.vetrina_id 
  LEFT JOIN lmn_geo l10_ ON l10_.id = l14_.geo_id 
  INNER JOIN lmn_geo l11_ ON l0_.geo_id = l11_.id 
  LEFT JOIN lmn_media_foto l12_ ON l0_.boximage_id = l12_.id 
  LEFT JOIN lmn_media_foto l13_ ON l0_.copertina_id = l13_.id 
WHERE 
  l0_.id = ? 
ORDER BY 
  l10_.titolo ASC

SELECT 
  l0_.id AS id_0, 
  l0_.url_scheda AS url_scheda_1, 
  l0_.premium AS premium_2, 
  l0_.slug AS slug_3, 
  l0_.titolo AS titolo_4, 
  l0_.h1 AS h1_5, 
  l0_.descrizione AS descrizione_6, 
  l1_.id AS id_7, 
  l2_.id AS id_8, 
  l2_.tipo AS tipo_9, 
  l2_.url AS url_10, 
  l2_.titolo AS titolo_11, 
  l2_.h1 AS h1_12, 
  l3_.id AS id_13, 
  l3_.tipo AS tipo_14, 
  l3_.url AS url_15, 
  l3_.titolo AS titolo_16, 
  l3_.h1 AS h1_17, 
  l4_.id AS id_18, 
  l5_.id AS id_19, 
  l5_.titolo AS titolo_20, 
  l6_.id AS id_21, 
  l6_.titolo AS titolo_22, 
  l7_.id AS id_23, 
  l7_.attivo AS attivo_24, 
  l8_.id AS id_25, 
  l8_.tipo AS tipo_26, 
  l9_.id AS id_27, 
  l9_.slug AS slug_28, 
  l9_.titolo AS titolo_29, 
  l9_.h1 AS h1_30, 
  l10_.id AS id_31, 
  l10_.titolo AS titolo_32, 
  l11_.id AS id_33, 
  l11_.tipo AS tipo_34, 
  l11_.url AS url_35, 
  l11_.titolo AS titolo_36, 
  l11_.h1 AS h1_37, 
  l12_.id AS id_38, 
  l12_.name AS name_39, 
  l13_.id AS id_40, 
  l13_.name AS name_41 
FROM 
  lmn_vetrina l0_ 
  LEFT JOIN lmn_vetrina_recapito l1_ ON l0_.recapito_id = l1_.id 
  LEFT JOIN lmn_geo l2_ ON l1_.geo_id = l2_.id 
  INNER JOIN lmn_geo l3_ ON l2_.provincia_id = l3_.id 
  LEFT JOIN lmn_vetrina_recapito l4_ ON l0_.id = l4_.vetrina_id 
  LEFT JOIN lmn_geo l5_ ON l4_.geo_id = l5_.id 
  INNER JOIN lmn_geo l6_ ON l5_.provincia_id = l6_.id 
  LEFT JOIN lmn_premiums_vetrina l7_ ON l0_.listing_id = l7_.id 
  LEFT JOIN lmn_vetrina_tipi l8_ ON l0_.vetrina_tipo_id = l8_.id 
  INNER JOIN lmn_categoria l9_ ON l0_.categoria_id = l9_.id 
  LEFT JOIN lmn_vetrina_geo_rel l14_ ON l0_.id = l14_.vetrina_id 
  LEFT JOIN lmn_geo l10_ ON l10_.id = l14_.geo_id 
  INNER JOIN lmn_geo l11_ ON l0_.geo_id = l11_.id 
  LEFT JOIN lmn_media_foto l12_ ON l0_.boximage_id = l12_.id 
  LEFT JOIN lmn_media_foto l13_ ON l0_.copertina_id = l13_.id 
WHERE 
  l0_.id = ? 
ORDER BY 
  l10_.titolo ASC