Продать

Back to the, Дрогобыч

10 объявлений

AMP
Фильтры
Amy Winehouse – Back To Black (2006, E.U. / U.S.A.)
920 ₴
920.0

Amy Winehouse – Back To Black (2006, E.U. / U.S.A.)

Amy Winehouse – Back To Black Barcode: 6 02517 13041 8 Made in the E.U. Condition: M / M 920 ₴ --- Amy Winehouse – Back To Black Matrix / Runout: 06025 171 421-1 01 51813779 [4x Universal logo] Made in Germany by EDC D Mastering SID Code: IFPI LV26 Mould SID Code: IFPI 0123 Barcode: 6 02517 14211 4…

Дрогобыч · 6 дней
Marty Willson-Piper – Rhyme (1989, U.S.A.)
960 ₴
960.0

Marty Willson-Piper – Rhyme (1989, U.S.A.)

Marty Willson-Piper – Rhyme Matrix / Runout: RCD10114 01! Other (Mould area): MADE IN USA BY PDO Made in U.S.A. U.S. First Press Condition: M / M- Каталог фірмових CD (в наявності) Частина 5 Sabre, Maverick – Lonely Are The Brave (2012, E.U.) Sade – Diamond Life (1984, E.U. / U.S.A.) – Stronger Than…

Дрогобыч · 22.09.2026
Daniel Boucher – Dix Mille Matins (1999, Canada)
440 ₴
440.0

Daniel Boucher – Dix Mille Matins (1999, Canada)

Daniel Boucher ‎– Dix Mille Matins Matrix / Runout: 235F1 GSIC984 MFG BY RSB Barcode: 0 55490 09842 6 Made in Canada Canadian First Press Condition: M / M- Каталог фірмових CD (в наявності) Частина 1 A$AP Rocky – Long.Live.A$AP (2013, E.U.) – At.Long.Last.A$AP (2015, U.S.A.) ABBA – More ABBA Gold: M…

Дрогобыч · 22.09.2026
James Vincent McMorrow – Early In The Morning / 2 CD (2012, U.K.)
720 ₴
720.0

James Vincent McMorrow – Early In The Morning / 2 CD (2012, U.K.)

James Vincent McMorrow – Early In The Morning / 2 CD Matrix / Runout (CD 1): ABS BLVDIG01 Mastering SID Code: IFPI LT23 Matrix / Runout (CD 2): ABS BLVDIG01S-2 Mastering SID Code: IFPI LP78 Barcode: 5 0373******596 Made in U.K. Condition: M, M / M- Каталог фірмових CD (в наявності) Частина 3 Horrors…

Дрогобыч · 28.12.2025
Enfant Sauvage – Petrichor (2021, France)
1 190 ₴
1190.0

Enfant Sauvage – Petrichor (2021, France)

Enfant Sauvage – Petrichor Barcode: 3 700187 675332 Made in France Condition: M / M Каталог фірмових CD (в наявності) Частина 4 Naughty By Nature – Naughty By Nature (1991, Germany) Nazareth – The Ultimate Collection / 3 CD (2020, U.K.) Neighbourhood, The – I Love You (2013, E.U.) New Order – Low-li…

Дрогобыч · 28.12.2025
UNKLE – The Road: Part II / Lost Highway / 2 CD (2019, U.K.)
1 090 ₴
1090.0

UNKLE – The Road: Part II / Lost Highway / 2 CD (2019, U.K.)

UNKLE – The Road: Part II / Lost Highway / 2 CD (2019, U.K.) Barcode (Text from sticker on shrink): 0 193******2098 Made in U.K. Condition: NEW / SEALED Каталог фірмових CD (в наявності) Частина 3 Horrors, The – Primary Colours (2009, E.U.) Horse – The Same Sky (1990, U.K. / U.S.A.) Howard, Ben – Ev…

Дрогобыч · 26.06.2025
Книга Someone Else’s Shoes авторки Jojo Moyes
350 ₴
350.0

