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 
  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 l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )

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 l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )

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 l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )