1 / SELECT pl.*, pt.*, c.* FROM playlist_rch AS pl LEFT JOIN playtitel AS pt ON (pl.titleID = pt.id ) LEFT JOIN cover AS c ON (pt.cover_id = c.id) WHERE pl.datum < '2023-01-31 21:50:00' AND pl.datum > '2023-01-31 20:50:00' GROUP BY pl.titleId ORDER BY pl.datum DESC LIMIT 24

a

b

11