Pi-Hole - Block Lists - Extract the domains from the long-term database

sqlite3 /etc/pihole/pihole-FTL.db "SELECT domain FROM queries LIMIT 100000;" > domains.list

NOTE: This will generate a list file with up to 100,000 domains.

They are extracted into the domains.list file as they are recorded in the database.

There will be lots of frequently queried domains as well as some blocked ad domains.