Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.group_page AS group_page_3,
  t0.lang AS lang_4,
  t0.status AS status_5,
  t0.title AS title_6,
  t0.str_html AS str_html_7,
  t0.json_back AS json_back_8,
  t0.date_created AS date_created_9,
  t0.default_page AS default_page_10
FROM
  api_pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = 21;

SELECT
  identificador,
  valor_fr as texto
FROM
  textos

SELECT identificador, valor_fr as texto FROM textos;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.group_page AS group_page_3,
  t0.lang AS lang_4,
  t0.status AS status_5,
  t0.title AS title_6,
  t0.str_html AS str_html_7,
  t0.json_back AS json_back_8,
  t0.date_created AS date_created_9,
  t0.default_page AS default_page_10
FROM
  api_pages t0
WHERE
  t0.lang = ?
  AND t0.group_page = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = 'fr' AND t0.group_page = 21 LIMIT 1;

SELECT
  *
FROM
  api_properties_supertype s
  LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id)
WHERE
  id_properties_supertype = '1'
  AND cod_lang = 'fr_FR'
LIMIT
  1

SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'fr_FR' LIMIT 1;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 1
      AND bi.localidad = '6380'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6380'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  *
FROM
  api_locations
WHERE
  id = '6236'
LIMIT
  1

SELECT * FROM api_locations WHERE id='6236' LIMIT 1;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 1
      AND bi.localidad = '6400'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6400'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.localidad = '2'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.localidad = '2'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.localidad = '1'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.localidad = '1'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  api_properties_subtypes_i18n.id
FROM
  api_properties_subtypes_i18n
  INNER JOIN api_properties_subtypes ON api_properties_subtypes_i18n.id = api_properties_subtypes.id
WHERE
  api_properties_subtypes_i18n.cod_lang = 'fr_FR'
  AND api_properties_subtypes_i18n.friendly = ''
ORDER BY
  id ASC
LIMIT
  1

SELECT api_properties_subtypes_i18n.id FROM api_properties_subtypes_i18n INNER JOIN api_properties_subtypes ON api_properties_subtypes_i18n.id = api_properties_subtypes.id WHERE api_properties_subtypes_i18n.cod_lang='fr_FR' AND api_properties_subtypes_i18n.friendly=''  ORDER BY id ASC LIMIT 1;

SELECT
  *
FROM
  api_provinces
WHERE
  id = '3'
LIMIT
  1

SELECT * FROM api_provinces WHERE id='3' LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  id
FROM
  api_properties_supertype_i18n
WHERE
  friendly = 'habitatges'

SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'habitatges';

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 1
      AND bi.localidad = '6334'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6334'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 1
      AND bi.localidad = '6407'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6407'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  i.text
from
  api_properties_types t
  LEFT JOIN api_properties_types_i18n i ON t.id = i.id
  LEFT JOIN api_properties p ON t.id = p.id_properties_type
WHERE
  p.id = 12
  AND i.cod_lang = 'fr_FR'
LIMIT
  1

SELECT i.text from api_properties_types t LEFT JOIN api_properties_types_i18n i ON t.id=i.id LEFT JOIN api_properties p ON t.id= p.id_properties_type  WHERE p.id=12 AND i.cod_lang = 'fr_FR'  LIMIT 1;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 1
        OR bi.alquiler = 2
      )
      AND bi.precio_alquiler > 0
      AND bi.localidad = '1'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   bi.localidad = '1'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  *
FROM
  api_locations
WHERE
  province = 3
  AND name != ''
  AND orden = 0
ORDER BY
  name

SELECT * FROM api_locations WHERE province = 3 AND name != '' AND orden = 0 ORDER BY name;

SELECT
  text_seo_fr as text_seo
FROM
  tipus_operacio
WHERE
  codi = 2
LIMIT
  1

SELECT text_seo_fr as text_seo FROM tipus_operacio WHERE codi = 2 LIMIT 1;

SELECT
  bi.*,
  des.telef1,
  bi18.anuncio AS descrip,
  IF (
    superf_constr != ''
    AND superf_constr != '00'
    AND superf_constr != '0',
    superf_constr,
    superf_util
  ) AS superficie,
  bi.precio AS preu,
  bi.id_properties_subtype AS id_tipus,
  IF(
    bi.es_lloguer_temporada = 1,
    7,
    IF(
      bi.es_banc = 1,
      4,
      IF(
        bi.obra_nueva = 1,
        3,
        IF(bi.alquiler = 1, 1, 2)
      )
    )
  ) operation,
  apitype.text as tipo_nombre
FROM
  api_properties as bi
  LEFT JOIN api_properties_i18n AS bi18 ON (bi.id = bi18.id)
  AND bi18.cod_lang = 'fr_FR'
  INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
  INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
  INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
  INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
  AND apitype.cod_lang = 'fr_FR'
WHERE
  (
    IF (
      bi.contrato_exclusividad = 1,
      IF (
        bi.fecha_caducidad != '0000-00-00'
        AND bi.fecha_caducidad > '2026-06-19',
        TRUE,
        FALSE
      ),
      TRUE
    ) = TRUE
  )
  AND (
    (
      IF(
        bi.obra_nueva = 1
        AND bi.num_fotos >= 1,
        TRUE,
        FALSE
      ) = TRUE
    )
    OR (
      IF(
        bi.obra_nueva = 0
        AND bi.num_fotos >= 1,
        TRUE,
        FALSE
      ) = TRUE
    )
  )
  AND bi.num_fotos > 0
  AND (
    bi.alquiler = 0
    OR bi.alquiler = 2
  )
  AND bi.precio > 0
  AND id_properties_supertype = 1
  AND bi.localidad = '6236'
  AND bi.provincia = '3'
