-
Notifications
You must be signed in to change notification settings - Fork 0
/
gridbiddb (4).sql
4503 lines (4416 loc) · 784 KB
/
gridbiddb (4).sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 03, 2013 at 11:39 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `gridbiddb`
--
DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `automailerimperial`(IN currentLat float, IN currentLng float, IN dist float)
BEGIN declare lon1 float; declare lon2 float;declare lat1 float; declare lat2 float;
-- get the original lon and lat for the userid
-- calculate lon and lat for the rectangle:
set lon1 = currentLng-dist/abs(cos(radians(currentLat))*69);
set lon2 = currentLng+dist/abs(cos(radians(currentLat))*69);
set lat1 = currentLat-(dist/69);
set lat2 = currentLat+(dist/69);
-- run the query:
SELECT *, ( 3959 * acos( cos( radians(currentLat)) * cos( radians( lat ) ) * cos( radians( lng ) - radians
(currentLng) ) + sin( radians(currentLat) ) * sin( radians( lat ) ) ) ) AS distance
FROM tbl_automail WHERE lng between lon1 and lon2 and lat between lat1 and lat2 HAVING distance < radius ORDER
BY distance;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `automailermetric`(IN currentLat float, IN currentLng float, IN dist float)
BEGIN declare lon1 float; declare lon2 float;declare lat1 float; declare lat2 float;
-- get the original lon and lat for the userid
-- calculate lon and lat for the rectangle:
set lon1 = currentLng-dist/abs(cos(radians(currentLat))*110);
set lon2 = currentLng+dist/abs(cos(radians(currentLat))*110);
set lat1 = currentLat-(dist/110);
set lat2 = currentLat+(dist/110);
-- run the query:
SELECT *, ( 6367.45 * acos( cos( radians(currentLat)) * cos( radians( lat ) ) * cos( radians( lng ) - radians
(currentLng) ) + sin( radians(currentLat) ) * sin( radians( lat ) ) ) ) AS distance
FROM tbl_automail WHERE lng between lon1 and lon2 and lat between lat1 and lat2 HAVING distance < radius ORDER
BY distance;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `geodist`(IN currentLat float, IN currentLng float, IN dist float, IN results INTEGER)
BEGIN declare lon1 float; declare lon2 float;declare lat1 float; declare lat2 float;
-- get the original lon and lat for the userid
-- calculate lon and lat for the rectangle:
set lon1 = currentLng-dist/abs(cos(radians(currentLat))*69);
set lon2 = currentLng+dist/abs(cos(radians(currentLat))*69);
set lat1 = currentLat-(dist/69);
set lat2 = currentLat+(dist/69);
-- run the query:
SELECT *, ( 3959 * acos( cos( radians(currentLat)) * cos( radians( lat ) ) * cos( radians( lng ) - radians
(currentLng) ) + sin( radians(currentLat) ) * sin( radians( lat ) ) ) ) AS distance
FROM tbl_leads WHERE lng between lon1 and lon2 and lat between lat1 and lat2 HAVING distance < dist ORDER BY
distance LIMIT results;
END$$
DELIMITER ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_articles`
--
CREATE TABLE IF NOT EXISTS `tbl_articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`framecode` varchar(50) NOT NULL COMMENT 'the frame name customer will use to edit site',
`content` varchar(3000) NOT NULL DEFAULT '' COMMENT 'the content, can include html markup',
`framename` varchar(50) NOT NULL DEFAULT 'not defined',
`type` int(3) NOT NULL DEFAULT '0' COMMENT '0-viewable, 1-meta, 2-text, 3-slideshow',
PRIMARY KEY (`id`),
UNIQUE KEY `framecode` (`framecode`,`framename`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=72 ;
--
-- Dumping data for table `tbl_articles`
--
INSERT INTO `tbl_articles` (`id`, `framecode`, `content`, `framename`, `type`) VALUES
(8, 'metaTitle', 'Solar panel installation | Get the best deal on solar panels', 'Meta Tag Title', 1),
(9, 'metaDescription', 'Save big on your monthly utility bill when solar installers compete for your roof on Gridbid. Click here to find out how to get the best deal.', 'Meta Tag Description', 1),
(10, 'metaKeywords', 'solar panel installation,solar installation, solar installers,residential solar installation,solar installers in California,solar estimate, solar auction', 'Meta Tag Keywords', 1),
(11, 'roofH1', '<div style="font-size:62px;font-weight:bold;line-height:55px;width:350px;">Get the best deal on solar</div>', 'roof Header 1', 0),
(12, 'roofH2', '<p style="margin-top:20px;margin-bottom:20px;font-size:16px;line-height:25px;">Auction your roof for free to get multiple offers from solar installers and save on rooftop solar</p>', 'roof Header 2', 0),
(13, 'roofAuctionButtonText', 'See How Much You Can Save', 'Roof Landing Page Auction Button Text', 2),
(14, 'solarRedirectStatic', 'Are you a solar contractor? ', 'Solar Redirect Static Text', 2),
(15, 'solarRedirectLink', 'Get exclusive solar leads<br />', 'Solar Redirect Link', 2),
(16, 'roofCaption1', 'Find the right installer, fast', 'Roof Page Caption 1', 2),
(17, 'roofCaption2', 'Auction any size of project', 'Roof Page Caption 2', 2),
(18, 'roofCaption3', 'Guarantee your best deal', 'Roof Page Caption 3', 2),
(19, 'roofCaption4', 'Compare bids side-by-side', 'Roof Page Caption 4', 2),
(20, 'metaDescriptionLanding', 'Save big on your solar panel installation when solar installers compete online for your roof. Click Here Now to find out how to get \r\nthe best deal!', 'Meta Description Landing Page', 1),
(21, 'metaKeywordsLanding', 'solar panels installation,solar power system, solar \r\ninstaller, residential solar, solar auction', 'Meta Keywords Landing Page', 1),
(22, 'metaDescriptionContactUs', 'Contact Us<br />', 'Meta Description Contact Us', 1),
(23, 'metaKeywordsFaq', 'FAQ, Gridbid FAQs', 'Meta Keywords FAQ', 1),
(24, 'metaDescriptionFaq', 'Here are a few frequently asked questions about Gridbid.', 'Meta Description FAQ', 1),
(25, 'metaDescriptionSoco', '<br />', 'Meta Description Soco', 1),
(26, 'metaKeywordsSoco', '', 'Meta Keywords Soco Page', 1),
(27, 'aboutWhyRoof', '<h5 style="font-weight:normal;margin-bottom:30px;padding-left:35px;">Gridbid.com is a free, easy to use website where you post details about your home or building and solar installers submit competing offers or “bids” to install solar on your roof. Unlike competitors, Gridbid starts an online competition for your roof, getting you multiple bids, ranking each bid using our proprietary Gridbid Score, and allowing you to pick the best deal based on your individual needs (no group purchasing where you take a deal put together by others)</h5>', 'not defined', 0),
(28, 'aboutWhySoco', '<h5 style="font-weight:normal;margin-bottom:30px;padding-left:35px;">Gridbid gives you a place where you can search for roofs that meet your criteria and rapidly submit proposals to those home or business owners - showing off your unique characterisitics easily. No more than four installers are allowed to bid on a roof, so at most you are competing with 3 other installers. Unlike competitors, Gridbid charges you for leads only after you exclusively secure them.</h5>', 'not defined', 0),
(29, 'bioThomas', '<table style="font-size:10pt;margin-bottom:50px;"><tbody><tr style="vertical-align:top;"><td style="width:500px;vertical-align:top;"><div class="biotitle">Chris Hunter, CEO</div><div class="biowriteup">Chris is a recognized expert in the energy and cleantech industries. Prior to joining Gridbid, Chris was Head of Development of AMSolar and Principal at Abundance Clean Energy Partners where he advised leading renewable energy companies are market entry strategy, project development, capital raises and the structuring of financial transactions. Before that, Chris founded and served as Vice President of Climate Change Capital''s (CCC) investment business in North America. In that capacity he identified, negotiated and executed new business opportunities on behalf of the firm''s $1 billion carbon infrastructure fund. Chris has a BSc in Mechanical Engineering from Rutgers University and a Joint Executive MBA from Columbia Business School and London Business School.</div><br /><a href="http://www.linkedin.com/in/hunterchris">linkedIn</a></td></tr></tbody></table>', 'not defined', 0),
(30, 'linksThomas', 'twitter: <a href="https://twitter.com/#%21/kineshanko">@kineshanko</a>, <a href="http://ca.linkedin.com/pub/thomas-kineshanko/7/252/b1">linkedIn</a>, Telephone: +1.604.317.2756<br /><br />', 'not defined', 0),
(31, 'bioKevin', '<table style="font-family:Arial, Verdana;font-size:10pt;margin-bottom:50px;"><tbody><tr style="vertical-align:top;"><td style="width:500px;vertical-align:top;"><div class="biotitle">Thomas Kineshanko, CTO</div>\r\n<div class="biowriteup">Thomas is Canadian entrepreneur focused on using technology to solve environmental problems. Thomas is the founder of Habitat Enterprises and Radiant Carbon, co-founder of Gridbid, and a co-founding equity partner of GreenAngel Energy, North America’s first publicly traded Greentech fund. Thomas has led multiple successful rounds of venture and project finance and has worked on renewable energy projects on four continents. Thomas is a graduate of Simon Fraser University, the National University of Singapore, and was recently chosen to attend the Graduate Studies Program at Singularity University - a NASA and Google backed incubator for technology entrepreneurs that has an admissions rate six times lower than a Harvard MBA. Thomas is also a two-time academic and athletic All-American in Track & Field.</div><br />twitter: <a href="https://twitter.com/#%21/kineshanko">@kineshanko</a>, <a href="http://ca.linkedin.com/pub/thomas-kineshanko/7/252/b1">linkedIn</a>, Telephone: +1.415.632.6754<br /></td>\r\n</tr></tbody></table>', 'not defined', 0),
(32, 'linksKevin', 'twitter: <a href="https://twitter.com/#!/kevinstarke">@kevinstarke</a>, <a href="http://ca.linkedin.com/pub/kevin-starke/27/ba0/400">linkedIn</a><br /><br />', 'not defined', 0),
(33, 'linkMarc', 'twitter: <a href="https://twitter.com/#!/marcbx">@marcbx</a>, <a href="http://ca.linkedin.com/pub/marc-baumgartner/3/777/1b4">linkedIn</a><br /><br />', 'not defined', 0),
(34, 'linkDaniela', '<a href="http://ca.linkedin.com/in/dkorinth">linkedIn</a><br /><br />', 'not defined', 0),
(35, 'metaTitleSoco', 'Solar panel installation | Get the best deal on solar panels<br />', 'not defined', 1),
(36, 'aboutBetterTime', '<h3 style="margin-bottom:15px;">This is the best time in history to go solar</h3>\r\n<h5 style="font-weight:normal;margin-bottom:20px;padding-right:5px;">The price of solar has decreased by over 50% in the last 2 years, creating an amazing opportunity to reduce your electricity bill and lock in your electricity price today to avoid future price increases. There are a number of incentives available that make installing solar still more financially attractive. Further, solar installers will install solar on your home or business for no upfront cost, allowing you to instantly start saving on your utility bill. Gridbid allows you to ensure that when you are ready to go solar, you get the best possible deal and the process is streamlined and fun. You can try Gridbid free with no obligation today.</h5>', 'not defined', 0),
(37, 'bioMarc', '<table style="font-family:Arial, Verdana;font-size:10pt;margin-bottom:50px;"><tbody><tr style="vertical-align:top;"><td style="width:500px;vertical-align:top;"><div class="biotitle">Marc Baumgartner, Designer</div>\r\n<div class="biowriteup">Marc is a veteran entrepreneur and designer,\r\nhaving co-founded Ayoudo, Codename Design and lead all design at NowPublic\r\nthrough its inception, substantial venture financing, and acquisition by\r\nExaminer.com in 2009. Marc is also an avid cyclist who puts the rest of the\r\nGridbid team to shame not only in design, but also on a road bike.\r\n</div><br />twitter: <a href="https://twitter.com/#%21/marcbx">@marcbx</a>, <a href="http://ca.linkedin.com/pub/marc-baumgartner/3/777/1b4">linkedIn</a></td>\r\n</tr></tbody></table>', 'not defined', 0),
(38, 'bioDaniela', '<table style="font-family:Arial, Verdana;font-size:10pt;margin-bottom:50px;"><tbody><tr style="vertical-align:top;"><td style="width:500px;vertical-align:top;"><div class="biotitle">Kevin Starke, Co-Founder</div>\r\n<div class="biowriteup">Kevin is a co-founder of Gridbid, Habitat Enterprises and PowerLend with over four years of experience analyzing renewable energy opportunities in both North and South America. Kevin previously worked for KPMG in Canada and Euro-Trend in Europe where he had work published on International Policy. Kevin has a Bachelor of Commerce from the University of Victoria where he received the Medal of Excellence for receiving the top academic scores of any graduant. In his youth Kevin was a sponsored skateboarder and is now an aspiring triathlete.</div><br />twitter: <a href="http://twitter.com/KevinStarke">@kevinstarke</a>, <a href="http://ca.linkedin.com/in/kevinstarke/">linkedIn</a></td>\r\n</tr></tbody></table>', 'not defined', 0),
(39, 'bioSpencer', '<table style="font-family:Arial, Verdana;font-size:10pt;margin-bottom:50px;"><tbody><tr style="vertical-align:top;"><td style="width:500px;vertical-align:top;"><div class="biotitle">Spencer, Loyalty</div>\r\n<div class="biowriteup">Spencer is a dog, and is extremely loyal. Between fetch matches, naps, and meals, Spencer finds time to keep the Gridbid team having fun and working hard to dramatically improve how building owners go solar.\r\n</div></td>\r\n</tr></tbody></table>', 'not defined', 0),
(40, 'linkSpencer', '<br />', 'not defined', 0),
(41, 'aboutLeadIn', '<h4 style="font-weight:normal;margin-top:0px;margin-bottom:25px;padding-right:5px;">Launched in 2012, Gridbid auctioned more than $300,000 in rooftop solar projects in its first week online, helping numerous building owners go solar and many solar installers secure great new customers. Gridbid is a product of Habitat Enterprises, an independent, privately held company with offices in Berkeley and Vancouver.</h4>', 'About Lead In', 0),
(42, 'creditFormTop', '<div style="margin:0 30px;"> <div style="font-size:24px;font-weight:bold;margin-bottom:10px;">Payment Details</div> <div style="margin-bottom:10px;font-size:13px;">Please enter your credit card information below. No charges will be made to this card until you have been selected as the winning bidder of a Gridbid auction. At that point you will be charged Gridbid''s exclusive lead fee at $100 per kW (DC) of installation size.</div> </div>', 'not defined', 0),
(43, 'aboutSecurity', '<h3 style="margin-bottom:15px;">Security</h3> \r\n<h5 style="font-weight:normal;">By default your data is securely stored in the Gridbid cloud using world-class technology and techniques.</h5>', 'not defined', 0),
(44, 'aboutHomeOwners', '<div class="portletShadowBox" style="margin-bottom:40px;">\r\n<img src="images/title_homeowner.png" alt="Gridbid for Homeowners" style="font-size:20px;font-weight:bold;" /><h4 style="font-weight:normal;">Gridbid.com is for anyone who owns a building with a roof who needs to reduce their monthly utility bill by going solar.<br /><a href="#homeowners">Learn more</a></h4>\r\n</div>', 'not defined', 0),
(45, 'aboutInstallers', '<div class="portletShadowBox">\r\n<img src="images/title_installers.png" alt="Gridbid for Installers" style="font-size:20px;font-weight:bold;" /><h4 style="font-weight:normal;">With Gridbid you only pay for customers you actually get. Gridbid.com is for any solar installer who needs to reduce the cost of vetting and securing roofs to install solar on. <a href="#installers">Learn more</a></h4>\r\n</div>', 'not defined', 0),
(46, 'bioAaron', '<table style="font-family:Arial, Verdana;font-size:10pt;margin-bottom:50px;"><tbody><tr style="vertical-align:top;"><td style="width:500px;vertical-align:top;"><div class="biotitle">Aaron Kennedy, Software Development</div>\r\n<div class="biowriteup">Aaron graduated with a Master’s in Electro-mechanical engineering from the University of British Columbia. After a placement at the European Space Agency in Holland he attended the International Space University in 2005. He recently completed his Project Management Professional certification. The Gridbid initiative struck a chord with his desire to work on projects that have major environmental impact and he is excited to be involved as a developer.</div><br />twitter: <a href="https://twitter.com/#%21/dmkdesign79">@dmkdesign79</a>, <a href="http://www.linkedin.com/pub/aaron-kennedy/4/645/780">linkedIn</a><br /></td>\r\n</tr></tbody></table>', 'not defined', 0),
(47, 'metaKeywordsAbout', 'solar panel kits, solar installer, installation solar power, installation solar panels cost, solar leads, reduce utility bill<br />', 'Meta tag for about page', 1),
(48, 'metaDescriptionAbout', 'On this page we explain how Gridbid solar auctions work and why this is the best time to go solar.<br />', 'Meta Tag for About Description', 1),
(49, 'metaTitleAbout', 'The world''s first rooftop solar auction - About Gridbid', 'Title Tag contents', 1),
(50, 'bioInvestors', '<h3>Investors</h3>\r\n<h5 style="margin-bottom:50px;font-weight:normal;">Gridbid is funded by Habitat Enterprises and a number of successful Angel Investors in the renewable energy marketplace including Matthew Shaw, Ralph Turfus, and Michael Volker. </h5>', 'not defined', 0),
(51, 'refund', '<h2>Refund Policy</h2><p>Gridbid will refund 100% of its fee if notified within 60 days of an auction closing that a contract between the winning installer and the building owner has not, and will not be signed. Gridbid requires written documentation from the installer proving that the building owner has chosen not to move forward with the installer''s contract. This can come in the form of an email or other written document from the building owner stating their intention to not sign a contract. If documentation is not provided stating that a contract will not be signed, then Gridbid will contact the building owner directly to verify that a contract will not be signed. <br /><br />Gridbid will refund 50% its fee if notified after 2 months of an auction closing that a contract between the winning installer and the building owner has not, and will not be signed. Gridbid requires written documentation from the installer proving that the building owner has chosen not to move forward with the installer''s contract. This can come in the form of an email or other written document from the building owner stating their intention to not sign a contract. If documentation is not provided stating that a contract will not be signed, then Gridbid will contact the building owner directly to verify that a contract will not be signed. <br /><br />All refunds from Gridbid will be processed within 5 business days of Gridbid receiving written documentation or verbal verification from a building owner that a contract will not be signed.<br /><br /></p><p></p>', 'not defined', 0),
(52, 'roofSEOtext', '<div style="font-size:14px;"> At Gridbid we believe that it is time to switch to clean and renewable energy sources and we believe there has been no better time in history to go solar than right now. <br /><br /><strong>Solar energy - A clean source of energy</strong> <br />Solar energy is considered a true alternative to fossil fuels (such as oil, coal and gasoline). It is a natural, clean and renewable source of energy that is expected to last for at least another 4 billion years (depending on how long the sun provides us with its light). We can use solar energy to produce cleaner, better electricity with solar cells either located on rooftops or on the ground.<br /><br /><strong>Solar energy - An affordable alternative</strong> <br /> With the price for solar panels decreasing over 50% in the last 2 years solar power has been expanding rapidly. This has allowed for more competition within the US solar industry and as a result solar cells have become more efficient while production costs have dramatically decreased. Different types of subsidies, including federal, state and local solar incentives as well as solar rebate programs, are also making going solar more attractive than ever before. There are even different payment options available and there is no longer the need to pay a large amount of cash upfront to have solar panels installed. <br /><br /><strong>Solar energy - A great investment for future savings </strong> <br /> With solar energy you start reducing your monthly utility bill as soon as your solar power system goes live. Depending on the form of financing you choose there might be a monthly solar lease or PPA fee for your solar power system. The lease/PPA fee is usually still cheaper than the amount of your old monthly utility bill. With your own solar power system your electricity rate will be predictable and you will be able to protect yourself from rising energy cost for the next 20 plus years. <br /><br /> Gridbid helps you find the best deal on rooftop solar by having solar installers submit competing offers for your solar installation.<br /><a href="http://www.gridbid.com/index.php?r=leadsWizard/WizardStart&step=gettingStarted">Start saving money each month by going solar now.</a> </div>', 'not defined', 0),
(53, 'socoH1', '<div style="font-size:62px;font-weight:bold;line-height:55px;">Save 80% Securing Roof Leads</div>', 'not defined', 0),
(54, 'socoH2', '<div style="margin:19px 0;font-size:14px;line-height:20px;">Pay business development costs only for roofs you actually secure. Simply find roofs up for auction on Gridbid, review the detailed roof information and place a bid that highlights your unique characteristics. If your bid wins the auction, the lead is exclusively yours. </div>', 'not defined', 0),
(55, 'socoLandingPic', '<div class="slide" style="background-color:#FFFFFF;">\n <img style="margin:auto;" alt="Slide 1" src="images/solar1.jpg" width="500" /><div class="caption">Only pay for leads you get</div>\n</div>\n<div class="slide" style="background-color:#FFFFFF;">\n <img style="margin:auto;" alt="Slide 5" src="images/solar2.jpg" width="500" /><div class="caption">Find any size of project</div>\n</div>\n<div class="slide" style="background-color:#FFFFFF;">\n <img style="margin:auto;" alt="Slide 3" src="images/solar3.jpg" width="500" /><div class="caption">Differentiate yourself from your competition</div>\n</div>\n<div class="slide" style="background-color:#FFFFFF;">\n <img style="margin:auto;" alt="Slide 2" src="images/solar4.jpg" width="500" /><div class="caption">Save money securing leads</div>\n</div>', 'not defined', 2),
(56, 'automailHeader', '<h3 style="color:#02A1DE;margin-top:10px;">Sign up for auction alerts</h3>\n<p>Gridbid will send you an email to alert you of any new auctions posted.</p>', 'not defined', 0),
(57, 'bidRules', '<div style="font-size:18px;font-weight:bold;margin-bottom:15px;">Auction Rules</div>\n<div style="font-size:14px;">\nEach installer can submit only one bid per auction and a maximum of 4 \nbids are allowed per auction. Once the proposal deadline is reached, the\nbuilding owner will review the bids and select the winning bidder. That\nbidder will be given the detailed contact information of the building \nowner, who is awaiting their call. If your bid wins, the building owner \nhas agreed to exclusively negotiate your solar contract, but are not \nobligated to sign your contract.</div>', 'not defined', 0),
(58, 'bidWizardTitle', '<div style="font-size:24px;">Bid on this project!</div>', 'not defined', 0),
(59, 'bidForm_FeeText', '<div style="margin-bottom:15px;">I agree that if I am selected as the winning bidder for this auction, I will pay Gridbid $100 per kW DC of installation size included in my winning bid. </div> ', 'not defined', 0),
(60, 'bidFAQ1_Question', 'How Bidding Works. ', 'not defined', 0),
(61, 'bidFAQ1_Answer', '<div style="font-size:14px;">Submit your bid by signing in and filling in your bid information in 4 easy steps.<br /><br />Each installer can submit only one bid per auction and a maximum of 4 bids are allowed per auction, so submit yours fast! <br /><br />Once the proposal deadline is reached, the building owner will review the bids and select the winning bidder. That bidder will be given the detailed contact information of the building owner, who is awaiting their call.<br /><br />If your bid wins, the building owner has agreed to exclusively negotiate your solar contract, but are not obligated to sign your contract.</div>', 'not defined', 0),
(62, 'bidFAQ2_Question', 'Lowest Bid Does Not Always Win ', 'not defined', 0),
(63, 'bidFAQ2_Answer', '<div style="font-size:14px;">The lowest price bid does not always win. Price, warranty, utility bill savings, equipment quality, energy production, installer track record and key differentiators are all presented to building owners for them to make their decision. This gives installers the ability to separate themselves from their competition. Each bid is also given a Gridbid Score to help building owners identify the best bid for them.</div>', 'not defined', 0),
(64, 'bidFAQ3_Question', 'Gridbid Score', 'not defined', 0),
(65, 'bidFAQ3_Answer', '<div style="font-size:14px;">Each bid is given a Gridbid Score. This Gridbid Score is meant to help building owners identify the best bid for them. The Gridbid Score is based on a number of factors including: price, system and power warranty, equipment quality, energy bill savings, energy production and installer track record. Aim to be competitive on all of these factors to maximize your Gridbid Score.</div> ', 'not defined', 0),
(66, 'bidFAQ4_Question', 'Bid Requirements ', 'not defined', 0),
(67, 'bidFAQ4_Answer', '<div style="font-size:14px;">All bids presented on Gridbid include the following information: financial details for the primary financing option, financial details for additional financing options available from the installer, key differentiators that separate the installer from its competition, system specs, system and power warranty, number of installations completed by the installer to date, and the environmental benefits created by the installation.</div>', 'not defined', 0),
(68, 'bidFAQ5_Question', 'Gridbid Fee', 'not defined', 0),
(69, 'bidFAQ5_Answer', '<div style="font-size:14px;">The winning bidder of each auction is charged a Gridbid Fee. The Gridbid Fee is $100 per kW DC of installation size for the system included in the winning bid. This fee is payable within 10 days of winning the auction and is refundable if the auction does not turn into a contract.</div>', 'not defined', 0),
(70, 'aboutAddress', '<h3>Contact Info</h3>\r\n\r\n<div class="biowriteup">\r\nGridbid<br />\r\n1 Little West 12th Street<br />\r\nNew York City, NY<br />\r\nUnited States 10014<br /><br />\r\n\r\nPhone: 1-855-474-3243<br />\r\nEmail: [email protected]</div>\r\n<br />', 'not defined', 0),
(71, 'landingNews', '<div class="clear-fix" style="color:#00A0DE;font-size:22px;font-weight:bold;margin-bottom:15px;">Gridbid has been featured in the following publications</div>\r\n<table><tbody><tr style="height:75px;"><td style="width:225px;border-right:1px solid #D9D9D9;"><div style="margin:auto;width:169px;"><a href="http://www.fastcoexist.com/1679974/how-valuable-is-your-roof-put-it-up-for-solar-auction"><img src="images/fastcompany_logo1.png" alt="fastcompany" /></a></div></td>\r\n<td style="width:225px;border-right:1px solid #D9D9D9;"><div style="margin:auto;width:95px;"><a href="http://www.good.is/post/gridbid-auction-off-your-sunny-unused-roof-space"><img src="images/good_logo2.png" alt="good" /></a></div></td>\r\n<td style="width:225px;border-right:1px solid #D9D9D9;"><div style="margin:auto;width:90px;"><a href="http://grist.org/climate-energy/auction-yer-roof-and-other-ways-of-streamlining-distributed-energy"><img src="images/grist_logo2.png" alt="grist" /></a></div></td>\r\n<td style="width:225px;"><div style="margin:auto;width:126px;"><a href="http://www.mnn.com/your-home/at-home/blogs/gridbid-a-rooftop-auction-site-for-solar-seeking-homeowners"><img src="images/mnn_logo2.png" alt="mother nature network" /></a></div></td>\r\n</tr></tbody></table>', 'not defined', 0);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_auctions`
--
CREATE TABLE IF NOT EXISTS `tbl_auctions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`project_id` int(11) NOT NULL COMMENT 'foreign_key from project table. Not unique.',
`time_start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'the date the auction was created',
`winningBid` int(11) DEFAULT NULL COMMENT 'id of the winning bid.',
`status` int(11) NOT NULL DEFAULT '0' COMMENT '0 is inactive, 1 is active',
`auctionType` int(11) NOT NULL DEFAULT '0' COMMENT '0-blind, 1 - silent, 2-traditional',
`duration` int(11) NOT NULL DEFAULT '720' COMMENT 'number of hours the auction is live for past the time_start',
PRIMARY KEY (`id`),
KEY `project` (`project_id`),
KEY `winningbid` (`winningBid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This table holds active and inactive auctions.' AUTO_INCREMENT=603 ;
--
-- Dumping data for table `tbl_auctions`
--
INSERT INTO `tbl_auctions` (`id`, `project_id`, `time_start`, `winningBid`, `status`, `auctionType`, `duration`) VALUES
(2, 1, '2012-02-06 23:05:58', 186, 2, 0, 720),
(3, 2, '2012-02-06 23:11:11', 0, 6, 0, 720),
(4, 3, '2012-02-07 22:02:50', 0, 6, 0, 720),
(5, 4, '2012-02-10 18:58:55', 16, 2, 0, 720),
(6, 5, '2012-02-12 21:54:39', 15, 2, 0, 720),
(7, 6, '2012-02-13 04:04:45', 0, 6, 0, 720),
(8, 7, '2012-02-16 08:01:16', 0, 6, 0, 720),
(9, 8, '2012-02-16 17:03:39', 18, 2, 0, 720),
(10, 9, '2012-02-16 23:19:10', 11, 2, 0, 720),
(11, 10, '2012-02-17 02:05:33', 10, 2, 0, 720),
(12, 11, '2012-02-17 02:26:51', NULL, 6, 0, 720),
(13, 12, '2012-02-17 02:37:31', 0, 6, 0, 720),
(14, 13, '2012-02-17 02:49:48', 0, 6, 0, 720),
(15, 14, '2012-02-17 22:35:33', 0, 6, 0, 720),
(16, 16, '2012-02-20 19:56:18', 0, 6, 0, 720),
(17, 18, '2012-02-21 08:22:18', 0, 6, 0, 720),
(18, 15, '2012-02-21 08:27:52', 0, 6, 0, 720),
(19, 19, '2012-02-21 08:30:39', 0, 6, 0, 720),
(20, 21, '2012-02-21 19:04:51', 9, 2, 0, 720),
(21, 22, '2012-02-22 20:08:49', 0, 6, 0, 720),
(22, 23, '2012-02-22 20:45:19', 0, 6, 0, 720),
(23, 24, '2012-02-22 21:50:31', 0, 6, 0, 720),
(24, 25, '2012-02-22 22:23:35', 0, 6, 0, 720),
(25, 26, '2012-02-23 01:16:39', 0, 6, 0, 720),
(26, 20, '2012-02-23 01:21:16', 0, 6, 0, 720),
(27, 27, '2012-02-23 08:23:39', 0, 6, 0, 720),
(28, 28, '2012-02-23 15:27:02', 6, 2, 0, 720),
(29, 17, '2012-02-23 16:10:18', 0, 6, 0, 720),
(30, 29, '2012-02-23 21:49:07', 12, 2, 0, 720),
(31, 30, '2012-02-23 22:17:24', 0, 6, 0, 720),
(32, 31, '2012-02-23 23:00:13', 0, 6, 0, 720),
(33, 32, '2012-02-23 23:20:47', 0, 6, 0, 720),
(34, 33, '2012-02-24 00:17:04', 0, 6, 0, 720),
(35, 34, '2012-02-24 00:53:35', 0, 6, 0, 720),
(36, 36, '2012-02-24 01:04:11', 0, 6, 0, 720),
(37, 37, '2012-02-24 01:09:05', 0, 6, 0, 720),
(38, 38, '2012-02-24 02:23:14', 0, 6, 0, 720),
(39, 41, '2012-02-24 06:50:35', 0, 6, 0, 720),
(40, 40, '2012-02-24 06:52:48', 0, 6, 0, 720),
(41, 46, '2012-02-25 01:56:16', 0, 6, 0, 720),
(42, 47, '2012-02-27 21:25:56', 0, 6, 0, 720),
(43, 49, '2012-02-29 04:09:07', 0, 6, 0, 720),
(44, 51, '2012-03-05 05:33:02', 0, 6, 0, 720),
(45, 53, '2012-03-06 19:46:44', 0, 6, 0, 720),
(46, 55, '2012-03-07 07:16:15', 0, 6, 0, 720),
(47, 56, '2012-03-07 18:55:58', 0, 1, 0, 720),
(48, 54, '2012-03-08 19:17:30', 0, 1, 0, 720),
(49, 58, '2012-03-10 21:25:42', 0, 6, 0, 720),
(50, 59, '2012-03-18 00:00:42', 0, 6, 0, 720),
(51, 61, '2012-03-18 03:59:55', 24, 2, 0, 720),
(52, 62, '2012-03-18 19:43:03', 0, 6, 0, 720),
(53, 63, '2012-03-19 20:03:34', 0, 6, 0, 720),
(54, 65, '2012-03-20 16:37:29', 0, 1, 0, 720),
(55, 39, '2012-03-20 18:49:24', 0, 6, 0, 720),
(56, 66, '2012-03-20 19:09:26', 0, 6, 0, 720),
(57, 67, '2012-03-21 05:50:39', 0, 1, 0, 720),
(58, 68, '2012-03-23 00:58:37', 0, 1, 0, 720),
(59, 69, '2012-03-26 01:52:41', 0, 1, 0, 720),
(60, 70, '2012-03-27 02:48:32', 0, 6, 0, 720),
(61, 71, '2012-03-28 18:28:57', 0, 6, 0, 720),
(65, 2, '2012-04-01 19:17:09', NULL, 6, 0, 720),
(66, 74, '2012-04-11 14:38:29', NULL, 6, 0, 720),
(67, 75, '2012-04-11 18:54:43', NULL, 6, 0, 720),
(68, 77, '2012-04-14 15:17:14', NULL, 1, 0, 720),
(69, 78, '2012-04-15 21:18:33', NULL, 1, 0, 720),
(70, 79, '2012-04-17 19:43:44', NULL, 1, 0, 720),
(71, 80, '2012-04-19 17:48:14', NULL, 6, 0, 720),
(72, 81, '2012-04-20 16:33:17', 37, 2, 0, 720),
(73, 84, '2012-04-21 22:49:50', NULL, 6, 0, 720),
(74, 85, '2012-04-22 14:13:59', NULL, 1, 0, 720),
(75, 86, '2012-04-22 17:08:55', NULL, 6, 0, 720),
(76, 83, '2012-04-23 21:47:45', NULL, 1, 0, 720),
(77, 88, '2012-04-25 12:21:52', NULL, 6, 0, 720),
(78, 90, '2012-04-27 05:33:41', NULL, 6, 0, 720),
(79, 97, '2012-04-27 06:20:18', NULL, 6, 0, 720),
(80, 99, '2012-04-27 06:25:37', NULL, 6, 0, 720),
(81, 100, '2012-04-27 06:26:12', NULL, 6, 0, 720),
(82, 96, '2012-04-27 13:10:39', NULL, 6, 0, 720),
(83, 101, '2012-04-27 17:50:08', NULL, 6, 0, 720),
(84, 102, '2012-05-02 18:43:36', NULL, 6, 0, 720),
(85, 103, '2012-05-05 04:55:48', NULL, 1, 0, 720),
(86, 105, '2012-05-10 17:47:35', NULL, 6, 0, 720),
(87, 106, '2012-05-10 23:08:56', NULL, 6, 0, 720),
(88, 107, '2012-05-12 00:27:28', NULL, 1, 0, 720),
(89, 109, '2012-05-14 22:25:52', NULL, 6, 0, 720),
(90, 110, '2012-05-15 19:34:06', NULL, 1, 0, 720),
(91, 111, '2012-05-15 20:45:19', NULL, 1, 0, 720),
(92, 115, '2012-05-16 02:27:51', NULL, 6, 0, 720),
(93, 117, '2012-05-18 16:48:01', NULL, 6, 0, 720),
(94, 119, '2012-05-22 22:52:04', NULL, 6, 0, 720),
(95, 120, '2012-05-23 01:27:59', NULL, 6, 0, 720),
(96, 121, '2012-05-23 15:06:12', NULL, 6, 0, 720),
(97, 122, '2012-05-23 21:33:14', NULL, 6, 0, 720),
(98, 124, '2012-05-24 05:04:58', NULL, 6, 0, 720),
(99, 125, '2012-05-24 16:40:25', NULL, 1, 0, 720),
(100, 126, '2012-05-29 15:10:33', NULL, 6, 0, 720),
(101, 127, '2012-05-30 18:36:05', NULL, 6, 0, 720),
(102, 130, '2012-06-06 12:25:58', NULL, 6, 0, 720),
(103, 131, '2012-06-07 15:22:29', NULL, 6, 0, 720),
(104, 132, '2012-06-07 18:21:09', NULL, 1, 0, 720),
(105, 133, '2012-06-07 18:43:54', NULL, 6, 0, 720),
(106, 136, '2012-06-07 20:14:01', NULL, 6, 0, 720),
(107, 135, '2012-06-07 20:14:17', NULL, 6, 0, 720),
(108, 137, '2012-06-07 20:35:45', NULL, 6, 0, 720),
(109, 139, '2012-06-07 21:12:22', NULL, 6, 0, 720),
(110, 140, '2012-06-07 21:44:46', NULL, 6, 0, 720),
(111, 141, '2012-06-07 21:54:43', NULL, 1, 0, 720),
(112, 142, '2012-06-07 22:07:46', NULL, 6, 0, 720),
(113, 143, '2012-06-08 00:20:03', NULL, 1, 0, 720),
(114, 144, '2012-06-08 01:04:21', NULL, 6, 0, 720),
(115, 145, '2012-06-08 02:36:56', NULL, 6, 0, 720),
(116, 147, '2012-06-08 03:20:35', NULL, 6, 0, 720),
(117, 150, '2012-06-08 17:00:01', NULL, 1, 0, 720),
(118, 149, '2012-06-08 17:00:22', NULL, 6, 0, 720),
(119, 152, '2012-06-08 18:32:06', NULL, 6, 0, 720),
(120, 153, '2012-06-08 18:41:17', NULL, 6, 0, 720),
(121, 154, '2012-06-08 19:05:05', NULL, 1, 0, 720),
(122, 156, '2012-06-09 07:10:59', NULL, 6, 0, 720),
(123, 157, '2012-06-09 15:54:34', NULL, 1, 0, 720),
(124, 158, '2012-06-09 21:33:03', NULL, 6, 0, 720),
(125, 159, '2012-06-10 00:24:31', NULL, 6, 0, 720),
(126, 160, '2012-06-10 03:34:44', NULL, 1, 0, 720),
(127, 161, '2012-06-10 04:09:05', NULL, 6, 0, 720),
(128, 162, '2012-06-10 13:37:34', NULL, 6, 0, 720),
(129, 164, '2012-06-10 17:16:26', NULL, 1, 0, 720),
(130, 165, '2012-06-10 17:34:05', NULL, 6, 0, 720),
(131, 166, '2012-06-10 20:53:30', NULL, 1, 0, 720),
(132, 168, '2012-06-11 21:58:33', 55, 2, 0, 720),
(133, 169, '2012-06-11 22:17:29', NULL, 1, 0, 720),
(134, 172, '2012-06-12 03:57:49', NULL, 1, 0, 720),
(135, 171, '2012-06-12 04:32:32', NULL, 6, 0, 720),
(136, 174, '2012-06-12 15:12:24', NULL, 6, 0, 720),
(137, 173, '2012-06-12 17:04:31', NULL, 6, 0, 720),
(138, 175, '2012-06-12 17:06:49', NULL, 6, 0, 720),
(139, 176, '2012-06-12 18:05:40', NULL, 6, 0, 720),
(140, 177, '2012-06-12 19:03:16', NULL, 6, 0, 720),
(141, 178, '2012-06-12 19:09:47', NULL, 6, 0, 720),
(142, 179, '2012-06-12 19:28:29', NULL, 1, 0, 720),
(143, 180, '2012-06-12 19:31:30', NULL, 6, 0, 720),
(144, 181, '2012-06-12 19:41:36', NULL, 6, 0, 720),
(145, 182, '2012-06-12 19:42:21', NULL, 1, 0, 720),
(146, 183, '2012-06-12 19:42:34', NULL, 6, 0, 720),
(147, 184, '2012-06-12 19:45:58', NULL, 6, 0, 720),
(148, 187, '2012-06-12 19:52:30', 78, 2, 0, 720),
(149, 188, '2012-06-12 19:52:32', NULL, 6, 0, 720),
(150, 189, '2012-06-12 19:53:33', NULL, 6, 0, 720),
(151, 186, '2012-06-12 19:55:19', NULL, 6, 0, 720),
(152, 190, '2012-06-12 20:00:29', NULL, 6, 0, 720),
(153, 192, '2012-06-12 20:05:34', NULL, 1, 0, 720),
(154, 193, '2012-06-12 20:07:54', NULL, 6, 0, 720),
(155, 191, '2012-06-12 20:09:39', NULL, 1, 0, 720),
(156, 194, '2012-06-12 20:14:13', NULL, 6, 0, 720),
(157, 196, '2012-06-12 20:24:20', NULL, 6, 0, 720),
(158, 195, '2012-06-12 20:25:19', NULL, 6, 0, 720),
(159, 198, '2012-06-12 20:32:25', NULL, 6, 0, 720),
(160, 199, '2012-06-12 20:36:22', NULL, 6, 0, 720),
(161, 201, '2012-06-12 20:43:55', 144, 2, 0, 720),
(162, 203, '2012-06-12 20:50:55', NULL, 6, 0, 720),
(163, 205, '2012-06-12 21:00:16', NULL, 6, 0, 720),
(164, 207, '2012-06-12 21:06:35', NULL, 6, 0, 720),
(165, 206, '2012-06-12 21:06:50', NULL, 1, 0, 720),
(166, 202, '2012-06-12 21:08:16', NULL, 6, 0, 720),
(167, 208, '2012-06-12 21:09:46', NULL, 6, 0, 720),
(168, 209, '2012-06-12 21:13:57', NULL, 6, 0, 720),
(169, 210, '2012-06-12 21:17:02', NULL, 6, 0, 720),
(170, 211, '2012-06-12 21:17:39', NULL, 6, 0, 720),
(171, 212, '2012-06-12 21:19:11', NULL, 6, 0, 720),
(172, 213, '2012-06-12 21:26:21', NULL, 6, 0, 720),
(173, 214, '2012-06-12 21:31:58', NULL, 1, 0, 720),
(174, 215, '2012-06-12 21:32:42', NULL, 6, 0, 720),
(175, 218, '2012-06-12 21:41:44', NULL, 6, 0, 720),
(176, 220, '2012-06-12 21:44:04', NULL, 6, 0, 720),
(177, 219, '2012-06-12 21:44:33', NULL, 6, 0, 720),
(178, 221, '2012-06-12 21:56:05', NULL, 6, 0, 720),
(179, 222, '2012-06-12 21:58:32', NULL, 6, 0, 720),
(180, 224, '2012-06-12 22:01:45', NULL, 6, 0, 720),
(181, 225, '2012-06-12 22:03:43', NULL, 6, 0, 720),
(182, 227, '2012-06-12 22:12:56', 154, 2, 0, 720),
(183, 229, '2012-06-12 22:20:33', NULL, 6, 0, 720),
(184, 228, '2012-06-12 22:20:52', NULL, 6, 0, 720),
(185, 230, '2012-06-12 22:21:26', NULL, 6, 0, 720),
(186, 231, '2012-06-12 22:27:01', NULL, 6, 0, 720),
(187, 232, '2012-06-12 22:31:29', NULL, 6, 0, 720),
(188, 233, '2012-06-12 22:40:00', NULL, 1, 0, 720),
(189, 234, '2012-06-12 22:45:32', NULL, 1, 0, 720),
(190, 235, '2012-06-12 22:50:16', NULL, 6, 0, 720),
(191, 236, '2012-06-12 22:52:43', NULL, 6, 0, 720),
(192, 237, '2012-06-12 23:06:44', NULL, 6, 0, 720),
(193, 238, '2012-06-12 23:09:27', NULL, 1, 0, 720),
(194, 240, '2012-06-12 23:12:31', NULL, 6, 0, 720),
(195, 239, '2012-06-12 23:13:19', NULL, 6, 0, 720),
(196, 241, '2012-06-12 23:15:04', NULL, 6, 0, 720),
(197, 242, '2012-06-12 23:16:48', NULL, 6, 0, 720),
(198, 243, '2012-06-12 23:21:15', NULL, 6, 0, 720),
(199, 244, '2012-06-12 23:59:40', NULL, 6, 0, 720),
(200, 245, '2012-06-13 00:00:09', NULL, 6, 0, 720),
(201, 246, '2012-06-13 00:21:05', NULL, 1, 0, 720),
(202, 247, '2012-06-13 00:40:48', NULL, 6, 0, 720),
(203, 249, '2012-06-13 01:04:12', NULL, 6, 0, 720),
(204, 250, '2012-06-13 01:05:29', NULL, 6, 0, 720),
(205, 251, '2012-06-13 01:19:23', NULL, 6, 0, 720),
(206, 252, '2012-06-13 01:34:18', NULL, 6, 0, 720),
(207, 253, '2012-06-13 01:37:34', NULL, 6, 0, 720),
(208, 254, '2012-06-13 01:38:18', NULL, 6, 0, 720),
(209, 255, '2012-06-13 02:00:14', NULL, 1, 0, 720),
(210, 256, '2012-06-13 02:02:07', NULL, 6, 0, 720),
(211, 258, '2012-06-13 02:07:33', NULL, 6, 0, 720),
(212, 260, '2012-06-13 02:17:30', NULL, 6, 0, 720),
(213, 261, '2012-06-13 02:21:03', NULL, 6, 0, 720),
(214, 262, '2012-06-13 02:23:21', NULL, 6, 0, 720),
(215, 263, '2012-06-13 02:34:11', NULL, 6, 0, 720),
(216, 264, '2012-06-13 02:39:40', NULL, 6, 0, 720),
(217, 265, '2012-06-13 02:42:19', NULL, 1, 0, 720),
(218, 266, '2012-06-13 02:45:11', NULL, 6, 0, 720),
(219, 267, '2012-06-13 02:59:47', NULL, 6, 0, 720),
(220, 269, '2012-06-13 03:48:22', 91, 2, 0, 720),
(221, 270, '2012-06-13 03:58:47', NULL, 6, 0, 720),
(222, 271, '2012-06-13 04:30:21', 63, 2, 0, 720),
(223, 272, '2012-06-13 04:48:12', NULL, 1, 0, 720),
(224, 274, '2012-06-13 04:54:18', NULL, 6, 0, 720),
(225, 275, '2012-06-13 05:06:49', NULL, 6, 0, 720),
(226, 276, '2012-06-13 05:39:29', NULL, 6, 0, 720),
(227, 268, '2012-06-13 05:40:15', NULL, 6, 0, 720),
(228, 278, '2012-06-13 06:39:54', NULL, 6, 0, 720),
(229, 280, '2012-06-13 07:03:20', NULL, 6, 0, 720),
(230, 281, '2012-06-13 07:44:05', NULL, 6, 0, 720),
(231, 282, '2012-06-13 08:12:49', NULL, 6, 0, 720),
(232, 283, '2012-06-13 10:40:41', NULL, 6, 0, 720),
(233, 284, '2012-06-13 11:08:27', NULL, 6, 0, 720),
(234, 285, '2012-06-13 12:04:22', NULL, 1, 0, 720),
(235, 286, '2012-06-13 12:41:29', NULL, 6, 0, 720),
(236, 287, '2012-06-13 13:25:18', NULL, 6, 0, 720),
(237, 288, '2012-06-13 14:15:25', NULL, 6, 0, 720),
(238, 289, '2012-06-13 14:25:06', NULL, 6, 0, 720),
(239, 290, '2012-06-13 14:42:21', NULL, 6, 0, 720),
(240, 291, '2012-06-13 14:52:04', NULL, 6, 0, 720),
(241, 292, '2012-06-13 15:06:13', NULL, 6, 0, 720),
(242, 293, '2012-06-13 15:09:09', NULL, 6, 0, 720),
(243, 294, '2012-06-13 15:16:01', 170, 2, 0, 720),
(244, 295, '2012-06-13 15:24:37', NULL, 6, 0, 720),
(245, 296, '2012-06-13 15:37:12', NULL, 6, 0, 720),
(246, 297, '2012-06-13 16:50:11', NULL, 1, 0, 720),
(247, 298, '2012-06-13 17:00:26', NULL, 6, 0, 720),
(248, 300, '2012-06-13 18:23:26', NULL, 6, 0, 720),
(249, 302, '2012-06-13 19:56:51', NULL, 6, 0, 720),
(250, 303, '2012-06-13 20:20:12', NULL, 6, 0, 720),
(251, 304, '2012-06-13 20:45:12', NULL, 6, 0, 720),
(252, 305, '2012-06-13 20:51:17', NULL, 6, 0, 720),
(253, 307, '2012-06-13 21:35:53', NULL, 6, 0, 720),
(254, 308, '2012-06-13 22:04:52', NULL, 6, 0, 720),
(255, 309, '2012-06-13 23:03:28', NULL, 6, 0, 720),
(256, 310, '2012-06-13 23:06:25', NULL, 6, 0, 720),
(257, 311, '2012-06-13 23:12:25', NULL, 6, 0, 720),
(258, 313, '2012-06-14 00:55:55', NULL, 1, 0, 720),
(259, 315, '2012-06-14 02:11:12', NULL, 6, 0, 720),
(260, 317, '2012-06-14 03:00:44', NULL, 6, 0, 720),
(261, 320, '2012-06-14 03:47:07', NULL, 6, 0, 720),
(262, 322, '2012-06-14 03:56:11', NULL, 6, 0, 720),
(263, 323, '2012-06-14 04:01:02', NULL, 6, 0, 720),
(264, 325, '2012-06-14 04:22:16', NULL, 6, 0, 720),
(265, 326, '2012-06-14 06:22:45', NULL, 6, 0, 720),
(266, 327, '2012-06-14 10:28:57', NULL, 6, 0, 720),
(267, 328, '2012-06-14 10:34:42', NULL, 6, 0, 720),
(268, 329, '2012-06-14 10:54:43', NULL, 6, 0, 720),
(269, 331, '2012-06-14 13:06:05', NULL, 6, 0, 720),
(270, 332, '2012-06-14 13:20:26', NULL, 6, 0, 720),
(271, 336, '2012-06-14 17:49:09', NULL, 6, 0, 720),
(272, 337, '2012-06-14 18:02:55', NULL, 6, 0, 720),
(273, 338, '2012-06-14 18:16:18', NULL, 1, 0, 720),
(274, 339, '2012-06-14 18:22:46', NULL, 6, 0, 720),
(275, 341, '2012-06-14 18:52:22', NULL, 6, 0, 720),
(276, 342, '2012-06-14 19:34:56', NULL, 6, 0, 720),
(277, 345, '2012-06-14 21:08:19', NULL, 6, 0, 720),
(278, 346, '2012-06-14 21:12:27', NULL, 6, 0, 720),
(279, 347, '2012-06-14 21:43:14', NULL, 6, 0, 720),
(280, 349, '2012-06-14 21:53:20', NULL, 6, 0, 720),
(281, 350, '2012-06-14 22:18:08', NULL, 6, 0, 720),
(282, 351, '2012-06-14 23:46:32', NULL, 6, 0, 720),
(283, 352, '2012-06-14 23:49:54', NULL, 1, 0, 720),
(284, 353, '2012-06-15 00:14:15', NULL, 1, 0, 720),
(285, 354, '2012-06-15 00:52:50', NULL, 1, 0, 720),
(286, 357, '2012-06-15 02:31:50', NULL, 1, 0, 720),
(287, 358, '2012-06-15 02:38:08', NULL, 6, 0, 720),
(288, 360, '2012-06-15 04:11:02', NULL, 6, 0, 720),
(289, 362, '2012-06-15 05:03:28', NULL, 6, 0, 720),
(290, 363, '2012-06-15 05:36:11', NULL, 6, 0, 720),
(291, 364, '2012-06-15 08:46:38', NULL, 6, 0, 720),
(292, 365, '2012-06-15 12:30:05', NULL, 6, 0, 720),
(293, 366, '2012-06-15 14:18:31', NULL, 6, 0, 720),
(294, 367, '2012-06-15 14:25:06', NULL, 1, 0, 720),
(295, 368, '2012-06-15 16:38:09', NULL, 6, 0, 720),
(296, 369, '2012-06-15 16:48:32', NULL, 6, 0, 720),
(297, 370, '2012-06-15 18:22:56', NULL, 6, 0, 720),
(298, 371, '2012-06-15 18:24:31', NULL, 6, 0, 720),
(299, 372, '2012-06-15 18:39:03', NULL, 6, 0, 720),
(300, 373, '2012-06-15 18:43:09', NULL, 6, 0, 720),
(301, 374, '2012-06-15 19:04:47', NULL, 6, 0, 720),
(302, 375, '2012-06-15 19:47:37', NULL, 6, 0, 720),
(303, 376, '2012-06-15 21:08:05', NULL, 6, 0, 720),
(304, 377, '2012-06-15 22:22:58', NULL, 6, 0, 720),
(305, 378, '2012-06-15 22:48:16', NULL, 6, 0, 720),
(306, 379, '2012-06-16 01:29:43', NULL, 6, 0, 720),
(307, 380, '2012-06-16 02:34:32', NULL, 1, 0, 720),
(308, 381, '2012-06-16 03:44:00', NULL, 6, 0, 720),
(309, 383, '2012-06-16 05:00:09', NULL, 1, 0, 720),
(310, 384, '2012-06-16 05:19:24', NULL, 1, 0, 720),
(311, 385, '2012-06-16 05:22:08', NULL, 1, 0, 720),
(312, 388, '2012-06-16 16:28:06', NULL, 6, 0, 720),
(313, 390, '2012-06-16 16:38:34', NULL, 6, 0, 720),
(314, 392, '2012-06-16 19:38:05', NULL, 6, 0, 720),
(315, 316, '2012-06-16 20:45:00', NULL, 6, 0, 720),
(316, 393, '2012-06-17 02:05:11', 67, 2, 0, 720),
(317, 394, '2012-06-17 06:02:44', NULL, 1, 0, 720),
(318, 330, '2012-06-17 11:33:02', NULL, 6, 0, 720),
(319, 395, '2012-06-17 13:05:53', NULL, 6, 0, 720),
(320, 397, '2012-06-17 15:14:13', NULL, 6, 0, 720),
(321, 398, '2012-06-17 17:08:42', NULL, 1, 0, 720),
(322, 399, '2012-06-18 00:57:27', NULL, 6, 0, 720),
(323, 400, '2012-06-18 01:19:22', NULL, 1, 0, 720),
(324, 402, '2012-06-18 04:23:45', NULL, 6, 0, 720),
(325, 401, '2012-06-18 04:27:20', 122, 2, 0, 720),
(326, 403, '2012-06-18 04:28:57', NULL, 6, 0, 720),
(327, 404, '2012-06-18 12:10:39', NULL, 6, 0, 720),
(328, 405, '2012-06-18 13:44:00', NULL, 6, 0, 720),
(329, 406, '2012-06-18 15:24:11', NULL, 6, 0, 720),
(330, 407, '2012-06-18 15:30:07', NULL, 6, 0, 720),
(331, 408, '2012-06-18 16:16:25', NULL, 6, 0, 720),
(332, 409, '2012-06-18 16:33:22', NULL, 6, 0, 720),
(333, 410, '2012-06-18 18:06:28', NULL, 1, 0, 720),
(334, 413, '2012-06-18 20:00:49', NULL, 6, 0, 720),
(335, 414, '2012-06-18 20:22:40', NULL, 1, 0, 720),
(336, 415, '2012-06-18 20:25:46', NULL, 1, 0, 720),
(337, 417, '2012-06-18 20:52:13', NULL, 6, 0, 720),
(338, 418, '2012-06-18 21:22:05', NULL, 6, 0, 720),
(339, 419, '2012-06-18 22:38:39', NULL, 1, 0, 720),
(340, 420, '2012-06-18 23:16:52', NULL, 6, 0, 720),
(341, 422, '2012-06-18 23:51:09', NULL, 1, 0, 720),
(342, 424, '2012-06-19 12:19:12', NULL, 6, 0, 720),
(343, 426, '2012-06-19 13:49:01', NULL, 1, 0, 720),
(344, 427, '2012-06-19 14:30:15', NULL, 1, 0, 720),
(345, 428, '2012-06-19 15:27:25', NULL, 6, 0, 720),
(346, 430, '2012-06-19 17:08:00', NULL, 6, 0, 720),
(347, 431, '2012-06-19 21:07:17', NULL, 6, 0, 720),
(348, 432, '2012-06-19 22:21:33', NULL, 6, 0, 720),
(349, 434, '2012-06-20 05:51:04', NULL, 6, 0, 720),
(350, 435, '2012-06-20 13:55:29', NULL, 1, 0, 720),
(351, 436, '2012-06-20 17:14:26', NULL, 6, 0, 720),
(352, 437, '2012-06-20 18:37:01', NULL, 6, 0, 720),
(353, 299, '2012-06-20 18:38:03', NULL, 6, 0, 720),
(354, 439, '2012-06-20 19:52:25', NULL, 6, 0, 720),
(355, 440, '2012-06-20 20:54:11', 169, 2, 0, 720),
(356, 441, '2012-06-20 21:00:38', NULL, 1, 0, 720),
(357, 443, '2012-06-21 04:42:15', NULL, 6, 0, 720),
(358, 444, '2012-06-21 16:18:29', 137, 2, 0, 720),
(359, 433, '2012-06-21 17:29:35', NULL, 6, 0, 720),
(360, 446, '2012-06-21 19:16:05', NULL, 1, 0, 720),
(361, 445, '2012-06-21 19:19:39', NULL, 6, 0, 720),
(362, 447, '2012-06-21 20:21:25', 172, 2, 0, 720),
(363, 448, '2012-06-21 22:31:57', NULL, 1, 0, 720),
(364, 450, '2012-06-22 01:14:56', NULL, 6, 0, 720),
(365, 451, '2012-06-22 03:05:31', NULL, 6, 0, 720),
(366, 452, '2012-06-22 17:11:57', NULL, 1, 0, 720),
(367, 454, '2012-06-22 19:59:38', NULL, 6, 0, 720),
(368, 429, '2012-06-22 20:28:32', 79, 2, 0, 720),
(369, 453, '2012-06-22 21:53:51', NULL, 6, 0, 720),
(370, 455, '2012-06-23 01:14:20', NULL, 1, 0, 720),
(371, 456, '2012-06-23 01:14:37', NULL, 1, 0, 720),
(372, 457, '2012-06-23 01:18:47', NULL, 6, 0, 720),
(373, 458, '2012-06-23 04:31:35', NULL, 6, 0, 720),
(374, 460, '2012-06-23 20:27:28', NULL, 1, 0, 720),
(375, 462, '2012-06-25 12:23:00', NULL, 6, 0, 720),
(376, 463, '2012-06-25 15:46:42', NULL, 6, 0, 720),
(377, 464, '2012-06-25 16:33:33', NULL, 1, 0, 720),
(378, 465, '2012-06-26 02:28:52', NULL, 6, 0, 720),
(379, 324, '2012-06-26 04:55:36', NULL, 6, 0, 720),
(380, 466, '2012-06-26 14:44:56', NULL, 6, 0, 720),
(381, 467, '2012-06-26 17:38:16', NULL, 6, 0, 720),
(382, 468, '2012-06-26 18:11:40', NULL, 6, 0, 720),
(383, 471, '2012-06-27 03:30:05', NULL, 6, 0, 720),
(384, 473, '2012-06-27 14:41:57', NULL, 1, 0, 720),
(385, 474, '2012-06-27 18:20:20', 82, 2, 0, 720),
(386, 475, '2012-06-27 22:55:25', NULL, 1, 0, 720),
(387, 476, '2012-06-27 23:45:17', NULL, 6, 0, 720),
(388, 477, '2012-06-28 00:10:50', 103, 2, 0, 720),
(389, 478, '2012-06-28 02:13:37', NULL, 6, 0, 720),
(390, 479, '2012-06-28 04:16:42', NULL, 6, 0, 720),
(391, 481, '2012-06-28 15:23:18', NULL, 1, 0, 720),
(392, 482, '2012-06-28 15:24:44', NULL, 6, 0, 720),
(393, 484, '2012-06-28 15:44:02', NULL, 6, 0, 720),
(394, 485, '2012-06-28 16:04:37', NULL, 6, 0, 720),
(395, 486, '2012-06-28 16:27:28', NULL, 6, 0, 720),
(396, 487, '2012-06-28 16:47:38', NULL, 6, 0, 720),
(397, 488, '2012-06-28 17:17:01', NULL, 6, 0, 720),
(398, 489, '2012-06-28 17:54:38', NULL, 1, 0, 720),
(399, 490, '2012-06-28 18:29:39', NULL, 1, 0, 720),
(400, 492, '2012-06-28 19:47:12', NULL, 1, 0, 720),
(401, 494, '2012-06-28 21:15:43', 102, 2, 0, 720),
(402, 495, '2012-06-29 13:39:00', NULL, 6, 0, 720),
(403, 496, '2012-06-29 19:08:46', NULL, 6, 0, 720),
(404, 497, '2012-06-29 20:02:06', NULL, 6, 0, 720),
(405, 470, '2012-06-29 20:08:16', NULL, 1, 0, 720),
(406, 498, '2012-06-29 20:22:59', NULL, 6, 0, 720),
(407, 499, '2012-06-29 22:04:07', NULL, 1, 0, 720),
(408, 491, '2012-06-30 00:37:13', NULL, 6, 0, 720),
(409, 500, '2012-06-30 19:53:38', NULL, 6, 0, 720),
(410, 501, '2012-06-30 21:44:40', NULL, 6, 0, 720),
(411, 502, '2012-06-30 23:29:12', NULL, 6, 0, 720),
(412, 503, '2012-07-01 16:43:56', NULL, 6, 0, 720),
(413, 505, '2012-07-02 14:37:48', NULL, 1, 0, 720),
(414, 506, '2012-07-03 03:05:24', NULL, 1, 0, 720),
(415, 507, '2012-07-03 03:13:56', NULL, 6, 0, 720),
(416, 508, '2012-07-03 16:01:37', NULL, 6, 0, 720),
(417, 509, '2012-07-03 21:10:27', NULL, 6, 0, 720),
(418, 512, '2012-07-04 19:48:08', NULL, 1, 0, 720),
(419, 514, '2012-07-04 21:57:55', 99, 2, 0, 720),
(420, 515, '2012-07-05 00:41:48', NULL, 6, 0, 720),
(421, 511, '2012-07-05 04:56:44', NULL, 6, 0, 720),
(422, 472, '2012-07-05 16:42:41', NULL, 6, 0, 720),
(423, 516, '2012-07-06 02:40:28', NULL, 6, 0, 720),
(424, 517, '2012-07-06 08:07:33', NULL, 6, 0, 720),
(425, 519, '2012-07-07 06:02:15', NULL, 6, 0, 720),
(426, 520, '2012-07-07 14:41:52', NULL, 1, 0, 720),
(427, 411, '2012-07-09 19:49:32', NULL, 6, 0, 720),
(428, 521, '2012-07-09 20:18:22', NULL, 6, 0, 720),
(429, 522, '2012-07-09 21:41:06', NULL, 6, 0, 720),
(430, 523, '2012-07-09 23:05:01', NULL, 1, 0, 720),
(431, 525, '2012-07-10 05:33:10', 114, 2, 0, 720),
(432, 526, '2012-07-10 11:54:42', 134, 2, 0, 720),
(433, 527, '2012-07-10 18:18:35', NULL, 6, 0, 720),
(434, 529, '2012-07-11 16:03:05', NULL, 6, 0, 720),
(435, 530, '2012-07-11 16:05:56', NULL, 6, 0, 720),
(436, 531, '2012-07-11 17:11:10', NULL, 6, 0, 720),
(437, 532, '2012-07-12 22:30:08', NULL, 6, 0, 720),
(438, 535, '2012-07-14 06:25:19', NULL, 6, 0, 720),
(439, 538, '2012-07-15 20:01:31', NULL, 6, 0, 720),
(440, 539, '2012-07-16 16:03:34', NULL, 6, 0, 720),
(441, 540, '2012-07-16 21:37:44', NULL, 1, 0, 720),
(442, 541, '2012-07-17 02:59:30', NULL, 6, 0, 720),
(443, 542, '2012-07-17 03:54:44', NULL, 6, 0, 720),
(444, 543, '2012-07-17 15:32:43', NULL, 6, 0, 720),
(445, 545, '2012-07-17 18:57:11', NULL, 6, 0, 720),
(446, 545, '2012-07-17 18:57:52', NULL, 1, 0, 720),
(447, 546, '2012-07-17 22:17:18', NULL, 6, 0, 720),
(448, 548, '2012-07-18 18:38:43', NULL, 6, 0, 720),
(449, 549, '2012-07-18 21:43:11', NULL, 6, 0, 720),
(450, 550, '2012-07-18 23:12:00', NULL, 6, 0, 720),
(451, 551, '2012-07-19 00:27:14', NULL, 6, 0, 720),
(452, 554, '2012-07-20 20:26:16', NULL, 6, 0, 720),
(453, 555, '2012-07-20 23:17:12', NULL, 6, 0, 720),
(454, 557, '2012-07-21 03:05:55', NULL, 6, 0, 720),
(455, 558, '2012-07-21 06:46:35', NULL, 6, 0, 720),
(456, 559, '2012-07-21 14:00:06', NULL, 1, 0, 720),
(457, 561, '2012-07-22 18:04:59', NULL, 6, 0, 720),
(458, 563, '2012-07-23 16:18:34', NULL, 6, 0, 720),
(459, 564, '2012-07-24 16:18:25', NULL, 6, 0, 720),
(460, 552, '2012-07-24 18:59:22', NULL, 6, 0, 720),
(461, 565, '2012-07-25 17:02:35', NULL, 6, 0, 720),
(462, 567, '2012-07-26 11:21:46', NULL, 6, 0, 720),
(463, 568, '2012-07-26 12:10:39', NULL, 1, 0, 720),
(464, 569, '2012-07-26 17:53:29', NULL, 6, 0, 720),
(465, 570, '2012-07-26 20:10:06', NULL, 1, 0, 720),
(466, 571, '2012-07-26 22:57:17', 168, 2, 0, 720),
(467, 572, '2012-07-26 23:19:41', NULL, 6, 0, 720),
(468, 573, '2012-07-26 23:27:29', NULL, 1, 0, 720),
(469, 574, '2012-07-27 20:46:27', NULL, 6, 0, 720),
(470, 575, '2012-07-27 20:56:45', NULL, 1, 0, 720),
(471, 576, '2012-07-28 00:11:30', NULL, 6, 0, 720),
(472, 578, '2012-07-28 19:23:27', NULL, 6, 0, 720),
(473, 579, '2012-07-29 00:47:56', NULL, 6, 0, 720),
(474, 580, '2012-07-29 17:34:07', 171, 2, 0, 720),
(475, 582, '2012-07-30 04:51:10', NULL, 6, 0, 720),
(476, 584, '2012-07-30 22:48:39', NULL, 6, 0, 720),
(477, 585, '2012-07-31 04:47:58', NULL, 6, 0, 720),
(478, 586, '2012-07-31 16:55:52', NULL, 6, 0, 720),
(479, 587, '2012-07-31 17:42:02', 179, 2, 0, 720),
(480, 588, '2012-07-31 18:56:41', 217, 2, 0, 720),
(481, 589, '2012-07-31 22:00:40', NULL, 6, 0, 720),
(482, 590, '2012-08-01 00:24:33', NULL, 6, 0, 720),
(483, 591, '2012-08-01 22:07:53', NULL, 6, 0, 720),
(484, 592, '2012-08-02 14:35:03', NULL, 1, 0, 720),
(485, 593, '2012-08-02 15:53:39', NULL, 6, 0, 720),
(486, 597, '2012-08-03 14:54:31', NULL, 1, 0, 720),
(487, 598, '2012-08-03 17:47:10', NULL, 6, 0, 720),
(488, 599, '2012-08-03 19:21:41', NULL, 6, 0, 720),
(489, 600, '2012-08-04 01:38:22', NULL, 1, 0, 720),
(490, 601, '2012-08-04 18:08:50', NULL, 6, 0, 720),
(491, 602, '2012-08-04 20:24:42', NULL, 1, 0, 720),
(492, 604, '2012-08-05 01:19:53', NULL, 6, 0, 720),
(493, 607, '2012-08-05 18:35:28', NULL, 1, 0, 720),
(494, 608, '2012-08-05 20:36:56', NULL, 6, 0, 720),
(495, 614, '2012-08-08 02:15:04', NULL, 6, 0, 720),
(496, 615, '2012-08-08 13:10:07', NULL, 1, 0, 720),
(497, 616, '2012-08-09 17:50:19', NULL, 1, 0, 720),
(498, 617, '2012-08-10 02:25:36', NULL, 6, 0, 720),
(499, 618, '2012-08-10 05:09:41', NULL, 1, 0, 720),
(500, 620, '2012-08-11 18:53:37', NULL, 1, 0, 720),
(501, 621, '2012-08-11 20:03:56', NULL, 6, 0, 720),
(502, 612, '2012-08-11 20:11:03', 190, 2, 0, 720),
(503, 613, '2012-08-11 20:11:19', NULL, 1, 0, 720),
(504, 622, '2012-08-11 22:08:57', NULL, 6, 0, 720),
(505, 624, '2012-08-12 17:15:26', NULL, 1, 0, 720),
(506, 625, '2012-08-12 20:39:57', NULL, 6, 0, 720),
(507, 626, '2012-08-13 02:14:51', NULL, 1, 0, 720),
(508, 627, '2012-08-13 18:02:33', NULL, 1, 1, 720),
(509, 630, '2012-08-14 00:52:10', NULL, 6, 0, 720),
(510, 631, '2012-08-14 06:56:26', NULL, 6, 0, 720),
(511, 632, '2012-08-16 10:51:16', NULL, 6, 0, 720),
(512, 633, '2012-08-17 18:13:25', NULL, 6, 0, 720),
(513, 634, '2012-08-17 21:08:40', NULL, 6, 0, 720),
(514, 635, '2012-08-18 11:28:55', NULL, 6, 0, 720),
(515, 636, '2012-08-18 23:26:26', NULL, 6, 0, 720),
(516, 637, '2012-08-19 15:54:36', NULL, 6, 0, 720),
(517, 638, '2012-08-21 15:47:38', NULL, 1, 0, 720),
(518, 639, '2012-08-23 23:20:11', NULL, 6, 0, 720),
(519, 640, '2012-08-25 20:24:15', NULL, 6, 0, 720),
(520, 641, '2012-08-26 14:19:59', NULL, 6, 0, 720),
(521, 642, '2012-08-28 17:05:25', NULL, 6, 0, 720),
(522, 643, '2012-08-30 23:37:23', NULL, 6, 0, 720),
(523, 644, '2012-09-03 01:00:27', NULL, 6, 0, 720),
(524, 646, '2012-09-06 06:53:50', NULL, 1, 0, 720),
(525, 647, '2012-09-06 09:53:41', NULL, 6, 0, 720),
(526, 648, '2012-09-13 13:54:32', NULL, 6, 0, 720),
(527, 651, '2012-09-26 19:55:38', NULL, 1, 0, 720),
(528, 654, '2012-10-05 15:49:03', NULL, 6, 0, 720),
(529, 656, '2012-10-08 01:56:20', NULL, 6, 0, 720),
(530, 657, '2012-10-09 16:35:18', NULL, 6, 0, 720),
(531, 658, '2012-10-10 15:19:40', NULL, 6, 0, 720),
(532, 659, '2012-10-12 16:53:24', NULL, 6, 0, 720),
(533, 662, '2012-10-17 00:46:42', NULL, 6, 0, 720),
(534, 663, '2012-10-17 06:42:50', NULL, 6, 0, 720),
(535, 664, '2012-10-17 18:30:10', NULL, 6, 0, 720),
(536, 665, '2012-10-17 20:13:38', NULL, 6, 0, 720),
(537, 667, '2012-10-22 13:16:57', NULL, 6, 0, 720),
(538, 668, '2012-10-23 10:43:43', NULL, 6, 0, 720),
(539, 669, '2012-11-01 16:23:12', NULL, 6, 0, 720),
(540, 670, '2012-11-01 20:30:41', NULL, 6, 0, 720),
(541, 671, '2012-11-04 22:56:40', NULL, 6, 0, 720),
(542, 673, '2012-11-15 17:17:59', NULL, 6, 0, 720),
(543, 676, '2012-12-01 07:27:28', NULL, 6, 0, 720),
(544, 677, '2012-12-02 13:57:49', NULL, 6, 0, 720),
(545, 678, '2012-12-03 17:45:19', NULL, 6, 0, 720),
(546, 681, '2012-12-12 17:16:00', NULL, 6, 0, 720),
(547, 682, '2012-12-12 17:19:10', NULL, 6, 0, 720),
(548, 683, '2012-12-21 05:45:11', NULL, 6, 0, 720),
(549, 685, '2012-12-26 23:40:30', NULL, 6, 0, 720),
(550, 686, '2013-01-02 15:17:46', NULL, 6, 0, 720),
(551, 687, '2013-01-02 17:05:05', NULL, 6, 0, 720),
(552, 688, '2013-01-03 06:48:56', NULL, 6, 0, 720),
(553, 690, '2013-01-12 07:01:08', NULL, 6, 0, 720),
(554, 691, '2013-01-15 16:05:59', NULL, 6, 0, 720),
(555, 692, '2013-01-15 18:01:13', NULL, 6, 0, 720),
(556, 694, '2013-01-21 05:02:11', NULL, 6, 0, 720),
(557, 695, '2013-01-23 18:03:41', NULL, 6, 0, 720),
(558, 696, '2013-01-27 04:04:11', NULL, 6, 0, 720),
(559, 697, '2013-02-02 06:29:52', NULL, 6, 0, 720),
(560, 698, '2013-02-15 00:11:52', NULL, 6, 0, 720),
(561, 699, '2013-02-22 16:02:12', NULL, 6, 0, 720),
(562, 700, '2013-03-11 06:15:01', NULL, 6, 0, 720),
(563, 701, '2013-03-12 21:50:45', NULL, 6, 0, 720),
(564, 702, '2013-03-19 16:54:50', NULL, 6, 0, 720),
(565, 704, '2013-04-18 17:41:32', NULL, 6, 0, 720),
(566, 705, '2013-04-19 19:39:49', NULL, 6, 0, 720),
(567, 706, '2013-04-25 18:56:11', NULL, 6, 0, 720),
(568, 707, '2013-04-29 18:12:13', NULL, 6, 0, 720),
(569, 708, '2013-05-12 08:30:42', NULL, 6, 0, 720),
(570, 711, '2013-06-10 02:00:04', NULL, 6, 0, 720),
(571, 712, '2013-06-12 02:16:12', NULL, 6, 0, 720),
(572, 713, '2013-06-17 19:57:10', NULL, 6, 0, 720),
(573, 714, '2013-06-18 19:09:15', NULL, 6, 0, 720),
(574, 715, '2013-06-20 15:39:37', NULL, 6, 0, 720),
(575, 716, '2013-06-21 17:54:23', NULL, 6, 0, 720),
(576, 717, '2013-06-24 23:09:25', NULL, 6, 0, 720),
(577, 718, '2013-06-30 18:23:55', NULL, 6, 0, 720),
(578, 719, '2013-07-03 13:52:47', NULL, 6, 0, 720),
(579, 720, '2013-07-08 03:42:47', NULL, 6, 0, 720),
(580, 721, '2013-07-18 17:40:58', NULL, 6, 0, 720),
(581, 722, '2013-07-19 04:55:12', NULL, 6, 0, 720),
(582, 723, '2013-07-21 05:35:13', NULL, 6, 0, 720),
(583, 724, '2013-07-21 17:16:27', NULL, 0, 0, 720),
(584, 725, '2013-08-07 06:50:36', NULL, 6, 0, 720),
(585, 726, '2013-08-13 03:57:09', NULL, 6, 0, 720),
(586, 727, '2013-08-14 16:59:54', NULL, 6, 0, 720),
(587, 728, '2013-08-20 22:23:36', NULL, 6, 0, 720),
(588, 730, '2013-09-04 19:59:01', NULL, 6, 0, 720),
(589, 731, '2013-09-04 20:28:13', NULL, 6, 0, 720),
(590, 732, '2013-09-05 18:29:58', NULL, 6, 0, 720),
(591, 734, '2013-09-06 18:07:37', NULL, 6, 0, 720),
(592, 735, '2013-09-14 15:46:40', NULL, 6, 0, 720),
(593, 737, '2013-09-19 19:14:10', NULL, 6, 0, 720),
(594, 738, '2013-09-25 17:55:09', NULL, 6, 0, 720),
(595, 739, '2013-10-01 18:59:44', NULL, 6, 0, 720),
(596, 744, '2013-10-02 17:06:38', NULL, 6, 0, 720),
(597, 745, '2013-10-03 05:29:44', NULL, 6, 0, 720),
(598, 746, '2013-10-03 06:30:36', NULL, 6, 0, 720),
(599, 747, '2013-10-03 07:11:08', NULL, 6, 0, 720),
(600, 750, '2013-10-03 10:49:25', NULL, 6, 0, 720),
(601, 751, '2013-10-03 11:41:53', NULL, 6, 0, 720),
(602, 752, '2013-10-03 14:09:36', NULL, 6, 0, 720);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_automail`
--
CREATE TABLE IF NOT EXISTS `tbl_automail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(5) DEFAULT NULL COMMENT 'the user_id if associated with a user',
`email` varchar(255) NOT NULL COMMENT 'e-mail of user',
`address` varchar(256) NOT NULL,
`lat` decimal(11,5) NOT NULL DEFAULT '0.00000' COMMENT 'latitude of search origin',
`lng` decimal(11,5) NOT NULL DEFAULT '0.00000' COMMENT 'longitude of search origin',
`radius` decimal(7,2) NOT NULL DEFAULT '100.00' COMMENT 'the radius of the search',
`units` varchar(2) NOT NULL DEFAULT 'mi' COMMENT 'mi-miles, km-kilometres',
`active` int(1) NOT NULL DEFAULT '0' COMMENT '0-inactive, 1-active',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=795 ;
--
-- Dumping data for table `tbl_automail`
--
INSERT INTO `tbl_automail` (`id`, `user_id`, `email`, `address`, `lat`, `lng`, `radius`, `units`, `active`) VALUES
(1, 444, '[email protected]', 'Vancouver, BC, Canada', '49.26123', '-123.11393', '100.00', 'mi', 0),
(2, NULL, '[email protected]', 'Vancouver, BC, Canada', '49.26123', '-123.11393', '250.00', 'mi', 1),
(4, NULL, '[email protected]', 'Grass Valley, CA', '39.21906', '-121.06106', '50.00', 'mi', 1),
(5, 459, '[email protected]', 'NY', '40.71435', '-74.00597', '100.00', 'mi', 1),
(10, 464, '[email protected]', '92122', '32.85638', '-117.20294', '100.00', 'mi', 1),
(11, 465, '[email protected]', 'Pasadena, CA', '34.14778', '-118.14452', '50.00', 'mi', 1),
(44, NULL, '[email protected]', 'delaware', '38.91083', '-75.52767', '50.00', 'mi', 1),
(57, NULL, '[email protected]', 'Philadelphia', '39.95234', '-75.16379', '100.00', 'mi', 0),
(58, NULL, '[email protected]', 'Brookhaven', '40.77927', '-72.91538', '100.00', 'mi', 0),
(66, NULL, '[email protected]', 'Lakewood Township, NJ', '40.08213', '-74.20970', '100.00', 'mi', 1),
(67, NULL, '[email protected]', 'Denville, NJ', '40.88611', '-74.48833', '100.00', 'mi', 1),
(68, NULL, '[email protected]', 'Middletown, NJ', '40.39680', '-74.09160', '100.00', 'mi', 1),
(70, NULL, '[email protected]', 'Ocean City, NJ', '39.27762', '-74.57460', '100.00', 'mi', 1),
(71, NULL, '[email protected]', 'Turnersville, Nj', '39.77288', '-75.05186', '100.00', 'mi', 1),
(73, NULL, '[email protected]', 'Northampton, MA', '42.32509', '-72.64120', '250.00', 'mi', 1),
(74, NULL, '[email protected]', 'Boston, MA', '42.35843', '-71.05977', '250.00', 'mi', 1),
(75, NULL, '[email protected]', 'Dartmouth, MA', '41.57206', '-71.00737', '100.00', 'mi', 1),
(76, NULL, '[email protected]', 'Dartmouth, MA', '41.57206', '-71.00737', '100.00', 'mi', 1),
(77, NULL, '[email protected]', 'Dartmouth, MA', '41.57206', '-71.00737', '100.00', 'mi', 1),
(78, NULL, '[email protected]', 'Dartmouth, MA', '41.57206', '-71.00737', '100.00', 'mi', 1),
(84, NULL, '[email protected]', 'Phoenix, AZ', '33.44838', '-112.07404', '50.00', 'mi', 0),
(85, NULL, '[email protected]', 'Chino Valley, AZ', '34.75752', '-112.45378', '100.00', 'mi', 0),
(86, NULL, '[email protected]', 'Phoenix, AZ', '33.44838', '-112.07404', '50.00', 'mi', 1),
(87, NULL, '[email protected]', 'Scottsdale, AZ', '33.49417', '-111.92605', '100.00', 'mi', 1),
(88, NULL, '[email protected]', 'Phoenix, AZ', '33.44838', '-112.07404', '100.00', 'mi', 1),
(89, NULL, '[email protected]', 'Tempe, AZ', '33.42551', '-111.94001', '100.00', 'mi', 1),
(90, NULL, '[email protected] ', 'Phoenix, AZ', '33.44838', '-112.07404', '50.00', 'mi', 1),
(91, NULL, '[email protected]', 'Phoenix, AZ', '33.44838', '-112.07404', '50.00', 'mi', 1),
(92, NULL, '[email protected]', 'Tempe, AZ', '33.42551', '-111.94001', '50.00', 'mi', 1),
(93, NULL, '[email protected]', 'Yuma, AZ', '32.69265', '-114.62769', '50.00', 'mi', 1),
(94, NULL, '[email protected]', 'Washington, DC', '38.89511', '-77.03637', '100.00', 'mi', 1),
(95, NULL, '[email protected]', 'Washington, DC', '38.89511', '-77.03637', '100.00', 'mi', 1),
(96, NULL, '[email protected]', 'Washington, DC', '38.89511', '-77.03637', '100.00', 'mi', 1),
(97, NULL, '[email protected]', 'Washington, DC', '38.89511', '-77.03637', '100.00', 'mi', 1),
(98, NULL, '[email protected]', 'Reno, NV', '39.52963', '-119.81380', '100.00', 'mi', 0),
(99, NULL, '[email protected] &', 'Reno, NV', '39.52963', '-119.81380', '100.00', 'mi', 0),
(100, NULL, '[email protected]', 'Reno, NV', '39.52963', '-119.81380', '50.00', 'mi', 1),
(101, NULL, '[email protected]', 'Reno, NV', '39.52963', '-119.81380', '50.00', 'mi', 1),
(102, NULL, '[email protected]', 'Reno, NV', '39.52963', '-119.81380', '50.00', 'mi', 1),
(103, NULL, '[email protected]', 'Las Vegas, NV', '36.11465', '-115.17282', '50.00', 'mi', 1),
(104, NULL, '[email protected]', 'Las Vegas, NV', '36.11465', '-115.17282', '50.00', 'mi', 1),
(105, NULL, '[email protected] ', 'Las Vegas, NV', '36.11465', '-115.17282', '50.00', 'mi', 1),
(106, NULL, '[email protected]', 'Las Vegas, NV', '36.11465', '-115.17282', '50.00', 'mi', 1),
(107, NULL, 'alehrcomer@suntreksolar', 'Las Vegas, NV', '36.11465', '-115.17282', '50.00', 'mi', 1),
(108, NULL, '[email protected]', 'Las Vegas, NV', '36.11465', '-115.17282', '50.00', 'mi', 1),
(109, NULL, '[email protected] ', 'Las Vegas, NV', '36.11465', '-115.17282', '50.00', 'mi', 1),
(110, NULL, '[email protected]', 'Las Vegas, NV', '36.11465', '-115.17282', '500.00', 'mi', 1),
(111, NULL, '[email protected]', 'Las Vegas, NV', '36.11465', '-115.17282', '50.00', 'mi', 1),
(112, NULL, '[email protected]', 'Las Vegas, NV', '36.11465', '-115.17282', '50.00', 'mi', 1),
(113, NULL, '[email protected]', 'Atlanta, GA', '33.74900', '-84.38798', '100.00', 'mi', 1),
(114, NULL, '[email protected]', 'Atlanta, GA', '33.74900', '-84.38798', '100.00', 'mi', 1),
(115, NULL, '[email protected]', 'Atlanta, GA', '33.74900', '-84.38798', '100.00', 'mi', 1),
(116, NULL, '[email protected] ', 'Atlanta, GA', '33.74900', '-84.38798', '50.00', 'mi', 1),
(117, NULL, '[email protected]', 'Atlanta, GA', '33.74900', '-84.38798', '50.00', 'mi', 1),
(118, NULL, '[email protected]', 'Atlanta, GA', '33.74900', '-84.38798', '50.00', 'mi', 1),
(119, NULL, '[email protected]', 'Atlanta, GA', '33.74900', '-84.38798', '50.00', 'mi', 1),
(120, NULL, '[email protected]', 'Atlanta, GA', '33.74900', '-84.38798', '50.00', 'mi', 1),
(121, NULL, '[email protected] ', 'Atlanta, GA', '33.74900', '-84.38798', '50.00', 'mi', 1),
(122, NULL, '[email protected] ', 'Atlanta, GA', '33.74900', '-84.38798', '50.00', 'mi', 1),
(123, NULL, '[email protected]', 'Modesto, CA', '37.63910', '-120.99688', '50.00', 'mi', 1),
(130, NULL, '[email protected]', 'Coppell, TX', '32.95457', '-97.01501', '50.00', 'mi', 1),
(131, NULL, '[email protected]', 'Coppell, TX', '32.95457', '-97.01501', '50.00', 'mi', 1),
(132, NULL, '[email protected]', 'Coppell, TX', '32.95457', '-97.01501', '50.00', 'mi', 1),
(133, NULL, '[email protected]', 'Houston, TX', '29.76019', '-95.36939', '100.00', 'mi', 1),
(134, NULL, '[email protected]', 'Houston, TX', '29.76019', '-95.36939', '100.00', 'mi', 1),
(136, NULL, '[email protected]', 'San Diego, CA', '32.71533', '-117.15726', '25.00', 'mi', 1),
(137, NULL, '[email protected]', 'orange county, ca', '33.71747', '-117.83114', '25.00', 'mi', 1),
(138, NULL, '[email protected]', 'Brentwood, CA', '37.93187', '-121.69579', '50.00', 'mi', 1),
(139, NULL, '[email protected]', 'Brentwood, CA', '37.93187', '-121.69579', '50.00', 'mi', 1),
(140, NULL, '[email protected]', 'Brentwood, CA', '37.93187', '-121.69579', '50.00', 'mi', 1),
(141, NULL, '[email protected]', 'Brentwood, CA', '37.93187', '-121.69579', '50.00', 'mi', 1),
(142, NULL, '[email protected]', 'Glendale, CA', '34.14251', '-118.25508', '50.00', 'mi', 1),
(143, NULL, '[email protected]', 'Redlands, CA', '34.05557', '-117.18254', '50.00', 'mi', 0),
(144, NULL, '[email protected]', 'Apple Valley, CA', '34.50083', '-117.18588', '50.00', 'mi', 0),
(145, NULL, '[email protected]', 'Apple Valley, CA', '34.50083', '-117.18588', '50.00', 'mi', 0),
(146, NULL, '[email protected]', 'Apple Valley, CA', '34.50083', '-117.18588', '100.00', 'mi', 0),
(147, NULL, '[email protected]', 'Escondido, CA', '33.11921', '-117.08642', '50.00', 'mi', 1),
(149, NULL, '[email protected]', 'Escondido, CA', '33.11921', '-117.08642', '50.00', 'mi', 1),
(150, NULL, '[email protected]', 'Escondido, CA', '33.11921', '-117.08642', '50.00', 'mi', 0),
(151, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(152, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(153, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(154, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(155, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(156, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(157, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(158, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(159, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(160, NULL, '[email protected]', 'Toronto, ON, Canada', '43.65323', '-79.38318', '100.00', 'mi', 1),
(161, NULL, '[email protected]', 'San Diego, CA', '32.71533', '-117.15726', '100.00', 'mi', 1),
(162, NULL, '[email protected]', 'Lake Elsinore, CA', '33.66808', '-117.32726', '50.00', 'mi', 1),
(163, NULL, '[email protected]', 'Lake Elsinore, CA', '33.66808', '-117.32726', '50.00', 'mi', 1),
(164, NULL, '[email protected]', 'Lake Elsinore, CA', '33.66808', '-117.32726', '50.00', 'mi', 1),
(165, NULL, '[email protected]', 'Lake Elsinore, CA', '33.66808', '-117.32726', '50.00', 'mi', 1),
(166, NULL, '[email protected]', 'Lake Elsinore, CA', '33.66808', '-117.32726', '50.00', 'mi', 1),
(167, NULL, '[email protected]', 'Lake Elsinore, CA', '33.66808', '-117.32726', '50.00', 'mi', 1),
(168, NULL, '[email protected]', 'Lake Elsinore, CA', '33.66808', '-117.32726', '50.00', 'mi', 1),
(169, NULL, '[email protected]', 'Los Gatos, CA', '37.23581', '-121.96238', '50.00', 'mi', 1),
(170, NULL, '[email protected]', 'San Jose, CA', '37.33939', '-121.89496', '50.00', 'mi', 1),
(171, NULL, '[email protected]', 'San Jose, CA', '37.33939', '-121.89496', '50.00', 'mi', 1),
(172, NULL, '[email protected]', 'Morgan Hill, CA', '37.13050', '-121.65439', '50.00', 'mi', 1),
(173, NULL, '[email protected]', 'Los Angeles, CA', '34.05223', '-118.24368', '50.00', 'mi', 1),
(174, NULL, '[email protected]', 'Los Angeles, CA', '34.05223', '-118.24368', '50.00', 'mi', 1),
(175, NULL, '[email protected]', 'Los Angeles, CA', '34.05223', '-118.24368', '50.00', 'mi', 1),
(176, NULL, '[email protected]', 'Los Angeles, CA', '34.05223', '-118.24368', '50.00', 'mi', 1),
(177, NULL, '[email protected]', 'Los Angeles, CA', '34.05223', '-118.24368', '50.00', 'mi', 1),
(178, NULL, '[email protected]', 'Los Angeles, CA', '34.05223', '-118.24368', '50.00', 'mi', 1),
(179, NULL, '[email protected]', 'Los Angeles, CA', '34.05223', '-118.24368', '50.00', 'mi', 1),
(180, NULL, '[email protected]', 'Los Angeles, CA', '34.05223', '-118.24368', '100.00', 'mi', 1),
(181, NULL, '[email protected]', 'Los Angeles, CA', '34.05223', '-118.24368', '50.00', 'mi', 1),
(182, NULL, '[email protected]', 'Rocklin, CA', '38.79073', '-121.23578', '50.00', 'mi', 1),
(183, NULL, '[email protected]', 'Rocklin, CA', '38.79073', '-121.23578', '50.00', 'mi', 1),
(184, NULL, '[email protected]', 'Yuba City, CA', '39.14045', '-121.61691', '50.00', 'mi', 1),
(185, NULL, '[email protected]', 'Yuba City, CA', '39.14045', '-121.61691', '50.00', 'mi', 1),
(186, NULL, '[email protected]', 'Yuba City, CA', '39.14045', '-121.61691', '50.00', 'mi', 1),
(187, NULL, '[email protected]', 'Yuba City, CA', '39.14045', '-121.61691', '50.00', 'mi', 1),
(188, NULL, '[email protected]', 'Morgan Hill, CA', '37.13050', '-121.65439', '100.00', 'mi', 0),
(189, NULL, '[email protected]', 'Gilroy, CA', '37.00578', '-121.56828', '50.00', 'mi', 1),
(190, NULL, '[email protected]', 'Los Gatos, CA', '37.23581', '-121.96238', '50.00', 'mi', 1),
(191, NULL, '[email protected]', 'Moreno Valley, CA', '33.94247', '-117.22967', '50.00', 'mi', 1),
(192, NULL, '[email protected] ', 'Palm Springs, CA', '33.83030', '-116.54529', '50.00', 'mi', 1),
(193, NULL, '[email protected]', 'Palm Springs, CA', '33.83030', '-116.54529', '50.00', 'mi', 1),
(194, NULL, '[email protected]', 'Palm Springs, CA', '33.83030', '-116.54529', '50.00', 'mi', 1),
(195, NULL, '[email protected]', 'Cathedral City, CA', '33.77974', '-116.46529', '50.00', 'mi', 1),
(196, NULL, '[email protected]', 'Cathedral City, CA', '33.77974', '-116.46529', '50.00', 'mi', 1),
(198, NULL, '[email protected]', 'Visalia, CA', '36.33023', '-119.29206', '50.00', 'mi', 1),
(199, NULL, '[email protected]', 'Visalia, CA', '36.33023', '-119.29206', '50.00', 'mi', 1),
(200, NULL, '[email protected]', 'Visalia, CA', '36.33023', '-119.29206', '50.00', 'mi', 1),
(201, NULL, '[email protected]', 'Visalia, CA', '36.33023', '-119.29206', '50.00', 'mi', 1),
(202, NULL, '[email protected]', 'Visalia, CA', '36.33023', '-119.29206', '50.00', 'mi', 1),
(203, NULL, '[email protected]', 'Visalia, CA', '36.33023', '-119.29206', '50.00', 'mi', 1),
(204, NULL, '[email protected] ', 'canyon country', '34.42333', '-118.47203', '50.00', 'mi', 1),
(205, NULL, '[email protected]', 'canyon country', '34.42333', '-118.47203', '50.00', 'mi', 1),
(206, NULL, '[email protected]', 'canyon country', '34.42333', '-118.47203', '50.00', 'mi', 1),
(207, NULL, '[email protected]', 'canyon country', '34.42333', '-118.47203', '50.00', 'mi', 1),
(208, NULL, '[email protected]', 'Huntington Beach, CA', '33.66030', '-117.99923', '50.00', 'mi', 1),
(209, NULL, '[email protected]', 'Huntington Beach, CA', '33.66030', '-117.99923', '50.00', 'mi', 1),
(210, NULL, '[email protected]', 'Huntington Beach, CA', '33.66030', '-117.99923', '50.00', 'mi', 1),
(211, NULL, '[email protected]', 'San Francisco, CA', '37.77493', '-122.41942', '100.00', 'mi', 1),
(212, NULL, '[email protected]', 'Sacramento, CA', '38.58157', '-121.49440', '50.00', 'mi', 1),
(213, NULL, '[email protected]', 'Sacramento, CA', '38.58157', '-121.49440', '50.00', 'mi', 1),
(214, NULL, '[email protected]', 'Sacramento, CA', '38.58157', '-121.49440', '50.00', 'mi', 1),
(215, NULL, '[email protected]', 'Sacramento, CA', '38.58157', '-121.49440', '50.00', 'mi', 1),
(216, NULL, '[email protected]', 'Sacramento, CA', '38.58157', '-121.49440', '50.00', 'mi', 1),
(217, NULL, '[email protected]', 'Fresno, CA', '36.74684', '-119.77259', '50.00', 'mi', 1),
(218, NULL, '[email protected]', 'Fresno, CA', '36.74684', '-119.77259', '50.00', 'mi', 1),
(219, NULL, '[email protected]', 'Fresno, CA', '36.74684', '-119.77259', '50.00', 'mi', 1),
(220, NULL, '[email protected]', 'Fresno, CA', '36.74684', '-119.77259', '50.00', 'mi', 1),
(221, NULL, '[email protected]', 'Fresno, CA', '36.74684', '-119.77259', '50.00', 'mi', 1),
(222, NULL, '[email protected]', 'Santa Clara, CA', '37.35411', '-121.95524', '50.00', 'mi', 0),
(223, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '50.00', 'mi', 1),
(224, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '50.00', 'mi', 1),
(225, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '50.00', 'mi', 1),
(226, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '50.00', 'mi', 1),
(227, NULL, '[email protected]', 'Oceanside, CA', '33.19587', '-117.37948', '50.00', 'mi', 1),
(228, NULL, '[email protected]', 'Oceanside, CA', '33.19587', '-117.37948', '50.00', 'mi', 1),
(229, NULL, '[email protected]', 'Oceanside, CA', '33.19587', '-117.37948', '50.00', 'mi', 1),
(230, NULL, '[email protected]', 'Danville, CA', '37.82159', '-121.99996', '50.00', 'mi', 1),
(231, NULL, '[email protected]', 'Danville, CA', '37.82159', '-121.99996', '50.00', 'mi', 1),
(232, NULL, '[email protected]', 'Danville, CA', '37.82159', '-121.99996', '50.00', 'mi', 1),
(233, NULL, '[email protected]', 'Danville, CA', '37.82159', '-121.99996', '50.00', 'mi', 1),
(234, NULL, '[email protected]', 'Danville, CA', '37.82159', '-121.99996', '50.00', 'mi', 1),
(235, NULL, '[email protected]', 'Danville, CA', '37.82159', '-121.99996', '100.00', 'mi', 1),
(236, NULL, '[email protected]', 'Danville, CA', '37.82159', '-121.99996', '50.00', 'mi', 1),
(237, NULL, '[email protected]', 'Holtville, CA', '32.81116', '-115.38026', '50.00', 'mi', 1),
(238, NULL, '[email protected]', 'Landers, CA', '34.26611', '-116.39222', '50.00', 'mi', 1),
(239, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '50.00', 'mi', 1),
(240, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '100.00', 'mi', 1),
(241, NULL, '[email protected] ', 'Holtville, CA', '32.81116', '-115.38026', '100.00', 'mi', 1),
(242, NULL, '[email protected]', 'Holtville, CA', '32.81116', '-115.38026', '50.00', 'mi', 1),
(243, NULL, '[email protected]', 'Holtville, CA', '32.81116', '-115.38026', '50.00', 'mi', 0),
(244, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '50.00', 'mi', 1),
(245, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '50.00', 'mi', 1),
(246, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '50.00', 'mi', 0),
(247, NULL, '[email protected]', 'Fremont, CA', '37.54827', '-121.98857', '50.00', 'mi', 1),
(248, NULL, '[email protected]', 'Yorba Linda, CA', '33.88863', '-117.81311', '50.00', 'mi', 1),
(249, NULL, '[email protected]', 'Yorba Linda, CA', '33.88863', '-117.81311', '50.00', 'mi', 1),
(250, NULL, '[email protected]', 'Yorba Linda, CA', '33.88863', '-117.81311', '50.00', 'mi', 1),
(251, NULL, '[email protected]', 'Yorba Linda, CA', '33.88863', '-117.81311', '50.00', 'mi', 1),
(252, NULL, '[email protected]', 'Huntington Beach, CA', '33.66030', '-117.99923', '50.00', 'mi', 1),
(253, NULL, '[email protected]', 'Huntington Beach, CA', '33.66030', '-117.99923', '50.00', 'mi', 0),
(254, NULL, '[email protected]', 'Huntington Beach, CA', '33.66030', '-117.99923', '50.00', 'mi', 1),