SELECT 
  t0.id AS id_1, 
  t0.created_by AS created_by_2, 
  t0.updated_by AS updated_by_3, 
  t0.url_scheda AS url_scheda_4, 
  t0.stato AS stato_5, 
  t0.email AS email_6, 
  t0.premium AS premium_7, 
  t0.testo AS testo_8, 
  t0.info_recapito AS info_recapito_9, 
  t0.fattura AS fattura_10, 
  t0.edit AS edit_11, 
  t0.website AS website_12, 
  t0.data_attivazione AS data_attivazione_13, 
  t0.stat_user AS stat_user_14, 
  t0.stat_pwd AS stat_pwd_15, 
  t0.preview AS preview_16, 
  t0.nuovo AS nuovo_17, 
  t0.no_rinnovo AS no_rinnovo_18, 
  t0.ritardo_pagamento AS ritardo_pagamento_19, 
  t0.data_pubblicazione AS data_pubblicazione_20, 
  t0.scadenza AS scadenza_21, 
  t0.link_scambio AS link_scambio_22, 
  t0.link_url AS link_url_23, 
  t0.link_checked AS link_checked_24, 
  t0.vetrina_tipo_id AS vetrina_tipo_id_25, 
  t0.data_conferma AS data_conferma_26, 
  t0.slug AS slug_27, 
  t0.pubblico AS pubblico_28, 
  t0.titolo AS titolo_29, 
  t0.h1 AS h1_30, 
  t0.h2 AS h2_31, 
  t0.meta_title AS meta_title_32, 
  t0.meta_keyword AS meta_keyword_33, 
  t0.meta_description AS meta_description_34, 
  t0.descrizione AS descrizione_35, 
  t0.created_at AS created_at_36, 
  t0.updated_at AS updated_at_37, 
  t0.categoria_id AS categoria_id_38, 
  t0.geo_id AS geo_id_39, 
  t0.cliente_id AS cliente_id_40, 
  t0.recapito_id AS recapito_id_41, 
  t0.listing_id AS listing_id_42, 
  t0.boximage_id AS boximage_id_43, 
  t0.logo_id AS logo_id_44, 
  t0.vetrina_tipo_id AS vetrina_tipo_id_45, 
  t0.copertina_id AS copertina_id_46 
FROM 
  lmn_vetrina t0 
WHERE 
  t0.url_scheda = ?

