385 000 $
Совиньон-3! Дом на 5 сотках! Нео-классика! 1A37
183 м² 16940000.0
Може
Знайдено 11 461 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6243
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2200,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 7.1 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["limanka","\/limanka","limanka\/","\/limanka\/"] · 0.52 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.29 msSHOW TABLES · 0.62 msSELECT p.id, p.category_id, p.city_id, p.region AS region_id, p.vendor AS vendor_id, p.name, p.description, p.name AS name_orig, p.price, p.currency, p.bargain, p.conditions, p.url, p.img, p.view AS views, p.data_post, p.data_edit, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS city_name, c.url AS city_slug FROM `post` p LEFT JOIN `city` c ON c.id = p.city_id WHERE p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (1=1) [214116430,214116254,214115114,214113992,214105374,214089576,214089540,214088486,214088454,214083002,214080552,214079030,214078104,214077360,214075796,214072920,214068710,214066504,214066240,214065632,214063768,214063592,214063468,214063442,214063324,214061900,214061674,214051992,214051386,214050608,214050438,214049426,214048462,214047534,214046826,214045696,214043176,214038822,214029642,214028194,214023030,214021612,214018272,214018202,214017628,214017572,214014786,214012978,214011092,214010704] · 115.99 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute_value` v JOIN `attribute` a ON a.id = v.attribute_id WHERE v.post_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND v.value IS NOT NULL AND v.value <> '' ORDER BY a.id [214010704,214011092,214012978,214014786,214017572,214017628,214018202,214018272,214021612,214023030,214028194,214038822,214043176,214045696,214046826,214047534,214048462,214049426,214050438,214050608,214051386,214051992,214061674,214061900,214063324,214063442,214063468,214063592,214063768,214065632,214066240,214066504,214068710,214072920,214075796,214077360,214078104,214079030,214080552,214083002,214088454,214088486,214089540,214089576,214105374,214113992,214115114,214116254,214116430] · 122.51 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 12.63 ms