search

jacklul / pihole-updatelists

Update Pi-hole's lists from remote sources easily
MIT License
1.42k stars 82 forks source link

All adlist and whitelist comments are being ignored and using blacklist comment instead #114

Closed seanob86 closed 2 years ago

seanob86 commented 2 years ago

I have pihole-updatelists configured inside pihole docker container. I am using the dockerfile to build image per this.

FROM pihole/pihole:latest

RUN apt-get update && apt-get install -Vy wget php-cli php-sqlite3 php-intl php-curl

RUN wget -O - https://raw.githubusercontent.com/jacklul/pihole-updatelists/master/install.sh | bash /dev/stdin docker

Pihole image installed is 2022.08.2

Every thing works well and almost as expected, except the comments for the adlists and whitelist are not being used per the .conf file. It appears the same blacklist comment (pihole-updatelists - regex blacklist) is being used across all adlist, whitelist and blacklist.

Here is my pihole-updatelists.conf

; Pi-hole's Lists Updater by Jack'lul
; https://github.com/jacklul/pihole-updatelists
; For a full list of available variables please see the readme.

; Remote list URL containing list of adlists to import
; URLs to single adlists are not supported here!
ADLISTS_URL="https://v.firebog.net/hosts/lists.php?type=tick"
COMMENT="pihole-updatelists - firebog (tick)"

; Remote list URL containing exact domains to whitelist
WHITELIST_URL="https://raw.githubusercontent.com/anudeepND/whitelist/master/domains/whitelist.txt https://raw.githubusercontent.com/anudeepND/whitelist/master/domains/referral-sites.txt"
COMMENT="pihole-updatelists - whitelist"

; Remote list URL containing regex rules for blacklisting
REGEX_BLACKLIST_URL="https://raw.githubusercontent.com/mmotti/pihole-regex/master/regex.list"
COMMENT="pihole-updatelists - regex blacklist"

Example sqlite3 query from adlist

sqlite3 /etc/pihole/gravity.db "SELECT * FROM adlist" You can see pihole-updatelists - regex blacklist on each line below per adlist

80|https://v.firebog.net/hosts/static/w3kbl.txt|1|1661575101|1661575101|pihole-updatelists - regex blacklist|1661576273|356|0|2
81|https://adaway.org/hosts.txt|1|1661575101|1661575101|pihole-updatelists - regex blacklist|1661576274|7196|0|2
82|https://v.firebog.net/hosts/AdguardDNS.txt|1|1661575101|1661575101|pihole-updatelists - regex blacklist|1661576275|46921|0|2
83|https://v.firebog.net/hosts/Admiral.txt|1|1661575101|1661575101|pihole-updatelists - regex blacklist|1661576276|636|0|2
84|https://raw.githubusercontent.com/anudeepND/blacklist/master/adservers.txt|1|1661575101|1661575101|pihole-updatelists - regex blacklist|1661576277|42553|0|2
85|https://s3.amazonaws.com/lists.disconnect.me/simple_ad.txt|1|1661575101|1661575101|pihole-updatelists - regex blacklist|1661576278|2701|0|2

Per the .conf the expected comment for adlist should be pihole-updatelists - firebog (tick) however it is incorrectly adding the pihole-updatelists - regex blacklist comment.

Example sqlite3 query from my whitelist

sqlite3 /etc/pihole/gravity.db "SELECT * FROM domainlist" You can see pihole-updatelists - regex blacklist on each line below per whitelist

259|0|0.client-channel.google.com|1|1649828158|1649828158|pihole-updatelists - regex blacklist
260|0|1drv.com|1|1649828158|1649828158|pihole-updatelists - regex blacklist
261|0|2.android.pool.ntp.org|1|1649828158|1649828158|pihole-updatelists - regex blacklist
262|0|akamaihd.net|1|1649828158|1649828158|pihole-updatelists - regex blacklist

