Symfony Profiler

[
  "route" => "search_page"
  "route_parameters" => [
    "_route" => "search_page"
    "lang" => "en"
    "_controller" => "App\Controller\MainController::searchPage"
    "operacio" => "rent"
    "supertipus" => "flats-and-houses"
    "province" => "cordoba"
    "locality" => "baena"
  ]
  "request_uri" => "https://webprof.tridenia.es/en/rent/flats-and-houses/cordoba/baena"
  "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\LocaleListener::setDefaultLocale"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::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 => "/en/rent/flats-and-houses/cordoba/baena"
    4 => "2026-06-19 20:28:50"
  ]
  "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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

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

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

[
  "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 => "en"
  ]
  "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 => "en"
    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.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "en"
    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 => 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.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 => "en"
    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 => "en"
    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.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "en"
    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 => 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.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 => "en"
    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 => "en"
    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 => "en"
    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.lang = ? AND t0.group_page = ? LIMIT 1"
  "params" => [
    1 => "en"
    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 => 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 => "en"
    2 => 60722
  ]
  "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 identificador, valor_en 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 = 'cordoba' 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 = 19"
]

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

[
  "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 = 9"
]

[
  "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 = 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 = 22"
]

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

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

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

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

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

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

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

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

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

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

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

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

[
  "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 = 44"
]

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

[
  "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 = 23"
]

[
  "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 = 51"
]

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

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

[
  "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 = 'en_US'\n
                    ORDER BY s.id_properties_supertype
    """
]

[
  "sql" => "SELECT * FROM api_locations WHERE friendly = 'baena'  AND province= '3'  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 = 'flats-and-houses' AND cod_lang = 'en_US'  LIMIT 1"
]

[
  "sql" => "SELECT codi FROM tipus_operacio WHERE friendly_en = 'rent' LIMIT 1"
]

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

[
  "sql" => "SELECT * FROM api_locations WHERE province = 3 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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6214'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6213'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6215'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6216'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6217'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6218'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6219'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6220'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6221'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6222'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6223'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6224'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6225'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6226'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6227'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6229'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6228'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6230'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6231'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6232'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6233'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6234'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6235'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6236'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6237'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6238'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6239'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6240'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6241'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6242'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6243'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6244'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6245'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6246'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6247'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6248'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6249'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6251'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6252'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6250'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6253'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6254'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6255'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6257'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6256'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6258'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6259'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6260'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6261'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6262'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6263'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6265'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6264'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6266'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6267'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6268'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6269'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6270'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6271'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6272'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6273'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6274'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6275'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6277'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6276'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6278'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6279'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6280'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6282'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6281'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6283'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6284'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6285'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6286'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6287'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6288'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6289'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6290'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6291'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6292'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6294'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6295'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6293'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6296'  AND   bi.provincia = '3'  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 = 'en_US' 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=1 OR bi.alquiler=2)  AND   bi.precio_alquiler > 0 AND   id_properties_supertype = 1  AND   bi.localidad = '6297'  AND   bi.provincia = '3'  GROUP BY bi.id ) AS CONTADOR
    """
]