16 000 $
Продається хата в с. Литвинець
80 м² 704000.0
Литвинець
Знайдено 42 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 10034
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.67 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 ["litvinec","\/litvinec","litvinec\/","\/litvinec\/"] · 1.57 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.41 msSHOW TABLES · 0.83 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) [219034658,217100869,217012690,216587173,215793037,214670973,214401966,214401594,214001590,213829818,213817083,212917863,210396311,210301508,209692037,208048267,207494191,207448120,206839990,204817361,200820031,200053285,200043511,198012175,197689262,197595371,195480938,194902334,191082537,189725742,189725271,189725226,189725220,189725211,189352026,189087147,186384054,182211550,179819239,173171899,170911651,169982917] · 45.73 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 [169982917,170911651,173171899,179819239,182211550,186384054,189087147,189352026,189725211,189725220,189725226,189725271,189725742,191082537,194902334,195480938,197595371,197689262,198012175,200043511,200053285,200820031,204817361,206839990,207448120,207494191,208048267,209692037,210301508,210396311,212917863,213817083,213829818,214001590,214401594,214401966,214670973,215793037,216587173,217012690,217100869,219034658] · 19.12 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.83 ms