118 000 $
Продам 2 єт. дом 440 кв.м.,18 соток в КГ Севериновка,віход на озеро
440 м² 5192000.0
Северинівка
Знайдено 485 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6409
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 50,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 5.82 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 ["severinovka","\/severinovka","severinovka\/","\/severinovka\/"] · 0.88 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.71 msSHOW TABLES · 2.05 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) [218130820,218092270,218003713,217978899,217956859,217948099,217875649,217821367,217774012,217760203,217756453,217664734,217650130,217539760,217521508,217423900,217390036,217374964,217281262,217177624,217124650,217071370,217030135,216790243,216721774,216642850,216640444,216640186,216631045,216460621,216384013,216383926,216345529,216277489,216001639,215992477,215919232,215853226,215756660,215725772,215718938,215718842,215683247,215640624,215455938,215455545,215418933,215413155,215394402,215231487] · 26.2 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 [215231487,215394402,215413155,215418933,215455545,215455938,215640624,215683247,215718842,215718938,215725772,215756660,215853226,215919232,215992477,216001639,216277489,216345529,216383926,216384013,216460621,216631045,216640186,216640444,216642850,216721774,216790243,217030135,217071370,217124650,217177624,217281262,217374964,217390036,217423900,217521508,217539760,217650130,217664734,217756453,217760203,217774012,217821367,217875649,217948099,217956859,217978899,218003713,218092270,218130820] · 26.83 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] · 0.92 ms