Per the .conf the expected comment for whitelists should be pihole-updatelists - whitelist however it is incorrectly adding the pihole-updatelists - regex blacklist comment.

Troubleshooting

  1. Removed adlists from pihole via the PiHole UI
  2. Ensured pihole-updatelists is up-to-date (which it already was)
  3. Executed pihole-updatelists to re-populate the adlists to pihole/gravity
  4. Verified that incorrect comment was still being added with the adlist.
seanob86 commented 2 years ago

Just to see output of pihole-updatelists --verbose --debug i can only see one comment being used.

Acquired process lock through file: /var/lock/pihole-updatelists.lock

      Pi-hole's Lists Updater by Jack'lul
 https://github.com/jacklul/pihole-updatelists

Checksum: 5ee607d9398e01b7c726664934fd94d0
Git branch: master
OS: Linux primary-pihole 5.15.56-v8+ #1575 SMP PREEMPT Fri Jul 22 20:31:26 BST 2022 aarch64
PHP: 7.4.30 NTS
SQLite: 3.34.1
cURL: 7.74.0
Pi-hole Core: v5.11.4-0-gaefbe1f (master)
Pi-hole Web: v5.13-0-g1714b08 (master)
Pi-hole FTL: v5.16.3 (master)
Configuration: array(19) {
  ["CONFIG_FILE"] => string(28) "/etc/pihole-updatelists.conf"
  ["GRAVITY_DB"] => string(22) "/etc/pihole/gravity.db"
  ["LOCK_FILE"] => string(33) "/var/lock/pihole-updatelists.lock"
  ["LOG_FILE"] => string(0) ""
  ["ADLISTS_URL"] => string(47) "https://v.firebog.net/hosts/lists.php?type=tick"
  ["WHITELIST_URL"] => string(170) "https://raw.githubusercontent.com/anudeepND/whitelist/master/domains/whitelist.txt https://raw.githubusercontent.com/anudeepND/whitelist/master/domains/referral-sites.txt"
  ["REGEX_WHITELIST_URL"] => string(0) ""
  ["BLACKLIST_URL"] => string(0) ""
  ["REGEX_BLACKLIST_URL"] => string(71) "https://raw.githubusercontent.com/mmotti/pihole-regex/master/regex.list"
  ["COMMENT"] => string(36) "pihole-updatelists - regex blacklist"
  ["GROUP_ID"] => int(0)
  ["PERSISTENT_GROUP"] => bool(true)
  ["REQUIRE_COMMENT"] => bool(true)
  ["UPDATE_GRAVITY"] => bool(true)
  ["VERBOSE"] => bool(true)
  ["DEBUG"] => bool(true)
  ["DOWNLOAD_TIMEOUT"] => int(60)
  ["IGNORE_DOWNLOAD_FAILURE"] => bool(false)
  ["GIT_BRANCH"] => string(6) "master"
}
Options: array(2) {
  ["verbose"] => bool(false)
  ["debug"] => bool(false)
}

Opened gravity database: /etc/pihole/gravity.db (88.14 MB)