GROUP BY
  bi.id
ORDER BY
  destacado DESC,
  fecha_creacion DESC,
  num_fotos DESC,
  bi.id DESC
LIMIT
  18

SELECT bi.*, des.telef1  ,bi18.anuncio AS descrip
							,IF (superf_constr != '' AND superf_constr != '00' AND superf_constr !='0' , superf_constr, superf_util) AS superficie,
							 bi.precio AS preu  	,bi.id_properties_subtype AS id_tipus,
			 IF(bi.es_lloguer_temporada = 1, 7,
                IF(bi.es_banc = 1, 4,
                    IF(bi.obra_nueva = 1, 3,
                        IF(bi.alquiler = 1, 1, 2)
                    )
                )
            ) operation,
            apitype.text as tipo_nombre FROM api_properties as bi  LEFT JOIN api_properties_i18n AS bi18 ON (bi.id = bi18.id) AND bi18.cod_lang = 'fr_FR' 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE  (IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE) = TRUE)    AND ((IF(bi.obra_nueva=1 AND bi.num_fotos>=1, TRUE, FALSE) = TRUE) OR (IF(bi.obra_nueva=0 AND bi.num_fotos>=1, TRUE, FALSE) = TRUE))  AND bi.num_fotos > 0  AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6236'  AND   bi.provincia = '3'  GROUP BY bi.id  ORDER BY destacado DESC, fecha_creacion DESC , num_fotos DESC,  bi.id DESC  LIMIT 18;

SELECT
  bi.*,
  des.telef1,
  bi18.anuncio AS descrip,
  IF (
    superf_constr != ''
    AND superf_constr != '00'
    AND superf_constr != '0',
    superf_constr,
    superf_util
  ) AS superficie,
  bi.precio AS preu,
  bi.id_properties_subtype AS id_tipus,
  IF(
    bi.es_lloguer_temporada = 1,
    7,
    IF(
      bi.es_banc = 1,
      4,
      IF(
        bi.obra_nueva = 1,
        3,
        IF(bi.alquiler = 1, 1, 2)
      )
    )
  ) operation,
  apitype.text as tipo_nombre
FROM
  api_properties as bi
  LEFT JOIN api_properties_i18n AS bi18 ON (bi.id = bi18.id)
  AND bi18.cod_lang = 'fr_FR'
  INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
  INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
  INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
  INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
  AND apitype.cod_lang = 'fr_FR'
WHERE
  (
    IF (
      bi.contrato_exclusividad = 1,
      IF (
        bi.fecha_caducidad != '0000-00-00'
        AND bi.fecha_caducidad > '2026-06-19',
        TRUE,
        FALSE
      ),
      TRUE
    ) = TRUE
  )
  AND (
    (
      IF(
        bi.obra_nueva = 1
        AND bi.num_fotos >= 1,
        TRUE,
        FALSE
      ) = TRUE
    )
    OR (
      IF(
        bi.obra_nueva = 0
        AND bi.num_fotos >= 1,
        TRUE,
        FALSE
      ) = TRUE
    )
  )
  AND bi.num_fotos > 0
  AND (
    bi.alquiler = 0
    OR bi.alquiler = 2
  )
  AND bi.precio > 0
  AND id_properties_supertype = 1
  AND bi.localidad = '6236'
  AND bi.provincia = '3'
GROUP BY
  bi.id
ORDER BY
  destacado DESC,
  fecha_creacion DESC,
  num_fotos DESC,
  bi.id DESC

SELECT bi.*, des.telef1  ,bi18.anuncio AS descrip
							,IF (superf_constr != '' AND superf_constr != '00' AND superf_constr !='0' , superf_constr, superf_util) AS superficie,
							 bi.precio AS preu  	,bi.id_properties_subtype AS id_tipus,
			 IF(bi.es_lloguer_temporada = 1, 7,
                IF(bi.es_banc = 1, 4,
                    IF(bi.obra_nueva = 1, 3,
                        IF(bi.alquiler = 1, 1, 2)
                    )
                )
            ) operation,
            apitype.text as tipo_nombre FROM api_properties as bi  LEFT JOIN api_properties_i18n AS bi18 ON (bi.id = bi18.id) AND bi18.cod_lang = 'fr_FR' 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE  (IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE) = TRUE)    AND ((IF(bi.obra_nueva=1 AND bi.num_fotos>=1, TRUE, FALSE) = TRUE) OR (IF(bi.obra_nueva=0 AND bi.num_fotos>=1, TRUE, FALSE) = TRUE))  AND bi.num_fotos > 0  AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6236'  AND   bi.provincia = '3'  GROUP BY bi.id  ORDER BY destacado DESC, fecha_creacion DESC , num_fotos DESC,  bi.id DESC ;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 1
      AND bi.localidad = '6402'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6402'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 1
      AND bi.localidad = '6406'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6406'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 1
      AND bi.localidad = '6413'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'fr_FR' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6413'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'fr_FR'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 1
      AND bi.localidad = '6412'
      AND bi.provincia = '3'
    GROUP BY
      bi.id
  ) AS CONTADOR