home / prices

product_market

2 rows where product_id = 288

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id market_id url
29 Der große Bauer Joghurt 500g 288 ALDI Nord – Sortiment/Aktion 4 https://www.aldi-nord.de/angebote/aktion-sa-13-12/der-grosse-bauer-1012065-0-0.article.html
36 Der große Bauer Joghurt 500g 288 ALDI Süd – Sortiment/Aktion 52 https://www.aldi-sued.de/de/p.bauer-der-grosse-bauer--g-erdbeere.000000000608125001.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 7.744ms