Skip to content

Instantly share code, notes, and snippets.

@vimagick
Created July 7, 2023 10:29
Show Gist options
  • Select an option

  • Save vimagick/c387b85ac972854dbd98265e42e5b76f to your computer and use it in GitHub Desktop.

Select an option

Save vimagick/c387b85ac972854dbd98265e42e5b76f to your computer and use it in GitHub Desktop.
#!/bin/bash
#
# https://kodi.wiki/view/Databases/MyVideos
#
echo "select strFilename, lastPlayed from files where playCount > 0 order by lastPlayed desc limit 10" |
sqlite3 ~/.kodi/userdata/Database/MyVideos121.db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment