4 000 $
Продаж земельної ділянки під забудову
176000.0
Томилівка
Знайдено 93 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7128
}
}
]
}
},
"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 · 3.45 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 ["tomilovka","\/tomilovka","tomilovka\/","\/tomilovka\/"] · 1.51 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.59 msSHOW TABLES · 1.64 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) [202173550,202169764,202148431,202078486,201640199,200817481,200711251,200103700,199864879,199309996,199281088,199258114,198515048,198225100,198204399,198099397,197500556,197335658,197221473,196927336,196786063,196658668,196599652,196561325,196356065,196266704,196167956,196166831,195633854,194837558,192540367,188895042,186299247,186037098,183313366,182570581,182366221,181437253,176541667,175398321,170219260,169781485,168194875] · 51.14 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 [168194875,169781485,170219260,175398321,176541667,181437253,182366221,182570581,183313366,186037098,186299247,188895042,192540367,194837558,195633854,196166831,196167956,196266704,196356065,196561325,196599652,196658668,196786063,196927336,197221473,197335658,197500556,198099397,198204399,198225100,198515048,199258114,199281088,199309996,199864879,200103700,200711251,200817481,201640199,202078486,202148431,202169764,202173550] · 3.44 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.64 ms