Книга Someone Else’s Shoes авторки Jojo Moyes

Книга Червоні лубутени авторки Джоджо Мойєс англійською мовою Опис книги The brand-new novel from the International No 1 Bestselling phenomenon and author of Me Before You and The Giver of Stars. Nisha Cantor and Sam Kemp are two very different women. Nisha, 45, lives the globetrotting life of the s…

Дрогобыч · 06.03.2026
Blasphemous Rumours – An Electronic Tribute To DM (2002, U.K.)
1 080 ₴
1080.0

Blasphemous Rumours – An Electronic Tribute To DM (2002, U.K.)

Blasphemous Rumours – An Electronic Tribute To Depeche Mode Matrix / Runout: SONOPRESS 50512921/CDMGRAM163 01 Barcode: 5 0139******327 Made in Germany Condition: M / M- Каталог фірмових CD (в наявності) Частина 2 Dead Can Dance – Spleen and Ideal (1985, U.K.) – Within The Realm Of A Dying Sun (1987,…

Дрогобыч · 20.07.2025
Lana Del Rey – Chemtrails Over The Country Club (2021, U.S.A.)
940 ₴
940.0

Lana Del Rey – Chemtrails Over The Country Club (2021, U.S.A.)

Lana Del Rey – Chemtrails Over The Country Club Barcode: 6 02435 49781 5 Made in U.S.A. Condition: NEW / SEALED Каталог фірмових CD (в наявності) Частина 2 Dead Can Dance – Spleen and Ideal (1985, U.K.) – Within The Realm Of A Dying Sun (1987, U.K.) – The Serpent's Egg (1988, U.S.A.) – Aion (1990, U…

Дрогобыч · 30.01.2025
Cat Power – Jukebox (2008, U.S.A.)
840 ₴
840.0

Cat Power – Jukebox (2008, U.S.A.)

Cat Power – Jukebox Matrix / Runout: LN OLE 754-2 TEXT 01 M1S2 Mastering SID Code: ifpi L909 Mould SID Code: IFPI 2U9B Barcode: 7 44861 07542 4 Made in U.S.A. Condition: M / M Каталог фірмових CD (в наявності) Частина 2 Dead Can Dance – Spleen and Ideal (1985, U.K.) – Within The Realm Of A Dying Sun…

Дрогобыч · 28.12.2025

Похожие запросы

Объявления по областям

OK · 81.3 ms · SQL 8 (31.3 ms) · ES 1 (29.9 ms) · PHP 8.5.12 · 0.9 MB

Нотатки

Маршрут: категорія —, місто city #2181 · ES: всього 10, id на сторінці: 10 · знайдено в БД: 10

Elasticsearch

POST /abyhomcom/_search → 200 · 29.9 ms · знайдено 10, повернуто 10
тіло запиту
{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "back to the",
                        "fields": [
                            "name^3",
                            "description",
                            "city^2"
                        ],
                        "type": "best_fields",
                        "operator": "and",
                        "fuzziness": "AUTO",
                        "prefix_length": 2
                    }
                }
            ],
            "filter": [
                {
                    "term": {
                        "city_id": 2181
                    }
                }
            ]
        }
    },
    "sort": [
        "_score",
        {
            "data_post": {
                "order": "desc"
            }
        }
    ],
    "from": 0,
    "size": 50,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true,
    "aggs": {
        "cats": {
            "terms": {
                "field": "category_id",
                "size": 2000
            }
        }
    }
}

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 1.34 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["drogobych","\/drogobych","drogobych\/","\/drogobych\/"] · 4.48 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.65 ms
SHOW TABLES · 3 ms
SELECT 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, ''), NULLIF(c.name_ua, '')) 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) [219104087,217050412,217050397,199872199,199872073,185107884,204270132,187224804,171630934,199871857] · 16.95 ms
SELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [171630934,185107884,187224804,199871857,199872073,199872199,204270132,217050397,217050412,219104087] · 1.76 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 0.92 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 2.2 ms