SQL Query: SELECT * FROM `adlist`
SQL Query: SELECT * FROM `adlist_by_group`
Fetching ADLISTS from 'https://v.firebog.net/hosts/lists.php?type=tick'... done (30 entries)
Processing...
SQL Query: SELECT * FROM `adlist` WHERE `enabled` = 1 AND `comment` LIKE "%pihole-updatelists - regex blacklist%"
SQL Query: SELECT * FROM `adlist` LEFT JOIN `adlist_by_group` ON `adlist`.`id` = `adlist_by_group`.`adlist_id` WHERE `adlist`.`enabled` = 1 AND `adlist_by_group`.`group_id` = 0
Exists: https://raw.githubusercontent.com/PolishFiltersTeam/KADhosts/master/KADhosts.txt
Exists: https://raw.githubusercontent.com/FadeMind/hosts.extras/master/add.Spam/hosts
Exists: https://v.firebog.net/hosts/static/w3kbl.txt
Exists: https://adaway.org/hosts.txt
Exists: https://v.firebog.net/hosts/AdguardDNS.txt
Exists: https://v.firebog.net/hosts/Admiral.txt
Exists: https://raw.githubusercontent.com/anudeepND/blacklist/master/adservers.txt
Exists: https://s3.amazonaws.com/lists.disconnect.me/simple_ad.txt
Exists: https://v.firebog.net/hosts/Easylist.txt
Exists: https://pgl.yoyo.org/adservers/serverlist.php?hostformat=hosts&showintro=0&mimetype=plaintext
Exists: https://raw.githubusercontent.com/FadeMind/hosts.extras/master/UncheckyAds/hosts
Exists: https://raw.githubusercontent.com/bigdargon/hostsVN/master/hosts
Exists: https://v.firebog.net/hosts/Easyprivacy.txt
Exists: https://v.firebog.net/hosts/Prigent-Ads.txt
Exists: https://raw.githubusercontent.com/FadeMind/hosts.extras/master/add.2o7Net/hosts
Exists: https://raw.githubusercontent.com/crazy-max/WindowsSpyBlocker/master/data/hosts/spy.txt
Exists: https://hostfiles.frogeye.fr/firstparty-trackers-hosts.txt
Exists: https://raw.githubusercontent.com/DandelionSprout/adfilt/master/Alternate%20versions%20Anti-Malware%20List/AntiMalwareHosts.txt
Exists: https://osint.digitalside.it/Threat-Intel/lists/latestdomains.txt
Exists: https://s3.amazonaws.com/lists.disconnect.me/simple_malvertising.txt
Exists: https://v.firebog.net/hosts/Prigent-Crypto.txt
Exists: https://raw.githubusercontent.com/FadeMind/hosts.extras/master/add.Risk/hosts
Exists: https://bitbucket.org/ethanr/dns-blacklists/raw/8575c9f96e5b4a1308f2f12394abd86d0927a4a0/bad_lists/Mandiant_APT1_Report_Appendix_D.txt
Exists: https://phishing.army/download/phishing_army_blocklist_extended.txt
Exists: https://malware-filter.gitlab.io/malware-filter/phishing-filter-hosts.txt
Exists: https://gitlab.com/quidsup/notrack-blocklists/raw/master/notrack-malware.txt
Exists: https://raw.githubusercontent.com/Spam404/lists/master/main-blacklist.txt
Exists: https://raw.githubusercontent.com/AssoEchap/stalkerware-indicators/master/generated/hosts
Exists: https://urlhaus.abuse.ch/downloads/hostfile/
Exists: https://zerodot1.gitlab.io/CoinBlockerLists/hosts_browser
Summary: 30 exists

