0000
Resultados
func:getCountProperties - Query execution was interrupted SELECT COUNT( DISTINCT properties.id ) AS total FROM properties INNER JOIN data_terms AS categories ON categories.concept_id = properties.category_id AND categories.concept_type = 'category' AND categories.language_id = 1 INNER JOIN locations_terms AS country ON country.location_id = properties.country_id AND country.location_type = 'country' AND country.language_id = 1 LEFT JOIN areas_relationships AS idCountryArea ON idCountryArea.location_id = properties.country_id AND idCountryArea.concept_id = 'country' LEFT JOIN areas_relationships AS idProvinceArea ON idProvinceArea.location_id = properties.country_id AND idProvinceArea.concept_id = 'province' LEFT JOIN areas_relationships AS idCityArea ON idCityArea.location_id = properties.country_id AND idCityArea.concept_id = 'city' LEFT JOIN areas_relationships AS idQuarterArea ON idQuarterArea.location_id = properties.country_id AND idQuarterArea.concept_id = 'quarter' INNER JOIN lifestyle_calification ON lifestyle_calification.property_id = properties.id WHERE properties.deleted = 0 AND properties.category_id IN ( '2' ) AND properties.sale > 0 AND properties.sold = 0 AND properties.development = 0 AND properties.province_id IN ( '307' ) AND properties.city_id IN ( '74048' ) AND REPLACE( SUBSTRING( lifestyle_calification.lifestyles, LOCATE( '413', lifestyle_calification.lifestyles ) + LENGTH('413","puntuacion":"') , 2 ), '"', '' ) >= 1