23 000 $
Продаж двох суміжних земельних ділянок у с. Суховоля
1012000.0
Суховоля
Знайдено 786 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6457
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 4.18 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 ["suhovolya","\/suhovolya","suhovolya\/","\/suhovolya\/"] · 1.98 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.51 msSHOW TABLES · 0.96 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) [216456400,216456286,216456052,216411517,216403579,216378766,216371011,216329707,216328825,216328477,216290563,216252754,216239155,216239092,216209221,216197440,216191008,216190960,216173008,216106558,216083227,216064396,216053758,216052891,216050290,216032296,216023965,215910841,215905819,215850100,215822593,215782393,215751170,215748368,215748161,215735744,215725718,215697770,215648652,215622561,215614395,215606094,215600286,215546457,215484387,215444781,215423608,215362161,215344130,215340470] · 99.51 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 [215340470,215344130,215362161,215423608,215444781,215484387,215546457,215600286,215606094,215614395,215622561,215648652,215697770,215725718,215735744,215748161,215748368,215751170,215782393,215822593,215850100,215905819,215910841,216023965,216032296,216050290,216052891,216053758,216064396,216083227,216106558,216173008,216190960,216191008,216197440,216209221,216239092,216239155,216252754,216290563,216328477,216328825,216329707,216371011,216378766,216403579,216411517,216456052,216456286,216456400] · 29.73 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] · 2.61 ms