SQL Query: SELECT * FROM `domainlist`
SQL Query: SELECT * FROM `domainlist_by_group`
Fetching WHITELIST from 'https://raw.githubusercontent.com/anudeepND/whitelist/master/domains/whitelist.txt'... done
Fetching WHITELIST from 'https://raw.githubusercontent.com/anudeepND/whitelist/master/domains/referral-sites.txt'... done
Merging multiple lists... done (268 entries)
Processing...
SQL Query: SELECT * FROM `domainlist` WHERE `enabled` = 1 AND `type` = 0 AND `comment` LIKE "%pihole-updatelists - regex blacklist%"
SQL Query: SELECT * FROM `domainlist` LEFT JOIN `domainlist_by_group` ON `domainlist`.`id` = `domainlist_by_group`.`domainlist_id` WHERE `domainlist`.`enabled` = 1 AND `domainlist`.`type` = 0 AND `domainlist_by_group`.`group_id` = 0
Exists: 0.client-channel.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (259, 0)
Exists: 1drv.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (260, 0)
Exists: 2.android.pool.ntp.org
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (261, 0)
Exists: akamaihd.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (262, 0)
Exists: akamaitechnologies.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (263, 0)
Exists: akamaized.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (264, 0)
Exists: amazonaws.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (265, 0)
Exists: android.clients.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (266, 0)
Exists: api.ipify.org
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (267, 0)
Exists: api.rlje.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (268, 0)
Exists: app-api.ted.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (269, 0)
Exists: appleid.apple.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (270, 0)
Exists: apps.skype.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (271, 0)
Exists: appsbackup-pa.clients6.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (272, 0)
Exists: appsbackup-pa.googleapis.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (273, 0)
Exists: apt.sonarr.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (274, 0)
Exists: aspnetcdn.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (275, 0)
Exists: attestation.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (276, 0)
Exists: ax.phobos.apple.com.edgesuite.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (277, 0)
Exists: brightcove.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (278, 0)
Exists: c.s-microsoft.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (279, 0)
Exists: cdn.cloudflare.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (280, 0)
Exists: cdn.embedly.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (281, 0)
Exists: cdn.optimizely.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (282, 0)
Exists: cdn.vidible.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (283, 0)
Exists: cdn2.optimizely.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (284, 0)
Exists: cdn3.optimizely.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (285, 0)
Exists: cdnjs.cloudflare.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (286, 0)
Exists: cert.mgt.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (287, 0)
Exists: clientconfig.passport.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (288, 0)
Exists: clients1.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (289, 0)
Exists: clients2.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (290, 0)
Exists: clients3.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (291, 0)
Exists: clients4.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (292, 0)
Exists: clients5.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (293, 0)
Exists: clients6.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (294, 0)
Exists: cpms.spop10.ams.plex.bz
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (295, 0)
Exists: cpms35.spop10.ams.plex.bz
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (296, 0)
Exists: cse.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (297, 0)
Exists: ctldl.windowsupdate.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (298, 0)
Exists: d2c8v52ll5s99u.cloudfront.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (299, 0)
Exists: d2gatte9o95jao.cloudfront.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (300, 0)
Exists: dashboard.plex.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (301, 0)
Exists: dataplicity.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (302, 0)
Exists: def-vef.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (303, 0)
Exists: delivery.vidible.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (304, 0)
Exists: dev.virtualearth.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (305, 0)
Exists: device.auth.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (306, 0)
Exists: display.ugc.bazaarvoice.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (307, 0)
Exists: displaycatalog.mp.microsoft.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (308, 0)
Exists: dl.delivery.mp.microsoft.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (309, 0)
Exists: dl.dropbox.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (310, 0)
Exists: dl.dropboxusercontent.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (311, 0)
Exists: dns.msftncsi.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (590, 0)
Exists: download.sonarr.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (313, 0)
Exists: drift.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (314, 0)
Exists: driftt.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (315, 0)
Exists: dynupdate.no-ip.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (316, 0)
Exists: ecn.dev.virtualearth.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (317, 0)
Exists: edge.api.brightcove.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (318, 0)
Exists: eds.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (319, 0)
Exists: fonts.gstatic.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (320, 0)
Exists: forums.sonarr.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (321, 0)
Exists: g.live.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (322, 0)
Exists: geo-prod.do.dsp.mp.microsoft.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (323, 0)
Exists: geo3.ggpht.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (324, 0)
Exists: giphy.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (325, 0)
Exists: github.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (326, 0)
Exists: github.io
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (327, 0)
Exists: googleapis.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (328, 0)
Exists: gravatar.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (329, 0)
Exists: gstatic.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (330, 0)
Exists: help.ui.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (331, 0)
Exists: hls.ted.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (332, 0)
Exists: i.ytimg.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (333, 0)
Exists: i1.ytimg.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (334, 0)
Exists: imagesak.secureserver.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (335, 0)
Exists: img.vidible.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (336, 0)
Exists: imgix.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (337, 0)
Exists: imgs.xkcd.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (338, 0)
Exists: instantmessaging-pa.googleapis.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (339, 0)
Exists: intercom.io
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (340, 0)
Exists: jquery.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (341, 0)
Exists: jsdelivr.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (342, 0)
Exists: keystone.mwbsys.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (343, 0)
Exists: lastfm-img2.akamaized.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (344, 0)
Exists: licensing.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (345, 0)
Exists: live.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (346, 0)
Exists: login.live.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (347, 0)
Exists: login.microsoftonline.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (348, 0)
Exists: manifest.googlevideo.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (349, 0)
Exists: meta-db-worker02.pop.ric.plex.bz
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (350, 0)
Exists: meta.plex.bz
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (351, 0)
Exists: meta.plex.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (352, 0)
Exists: microsoftonline.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (353, 0)
Exists: msftncsi.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (354, 0)
Exists: my.plexapp.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (355, 0)
Exists: nexusrules.officeapps.live.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (356, 0)
Exists: npr-news.streaming.adswizz.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (357, 0)
Exists: nine.plugins.plexapp.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (358, 0)
Exists: no-ip.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (359, 0)
Exists: node.plexapp.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (360, 0)
Exists: notify.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (361, 0)
Exists: ns1.dropbox.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (362, 0)
Exists: ns2.dropbox.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (363, 0)
Exists: o1.email.plex.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (364, 0)
Exists: o2.sg0.plex.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (365, 0)
Exists: ocsp.apple.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (366, 0)
Exists: office.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (367, 0)
Exists: office.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (368, 0)
Exists: office365.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (369, 0)
Exists: officeclient.microsoft.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (370, 0)
Exists: om.cbsi.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (371, 0)
Exists: onedrive.live.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (372, 0)
Exists: outlook.live.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (373, 0)
Exists: outlook.office365.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (374, 0)
Exists: placehold.it
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (375, 0)
Exists: placeholdit.imgix.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (376, 0)
Exists: players.brightcove.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (377, 0)
Exists: pricelist.skype.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (378, 0)
Exists: products.office.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (379, 0)
Exists: proxy.plex.bz
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (380, 0)
Exists: proxy.plex.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (381, 0)
Exists: proxy02.pop.ord.plex.bz
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (382, 0)
Exists: pubsub.plex.bz
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (383, 0)
Exists: pubsub.plex.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (384, 0)
Exists: raw.githubusercontent.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (385, 0)
Exists: redirector.googlevideo.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (386, 0)
Exists: res.cloudinary.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (387, 0)
Exists: s.gateway.messenger.live.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (388, 0)
Exists: s.marketwatch.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (389, 0)
Exists: s.youtube.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (390, 0)
Exists: s.ytimg.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (391, 0)
Exists: s1.wp.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (392, 0)
Exists: s2.youtube.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (393, 0)
Exists: s3.amazonaws.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (394, 0)
Exists: sa.symcb.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (395, 0)
Exists: secure.avangate.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (396, 0)
Exists: secure.brightcove.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (397, 0)
Exists: secure.surveymonkey.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (398, 0)
Exists: services.sonarr.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (399, 0)
Exists: skyhook.sonarr.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (400, 0)
Exists: spclient.wg.spotify.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (401, 0)
Exists: ssl.p.jwpcdn.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (402, 0)
Exists: staging.plex.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (403, 0)
Exists: status.plex.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (404, 0)
Exists: t.co
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (405, 0)
Exists: t0.ssl.ak.dynamic.tiles.virtualearth.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (406, 0)
Exists: t0.ssl.ak.tiles.virtualearth.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (407, 0)
Exists: tawk.to
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (408, 0)
Exists: tedcdn.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (409, 0)
Exists: themoviedb.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (410, 0)
Exists: thetvdb.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (411, 0)
Exists: tinyurl.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (412, 0)
Exists: title.auth.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (413, 0)
Exists: title.mgt.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (414, 0)
Exists: traffic.libsyn.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (415, 0)
Exists: tvdb2.plex.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (416, 0)
Exists: tvthemes.plexapp.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (417, 0)
Exists: twimg.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (418, 0)
Exists: ui.skype.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (419, 0)
Exists: video-stats.l.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (420, 0)
Exists: videos.vidible.tv
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (421, 0)
Exists: widget-cdn.rpxnow.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (422, 0)
Exists: win10.ipv6.microsoft.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (423, 0)
Exists: wp.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (424, 0)
Exists: ws.audioscrobbler.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (425, 0)
Exists: www.dataplicity.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (426, 0)
Exists: www.googleapis.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (427, 0)
Exists: www.msftncsi.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (428, 0)
Exists: www.no-ip.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (429, 0)
Exists: www.youtube-nocookie.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (430, 0)
Exists: xbox.ipv6.microsoft.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (431, 0)
Exists: xboxexperiencesprod.experimentation.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (432, 0)
Exists: xflight.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (433, 0)
Exists: xkms.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (434, 0)
Exists: xsts.auth.xboxlive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (435, 0)
Exists: youtu.be
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (436, 0)
Exists: youtube-nocookie.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (437, 0)
Exists: yt3.ggpht.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (438, 0)
Exists: zee.cws.conviva.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (439, 0)
Exists: pings.conviva.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (440, 0)
Exists: cws.conviva.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (441, 0)
Exists: livepassdl.conviva.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (442, 0)
Exists: gfwsl.geforce.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (443, 0)
Exists: appspot-preview.l.google.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (444, 0)
Exists: vidtech.cbsinteractive.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (445, 0)
Exists: continuum.dds.microsoft.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (446, 0)
Exists: connectivitycheck.gstatic.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (447, 0)
Exists: connectivitycheck.android.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (448, 0)
Exists: www.msftconnecttest.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (449, 0)
Exists: 7eer.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (467, 0)
Exists: ad.doubleclick.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (468, 0)
Exists: affiliatefuture.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (469, 0)
Exists: anrdoezrs.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (470, 0)
Exists: apmebf.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (471, 0)
Exists: avantlink.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (472, 0)
Exists: bfast.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (473, 0)
Exists: cc-dt.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (474, 0)
Exists: cj.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (475, 0)
Exists: cj.dotomi.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (476, 0)
Exists: clickserve.cc-dt.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (477, 0)
Exists: commission-junction.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (478, 0)
Exists: doubleclick.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (479, 0)
Exists: dpbolvw.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (480, 0)
Exists: emjcd.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (481, 0)
Exists: evyy.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (482, 0)
Exists: gan.doubleclick.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (483, 0)
Exists: go.redirectingat.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (484, 0)
Exists: go2jump.org
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (485, 0)
Exists: gopjn.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (486, 0)
Exists: jdoqocy.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (487, 0)
Exists: kqzyfj.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (488, 0)
Exists: linksynergy.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (489, 0)
Exists: ojrq.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (490, 0)
Exists: onenetworkdirect.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (491, 0)
Exists: partners.webmasterplan.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (492, 0)
Exists: pjatr.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (493, 0)
Exists: pjtra.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (494, 0)
Exists: pntra.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (495, 0)
Exists: pntrac.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (496, 0)
Exists: pntrack.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (497, 0)
Exists: qksrv.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (498, 0)
Exists: redirect.at
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (499, 0)
Exists: redirect.viglink.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (500, 0)
Exists: redirectingat.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (501, 0)
Exists: shareasale.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (502, 0)
Exists: tkqlhce.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (503, 0)
Exists: www.7eer.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (504, 0)
Exists: www.affiliatefuture.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (505, 0)
Exists: www.anrdoezrs.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (506, 0)
Exists: www.apmebf.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (507, 0)
Exists: www.avantlink.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (508, 0)
Exists: www.bfast.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (509, 0)
Exists: www.cc-dt.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (510, 0)
Exists: www.cj.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (511, 0)
Exists: www.doubleclick.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (512, 0)
Exists: www.dpbolvw.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (513, 0)
Exists: www.emjcd.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (514, 0)
Exists: www.evyy.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (515, 0)
Exists: www.gopjn.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (516, 0)
Exists: www.jdoqocy.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (517, 0)
Exists: www.kqzyfj.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (518, 0)
Exists: www.linksynergy.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (519, 0)
Exists: www.ojrq.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (520, 0)
Exists: www.onenetworkdirect.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (521, 0)
Exists: www.pjatr.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (522, 0)
Exists: www.pjtra.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (523, 0)
Exists: www.pntra.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (524, 0)
Exists: www.pntrac.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (525, 0)
Exists: www.pntrack.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (526, 0)
Exists: www.qksrv.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (527, 0)
Exists: www.tkqlhce.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (528, 0)
Exists: tradetracker.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (529, 0)
Exists: www.tradetracker.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (530, 0)
Exists: click.linksynergy.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (531, 0)
Exists: clk.tradedoubler.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (532, 0)
Exists: tc.tradetracker.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (533, 0)
Exists: track.adform.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (534, 0)
Exists: track.webgains.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (535, 0)
Exists: ad.atdmt.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (536, 0)
Exists: clickserve.dartsearch.net
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (537, 0)
Exists: 5231.xg4ken.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (538, 0)
Exists: shareasale-analytics.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (539, 0)
Exists: www.kqzyfj.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (518, 0)
Exists: go.skimresources.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (540, 0)
Exists: goto-target-com.customtraffic.impactradius.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (541, 0)
Exists: goto.target.com
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (542, 0)
Summary: 267 exists

