API tools faq
paste
Advertisement
FailSecurityBR

Data Dump ~~> springfieldmo.org <~~ #FailSecBR #PART2

FailSecurityBR
Aug 15th, 2012
166
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 195.51 KB | None | 0 0
raw download clone embed print report
  1.  
  2. =============================================================================================================================================
  3. $$$$$$$$\ $$\ $$\ $$$$$$\ $$$$$$$\ $$$$$$$\
  4. $$ _____| \__|$$ |$$ __$$\ $$ __$$\ $$ __$$\
  5. $$ | $$$$$$\ $$\ $$ |$$ / \__| $$$$$$\ $$$$$$$\ $$ | $$ |$$ | $$ |
  6. $$$$$\ \____$$\ $$ |$$ |\$$$$$$\ $$ __$$\ $$ _____|$$$$$$$\ |$$$$$$$ |
  7. $$ __|$$$$$$$ |$$ |$$ | \____$$\ $$$$$$$$ |$$ / $$ __$$\ $$ __$$<
  8. $$ | $$ __$$ |$$ |$$ |$$\ $$ |$$ ____|$$ | $$ | $$ |$$ | $$ |
  9. $$ | \$$$$$$$ |$$ |$$ |\$$$$$$ |\$$$$$$$\ \$$$$$$$\ $$$$$$$ |$$ | $$ |
  10. \__| \_______|\__|\__| \______/ \_______| \_______|\_______/ \__| \__|
  11.  
  12. ===========================================================================================================================================
  13. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66208,'Todd Oliver & Friends',null,null,'Jim Stafford Theatre 3440 W. Hwy 76','','','Branson','MO','65616','','US','417','335-8080','','',null,null,'417','335-2643',null,null,'','marketing@jimstafford.com',null,1,null,'CANCEL','Attrac','JR',null,'Out',0,null,'http://www.toddoliver.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Apr 2 2012 12:00AM',null,36.6437,-93.2185);
  14. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66209,'Springfield-Greene County Park Board - Tom Watkins Park',null,null,'2100 W. High St.','','','Springfield','MO','65803',null,'US','417','833-8923','417','864-1049',null,null,null,'',null,null,'http://www.parkboard.org/','',null,1,null,'FREE','Parks','JR',null,'NW',0,null,'',null,'Dec 10 2010 12:00AM',null,null,null,null,'SD','Jun 13 2012 12:00AM',null,37.2374,-93.3187);
  15. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66210,'Touch',null,null,'1620 E. Republic Rd.','','','Springfield','MO','65804',null,'US','417','823-8383',null,null,null,null,'417','823-8380',null,null,'www.touch-restaurant.com','',null,1,null,'SGF ADV','Rest','RA',null,'SE',0,null,'',null,'Dec 10 2010 12:00AM',null,null,null,null,'LWH','Nov 1 2011 12:00AM',null,37.1374,-93.2667);
  16. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66212,'The Tower Club',null,null,'901 E. St. Louis St.','Hammons Tower - 21st & 22nd Floor','','Springfield','MO','65806','','US','417','866-4466','','',null,null,'417','866-4466',null,null,'http://www.towerclubspringfield.com','',null,1,null,'SGF ADV','Rest','RA',null,'DT',0,null,'Sept/Jan $400 payments ',null,'Dec 10 2010 12:00AM',null,null,null,null,'SD','Oct 25 2011 12:00AM',null,37.2096,-93.2821);
  17. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66214,'Travel Host Magazine',null,null,'1440 State Hwy 248, Ste Q, PMB 402','','','Branson','MO','65616',null,'US','417','334-5297',null,null,null,null,'417','334-1268',null,null,'','thstbranson@aol.com',null,1,null,'NONSALES','Other','RA',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Dec 28 2010 12:00AM',null,36.6437,-93.2185);
  18. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66215,'TRAVELHERO.COM',null,null,'7201 E. Camelback Rd. Suite 295','','','Scottsdale','AZ','85251',null,'US',null,'',null,null,null,null,null,'',null,null,'','',null,1,null,'NONSALES','CVBVendor','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'LW','Jan 10 2011 12:00AM',null,33.502,-111.925);
  19. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66216,'Trinity Lutheran Church',null,null,'1415 S. Holland Ave.','','','Springfield','MO','65807',null,'US','417','866-5878',null,null,null,null,null,'',null,null,'','',null,1,null,'SGF ADV','Church','JR',null,'SE',0,null,'http://www.trinitylutheranspfd.org',null,'Dec 10 2010 12:00AM',null,null,null,null,'AM','Oct 17 2011 12:00AM',null,37.1879,-93.2864);
  20. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66217,'Trymeek Corporation',null,null,'PO Box 1746','','','Springfield','MO','65801',null,'US',null,'',null,null,null,null,'417','869--9440',null,null,'','',null,1,null,'NONSALES','Other','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Dec 28 2010 12:00AM',null,37.214,-93.2952);
  21. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66218,'Turkel',null,null,'2871 Oak Ave.','','','Miami','FL','33133',null,'US',null,'',null,null,null,null,null,'',null,null,'','',null,1,null,'NONSALES','CVBVendor','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'CH','Dec 29 2010 12:00AM',null,25.7301,-80.2403);
  22. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66219,'Twin Oaks Country Club',null,null,'1020 E. Republic Rd.','','','Springfield','MO','65807',null,'US','417','881-4744',null,null,null,null,'417','881--3331',null,null,'','',null,1,null,'FREE','Sport','JR',null,'SE',0,null,'http://www.twinoakscountryclub.com/',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.1383,-93.2803);
  23. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66221,'U.S. Post Office',null,null,'500 W. Chestnut Expy.','','','Springfield','MO','65801',null,'US','417','864-0104',null,null,null,null,null,'',null,null,'','',null,1,null,'NONSALES','Other','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Dec 28 2010 12:00AM',null,37.2154,-93.2952);
  24. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66223,'UMB Bank',null,null,'1150 E. Battlefield Rd.','','','Springfield','MO','65807',null,'US','417','887-5855',null,null,null,null,'417','887--1808',null,null,'','',null,1,null,'NONSALES','Other','JR','SF',null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SF','Jun 4 2012 12:00AM',null,37.1596,-93.2784);
  25. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66224,'Unite',null,null,'PO Box 1745','','','Springfield','MO','65801',null,'US','417','864-7444',null,null,null,null,null,'',null,null,'','',null,1,null,'NONSALES','Other','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Dec 28 2010 12:00AM',null,37.214,-93.2952);
  26. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66225,'United Express',null,null,'Springfield-Branson National Airport','2298 N. Airport Blvd.','','Springfield','MO','65802',null,'US','800','864-8331','800','241-6522','800','864-8331',null,'',null,null,'','',null,1,null,'FREE','Transp','JR',null,'NW',0,null,'www.united.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.2391,-93.3971);
  27. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66226,'United Way of the Ozarks Inc',null,null,'320 N. Jefferson Ave.','','','Springfield','MO','65806',null,'US',null,'',null,null,null,null,null,'',null,null,'','jkennally@uwozarks.com',null,1,null,'NONSALES','Relocate','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'CH','Feb 24 2011 12:00AM',null,37.2107,-93.2897);
  28. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66227,'University Plaza Hotel & Convention Center',null,null,'333 S. John Q Hammons Pkwy.','','','Springfield','MO','65806','','US','417','864-7333','417','522-1116','417','522-1117','417','864-3077',null,null,'http://www.upspringfield.com','upevents@jqh.com',null,1,null,'SGF ADV','Lodgng','JR','SF','DT',0,null,'http://www.upspringfield.com' + CHAR(13) + CHAR(10) + 'Chris.Huffington@jqh.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SD','Dec 1 2011 12:00AM',null,37.2083,-93.2816);
  29. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66228,'Urban Districts Alliance ',null,null,'304 W. McDaniel St.','','','Springfield','MO','65806',null,'US','417','831-6200',null,null,null,null,'417','831-6217',null,null,'','',null,1,null,'SGF ADV','Other','RA',null,'DT',0,null,'barb@itsalldowntown.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'MD','Jul 21 2011 12:00AM',null,37.2079,-93.2943);
  30. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66229,'USS Lapon Sail and Memorial',null,null,'American Legion Post 639','2600 S. Scenic','','Springfield','MO','',null,'US','417','882-8639',null,null,null,null,null,'',null,null,'','',null,1,null,'NONSALES','Other','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Dec 28 2010 12:00AM',null,37.2153,-93.2982);
  31. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66230,'Valentine''s Restaurant',null,null,'2902 S. Campbell Ste. B','','','Springfield','MO','65807',null,'US','417','891-9700',null,null,null,null,'417','891--9705',null,null,'','',null,1,null,'CLOSED','Rest','RA',null,'SW',0,null,'OUT OF BUSINESS as of 1-6-11' + CHAR(13) + CHAR(10) + 'http://www.valetinesrestaurant.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.1612,-93.2954);
  32. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66231,'Value Place',null,null,'2021 W. Kingsley St.','','','Springfield','MO','65807',null,'US','417','886-8600',null,null,null,null,'417','887-6488',null,null,'','',null,1,null,'FREE','Lodgng','JR',null,'SW',0,null,'http://www.valueplace.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 7 2011 12:00AM',null,37.1412,-93.3216);
  33. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66232,'Vandivort Center',null,null,'305 E. Walnut, 4th Floor','','','Springfield','MO','65806',null,'US','417','869-0727',null,null,null,null,null,'',null,null,'','chelseybode@yahoo.com',null,1,null,'FREE','Mt/Bqt','JR',null,'DT',0,null,'www.SpringfieldContemporaryTheatre.org',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.2073,-93.2912);
  34. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66233,'Veterans Memorial Museum',null,null,'1250 W. 76 Country Blvd.','','','Branson','MO','65616',null,'US','417','336-2300',null,null,null,null,'417','336-2301',null,null,'http://www.veteransmemorialbranson.com','info@veteransmemorialbranson.com',null,1,null,'PARTNER','Attrac','JR',null,'Out',0,null,'Zac has taken over the museum. need to contact him directly. NO MORE CINDY MERRY',null,'Dec 10 2010 12:00AM',null,null,null,null,'KS','Feb 8 2011 12:00AM',null,36.6394,-93.2413);
  35. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66235,'Village Inn Family Restaurant - Ozark',null,null,'850 N. 17th St.','','','Ozark','MO','65721',null,'US','417','581-8815',null,null,null,null,'417','887-2113',null,null,'','',null,1,null,'SGF ADV','Rest','RA',null,'Out',0,null,'http://www.villageinns.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SD','Aug 31 2011 12:00AM',null,37.0261,-93.2253);
  36. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66236,'Village Inn Family Restaurant - S. Campbell',null,null,'4222 S. Campbell Ave.','','','Springfield','MO','65807',null,'US','417','887-4774',null,null,null,null,'417','887-2113',null,null,'','',null,1,null,'SGF ADV','Rest','RA','SF','SE',0,null,'http://www.villageinns.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SF','Jul 27 2012 12:00AM',null,37.1377,-93.2953);
  37. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66237,'Village Inn Family Restaurant - S. Glenstone Ave.',null,null,'2036 S. Glenstone Ave.','','','Springfield','MO','65804',null,'US','417','881-0774',null,null,null,null,'417','887-2113',null,null,'','',null,1,null,'SGF ADV','Rest','RA',null,'SE',0,null,'http://www.villageinns.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Mar 16 2012 12:00AM',null,37.1769,-93.2624);
  38. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66238,'Walnut Street Historic District',null,null,'Walnut Street','','','Springfield','MO','65806',null,'US',null,'',null,null,null,null,null,'',null,null,'','',null,1,null,'FREE','Other','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'CH','Jan 7 2011 12:00AM',null,37.208,-93.2747);
  39. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66239,'Walnut Street Inn',null,null,'900 E. Walnut St.','','','Springfield','MO','65806',null,'US','800','593-6346','417','864-6346',null,null,'417','864-6184',null,null,'http://www.walnutstreetinn.com','',null,1,null,'SGF ADV','Lodgng','JR',null,'DT',0,null,'Received an extra $200 toward next FY contract on 6/7/11',null,'Dec 10 2010 12:00AM',null,null,null,null,'KS','May 10 2011 12:00AM',null,37.2065,-93.282);
  40. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66240,'Wannenmacher Advertising Co.',null,null,'211 E. Walnut St.','','','Springfield','MO','65806',null,'US','417','869-4848',null,null,null,null,'417','869--6201',null,null,'','',null,1,null,'NONSALES','Other','JR','LK','DT',0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'LW','Jan 10 2011 12:00AM',null,37.2073,-93.2918);
  41. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66241,'Springfield-Greene County Park Board - Watershed Center at Valley Water Mill Park',null,null,'2300 E. Valley Water Mill Rd.','','','Springfield','MO','65803',null,'US','417','866-1127','417','833-8647','417','864-1049','417','866-1918',null,null,'http://www.parkboard.org/','',null,1,null,'FREE','Attrac','JR',null,'NE',0,null,'mailing address 320 N. Main Ave. 65806' + CHAR(13) + CHAR(10) + 'http://www.parkboard.org/info/city_parks/vwm_park/index.htm',null,'Dec 10 2010 12:00AM',null,null,null,null,'SD','Jun 13 2012 12:00AM',null,37.2649,-93.247);
  42. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66242,'Waverly House Gifts & Gallery',null,null,'2031 S. Waverly Ave.','','','Springfield','MO','65804',null,'US','417','882-3445',null,null,null,null,'417','886-1350',null,null,'','waverlyhouse1@att.net',null,1,null,'SGF ADV','Shop','RA',null,'SE',0,null,'http://www.waverlyhouse.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.177,-93.2642);
  43. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66243,'Webster County Commission',null,null,'101 S. Crittendon St., Room 11','','','Marshfield','MO','65706',null,'US',null,'',null,null,null,null,null,'',null,null,'','',null,1,null,null,'Other','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jan 10 2011 12:00AM',null,37.3385,-92.9063);
  44. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66244,'Welcome Center Services',null,null,'362 Gascony Way','','','St. Louis','MO','63122',null,'US','314','503-0457',null,null,null,null,'314','965--9969',null,null,'','',null,1,null,'NONSALES','Other','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'LW','Jan 10 2011 12:00AM',null,38.6094,-90.4003);
  45. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66245,'Welcome to Springfield Magazine',null,null,'PO Box 4025','','','Springfield','MO','65808',null,'US','417','877-0404',null,null,null,null,'417','877-0404',null,null,'','',null,1,null,'SGF ADV','Other','RA','SF',null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SF','Jun 19 2012 12:00AM',null,37.1882,-93.2622);
  46. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66246,'Wendy''s of Missouri, Inc.',null,null,'1855 S. Ingram Mill Rd., Suite 100','','','Springfield','MO','65804',null,'US','417','887-7677',null,null,null,null,null,'',null,null,'','',null,1,null,'PROSPECT','Rest','RA','RM',null,0,null,'www.wendysofmissouri.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.1784,-93.2268);
  47. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66247,'Which Wich Superior Sandwiches',null,null,'3405 E. Battlefield Rd.','','','Springfield','MO','65804',null,'US','417','882-9424',null,null,null,null,'417','883--4329',null,null,'','',null,1,null,'SGF ADV','Rest','RA','RM','SE',0,null,'Best to reach Natalie on her cell ',null,'Dec 10 2010 12:00AM',null,null,null,null,'DB','Jan 13 2012 12:00AM',null,37.1582,-93.2268);
  48. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66248,'White Knight Bus Company',null,null,'1500 Jade Rd.','','','Columbia','MO','65201',null,'US','417','736-3400',null,null,null,null,'573','814-2339',null,null,'GoWhiteKnight.com','gowkl@hotmail.com',null,1,null,'PARTNER','Transp','RA',null,'Out',0,null,'',null,'Dec 10 2010 12:00AM',null,null,null,null,'DB','Sep 20 2011 12:00AM',null,38.9534,-92.1324);
  49. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66249,'Whittington Associates',null,null,'1263 N. Yarberry Ave.','','','Springfield','MO','65802',null,'US','417','831-4755',null,null,null,null,'417','831--2553',null,null,'','',null,1,null,'NONSALES','Other','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'CH','Feb 24 2011 12:00AM',null,37.2204,-93.2178);
  50. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66250,'Wild Animal Safari',null,null,'124 Jungle Dr.','','','Strafford','MO','65757',null,'US','417','859-5300',null,null,null,null,'417','859-1001',null,null,'http://www.animalsafari.com','wildanimalsafari@gmail.com',null,1,null,'PARTNER','Attrac','JR','RM','Out',0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'AM','Jan 13 2011 12:00AM',null,37.2714,-93.0556);
  51. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66251,'Wild Bill Hickok Shootout',null,null,'Park Central Square','','','Springfield','MO','65806',null,'US','417','881-5300',null,null,null,null,null,'',null,null,'http://www.springfieldmo.org','',null,1,null,'FREE','Attrac','JR',null,'DT',0,null,'Davis Tutt''s grave is in Maple Park Cemetery. Block 57, Lot 54. (Go to west side of cemetery, then south. The marker is six roads south from the office.)',null,'Dec 10 2010 12:00AM',null,null,null,null,'LW','Dec 30 2010 12:00AM',null,37.209,-93.2922);
  52. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66252,'Willard Area Chamber of Commerce',null,null,'PO Box 384','','','Willard','MO','65781',null,'US','417','742-2442',null,null,null,null,null,'',null,null,'www.willardmochamber.org','willardchamber@yahoo.com',null,1,null,'PROSPECT','Other','JR',null,null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Dec 28 2010 12:00AM',null,37.3575,-93.4157);
  53. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66253,'Wilson''s Creek National Battlefield',null,'WC','6424 W. Farm Rd. 182','','','Republic','MO','65738',null,'US','417','732-2662',null,null,null,null,'417','732-1167',null,null,'','',null,1,null,'SGF ADV','Attrac','JR','LWH','Out',0,null,'http://www.nps.gov/wicr',null,'Dec 10 2010 12:00AM',null,null,null,null,'AM','Nov 1 2011 12:00AM',null,37.1067,-93.4196);
  54. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66254,'Wilson''s Creek National Battlefield Foundation',null,null,'PO Box 8163','','','Springfield','MO','65801',null,'US','417','864-3041','417','864-3041',null,null,null,'',null,null,'www.wilsonscreek150.com','',null,1,null,'NONSALES','Other','LWH',null,'Out',0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'MD','May 11 2011 12:00AM',null,37.2134,-93.2955);
  55. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66255,'WIN of Springfield',null,null,'1923 N. Weller','','','Springfield','MO','65803',null,'US','417','864-1329',null,null,null,null,null,'',null,null,'','jadams@springfieldmo.gov',null,1,null,'NONSALES','Other','JR','RM',null,0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'CH','Dec 29 2010 12:00AM',null,37.2327,-93.268);
  56. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66256,'Wishing Well Motor Inn',null,null,'3550 W. Chestnut Expy.','','','Springfield','MO','65802',null,'US','417','862-0996',null,null,null,null,null,'',null,null,'','',null,1,null,'FREE','Lodgng','RA',null,null,0,null,'>Has designated not to receive Sales Lead in times past. Not selected as a "Sales Lead Recipient." CC',null,'Dec 10 2010 12:00AM',null,null,null,null,'CH','Feb 24 2011 12:00AM',null,37.2117,-93.3505);
  57. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66257,'Wonders of Wildlife Museum & Aquarium',null,null,'500 W. Sunshine St.','','','Springfield','MO','65807','','US','417','890-9453','(877)','245-9453',null,null,'(417)','890-9278',null,null,'http://www.wondersofwildlife.org','info@wondersofwildlife.org',null,1,null,'SGF ADV','Attrac','JR','RM','SW',0,null,null,null,'Dec 10 2010 12:00AM',null,null,null,null,'SD','May 9 2011 12:00AM',null,37.1815,-93.2967);
  58. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66258,'University of Missouri Extension - Xeriscape Demonstration Garden',null,null,'National Avenue and Linwood Street','','','Springfield','MO','65802',null,'US','417','881-8909',null,null,null,null,null,'',null,null,'','',null,1,null,'FREE','Attrac','JR',null,'NE',0,null,'http://www.outreach.missouri.edu/greene/mgg/xeriscape.htm' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + '10/27/11 - swa updated name to University of Missouri Extension instead of Springfield Greene County Parks. Also added David Burton as contact and removed Lisa Zimmerman and unnamed contact.',null,'Dec 10 2010 12:00AM',null,null,null,null,'SWA','Oct 27 2011 12:00AM',null,37.1879,-93.2765);
  59. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66259,'Yakov Smirnoff Theatre',null,null,'470 State Hwy. 248','','','Branson','MO','65616',null,'US','417','336-3838',null,null,null,null,'417','336-4102',null,null,'','yakov@yakov.com',null,1,null,'PARTNER','Attrac','JR',null,'Out',0,null,'www.yakov.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,36.6648,-93.223);
  60. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66260,'Zen 3 Spa & Bodyworks',null,null,'619 S. Pickwick Ave.','','','Springfield','MO','65802','','US','417','866-9363','','',null,null,'417','863-9770',null,null,'','bodywork@zen3massage.com',null,1,null,'SGF ADV','Attrac','JR',null,'DT',0,null,'www.zen3massage.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.2031,-93.2697);
  61. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66261,'Ziggie''s Caf� - N. Glenstone',null,null,'935 N. Glenstone Ave','','','Springfield','MO','65806',null,'US','417','883-0900',null,null,null,null,'417','881-5504',null,null,'','',null,1,null,'CANCEL','Rest','RA',null,'NE',0,null,'www.ziggiescafe.com' + CHAR(13) + CHAR(10) + 'Cancelled promotion of this location 7/14/11 per Agim',null,'Dec 10 2010 12:00AM',null,null,null,null,'LWH','Jul 14 2011 12:00AM',null,37.2175,-93.2623);
  62. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66262,'Ziggie''s Caf� - Nixa',null,null,'911 N. Kenneth','','','Nixa','MO','65714',null,'US','417','883-0900',null,null,null,null,'417','881-5504',null,null,'','',null,1,null,'CANCEL','Rest','RA',null,'Out',0,null,'www.ziggiescafe.com' + CHAR(13) + CHAR(10) + 'Cancelled promotion of this location 7/14/11 per Agim',null,'Dec 10 2010 12:00AM',null,null,null,null,'LWH','Jul 14 2011 12:00AM',null,37.0583,-93.3041);
  63. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66263,'Ziggie''s Caf� - Republic',null,null,'1230 E. Hwy 60','','','Republic','MO','65738',null,'US','417','883-0900',null,null,null,null,'417','881-5504',null,null,'','',null,1,null,'CANCEL','Rest','RA',null,'Out',0,null,'www.ziggiescafe.com' + CHAR(13) + CHAR(10) + 'Cancelled promotion of this location 7/14/11 per Agim',null,'Dec 10 2010 12:00AM',null,null,null,null,'LWH','Jul 14 2011 12:00AM',null,37.1321,-93.4575);
  64. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66264,'Springfield Family Restaurant',null,null,'2222 S. Campbell Ave.','','','Springfield','MO','65807',null,'US','417','883-0900',null,null,null,null,'417','881-5504',null,null,'','',null,1,null,'SGF ADV','Rest','RA',null,'SW',0,null,'',null,'Dec 10 2010 12:00AM',null,null,null,null,'JR','Mar 30 2012 12:00AM',null,37.1743,-93.2948);
  65. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66265,'Ziggie''s Caf� - W. Kearney',null,null,'1324 W. Kearney St.','','','Springfield','MO','65803',null,'US','417','883-0900',null,null,null,null,'417','881-5504',null,null,'','',null,1,null,'SGF ADV','Rest','RA',null,'NW',0,null,'www.ziggiescafe.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.2405,-93.3077);
  66. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66266,'Zio''s Italian Kitchen',null,null,'1249 E. Kingsley St.','','','Springfield','MO','65804',null,'US','417','889-1919',null,null,null,null,'417','889--4333',null,null,'','',null,1,null,'PROSPECT','Rest','RA','RM',null,0,null,'www.zios.com',null,'Dec 10 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.1406,-93.2768);
  67. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66268,'Cape Fair Marina',null,null,'142 Sturgis Lane','','','Reed Springs','MO','65737','','US','417','538-4163','417','272-1311',null,null,'417','538-4165',null,null,'capefairmarina.com','info@capefairmarina.com',null,1,null,'PARTNER','Attrac','JR',null,'Out',0,null,'www.capefairmarina.com',null,'Dec 14 2010 12:00AM','Dec 7 2010 12:00AM',null,null,null,'SD','Dec 19 2011 12:00AM',null,36.7132,-93.359);
  68. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66271,'Christian Preschool',null,null,'xxx',null,null,'Springfield','MO',null,null,'US',null,null,null,null,null,null,null,null,null,null,null,'christianpreschool@yahoo.com',null,1,null,'PROSPECT','Other','JR',null,null,0,null,'Kim Hicks called about website adv.',null,'Dec 15 2010 12:00AM',null,null,null,null,'SD','Dec 27 2010 12:00AM',null,37.2153,-93.2982);
  69. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66272,'Houlihan''s Restaurant and Bar - E. Republic Rd.',null,null,'2110 E. Republic Rd.',null,null,'Springfield','MO','65804',null,'US','417','883-3434',null,null,null,null,null,null,null,null,'',null,null,1,null,'SGF ADV','Rest','RA','SF','SE',0,null,'http://www.houlihans.com',null,'Dec 15 2010 12:00AM',null,null,null,null,'SF','Jun 21 2012 12:00AM',null,37.137,-93.2554);
  70. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66273,'Pickleman''s Gourmet Caf� - E. Walnut St.',null,null,'333 E. Walnut St.','','','Springfield','MO','65806','','US','417','851-6900','','',null,null,'','',null,null,'','',null,1,null,'SGF ADV','Rest','RA',null,'DT',0,null,'*Slow Pay*' + CHAR(13) + CHAR(10) + 'http://www.picklemans.com',null,'Dec 15 2010 12:00AM',null,null,null,null,'SD','Aug 22 2011 12:00AM',null,37.2071,-93.2902);
  71. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66275,'Interactive Hotel Solutions',null,null,null,null,null,null,null,null,null,'US',null,null,null,null,null,null,null,null,null,null,'ihsadvantage.com','',null,1,null,'NONSALES','Other','JR','KS',null,0,null,'only open using internet explorer. This is a website used on website to filter hotel booking through. Data from bookings can be obtained through FTP site: see Laura or Colleen. ',null,'Dec 16 2010 12:00AM',null,null,null,null,'SG','Jan 11 2011 12:00AM',null,null,null);
  72. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66279,'Princess Diana Exhibit',null,null,'3950 Green Mountain Drive',null,null,'Branson','MO','65616',null,'US','417','335-6611',null,null,null,null,null,null,null,null,'',null,null,1,null,'PROSPECT','Attrac','JR',null,null,0,null,'Have tried to contact three times.' + CHAR(13) + CHAR(10) + 'www.princessdianabranson.com' + CHAR(13) + CHAR(10) + '',null,'Dec 21 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,36.6504,-93.2932);
  73. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66280,'Orange Leaf',null,null,'1368 East Republic Road',null,null,'Springfield','MO','65804',null,'US','417','888-2050',null,null,null,null,null,null,null,null,'','',null,1,null,'PROSPECT','Rest','RA',null,null,0,null,'http://www.orangeleafyogurt.com/',null,'Dec 21 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.1375,-93.2727);
  74. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66282,'Avanzare',null,null,'1908 South Glenstone Avenue',null,null,'Springfield','MO','65804','2305','US','417','567-3463',null,null,null,null,null,null,null,null,null,'info@avanzareitaliandining.com',null,1,null,'PROSPECT','Rest','RA',null,'SE',0,null,'www.avanzareitaliandining.com',null,'Dec 21 2010 12:00AM',null,null,null,null,'SG','Aug 5 2011 12:00AM',null,37.1795,-93.2616);
  75. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66284,'Ozark Treasures',null,null,'2510 S. Campbell Ave.',null,null,'Springfield','MO','65807',null,'US','417','882-2400',null,null,null,null,null,null,null,null,null,null,null,1,null,'SGF ADV','Shop','RA',null,'SE',0,null,null,null,'Dec 21 2010 12:00AM',null,null,null,null,'LWH','Oct 28 2011 12:00AM',null,37.1685,-93.2943);
  76. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66285,'SIX','aka Numax Entertainment',null,'3455 West Hwy 76','',null,'Branson','MO','65615',null,'US','','334-0076',null,null,null,null,'877','321-6044',null,null,null,'doug@thesicshow.com',null,1,null,'PARTNER','Attrac','JR',null,'Out',0,null,'www.thesixshow.com' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'Numax Entertainment, Inc DBA "SIX"' + CHAR(13) + CHAR(10) + 'info@numaxentertainment.com',null,'Dec 21 2010 12:00AM','Apr 21 2011 12:00AM',null,null,null,'MD','May 24 2011 12:00AM',null,36.6405,-93.285);
  77. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66287,'Dairy Queen',null,null,'9001 W 71st Street ',null,null,'Merriam','KS','66204',null,'US','913','549-4774','','',null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA','SF','Out',0,null,null,null,'Dec 23 2010 12:00AM',null,null,null,null,'LK','May 8 2012 12:00AM',null,39.0001,-94.6902);
  78. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66288,'The Team, Inc.',null,null,'716 North 22nd Street ',null,null,'Ozark','MO','65721',null,'US','417','581-0600',null,null,null,null,null,null,null,null,'',null,null,1,null,'NONSALES','Other','LK','RM',null,0,null,'Sports Commission Trade Member',null,'Dec 23 2010 12:00AM',null,null,null,null,'LK','Apr 12 2012 12:00AM',null,37.0238,-93.2335);
  79. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66290,'Leong''s Asian Diner ',null,null,'1540 W. Republic Rd.',null,null,'Springfield','MO','65807',null,'US','417','887-7500','417','887-7500',null,null,'417','887-7551',null,null,null,null,null,1,null,'SGF ADV','Rest','RA',null,'SW',0,null,null,null,'Dec 27 2010 12:00AM','Jan 27 2011 12:00AM',null,null,null,'SG','Mar 28 2011 12:00AM',null,37.1378,-93.3142);
  80. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66291,'Decades Boutique',null,null,'213 W Commercial Street ',null,null,'Springfield','MO',null,null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Shop',null,null,null,0,null,null,null,'Dec 27 2010 12:00AM',null,null,null,null,'CH','Feb 24 2011 12:00AM',null,37.2298,-93.2926);
  81. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66292,'Qdoba Mexican Grill ',null,null,'722-B W Olive',null,null,'Springfield','MO','65806',null,'US',null,null,null,null,null,null,null,null,null,null,'',null,null,1,null,'PROSPECT','Rest','RA','SF',null,0,null,'Sports Commission Member / Lunch Trade ' + CHAR(13) + CHAR(10) + 'www.qdoba.com',null,'Dec 28 2010 12:00AM',null,null,null,null,'SF','Jul 17 2012 12:00AM',null,37.2093,-93.2989);
  82. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66293,'Zipline USA',null,null,'3335 US-160',null,null,'Reeds Spring','MO','65737',null,'US','417','559-5398',null,null,null,null,null,null,null,null,'','ziplineusa@gmail.com',null,1,null,'PROSPECT','Attrac',null,null,null,0,null,'Krista from Zumba passed along contact information' + CHAR(13) + CHAR(10) + 'www.goziplineusa.com/index.html',null,'Dec 28 2010 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,36.7602,-93.3356);
  83. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66294,'Toss Across',null,null,'431 S Jefferson Ave',null,null,'Springfield','MO','65806',null,'US','417','865-8677',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA',null,'DT',0,null,null,null,'Dec 28 2010 12:00AM',null,null,null,null,'MI','Apr 18 2011 12:00AM',null,37.2059,-93.2907);
  84. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66296,'The Cup',null,null,'322 E. Walnut St.','Suite 102','','Springfield','MO','65806','','US','417','865-2287','417','865-2287',null,null,'','',null,null,'www.cravethecup.com','','infospringfield@cravethecup.com',1,null,'SGF ADV','Rest','RA',null,'DT',0,null,'8/4/11 - swa copied VG25 description into website description, which was blank.' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'Sandy Nance is the general manager at the springfield location' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'www.cravethecup.com',null,'Dec 28 2010 12:00AM','Jun 16 2011 12:00AM',null,null,null,'SD','Aug 12 2011 12:00AM','Apr 5 2011 12:00AM',37.2068,-93.2904);
  85. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66297,'Show-Me Music & Arts Festival',null,null,'2019 North Le Compte Road',null,null,'Springfield','MO','65802',null,'US','615','983-6959 ','office','615-983-6959','',null,null,null,null,null,'',null,null,1,null,'SGF ADV','Other',null,null,'NE',0,null,'June 17-19' + CHAR(13) + CHAR(10) + 'http://www.showmemusicfest.com/?pg=home' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + '8/4/11 - swa changed major category and major code to other, removed minor code of attraction with restaurant',null,'Dec 30 2010 12:00AM','May 3 2011 12:00AM',null,null,null,'SWA','Aug 4 2011 12:00AM',null,37.2316,-93.2157);
  86. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66298,'St Louis CVB',null,null,null,null,null,null,null,null,null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,0,null,null,null,'Jan 3 2011 12:00AM',null,null,null,null,'CH','Jan 4 2011 12:00AM',null,null,null);
  87. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66322,'Branson Airport',null,null,'110 W. Adams Street',null,null,'Branson','MO','65616',null,'US','417','334-7813',null,null,null,null,'417','334-2190',null,null,'',null,null,1,null,'PARTNER','Transp','JR',null,'Out',0,null,'www.flybranson.com',null,'Jan 5 2011 12:00AM',null,null,null,null,'LWH','Oct 25 2011 12:00AM',null,36.6404,-93.2177);
  88. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66328,'Staxx',null,null,'331 South Ave.',null,null,'Springfield','MO','65806',null,'US','417','866-2900',null,null,null,null,'417','866-2911',null,null,'',null,null,1,null,'SGF ADV','Shop','JR',null,'DT',0,null,'Meghan is a new board member and also owns Jelly Beans (Children''s clothing store)' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'www.shopstaxx.com',null,'Jan 5 2011 12:00AM',null,null,null,null,'AM','Nov 1 2011 12:00AM',null,37.2073,-93.2928);
  89. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66337,'Nearly Famous ',null,null,'2708 S. Glenstone',null,null,'Springfield','MO','65804',null,'US','417','883-3403',null,null,null,null,null,null,null,null,'',null,'info@nearlyfamous.net',1,null,'PROSPECT','Rest','RA',null,'SE',0,null,'http://www.nearlyfamous.net/index.php',null,'Jan 6 2011 12:00AM',null,null,null,null,'SG','Aug 5 2011 12:00AM',null,37.164,-93.2618);
  90. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66339,'Melissa Divincen',null,null,null,null,null,null,null,null,null,'US','417','881-5300',null,null,null,null,null,null,null,null,null,null,null,1,null,'NONSALES','Other','JR',null,null,0,null,'TO DO- OTHER ITEMS',null,'Jan 6 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,null,null);
  91. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66364,'American Eagle',null,null,'Springfield-Branson National Airport','2298 N. Airport Blvd.',null,'Springfield','MO','65802',null,'US',null,null,'800','443-7300',null,null,null,null,null,null,'',null,null,1,null,'CANCEL','Transp','RA',null,'NW',0,null,'www.aa.com',null,'Jan 7 2011 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.2391,-93.3971);
  92. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66365,'Allegiant Air',null,null,'Springfield-Branson National Airport','2298 N. Airport Blvd.',null,'Springfield','MO','65802',null,'US','702','505-8888',null,null,null,null,null,null,null,null,'',null,null,1,null,'FREE','Transp','RA',null,'NW',0,null,'www.allegiant.com',null,'Jan 7 2011 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.2391,-93.3971);
  93. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66368,'Missouri State University Athletics',null,null,'901 S. National Ave',null,null,'Springfield','MO',null,null,'US','417','836-7678',null,null,null,null,'417',null,null,null,'','',null,1,null,'CANCEL','Sport','JR',null,'DT',0,null,'Athletic director' + CHAR(13) + CHAR(10) + 'Stewart is no longer there. Katie is new contact' + CHAR(13) + CHAR(10) + 'www.missouristatebears.com' + CHAR(13) + CHAR(10) + '8/4/11 - swa removed major code attractions, changed major category to sports facilities, removed minor code all attractions',null,'Jan 7 2011 12:00AM',null,null,null,null,'SWA','Aug 4 2011 12:00AM',null,37.1973,-93.2767);
  94. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66377,'Huskey Trailways',null,null,'5034 North 17th St.',null,null,'Ozark','MO','65721',null,'US','417','581-3440','1-888','844-3704',null,null,'417','581-5528',null,null,null,null,null,1,null,'PROSPECT','Transp','RA',null,null,0,null,null,null,'Jan 10 2011 12:00AM',null,null,null,null,'MD','Jan 10 2011 12:00AM',null,37.0625,-93.2232);
  95. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66378,'Savor Restaurant & Lounge',null,null,'234 E. Commercial St.',null,null,'Springfield','MO','65807',null,'US','417','831-5111','417','848-2829',null,null,null,null,null,null,'','info@savorbakery.com',null,1,null,'CLOSED',null,'RA',null,'DT',0,null,'CLOSED - Publications Removed. -SD',null,'Jan 10 2011 12:00AM','May 24 2011 12:00AM',null,null,null,'SG','May 1 2012 12:00AM',null,37.2294,-93.2908);
  96. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66379,'Eagle Shuttle Co',null,null,'3329 S. Pinehurst',null,null,'Springfield','MO','65807',null,'US',null,null,null,null,null,null,null,null,null,null,'',null,'hungN97@yahoo.com',1,null,'CANCEL','Transp','JR',null,null,0,null,'Tried to contact in 2011 for renewal in Travel Guide and website.',null,'Jan 11 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,37.1536,-93.3023);
  97. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66398,'US Bank',null,null,'417 St. Louis St.',null,null,'Springfield','MO','65806',null,'US','417','868-4506',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,'JR','SF',null,0,null,'Sports Commission Member September 2011 ',null,'Jan 12 2011 12:00AM',null,null,null,null,'SF','Jun 14 2012 12:00AM',null,37.2089,-93.2887);
  98. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66406,'Missouri Government',null,null,'',null,null,'',null,'',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'NONSALES','Other','SWA','TK',null,0,null,null,null,'Jan 13 2011 12:00AM',null,null,null,null,'LWH','Jan 18 2011 12:00AM',null,38.5789,-92.1725);
  99. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66418,'Deerfield Vet',null,null,'2850 South Ingram Mill Road',null,null,'Springfield','MO',null,null,'US','417','889-2727',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Other',null,null,null,0,null,null,null,'Jan 17 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,37.1601,-93.2293);
  100. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66419,'Days Inn Ozark',null,null,'900 North 18th Street',null,null,'Ozark ','MO','65721',null,'US','417','581-5800',null,null,null,null,'417','581-5807',null,null,null,null,null,1,null,'PROSPECT','Lodgng','JR',null,null,0,null,'competes with American Inn Ozark',null,'Jan 17 2011 12:00AM',null,null,null,null,'CE','Feb 16 2012 12:00AM',null,37.0269,-93.2278);
  101. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66421,'Associated Video Producers',null,'AVP','2034 W. Vista','','','Springfield','MO','65807','','US','417','881-7090','(888)','688-6721',null,null,'','',null,null,'www.a-v-p.com','',null,1,null,'SGF ADV','ConvServ','JR',null,'NE',0,null,null,null,'Jan 17 2011 12:00AM',null,null,null,null,'SD','Jun 26 2012 12:00AM',null,37.1656,-93.3203);
  102. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66424,'U.P. Catering Company, Inc.',null,null,'333 S. John Q Hammons Pkwy.',null,null,'Springfield','MO','65806',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,'KS',null,null,0,null,'This is a separate IP set up for payment of commissions for Expo litewall. Please do not delete or combine with University Plaza Hotel.',null,'Jan 17 2011 12:00AM',null,null,null,null,'KS','Aug 9 2012 12:00AM',null,37.2083,-93.2816);
  103. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66432,'Federal Government',null,null,null,null,null,null,null,null,null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'NONSALES','Other','SWA','TK',null,0,null,null,null,'Jan 17 2011 12:00AM',null,null,null,null,'SWA','Feb 25 2011 12:00AM',null,null,null);
  104. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66438,'Community Foundation of the Ozarks',null,'CFO','425 E. Trafficway St.',null,null,'Springfield','MO','65806','1121','US','417','864-6199',null,null,null,null,null,null,null,null,'www.cfozarks.org',null,null,1,null,'NONSALES','Other','TK',null,null,0,null,null,null,'Jan 18 2011 12:00AM',null,null,null,null,'SWA','Feb 25 2011 12:00AM',null,37.2108,-93.2893);
  105. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66440,'Missouri State University - JQH Arena',null,null,'685 S. John Q. Hammons Parkway',null,null,'Springfield','MO','65897',null,'US','417','836-5240','417','836-5240',null,null,null,null,null,null,'',null,null,1,null,'SGF ADV','Sport','JR','RM','DT',0,null,'jqharena.missouristate.edu',null,'Jan 18 2011 12:00AM',null,null,null,null,'SD','Nov 18 2011 12:00AM',null,37.2021,-93.283);
  106. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66442,'Chateau Charmant',null,null,'1700 Martin Branch Rd',null,null,'Fordland','MO','65652',null,'US','417','767-2233','','',null,null,null,null,null,null,'',null,null,1,null,'PARTNER','Attrac','JR',null,'Out',0,null,'http://www.charmingcastle.com',null,'Jan 18 2011 12:00AM',null,null,null,null,'SG','Jul 7 2011 12:00AM',null,37.0787,-92.9243);
  107. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66455,'Greene County Government',null,null,null,null,null,null,null,null,null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,'Other',null,null,null,0,null,null,null,'Jan 20 2011 12:00AM',null,null,null,null,'SWA','Feb 25 2011 12:00AM',null,null,null);
  108. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66459,'Missouri State University - Plaster Sports Complex',null,null,'901 S. National Ave.',null,null,'Springfield','MO','65897',null,'US','417','836-4640',null,null,null,null,null,null,null,null,'http://www.missouristate.edu/psc/',null,null,1,null,null,'Sport',null,null,'DT',0,null,null,null,'Jan 20 2011 12:00AM',null,null,null,null,'KM','Dec 20 2011 12:00AM',null,37.1977,-93.2798);
  109. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66477,'Drury University - Breech Pool',null,null,'900 N. Benton Ave.',null,null,'Springfield','MO','65802',null,'US','417','873-7265',null,null,null,null,null,null,null,null,'www.drurypanthers.com',null,null,1,null,null,'Sport','JR',null,'DT',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 20 2011 12:00AM',null,37.2192,-93.2846);
  110. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66478,'Drury University - Weiser Gym',null,null,'900 N. Benton Ave.',null,null,'Springfield','MO','65802',null,'US','417','873-7265',null,null,null,null,null,null,null,null,'www.drurypanthers.com',null,null,1,null,null,'Sport',null,null,'DT',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 20 2011 12:00AM',null,37.2192,-93.2852);
  111. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66480,'Drury University - Harrison Stadium',null,null,'900 N. Benton Ave.',null,'','Springfield','MO','65802',null,'US','417','873-7265',null,null,null,null,null,null,null,null,'www.drurypanthers.com',null,null,1,null,null,'Sport',null,null,'DT',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.2181,-93.2834);
  112. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66482,'Evangel University - Ashcroft Center',null,null,'1111 N. Glenstone Ave.',null,null,'Springfield','MO','65802',null,'US','417','865-2811',null,null,null,null,null,null,null,null,'www.evangel.edu',null,null,1,null,null,'Sport',null,null,'NE',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.2228,-93.265);
  113. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66484,'Evangel University - Mabee Student Fitness Center',null,null,'1111 N. Glenstone Ave.',null,null,'Springfield','MO','65802',null,'US','417','865-2811',null,null,null,null,null,null,null,null,'www.evangel.edu',null,null,1,null,null,'Sport',null,null,'NE',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.2232,-93.265);
  114. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66486,'Evangel University - Evangel Baseball Field',null,null,'1111 N. Glenstone Ave.',null,null,'Springfield','MO','65802',null,'US','417','865-2811',null,null,null,null,null,null,null,null,'www.evangel.edu',null,null,1,null,null,'Sport',null,null,'NE',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.2244,-93.2654);
  115. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66487,'Evangel University - Evangel Softball Field',null,null,'1111 N. Glenstone Ave.',null,null,'Springfield','MO','65802',null,'US','417','865-2811',null,null,null,null,null,null,null,null,'www.evangel.edu',null,null,1,null,null,'Sport',null,null,'NE',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.2242,-93.2666);
  116. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66488,'Evangel University - Baseball & Softball Fieldhouse',null,null,'1111 N. Glenstone Ave.',null,null,'Springfield','MO','65802',null,'US','417','865-2811',null,null,null,null,null,null,null,null,'www.evangel.edu',null,null,1,null,null,'Sport',null,null,'NE',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.2239,-93.2655);
  117. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66489,'Hammons Field - Bill Rowe Indoor Training Facility',null,null,'955 E. Trafficway',null,null,'Springfield','MO','65804',null,'US','417','863-2143',null,null,null,null,null,null,null,null,'www.springfieldcardinals.com',null,null,1,null,null,'Sport',null,null,'DT',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 6 2011 12:00AM',null,37.2106,-93.2801);
  118. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66490,'Springfield Underground - MSU Cross Country Facility',null,null,'2019 North Le Compte Road',null,null,'Springfield','MO','65802',null,'US','417','836-7678',null,null,null,null,null,null,null,null,'',null,null,1,null,null,'Sport',null,null,'NE',0,null,null,null,'Jan 21 2011 12:00AM',null,null,null,null,'KM','Dec 7 2011 12:00AM',null,37.2316,-93.2157);
  119. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66496,'Central Bible College - Forest Arnold Activities Building',null,null,'3000 N. Grant Ave.',null,null,'Springfield','MO','65803',null,'US','417','833-2551',null,null,null,null,null,null,null,null,'http://netcom.cbcag.edu/netcommunity/page.aspx?pid=259',null,null,1,null,'FREE','Sport','JR',null,'NW',0,null,null,null,'Jan 24 2011 12:00AM',null,null,null,null,'KM','Dec 20 2011 12:00AM',null,37.254,-93.2943);
  120. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66497,'Central Bible College - Schmidgall Fitness Center',null,null,'3000 N. Grant Ave.',null,null,'Springfield','MO','65803',null,'US','417','833-2551',null,null,null,null,null,null,null,null,'http://netcom.cbcag.edu/netcommunity/page.aspx?pid=259',null,null,1,null,null,'Sport',null,null,'NW',0,null,null,null,'Jan 24 2011 12:00AM',null,null,null,null,'KM','Dec 20 2011 12:00AM',null,37.2532,-93.2952);
  121. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66498,'Baptist Bible College - W.E. Dowell Field House',null,null,'628 E. Kearney St.',null,null,'Springfield','MO','65803',null,'US','417','268-6038',null,null,null,null,null,null,null,null,'http://www.gobbc.edu/student-life/campus-recreation',null,null,1,null,null,'Sport',null,null,'NW',0,null,null,null,'Jan 24 2011 12:00AM',null,null,null,null,'KM','Dec 20 2011 12:00AM',null,37.2402,-93.2863);
  122. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66499,'Southwest Baptist University - Plaster Stadium',null,null,'1600 University Ave.',null,null,'Bolivar','MO','65613',null,'US','417 ','328-5281',null,null,null,null,null,null,null,null,'http://www.sbubearcats.com/sports/2009/10/6/FB_1006095840.aspx?id=82',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Jan 24 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.6021,-93.4132);
  123. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66500,'Southwest Baptist University - Meyer Wellness & Sports Center',null,null,'1600 University Ave.',null,null,'Bolivar','MO','65613',null,'US','417','328-5281',null,null,null,null,null,null,null,null,'www.sbubearcats.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Jan 24 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.6027,-93.4109);
  124. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66501,'Southwest Baptist University - John Bryant Tennis Center',null,null,'1600 University Ave.',null,null,'Bolivar','MO','65613',null,'US','417','328-5281 ',null,null,null,null,null,null,null,null,'www.sbubearcats.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Jan 24 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.6027,-93.4098);
  125. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66502,'Southwest Baptist University - Dodson Baseball Field',null,null,'1600 University Ave.',null,null,'Bolivar','MO','65613',null,'US','417','328-5281 ',null,null,null,null,null,null,null,null,'www.sbubearcats.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Jan 24 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.5989,-93.4105);
  126. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66503,'Southwest Baptist University - SBU Soccer Field',null,null,'1600 University Ave.',null,null,'Bolivar','MO','65613',null,'US','417','328-5281 ',null,null,null,null,null,null,null,null,'www.sbubearcats.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Jan 24 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.5981,-93.4102);
  127. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66504,'Southwest Baptist University - SBU Softball Field',null,null,'1600 University Ave.',null,null,'Bolivar','MO','65613',null,'US','417','328-5281 ',null,null,null,null,null,null,null,null,'www.sbubearcats.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Jan 24 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.5988,-93.4119);
  128. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66514,'Sumit Hot Yoga',null,null,'610 E Battlefield Road',null,null,'Springfield','MO','65804',null,'US','417','881-yoga (9642)',null,null,null,null,null,null,null,null,'',null,null,1,null,'PROSPECT','Attrac',null,null,null,0,null,'www.sumithotyoga.com',null,'Jan 26 2011 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.16,-93.2884);
  129. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66515,'Savoy Ballroom',null,null,'224 E Commercial Street',null,null,'Springfield','MO','65803',null,'US','417','865-2255',null,null,null,null,null,null,null,null,'www.cstreetsavoy.com','events@cstreetsavoy.com',null,1,null,'PROSPECT','Attrac','JR',null,null,0,null,'Great music for all styles of ballroom dance, plus we''ll take requests! Gorgeous ballroom with awesome dance floor, no smoking, and great bar selection.' + CHAR(13) + CHAR(10) + 'http://www.DanceWithMe.us/',null,'Jan 26 2011 12:00AM',null,null,null,null,'DG','Aug 12 2011 12:00AM',null,37.2294,-93.2911);
  130. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66516,'The Diamond Room',null,null,'2340 W. Grand',null,null,'Springfield','MO','65802',null,'US','417','862-7780',null,null,null,null,null,null,null,null,'www.diamondroom.org',null,null,1,null,'PROSPECT','Mt/Bqt','JR',null,'NW',0,null,'corporate events, receptions, private parties.' + CHAR(13) + CHAR(10) + '30-330 Guests #380' + CHAR(13) + CHAR(10) + 'Grand Ballroom is connected as well' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'Santa Maria Lounge #100',null,'Jan 27 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,37.1976,-93.3631);
  131. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66520,'Subway ',null,null,null,null,null,null,null,null,null,'US',null,null,null,null,null,null,null,null,null,null,null,'info@masonandmoon.com',null,1,null,'PROSPECT','Rest','RA','SF',null,0,null,'Mason and Moon Advertising' + CHAR(13) + CHAR(10) + '4700 Gaillardia Parkway, Suite 211' + CHAR(13) + CHAR(10) + 'Oklahoma City, OK 73142' + CHAR(13) + CHAR(10) + '405-607-6226 Office' + CHAR(13) + CHAR(10) + '',null,'Jan 28 2011 12:00AM',null,null,null,null,'RM','Dec 30 2011 12:00AM',null,null,null);
  132. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66521,'Ozark Community Center',null,null,'1530 W Jackson, PO box 1206',null,null,'Ozark','MO','65721',null,'US','417','581-7002','417','581-7002',null,null,'417','581-8599',null,null,null,null,null,1,null,'PROSPECT',null,'JR',null,'Out',0,null,'At the Ozark Community Center we recognize that people want an affordable, top-notch facility with state-of-the-art equipment and innovative programs. That�s why we offer more than your average local health club and give it to you at a competitive price and wonderful value you can feel great about. ' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + '',null,'Jan 28 2011 12:00AM',null,null,null,null,'KM','Dec 9 2011 12:00AM',null,37.0249,-93.2216);
  133. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66522,'Extra Innings',null,null,'1900 W Sunset B-100',null,null,'Springfield','MO','65807',null,'US','417','881-2920',null,null,null,null,null,null,null,null,null,null,null,1,null,null,'Sport',null,null,'SW',0,null,null,null,'Jan 28 2011 12:00AM',null,null,null,null,'KM','Dec 12 2011 12:00AM',null,37.1654,-93.3179);
  134. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66523,'TLC Properties',null,null,'1531 E Broadway Pkwy',null,null,'Springfield','MO','65804',null,'US','417','869-1118',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Lodgng','RA',null,null,0,null,null,null,'Jan 28 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,37.2271,-93.3027);
  135. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66526,'Air Time Bounce Centers','',null,'4234 South Reed Road','2103 E Rockhurst',null,'Springfield','MO',null,null,'US','417','889-KIDZ',null,null,null,null,null,null,null,null,'',null,null,1,null,'PROSPECT','Attrac','JR',null,null,0,null,'Wacky World Centers' + CHAR(13) + CHAR(10) + 'www.airttimekidz.com',null,'Jan 31 2011 12:00AM',null,null,null,null,'MD','May 11 2011 12:00AM',null,37.1361,-93.2501);
  136. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66527,'The Track Family Fun Parks',null,null,'3388 Green Mountain Dr','3415 West 76 Country Boulevard',null,'Branson','MO','65616',null,'US','417','334-1612',null,null,null,null,null,null,null,null,'',null,null,1,null,'PROSPECT','Attrac','JR',null,'Out',0,null,'337-9896' + CHAR(13) + CHAR(10) + 'www.bransontracks.com',null,'Jan 31 2011 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,36.6437,-93.2875);
  137. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66529,'Sunshine Lanes ',null,null,'1500 West Sunshine',null,null,'Springfield ','MO','65807',null,'US','417','866-7246',null,null,null,null,null,null,null,null,'www.sunshinelanesbowling.com',null,null,1,null,null,'Sport','SF',null,'SW',0,null,null,null,'Jan 31 2011 12:00AM',null,null,null,null,'CH','Feb 24 2011 12:00AM',null,37.182,-93.312);
  138. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66531,'City of Republic-Bervin White Memorial Baseball/Softball Complex',null,null,'711 E. Miller Rd.',null,null,'Republic','MO','65738',null,'US','417','732-3500',null,null,null,null,null,null,null,null,'republicmo.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,'6 baseball/softball fields, pavillion and concessions',null,'Feb 1 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.1111,-93.4685);
  139. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66532,'Bolivar Speedway',null,null,null,null,null,null,null,null,null,'US','417','326-2285',null,null,null,null,null,null,null,null,'http:\\bolivarspeedway.net',null,null,1,null,null,'Sport',null,null,null,0,null,null,null,'Feb 1 2011 12:00AM',null,null,null,null,'CH','Feb 24 2011 12:00AM',null,null,null);
  140. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66534,'City of Republic-Garoutte Field',null,null,'210 E. Hines',null,null,'Republic','MO','65738',null,'US','417','732-3500',null,null,null,null,null,null,null,null,'http:\\republicmo.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Feb 1 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.1248,-93.4769);
  141. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66535,'Holiday Lanes',null,null,'1111 W. Kearney St.',null,null,'Springfield','MO','65803',null,'US','417','862-5472',null,null,null,null,null,null,null,null,'',null,null,1,null,null,'Sport',null,null,null,0,null,null,null,'Feb 1 2011 12:00AM',null,null,null,null,'KM','Dec 7 2011 12:00AM',null,37.241,-93.3043);
  142. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66536,'Island Green Golf Club',null,null,'169 Country Club Drive',null,null,'Republic ','MO','65738',null,'US','417','732-7622',null,null,null,null,null,null,null,null,'http:\\islandgreengolfclub.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Feb 1 2011 12:00AM',null,null,null,null,'KM','Dec 13 2011 12:00AM',null,37.0829,-93.4832);
  143. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66537,'City of Republic-J.R. Martin Park',null,null,'300 E. Hines',null,null,'Republic','MO','65738',null,'US','417','732-3500',null,null,null,null,null,null,null,null,'http:\\republicmo.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Feb 1 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.1245,-93.4715);
  144. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66538,'Mickey Owen Baseball School/Complex',null,null,'814 S Kickapoo Ave',null,null,'Springfield','MO','65804',null,'US','417','882-2799',null,null,null,null,null,null,null,null,null,null,null,1,null,null,'Sport',null,null,null,0,null,null,null,'Feb 2 2011 12:00AM',null,null,null,null,'CH','Feb 24 2011 12:00AM',null,37.1996,-93.2734);
  145. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66539,'Ozark International Raceway',null,null,'402 W Mt. Vernon Suite 266',null,null,'Nixa','MO','65714',null,'US','417','738-2222',null,null,null,null,null,null,null,null,'www.ozarkdragstrip.com',null,null,1,null,null,'Sport',null,null,null,0,null,null,null,'Feb 2 2011 12:00AM',null,null,null,null,'CH','Feb 24 2011 12:00AM',null,37.0436,-93.3013);
  146. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66540,'Ozark Mountain Gymnastics',null,null,'2910 S Fort Avenue ',null,null,'Springfield','MO','65807',null,'US','417','882-5311',null,null,null,null,null,null,null,null,'www.ozarkmountaingymnastics.com',null,null,1,null,'PROSPECT','Sport','SF','RM',null,0,null,null,null,'Feb 2 2011 12:00AM',null,null,null,null,'RM','Aug 23 2011 12:00AM',null,37.1613,-93.3095);
  147. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66541,'Paintball Outpost',null,null,'310 N. Karnage Lane',null,null,'Springfield','MO','65802',null,'US','417','866-8801',null,null,null,null,null,null,null,null,'http://paintball-outpost.com/',null,null,1,null,null,'Sport',null,null,null,0,null,null,null,'Feb 2 2011 12:00AM',null,null,null,null,'KM','Dec 7 2011 12:00AM',null,37.2109,-93.3932);
  148. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66542,'Price Cutter Park Baseball Stadium',null,null,null,null,null,null,null,null,null,'US','417','818-7785',null,null,null,null,null,null,null,null,null,null,null,1,null,null,'Sport',null,null,null,0,null,null,null,'Feb 2 2011 12:00AM',null,null,null,null,'CH','Feb 24 2011 12:00AM',null,null,null);
  149. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66543,'Polk County Fairground',null,null,'4560 S. 100th Rd.',null,null,'Bolivar','MO','65613',null,'US','417','326-7606',null,null,null,null,null,null,null,null,null,null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Feb 2 2011 12:00AM',null,null,null,null,'KM','Dec 7 2011 12:00AM',null,37.5914,-93.4495);
  150. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66545,'Silo Ridge Golf & Country Club',null,null,'PO Box 432',null,null,'Bolivar','MO','65613',null,'US','417','326-7456',null,null,null,null,'417','777-3998',null,null,'http://siloridge.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Feb 2 2011 12:00AM',null,null,null,null,'KM','Dec 14 2011 12:00AM',null,37.6122,-93.4194);
  151. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66546,'Springfield Gymnastics & Aquatic Center',null,null,'529 S. Cavalier',null,null,'Springfield','MO','65802',null,'US','417','864-6869',null,null,null,null,null,null,null,null,'http://springfieldgymnastics-aquatics.com',null,null,1,null,null,'Sport',null,null,'NE',0,null,null,null,'Feb 2 2011 12:00AM',null,null,null,null,'KM','Dec 8 2011 12:00AM',null,37.2036,-93.232);
  152. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66548,'Strafford Sports Complex',null,null,'9602 E. State Highway OO',null,null,'Strafford','MO','65757',null,'US','417','736-2434',null,null,null,null,null,null,null,null,'http://straffordsportscomplex.com',null,null,1,null,null,'Sport',null,null,'Out',0,null,null,null,'Feb 2 2011 12:00AM',null,null,null,null,'KM','Dec 8 2011 12:00AM',null,37.2691,-93.0828);
  153. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66561,'Springfield-Greene County Park Board - Perry Tennis Courts',null,null,'National and Bennett',null,null,'Springfield','MO','65807',null,'US','417','864-1049',null,null,null,null,null,null,null,null,'',null,null,1,null,'FREE','Sport','JR',null,null,0,null,null,null,'Feb 3 2011 12:00AM',null,null,null,null,'KM','Dec 7 2011 12:00AM',null,37.1894,-93.2764);
  154. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66576,'Custom Celebrations by Crystal',null,null,null,null,null,null,null,null,null,'US','417','880-2155',null,null,null,null,null,null,null,null,'www.customcelebrationsbycrystal.com',null,null,1,null,'PROSPECT','Mt/Bqt','JR',null,null,0,null,null,null,'Feb 7 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,null,null);
  155. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66577,'Springfield-Greene County Park Board - Chesterfield Family Center',null,null,'2511 W Republic Road',null,null,'Springfield','MO','65807',null,'US','417','891-1616','417','891-1616',null,null,null,null,null,null,'http://www.parkboard.org/info/facilities/cfc/index.html','cfc@springfieldmo.gov',null,1,null,'FREE','Sport','JR',null,'SW',0,null,null,null,'Feb 7 2011 12:00AM',null,null,null,null,'LWH','May 12 2011 12:00AM',null,37.1384,-93.3285);
  156. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66578,'Springfield-Greene County Park Board - Northview Center',null,null,'301 E Talmage',null,null,'Springfield','MO','65803',null,'US','417','837-5808',null,null,null,null,null,null,null,null,'http://www.parkboard.org/info/facilities/northview/index.html',null,null,1,null,'FREE','Sport','JR','SF','NE',0,null,null,null,'Feb 7 2011 12:00AM',null,null,null,null,'SF','May 21 2012 12:00AM',null,37.2444,-93.2908);
  157. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66579,'Springfield-Greene County Park Board - Valley Mill Equestrian Center',null,null,'4007 N FR 171',null,null,'Springfield','MO','65803',null,'US','417','833-3291','417','833-3291',null,null,null,null,null,null,'',null,null,1,null,null,'Attrac',null,null,'NE',0,null,'http://www.parkboard.org/info/city_parks/vwmec/index.htm',null,'Feb 7 2011 12:00AM',null,null,null,null,'KM','Dec 19 2011 12:00AM',null,37.2699,-93.253);
  158. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66580,'Ozark Greenways - South Dry Sac Trail',null,null,'North Grant Ave.',null,null,'Springfield ','MO','65803',null,'US','417','864-2015','417','864-1049',null,null,null,null,null,null,'http://www.ozarkgreenways.org/',null,null,1,null,null,'Parks',null,null,'NW',0,null,'http://www.ozarkgreenways.org/trails.html',null,'Feb 7 2011 12:00AM',null,null,null,null,'SD','Jun 12 2012 12:00AM',null,37.2816,-93.3012);
  159. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66581,'Ozark Greenways - James River Water Trail',null,null,null,null,null,null,null,null,null,'US','417','864-2015','417','864-1049',null,null,null,null,null,null,'http://www.ozarkgreenways.org/',null,null,1,null,null,'Parks',null,null,'SE',0,null,'',null,'Feb 7 2011 12:00AM',null,null,null,null,'SD','Jun 12 2012 12:00AM',null,37.1217,-93.2533);
  160. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66582,'Ozark Greenways - James River Greenway',null,null,null,null,null,null,null,null,null,'US','417','864-2015','417','864-1049',null,null,null,null,null,null,'http://www.ozarkgreenways.org',null,null,1,null,'FREE','Parks',null,null,'SE',0,null,null,null,'Feb 7 2011 12:00AM',null,null,null,null,'SD','Jun 12 2012 12:00AM',null,37.1193,-93.2653);
  161. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66583,'Ozark Greenways - Ward Branch Greenway',null,null,null,null,null,null,null,null,null,'US','417','864-2015','417','864-1049',null,null,null,null,null,null,'http://www.ozarkgreenways.org/',null,null,1,null,null,'Parks',null,null,'SW',0,null,null,null,'Feb 7 2011 12:00AM',null,null,null,null,'SD','Jun 12 2012 12:00AM',null,37.1197,-93.3234);
  162. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 66593,'Eldon Chamber of Commerce',null,null,'203 East First Street','PO Box 209',null,'Eldon','MO','65026',null,'US','573','392-3752',null,null,null,null,'',null,null,null,null,null,'eldoninfo@eldonchamber.com',1,null,'PROSPECT','Other','JR',null,null,0,null,'$250 used to pay offered again',null,'Feb 10 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,38.3496,-92.5802);
  163. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67104,'Pizza Hut - N. Glenstone',null,null,'1815 N Glenstone',null,null,'Springfield','MO','65803',null,'US','417','882-2300',null,null,null,null,null,null,null,null,null,null,null,1,null,'SGF ADV','Rest','RA',null,'NE',0,null,null,null,'Dec 1 2010 12:00AM','Mar 18 2011 12:00AM',null,null,null,'MD','Apr 21 2011 12:00AM',null,37.2305,-93.2613);
  164. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67105,'Pizza Hut - N Grant (Delivery/Carryout only)',null,null,'1201 N. Grant',null,null,'Springfield','MO','65802',null,'US','417','882-230',null,null,null,null,null,null,null,null,null,null,null,1,null,'SGF ADV','Rest','RA',null,'NE',0,null,null,null,'Dec 1 2010 12:00AM',null,null,null,null,'MD','Apr 21 2011 12:00AM',null,37.2214,-93.2987);
  165. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67106,'Pizza Hut - S. Campbell (Delivery/Carryout only)',null,null,'3437 S. Campbell',null,null,'Springfield','MO','65807',null,'US','417','882-2300',null,null,null,null,null,null,null,null,null,null,null,1,null,'SGF ADV','Rest','RA',null,'SW',0,null,null,null,'Dec 1 2010 12:00AM','Dec 1 2010 12:00AM',null,null,null,'MD','Apr 29 2011 12:00AM',null,37.1514,-93.2958);
  166. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67107,'Pizza Hut - S. Grant (Delivery/Carryout only)',null,null,'1212 S. Grant',null,null,'Springfield','MO','65807',null,'US','417','882-2300',null,null,null,null,null,null,null,null,null,null,null,1,null,'SGF ADV','Rest','RA',null,'SE',0,null,null,null,'Dec 1 2010 12:00AM',null,null,null,null,'MD','Apr 29 2011 12:00AM',null,37.1929,-93.2997);
  167. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67108,'Pizza Hut - W. Sunshine',null,null,'1705 W. Sunshine',null,null,'Springfield','MO','65807',null,'US','417','882-2300',null,null,null,null,null,null,null,null,null,null,null,1,null,'SGF ADV','Rest','RA',null,'SW',0,null,null,null,'Dec 1 2010 12:00AM','Jan 6 2011 12:00AM',null,null,null,'MD','Apr 29 2011 12:00AM',null,37.1826,-93.3153);
  168. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67306,'Tropical Liqueurs',null,null,'420 S. Campbell Ave Ste 100',null,null,'Springfield','MO','65806',null,'US','417','832-9067',null,null,null,null,null,null,null,null,'',null,null,1,null,'PROSPECT','Rest','JR',null,'DT',0,null,'',null,'Feb 14 2011 12:00AM','Feb 14 2011 12:00AM',null,null,null,'SG','Aug 15 2011 12:00AM',null,37.2065,-93.2942);
  169. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67308,'Taco Bell',null,null,null,null,null,null,null,null,null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA','SF',null,0,null,'Sports Commission Member decision, contact is with Williams/Crawford' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'Amanda Coffman' + CHAR(13) + CHAR(10) + 'Asst. Account Executive ' + CHAR(13) + CHAR(10) + 'Williams/Crawford & Associates' + CHAR(13) + CHAR(10) + '(479) 782-5230 ext.10 [v]' + CHAR(13) + CHAR(10) + '(479) 782-5843 [f]' + CHAR(13) + CHAR(10) + 'amanda@williams-crawford.com ' + CHAR(13) + CHAR(10) + '',null,'Feb 14 2011 12:00AM',null,null,null,null,'SF','Jul 24 2012 12:00AM',null,null,null);
  170. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67309,'Panera Bread',null,null,'500 S. National Avenue',null,null,'Springfield ','MO','65802',null,'US','417','862-9898',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA','RM',null,0,null,null,null,'Feb 14 2011 12:00AM',null,null,null,null,'RM','Feb 13 2012 12:00AM',null,37.2049,-93.276);
  171. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67310,'Nicolas Ristorante',null,null,'3631 East Sunshine Street',null,null,'Springfield','MO','65809','','US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,'RA',null,null,0,null,null,null,'Feb 14 2011 12:00AM',null,null,null,null,'SD','Feb 17 2011 12:00AM',null,37.1802,-93.2206);
  172. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67312,'Dance with Me',null,null,'Savoy Ballroom ','224 E Commercial Street',null,'Springfield','MO',null,null,'US','417','865-2255',null,null,null,null,null,null,null,null,'','dance@dancewithme.us',null,1,null,'PROSPECT','Attrac','JR',null,null,0,null,'Great music for all styles of ballroom dance, plus we''ll take requests! Gorgeous ballroom with awesome dance floor, no smoking, and great bar selection.' + CHAR(13) + CHAR(10) + 'www.DancewithMe.us',null,'Feb 15 2011 12:00AM',null,null,null,null,'SG','Jul 7 2011 12:00AM',null,37.209,-93.2923);
  173. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67313,'Veridian Event Center',null,null,'309 South Ave ',null,null,'Springfield','MO',null,'','US','417','693-0663',null,null,null,null,null,null,null,null,'veridianevents.com',null,null,1,null,'PROSPECT',null,'JR',null,null,0,null,'Parties, meetings, receptions, weddings.',null,'Feb 15 2011 12:00AM',null,null,null,null,'MD','Feb 15 2011 12:00AM',null,37.2079,-93.2928);
  174. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67314,'Macaroni Grill',null,null,'1286 E Battlefield Rd',null,null,'Springfield','MO',null,null,'US','417','881-7804',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA',null,'SW',0,null,'Bruce is owner' + CHAR(13) + CHAR(10) + 'Cody is manager' + CHAR(13) + CHAR(10) + 'Swiss helm group- ginger will answer and bruce will make decisions. 866-4605',null,'Feb 15 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,37.1596,-93.2771);
  175. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67317,'A Moment of Peace Massage',null,null,'Mailing address only','1821 Laurel Hill Place',null,'Nixa','MO','65714',null,'US','417','496-9954',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Other','JR',null,'Out',0,null,'Reduce effects of pain and stress. Sleep better, rest better, feel better. Treat your body to a massage. ',null,'Feb 16 2011 12:00AM',null,null,null,null,'LWH','May 11 2011 12:00AM',null,37.0434,-93.2944);
  176. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67318,'Downstream Casino',null,null,'Choice Marketing',null,null,'Joplin','MO',null,null,'US','417','626-0101',null,null,null,null,null,null,null,null,null,'bfranklin@choicemarketing.biz',null,1,null,'PROSPECT',null,'JR',null,null,0,null,null,null,'Feb 16 2011 12:00AM',null,null,null,null,'JR','Sep 15 2011 12:00AM',null,null,null);
  177. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67321,'R&M Dutch Cooking',null,null,'2994 South Hwy E',null,null,'Norwood','MO','65717',null,'US','417','746-0305',null,null,null,null,null,null,null,null,null,null,null,1,null,'CANCEL','Rest','RA',null,'Out',0,null,'Do group reservations for any occassion. Everything made from scratch- Amish cooking',null,'Feb 17 2011 12:00AM',null,'Apr 12 2012 12:00AM','Expsosure',null,'LWH','Apr 12 2012 12:00AM',null,37.1084,-92.4149);
  178. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67322,'Jellybean Childrens Wear',null,null,'900 E. Battlefield St.',null,null,'Springfield','MO','65807','','US','417','889 - 2117',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Shop',null,null,'SE',0,null,'In for Salute 2011 website demo.',null,'Feb 17 2011 12:00AM',null,null,null,null,'SD','Feb 17 2011 12:00AM',null,37.1591,-93.2834);
  179. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67323,'Bistro Market by Price Cutter',null,null,'401 South Avenue',null,null,'Springfield','MO','65806',null,'US','417','829-9200',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Shop','RA',null,'DT',0,null,'www.bistromarket.net' + CHAR(13) + CHAR(10) + 'Sales Blitz 2011' + CHAR(13) + CHAR(10) + '',null,'Feb 17 2011 12:00AM',null,null,null,null,'SG','Jul 12 2011 12:00AM',null,37.2071,-93.2926);
  180. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67324,'Metropolitan Grill ',null,null,'2931 E Battlefield St',null,null,'Springfield','MO','65804',null,'US','417','889-4951',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','SF',null,'SE',0,null,'',null,'Feb 17 2011 12:00AM',null,null,null,null,'SD','May 2 2012 12:00AM',null,37.159,-93.2362);
  181. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67325,'Town and County',null,null,'2660 South Glenstone Avenue',null,null,'Springfield','MO','65804',null,'US','417','883-6131',null,null,null,null,null,null,null,null,null,'townandcounty@sbcglobal.net',null,1,null,'PROSPECT','Shop','JR',null,'SE',0,null,'Sales Blitz 2011',null,'Feb 17 2011 12:00AM',null,null,null,null,'SG','Jul 15 2011 12:00AM',null,37.1657,-93.2625);
  182. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67326,'Maxon''s Diamond Merchants',null,null,'2622 South Glenstone Avenue',null,null,'Springfield','MO','65804',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Shop',null,null,null,0,null,null,null,'Feb 17 2011 12:00AM',null,null,null,null,'SD','Feb 17 2011 12:00AM',null,37.166,-93.2617);
  183. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67330,'Casper''s Chili',null,null,'601 West Walnut Street',null,null,'Springfield','MO','65806',null,'US','417','866-9750',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA',null,'DT',0,null,null,null,'Feb 17 2011 12:00AM',null,null,null,null,'MI','Apr 18 2011 12:00AM',null,37.2073,-93.2972);
  184. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67332,'Rebecca Grille',null,null,'209 E Walnut Street',null,null,'Springfield','MO','65806',null,'US','417','863-7000',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA',null,null,0,null,'New restaurant downtown' + CHAR(13) + CHAR(10) + 'Terry Baum knows owners',null,'Feb 18 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,37.2072,-93.292);
  185. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67333,'Ozark Herbalist, LLC',null,null,'608 E South Street',null,null,'Springfield','MO','65721',null,'US','417','581-herb (4372)',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Other','JR',null,null,0,null,'Life is a gift, wellness is our challenge' + CHAR(13) + CHAR(10) + 'Wellness clinic',null,'Feb 18 2011 12:00AM',null,null,null,null,'MD','Feb 25 2011 12:00AM',null,37.0041,-93.2021);
  186. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67340,'Tonya Murfin, Murney Associates Realtors',null,null,'Murney Associates Realtors','1625 E Primrose',null,'Springfield','MO','65804',null,'US','417','823-2300','417','827-1405',null,null,null,null,null,null,'http://tonyamurfinhomes.com/','tmurfin@murney.com',null,1,null,'SGF ADV','Relocate','JR',null,null,0,null,'Met at Red Crow Marketing event' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + '37.14749,-93.266429',null,'Feb 25 2011 12:00AM',null,null,null,null,'DB','Aug 29 2011 12:00AM',null,37.1475,-93.2664);
  187. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67345,'Relics Antique Mall',null,null,'2015 W. Battlefield Rd.','5 minutes W of Battlefield Mall','','Springfield','MO','65807','','US','417','885-0007','','',null,null,'','',null,null,'','relicsantiquemall@gmail.com',null,1,null,'SGF ADV','Attrac','JR',null,'SW',0,null,'Missouri''s Largest!' + CHAR(13) + CHAR(10) + 'Also have a location in Mt. Vernon' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'www.relicsantiquemall.com',null,'Mar 2 2011 12:00AM','Jun 21 2011 12:00AM',null,null,null,'SD','Aug 12 2011 12:00AM',null,37.1607,-93.3203);
  188. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67358,'Higher Power Promotions',null,null,'Post Office Box 6307',null,null,'Springfield','MO','65801',null,'US','417','988-3811','',null,null,null,null,null,null,null,'','promoter@higherpowerpromotions.com',null,1,null,'PROSPECT',null,'JR',null,null,0,null,null,null,'Mar 7 2011 12:00AM',null,null,null,null,'MD','Mar 7 2011 12:00AM',null,37.214,-93.2952);
  189. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67359,'Bass Pro Outdoor Fitness Festival',null,null,'1935 South Campbell','','','Springfield','MO','65807','','US','417','891-5214','','',null,null,'','',null,null,'www.basspro.com/fitness','fitness@basspro.com',null,1,null,'SGF ADV','Attrac','RA',null,'SW',0,null,null,null,'Mar 8 2011 12:00AM',null,null,null,null,'SD','Oct 27 2011 12:00AM',null,37.18,-93.2966);
  190. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67369,'MPB Today',null,null,null,null,null,null,null,null,null,'US','870','405-6460',null,null,null,null,null,null,null,null,'www.mpbtoday.com',null,null,1,null,'PROSPECT',null,'JR',null,null,0,null,'Called after seeing signage at the Airport',null,'Mar 10 2011 12:00AM',null,null,null,null,'MD','Mar 10 2011 12:00AM',null,null,null);
  191. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67371,'The Mustard Seed','',null,'1023 State Hwy AA',null,null,'Elkland','MO','65644',null,'US','417','933-2053',null,null,null,null,null,null,null,null,null,'suegarard@aol.com',null,1,null,'PARTNER','Lodgng','SD',null,'Out',0,null,'Partnership ended 3/12. Publications removed -SD',null,'Mar 11 2011 12:00AM','Mar 18 2011 12:00AM',null,null,null,'MD','Mar 18 2011 12:00AM',null,37.4437,-93.0573);
  192. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67372,'Talent Salad',null,null,'813 N Booneville','',null,'Springfield ','MO','65806',null,'US','417','889-9909',null,null,null,null,null,null,null,null,'www.talentsalad.com',null,null,1,null,'SGF ADV','Other','RA',null,'NE',0,null,'Located above the HUB',null,'Mar 11 2011 12:00AM',null,null,null,null,'DB','Aug 29 2011 12:00AM',null,37.2163,-93.2924);
  193. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67373,'417 Pizza',null,null,'4560 S. Campbell',null,null,'Springfield','MO','65810',null,'US','417','887-4417',null,null,null,null,null,null,null,null,'',null,null,1,null,'PROSPECT','Rest','RA',null,'S',0,null,'MD - Met at MOB' + CHAR(13) + CHAR(10) + '417pizza.com',null,'Mar 14 2011 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.1322,-93.2955);
  194. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67374,'Majestic Gems',null,null,'306 Branson Landing',null,null,'Branson','MO','65616',null,'US','417','231-4933',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Shop','JR',null,'Out',0,null,'Called about tranp at airport- New jewelry store in Branson landing' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'Call cell- 360-420-5192',null,'Mar 14 2011 12:00AM',null,null,null,null,'MD','Jun 24 2011 12:00AM',null,36.6386,-93.2144);
  195. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67375,'Doe''s Eat Place',null,null,'1232 E Trafficway',null,null,'Springfield','MO','65802',null,'US','417','869-3637',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA',null,'NE',0,null,'' + CHAR(13) + CHAR(10) + 'Bill Davis- Owner',null,'Mar 14 2011 12:00AM',null,null,null,null,'MD','May 2 2011 12:00AM',null,37.2109,-93.2751);
  196. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67378,'001 SMI Test Hotel - Plus',null,'test','250 Mt Lebanon Blvd','','','Pittsburgh','PA','15234','','US','(412)','254-9999','(800)','111-1111',null,null,'(xxx)','xxxxxxx',null,null,'www.SoftwareMgt.com','smi@softwaremgt.com',null,1,null,'PARTNER','Attrac','SMI',null,'NE',0,null,'This is for TEST only',null,'Mar 15 2011 12:00AM',null,null,null,null,'SD','Nov 14 2011 12:00AM',null,40.3678,-80.0364);
  197. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67381,'Heroes Coffee Company',null,null,'621 N. Washington','',null,'Springfield','MO','65806',null,'US','417','831-1492',null,null,null,null,null,null,null,null,'','info@heroescoffeecompany.com',null,1,null,'PROSPECT','Rest','RA',null,'NE',0,null,'www.heroescoffeecompany.com' + CHAR(13) + CHAR(10) + 'Called after annual banqet invite came back. Entered 621 N. Washingtgon address but they will be moving and she will email me with new address. 1/20/12 SG' + CHAR(13) + CHAR(10) + 'At new location they will have a retail and espresso bar.',null,'Mar 16 2011 12:00AM',null,null,null,null,'SG','Jan 20 2012 12:00AM',null,37.2142,-93.2859);
  198. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67383,'The Cake Truffle Store',null,null,'3210 N 10th Street',null,null,'Ozark','MO','65721',null,'US','417','234-0255',null,null,null,null,null,null,null,null,'www.caketrufflestore.com','thecaketrufflestore@live.com',null,1,null,'PROSPECT','Dining','JR',null,null,0,null,null,null,'Mar 17 2011 12:00AM',null,null,null,null,'MD','Mar 17 2011 12:00AM','Apr 5 2011 12:00AM',37.0493,-93.2111);
  199. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67385,'Kaleidoscope',null,null,'1430 East Sunshine Street',null,null,'Springfield','MO','68504',null,'US','417',' 889-4465',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Shop','JR',null,'SE',0,null,'http://www.kscope4fun.com/',null,'Mar 17 2011 12:00AM',null,null,null,null,'MI','Apr 18 2011 12:00AM',null,37.1816,-93.2705);
  200. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67388,'The Bretts Morning Show','',null,'Dick Clark''s American Bandstand Theater','1600 West Hwy. 76','','Branson','MO','65616','','US','417','336-4222','(877)','252-7388',null,null,'(417)','332-1982',null,null,'','info@brettfamily.com',null,1,null,'PARTNER','Attrac','JR',null,'Out',0,null,'http://www.brettfamily.com/' + CHAR(13) + CHAR(10) + '5/12 - Changes Website Pub title to The Bretts Morning Show -SD',null,'Mar 18 2011 12:00AM','Apr 25 2011 12:00AM',null,null,null,'SD','May 9 2011 12:00AM',null,36.6437,-93.2185);
  201. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67390,'Jetz Limosuine',null,null,'2432 N Eastgate','Suite 6',null,'Springfield','MO','MO',null,'US','417','576-0589',null,null,null,null,null,null,null,null,null,'info@jetzlimosuine',null,1,null,'PROSPECT','Transp','JR',null,null,0,null,'Luke called about airport/exp pricing',null,'Mar 21 2011 12:00AM',null,null,null,null,'MD','Mar 21 2011 12:00AM',null,37.24,-93.2219);
  202. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67391,'USA Prepares',null,null,null,null,null,null,null,null,null,'US','417','200-4715',null,null,null,null,null,null,null,null,'http://www.usaprepares.com/','info@usaprepares.com',null,1,null,'PROSPECT','Other','JR',null,'DT',0,null,'Mission:' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'USAprepares.com is an education centered organization dedicated to improving the emergency preparedness life-style of American families by providing practical advice and affordable solutions through our EXPO events, symposia, and charitable efforts',null,'Mar 21 2011 12:00AM',null,null,null,null,'MD','Mar 23 2011 12:00AM',null,null,null);
  203. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67392,'The Cake Pop Company',null,null,'1805 E Seminole ',null,null,'Springfield','MO','65804',null,'US','417','886-2767',null,null,null,null,null,null,null,null,'http://cakepopco.com/index.html','info@cakepopco.com',null,1,null,'PROSPECT','Dining','JR',null,null,0,null,null,null,'Mar 21 2011 12:00AM',null,null,null,null,'MD','Mar 21 2011 12:00AM',null,37.1743,-93.2624);
  204. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67393,'Names and Numbers',null,null,'1225 E Centennial','PO Box 1479','','Pittsburg','KS','66762','','US','800','592-7625','','',null,null,'','',null,null,'www.namesandnumbers.com','',null,1,null,'SGF ADV','CVBVendor','RA',null,null,0,null,'Wants to display their products at TIC for $50 a month with their own rack, we currently just have their products in the back',null,'Mar 21 2011 12:00AM',null,null,null,null,'LWH','Sep 21 2011 12:00AM',null,37.3817,-94.6825);
  205. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67394,'Springfield Roller Girls',null,null,'3820 S. Glenstone ',null,null,'Springfield','MO','65804',null,'US','','',null,null,null,null,null,null,null,null,'','springfieldrollergirls@gmail.com',null,1,null,'PROSPECT','Attrac','JR',null,'SE',0,null,'springfieldrollergirls.com',null,'Mar 22 2011 12:00AM',null,null,null,null,'SG','Aug 4 2011 12:00AM',null,37.144,-93.2537);
  206. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67396,'The Grotto',null,null,'3046 S. Kimbrough',null,null,'Springfield','MO','65807',null,'US','417','886-9600',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA',null,'SW',0,null,null,null,'Mar 24 2011 12:00AM',null,null,null,null,'SG','Jul 28 2011 12:00AM',null,37.1583,-93.2849);
  207. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67400,'The Copy Shoppe',null,null,'1446 E Sunshine',null,null,'Springfield','MO','65804',null,'US','417','887-5999',null,null,null,null,null,null,null,null,'www.thecopyshoppe.com','',null,1,null,'PROSPECT',null,'JR','LWH','SE',0,null,'Laura is getting quotes from them for printed materials.',null,'Mar 25 2011 12:00AM',null,null,null,null,'MD','Mar 25 2011 12:00AM',null,37.1817,-93.27);
  208. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67409,'Baptist Bible College',null,null,'628 East Kearney Street ',null,null,'Springfield','MO','65803',null,'US','800',' 228-5754',null,null,null,null,'417','268-6694',null,null,'http://www.gobbc.edu/',null,null,1,null,'FREE','Relocate','JR',null,'NE',0,null,null,null,'Mar 31 2011 12:00AM',null,null,null,null,'MD','Mar 31 2011 12:00AM',null,37.2406,-93.2838);
  209. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67410,'Southwest Baptist University',null,null,'1600 University Avenue',null,null,'Bolivar','MO','65613',null,'US','1-800','526-5859 ',null,null,null,null,null,null,null,null,'http://www.sbuniv.edu/',null,null,1,null,'FREE','Relocate','JR',null,'Out',0,null,'',null,'Mar 31 2011 12:00AM',null,null,null,null,'MD','Mar 31 2011 12:00AM',null,37.6011,-93.406);
  210. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67411,'Central Bible College',null,null,'300 North Grant Avenue',null,null,'Springfield','MO','65803',null,'US','800','831-4222',null,null,null,null,null,null,null,null,'http://netcom.cbcag.edu/netcommunity/page.aspx?pid=183',null,null,1,null,'FREE','Relocate','JR',null,'NE',0,null,null,null,'Mar 31 2011 12:00AM',null,null,null,null,'MD','Mar 31 2011 12:00AM',null,37.2098,-93.2987);
  211. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67412,'Quincy Magoo''s Restaurant & Pub',null,null,'900 E. Battlefield Rd.',null,null,'Springfield','MO','65807',null,'US','417','888-2066',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA','RM','SW',0,null,null,null,'Mar 31 2011 12:00AM',null,null,null,null,'RM','Jan 20 2012 12:00AM',null,37.1597,-93.2834);
  212. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67435,'Springfield Fight Club',null,null,'450 S Union Ave',null,null,'Springfield','MO','65802',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,null,0,null,'Local Favorite for website.',null,'Apr 9 2011 12:00AM',null,null,null,null,'SD','Apr 9 2011 12:00AM',null,37.2046,-93.2324);
  213. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67436,'Martino Training Systems',null,null,'4331 S. Fremont Ave',null,null,'Springfield','MO','65804',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,null,0,null,'Local Favorite',null,'Apr 9 2011 12:00AM',null,null,null,null,'SD','Apr 9 2011 12:00AM',null,37.137,-93.2721);
  214. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67437,'Icon Nightclub',null,null,'307 Park Central East',null,null,'Springfield','MO','65806',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,null,0,null,'Local Favorite',null,'Apr 9 2011 12:00AM',null,null,null,null,'SD','Apr 9 2011 12:00AM',null,37.209,-93.291);
  215. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67438,'Mark Twain Elementary School',null,null,'2352 South Weaver Avenue',null,null,'Springfield','MO','65807',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,null,0,null,'Local Favorite',null,'Apr 9 2011 12:00AM',null,null,null,null,'SD','Apr 9 2011 12:00AM',null,37.1734,-93.3052);
  216. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67439,'McDonald''s Corporation',null,null,'2111 Mcdonald''s Drive ','',null,'Oak Brook','IL','60523',null,'US','800','244-6227',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,'RA',null,null,0,null,'Local Favorite',null,'Apr 9 2011 12:00AM',null,null,null,null,'DB','Dec 29 2011 12:00AM',null,41.8476,-87.9449);
  217. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67440,'Mud House','',null,'323 South Ave.',null,null,'Springfield','MO','65806',null,'US','417','832-1720',null,null,null,null,null,null,null,null,null,null,null,1,null,'SGF ADV','Rest','RA',null,'DT',0,null,'Local Fav' + CHAR(13) + CHAR(10) + 'http://www.mudhousecoffee.com/' + CHAR(13) + CHAR(10) + 'brian@mudhousecoffee.com, rob@mudhousecoffee.com, kyle@mudhousecoffee.com',null,'Apr 9 2011 12:00AM',null,null,null,null,'RA','Apr 2 2012 12:00AM',null,37.2075,-93.2925);
  218. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67441,'Brown Derby International Wine Center',null,null,'2023 S. Glenstone Ave.',null,null,'Springfield','MO','65804',null,'US','417','883-4066',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,'RA',null,null,0,null,'Local Fav',null,'Apr 9 2011 12:00AM',null,null,null,null,'JR','Jan 5 2012 12:00AM',null,37.1775,-93.2631);
  219. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67442,'Cruse Dog Park',null,null,'2100 W Catalpa St.',null,null,'Springfield','MO','65807',null,'US','417','864-1049',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,'NW',0,null,null,null,'Apr 9 2011 12:00AM',null,null,null,null,'SG','Nov 16 2011 12:00AM',null,37.195,-93.3203);
  220. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67443,'Disabled American Veterans Thrift Store',null,null,'1711 N. Glenstone Ave.',null,null,'Springfield','MO','65803',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,null,0,null,'Local Favorite',null,'Apr 9 2011 12:00AM',null,null,null,null,'SD','Apr 9 2011 12:00AM',null,37.2283,-93.262);
  221. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67444,'Obelisk Home',null,null,'214 W. Phelps St.',null,null,'Springfield','MO','65806',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,null,0,null,'Local Favorite',null,'Apr 9 2011 12:00AM',null,null,null,null,'SD','Apr 9 2011 12:00AM',null,37.2124,-93.293);
  222. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67445,'Evergreen Church',null,null,'3225 N. Farm Road 123',null,null,'Springfield','MO','65803',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,null,0,null,'Local Favorite',null,'Apr 9 2011 12:00AM',null,null,null,null,'SD','Apr 9 2011 12:00AM',null,37.2594,-93.3646);
  223. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67446,'New Growth Ministries',null,null,'749 N Weaver Ave',null,null,'Springfield','MO','65802',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,null,0,null,'Local Favorites',null,'Apr 9 2011 12:00AM',null,null,null,null,'SD','Apr 9 2011 12:00AM',null,37.216,-93.3042);
  224. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67447,'Wing Stop',null,null,'303C E Battlefield St',null,null,'Springfield','MO','65807',null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,null,null,null,0,null,'Local Favorite',null,'Apr 9 2011 12:00AM',null,null,null,null,'SD','Apr 9 2011 12:00AM',null,37.161,-93.2917);
  225. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67448,'Alexandria''s Cupcake Cottage',null,null,'1332 E Republic Road','Ste C',null,'Springfield','MO','65804',null,'US','417','877-7528',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA',null,'SE',0,null,'Chloe (Dana''s Daughter) works there',null,'Apr 12 2011 12:00AM',null,null,null,null,'MD','Apr 29 2011 12:00AM',null,37.1371,-93.2744);
  226. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67449,'Dollar Thrifty Car Rental',null,null,'2300 N Airport Blvd',null,null,'Springfield','MO','65802',null,'US','417','616-8777',null,null,null,null,'417','616-8780',null,null,'','thrifty.com',null,1,null,'SGF ADV','Transp','RA',null,'NW',0,null,'dollar.com',null,'Apr 13 2011 12:00AM','Apr 13 2011 12:00AM',null,null,null,'DB','Sep 16 2011 12:00AM',null,37.2384,-93.3971);
  227. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67450,'Sherry Burnett-Mortgage Banker',null,null,'2006 S. Glenstone Ave','','','Springfield','MO','65804','','US','(417)','299-3434','()','',null,null,'()','',null,null,'www.sherryburnett.com','sburnett@sfcbank.com',null,1,null,'SGF ADV','Relocate','JR',null,'SE',0,null,'Met at a chamber connect lunch',null,'Apr 14 2011 12:00AM','Apr 21 2011 12:00AM',null,null,null,'SD','Aug 24 2011 12:00AM',null,37.1597,-93.281);
  228. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67452,'Dagwood''s',null,null,'1111 E. Republic Road ','#164',null,'Springfield','MO','65807',null,'US','417','886-5155',null,null,null,null,'417','886-5167',null,null,null,null,null,1,null,'PROSPECT','Rest','RA',null,null,0,null,null,null,'Apr 18 2011 12:00AM',null,null,null,null,'DB','Jan 3 2012 12:00AM',null,37.1387,-93.2804);
  229. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67453,'Sunshine Bike Shop',null,null,'1926 E. Sunshine ',null,null,'Springfield','MO','65804',null,'US','417','883-1113',null,null,null,null,null,null,null,null,null,'Kay@sunshinebike.com',null,1,null,'PROSPECT','Shop',null,null,'SE',0,null,'www.sunshinebike.com',null,'Apr 18 2011 12:00AM',null,null,null,null,'MI','Apr 18 2011 12:00AM',null,37.1815,-93.2592);
  230. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67455,'McSalty''s Pizza Cafe',null,null,'1550 East Battlefield Road','',null,'Springfield','MO','65804',null,'US','417','883-4324',null,null,null,null,null,null,null,null,null,'McSaltys@yahoo.com',null,1,null,'PROSPECT','Rest','RA','SF','SE',0,null,'www.mcsaltysbattlefield.com/' + CHAR(13) + CHAR(10) + '' + CHAR(13) + CHAR(10) + 'Battlefield location, locations have separate owners. ',null,'Apr 18 2011 12:00AM',null,null,null,null,'SF','Jul 30 2012 12:00AM',null,37.1594,-93.2668);
  231. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67456,'Big Momma''s Coffee and Espresso',null,null,'217 E. Commercial St',null,null,'Springfield','MO','65803',null,'US','417','865-9911',null,null,null,null,null,null,null,null,null,'momma@bigmommascoffee.com',null,1,null,'SGF ADV','Rest','RA',null,'DT',0,null,'http://www.bigmommascoffee.com/',null,'Apr 18 2011 12:00AM',null,null,null,null,'MI','Apr 18 2011 12:00AM',null,37.2297,-93.2914);
  232. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67457,'Lucy''s Chinese Food',null,null,'3330 S Campbell',null,null,'Springfield ','MO','65807',null,'US','417','882-5383',null,null,null,null,null,null,null,null,null,'jlgreg@live.com ',null,1,null,'PROSPECT','Rest','RA',null,'SW',0,null,'http://www.lucyschinesefood.com/',null,'Apr 18 2011 12:00AM',null,null,null,null,'MI','Apr 18 2011 12:00AM',null,37.1542,-93.2951);
  233. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67458,'Grove Spa',null,null,'1522 E. Sunshine St.',null,null,'Springfield','MO','65804',null,'US','417','881-8887',null,null,null,null,null,null,null,null,null,null,null,1,null,'SGF ADV','Attrac','JR',null,'SE',0,null,'http://www.grovespa.com/',null,'Apr 18 2011 12:00AM',null,null,null,null,'MI','Apr 18 2011 12:00AM',null,37.1816,-93.2679);
  234. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67461,'OakStar Bank',null,null,'1020 East Battlefield Street',null,null,'Springfield','MO','65807',null,'US','417',' 877-2020',null,null,null,null,null,null,null,null,null,null,null,1,null,'SGF ADV','Relocate','JR','RM','SE',0,null,'http://www.oakstarbank.com/',null,'Apr 19 2011 12:00AM',null,null,null,null,'RM','Aug 26 2011 12:00AM',null,37.1591,-93.281);
  235. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67462,'Eastland Farmers Market',null,null,'1835 E St. Louis Street',null,null,'Springfield','MO','65806',null,'US','417','862-1034',null,null,null,null,null,null,null,null,null,'',null,1,null,'PROSPECT','Attrac','JR',null,'NE',0,null,'Susan passed lead along, went to sales meeting with me. Referred travel writer.' + CHAR(13) + CHAR(10) + 'eastlandfarmersmarket@gmail.com',null,'Apr 19 2011 12:00AM',null,null,null,null,'SG','Jul 8 2011 12:00AM',null,37.2096,-93.2605);
  236. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67464,'Gallery Bistro',null,null,'220 E. Walnut',null,null,'Springfield','MO','65806',null,'US','417','866-0555',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Rest','RA',null,'DT',0,null,null,null,'Apr 19 2011 12:00AM',null,null,null,null,'SG','Jul 29 2011 12:00AM',null,37.2071,-93.2916);
  237. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67465,'The Bill Chrastil Show',null,null,null,null,null,null,null,null,null,'US',null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT',null,'JR',null,null,0,null,'Sharon passed along e-mail about brochures in info centers and we are not state-run. ',null,'Apr 20 2011 12:00AM',null,null,null,null,'MD','Apr 20 2011 12:00AM',null,null,null);
  238. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67466,'ReMax- Ron Hartman',null,null,'3745 S Fremont',null,null,'Springfield','MO','65804',null,'US','1-800','499-7369',null,null,null,null,null,null,null,null,null,null,null,1,null,'PROSPECT','Relocate','JR',null,'SE',0,null,'Cell 766-3559' + CHAR(13) + CHAR(10) + 'Sherry with Oakstar bank passed along contact to me. Met at Chamber Connect lunch (Sherry)',null,'Apr 20 2011 12:00AM',null,null,null,null,'MD','May 2 2011 12:00AM',null,37.1469,-93.2723);
  239. insert into cli_Clients ( cli_Number,cli_Name,former_name,acronym,address1,address2,address3,city,state,zip,zip4,country,phone1_ac,phone1,phone2_ac,phone2,phone3_ac,phone3,fax1_ac,fax1,fax2_ac,fax2,url,email1,email2,ip,ip_accounting,ip_status,ip_major,ip_rep1,ip_rep2,ip_region,ip_mb,ip_mb_site_id,ip_comments,ip_date_anniversary,ip_date_entered,ip_date_joined,ip_date_canceled,ip_canceled_code,ip_canceled_comments,ip_update_by,ip_update_date,date_last_rec,Latitude,Longitude ) values ( 67467,'Morgan Stanley Smith Barney LLC ',null,null,'1535 East Primrose ',null,null,'Springfield','MO','65804',null,'US','417','885-1645','800','884-5590 ',null,null,'417','882-9744',null,null,null,null,null,1,null,'PROSPECT',null,'JR','RM',null,0,null,'Met at MOB event' + CHAR(13) + CHAR(10) + 'http://fa.smithbarney.com/stacydavis/',null,'Apr 20 2011 12:00AM',null,null,null,null,'RM','Jan 6 2012 12:00AM',null,37.1472,-93.2684);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!