Symfony Profiler

SELECT
  COUNT(DISTINCT r0_.id) AS sclr_0
FROM
  real_estate r0_
  INNER JOIN real_estate_search_facet r1_ ON (r1_.real_estate_id = r0_.id)
  INNER JOIN search_facet s2_ ON r1_.facet_id = s2_.id
  INNER JOIN real_estate_search_facet r3_ ON (r3_.real_estate_id = r0_.id)
  INNER JOIN search_facet s4_ ON r3_.facet_id = s4_.id
WHERE
  r0_.status = ?
  AND s2_.slug = ?
  AND r1_.charvalue = ?
  AND s4_.slug = ?
  AND r3_.charvalue = ?

SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM real_estate r0_ INNER JOIN real_estate_search_facet r1_ ON (r1_.real_estate_id = r0_.id) INNER JOIN search_facet s2_ ON r1_.facet_id = s2_.id INNER JOIN real_estate_search_facet r3_ ON (r3_.real_estate_id = r0_.id) INNER JOIN search_facet s4_ ON r3_.facet_id = s4_.id WHERE r0_.status = 'publish' AND s2_.slug = 'contract-type' AND r1_.charvalue = 'rental' AND s4_.slug = 'rooms' AND r3_.charvalue = '1';

SELECT
  r0_.id AS id_0,
  r0_.internal AS internal_1,
  r0_.reference AS reference_2,
  r0_.type AS type_3,
  r0_.category AS category_4,
  r0_.contract AS contract_5,
  r0_.status AS status_6,
  r0_.title AS title_7,
  r0_.description AS description_8,
  r0_.slug AS slug_9,
  r0_.virtual_tour AS virtual_tour_10,
  r0_.images AS images_11,
  r0_.available_at AS available_at_12,
  r1_.id AS id_13,
  r1_.visible AS visible_14,
  r1_.street AS street_15,
  r1_.zipcode AS zipcode_16,
  r1_.city AS city_17,
  r1_.borough AS borough_18,
  r1_.latitude AS latitude_19,
  r1_.longitude AS longitude_20,
  r2_.id AS id_21,
  r2_.building_year AS building_year_22,
  r2_.energy_grade AS energy_grade_23,
  r2_.energy_consumption AS energy_consumption_24,
  r2_.energy_cost_min AS energy_cost_min_25,
  r2_.energy_cost_max AS energy_cost_max_26,
  r2_.energy_cost_year AS energy_cost_year_27,
  r2_.ges_grade AS ges_grade_28,
  r2_.ges_value AS ges_value_29,
  r2_.surface_carrez AS surface_carrez_30,
  r2_.surface AS surface_31,
  r2_.rooms AS rooms_32,
  r2_.bedrooms AS bedrooms_33,
  r2_.bathrooms AS bathrooms_34,
  r2_.wc AS wc_35,
  r2_.floors AS floors_36,
  r2_.balcony AS balcony_37,
  r2_.terrace AS terrace_38,
  r2_.garage AS garage_39,
  r2_.parking AS parking_40,
  r2_.heating_type AS heating_type_41,
  r2_.heating_mode AS heating_mode_42,
  r2_.hotwater AS hotwater_43,
  r2_.kitchen AS kitchen_44,
  r2_.aspect AS aspect_45,
  r2_.windows AS windows_46,
  r2_.proximities AS proximities_47,
  r2_.equipments AS equipments_48,
  r3_.id AS id_49,
  r3_.price AS price_50,
  r3_.annual_charges AS annual_charges_51,
  r3_.fees_percent AS fees_percent_52,
  r3_.price_fees_excl AS price_fees_excl_53,
  r3_.buyer_fees AS buyer_fees_54,
  r3_.nb_lots AS nb_lots_55,
  r3_.nb_lots_hab AS nb_lots_hab_56,
  r3_.nb_procedures AS nb_procedures_57,
  r4_.id AS id_58,
  r4_.price_hc AS price_hc_59,
  r4_.charges AS charges_60,
  r4_.price_cc AS price_cc_61,
  r4_.alur AS alur_62,
  r4_.rent_base AS rent_base_63,
  r4_.rent_ref AS rent_ref_64,
  r4_.deposit AS deposit_65,
  r4_.checkin_fees AS checkin_fees_66,
  r1_.parent_id AS parent_id_67,
  r2_.parent_id AS parent_id_68,
  r3_.parent_id AS parent_id_69,
  r4_.parent_id AS parent_id_70
FROM
  real_estate r0_
  LEFT JOIN real_estate_address r1_ ON r0_.id = r1_.parent_id
  LEFT JOIN real_estate_details r2_ ON r0_.id = r2_.parent_id
  LEFT JOIN real_estate_sale r3_ ON r0_.id = r3_.parent_id
  LEFT JOIN real_estate_rental r4_ ON r0_.id = r4_.parent_id
  INNER JOIN real_estate_search_facet r5_ ON (r5_.real_estate_id = r0_.id)
  INNER JOIN search_facet s6_ ON r5_.facet_id = s6_.id
  INNER JOIN real_estate_search_facet r7_ ON (r7_.real_estate_id = r0_.id)
  INNER JOIN search_facet s8_ ON r7_.facet_id = s8_.id
WHERE
  r0_.status = ?
  AND s6_.slug = ?
  AND r5_.charvalue = ?
  AND s8_.slug = ?
  AND r7_.charvalue = ?
ORDER BY
  r0_.contract ASC,
  r3_.price ASC,
  r4_.price_cc ASC
LIMIT
  8

SELECT r0_.id AS id_0, r0_.internal AS internal_1, r0_.reference AS reference_2, r0_.type AS type_3, r0_.category AS category_4, r0_.contract AS contract_5, r0_.status AS status_6, r0_.title AS title_7, r0_.description AS description_8, r0_.slug AS slug_9, r0_.virtual_tour AS virtual_tour_10, r0_.images AS images_11, r0_.available_at AS available_at_12, r1_.id AS id_13, r1_.visible AS visible_14, r1_.street AS street_15, r1_.zipcode AS zipcode_16, r1_.city AS city_17, r1_.borough AS borough_18, r1_.latitude AS latitude_19, r1_.longitude AS longitude_20, r2_.id AS id_21, r2_.building_year AS building_year_22, r2_.energy_grade AS energy_grade_23, r2_.energy_consumption AS energy_consumption_24, r2_.energy_cost_min AS energy_cost_min_25, r2_.energy_cost_max AS energy_cost_max_26, r2_.energy_cost_year AS energy_cost_year_27, r2_.ges_grade AS ges_grade_28, r2_.ges_value AS ges_value_29, r2_.surface_carrez AS surface_carrez_30, r2_.surface AS surface_31, r2_.rooms AS rooms_32, r2_.bedrooms AS bedrooms_33, r2_.bathrooms AS bathrooms_34, r2_.wc AS wc_35, r2_.floors AS floors_36, r2_.balcony AS balcony_37, r2_.terrace AS terrace_38, r2_.garage AS garage_39, r2_.parking AS parking_40, r2_.heating_type AS heating_type_41, r2_.heating_mode AS heating_mode_42, r2_.hotwater AS hotwater_43, r2_.kitchen AS kitchen_44, r2_.aspect AS aspect_45, r2_.windows AS windows_46, r2_.proximities AS proximities_47, r2_.equipments AS equipments_48, r3_.id AS id_49, r3_.price AS price_50, r3_.annual_charges AS annual_charges_51, r3_.fees_percent AS fees_percent_52, r3_.price_fees_excl AS price_fees_excl_53, r3_.buyer_fees AS buyer_fees_54, r3_.nb_lots AS nb_lots_55, r3_.nb_lots_hab AS nb_lots_hab_56, r3_.nb_procedures AS nb_procedures_57, r4_.id AS id_58, r4_.price_hc AS price_hc_59, r4_.charges AS charges_60, r4_.price_cc AS price_cc_61, r4_.alur AS alur_62, r4_.rent_base AS rent_base_63, r4_.rent_ref AS rent_ref_64, r4_.deposit AS deposit_65, r4_.checkin_fees AS checkin_fees_66, r1_.parent_id AS parent_id_67, r2_.parent_id AS parent_id_68, r3_.parent_id AS parent_id_69, r4_.parent_id AS parent_id_70 FROM real_estate r0_ LEFT JOIN real_estate_address r1_ ON r0_.id = r1_.parent_id LEFT JOIN real_estate_details r2_ ON r0_.id = r2_.parent_id LEFT JOIN real_estate_sale r3_ ON r0_.id = r3_.parent_id LEFT JOIN real_estate_rental r4_ ON r0_.id = r4_.parent_id INNER JOIN real_estate_search_facet r5_ ON (r5_.real_estate_id = r0_.id) INNER JOIN search_facet s6_ ON r5_.facet_id = s6_.id INNER JOIN real_estate_search_facet r7_ ON (r7_.real_estate_id = r0_.id) INNER JOIN search_facet s8_ ON r7_.facet_id = s8_.id WHERE r0_.status = 'publish' AND s6_.slug = 'contract-type' AND r5_.charvalue = 'rental' AND s8_.slug = 'rooms' AND r7_.charvalue = '1' ORDER BY r0_.contract ASC, r3_.price ASC, r4_.price_cc ASC LIMIT 8;

