v_preise (view)

587 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: produkt, haendler, markt, url, aktion, originalpreis, quelle, http_status, datum (date)

Next page

CREATE VIEW v_preise AS
SELECT
  p.name            AS produkt,
  r.name            AS haendler,
  m.name            AS markt,
  pm.url            AS url,
  po.observed_date  AS datum,
  po.price          AS preis,
  po.currency       AS waehrung,
  CASE WHEN po.is_promo=1 THEN 'JA' ELSE 'NEIN' END AS aktion,
  po.original_price AS originalpreis,
  po.promo_text     AS promo_text,
  po.source_type    AS quelle,
  po.http_status    AS http_status
FROM price_observation po
JOIN product_market pm ON pm.id = po.product_market_id
JOIN market m          ON m.id = pm.market_id
JOIN retailer r        ON r.id = m.retailer_id
JOIN product p         ON p.id = pm.product_id
ORDER BY p.name, po.observed_date;