today_one_room (view)

Data license: ODbL · Data source: api.pik.ru

116 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: корпус, секция, площадь_м², статус, заселение, заселение (date), дата_среза (date)

Next page

CREATE VIEW today_one_room AS
SELECT
    f.id                      AS id,
    f.bulk_name               AS корпус,
    f.section_no              AS секция,
    f.floor                   AS этаж,
    f.area                    AS "площадь_м²",
    s.price                   AS цена,
    s.meter_price             AS "цена_за_м²",
    s.old_price               AS старая_цена,
    s.discount                AS скидка,
    s.status                  AS статус,
    s.finish                  AS отделка,
    s.mortgage_min_rate       AS "мин_ставка_%",
    s.mortgage_best_name      AS программа,
    f.settlement_date         AS заселение,
    f.name                    AS артикул,
    f.url                     AS ссылка,
    f.plan_url                AS планировка,
    s.scan_date               AS дата_среза
FROM flats f
JOIN snapshots s ON s.flat_id = f.id
WHERE s.scan_date = (
    SELECT MAX(scan_date) FROM snapshots
)
AND f.rooms = '1';