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

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

<WRAP info>
**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.
</WRAP>