SELECT
  s0_.id AS id_0,
  s0_.label AS label_1,
  s0_.slug AS slug_2,
  s0_.type AS type_3,
  s0_.order AS order_4,
  s0_.active AS active_5
FROM
  search_facet s0_
ORDER BY
  s0_.order ASC

SELECT s0_.id AS id_0, s0_.label AS label_1, s0_.slug AS slug_2, s0_.type AS type_3, s0_.order AS order_4, s0_.active AS active_5 FROM search_facet s0_ ORDER BY s0_.order ASC;

SELECT
  s0_.label AS label_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  r1_.charvalue AS charvalue_3,
  r1_.numvalue AS numvalue_4,
  COUNT(DISTINCT r2_.id) AS sclr_5
FROM
  real_estate_search_facet r1_
  INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id
  INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id
WHERE
  s0_.active = true
  AND r1_.facet_id = ?
  AND r2_.status = ?
  AND (
    r2_.id IN (
      SELECT
        r3_.id
      FROM
        real_estate r3_
        INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id)
        INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id
      WHERE
        r2_.status = ?
        AND s5_.slug = ?
        AND r4_.charvalue = ?
    )
  )
GROUP BY
  s0_.label,
  s0_.slug,
  r1_.charvalue,
  r1_.numvalue,
  s0_.type
ORDER BY
  r1_.numvalue ASC,
  r1_.charvalue ASC

SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true AND r1_.facet_id = 1 AND r2_.status = 'publish' AND (r2_.id IN (SELECT r3_.id FROM real_estate r3_ INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id) INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id WHERE r2_.status = 'publish' AND s5_.slug = 'rooms' AND r4_.charvalue = '1')) GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.type ORDER BY r1_.numvalue ASC, r1_.charvalue ASC;

SELECT
  s0_.label AS label_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  r1_.charvalue AS charvalue_3,
  r1_.numvalue AS numvalue_4,
  COUNT(DISTINCT r2_.id) AS sclr_5
FROM
  real_estate_search_facet r1_
  INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id
  INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id
WHERE
  s0_.active = true
  AND r1_.facet_id = ?
  AND r2_.status = ?
  AND (
    r2_.id IN (
      SELECT
        r3_.id
      FROM
        real_estate r3_
        INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id)
        INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id
        INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id)
        INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id
      WHERE
        r2_.status = ?
        AND s5_.slug = ?
        AND r4_.charvalue = ?
        AND s7_.slug = ?
        AND r6_.charvalue = ?
    )
  )
GROUP BY
  s0_.label,
  s0_.slug,
  r1_.charvalue,
  r1_.numvalue,
  s0_.type
ORDER BY
  r1_.numvalue ASC,
  r1_.charvalue ASC

SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true AND r1_.facet_id = 2 AND r2_.status = 'publish' AND (r2_.id IN (SELECT r3_.id FROM real_estate r3_ INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id) INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id) INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id WHERE r2_.status = 'publish' AND s5_.slug = 'contract-type' AND r4_.charvalue = 'rental' AND s7_.slug = 'rooms' AND r6_.charvalue = '1')) GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.type ORDER BY r1_.numvalue ASC, r1_.charvalue ASC;

SELECT
  s0_.label AS label_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  r1_.charvalue AS charvalue_3,
  r1_.numvalue AS numvalue_4,
  COUNT(DISTINCT r2_.id) AS sclr_5
