Ads.txt Normalization Mappings

From IAB TechLab Wiki
Jump to: navigation, search

This list does not imply that any of the ad systems have been vetted or certified. An advertising system's inclusion or exclusion on this list should not bear any meaning for business policy. Publishers should be vigilant when determining which advertising systems to include in their ads.txt file.

There are two tables in this data set:

  • "adsystem": This table is a list of all known ad systems (i.e. SSPs/exchanges). There is no order or meaning implied by the ID, it is merely an auto incrementing number. "CANONICAL_DOMAIN" is the domain that the exchange has declared to be canonical (i.e. what should be used in ads.txt files). Where it is not known, CANONICAL_DOMAIN is NULL. Exchanges are encouraged to edit this page and add their canonical domain.
  • "adsystem_domain": This table is a list of all known domains from field #1 of publisher ads.txt files. "ID" is a foreign key referencing the ad system's ID from the "adsystem" table. Note that this table is not an endorsement of the domains used. It is intended to allow for handling of misspellings, mistakes, etc. The official domain is indicated in the "adsystem" table under "CANONICAL_DOMAIN" where known.

This data set is designed to be easily used with the reference crawler. If imported into the SQLite database, for example, the following query could be used to output crawler data with variations normalized to the ad system ID:

SELECT adstxt.site_domain, 
       adstxt.exchange_domain,
       adsystem.id, 
       adsystem.name, 
       adstxt.seller_account_id, 
       adstxt.account_type 
FROM   adstxt 
       LEFT JOIN adsystem_domain 
              ON adstxt.exchange_domain = adsystem_domain.domain 
       LEFT JOIN adsystem 
              ON adsystem_domain.id = adsystem.id; 

With one further table and join, DSPs can easily map the data to their internal identifers for each exchange.

Please feel free to contribute mapping information here.

"adsystem" table

Due to current limitations on the wiki, these are presented inline as SQL.

DROP TABLE IF EXISTS adsystem;
CREATE TABLE "adsystem" (
	`ID`	INTEGER,
	`NAME`	TEXT,
	`CANONICAL_DOMAIN`	TEXT,
	PRIMARY KEY(`ID`)
);
INSERT INTO `adsystem` VALUES (1,'Rubicon Project','rubiconproject.com');
INSERT INTO `adsystem` VALUES (2,'33Across',NULL);
INSERT INTO `adsystem` VALUES (3,'PubMatic','pubmatic.com');
INSERT INTO `adsystem` VALUES (4,'OpenX','openx.com');
INSERT INTO `adsystem` VALUES (5,'Facebook',NULL);
INSERT INTO `adsystem` VALUES (6,'GumGum',NULL);
INSERT INTO `adsystem` VALUES (7,'Kargo',NULL);
INSERT INTO `adsystem` VALUES (8,'Google','google.com');
INSERT INTO `adsystem` VALUES (9,'bRealtime',NULL);
INSERT INTO `adsystem` VALUES (10,'Amazon',NULL);
INSERT INTO `adsystem` VALUES (11,'One by AOL: Display','adtech.com, aolcloud.net');
INSERT INTO `adsystem` VALUES (12,'LiveIntent',NULL);
INSERT INTO `adsystem` VALUES (13,'Yieldmo',NULL);
INSERT INTO `adsystem` VALUES (14,'MoPub',NULL);
INSERT INTO `adsystem` VALUES (15,'One by AOL: Mobile','aol.com');
INSERT INTO `adsystem` VALUES (16,'SmartStream',NULL);
INSERT INTO `adsystem` VALUES (17,'Smaato',NULL);
INSERT INTO `adsystem` VALUES (18,'Taboola',NULL);
INSERT INTO `adsystem` VALUES (19,'TrustX',NULL);
INSERT INTO `adsystem` VALUES (20,'LKQD',NULL);
INSERT INTO `adsystem` VALUES (21,'Criteo',NULL);
INSERT INTO `adsystem` VALUES (22,'Exponential',NULL);
INSERT INTO `adsystem` VALUES (23,'Sovrn',NULL);
INSERT INTO `adsystem` VALUES (24,'RhythmOne',NULL);
INSERT INTO `adsystem` VALUES (25,'Yieldbot',NULL);
INSERT INTO `adsystem` VALUES (26,'Technorati',NULL);
INSERT INTO `adsystem` VALUES (27,'Bidfluence',NULL);
INSERT INTO `adsystem` VALUES (28,'Switch Concepts',NULL);
INSERT INTO `adsystem` VALUES (29,'BrightRoll from Yahoo!','btrll.com');
INSERT INTO `adsystem` VALUES (30,'Conversant',NULL);
INSERT INTO `adsystem` VALUES (31,'Sonobi',NULL);
INSERT INTO `adsystem` VALUES (32,'Spoutable',NULL);
INSERT INTO `adsystem` VALUES (33,'FreeWheel','freewheel.tv');
INSERT INTO `adsystem` VALUES (34,'Connatix',NULL);
INSERT INTO `adsystem` VALUES (35,'Centro Brand Exchange',NULL);
INSERT INTO `adsystem` VALUES (36,'Positive Mobile',NULL);
INSERT INTO `adsystem` VALUES (37,'MemeGlobal',NULL);
INSERT INTO `adsystem` VALUES (38,'Kixer',NULL);
INSERT INTO `adsystem` VALUES (39,'Sekindo',NULL);
INSERT INTO `adsystem` VALUES (40,'Improve Digital','improvedigital.com');
INSERT INTO `adsystem` VALUES (41,'AdForm',NULL);
INSERT INTO `adsystem` VALUES (42,'MADS',NULL);
INSERT INTO `adsystem` VALUES (43,'Inneractive','inner-active.com');
INSERT INTO `adsystem` VALUES (44,'SpotX','spotx.tv,spotxchange.com');
INSERT INTO `adsystem` VALUES (45,'StreamRail',NULL);
INSERT INTO `adsystem` VALUES (46,'MediaMath',NULL);
INSERT INTO `adsystem` VALUES (47,'AdYouLike',NULL);
INSERT INTO `adsystem` VALUES (48,'Index Exchange','indexexchange.com');
INSERT INTO `adsystem` VALUES (49,'e-Planning',NULL);
INSERT INTO `adsystem` VALUES (50,'Kiosked',NULL);
INSERT INTO `adsystem` VALUES (51,'UnrulyX',NULL);
INSERT INTO `adsystem` VALUES (52,'Brightcom',NULL);
INSERT INTO `adsystem` VALUES (53,'PowerInbox',NULL);
INSERT INTO `adsystem` VALUES (54,'Fyber','fyber.com');
INSERT INTO `adsystem` VALUES (55,'TidalTV',NULL);
INSERT INTO `adsystem` VALUES (56,'Nativo',NULL);
INSERT INTO `adsystem` VALUES (57,'Media.net',NULL);
INSERT INTO `adsystem` VALUES (58,'YuMe',NULL);
INSERT INTO `adsystem` VALUES (59,'RevContent',NULL);
INSERT INTO `adsystem` VALUES (60,'Outbrain',NULL);
INSERT INTO `adsystem` VALUES (61,'Zedo','zedo.com');
INSERT INTO `adsystem` VALUES (62,'SlimCut Media',NULL);
INSERT INTO `adsystem` VALUES (63,'Bidtellect',NULL);
INSERT INTO `adsystem` VALUES (64,'Smart RTB+','smartadserver.com');
INSERT INTO `adsystem` VALUES (65,'LoopMe','loopme.com');
INSERT INTO `adsystem` VALUES (66,'Vidazoo',NULL);
INSERT INTO `adsystem` VALUES (67,'Videoflare',NULL);
INSERT INTO `adsystem` VALUES (68,'Gemini from Yahoo!','yahoo.com');
INSERT INTO `adsystem` VALUES (69,'PixFuture',NULL);
INSERT INTO `adsystem` VALUES (70,'OMS',NULL);
INSERT INTO `adsystem` VALUES (71,'Ströer',NULL);
INSERT INTO `adsystem` VALUES (73,'C1X',NULL);
INSERT INTO `adsystem` VALUES (74,'Synacor',NULL);
INSERT INTO `adsystem` VALUES (76,'Videology',NULL);
INSERT INTO `adsystem` VALUES (77,'Telaria (fka Tremor Video)','tremorhub.com');
INSERT INTO `adsystem` VALUES (78,'Genesis Media','altitude-arena.com');
INSERT INTO `adsystem` VALUES (80,'Imonomy',NULL);
INSERT INTO `adsystem` VALUES (81,'Komoona',NULL);
INSERT INTO `adsystem` VALUES (82,'SpringServe',NULL);
INSERT INTO `adsystem` VALUES (83,'TripleLift',NULL);
INSERT INTO `adsystem` VALUES (84,'AppNexus','appnexus.com');
INSERT INTO `adsystem` VALUES (85,'NTV',NULL);
INSERT INTO `adsystem` VALUES (86,'COMET',NULL);
INSERT INTO `adsystem` VALUES (87,'Undertone',NULL);
INSERT INTO `adsystem` VALUES (88,'One by AOL: Video','advertising.com');
INSERT INTO `adsystem` VALUES (89,'Algovid',NULL);
INSERT INTO `adsystem` VALUES (90,'Lockerdome',NULL);
INSERT INTO `adsystem` VALUES (91,'Widespace',NULL);
INSERT INTO `adsystem` VALUES (92,'Sortable',NULL);
INSERT INTO `adsystem` VALUES (93,'Mobfox',NULL);
INSERT INTO `adsystem` VALUES (94,'Teads','teads.tv');
INSERT INTO `adsystem` VALUES (95,'PulsePoint','contextweb.com');
INSERT INTO `adsystem` VALUES (96,'District M',NULL);
INSERT INTO `adsystem` VALUES (97,'Sharethrough',NULL);
INSERT INTO `adsystem` VALUES (98,'Adfrontiers',NULL);
INSERT INTO `adsystem` VALUES (99,'Ad3media',NULL);
INSERT INTO `adsystem` VALUES (100,'ADMIZED',NULL);
INSERT INTO `adsystem` VALUES (101,'Twiago',NULL);
INSERT INTO `adsystem` VALUES (102,'Xapads',NULL);
INSERT INTO `adsystem` VALUES (104,'Adstir',NULL);
INSERT INTO `adsystem` VALUES (105,'Yieldlab',NULL);
INSERT INTO `adsystem` VALUES (107,'Ad6Media',NULL);
INSERT INTO `adsystem` VALUES (108,'Adbistro',NULL);
INSERT INTO `adsystem` VALUES (109,'AdColony',NULL);
INSERT INTO `adsystem` VALUES (110,'Fluct',NULL);
INSERT INTO `adsystem` VALUES (111,'Adman Media',NULL);
INSERT INTO `adsystem` VALUES (112,'AdMedia',NULL);
INSERT INTO `adsystem` VALUES (113,'AdMixer',NULL);
INSERT INTO `adsystem` VALUES (114,'NOT IN USE',NULL);
INSERT INTO `adsystem` VALUES (115,'Ads4Pics',NULL);
INSERT INTO `adsystem` VALUES (117,'Adunity',NULL);
INSERT INTO `adsystem` VALUES (118,'AMM Media Marketing',NULL);
INSERT INTO `adsystem` VALUES (119,'Advertise.com',NULL);
INSERT INTO `adsystem` VALUES (120,'Aerserv',NULL);
INSERT INTO `adsystem` VALUES (121,'AndBeyond.Media',NULL);
INSERT INTO `adsystem` VALUES (122,'appTV',NULL);
INSERT INTO `adsystem` VALUES (123,'ucfunnel',NULL);
INSERT INTO `adsystem` VALUES (124,'WideOrbit',NULL);
INSERT INTO `adsystem` VALUES (125,'Aximus',NULL);
INSERT INTO `adsystem` VALUES (126,'BaronsMedia',NULL);
INSERT INTO `adsystem` VALUES (128,'Streamlyn',NULL);
INSERT INTO `adsystem` VALUES (129,'Bidtheater',NULL);
INSERT INTO `adsystem` VALUES (131,'Buy Sell Ads',NULL);
INSERT INTO `adsystem` VALUES (132,'Carambola',NULL);
INSERT INTO `adsystem` VALUES (133,'Cedato',NULL);
INSERT INTO `adsystem` VALUES (134,'Clickio',NULL);
INSERT INTO `adsystem` VALUES (135,'Collective',NULL);
INSERT INTO `adsystem` VALUES (136,'Adimia',NULL);
INSERT INTO `adsystem` VALUES (137,'Converge-Digital',NULL);
INSERT INTO `adsystem` VALUES (138,'Crimtan',NULL);
INSERT INTO `adsystem` VALUES (139,'Defy',NULL);
INSERT INTO `adsystem` VALUES (141,'DistroScale',NULL);
INSERT INTO `adsystem` VALUES (142,'DynAdmic',NULL);
INSERT INTO `adsystem` VALUES (144,'EADV',NULL);
INSERT INTO `adsystem` VALUES (145,'Easy Platform',NULL);
INSERT INTO `adsystem` VALUES (146,'eBoundServices',NULL);
INSERT INTO `adsystem` VALUES (147,'Electric Sheep',NULL);
INSERT INTO `adsystem` VALUES (148,'FirstImpression.io',NULL);
INSERT INTO `adsystem` VALUES (149,'Exclude',NULL);
INSERT INTO `adsystem` VALUES (150,'Get Intent',NULL);
INSERT INTO `adsystem` VALUES (151,'Glu Company',NULL);
INSERT INTO `adsystem` VALUES (152,'GMO SSP',NULL);
INSERT INTO `adsystem` VALUES (153,'Browsi',NULL);
INSERT INTO `adsystem` VALUES (154,'Gourmet Ads',NULL);
INSERT INTO `adsystem` VALUES (155,'Hiro Media',NULL);
INSERT INTO `adsystem` VALUES (156,'iBillboard',NULL);
INSERT INTO `adsystem` VALUES (157,'Increase Rev',NULL);
INSERT INTO `adsystem` VALUES (158,'Infolinks',NULL);
INSERT INTO `adsystem` VALUES (159,'Insticator',NULL);
INSERT INTO `adsystem` VALUES (160,'JustPremium',NULL);
INSERT INTO `adsystem` VALUES (161,'JWPlayer',NULL);
INSERT INTO `adsystem` VALUES (162,'KeenKale',NULL);
INSERT INTO `adsystem` VALUES (163,'Lifestreet',NULL);
INSERT INTO `adsystem` VALUES (164,'Linicom',NULL);
INSERT INTO `adsystem` VALUES (165,'MadAdsMedia',NULL);
INSERT INTO `adsystem` VALUES (166,'Vuble','mediabong.com');
INSERT INTO `adsystem` VALUES (167,'Deguate',NULL);
INSERT INTO `adsystem` VALUES (169,'Mgid',NULL);
INSERT INTO `adsystem` VALUES (170,'Monarch Ads',NULL);
INSERT INTO `adsystem` VALUES (171,'Netseer',NULL);
INSERT INTO `adsystem` VALUES (173,'Ooyala',NULL);
INSERT INTO `adsystem` VALUES (174,'Optimatic',NULL);
INSERT INTO `adsystem` VALUES (175,'Padsquad',NULL);
INSERT INTO `adsystem` VALUES (176,'Paypal',NULL);
INSERT INTO `adsystem` VALUES (177,'Playtouch',NULL);
INSERT INTO `adsystem` VALUES (178,'Paywire',NULL);
INSERT INTO `adsystem` VALUES (179,'PowerLinks',NULL);
INSERT INTO `adsystem` VALUES (180,'NexTag',NULL);
INSERT INTO `adsystem` VALUES (181,'Purch',NULL);
INSERT INTO `adsystem` VALUES (182,'Q1 Media',NULL);
INSERT INTO `adsystem` VALUES (183,'Quantcast',NULL);
INSERT INTO `adsystem` VALUES (184,'Quantum Native',NULL);
INSERT INTO `adsystem` VALUES (185,'ReklamStore',NULL);
INSERT INTO `adsystem` VALUES (186,'RekMob',NULL);
INSERT INTO `adsystem` VALUES (188,'Smartclip',NULL);
INSERT INTO `adsystem` VALUES (189,'Smarty Ads',NULL);
INSERT INTO `adsystem` VALUES (190,'Somo Audience','somoaudience.com');
INSERT INTO `adsystem` VALUES (191,'Spot.im',NULL);
INSERT INTO `adsystem` VALUES (192,'Sprout',NULL);
INSERT INTO `adsystem` VALUES (193,'SSPHwy',NULL);
INSERT INTO `adsystem` VALUES (194,'StartApp',NULL);
INSERT INTO `adsystem` VALUES (195,'SNT Media',NULL);
INSERT INTO `adsystem` VALUES (196,'TabletMedia',NULL);
INSERT INTO `adsystem` VALUES (197,'Tappx',NULL);
INSERT INTO `adsystem` VALUES (198,'The Moneytizer',NULL);
INSERT INTO `adsystem` VALUES (199,'The Trade Desk',NULL);
INSERT INTO `adsystem` VALUES (200,'Thrive',NULL);
INSERT INTO `adsystem` VALUES (201,'Tisoomi',NULL);
INSERT INTO `adsystem` VALUES (202,'Tribal Fusion',NULL);
INSERT INTO `adsystem` VALUES (203,'Trion Interactive',NULL);
INSERT INTO `adsystem` VALUES (204,'TrueX',NULL);
INSERT INTO `adsystem` VALUES (205,'Turf Digital',NULL);
INSERT INTO `adsystem` VALUES (206,'UBM',NULL);
INSERT INTO `adsystem` VALUES (207,'Underdog Media',NULL);
INSERT INTO `adsystem` VALUES (208,'Alliance Data',NULL);
INSERT INTO `adsystem` VALUES (209,'Verta Media',NULL);
INSERT INTO `adsystem` VALUES (210,'Vertoz',NULL);
INSERT INTO `adsystem` VALUES (211,'Video Intelligence',NULL);
INSERT INTO `adsystem` VALUES (212,'Fidelity Media',NULL);
INSERT INTO `adsystem` VALUES (213,'Yandex',NULL);
INSERT INTO `adsystem` VALUES (214,'Yellow Hammer',NULL);
INSERT INTO `adsystem` VALUES (215,'RockYou','rockyou.net');
INSERT INTO `adsystem` VALUES (216,'Innity','innity.com');
INSERT INTO `adsystem` VALUES (217,'Native Ads','nativeads.com');
INSERT INTO `adsystem` VALUES (218,'RichAudience','richaudience.com');
INSERT INTO `adsystem` VALUES (219,'AdStanding','adstanding.com');
INSERT INTO `adsystem` VALUES (220,'Mass2','www.mass2.com');
INSERT INTO `adsystem` VALUES (221,'RTK.io','NULL');
INSERT INTO `adsystem` VALUES (222,'Atomx','atomx.com');
INSERT INTO `adsystem` VALUES (223,'Addroplet.com ','Addroplet.com ');
INSERT INTO `adsystem` VALUES (224,'Liondigitalserving.com','Liondigitalserving.com');
INSERT INTO `adsystem` VALUES (225,'sulvo.com','sulvo.com');
INSERT INTO `adsystem` VALUES (226,'surgeprice.com','surgeprice.com');
INSERT INTO `adsystem` VALUES (227,'mediabong.com','mediabong.com');
INSERT INTO `adsystem` VALUES (228,'Seracast','babaroll.com');
INSERT INTO `adsystem` VALUES (229,'Juice Nectar','juicenectar.com');
INSERT INTO `adsystem` VALUES (230,'AdPone','adpone.com');
INSERT INTO `adsystem` VALUES (231,'OneTag','onetag.com');
INSERT INTO `adsystem` VALUES (232,'Between Exchange','betweendigital.com');
INSERT INTO `adsystem` VALUES (233,'Experian','experian.com');
INSERT INTO `adsystem` VALUES (234,'GammaSSP','gammassp.com');
INSERT INTO `adsystem` VALUES (235,'Cynogage','cynogage.com');
INSERT INTO `adsystem` VALUES (236,'DeepIntent','deepintent.com');
INSERT INTO `adsystem` VALUES (237,'Adversal','adversal.com');
INSERT INTO `adsystem` VALUES (238,'vmg.host','vmg.host');
INSERT INTO `adsystem` VALUES (239,'Vdopia','null');
INSERT INTO `adsystem` VALUES (240,'Yengo','null');
INSERT INTO `adsystem` VALUES (241,'Backbeatmedia','null');
INSERT INTO `adsystem` VALUES (242,'Videmob by Cydersoft','null');
INSERT INTO `adsystem` VALUES (243,'Ligatus','null');
INSERT INTO `adsystem` VALUES (244,'Vidstart','null');
INSERT INTO `adsystem` VALUES (245,'Somo Audience','null');

"adsystem_domain" table

DROP TABLE IF EXISTS adsystem_domain;
CREATE TABLE "adsystem_domain" (
	`DOMAIN`	TEXT,
	`ID`	INTEGER,
	PRIMARY KEY(`DOMAIN`,`ID`)
);
INSERT INTO `adsystem_domain` VALUES ('rubicon.com',1);
INSERT INTO `adsystem_domain` VALUES ('fastlane.rubiconproject.com',1);
INSERT INTO `adsystem_domain` VALUES ('ads.rubiconproject.com',1);
INSERT INTO `adsystem_domain` VALUES ('rubiconproject.com',1);
INSERT INTO `adsystem_domain` VALUES ('rubiconproject.com<http://rubiconproject.com>',1);
INSERT INTO `adsystem_domain` VALUES ('33across.com',2);
INSERT INTO `adsystem_domain` VALUES ('pubmatic.com',3);
INSERT INTO `adsystem_domain` VALUES ('apps.pubmatic.com',3);
INSERT INTO `adsystem_domain` VALUES ('pubmatic',3);
INSERT INTO `adsystem_domain` VALUES ('openx.com',4);
INSERT INTO `adsystem_domain` VALUES ('openx',4);
INSERT INTO `adsystem_domain` VALUES ('openxebda',4);
INSERT INTO `adsystem_domain` VALUES ('openxprebid',4);
INSERT INTO `adsystem_domain` VALUES ('openx.com<http://openx.com>',4);
INSERT INTO `adsystem_domain` VALUES ('openx.net',4);
INSERT INTO `adsystem_domain` VALUES ('facebook.com',5);
INSERT INTO `adsystem_domain` VALUES ('facebook',5);
INSERT INTO `adsystem_domain` VALUES ('facebook:facebook.com',5);
INSERT INTO `adsystem_domain` VALUES ('gumgum.com',6);
INSERT INTO `adsystem_domain` VALUES ('kargo.com',7);
INSERT INTO `adsystem_domain` VALUES ('google.com',8);
INSERT INTO `adsystem_domain` VALUES ('googletagservices.com',8);
INSERT INTO `adsystem_domain` VALUES ('?google.com',8);
INSERT INTO `adsystem_domain` VALUES ('adsense',8);
INSERT INTO `adsystem_domain` VALUES ('google.com/adsense',8);
INSERT INTO `adsystem_domain` VALUES ('google.com<http://google.com>',8);
INSERT INTO `adsystem_domain` VALUES ('www.google.com/dfp',8);
INSERT INTO `adsystem_domain` VALUES ('brealtime.com',9);
INSERT INTO `adsystem_domain` VALUES ('Brealtime',9);
INSERT INTO `adsystem_domain` VALUES ('brealtimegoogle',9);
INSERT INTO `adsystem_domain` VALUES ('emxdgt.com105',9);
INSERT INTO `adsystem_domain` VALUES ('amazon-adsystem.com',10);
INSERT INTO `adsystem_domain` VALUES ('c.amazon-adsystem.com',10);
INSERT INTO `adsystem_domain` VALUES ('advertising.amazon.com',10);
INSERT INTO `adsystem_domain` VALUES ('amazon.com',10);
INSERT INTO `adsystem_domain` VALUES ('a9.com',10);
INSERT INTO `adsystem_domain` VALUES ('aps.amazon.com',10);
INSERT INTO `adsystem_domain` VALUES ('adtech.com',11);
INSERT INTO `adsystem_domain` VALUES ('adtech.net',11);
INSERT INTO `adsystem_domain` VALUES ('aolcloud.net',11);
INSERT INTO `adsystem_domain` VALUES ('liveintent.com',12);
INSERT INTO `adsystem_domain` VALUES ('yieldmo.com',13);
INSERT INTO `adsystem_domain` VALUES ('mopub.com',14);
INSERT INTO `adsystem_domain` VALUES ('aol.com',15);
INSERT INTO `adsystem_domain` VALUES ('smartstream.tv',16);
INSERT INTO `adsystem_domain` VALUES ('smaato.com',17);
INSERT INTO `adsystem_domain` VALUES ('spx.smaato.com',17);
INSERT INTO `adsystem_domain` VALUES ('taboola.com',18);
INSERT INTO `adsystem_domain` VALUES ('trustx.org',19);
INSERT INTO `adsystem_domain` VALUES ('sofia.trustx.org',19);
INSERT INTO `adsystem_domain` VALUES ('lkqd.net',20);
INSERT INTO `adsystem_domain` VALUES ('lkqd.com',20);
INSERT INTO `adsystem_domain` VALUES ('ad.lkqd.net',20);
INSERT INTO `adsystem_domain` VALUES ('criteo.com',21);
INSERT INTO `adsystem_domain` VALUES ('critero.com',21);
INSERT INTO `adsystem_domain` VALUES ('criteo.net',21);
INSERT INTO `adsystem_domain` VALUES ('phillymag.com==criteo.com',21);
INSERT INTO `adsystem_domain` VALUES ('exponential.com',22);
INSERT INTO `adsystem_domain` VALUES ('exponential.comi',22);
INSERT INTO `adsystem_domain` VALUES ('xponential.com',22);
INSERT INTO `adsystem_domain` VALUES ('lijit.com',23);
INSERT INTO `adsystem_domain` VALUES ('meridian.sovrn.com',23);
INSERT INTO `adsystem_domain` VALUES ('sovrn.com',23);
INSERT INTO `adsystem_domain` VALUES ('lijit',23);
INSERT INTO `adsystem_domain` VALUES ('rhythmone.com',24);
INSERT INTO `adsystem_domain` VALUES ('1rx.io',24);
INSERT INTO `adsystem_domain` VALUES ('yldbt.com',25);
INSERT INTO `adsystem_domain` VALUES ('technorati.com',26);
INSERT INTO `adsystem_domain` VALUES ('bidfluence.com',27);
INSERT INTO `adsystem_domain` VALUES ('beachfront.com',27);
INSERT INTO `adsystem_domain` VALUES ('switch.com',28);
INSERT INTO `adsystem_domain` VALUES ('switchconcept',28);
INSERT INTO `adsystem_domain` VALUES ('switchconcepts.com',28);
INSERT INTO `adsystem_domain` VALUES ('brightroll.com',29);
INSERT INTO `adsystem_domain` VALUES ('conversantmedia.com',30);
INSERT INTO `adsystem_domain` VALUES ('go.sonobi.com',31);
INSERT INTO `adsystem_domain` VALUES ('sonobi.com',31);
INSERT INTO `adsystem_domain` VALUES ('*.go.sonobi.com',31);
INSERT INTO `adsystem_domain` VALUES ('spoutable.com',32);
INSERT INTO `adsystem_domain` VALUES ('freewheel.tv',33);
INSERT INTO `adsystem_domain` VALUES ('cdn.stickyadstv.com',33);
INSERT INTO `adsystem_domain` VALUES ('stickyad:freewheel.tv',33);
INSERT INTO `adsystem_domain` VALUES ('connatix.com',34);
INSERT INTO `adsystem_domain` VALUES ('t.brand-server.com',35);
INSERT INTO `adsystem_domain` VALUES ('positivemobile.com',36);
INSERT INTO `adsystem_domain` VALUES ('memeglobal.com',37);
INSERT INTO `adsystem_domain` VALUES ('kixer.com',38);
INSERT INTO `adsystem_domain` VALUES ('sekindo.com',39);
INSERT INTO `adsystem_domain` VALUES ('sekindo',39);
INSERT INTO `adsystem_domain` VALUES ('360yield.com',40);
INSERT INTO `adsystem_domain` VALUES ('improvedigital.com',40);
INSERT INTO `adsystem_domain` VALUES ('adform.com',41);
INSERT INTO `adsystem_domain` VALUES ('adform.net',41);
INSERT INTO `adsystem_domain` VALUES ('adx.adform.net',41);
INSERT INTO `adsystem_domain` VALUES ('inner-active.com',43);
INSERT INTO `adsystem_domain` VALUES ('spotxchange.com',44);
INSERT INTO `adsystem_domain` VALUES ('spotx.tv',44);
INSERT INTO `adsystem_domain` VALUES ('streamrail.net',45);
INSERT INTO `adsystem_domain` VALUES ('sdk.streamrail.com',45);
INSERT INTO `adsystem_domain` VALUES ('mathtag.com',46);
INSERT INTO `adsystem_domain` VALUES ('mediamath.com',46);
INSERT INTO `adsystem_domain` VALUES ('adyoulike.com',47);
INSERT INTO `adsystem_domain` VALUES ('indexexchnage.com',48);
INSERT INTO `adsystem_domain` VALUES ('indexexchange.com',48);
INSERT INTO `adsystem_domain` VALUES ('www.indexexchange.com',48);
INSERT INTO `adsystem_domain` VALUES ('indexechange.com',48);
INSERT INTO `adsystem_domain` VALUES ('indexexchange(ebda)',48);
INSERT INTO `adsystem_domain` VALUES ('indexexchange(pubmatic)',48);
INSERT INTO `adsystem_domain` VALUES ('indexexchange(videossp)',48);
INSERT INTO `adsystem_domain` VALUES ('index.com',48);
INSERT INTO `adsystem_domain` VALUES ('kiosked.com',50);
INSERT INTO `adsystem_domain` VALUES ('ads.kiosked.com',50);
INSERT INTO `adsystem_domain` VALUES ('video.unrulymedia.com',51);
INSERT INTO `adsystem_domain` VALUES ('brightcom.com',52);
INSERT INTO `adsystem_domain` VALUES ('rs-stripe.com',53);
INSERT INTO `adsystem_domain` VALUES ('fyber.com',54);
INSERT INTO `adsystem_domain` VALUES ('tidaltv.com',55);
INSERT INTO `adsystem_domain` VALUES ('nativo.com',56);
INSERT INTO `adsystem_domain` VALUES ('jadserve.postrelease.com',56);
INSERT INTO `adsystem_domain` VALUES ('media.net',57);
INSERT INTO `adsystem_domain` VALUES ('www.yumenetworks.com',58);
INSERT INTO `adsystem_domain` VALUES ('yume.com',58);
INSERT INTO `adsystem_domain` VALUES ('yumenetworks.com',58);
INSERT INTO `adsystem_domain` VALUES ('revcontent.com',59);
INSERT INTO `adsystem_domain` VALUES ('revontent.com',59);
INSERT INTO `adsystem_domain` VALUES ('outbrain.com',60);
INSERT INTO `adsystem_domain` VALUES ('zedo.com',61);
INSERT INTO `adsystem_domain` VALUES ('freeskreen.com',62);
INSERT INTO `adsystem_domain` VALUES ('bidtellect.com',63);
INSERT INTO `adsystem_domain` VALUES ('smartadserver.com',64);
INSERT INTO `adsystem_domain` VALUES ('loopme.com',65);
INSERT INTO `adsystem_domain` VALUES ('vidazoo.com',66);
INSERT INTO `adsystem_domain` VALUES ('vidazoo',66);
INSERT INTO `adsystem_domain` VALUES ('videoflare.com',67);
INSERT INTO `adsystem_domain` VALUES ('yahoo.com',68);
INSERT INTO `adsystem_domain` VALUES ('pixfuture.com',69);
INSERT INTO `adsystem_domain` VALUES ('oms.eu',70);
INSERT INTO `adsystem_domain` VALUES ('stroeer.com',71);
INSERT INTO `adsystem_domain` VALUES ('emxdgt.com',9);
INSERT INTO `adsystem_domain` VALUES ('c1exchange.com',73);
INSERT INTO `adsystem_domain` VALUES ('synacor.com',74);
INSERT INTO `adsystem_domain` VALUES ('sfx.freewheel.tv',33);
INSERT INTO `adsystem_domain` VALUES ('videologygroup.com',76);
INSERT INTO `adsystem_domain` VALUES ('tremorhub.com',77);
INSERT INTO `adsystem_domain` VALUES ('altitudedigital.com',78);
INSERT INTO `adsystem_domain` VALUES ('platform.videologygroup.com',76);
INSERT INTO `adsystem_domain` VALUES ('imonomy.com',80);
INSERT INTO `adsystem_domain` VALUES ('komoona ltd',81);
INSERT INTO `adsystem_domain` VALUES ('komoonaltd',81);
INSERT INTO `adsystem_domain` VALUES ('springserve.com',82);
INSERT INTO `adsystem_domain` VALUES ('spingserve.com',82);
INSERT INTO `adsystem_domain` VALUES ('triplelift.com',83);
INSERT INTO `adsystem_domain` VALUES ('www.triplelift.com',83);
INSERT INTO `adsystem_domain` VALUES ('ib.adnxs.com',84);
INSERT INTO `adsystem_domain` VALUES ('appnexus.com',84);
INSERT INTO `adsystem_domain` VALUES ('appnexus',84);
INSERT INTO `adsystem_domain` VALUES ('apnexus.com',84);
INSERT INTO `adsystem_domain` VALUES ('appnexus.txt',84);
INSERT INTO `adsystem_domain` VALUES ('adnxs.com',84);
INSERT INTO `adsystem_domain` VALUES ('appnexus.com<http://appnexus.com>',84);
INSERT INTO `adsystem_domain` VALUES ('s.ntv.io/serve',85);
INSERT INTO `adsystem_domain` VALUES ('coxmt.com',86);
INSERT INTO `adsystem_domain` VALUES ('undertone.com',87);
INSERT INTO `adsystem_domain` VALUES ('advertising.com',88);
INSERT INTO `adsystem_domain` VALUES ('c.algovid.com',89);
INSERT INTO `adsystem_domain` VALUES ('lockerdome.com',90);
INSERT INTO `adsystem_domain` VALUES ('widespace.com',91);
INSERT INTO `adsystem_domain` VALUES ('deployads.com',92);
INSERT INTO `adsystem_domain` VALUES ('www.mobfox.com',93);
INSERT INTO `adsystem_domain` VALUES ('mobfox.com',93);
INSERT INTO `adsystem_domain` VALUES ('teads.tv',94);
INSERT INTO `adsystem_domain` VALUES ('teads.com',94);
INSERT INTO `adsystem_domain` VALUES ('publishers.teads.tv',94);
INSERT INTO `adsystem_domain` VALUES ('contextweb.com',95);
INSERT INTO `adsystem_domain` VALUES ('pulsepoint.com',95);
INSERT INTO `adsystem_domain` VALUES ('pulsepoint',95);
INSERT INTO `adsystem_domain` VALUES ('pulsepoint:contextweb.com',95);
INSERT INTO `adsystem_domain` VALUES ('districtm.com',96);
INSERT INTO `adsystem_domain` VALUES ('districtm.ca',96);
INSERT INTO `adsystem_domain` VALUES ('districtm.io',96);
INSERT INTO `adsystem_domain` VALUES ('sharethrough.com',97);
INSERT INTO `adsystem_domain` VALUES ('media.adfrontiers.com',98);
INSERT INTO `adsystem_domain` VALUES ('adfrontiers.com',98);
INSERT INTO `adsystem_domain` VALUES ('media.adfrontiers',98);
INSERT INTO `adsystem_domain` VALUES ('ad3media.com',99);
INSERT INTO `adsystem_domain` VALUES ('ads.admized.com',100);
INSERT INTO `adsystem_domain` VALUES ('admized.com',100);
INSERT INTO `adsystem_domain` VALUES ('a.twiago.com',101);
INSERT INTO `adsystem_domain` VALUES ('twiago.com',101);
INSERT INTO `adsystem_domain` VALUES ('xapads.com',102);
INSERT INTO `adsystem_domain` VALUES ('ad-stir.com',104);
INSERT INTO `adsystem_domain` VALUES ('ad.yieldlab.net',105);
INSERT INTO `adsystem_domain` VALUES ('yieldlab.de',105);
INSERT INTO `adsystem_domain` VALUES ('yieldlab.net',105);
INSERT INTO `adsystem_domain` VALUES ('ad3.io',99);
INSERT INTO `adsystem_domain` VALUES ('ad6media.es',107);
INSERT INTO `adsystem_domain` VALUES ('ad6media.fr',107);
INSERT INTO `adsystem_domain` VALUES ('www.ad6media.fr',107);
INSERT INTO `adsystem_domain` VALUES ('adbistro.com',108);
INSERT INTO `adsystem_domain` VALUES ('adcolony.com',109);
INSERT INTO `adsystem_domain` VALUES ('adingo.jp',110);
INSERT INTO `adsystem_domain` VALUES ('adingo.jp<http://adingo.jp>',110);
INSERT INTO `adsystem_domain` VALUES ('admanmedia.com',111);
INSERT INTO `adsystem_domain` VALUES ('admedia.com',112);
INSERT INTO `adsystem_domain` VALUES ('admixer.com',113);
INSERT INTO `adsystem_domain` VALUES ('admixer.net',113);
INSERT INTO `adsystem_domain` VALUES ('ads.stickyadstv.com',33);
INSERT INTO `adsystem_domain` VALUES ('ads4pics.com',115);
INSERT INTO `adsystem_domain` VALUES ('adtech.com<http://adtech.com>',11);
INSERT INTO `adsystem_domain` VALUES ('aolcloud.com',11);
INSERT INTO `adsystem_domain` VALUES ('aolcloud.net<http://aolcloud.net>',11);
INSERT INTO `adsystem_domain` VALUES ('adunity.com',117);
INSERT INTO `adsystem_domain` VALUES ('advbo.ammadv.it',118);
INSERT INTO `adsystem_domain` VALUES ('Advertise.com',119);
INSERT INTO `adsystem_domain` VALUES ('advertising.com<http://advertising.com>',88);
INSERT INTO `adsystem_domain` VALUES ('aerserv.com',120);
INSERT INTO `adsystem_domain` VALUES ('andbeyond.media',121);
INSERT INTO `adsystem_domain` VALUES ('app.tv',122);
INSERT INTO `adsystem_domain` VALUES ('apptv.com',122);
INSERT INTO `adsystem_domain` VALUES ('aralego.com',123);
INSERT INTO `adsystem_domain` VALUES ('atemda.com',124);
INSERT INTO `adsystem_domain` VALUES ('aximusag',125);
INSERT INTO `adsystem_domain` VALUES ('aximus.ch',125);
INSERT INTO `adsystem_domain` VALUES ('baronsmedia.com',126);
INSERT INTO `adsystem_domain` VALUES ('bidsxchange.com',128);
INSERT INTO `adsystem_domain` VALUES ('bidtheatre.com',129);
INSERT INTO `adsystem_domain` VALUES ('buysellads.com',131);
INSERT INTO `adsystem_domain` VALUES ('carambo.la',132);
INSERT INTO `adsystem_domain` VALUES ('carambola.com',132);
INSERT INTO `adsystem_domain` VALUES ('cedato.com',133);
INSERT INTO `adsystem_domain` VALUES ('clickio.com',134);
INSERT INTO `adsystem_domain` VALUES ('collectiveuk.com',135);
INSERT INTO `adsystem_domain` VALUES ('connectignite.com',136);
INSERT INTO `adsystem_domain` VALUES ('converge-digital.com',137);
INSERT INTO `adsystem_domain` VALUES ('crimtan.com',138);
INSERT INTO `adsystem_domain` VALUES ('defymedia.com',139);
INSERT INTO `adsystem_domain` VALUES ('distrcitm.io',96);
INSERT INTO `adsystem_domain` VALUES ('districtmadexchange',96);
INSERT INTO `adsystem_domain` VALUES ('districtm',96);
INSERT INTO `adsystem_domain` VALUES ('districtm.net',96);
INSERT INTO `adsystem_domain` VALUES ('districtmio.com',96);
INSERT INTO `adsystem_domain` VALUES ('distroscale.com',141);
INSERT INTO `adsystem_domain` VALUES ('dynadmic',142);
INSERT INTO `adsystem_domain` VALUES ('e-planning.net',49);
INSERT INTO `adsystem_domain` VALUES ('eadv.it',144);
INSERT INTO `adsystem_domain` VALUES ('easyplatform.com',145);
INSERT INTO `adsystem_domain` VALUES ('eboundservices.com',146);
INSERT INTO `adsystem_domain` VALUES ('electric-sheep.tv',147);
INSERT INTO `adsystem_domain` VALUES ('firstimpression.io',148);
INSERT INTO `adsystem_domain` VALUES ('geekexchange.com',149);
INSERT INTO `adsystem_domain` VALUES ('getintent.com',150);
INSERT INTO `adsystem_domain` VALUES ('glucompany.com',151);
INSERT INTO `adsystem_domain` VALUES ('gmossp.jp',152);
INSERT INTO `adsystem_domain` VALUES ('gobrowsi.com',153);
INSERT INTO `adsystem_domain` VALUES ('gourmetads.com',154);
INSERT INTO `adsystem_domain` VALUES ('hiro-media.com',155);
INSERT INTO `adsystem_domain` VALUES ('ibillboard.com',156);
INSERT INTO `adsystem_domain` VALUES ('increaserev.com',157);
INSERT INTO `adsystem_domain` VALUES ('infolinks.com',158);
INSERT INTO `adsystem_domain` VALUES ('insticator.com',159);
INSERT INTO `adsystem_domain` VALUES ('justpremium.com',160);
INSERT INTO `adsystem_domain` VALUES ('jwdemandadexchange',161);
INSERT INTO `adsystem_domain` VALUES ('keenkale.com',162);
INSERT INTO `adsystem_domain` VALUES ('lifestreet.com',163);
INSERT INTO `adsystem_domain` VALUES ('linicom',164);
INSERT INTO `adsystem_domain` VALUES ('madadsmedia.com',165);
INSERT INTO `adsystem_domain` VALUES ('mediabong.net',166);
INSERT INTO `adsystem_domain` VALUES ('mediabong.com',166);
INSERT INTO `adsystem_domain` VALUES ('mediadeguate.com',167);
INSERT INTO `adsystem_domain` VALUES ('memevideoad.com',37);
INSERT INTO `adsystem_domain` VALUES ('stinger.memeglobal.com',37);
INSERT INTO `adsystem_domain` VALUES ('mgid.com',169);
INSERT INTO `adsystem_domain` VALUES ('monarchads.com',170);
INSERT INTO `adsystem_domain` VALUES ('netseer.com',171);
INSERT INTO `adsystem_domain` VALUES ('oogle.com',8);
INSERT INTO `adsystem_domain` VALUES ('ooyala.com',173);
INSERT INTO `adsystem_domain` VALUES ('optimatic.com',174);
INSERT INTO `adsystem_domain` VALUES ('padsquad.com',175);
INSERT INTO `adsystem_domain` VALUES ('paypal.com',176);
INSERT INTO `adsystem_domain` VALUES ('playtouch',177);
INSERT INTO `adsystem_domain` VALUES ('playtouch2',177);
INSERT INTO `adsystem_domain` VALUES ('playwire.com',178);
INSERT INTO `adsystem_domain` VALUES ('powerlinks.com',179);
INSERT INTO `adsystem_domain` VALUES ('pubgears.com',180);
INSERT INTO `adsystem_domain` VALUES ('purch.com',181);
INSERT INTO `adsystem_domain` VALUES ('servebom.com',181);
INSERT INTO `adsystem_domain` VALUES ('q1media.com',182);
INSERT INTO `adsystem_domain` VALUES ('q1connect.com',182);
INSERT INTO `adsystem_domain` VALUES ('quantcast.com',183);
INSERT INTO `adsystem_domain` VALUES ('quantum-advertising.com',184);
INSERT INTO `adsystem_domain` VALUES ('reklamstore.com',185);
INSERT INTO `adsystem_domain` VALUES ('rekmob.com',186);
INSERT INTO `adsystem_domain` VALUES ('smartadserver:smartadserver.com',64);
INSERT INTO `adsystem_domain` VALUES ('smartadsever.com',64);
INSERT INTO `adsystem_domain` VALUES ('smartclip.net',188);
INSERT INTO `adsystem_domain` VALUES ('smartyads.com',189);
INSERT INTO `adsystem_domain` VALUES ('somoaudience.com',190);
INSERT INTO `adsystem_domain` VALUES ('mobileadtrading.com',190);
INSERT INTO `adsystem_domain` VALUES ('SpotIM',191);
INSERT INTO `adsystem_domain` VALUES ('sprout-ad.com',192);
INSERT INTO `adsystem_domain` VALUES ('ssphwy.com',193);
INSERT INTO `adsystem_domain` VALUES ('startapp.com',194);
INSERT INTO `adsystem_domain` VALUES ('synapsys.us',195);
INSERT INTO `adsystem_domain` VALUES ('tabletmedia.co.uk',196);
INSERT INTO `adsystem_domain` VALUES ('tappx.com',197);
INSERT INTO `adsystem_domain` VALUES ('themoneytizer.com',198);
INSERT INTO `adsystem_domain` VALUES ('thetradedesk.com',199);
INSERT INTO `adsystem_domain` VALUES ('thrive.plus',200);
INSERT INTO `adsystem_domain` VALUES ('tisoomi-services.com',201);
INSERT INTO `adsystem_domain` VALUES ('tribalfusion.com',202);
INSERT INTO `adsystem_domain` VALUES ('trion.com',203);
INSERT INTO `adsystem_domain` VALUES ('trioninteractive.com',203);
INSERT INTO `adsystem_domain` VALUES ('truex.com',204);
INSERT INTO `adsystem_domain` VALUES ('turf.digital',205);
INSERT INTO `adsystem_domain` VALUES ('ubm.com',206);
INSERT INTO `adsystem_domain` VALUES ('udmserve.net',207);
INSERT INTO `adsystem_domain` VALUES ('valueclickmedia.com',208);
INSERT INTO `adsystem_domain` VALUES ('vertamedia.com',209);
INSERT INTO `adsystem_domain` VALUES ('vertoz.com',210);
INSERT INTO `adsystem_domain` VALUES ('vi.ai',211);
INSERT INTO `adsystem_domain` VALUES ('www.vi.ai',211);
INSERT INTO `adsystem_domain` VALUES ('x.fidelity-media.com',212);
INSERT INTO `adsystem_domain` VALUES ('yandex.ru',213);
INSERT INTO `adsystem_domain` VALUES ('yellowhammer.com',214);
INSERT INTO `adsystem_domain` VALUES ('rockyou.com',215);
INSERT INTO `adsystem_domain` VALUES ('rockyou.net',215);
INSERT INTO `adsystem_domain` VALUES ('innity.com',216);
INSERT INTO `adsystem_domain` VALUES ('innity.net',216);
INSERT INTO `adsystem_domain` VALUES ('advenueplatform.com',216);
INSERT INTO `adsystem_domain` VALUES ('nativeads.com',217);
INSERT INTO `adsystem_domain` VALUES ('natiiveads.com',217);
INSERT INTO `adsystem_domain` VALUES ('richaudience.com',218);
INSERT INTO `adsystem_domain` VALUES ('adstanding.com',219);
INSERT INTO `adsystem_domain` VALUES ('www.mass2.com',220);
INSERT INTO `adsystem_domain` VALUES ('RTK.io',221);
INSERT INTO `adsystem_domain` VALUES ('atomx.com', 222);
INSERT INTO `adsystem_domain` VALUES ('ato.mx', 222);
INSERT INTO `adsystem_domain` VALUES ('rtb.ato.mx', 222);
INSERT INTO `adsystem_domain` VALUES ('p.ato.mx', 222);
INSERT INTO `adsystem_domain` VALUES ('addroplet.com', 223); 
INSERT INTO `adsystem_domain` VALUES ('Liondigitalserving.com', 224);
INSERT INTO `adsystem_domain` VALUES ('sulvo.com', 225);
INSERT INTO `adsystem_domain` VALUES ('surgeprice.com', 226);
INSERT INTO `adsystem_domain` VALUES ('mediabong.com', 227);
INSERT INTO `adsystem_domain` VALUES ('babaroll.com', 228);
INSERT INTO `adsystem_domain` VALUES ('juicenectar.com', 229);
INSERT INTO `adsystem_domain` VALUES ('adpone.com', 230);
INSERT INTO `adsystem_domain` VALUES ('onetag.com', 231);
INSERT INTO `adsystem_domain` VALUES ('onetag-sys.com', 231);
INSERT INTO `adsystem_domain` VALUES ('betweendigital.com', 232);
INSERT INTO `adsystem_domain` VALUES ('ads.betweendigital.com', 232);
INSERT INTO `adsystem_domain` VALUES ('experian.com', 233);
INSERT INTO `adsystem_domain` VALUES ('altitude-arena.com', 78);
INSERT INTO `adsystem_domain` VALUES ('gammassp.com', 234);
INSERT INTO `adsystem_domain` VALUES ('ambientdigitalgroup.com', 234);
INSERT INTO `adsystem_domain` VALUES ('cynogage.com', 235);
INSERT INTO `adsystem_domain` VALUES ('deepintent.com', 236);
INSERT INTO `adsystem_domain` VALUES ('adversal.com', 237);
INSERT INTO `adsystem_domain` VALUES ('vmg.host', 238);
INSERT INTO `adsystem_domain` VALUES ('Chocolateplatform.com', 239);
INSERT INTO `adsystem_domain` VALUES ('directadvert.ru', 240);
INSERT INTO `adsystem_domain` VALUES ('backbeatmedia.com', 241);
INSERT INTO `adsystem_domain` VALUES ('videmob.com', 242);
INSERT INTO `adsystem_domain` VALUES ('ligadx.com', 243);
INSERT INTO `adsystem_domain` VALUES ('vidstart.com', 244);
INSERT INTO `adsystem_domain` VALUES ('somoaudience.com', 245);
INSERT INTO `adsystem_domain` VALUES ('mobileadtrading.com', 245);