Fetching REGEX_BLACKLIST from 'https://raw.githubusercontent.com/mmotti/pihole-regex/master/regex.list'... done (14 entries)
Processing...
SQL Query: SELECT * FROM `domainlist` WHERE `enabled` = 1 AND `type` = 3 AND `comment` LIKE "%pihole-updatelists - regex blacklist%"
SQL Query: SELECT * FROM `domainlist` LEFT JOIN `domainlist_by_group` ON `domainlist`.`id` = `domainlist_by_group`.`domainlist_id` WHERE `domainlist`.`enabled` = 1 AND `domainlist`.`type` = 3 AND `domainlist_by_group`.`group_id` = 0
Exists: ^ad([sxv]?[0-9]*|system)[_.-]([^.[:space:]]+\.){1,}|[_.-]ad([sxv]?[0-9]*|system)[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (450, 0)
Exists: ^(.+[_.-])?adse?rv(er?|ice)?s?[0-9]*[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (451, 0)
Exists: ^(.+[_.-])?telemetry[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (452, 0)
Exists: ^adim(age|g)s?[0-9]*[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (453, 0)
Exists: ^adtrack(er|ing)?[0-9]*[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (454, 0)
Exists: ^advert(s|is(ing|ements?))?[0-9]*[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (455, 0)
Exists: ^aff(iliat(es?|ion))?[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (456, 0)
Exists: ^analytics?[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (457, 0)
Exists: ^banners?[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (458, 0)
Exists: ^beacons?[0-9]*[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (459, 0)
Exists: ^count(ers?)?[0-9]*[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (460, 0)
Exists: ^mads\.
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (461, 0)
Exists: ^pixels?[-.]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (462, 0)
Exists: ^stat(s|istics)?[0-9]*[_.-]
SQL Query: INSERT OR IGNORE INTO `domainlist_by_group` (domainlist_id, group_id) VALUES (463, 0)
Summary: 14 exists
seanob86 commented 2 years ago

So figured it out 😅.... must use sections 😁