pickupdate_street (view)

367,160 rows

✎ View and edit SQL

This data as json, v1_json, CSV (advanced)

Suggested facets: start (date), end (date)

Next page

CREATE VIEW pickupdate_street as select s.name as street, z.zipcode as zipcode, pickupdate.date as start,
date(pickupdate.date, "+1 day") as end, d.name as district, "Gelber Sack Abholtermin" as summary
from pickupdate join area as a on pickupdate.area_id=a.id join zipcode as z on s.zipcode_id=z.id
join street as s on a.id=s.schaalundmueller_district_id join district as d on s.district_id=d.id;