1 000 ₴
Оренда земельної ділянки промислового призначення біля кордону Польщі
1000.0
Белз
Знайдено 251 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3632
}
}
]
}
},
"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 · 1.13 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 ["belz","\/belz","belz\/","\/belz\/"] · 1.85 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.39 msSHOW TABLES · 39.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) [204697973,204348140,204257796,203181298,202665533,202627933,202555157,202423803,202256404,202164901,202152595,201829381,201089146,200584957,200455246,200380393,199959070,198705019,197925343,197856739,197856737,197820485,197820483,197820479,197820477,197799535,197302737,197300835,197300833,197300803,197272347,197226071,197226067,197226023,197226015,196835284,196801504,196776067,196775692,196585283,196571317,196407905,196370774,195505373,195505352,195505346,195505328,195505307,195505196,195505163] · 65.28 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 [195505163,195505196,195505307,195505328,195505346,195505352,195505373,196370774,196407905,196571317,196585283,196775692,196776067,196801504,196835284,197226015,197226023,197226067,197226071,197272347,197300803,197300833,197300835,197302737,197799535,197820477,197820479,197820483,197820485,197856737,197856739,197925343,198705019,199959070,200380393,200455246,200584957,201089146,201829381,202152595,202164901,202256404,202423803,202555157,202627933,202665533,203181298,204257796,204348140,204697973] · 1.24 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.72 ms