FROM
  real_estate_search_facet r1_
  INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id
  INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id
WHERE
  s0_.active = true
  AND r1_.facet_id = ?
  AND r2_.status = ?
  AND (
    r2_.id IN (
      SELECT
        r3_.id
      FROM
        real_estate r3_
        INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id)
        INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id
        INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id)
        INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id
      WHERE
        r2_.status = ?
        AND s5_.slug = ?
        AND r4_.charvalue = ?
        AND s7_.slug = ?
        AND r6_.charvalue = ?
    )
  )
GROUP BY
  s0_.label,
  s0_.slug,
  r1_.charvalue,
  r1_.numvalue,
  s0_.type
ORDER BY
  r1_.numvalue ASC,
  r1_.charvalue ASC

SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true AND r1_.facet_id = 3 AND r2_.status = 'publish' AND (r2_.id IN (SELECT r3_.id FROM real_estate r3_ INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id) INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id) INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id WHERE r2_.status = 'publish' AND s5_.slug = 'contract-type' AND r4_.charvalue = 'rental' AND s7_.slug = 'rooms' AND r6_.charvalue = '1')) GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.type ORDER BY r1_.numvalue ASC, r1_.charvalue ASC;

SELECT
  s0_.label AS label_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  r1_.charvalue AS charvalue_3,
  r1_.numvalue AS numvalue_4,
  COUNT(DISTINCT r2_.id) AS sclr_5
FROM
  real_estate_search_facet r1_
  INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id
  INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id
WHERE
  s0_.active = true
  AND r1_.facet_id = ?
  AND r2_.status = ?
  AND (
    r2_.id IN (
      SELECT
        r3_.id
      FROM
        real_estate r3_
        INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id)
        INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id
        INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id)
        INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id
      WHERE
        r2_.status = ?
        AND s5_.slug = ?
        AND r4_.charvalue = ?
        AND s7_.slug = ?
        AND r6_.charvalue = ?
    )
  )
GROUP BY
  s0_.label,
  s0_.slug,
  r1_.charvalue,
  r1_.numvalue,
  s0_.type
ORDER BY
  r1_.numvalue ASC,
  r1_.charvalue ASC

SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true AND r1_.facet_id = 4 AND r2_.status = 'publish' AND (r2_.id IN (SELECT r3_.id FROM real_estate r3_ INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id) INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id) INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id WHERE r2_.status = 'publish' AND s5_.slug = 'contract-type' AND r4_.charvalue = 'rental' AND s7_.slug = 'rooms' AND r6_.charvalue = '1')) GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.type ORDER BY r1_.numvalue ASC, r1_.charvalue ASC;

SELECT
  s0_.label AS label_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  r1_.charvalue AS charvalue_3,
  r1_.numvalue AS numvalue_4,
  COUNT(DISTINCT r2_.id) AS sclr_5
FROM
  real_estate_search_facet r1_
  INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id
  INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id
WHERE
  s0_.active = true
  AND r1_.facet_id = ?
  AND r2_.status = ?
  AND (
    r2_.id IN (
      SELECT
        r3_.id
      FROM
        real_estate r3_
        INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id)
        INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id
        INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id)
        INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id
      WHERE
        r2_.status = ?
        AND s5_.slug = ?
        AND r4_.charvalue = ?
        AND s7_.slug = ?
        AND r6_.charvalue = ?
    )
  )
GROUP BY
  s0_.label,
  s0_.slug,
  r1_.charvalue,
  r1_.numvalue,
  s0_.type
ORDER BY
  r1_.numvalue ASC,
  r1_.charvalue ASC

SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true AND r1_.facet_id = 5 AND r2_.status = 'publish' AND (r2_.id IN (SELECT r3_.id FROM real_estate r3_ INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id) INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id) INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id WHERE r2_.status = 'publish' AND s5_.slug = 'contract-type' AND r4_.charvalue = 'rental' AND s7_.slug = 'rooms' AND r6_.charvalue = '1')) GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.type ORDER BY r1_.numvalue ASC, r1_.charvalue ASC;

SELECT
  s0_.label AS label_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  r1_.charvalue AS charvalue_3,
  r1_.numvalue AS numvalue_4,
  COUNT(DISTINCT r2_.id) AS sclr_5