SELECT 
  l0_.id AS id_0, 
  l0_.created_by AS created_by_1, 
  l0_.updated_by AS updated_by_2, 
  l0_.url_scheda AS url_scheda_3, 
  l0_.stato AS stato_4, 
  l0_.email AS email_5, 
  l0_.premium AS premium_6, 
  l0_.testo AS testo_7, 
  l0_.info_recapito AS info_recapito_8, 
  l0_.fattura AS fattura_9, 
  l0_.edit AS edit_10, 
  l0_.website AS website_11, 
  l0_.data_attivazione AS data_attivazione_12, 
  l0_.stat_user AS stat_user_13, 
  l0_.stat_pwd AS stat_pwd_14, 
  l0_.preview AS preview_15, 
  l0_.nuovo AS nuovo_16, 
  l0_.no_rinnovo AS no_rinnovo_17, 
  l0_.ritardo_pagamento AS ritardo_pagamento_18, 
  l0_.data_pubblicazione AS data_pubblicazione_19, 
  l0_.scadenza AS scadenza_20, 
  l0_.link_scambio AS link_scambio_21, 
  l0_.link_url AS link_url_22, 
  l0_.link_checked AS link_checked_23, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_24, 
  l0_.data_conferma AS data_conferma_25, 
  l0_.slug AS slug_26, 
  l0_.pubblico AS pubblico_27, 
  l0_.titolo AS titolo_28, 
  l0_.h1 AS h1_29, 
  l0_.h2 AS h2_30, 
  l0_.meta_title AS meta_title_31, 
  l0_.meta_keyword AS meta_keyword_32, 
  l0_.meta_description AS meta_description_33, 
  l0_.descrizione AS descrizione_34, 
  l0_.created_at AS created_at_35, 
  l0_.updated_at AS updated_at_36, 
  l1_.id AS id_37, 
  l1_.old_id AS old_id_38, 
  l1_.limitrofi AS limitrofi_39, 
  l1_.lft AS lft_40, 
  l1_.lvl AS lvl_41, 
  l1_.rgt AS rgt_42, 
  l1_.root AS root_43, 
  l1_.slug AS slug_44, 
  l1_.pubblico AS pubblico_45, 
  l1_.titolo AS titolo_46, 
  l1_.h1 AS h1_47, 
  l1_.h2 AS h2_48, 
  l1_.meta_title AS meta_title_49, 
  l1_.meta_keyword AS meta_keyword_50, 
  l1_.meta_description AS meta_description_51, 
  l1_.descrizione AS descrizione_52, 
  l1_.testo AS testo_53, 
  l1_.created_at AS created_at_54, 
  l1_.updated_at AS updated_at_55, 
  l2_.id AS id_56, 
  l2_.tipo AS tipo_57, 
  l2_.lat AS lat_58, 
  l2_.lon AS lon_59, 
  l2_.old_id AS old_id_60, 
  l2_.url AS url_61, 
  l2_.main AS main_62, 
  l2_.slug AS slug_63, 
  l2_.pubblico AS pubblico_64, 
  l2_.titolo AS titolo_65, 
  l2_.h1 AS h1_66, 
  l2_.h2 AS h2_67, 
  l2_.meta_title AS meta_title_68, 
  l2_.meta_keyword AS meta_keyword_69, 
  l2_.meta_description AS meta_description_70, 
  l2_.descrizione AS descrizione_71, 
  l2_.testo AS testo_72, 
  l2_.created_at AS created_at_73, 
  l2_.updated_at AS updated_at_74, 
  l0_.categoria_id AS categoria_id_75, 
  l0_.geo_id AS geo_id_76, 
  l0_.cliente_id AS cliente_id_77, 
  l0_.recapito_id AS recapito_id_78, 
  l0_.listing_id AS listing_id_79, 
  l0_.boximage_id AS boximage_id_80, 
  l0_.logo_id AS logo_id_81, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_82, 
  l0_.copertina_id AS copertina_id_83, 
  l1_.padre_id AS padre_id_84, 
  l1_.copertina_id AS copertina_id_85, 
  l2_.regione_id AS regione_id_86, 
  l2_.provincia_id AS provincia_id_87, 
  l2_.copertina_id AS copertina_id_88 
FROM 
  lmn_vetrina l0_ 
  INNER JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  INNER JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l0_.url_scheda = ? 
  AND l1_.slug = ?

SELECT 
  t0.id AS id_1, 
  t0.pubblico AS pubblico_2, 
  t0.height AS height_3, 
  t0.width AS width_4, 
  t0.mime AS mime_5, 
  t0.size AS size_6, 
  t0.created_at AS created_at_7, 
  t0.updated_at AS updated_at_8, 
  t0.titolo AS titolo_9, 
  t0.name AS name_10, 
  t0.path AS path_11, 
  t0.old_id AS old_id_12, 
  t0.posizione AS posizione_13, 
  t0.album_id AS album_id_14 
FROM 
  lmn_media_foto t0 
  INNER JOIN lmn_vetrina_foto_rel ON t0.id = lmn_vetrina_foto_rel.mediafoto_id 
WHERE 
  lmn_vetrina_foto_rel.vetrina_id = ? 
ORDER BY 
  t0.posizione ASC

SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  ) 
  AND l0_.quantity > l0_.used

SELECT 
  l0_.id AS id_0, 
  l0_.pubblico AS pubblico_1, 
  l0_.height AS height_2, 
  l0_.width AS width_3, 
  l0_.mime AS mime_4, 
  l0_.size AS size_5, 
  l0_.created_at AS created_at_6, 
  l0_.updated_at AS updated_at_7, 
  l0_.titolo AS titolo_8, 
  l0_.name AS name_9, 
  l0_.path AS path_10, 
  l0_.old_id AS old_id_11, 
  l0_.posizione AS posizione_12 
FROM 
  lmn_media_foto l0_ 
  INNER JOIN lmn_vetrina_foto_rel l2_ ON l0_.id = l2_.mediafoto_id 
  INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id 
WHERE 
  l1_.id = ? 
  AND l0_.pubblico = ? 
ORDER BY 
  l0_.posizione ASC 
LIMIT 
  12 OFFSET 0

SELECT 
  count(l0_.id) AS sclr_0 
FROM 
  lmn_media_foto l0_ 
  INNER JOIN lmn_vetrina_foto_rel l2_ ON l0_.id = l2_.mediafoto_id 
  INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id 
WHERE 
  l1_.id = ? 
  AND l0_.pubblico = 1