Symfony Profiler

[
  "route" => "search_page"
  "route_parameters" => [
    "_route" => "search_page"
    "lang" => "ca"
    "_controller" => "App\Controller\MainController::searchPage"
    "operacio" => "compra"
    "supertipus" => "habitatges"
    "province" => "barcelona"
    "locality" => "badalona"
  ]
  "request_uri" => "https://webprof.tridenia.es/ca/compra/habitatges/barcelona/badalona"
  "method" => "GET"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "host" => "tridenia.cluster-cdx46d7cizxf.eu-west-1.rds.amazonaws.com"
    "port" => 3306
    "user" => "tecnoapi"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "5.7"
    "defaultTableOptions" => []
    "dbname" => "bd_agency_a13096"
  ]
]

[
  "sql" => "INSERT INTO tracking (type, session_id, tracking_value, date_created) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => 0
    2 => "1122b1127dd203a4c9a07c01fee8dd2bcf618d3c"
    3 => "/ca/compra/habitatges/barcelona/badalona"
    4 => "2026-06-19 20:28:54"
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\PageSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3 FROM api_menu t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.google AS google_9, t0.linkedin AS linkedin_10, t0.instagram AS instagram_11, t0.tiktok AS tiktok_12, t0.youtube AS youtube_13, t0.logo AS logo_14, t0.logo_movile_email AS logo_movile_email_15, t0.logo_contact AS logo_contact_16, t0.logo_fav AS logo_fav_17, t0.logo_aicat AS logo_aicat_18, t0.logo_agente AS logo_agente_19, t0.logo_miembro AS logo_miembro_20, t0.banner AS banner_21, t0.banner_url AS banner_url_22, t0.default_list_properties AS default_list_properties_23, t0.user AS user_24, t0.password AS password_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.primary_foot_1 AS primary_foot_1_28, t0.primary_foot_2 AS primary_foot_2_29, t0.filter_header AS filter_header_30, t0.newsletter AS newsletter_31, t0.first_time AS first_time_32, t0.activation AS activation_33, t0.roles AS roles_34 FROM api_agency t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0"
]

[
  "sql" => "SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0 WHERE t0.cod = ? LIMIT 1"
  "params" => [
    1 => "ca"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.order_page AS order_page_2, t0.page_id AS page_id_3, t0.menu_id AS menu_id_4, t0.parent_id AS parent_id_5 FROM api_order_pages t0 WHERE t0.menu_id = ? ORDER BY t0.order_page ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 21
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 137
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 137
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 141
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 141
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 145
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 145
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 99760
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 149
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 149
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 71
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 99999
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 63
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 88190
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 59
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 70840
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 51
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ca"
    2 => 60722
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT identificador, valor_ca as texto FROM textos"
]

[
  "sql" => "SELECT * FROM api_provinces  WHERE id IN (33,34,35,36)  ORDER BY name"
]

[
  "sql" => "SELECT * FROM api_provinces  WHERE id NOT IN (33,34,35,36)  ORDER BY name"
]

[
  "sql" => "SELECT * FROM api_provinces WHERE friendly = 'barcelona' LIMIT 1"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 49"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 42"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 37"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 19"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 1"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 53"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 14"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 24"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 40"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 25"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 41"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 2"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 18"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 38"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 20"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 9"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 3"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 4"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 21"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 50"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 22"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 11"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 5"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 15"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 6"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 52"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 26"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 43"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 16"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 10"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 7"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 46"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 47"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 48"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 27"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 44"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 45"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 28"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 29"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 8"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 30"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 17"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 12"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 31"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 39"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 23"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 51"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 13"
]

[
  "sql" => "SELECT count(*) as total FROM api_properties WHERE provincia = 32"
]

[
  "sql" => "SELECT * FROM api_locations WHERE friendly = 'badalona'  AND province= '33'  LIMIT 1"
]

[
  "sql" => """
    SELECT\n
                        id_properties_supertype AS id,\n
                        friendly,\n
                        `TEXT` AS nom\n
                    FROM api_properties_supertype s\n
                    LEFT JOIN api_properties_supertype_i18n si ON s.id_properties_supertype = si.id AND cod_lang = 'ca_ES'\n
                    ORDER BY s.id_properties_supertype
    """
]

[
  "sql" => "SELECT codi FROM tipus_operacio WHERE friendly_ca = 'compra' LIMIT 1"
]

[
  "sql" => "SELECT id_properties_supertype as idSuperTipusImmoble FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n si ON s.id_properties_supertype=si.id WHERE friendly = 'habitatges' AND cod_lang = 'ca_ES'  LIMIT 1"
]

[
  "sql" => "SELECT * FROM api_locations WHERE province = 33 AND name != '' AND orden >= 1 ORDER BY orden, name"
]

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

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

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

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

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

[
  "sql" => "SELECT * FROM api_locations WHERE province = 33 AND name != '' AND orden = 0 ORDER BY name"
]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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