jensheidrich.de
  • Home
  • Kategorien
  • Tags
  • Archiv
  • Wunschliste

TOP 10 from your Mixxx-History

Get your top 10 from the last year mixxx history

sqlite> SELECT COUNT(l.id), l.artist, l.title FROM Playlists p, PlaylistTracks t, library l ON t.playlist_id=p.id WHERE strftime('%Y',p.date_modified)=strftime('%Y', date('now', '-1 year')) AND p.hidden=2 AND t.track_id=l.id GROUP BY l.id ORDER BY COUNT(l.id) DESC LIMIT 10;

Share on: Twitter ❄ Facebook ❄ E-Mail

  • « Host not found

Datum

03.12.2020

Letztes Update

2020-12-03 11:16:13+01:00

Kategorie

Hack

Tags

  • mixxx 1
  • playlist 1
  • sqlite 1
  • top 1
  • jensheidrich.de - parts of a memory dump
  • Impressum Datenschutz
  • Powered by Pelican. Theme: Elegant by Talha Mansoor