SELECT a.scan_uuid, a.gtin, a.scan_date, a.user_uuid, a.found, a.lat, a.lon, a.cnt, b.pbm_warengruppe_id FROM `SCAN` as a left join SCAN_MATKL as b on a.gtin = b.gtin where DATE(a.scan_date) = '2021-04-08' group by a.scan_uuid order by a.scan_date limit 500

DB	Date Filtern	Pic	lat/lon