Search
0000
Results
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 = 2 INNER JOIN locations_terms AS country ON country.location_id = properties.country_id AND country.location_type = 'country' AND country.language_id = 2 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 ( '1' ) AND properties.sale > 0 AND properties.sold = 0 AND properties.development = 0 AND properties.province_id IN ( '307' ) AND REPLACE( SUBSTRING( lifestyle_calification.lifestyles, LOCATE( '422', lifestyle_calification.lifestyles ) + LENGTH('422","puntuacion":"') , 2 ), '"', '' ) >= 1