FROM
  real_estate_search_facet r1_
  INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id
  INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id
WHERE
  s0_.active = true
  AND r1_.facet_id = ?
  AND r2_.status = ?
  AND (
    r2_.id IN (
      SELECT
        r3_.id
      FROM
        real_estate r3_
        INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id)
        INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id
        INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id)
        INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id
      WHERE
        r2_.status = ?
        AND s5_.slug = ?
        AND r4_.charvalue = ?
        AND s7_.slug = ?
        AND r6_.charvalue = ?
    )
  )
GROUP BY
  s0_.label,
  s0_.slug,
  r1_.charvalue,
  r1_.numvalue,
  s0_.type
ORDER BY
  r1_.numvalue ASC,
  r1_.charvalue ASC

SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true AND r1_.facet_id = 6 AND r2_.status = 'publish' AND (r2_.id IN (SELECT r3_.id FROM real_estate r3_ INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id) INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id) INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id WHERE r2_.status = 'publish' AND s5_.slug = 'contract-type' AND r4_.charvalue = 'rental' AND s7_.slug = 'rooms' AND r6_.charvalue = '1')) GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.type ORDER BY r1_.numvalue ASC, r1_.charvalue ASC;

SELECT
  s0_.label AS label_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  r1_.charvalue AS charvalue_3,
  r1_.numvalue AS numvalue_4,
  COUNT(DISTINCT r2_.id) AS sclr_5
FROM
  real_estate_search_facet r1_
  INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id
  INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id
WHERE
  s0_.active = true
  AND r1_.facet_id = ?
  AND r2_.status = ?
  AND (
    r2_.id IN (
      SELECT
        r3_.id
      FROM
        real_estate r3_
        INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id)
        INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id
        INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id)
        INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id
      WHERE
        r2_.status = ?
        AND s5_.slug = ?
        AND r4_.charvalue = ?
        AND s7_.slug = ?
        AND r6_.charvalue = ?
    )
  )
GROUP BY
  s0_.label,
  s0_.slug,
  r1_.charvalue,
  r1_.numvalue,
  s0_.type
ORDER BY
  r1_.numvalue ASC,
  r1_.charvalue ASC

SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true AND r1_.facet_id = 7 AND r2_.status = 'publish' AND (r2_.id IN (SELECT r3_.id FROM real_estate r3_ INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id) INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id INNER JOIN real_estate_search_facet r6_ ON (r6_.real_estate_id = r3_.id) INNER JOIN search_facet s7_ ON r6_.facet_id = s7_.id WHERE r2_.status = 'publish' AND s5_.slug = 'contract-type' AND r4_.charvalue = 'rental' AND s7_.slug = 'rooms' AND r6_.charvalue = '1')) GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.type ORDER BY r1_.numvalue ASC, r1_.charvalue ASC;

SELECT
  s0_.label AS label_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  r1_.charvalue AS charvalue_3,
  r1_.numvalue AS numvalue_4,
  COUNT(DISTINCT r2_.id) AS sclr_5
FROM
  real_estate_search_facet r1_
  INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id
  INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id
WHERE
  s0_.active = true
  AND r1_.facet_id = ?
  AND r2_.status = ?
  AND (
    r2_.id IN (
      SELECT
        r3_.id
      FROM
        real_estate r3_
        INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id)
        INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id
      WHERE
        r2_.status = ?
        AND s5_.slug = ?
        AND r4_.charvalue = ?
    )
  )
GROUP BY
  s0_.label,
  s0_.slug,
  r1_.charvalue,
  r1_.numvalue,
  s0_.type
ORDER BY
  r1_.numvalue ASC,
  r1_.charvalue ASC

SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true AND r1_.facet_id = 8 AND r2_.status = 'publish' AND (r2_.id IN (SELECT r3_.id FROM real_estate r3_ INNER JOIN real_estate_search_facet r4_ ON (r4_.real_estate_id = r3_.id) INNER JOIN search_facet s5_ ON r4_.facet_id = s5_.id WHERE r2_.status = 'publish' AND s5_.slug = 'contract-type' AND r4_.charvalue = 'rental')) GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.type ORDER BY r1_.numvalue ASC, r1_.charvalue ASC;