cd “/Users/tjen/Library/Application Support/Plex Media Server/Plug-in Support/Databases”
sqlite3 com.plexapp.plugins.library.db
SELECT a.name AS “User”,
pl.title AS “Playlist Name”,
CAST(pqg.order / 1000 AS INT) AS “Order”,
(CASE WHEN pqg.metadata_item_id IS NULL THEN “[Smart Playlist]” ELSE pl_items.title END) AS “Item”
FROM metadata_items pl
INNER JOIN play_queue_generators pqg ON pqg.playlist_id=pl.id
LEFT JOIN metadata_items pl_items ON pl_items.id=pqg.metadata_item_id
INNER JOIN metadata_item_accounts mia ON mia.metadata_item_id=pl.id
INNER JOIN accounts a ON a.id=mia.account_id
WHERE pl.metadata_type=15
ORDER BY a.name, pl.title, pqg.order ASC;
src: