SQL Query Error, think you can help?

[x11joex11]

Hi there, I am working on a program that gets keywords and adds them to a database, basically I have this large query below. Somewhere in it is an error that SQL does not like. The only error MYSQL reported back was, ERROR NEAR Insert;

Here is the query. Sorry for it being so long...

INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('wow','2009-12-05','2.040000e+7','2.040000e+7','1000000','6.800000e+7','6.800000e+7','6.120000e+6','-1','1.01','0.3966667','0.3966667','0.7466667','1','1','11','4283.572');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('inwow','2009-12-05','-1','-1','-1','18100','18100','14800','-1','0.05','0','0','0','0','0','0','0.51282');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('jewelcrafting','2009-12-05','-1','-1','-1','201000','165000','9900','-1','0.05','0','0','0','0','0','0','0.343035');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('blacksmithing','2009-12-05','110000','110000','14800','165000','165000','18100','-1','0.39','0.835','0.835','0.8716667','12','12','12','4.891887');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('gratis burning crusade','2009-12-05','-1','-1','-1','1900','210','-1','-1','0.05','0','0','0','0','0','0','-0.0000347');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('burning crusade videos','2009-12-05','-1','-1','-1','170','73','28','-1','0.05','0','0','0','0','0','0','0.0009702');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('burning crusade try','2009-12-05','-1','-1','-1','210','12','-1','-1','0.05','0','0','0','0','0','0','-0.0000347');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('burning crusade demo','2009-12-05','-1','-1','-1','590','480','140','-1','0.05','0','0','0','0','0','0','0.004851');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('burning crusade','2009-12-05','90500','90500','8100','368000','368000','40500','-1','0.45','0.6783333','0.6733333','0.6183333','11','11','11','12.62993');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('burning crusade tips','2009-12-05','-1','-1','-1','91','46','12','-1','0.05','0','0','0','0','0','0','0.0004158');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('burning crusade faq','2009-12-05','-1','-1','-1','170','91','36','-1','0.05','0','0','0','0','0','0','0.0012474');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('burning crusade video','2009-12-05','590','-1','-1','1300','720','170','-1','0.82','0.6916667','0','0','11','0','0','0.0966042');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('thottbot','2009-12-05','450000','450000','201000','2.240000e+6','1.830000e+6','1.220000e+6','-1','0.47','0.6991667','0.6991667','0.6283333','12','12','12','397.3662');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('allakhazam','2009-12-05','74000','74000','40500','450000','246000','165000','-1','0.64','0.7016667','0.7016667','0.6083333','11','11','11','73.1808');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('decursive','2009-12-05','5400','-1','-1','33100','27100','14800','-1','1.03','0.5608333','0','0','4','0','0','10.56409');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('auctioneer','2009-12-05','165000','165000','22200','368000','301000','74000','-1','0.85','0.8383333','0.8383333','0.6408333','8','8','8','43.5897');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('gatherer','2009-12-05','110000','110000','33100','201000','201000','74000','-1','0.91','0.8275','0.8275','0.7941667','8','8','4','46.66662');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('hexenmeister','2009-12-05','390','390','110','90500','90500','6600','-1','0.34','0.505','0.505','0.7375','4','4','3','1.555092');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('uldaman','2009-12-05','18100','-1','-1','60500','60500','14800','-1','0.85','0.8058333','0','0','4','0','0','8.71794');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('cosmos','2009-12-05','450000','450000','49500','1.830000e+6','1.830000e+6','368000','-1','2.47','0.9108333','0.9108333','0.7983333','3','3','3','629.9093');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('druide','2009-12-05','2400','2400','590','201000','201000','14800','-1','0.38','0.5683333','0.5683333','0.8166667','4','4','10','3.897432');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('makros','2009-12-05','720','720','110','90500','90500','8100','-1','0.4','0.4875','0.4875','0.6241667','4','4','2','2.24532');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('blasc','2009-12-05','-1','-1','-1','18100','14800','9900','-1','0.05','0','0','0','0','0','0','0.343035');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('curse','2009-12-05','1.830000e+6','1.830000e+6','110000','3.350000e+6','3.350000e+6','673000','-1','0.59','0.8358333','0.8358333','0.6683333','4','4','4','275.1695');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('jäger','2009-12-05','6600','6600','1000','673000','673000','22200','-1','0.53','0.7225','0.7225','0.6433333','10','10','10','8.153838')INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('onyxia','2009-12-05','246000','246000','22200','246000','201000','27100','-1','0.82','0.29','0.29','0.2741667','9','9','9','15.39985');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('addons','2009-12-05','550000','550000','27100','2.240000e+6','2.240000e+6','165000','-1','0.64','0.8391667','0.8391667','0.8791667','8','8','8','73.1808');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('gilde','2009-12-05','6600','6600','590','550000','550000','22200','-1','0.31','0.66','0.66','0.7083333','4','4','3','4.769226');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('gilden','2009-12-05','18100','-1','-1','90500','74000','4400','-1','0.78','0.3358333','0','0','6','0','0','2.378376');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('schurke','2009-12-05','880','880','91','165000','165000','8100','-1','0.69','0.6091667','0.6091667','0.7183333','4','4','1','3.873177');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('atlas','2009-12-05','3.350000e+6','3.350000e+6','110000','9.140000e+6','9.140000e+6','1000000','-1','0.76','0.8366667','0.8366667','0.7966667','9','9','9','526.68');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('quest','2009-12-05','1.110000e+7','1.110000e+7','135000','2.040000e+7','2.040000e+7','301000','-1','0.99','0.8416667','0.8416667','0.84','3','3','3','206.5071');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('koordinaten','2009-12-05','390','390','91','135000','135000','8100','-1','0.93','0.46','0.46','0.6058333','4','4','2','5.220369');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('paladin','2009-12-05','1000000','1000000','40500','1.830000e+6','1.830000e+6','135000','-1','0.76','0.905','0.905','0.8041667','8','8','1','71.1018');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('rogue','2009-12-05','4.090000e+6','4.090000e+6','110000','6.120000e+6','6.120000e+6','1000000','-1','0.84','0.5841667','0.5841667','0.8383333','10','10','10','582.12');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('horde','2009-12-05','550000','550000','27100','1.220000e+6','1.220000e+6','135000','-1','0.73','0.8641667','0.8641667','0.8216667','11','11','1','68.29515');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('buffed','2009-12-05','14800','14800','1000','673000','673000','450000','-1','1.33','0.805','0.805','0.7066667','4','4','11','414.7605');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('magier','2009-12-05','1900','1900','140','201000','165000','9900','-1','0.76','0.6166667','0.6166667','0.725','4','4','1','5.214132');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('ironforge','2009-12-05','33100','-1','-1','74000','60500','4400','-1','0.89','0.8675','0','0','6','0','0','2.713788');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('warlock','2009-12-05','823000','823000','40500','1.500000e+6','1.500000e+6','135000','-1','0.63','0.8775','0.8775','0.8658333','4','4','1','58.93965');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('stormwind','2009-12-05','74000','74000','1900','165000','165000','9900','-1','0.58','0.9041667','0.9041667','0.8941667','6','6','1','3.979206');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('monsters','2009-12-05','5.000000e+6','5.000000e+6','165000','5.000000e+6','4.090000e+6','301000','-1','0.72','0.7025','0.7025','0.8108333','4','4','1','150.187');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('krieger','2009-12-05','165000','165000','3600','673000','550000','22200','-1','0.68','0.8933333','0.8933333','0.7033333','4','4','12','10.46153');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('addon','2009-12-05','673000','673000','5400','2.240000e+6','2.240000e+6','49500','-1','0.84','0.7708333','0.7708333','0.8233333','8','8','8','28.81494');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('druid','2009-12-05','1.830000e+6','823000','33100','1.830000e+6','1.500000e+6','60500','-1','0.87','0.8233333','0.8233333','0.8941667','8','8','10','36.47606');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('coordinates','2009-12-05','1.220000e+6','1.220000e+6','18100','1000000','1000000','27100','-1','0.8','0.5325','0.5325','0.65','7','7','9','15.02424');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('macros','2009-12-05','368000','368000','9900','823000','823000','49500','-1','0.96','0.9116667','0.9116667','0.8925','7','7','3','32.93136');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('warrior','2009-12-05','6.120000e+6','6.120000e+6','90500','7.480000e+6','7.480000e+6','246000','-1','0.61','0.7566667','0.7566667','0.8833333','5','5','3','103.9916');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('interface','2009-12-05','2.740000e+6','2.740000e+6','33100','4.090000e+6','4.090000e+6','135000','-1','1.46','0.9166667','0.9166667','0.8266667','7','7','9','136.5903');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('unofficial','2009-12-05','246000','246000','3600','368000','368000','9900','-1','0.79','0.795','0.795','0.5483333','3','3','3','5.419953');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('ingame','2009-12-05','22200','22200','320','110000','110000','4400','-1','0.99','0.8108333','0.8108333','0.7708333','4','4','11','3.018708');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('priest','2009-12-05','2.240000e+6','2.240000e+6','49500','4.090000e+6','3.350000e+6','90500','-1','0.6','0.8616667','0.8616667','0.7816667','7','7','10','37.6299');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('alliance','2009-12-05','5.000000e+6','5.000000e+6','60500','7.480000e+6','7.480000e+6','246000','-1','1.22','0.6466667','0.6466667','0.8333333','9','9','3','207.9832');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('hunter','2009-12-05','1.110000e+7','1.110000e+7','165000','1.660000e+7','1.660000e+7','450000','-1','1.43','0.8808333','0.8808333','0.8316667','7','7','1','445.9455');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('quests','2009-12-05','450000','450000','3600','823000','823000','12100','-1','1.12','0.8666667','0.8666667','0.875','7','7','12','9.391536');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('instance','2009-12-05','368000','368000','12100','550000','550000','27100','-1','0.79','0.8275','0.8275','0.775','4','4','2','14.83644');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('logged','2009-12-05','135000','135000','1600','201000','201000','4400','-1','1.2','0.2741667','0.2741667','0.7316667','11','11','5','3.65904');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('world','2009-12-05','1.850000e+8','1.010000e+8','450000','1.850000e+8','1.010000e+8','673000','-1','1.34','0.9308333','0.9308333','0.7666667','4','4','9','624.9613');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('talent','2009-12-05','6.120000e+6','6.120000e+6','49500','2.040000e+7','2.040000e+7','301000','-1','1.33','0.4766667','0.4766667','0.695','5','5','4','277.4287');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('drops','2009-12-05','2.240000e+6','2.240000e+6','8100','2.240000e+6','2.240000e+6','60500','-1','1.56','0.875','0.875','0.8341667','9','9','5','65.40534');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('curse gaming','2009-12-05','90500','-1','-1','550000','450000','368000','-1','0.67','0.6075','0','0','4','0','0','170.8661');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('ui mods','2009-12-05','-1','-1','-1','12100','9900','590','-1','0.05','0','0','0','0','0','0','0.0204435');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('flight path','2009-12-05','49500','49500','1600','110000','90500','4400','-1','0.86','0.825','0.8166667','0.7608333','11','11','6','2.622312');

 

[x11joex11]

here is part 2, I appreciate any help and will add rep, thanks!

INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('gold guide','2009-12-05','74000','40500','1600','110000','60500','2900','-1','1.06','0.7725','0.7191667','0.7991667','7','7','4','2.130282');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('gold farming','2009-12-05','40500','-1','-1','74000','49500','5400','-1','1.2','0.7366667','0','0','7','0','0','4.49064');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('world of warcrafts','2009-12-05','1900','1900','590','5400','4400','1900','-1','0.81','0.6825','0.6816667','0.4483333','11','11','11','1.066527');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('shaman','2009-12-05','1000000','1000000','40500','2.740000e+6','2.740000e+6','135000','-1','0.62','0.9091667','0.9091667','0.9033333','4','4','10','58.0041');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('power leveling','2009-12-05','135000','135000','6600','450000','301000','22200','-1','2.72','0.7441667','0.7333333','0.8266667','2','2','12','41.84611');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('horde guide','2009-12-05','90500','6600','1000','110000','12100','1600','-1','0.8','0.8491667','0.9075','0.6991667','7','9','2','0.88704');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('world of worcraft','2009-12-05','2400','2400','1000','18100','18100','8100','-1','0.8','0.8033333','0.805','0.74','7','7','12','4.49064');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('world of warcarft','2009-12-05','5400','5400','1600','18100','18100','6600','-1','0.98','0.8558333','0.8566667','0.75','12','12','11','4.482324');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('northrend','2009-12-05','-1','-1','-1','201000','201000','14800','-1','0.05','0','0','0','0','0','0','0.51282');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('powerleveling','2009-12-05','49500','49500','2900','201000','201000','14800','-1','2.73','0.7675','0.7675','0.8333333','7','7','7','27.99997');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('horde leveling guide','2009-12-05','60500','49500','8100','74000','60500','14800','-1','0.9','0.8366667','0.8691667','0.8408333','7','7','11','9.23076');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('leveling guide','2009-12-05','450000','-1','-1','673000','550000','9900','-1','0.99','0.865','0','0','7','0','0','6.792093');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('power level','2009-12-05','74000','60500','1900','135000','90500','8100','-1','1.72','0.8891667','0.8991667','0.7975','7','7','5','9.654876');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('leveling','2009-12-05','1.500000e+6','1.500000e+6','4400','1.830000e+6','1.500000e+6','8100','-1','1.65','0.8508333','0.8508333','0.8883333','7','7','5','9.261945');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('powerlevel','2009-12-05','18100','18100','880','40500','40500','2900','-1','1.87','0.745','0.745','0.8516667','7','7','10','3.758139');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('level guide','2009-12-05','90500','33100','1000','135000','60500','1600','-1','0.68','0.835','0.9158333','0.6783333','9','9','5','0.753984');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('power leveling service','2009-12-05','3600','3600','720','6600','5400','590','-1','2.64','0.6633333','0.6725','0.715','7','7','7','1.079417');INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('dereks gold guide','2009-12-05','-1','-1','-1','880','390','170','-1','0.05','0','0','0','0','0','0','0.0058905');

 

[Eric]

I'd say your problem is:

INSERT OR IGNORE

That's not valid. Remove 'OR'.

INSERT IGNORE INTO ...

 

[x11joex11]

Actually it's valid, I'm using SQLITE, my code won't work without the OR, I want it to INSERT OR IGNORE as described. If I didn't have the OR then it would always insert, sometimes I want it to ignore so it doesn't add duplicate keywords (content). Good news is I've got the sql problem narrowed down to one of these '2' queries in the bunch. Error only occurs when it gets to those. If the problem was the OR then it should error on EVERY query not just those one of these 2.

INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('jäger','2009-12-06','6600','6600','1000','673000','673000','22200','-1','0.53','0.7225','0.7225','0.6433333','10','10','10','8.153838')INSERT OR IGNORE INTO keywords(keyword,DateLastChecked,BroadLastMonthsTraffic,PhraseLastMonthsTraffic,ExactLastMonthsTraffic,BroadAvgTraffic,PhraseAvgTraffic,ExactAvgTraffic,AdCompetition,Cpc,avgMonthsBroad,avgMonthsPhrase,avgMonthsExact,bestMonthBroad,bestMonthPhrase,bestMonthExact,Revenue) VALUES ('onyxia','2009-12-06','246000','246000','22200','246000','201000','27100','-1','0.82','0.29','0.29','0.2741667','9','9','9','15.39985');

My gut instinct was to think it's the jäger, but that query seems to run well by it's self. The SQL error doesn't appear to happen until onyxia comes up, which is the 2nd query, but I'm not sure what could be invalid. Everything else works. If you think I need need a description of the table just let me know and I'll put the table description down, but everything is DOUBLE data type except for the obvious TEXT type for the keyword and the DATES.

I have to admit this is pretty perplexing to me why it would error like this on those '2' keywords in the query when it works on thousands of others. I'm not sure what is different about the data at all. Only thing I can think of is maybe the weird jäger causes errors for the query afterwards when it's in order somehow, I'm going to try an experiment by removing it and see if the error still occurs on onyxia.


EDIT**

hmm I noticed something, I think it's missing a ; after the jäger query, this would cause the error near insert. interesting, wonder how this happened. I'm going to investigate into this now. I bolded it in the query.

 

[Eric]

Ah, I assumed you were using MySQL