home / prices

product_market

3 rows where market_id = 3

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id market_id url
8 Cola 1,25L 70 ALDI Nord – Sortiment (online) 3 https://www.aldi-nord.de/produkt/original-taste-4039-0-0.article.html#/sortiment/markenprodukte
9 Volvic 1,5l Wasser 71 ALDI Nord – Sortiment (online) 3 https://www.aldi-nord.de/produkt/naturelle-1005297-0-0.article.html#/sortiment/markenprodukte
10 Volvic Vitamin+ Angebot 72 ALDI Nord – Sortiment (online) 3 https://www.aldi-nord.de/angebote/aktion-mo-20-10/vitamin-pfirsich-1035204-0-0.article.html

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE product_market (
  id INTEGER PRIMARY KEY,
  product_id INTEGER NOT NULL REFERENCES product(id),
  market_id INTEGER NOT NULL REFERENCES market(id),
  url TEXT NOT NULL,
  UNIQUE(product_id, market_id)
);
Powered by Datasette · Queries took 8.524ms