🔍Easily query the RARBG torrent sqlite database.

RARBG DB Magnet Search View.sql

-- View to easily query the leaked RARBG torrent DB.
CREATE VIEW magnet_links as
SELECT id, title, cat, size, 'magnet:?xt=urn:btih:' || hash as magnetLink, imdb, dt
FROM items
ORDER BY dt DESC;

-- Example query:
SELECT * FROM magnet_links
         WHERE title LIKE '%Apocalypse.Now.1979.Theatrical%'
         LIMIT 501