INSERT INTO `phpads_adstats` (`views`, `clicks`, `day`, `BannerID`) VALUES
(775, 0, '2008-07-14', 14),
(155, 2, '2008-07-15', 14),
(0, 1, '2008-07-15', 158),
(404, 0, '2008-07-16', 14),
(474, 0, '2008-07-17', 14),
(427, 0, '2008-07-18', 14),
(81, 0, '2008-07-19', 14),
(0, 1, '2008-07-19', 44),
(0, 1, '2008-07-19', 129),
(128, 0, '2008-07-20', 14),
(294, 0, '2008-07-21', 14),
(0, 1, '2008-07-21', 128),
(0, 1, '2008-07-21', 153),
(325, 0, '2008-07-22', 14),
(0, 1, '2008-07-22', 156),
(0, 1, '2008-07-22', 158),
(419, 1, '2008-07-23', 14),
(0, 1, '2008-07-23', 157),
(85, 0, '2008-07-24', 14),
(0, 1, '2008-07-24', 127),
(94, 2, '2008-07-25', 14),
(45, 0, '2008-07-26', 14),
(0, 1, '2008-07-26', 33),
(116, 0, '2008-07-27', 14),
(54, 0, '2008-07-28', 14),
(557, 0, '2008-07-29', 14),
(172, 1, '2008-07-30', 14),
(0, 2, '2008-07-30', 161),
(449, 2, '2008-07-31', 14),
(98, 1, '2008-08-01', 14),
(0, 1, '2008-08-01', 34),
(0, 1, '2008-08-01', 50),
(105, 0, '2008-08-02', 14),
(0, 1, '2008-08-02', 127),
(99, 0, '2008-08-03', 14),
(0, 1, '2008-08-03', 157),
(45, 0, '2008-08-04', 14),
(53, 0, '2008-08-05', 14),
(53, 0, '2008-08-06', 14),
(0, 1, '2008-08-06', 158),
(352, 1, '2008-08-07', 14),
(27, 0, '2008-08-08', 14),
(63, 1, '2008-08-09', 14),
(24, 0, '2008-08-10', 14),
(33, 0, '2008-08-11', 14),
(73, 0, '2008-08-12', 14),
(119, 2, '2008-08-13', 14),
(0, 1, '2008-08-13', 15),
(46, 0, '2008-08-14', 14),
(27, 0, '2008-08-15', 14),
(27, 0, '2008-08-16', 14),
(50, 0, '2008-08-17', 14),
(36, 2, '2008-08-18', 14),
(154, 1, '2008-08-19', 14),
(129, 0, '2008-08-20', 14),
(65, 0, '2008-08-21', 14),
(0, 1, '2008-08-21', 50),
(0, 2, '2008-08-22', 161),
(73, 0, '2008-08-22', 14),
(39, 0, '2008-08-23', 14),
(103, 0, '2008-08-24', 14),
(51, 0, '2008-08-25', 14),
(233, 0, '2008-08-26', 14),
(454, 1, '2008-08-27', 14),
(0, 1, '2008-08-27', 161),
(163, 0, '2008-08-28', 14),
(517, 0, '2008-08-29', 14),
(637, 1, '2008-08-30', 14),
(199, 1, '2008-08-31', 14),
(0, 1, '2008-08-31', 34),
(72, 0, '2008-09-01', 14),
(148, 0, '2008-09-02', 14),
(198, 0, '2008-09-03', 14),
(402, 0, '2008-09-04', 14),
(194, 0, '2008-09-05', 14),
(116, 0, '2008-09-06', 14),
(210, 0, '2008-09-07', 14),
(245, 0, '2008-09-08', 14),
(537, 0, '2008-09-09', 14),
(148, 0, '2008-09-10', 14),
(121, 0, '2008-09-11', 14),
(70, 0, '2008-09-12', 14),
(0, 1, '2008-09-12', 161),
(122, 3, '2008-09-13', 14),
(57, 0, '2008-09-14', 14),
(79, 2, '2008-09-15', 14),
(60, 0, '2008-09-16', 14),
(0, 1, '2008-09-16', 130),
(0, 1, '2008-09-16', 153),
(87, 0, '2008-09-17', 14),
(213, 1, '2008-09-18', 14),
(0, 1, '2008-09-18', 161),
(199, 0, '2008-09-19', 14),
(131, 1, '2008-09-20', 14),
(91, 0, '2008-09-21', 14),
(135, 0, '2008-09-22', 14),
(153, 0, '2008-09-23', 14),
(133, 0, '2008-09-24', 14),
(0, 1, '2008-09-24', 15),
(0, 1, '2008-09-24', 158),
(0, 1, '2008-09-24', 157),
(51, 0, '2008-09-25', 14),
(276, 4, '2008-09-26', 14),
(0, 1, '2008-09-26', 157),
(22, 0, '2008-09-27', 14),
(140, 0, '2008-09-28', 14),
(0, 1, '2008-09-28', 158),
(154, 2, '2008-09-29', 14),
(308, 1, '2008-09-30', 14),
(563, 0, '2008-10-01', 14),
(0, 1, '2008-10-01', 48),
(74, 2, '2008-10-02', 14),
(76, 0, '2008-10-03', 14),
(64, 2, '2008-10-04', 14),
(82, 0, '2008-10-05', 14),
(0, 1, '2008-10-05', 161),
(95, 0, '2008-10-06', 14),
(207, 0, '2008-10-07', 14),
(108, 0, '2008-10-08', 14),
(97, 0, '2008-10-09', 14),
(145, 0, '2008-10-10', 14),
(0, 1, '2008-10-10', 34),
(0, 1, '2008-10-10', 50),
(77, 1, '2008-10-11', 14),
(0, 1, '2008-10-11', 161),
(133, 1, '2008-10-12', 14),
(116, 0, '2008-10-13', 14),
(191, 0, '2008-10-14', 14),
(86, 4, '2008-10-15', 14),
(115, 0, '2008-10-16', 14),
(30, 2, '2008-10-17', 14),
(0, 1, '2008-10-17', 50),
(0, 1, '2008-10-17', 15),
(105, 2, '2008-10-18', 14),
(66, 1, '2008-10-19', 14),
(172, 0, '2008-10-20', 14),
(0, 1, '2008-10-20', 130),
(110, 0, '2008-10-21', 14),
(76, 0, '2008-10-22', 14),
(0, 1, '2008-10-22', 44),
(179, 0, '2008-10-23', 14),
(139, 2, '2008-10-24', 14),
(85, 0, '2008-10-25', 14),
(177, 3, '2008-10-26', 14),
(111, 0, '2008-10-27', 14),
(0, 1, '2008-10-27', 161),
(81, 0, '2008-10-28', 14),
(146, 0, '2008-10-29', 14),
(93, 0, '2008-10-30', 14),
(255, 2, '2008-10-31', 14),
(126, 0, '2008-11-01', 14),
(150, 0, '2008-11-02', 14),
(0, 1, '2008-11-02', 161),
(114, 0, '2008-11-03', 14),
(112, 1, '2008-11-04', 14),
(0, 1, '2008-11-04', 158),
(22, 0, '2008-11-05', 14),
(44, 0, '2008-11-06', 14),
(318, 1, '2008-11-07', 14),
(50, 0, '2008-11-08', 14),
(0, 1, '2008-11-08', 79),
(68, 0, '2008-11-09', 14),
(115, 4, '2008-11-10', 14),
(0, 1, '2008-11-10', 161),
(73, 0, '2008-11-11', 14),
(41, 0, '2008-11-12', 14),
(280, 0, '2008-11-13', 14),
(40, 0, '2008-11-14', 14),
(0, 1, '2008-11-14', 130),
(0, 1, '2008-11-14', 32),
(78, 0, '2010-07-25', 14),
(0, 1, '2008-11-14', 154),
(36, 0, '2008-11-15', 14),
(0, 1, '2008-11-15', 156),
(0, 1, '2008-11-15', 53),
(0, 1, '2008-11-15', 157),
(34, 0, '2008-11-16', 14),
(0, 1, '2008-11-16', 138),
(0, 1, '2008-11-16', 86),
(0, 1, '2008-11-16', 54),
(30, 0, '2008-11-17', 14),
(0, 1, '2008-11-17', 34),
(0, 1, '2008-11-17', 153),
(60, 0, '2008-11-18', 14),
(0, 1, '2008-11-19', 161),
(58, 0, '2008-11-19', 14),
(0, 1, '2008-11-19', 160),
(0, 1, '2008-11-19', 12),
(87, 0, '2008-11-20', 14),
(110, 2, '2008-11-21', 14),
(0, 1, '2008-11-21', 161),
(0, 1, '2008-11-21', 137),
(462, 0, '2008-11-22', 14),
(0, 1, '2008-11-22', 43),
(113, 0, '2008-11-23', 14),
(0, 1, '2008-11-23', 52),
(69, 0, '2008-11-24', 14),
(0, 1, '2008-11-24', 12),
(89, 2, '2008-11-25', 14),
(202, 0, '2008-11-26', 14),
(60, 0, '2008-11-27', 14),
(52, 0, '2008-11-28', 14),
(99, 0, '2008-11-29', 14),
(60, 0, '2008-11-30', 14),
(47, 0, '2008-12-01', 14),
(43, 0, '2008-12-02', 14),
(48, 0, '2008-12-03', 14),
(0, 1, '2008-12-03', 15),
(224, 2, '2008-12-04', 14),
(424, 1, '2008-12-05', 14),
(58, 0, '2008-12-06', 14),
(0, 1, '2008-12-06', 48),
(0, 1, '2008-12-06', 135),
(295, 1, '2008-12-07', 14),
(0, 1, '2008-12-07', 34),
(48, 0, '2008-12-08', 14),
(0, 1, '2008-12-08', 161),
(80, 0, '2008-12-09', 14),
(0, 1, '2008-12-09', 158),
(0, 1, '2008-12-09', 133),
(55, 0, '2008-12-10', 14),
(0, 1, '2008-12-10', 55),
(116, 0, '2008-12-11', 14),
(0, 1, '2008-12-11', 129),
(139, 2, '2008-12-12', 14),
(0, 1, '2008-12-12', 15),
(102, 0, '2008-12-13', 14),
(0, 2, '2008-12-13', 161),
(425, 0, '2008-12-14', 14),
(0, 1, '2008-12-14', 135),
(79, 0, '2008-12-15', 14),
(0, 1, '2008-12-15', 33),
(158, 0, '2008-12-16', 14),
(111, 2, '2008-12-17', 14),
(0, 1, '2008-12-17', 50),
(91, 0, '2008-12-18', 14),
(160, 1, '2008-12-19', 14),
(97, 2, '2008-12-20', 14),
(0, 1, '2008-12-20', 157),
(81, 0, '2008-12-21', 14),
(0, 1, '2008-12-21', 128),
(70, 0, '2008-12-22', 14),
(62, 0, '2008-12-23', 14),
(69, 1, '2008-12-24', 14),
(162, 2, '2008-12-25', 14),
(459, 0, '2008-12-26', 14),
(66, 0, '2008-12-27', 14),
(64, 0, '2008-12-28', 14),
(0, 1, '2008-12-28', 50),
(234, 2, '2008-12-29', 14),
(0, 1, '2008-12-29', 48),
(123, 1, '2008-12-30', 14),
(0, 1, '2008-12-30', 127),
(38, 0, '2008-12-31', 14),
(31, 0, '2009-01-01', 14),
(0, 1, '2009-01-01', 44),
(0, 1, '2009-01-01', 153),
(109, 2, '2009-01-02', 14),
(52, 0, '2009-01-03', 14),
(0, 1, '2009-01-03', 161),
(65, 0, '2009-01-04', 14),
(207, 0, '2009-01-05', 14),
(32, 1, '2009-01-06', 14),
(0, 1, '2009-01-06', 86),
(0, 1, '2009-01-06', 161),
(123, 1, '2009-01-07', 14),
(37, 0, '2009-01-08', 14),
(36, 0, '2009-01-09', 14),
(100, 0, '2009-01-10', 14),
(75, 2, '2009-01-11', 14),
(56, 0, '2009-01-12', 14),
(0, 1, '2009-01-12', 34),
(288, 2, '2009-01-13', 14),
(67, 0, '2009-01-14', 14),
(0, 2, '2009-01-14', 15),
(313, 0, '2009-01-15', 14),
(0, 1, '2009-01-15', 53),
(592, 0, '2009-01-16', 14),
(36, 0, '2009-01-17', 14),
(159, 0, '2009-01-18', 14),
(107, 0, '2009-01-19', 14),
(94, 0, '2009-01-20', 14),
(0, 1, '2009-01-20', 156),
(212, 0, '2009-01-21', 14),
(64, 2, '2009-01-22', 14),
(29, 0, '2009-01-23', 14),
(0, 1, '2009-01-23', 15),
(50, 0, '2009-01-24', 14),
(291, 0, '2009-01-25', 14),
(0, 1, '2009-01-25', 161),
(159, 0, '2009-01-26', 14),
(0, 1, '2009-01-26', 154),
(112, 0, '2009-01-27', 14),
(111, 2, '2009-01-28', 14),
(0, 1, '2009-01-28', 54),
(0, 1, '2009-01-28', 138),
(269, 0, '2009-01-29', 14),
(0, 1, '2009-01-29', 161),
(177, 0, '2009-01-30', 14),
(100, 0, '2009-01-31', 14),
(178, 0, '2009-02-01', 14),
(122, 4, '2009-02-02', 14),
(198, 0, '2009-02-03', 14),
(46, 0, '2009-02-04', 14),
(357, 0, '2009-02-05', 14),
(182, 1, '2009-02-06', 14),
(137, 1, '2009-02-07', 14),
(40, 0, '2009-02-08', 14),
(67, 0, '2009-02-09', 14),
(122, 2, '2009-02-10', 14),
(0, 1, '2009-02-10', 50),
(76, 0, '2009-02-11', 14),
(71, 0, '2009-02-12', 14),
(89, 0, '2009-02-13', 14),
(25, 0, '2009-02-14', 14),
(37, 2, '2009-02-15', 14),
(0, 1, '2009-02-15', 161),
(140, 0, '2009-02-16', 14),
(0, 1, '2009-02-16', 32),
(0, 1, '2009-02-16', 50),
(20, 0, '2009-02-17', 14),
(228, 0, '2009-02-18', 14),
(384, 0, '2009-02-19', 14),
(96, 0, '2009-02-20', 14),
(0, 1, '2009-02-20', 79),
(87, 0, '2009-02-21', 14),
(31, 0, '2009-02-22', 14),
(55, 0, '2009-02-23', 14),
(136, 0, '2009-02-24', 14),
(0, 1, '2009-02-24', 158),
(56, 0, '2009-02-25', 14),
(56, 2, '2009-02-26', 14),
(0, 1, '2009-02-26', 12),
(214, 1, '2009-02-27', 14),
(57, 0, '2009-02-28', 14),
(199, 0, '2009-03-01', 14),
(0, 1, '2009-03-01', 130),
(0, 1, '2009-03-01', 161),
(225, 0, '2009-03-02', 14),
(194, 0, '2009-03-03', 14),
(68, 0, '2009-03-04', 14),
(115, 0, '2009-03-05', 14),
(119, 0, '2009-03-06', 14),
(109, 0, '2009-03-07', 14),
(48, 0, '2009-03-08', 14),
(104, 1, '2009-03-09', 14),
(107, 0, '2009-03-10', 14),
(0, 1, '2009-03-10', 161),
(99, 2, '2009-03-11', 14),
(50, 0, '2009-03-12', 14),
(81, 1, '2009-03-13', 14),
(0, 1, '2009-03-13', 34),
(0, 1, '2009-03-13', 50),
(50, 0, '2009-03-14', 14),
(252, 0, '2009-03-15', 14),
(19, 0, '2009-03-16', 14),
(19, 0, '2009-03-17', 14),
(577, 0, '2009-03-18', 14),
(40, 0, '2009-03-19', 14),
(48, 0, '2009-03-20', 14),
(47, 0, '2009-03-21', 14),
(43, 0, '2009-03-22', 14),
(22, 0, '2009-03-23', 14),
(0, 1, '2010-07-25', 132),
(56, 2, '2009-03-24', 14),
(14, 1, '2009-03-25', 14),
(13, 0, '2009-03-26', 14),
(0, 1, '2009-03-26', 15),
(132, 0, '2009-03-27', 14),
(100, 0, '2009-03-28', 14),
(32, 0, '2009-03-29', 14),
(36, 0, '2009-03-30', 14),
(57, 0, '2009-03-31', 14),
(0, 1, '2009-03-31', 161),
(53, 2, '2009-04-01', 14),
(141, 0, '2009-04-02', 14),
(0, 2, '2009-04-03', 161),
(76, 6, '2009-04-03', 14),
(29, 0, '2009-04-04', 14),
(47, 0, '2009-04-05', 14),
(0, 1, '2009-04-05', 161),
(41, 0, '2009-04-06', 14),
(0, 1, '2009-04-06', 130),
(329, 1, '2009-04-07', 14),
(78, 0, '2009-04-08', 14),
(135, 2, '2009-04-09', 14),
(28, 0, '2009-04-10', 14),
(0, 1, '2009-04-11', 50),
(28, 0, '2009-04-11', 14),
(51, 0, '2009-04-12', 14),
(68, 0, '2009-04-13', 14),
(94, 0, '2009-04-14', 14),
(78, 0, '2009-04-15', 14),
(59, 1, '2009-04-16', 14),
(172, 3, '2009-04-17', 14),
(70, 0, '2009-04-18', 14),
(61, 0, '2009-04-19', 14),
(0, 1, '2009-04-19', 158),
(0, 1, '2009-04-19', 157),
(23, 1, '2009-04-20', 14),
(105, 0, '2009-04-21', 14),
(25, 0, '2009-04-22', 14),
(120, 0, '2009-04-23', 14),
(37, 0, '2009-04-24', 14),
(24, 0, '2009-04-25', 14),
(35, 1, '2009-04-26', 14),
(59, 0, '2009-04-27', 14),
(280, 0, '2009-04-28', 14),
(87, 2, '2009-04-29', 14),
(0, 1, '2009-04-29', 130),
(20, 0, '2009-04-30', 14),
(0, 1, '2009-04-30', 50),
(31, 2, '2009-05-01', 14),
(233, 0, '2009-05-02', 14),
(71, 0, '2009-05-03', 14),
(181, 1, '2009-05-04', 14),
(65, 1, '2009-05-05', 14),
(88, 0, '2009-05-06', 14),
(120, 0, '2009-05-07', 14),
(109, 0, '2009-05-08', 14),
(31, 0, '2009-05-09', 14),
(0, 1, '2009-05-09', 15),
(52, 2, '2009-05-10', 14),
(27, 0, '2009-05-11', 14),
(0, 1, '2009-05-11', 161),
(48, 0, '2009-05-12', 14),
(63, 0, '2009-05-13', 14),
(135, 1, '2009-05-14', 14),
(111, 0, '2009-05-15', 14),
(0, 1, '2009-05-15', 161),
(75, 0, '2009-05-16', 14),
(30, 0, '2009-05-17', 14),
(47, 2, '2009-05-18', 14),
(217, 0, '2009-05-19', 14),
(34, 0, '2009-05-20', 14),
(56, 0, '2009-05-21', 14),
(70, 3, '2009-05-22', 14),
(106, 0, '2009-05-23', 14),
(67, 0, '2009-05-24', 14),
(92, 0, '2009-05-25', 14),
(123, 0, '2009-05-26', 14),
(209, 0, '2009-05-27', 14),
(88, 0, '2009-05-28', 14),
(170, 0, '2009-05-29', 14),
(212, 0, '2009-05-30', 14),
(77, 0, '2009-05-31', 14),
(140, 2, '2009-06-01', 14),
(85, 0, '2009-06-02', 14),
(31, 0, '2009-06-03', 14),
(128, 0, '2009-06-04', 14),
(0, 1, '2009-06-04', 161),
(177, 0, '2009-06-05', 14),
(55, 0, '2009-06-06', 14),
(30, 1, '2009-06-07', 14),
(63, 0, '2009-06-08', 14),
(187, 0, '2009-06-09', 14),
(0, 1, '2009-06-09', 34),
(417, 0, '2009-06-10', 14),
(167, 0, '2009-06-11', 14),
(51, 0, '2009-06-12', 14),
(0, 1, '2009-06-12', 161),
(93, 0, '2009-06-13', 14),
(109, 0, '2009-06-14', 14),
(340, 0, '2009-06-15', 14),
(0, 1, '2009-06-15', 160),
(159, 0, '2009-06-16', 14),
(62, 0, '2009-06-17', 14),
(30, 0, '2009-06-18', 14),
(70, 0, '2009-06-19', 14),
(0, 1, '2009-06-19', 158),
(57, 0, '2009-06-20', 14),
(0, 1, '2009-06-20', 157),
(0, 1, '2009-06-20', 158),
(188, 0, '2009-06-21', 14),
(284, 0, '2009-06-22', 14),
(0, 1, '2009-06-22', 50),
(118, 0, '2009-06-23', 14),
(99, 0, '2009-06-24', 14),
(314, 2, '2009-06-25', 14),
(129, 2, '2009-06-26', 14),
(135, 2, '2009-06-27', 14),
(48, 0, '2009-06-28', 14),
(161, 0, '2009-06-29', 14),
(159, 0, '2009-06-30', 14),
(106, 0, '2009-07-01', 14),
(84, 0, '2009-07-02', 14),
(0, 1, '2009-07-02', 161),
(0, 1, '2009-07-02', 130),
(131, 1, '2009-07-03', 14),
(106, 0, '2009-07-04', 14),
(50, 0, '2009-07-05', 14),
(139, 0, '2009-07-06', 14),
(130, 0, '2009-07-07', 14),
(100, 0, '2009-07-08', 14),
(42, 0, '2009-07-09', 14),
(0, 1, '2009-07-09', 34),
(30, 0, '2009-07-10', 14),
(83, 1, '2009-07-11', 14),
(70, 2, '2009-07-12', 14),
(146, 0, '2009-07-13', 14),
(97, 0, '2009-07-14', 14),
(67, 0, '2009-07-15', 14),
(126, 0, '2009-07-16', 14),
(166, 0, '2009-07-17', 14),
(218, 0, '2009-07-18', 14),
(183, 0, '2009-07-19', 14),
(0, 1, '2009-07-19', 15),
(188, 0, '2009-07-20', 14),
(150, 0, '2009-07-21', 14),
(72, 0, '2009-07-22', 14),
(54, 0, '2009-07-23', 14),
(0, 1, '2009-07-23', 161),
(96, 0, '2009-07-24', 14),
(52, 0, '2009-07-25', 14),
(232, 0, '2009-07-26', 14),
(64, 1, '2009-07-27', 14),
(64, 0, '2009-07-28', 14),
(100, 0, '2009-07-29', 14),
(114, 0, '2009-07-30', 14),
(0, 1, '2009-07-30', 161),
(110, 0, '2009-07-31', 14),
(99, 0, '2009-08-01', 14),
(137, 2, '2009-08-02', 14),
(193, 0, '2009-08-03', 14),
(133, 0, '2009-08-04', 14),
(455, 0, '2009-08-05', 14),
(124, 0, '2009-08-06', 14),
(154, 0, '2009-08-07', 14),
(149, 0, '2009-08-08', 14),
(0, 1, '2009-08-08', 130),
(140, 2, '2009-08-09', 14),
(90, 0, '2009-08-10', 14),
(118, 0, '2009-08-11', 14),
(146, 0, '2009-08-12', 14),
(0, 1, '2009-08-12', 50),
(470, 0, '2009-08-13', 14),
(201, 0, '2009-08-14', 14),
(161, 0, '2009-08-15', 14),
(191, 0, '2009-08-16', 14),
(90, 0, '2009-08-17', 14),
(0, 1, '2009-08-17', 161),
(525, 0, '2009-08-18', 14),
(56, 0, '2009-08-19', 14),
(95, 0, '2009-08-20', 14),
(144, 0, '2009-08-21', 14),
(89, 0, '2009-08-22', 14),
(0, 1, '2009-08-22', 157),
(0, 1, '2009-08-22', 158),
(174, 1, '2009-08-23', 14),
(181, 0, '2009-08-24', 14),
(185, 0, '2009-08-25', 14),
(120, 0, '2009-08-26', 14),
(73, 0, '2009-08-27', 14),
(135, 0, '2009-08-28', 14),
(85, 0, '2009-08-29', 14),
(64, 0, '2009-08-30', 14),
(0, 1, '2009-08-30', 15),
(122, 0, '2009-08-31', 14),
(96, 0, '2009-09-01', 14),
(75, 0, '2009-09-02', 14),
(112, 0, '2009-09-03', 14),
(86, 0, '2009-09-04', 14),
(100, 0, '2009-09-05', 14),
(92, 0, '2009-09-06', 14),
(181, 0, '2009-09-07', 14),
(0, 1, '2009-09-07', 160),
(217, 0, '2009-09-08', 14),
(60, 1, '2009-09-09', 14),
(98, 0, '2009-09-10', 14),
(0, 1, '2009-09-10', 34),
(97, 0, '2009-09-11', 14),
(106, 0, '2009-09-12', 14),
(151, 0, '2009-09-13', 14),
(77, 0, '2009-09-14', 14),
(217, 0, '2009-09-15', 14),
(112, 0, '2009-09-16', 14),
(130, 0, '2009-09-17', 14),
(55, 1, '2009-09-18', 14),
(304, 0, '2009-09-19', 14),
(99, 0, '2009-09-20', 14),
(47, 0, '2009-09-21', 14),
(140, 0, '2009-09-22', 14),
(58, 0, '2009-09-23', 14),
(95, 2, '2009-09-24', 14),
(190, 0, '2009-09-25', 14),
(111, 0, '2009-09-26', 14),
(107, 0, '2009-09-27', 14),
(175, 0, '2009-09-28', 14),
(39, 0, '2009-09-29', 14),
(121, 0, '2009-09-30', 14),
(0, 1, '2009-10-01', 161),
(91, 0, '2009-10-01', 14),
(29, 0, '2009-10-02', 14),
(120, 0, '2009-10-03', 14),
(137, 0, '2009-10-04', 14),
(153, 0, '2009-10-05', 14),
(0, 1, '2009-10-05', 161),
(353, 0, '2009-10-06', 14),
(863, 0, '2009-10-07', 14),
(83, 0, '2009-10-08', 14),
(141, 0, '2009-10-09', 14),
(79, 0, '2009-10-10', 14),
(157, 0, '2009-10-11', 14),
(0, 1, '2009-10-11', 158),
(159, 0, '2009-10-12', 14),
(193, 0, '2009-10-13', 14),
(126, 0, '2009-10-14', 14),
(323, 0, '2009-10-15', 14),
(171, 0, '2009-10-16', 14),
(69, 0, '2009-10-17', 14),
(198, 1, '2009-10-18', 14),
(122, 0, '2009-10-19', 14),
(64, 0, '2009-10-20', 14),
(166, 0, '2009-10-21', 14),
(89, 0, '2009-10-22', 14),
(127, 0, '2009-10-23', 14),
(0, 1, '2009-10-23', 161),
(158, 0, '2009-10-24', 14),
(262, 0, '2009-10-25', 14),
(350, 1, '2009-10-26', 14),
(91, 0, '2009-10-27', 14),
(94, 0, '2009-10-28', 14),
(95, 0, '2009-10-29', 14),
(211, 0, '2009-10-30', 14),
(193, 0, '2009-10-31', 14),
(98, 0, '2009-11-01', 14),
(0, 1, '2009-11-01', 15),
(80, 1, '2009-11-02', 14),
(36, 0, '2009-11-03', 14),
(142, 0, '2009-11-04', 14),
(77, 0, '2009-11-05', 14),
(89, 0, '2009-11-06', 14),
(97, 0, '2009-11-07', 14),
(98, 0, '2009-11-08', 14),
(0, 1, '2009-11-08', 15),
(170, 1, '2009-11-09', 14),
(159, 0, '2009-11-10', 14),
(308, 0, '2009-11-11', 14),
(167, 0, '2009-11-12', 14),
(109, 0, '2009-11-13', 14),
(90, 0, '2009-11-14', 14),
(0, 1, '2009-11-14', 15),
(159, 0, '2009-11-15', 14),
(101, 0, '2009-11-16', 14),
(92, 0, '2009-11-17', 14),
(0, 1, '2009-11-17', 160),
(87, 0, '2009-11-18', 14),
(76, 0, '2009-11-19', 14),
(0, 1, '2009-11-19', 161),
(171, 0, '2009-11-20', 14),
(49, 0, '2009-11-21', 14),
(84, 1, '2009-11-22', 14),
(104, 0, '2009-11-23', 14),
(67, 0, '2009-11-24', 14),
(0, 1, '2009-11-24', 161),
(55, 0, '2009-11-25', 14),
(124, 0, '2009-11-26', 14),
(80, 0, '2009-11-27', 14),
(136, 0, '2009-11-28', 14),
(24, 0, '2009-11-29', 14),
(106, 0, '2009-11-30', 14),
(138, 2, '2009-12-01', 14),
(94, 0, '2009-12-02', 14),
(58, 0, '2009-12-03', 14),
(37, 0, '2009-12-04', 14),
(39, 0, '2009-12-05', 14),
(171, 0, '2009-12-06', 14),
(118, 0, '2009-12-07', 14),
(625, 0, '2009-12-08', 14),
(0, 1, '2009-12-08', 50),
(178, 1, '2009-12-09', 14),
(128, 1, '2009-12-10', 14),
(95, 0, '2009-12-11', 14),
(135, 0, '2009-12-12', 14),
(176, 0, '2009-12-13', 14),
(192, 1, '2009-12-14', 14),
(182, 1, '2009-12-15', 14),
(0, 1, '2009-12-15', 161),
(88, 0, '2009-12-16', 14),
(199, 0, '2009-12-17', 14),
(122, 0, '2009-12-18', 14),
(168, 0, '2009-12-19', 14),
(156, 0, '2009-12-20', 14),
(100, 0, '2009-12-21', 14),
(302, 4, '2009-12-22', 14),
(133, 0, '2009-12-23', 14),
(0, 1, '2009-12-23', 153),
(0, 1, '2009-12-23', 15),
(165, 0, '2009-12-24', 14),
(189, 0, '2009-12-25', 14),
(102, 0, '2009-12-26', 14),
(115, 0, '2009-12-27', 14),
(63, 1, '2009-12-28', 14),
(227, 4, '2009-12-29', 14),
(0, 1, '2009-12-29', 50),
(60, 0, '2009-12-30', 14),
(72, 0, '2009-12-31', 14),
(322, 1, '2010-01-01', 14),
(0, 1, '2010-01-01', 50),
(91, 0, '2010-01-02', 14),
(126, 0, '2010-01-03', 14),
(0, 1, '2010-01-03', 50),
(103, 1, '2010-01-04', 14),
(230, 1, '2010-01-05', 14),
(0, 1, '2010-01-05', 50),
(167, 1, '2010-01-06', 14),
(0, 1, '2010-01-06', 161),
(370, 0, '2010-01-07', 14),
(245, 0, '2010-01-08', 14),
(0, 1, '2010-01-08', 50),
(0, 1, '2010-01-08', 161),
(168, 0, '2010-01-09', 14),
(185, 0, '2010-01-10', 14),
(216, 1, '2010-01-11', 14),
(168, 2, '2010-01-12', 14),
(92, 1, '2010-01-13', 14),
(48, 0, '2010-01-14', 14),
(83, 1, '2010-01-15', 14),
(61, 1, '2010-01-16', 14),
(45, 0, '2010-01-17', 14),
(0, 1, '2010-01-17', 34),
(69, 0, '2010-01-18', 14),
(70, 1, '2010-01-19', 14),
(64, 1, '2010-01-20', 14),
(34, 0, '2010-01-21', 14),
(9, 0, '2010-01-22', 14),
(30, 1, '2010-01-23', 14),
(55, 0, '2010-01-24', 14),
(142, 0, '2010-01-25', 14),
(88, 0, '2010-01-26', 14),
(37, 0, '2010-01-27', 14),
(92, 0, '2010-01-28', 14),
(51, 0, '2010-01-29', 14),
(61, 0, '2010-01-30', 14),
(0, 1, '2010-01-30', 161),
(43, 0, '2010-01-31', 14),
(50, 2, '2010-02-01', 14),
(39, 2, '2010-02-02', 14),
(0, 1, '2010-02-02', 158),
(61, 6, '2010-02-03', 14),
(97, 1, '2010-02-04', 14),
(94, 0, '2010-02-05', 14),
(0, 1, '2010-02-05', 161),
(108, 1, '2010-02-06', 14),
(62, 2, '2010-02-07', 14),
(207, 1, '2010-02-08', 14),
(238, 1, '2010-02-09', 14),
(271, 0, '2010-02-10', 14),
(66, 0, '2010-02-11', 14),
(0, 1, '2010-02-11', 34),
(61, 0, '2010-02-12', 14),
(0, 1, '2010-02-12', 34),
(80, 0, '2010-02-13', 14),
(67, 0, '2010-02-14', 14),
(103, 1, '2010-02-15', 14),
(0, 1, '2010-02-15', 34),
(222, 2, '2010-02-16', 14),
(0, 1, '2010-02-16', 34),
(121, 1, '2010-02-17', 14),
(0, 1, '2010-02-17', 34),
(49, 2, '2010-02-18', 14),
(0, 1, '2010-02-18', 157),
(123, 2, '2010-02-19', 14),
(92, 1, '2010-02-20', 14),
(0, 1, '2010-02-20', 158),
(81, 1, '2010-02-21', 14),
(50, 1, '2010-02-22', 14),
(88, 3, '2010-02-23', 14),
(52, 0, '2010-02-24', 14),
(0, 1, '2010-02-24', 50),
(49, 1, '2010-02-25', 14),
(57, 1, '2010-02-26', 14),
(53, 1, '2010-02-27', 14),
(36, 0, '2010-02-28', 14),
(0, 1, '2010-02-28', 161),
(78, 0, '2010-03-01', 14),
(25, 0, '2010-03-02', 14),
(0, 1, '2010-03-02', 15),
(47, 0, '2010-03-03', 14),
(53, 1, '2010-03-04', 14),
(91, 4, '2010-03-05', 14),
(89, 1, '2010-03-06', 14),
(41, 0, '2010-03-07', 14),
(108, 0, '2010-03-08', 14),
(41, 0, '2010-03-09', 14),
(103, 0, '2010-03-10', 14),
(74, 1, '2010-03-11', 14),
(96, 0, '2010-03-12', 14),
(79, 0, '2010-03-13', 14),
(0, 1, '2010-03-13', 161),
(96, 0, '2010-03-14', 14),
(117, 0, '2010-03-15', 14),
(56, 0, '2010-03-16', 14),
(63, 0, '2010-03-17', 14),
(76, 0, '2010-03-18', 14),
(61, 0, '2010-03-19', 14),
(23, 0, '2010-03-20', 14),
(35, 0, '2010-03-21', 14),
(154, 0, '2010-03-22', 14),
(18, 0, '2010-03-23', 14),
(62, 0, '2010-03-24', 14),
(0, 1, '2010-03-24', 34),
(75, 0, '2010-03-25', 14),
(0, 1, '2010-03-25', 161),
(94, 0, '2010-03-26', 14),
(43, 0, '2010-03-27', 14),
(151, 0, '2010-03-28', 14),
(148, 1, '2010-03-29', 14),
(46, 0, '2010-03-30', 14),
(44, 0, '2010-03-31', 14),
(56, 0, '2010-04-01', 14),
(71, 0, '2010-04-02', 14),
(71, 0, '2010-04-03', 14),
(78, 1, '2010-04-04', 14),
(77, 1, '2010-04-05', 14),
(0, 1, '2010-04-05', 50),
(77, 3, '2010-04-06', 14),
(61, 0, '2010-04-07', 14),
(77, 0, '2010-04-08', 14),
(64, 0, '2010-04-09', 14),
(94, 0, '2010-04-10', 14),
(170, 0, '2010-04-11', 14),
(85, 0, '2010-04-12', 14),
(56, 0, '2010-04-13', 14),
(54, 0, '2010-04-14', 14),
(57, 0, '2010-04-15', 14),
(0, 1, '2010-04-15', 15),
(72, 1, '2010-04-16', 14),
(49, 0, '2010-04-17', 14),
(439, 0, '2010-04-18', 14),
(203, 0, '2010-04-19', 14),
(130, 0, '2010-04-20', 14),
(0, 1, '2010-04-20', 161),
(66, 0, '2010-04-21', 14),
(57, 0, '2010-04-22', 14),
(82, 0, '2010-04-23', 14),
(66, 0, '2010-04-24', 14),
(93, 0, '2010-04-25', 14),
(0, 1, '2010-04-25', 34),
(89, 0, '2010-04-26', 14),
(65, 0, '2010-04-27', 14),
(87, 3, '2010-04-28', 14),
(22, 0, '2010-04-29', 14),
(31, 0, '2010-04-30', 14),
(0, 1, '2010-04-30', 161),
(38, 0, '2010-05-01', 14),
(111, 0, '2010-05-02', 14),
(252, 1, '2010-05-03', 14),
(98, 0, '2010-05-04', 14),
(19, 2, '2010-05-05', 14),
(8, 0, '2010-05-06', 14),
(0, 1, '2010-05-06', 50),
(2, 0, '2010-05-07', 14),
(0, 1, '2010-05-07', 160),
(23, 0, '2010-05-08', 14),
(39, 0, '2010-05-09', 14),
(50, 0, '2010-05-10', 14),
(18, 0, '2010-05-11', 14),
(98, 1, '2010-05-12', 14),
(0, 1, '2010-05-12', 161),
(21, 0, '2010-05-13', 14),
(86, 0, '2010-05-14', 14),
(32, 0, '2010-05-15', 14),
(22, 0, '2010-05-16', 14),
(67, 0, '2010-05-17', 14),
(95, 0, '2010-05-18', 14),
(75, 0, '2010-05-19', 14),
(45, 0, '2010-05-20', 14),
(63, 0, '2010-05-21', 14),
(102, 0, '2010-05-22', 14),
(86, 1, '2010-05-23', 14),
(71, 0, '2010-05-24', 14),
(97, 0, '2010-05-25', 14),
(0, 1, '2010-05-25', 34),
(124, 0, '2010-05-26', 14),
(34, 0, '2010-05-27', 14),
(229, 0, '2010-05-28', 14),
(46, 0, '2010-05-29', 14),
(117, 1, '2010-05-30', 14),
(0, 1, '2010-05-30', 158),
(132, 0, '2010-05-31', 14),
(99, 0, '2010-06-01', 14),
(94, 1, '2010-06-02', 14),
(115, 0, '2010-06-03', 14),
(124, 2, '2010-06-04', 14),
(121, 0, '2010-06-05', 14),
(0, 1, '2010-06-05', 161),
(120, 0, '2010-06-06', 14),
(126, 1, '2010-06-07', 14),
(0, 1, '2010-06-07', 161),
(86, 1, '2010-06-08', 14),
(51, 0, '2010-06-09', 14),
(48, 0, '2010-06-10', 14),
(112, 0, '2010-06-11', 14),
(64, 0, '2010-06-12', 14),
(123, 2, '2010-06-13', 14),
(73, 1, '2010-06-14', 14),
(197, 1, '2010-06-15', 14),
(134, 0, '2010-06-16', 14),
(70, 0, '2010-06-17', 14),
(142, 0, '2010-06-18', 14),
(83, 0, '2010-06-19', 14),
(98, 0, '2010-06-20', 14),
(62, 0, '2010-06-21', 14),
(57, 0, '2010-06-22', 14),
(33, 0, '2010-06-23', 14),
(60, 0, '2010-06-24', 14),
(71, 0, '2010-06-25', 14),
(115, 0, '2010-06-26', 14),
(181, 0, '2010-06-27', 14),
(0, 1, '2010-06-27', 15),
(88, 0, '2010-06-28', 14),
(43, 0, '2010-06-29', 14),
(115, 0, '2010-06-30', 14),
(0, 1, '2010-06-30', 161),
(110, 0, '2010-07-01', 14),
(177, 0, '2010-07-02', 14),
(73, 0, '2010-07-03', 14),
(171, 3, '2010-07-04', 14),
(85, 0, '2010-07-05', 14),
(58, 0, '2010-07-06', 14),
(74, 0, '2010-07-07', 14),
(83, 0, '2010-07-08', 14),
(107, 0, '2010-07-09', 14),
(90, 1, '2010-07-10', 14),
(92, 0, '2010-07-11', 14),
(114, 0, '2010-07-12', 14),
(113, 0, '2010-07-13', 14),
(0, 1, '2010-07-13', 161),
(86, 0, '2010-07-14', 14),
(55, 0, '2010-07-15', 14),
(80, 0, '2010-07-16', 14),
(47, 0, '2010-07-17', 14),
(98, 1, '2010-07-18', 14),
(101, 0, '2010-07-19', 14),
(42, 0, '2010-07-20', 14),
(59, 0, '2010-07-21', 14),
(123, 0, '2010-07-22', 14),
(45, 0, '2010-07-23', 14),
(134, 0, '2010-07-24', 14),
(159, 1, '2010-09-17', 14),
(0, 1, '2010-09-17', 161),
(16, 0, '2010-09-18', 14),
(0, 1, '2010-09-18', 132),
(141, 0, '2010-09-19', 14),
(0, 1, '2010-09-19', 132),
(22, 0, '2010-09-20', 14),
(55, 0, '2010-09-21', 14),
(34, 0, '2010-09-22', 14),
(0, 3, '2010-09-23', 132),
(24, 0, '2010-09-23', 14),
(0, 1, '2010-09-23', 158),
(22, 0, '2010-09-24', 14),
(0, 1, '2010-09-24', 161),
(88, 0, '2010-09-25', 14),
(27, 1, '2010-09-26', 14),
(20, 0, '2010-09-27', 14),
(42, 2, '2010-09-28', 14),
(76, 0, '2010-09-29', 14),
(29, 0, '2010-09-30', 14),
(0, 1, '2010-09-30', 132),
(23, 0, '2010-10-01', 14),
(80, 0, '2010-10-02', 14),
(125, 1, '2010-10-03', 14),
(0, 1, '2010-10-03', 132),
(228, 0, '2010-10-04', 14),
(82, 0, '2010-10-05', 14),
(0, 1, '2010-10-05', 132),
(42, 1, '2010-10-06', 14),
(19, 0, '2010-10-07', 14),
(37, 0, '2010-10-08', 14),
(0, 1, '2010-10-08', 132),
(75, 0, '2010-10-09', 14),
(49, 0, '2010-10-10', 14),
(60, 0, '2010-10-11', 14),
(0, 1, '2010-10-11', 132),
(76, 1, '2010-10-12', 14),
(66, 0, '2010-10-13', 14),
(0, 1, '2010-10-13', 161),
(54, 0, '2010-10-14', 14),
(41, 0, '2010-10-15', 14),
(24, 0, '2010-10-16', 14),
(34, 0, '2010-10-17', 14),
(0, 1, '2010-10-17', 132),
(42, 0, '2010-10-18', 14),
(117, 1, '2010-10-19', 14),
(0, 1, '2010-10-19', 15),
(357, 0, '2010-10-20', 14),
(182, 2, '2010-10-21', 14),
(25, 0, '2010-10-22', 14),
(21, 0, '2010-10-23', 14),
(53, 0, '2010-10-24', 14),
(84, 1, '2010-10-25', 14),
(0, 1, '2010-10-25', 132),
(72, 0, '2010-10-26', 14),
(40, 0, '2010-10-27', 14),
(39, 1, '2010-10-28', 14),
(96, 0, '2010-10-29', 14),
(121, 1, '2010-10-30', 14),
(156, 0, '2010-10-31', 14),
(24, 0, '2010-11-01', 14),
(177, 1, '2010-11-02', 14),
(19, 0, '2010-11-03', 14),
(17, 0, '2010-11-04', 14),
(0, 1, '2010-11-04', 132),
(33, 0, '2010-11-05', 14),
(11, 0, '2010-11-06', 14),
(26, 1, '2010-11-07', 14),
(105, 0, '2010-11-08', 14),
(32, 0, '2010-11-09', 14),
(0, 1, '2010-11-09', 161),
(35, 0, '2010-11-10', 14),
(0, 1, '2010-11-10', 161),
(13, 0, '2010-11-11', 14),
(0, 1, '2010-11-11', 158),
(0, 1, '2010-11-11', 157),
(2, 0, '2010-11-12', 14),
(1, 0, '2010-11-13', 14),
(0, 1, '2010-11-13', 132),
(1, 0, '2010-11-14', 14),
(1, 0, '2010-11-15', 14),
(1, 0, '2010-11-16', 14),
(1, 0, '2010-11-17', 14),
(1, 0, '2010-11-18', 14),
(1, 0, '2010-11-19', 14),
(0, 1, '2010-11-19', 132),
(1, 0, '2010-11-20', 14),
(1, 0, '2010-11-21', 14),
(0, 1, '2010-11-21', 132),
(1, 0, '2010-11-22', 14),
(1, 0, '2010-11-23', 14),
(0, 1, '2010-11-23', 132),
(1, 0, '2010-11-24', 14),
(1, 0, '2010-11-25', 14),
(1, 0, '2010-11-26', 14),
(1, 0, '2010-11-27', 14),
(1, 0, '2010-11-28', 14),
(0, 1, '2010-11-28', 132),
(1, 0, '2010-11-29', 14),
(1, 0, '2010-11-30', 14),
(1, 0, '2010-12-01', 14),
(0, 1, '2010-12-01', 132),
(1, 0, '2010-12-02', 14),
(1, 0, '2010-12-03', 14),
(1, 0, '2010-12-04', 14),
(1, 0, '2010-12-05', 14),
(1, 0, '2010-12-06', 14),
(1, 0, '2010-12-07', 14),
(1, 0, '2010-12-08', 14),
(0, 1, '2010-12-08', 161),
(1, 0, '2010-12-09', 14),
(1, 0, '2010-12-10', 14),
(0, 1, '2010-12-10', 15),
(1, 0, '2010-12-11', 14),
(0, 1, '2010-12-11', 132),
(1, 0, '2010-12-12', 14),
(1, 0, '2010-12-13', 14),
(0, 1, '2010-12-13', 132),
(1, 0, '2010-12-14', 14),
(1, 0, '2010-12-15', 14),
(1, 0, '2010-12-16', 14),
(1, 0, '2010-12-17', 14),
(1, 0, '2010-12-18', 14),
(1, 0, '2010-12-19', 14),
(1, 0, '2010-12-20', 14),
(1, 0, '2010-12-21', 14),
(1, 0, '2010-12-22', 14),
(1, 0, '2010-12-23', 14),
(1, 0, '2010-12-24', 14),
(1, 0, '2010-12-25', 14),
(1, 0, '2010-12-26', 14),
(1, 0, '2010-12-27', 14),
(1, 0, '2010-12-28', 14),
(1, 0, '2010-12-29', 14),
(0, 1, '2010-12-29', 161),
(1, 0, '2010-12-30', 14),
(1, 0, '2010-12-31', 14),
(0, 1, '2010-12-31', 161),
(1, 0, '2011-01-01', 14),
(0, 1, '2011-01-01', 132),
(1, 0, '2011-01-02', 14),
(1, 0, '2011-01-03', 14),
(1, 0, '2011-01-04', 14),
(1, 0, '2011-01-05', 14),
(1, 0, '2011-01-06', 14),
(1, 0, '2011-01-07', 14),
(1, 0, '2011-01-08', 14),
(1, 0, '2011-01-09', 14),
(1, 0, '2011-01-10', 14),
(1, 0, '2011-01-11', 14),
(0, 1, '2011-01-11', 132),
(1, 0, '2011-01-12', 14),
(1, 0, '2011-01-13', 14),
(0, 1, '2011-01-13', 158),
(1, 0, '2011-01-14', 14),
(1, 0, '2011-01-15', 14),
(1, 0, '2011-01-16', 14),
(1, 0, '2011-01-17', 14),
(1, 0, '2011-01-18', 14),
(1, 0, '2011-01-19', 14),
(1, 0, '2011-01-20', 14),
(1, 0, '2011-01-21', 14),
(1, 0, '2011-01-22', 14),
(0, 1, '2011-01-22', 161),
(1, 0, '2011-01-23', 14),
(1, 0, '2011-01-24', 14),
(0, 1, '2011-01-24', 132),
(0, 1, '2011-01-25', 14),
(1, 0, '2011-01-26', 14),
(0, 1, '2011-01-26', 132),
(1, 0, '2011-01-27', 14),
(1, 0, '2011-01-28', 14),
(1, 0, '2011-01-29', 14),
(1, 0, '2011-01-30', 14),
(0, 1, '2011-01-30', 132),
(1, 0, '2011-01-31', 14),
(0, 1, '2011-01-31', 132),
(1, 0, '2011-02-01', 14),
(1, 0, '2011-02-02', 14),
(1, 0, '2011-02-03', 14),
(0, 1, '2011-02-03', 132),
(1, 0, '2011-02-04', 14),
(1, 0, '2011-02-05', 14),
(0, 1, '2011-02-05', 132),
(1, 0, '2011-02-06', 14),
(1, 0, '2011-02-07', 14),
(1, 0, '2011-02-08', 14),
(1, 0, '2011-02-09', 14),
(0, 1, '2011-02-09', 15),
(1, 0, '2011-02-10', 14),
(1, 0, '2011-02-11', 14),
(0, 1, '2011-02-11', 161),
(1, 0, '2011-02-12', 14),
(1, 0, '2011-02-13', 14),
(0, 1, '2011-02-13', 161),
(1, 0, '2011-02-14', 14),
(1, 0, '2011-02-15', 14),
(1, 0, '2011-02-16', 14),
(1, 0, '2011-02-17', 14),
(1, 0, '2011-02-18', 14),
(1, 0, '2011-02-19', 14),
(0, 1, '2011-02-19', 132),
(1, 0, '2011-02-20', 14),
(1, 0, '2011-02-21', 14),
(1, 0, '2011-02-22', 14),
(1, 0, '2011-02-23', 14),
(1, 0, '2011-02-24', 14),
(1, 0, '2011-02-25', 14),
(1, 0, '2011-02-26', 14),
(1, 0, '2011-02-27', 14),
(1, 0, '2011-02-28', 14),
(1, 0, '2011-03-01', 14),
(1, 0, '2011-03-02', 14),
(1, 0, '2011-03-03', 14),
(1, 0, '2011-03-04', 14),
(1, 0, '2011-03-05', 14),
(1, 0, '2011-03-06', 14),
(1, 0, '2011-03-07', 14),
(1, 0, '2011-03-08', 14),
(1, 0, '2011-03-09', 14),
(1, 0, '2011-03-10', 14),
(0, 1, '2011-03-11', 14),
(1, 0, '2011-03-12', 14),
(0, 1, '2011-03-12', 132),
(1, 0, '2011-03-13', 14),
(1, 0, '2011-03-14', 14),
(1, 0, '2011-03-15', 14),
(1, 0, '2011-03-16', 14),
(1, 0, '2011-03-17', 14),
(1, 0, '2011-03-18', 14),
(0, 1, '2011-03-18', 161),
(1, 0, '2011-03-19', 14),
(1, 0, '2011-03-20', 14),
(1, 0, '2011-03-21', 14),
(1, 0, '2011-03-22', 14),
(1, 0, '2011-03-23', 14),
(1, 0, '2011-03-24', 14),
(1, 0, '2011-03-25', 14),
(1, 0, '2011-03-26', 14),
(1, 0, '2011-03-27', 14),
(0, 1, '2011-03-27', 132),
(1, 0, '2011-03-28', 14),
(1, 0, '2011-03-29', 14),
(0, 1, '2011-03-29', 161),
(1, 0, '2011-03-30', 14),
(1, 0, '2011-03-31', 14),
(1, 0, '2011-04-01', 14),
(1, 0, '2011-04-02', 14),
(1, 0, '2011-04-03', 14),
(0, 1, '2011-04-03', 153),
(1, 0, '2011-04-04', 14),
(1, 0, '2011-04-05', 14),
(0, 1, '2011-04-05', 15),
(1, 0, '2011-04-06', 14),
(1, 0, '2011-04-07', 14),
(0, 1, '2011-04-07', 161),
(0, 1, '2011-04-07', 157),
(1, 0, '2011-04-08', 14),
(1, 0, '2011-04-09', 14),
(1, 0, '2011-04-10', 14),
(1, 0, '2011-04-11', 14),
(1, 0, '2011-04-12', 14),
(1, 0, '2011-04-13', 14),
(1, 0, '2011-04-14', 14),
(1, 0, '2011-04-15', 14),
(1, 0, '2011-04-16', 14),
(1, 0, '2011-04-17', 14),
(1, 0, '2011-04-18', 14),
(1, 0, '2011-04-19', 14),
(1, 0, '2011-04-20', 14),
(1, 0, '2011-04-21', 14),
(1, 0, '2011-04-22', 14),
(1, 0, '2011-04-23', 14),
(1, 0, '2011-04-24', 14),
(1, 0, '2011-04-25', 14),
(1, 0, '2011-04-26', 14),
(1, 0, '2011-04-27', 14),
(1, 0, '2011-04-28', 14),
(1, 0, '2011-04-29', 14),
(1, 0, '2011-04-30', 14),
(1, 0, '2011-05-01', 14),
(1, 0, '2011-05-02', 14),
(1, 0, '2011-05-03', 14),
(1, 0, '2011-05-04', 14),
(1, 0, '2011-05-05', 14),
(1, 0, '2011-05-06', 14),
(1, 0, '2011-05-07', 14),
(0, 1, '2011-05-07', 161),
(1, 0, '2011-05-08', 14),
(0, 1, '2011-05-08', 158),
(1, 0, '2011-05-09', 14),
(1, 0, '2011-05-10', 14),
(1, 0, '2011-05-11', 14),
(1, 0, '2011-05-12', 14),
(0, 1, '2011-05-12', 153),
(1, 0, '2011-05-13', 14),
(1, 0, '2011-05-14', 14),
(1, 0, '2011-05-15', 14),
(1, 0, '2011-05-16', 14),
(1, 0, '2011-05-17', 14),
(1, 0, '2011-05-18', 14),
(1, 0, '2011-05-19', 14),
(1, 0, '2011-05-20', 14),
(1, 0, '2011-05-21', 14),
(1, 0, '2011-05-22', 14),
(1, 0, '2011-05-23', 14),
(1, 0, '2011-05-24', 14),
(1, 0, '2011-05-25', 14),
(1, 0, '2011-05-26', 14),
(1, 0, '2011-05-27', 14),
(1, 0, '2011-05-28', 14),
(0, 1, '2011-05-28', 161),
(1, 0, '2011-05-29', 14),
(1, 0, '2011-05-30', 14),
(1, 0, '2011-05-31', 14),
(1, 0, '2011-06-01', 14),
(1, 0, '2011-06-02', 14),
(1, 0, '2011-06-03', 14),
(1, 0, '2011-06-04', 14),
(1, 0, '2011-06-05', 14),
(1, 0, '2011-06-06', 14),
(0, 1, '2011-06-06', 15),
(0, 1, '2011-06-07', 161),
(1, 0, '2011-06-07', 14),
(0, 1, '2011-06-08', 157),
(0, 1, '2011-06-08', 158),
(1, 0, '2011-06-08', 14),
(1, 0, '2011-06-09', 14),
(1, 0, '2011-06-10', 14),
(0, 1, '2011-06-10', 130),
(0, 1, '2011-06-10', 158),
(1, 0, '2011-06-11', 14),
(1, 0, '2011-06-12', 14),
(1, 0, '2011-06-13', 14),
(1, 0, '2011-06-14', 14),
(1, 0, '2011-06-15', 14),
(1, 0, '2011-06-16', 14),
(1, 0, '2011-06-17', 14),
(1, 0, '2011-06-18', 14),
(1, 0, '2011-06-19', 14),
(1, 0, '2011-06-20', 14),
(1, 0, '2011-06-21', 14),
(1, 0, '2011-06-22', 14),
(1, 0, '2011-06-23', 14),
(1, 0, '2011-06-24', 14),
(1, 0, '2011-06-25', 14),
(1, 0, '2011-06-26', 14),
(1, 0, '2011-06-27', 14),
(1, 0, '2011-06-28', 14),
(1, 0, '2011-06-29', 14),
(1, 0, '2011-06-30', 14),
(1, 0, '2011-07-01', 14),
(1, 0, '2011-07-02', 14),
(0, 1, '2011-07-02', 161),
(1, 0, '2011-07-03', 14),
(1, 0, '2011-07-04', 14),
(1, 0, '2011-07-05', 14),
(0, 1, '2011-07-05', 130),
(1, 0, '2011-07-06', 14),
(1, 0, '2011-07-07', 14),
(1, 0, '2011-07-08', 14),
(0, 1, '2011-07-08', 161),
(1, 0, '2011-07-09', 14),
(1, 0, '2011-07-10', 14),
(1, 0, '2011-07-11', 14),
(1, 0, '2011-07-12', 14),
(1, 0, '2011-07-13', 14),
(1, 0, '2011-07-14', 14),
(1, 0, '2011-07-15', 14),
(1, 0, '2011-07-16', 14),
(1, 0, '2011-07-17', 14),
(1, 0, '2011-07-18', 14),
(1, 0, '2011-07-19', 14),
(0, 1, '2011-07-19', 130),
(1, 0, '2011-07-20', 14),
(1, 0, '2011-07-21', 14),
(1, 0, '2011-07-22', 14),
(0, 1, '2011-07-22', 130),
(1, 0, '2011-07-23', 14),
(0, 1, '2011-07-24', 161),
(1, 0, '2011-07-24', 14),
(1, 0, '2011-07-25', 14),
(1, 0, '2011-07-26', 14),
(0, 1, '2011-07-26', 15),
(1, 0, '2011-07-27', 14),
(1, 0, '2011-07-28', 14),
(1, 0, '2011-07-29', 14),
(1, 0, '2011-07-30', 14),
(0, 1, '2011-07-30', 161),
(1, 0, '2011-07-31', 14),
(1, 0, '2011-08-01', 14),
(1, 0, '2011-08-02', 14),
(1, 0, '2011-08-03', 14),
(1, 0, '2011-08-04', 14),
(1, 0, '2011-08-05', 14),
(1, 0, '2011-08-06', 14),
(1, 0, '2011-08-07', 14),
(1, 0, '2011-08-08', 14),
(1, 0, '2011-08-09', 14),
(1, 0, '2011-08-10', 14),
(0, 1, '2011-08-10', 132),
(1, 0, '2011-08-11', 14),
(1, 0, '2011-08-12', 14),
(1, 0, '2011-08-13', 14),
(1, 0, '2011-08-14', 14),
(1, 0, '2011-08-15', 14),
(1, 0, '2011-08-16', 14),
(1, 0, '2011-08-17', 14),
(1, 0, '2011-08-18', 14),
(0, 1, '2011-08-18', 50),
(0, 1, '2011-08-18', 34),
(1, 0, '2011-08-19', 14),
(1, 0, '2011-08-20', 14),
(1, 0, '2011-08-21', 14),
(1, 0, '2011-08-22', 14),
(0, 1, '2011-08-22', 161),
(1, 0, '2011-08-23', 14),
(1, 0, '2011-08-24', 14),
(1, 0, '2011-08-25', 14),
(1, 0, '2011-08-26', 14),
(1, 0, '2011-08-27', 14),
(1, 0, '2011-08-28', 14),
(1, 0, '2011-08-29', 14),
(0, 1, '2011-08-29', 161),
(1, 0, '2011-08-30', 14),
(0, 1, '2011-08-30', 158),
(1, 0, '2011-08-31', 14),
(1, 0, '2011-09-01', 14),
(1, 0, '2011-09-02', 14),
(1, 0, '2011-09-03', 14),
(1, 0, '2011-09-04', 14),
(1, 0, '2011-09-05', 14),
(1, 0, '2011-09-06', 14),
(1, 0, '2011-09-07', 14),
(1, 0, '2011-09-08', 14),
(1, 0, '2011-09-09', 14),
(1, 0, '2011-09-10', 14),
(1, 0, '2011-09-11', 14),
(1, 0, '2011-09-12', 14),
(1, 0, '2011-09-13', 14),
(0, 1, '2011-09-13', 161),
(1, 0, '2011-09-14', 14),
(1, 0, '2011-09-15', 14),
(1, 0, '2011-09-16', 14),
(1, 0, '2011-09-17', 14),
(1, 0, '2011-09-18', 14),
(1, 0, '2011-09-19', 14),
(1, 0, '2011-09-20', 14),
(1, 0, '2011-09-21', 14),
(1, 0, '2011-09-22', 14),
(0, 1, '2011-09-22', 161),
(1, 0, '2011-09-23', 14),
(1, 0, '2011-09-24', 14),
(1, 0, '2011-09-25', 14),
(1, 0, '2011-09-26', 14),
(1, 0, '2011-09-27', 14),
(0, 1, '2011-09-27', 15),
(0, 1, '2011-09-27', 161),
(1, 0, '2011-09-28', 14),
(1, 0, '2011-09-29', 14),
(1, 0, '2011-09-30', 14),
(1, 0, '2011-10-01', 14),
(1, 0, '2011-10-02', 14),
(1, 0, '2011-10-03', 14),
(1, 0, '2011-10-04', 14),
(1, 0, '2011-10-05', 14),
(1, 0, '2011-10-06', 14),
(1, 0, '2011-10-07', 14),
(1, 0, '2011-10-08', 14),
(1, 0, '2011-10-09', 14),
(1, 0, '2011-10-10', 14),
(1, 0, '2011-10-11', 14),
(0, 1, '2011-10-11', 161),
(1, 0, '2011-10-12', 14),
(0, 1, '2011-10-12', 133),
(0, 1, '2011-10-12', 134),
(0, 1, '2011-10-12', 135),
(0, 1, '2011-10-12', 136),
(0, 1, '2011-10-12', 161),
(0, 1, '2011-10-12', 59),
(1, 0, '2011-10-13', 14),
(1, 0, '2011-10-14', 14),
(1, 0, '2011-10-15', 14),
(1, 0, '2011-10-16', 14),
(1, 0, '2011-10-17', 14),
(0, 1, '2011-10-17', 161),
(1, 0, '2011-10-18', 14),
(1, 0, '2011-10-19', 14),
(1, 0, '2011-10-20', 14),
(1, 0, '2011-10-21', 14),
(1, 0, '2011-10-22', 14),
(0, 1, '2011-10-22', 158),
(0, 1, '2011-10-22', 157),
(1, 0, '2011-10-23', 14),
(1, 0, '2011-10-24', 14),
(1, 0, '2011-10-25', 14),
(1, 0, '2011-10-26', 14),
(1, 0, '2011-10-27', 14),
(1, 0, '2011-10-28', 14),
(1, 0, '2011-10-29', 14),
(1, 0, '2011-10-30', 14),
(1, 0, '2011-10-31', 14),
(1, 0, '2011-11-01', 14),
(1, 0, '2011-11-02', 14),
(0, 1, '2011-11-02', 133),
(0, 1, '2011-11-02', 134),
(0, 1, '2011-11-02', 135),
(0, 1, '2011-11-02', 136),
(0, 1, '2011-11-02', 161),
(0, 1, '2011-11-02', 59),
(1, 0, '2011-11-03', 14),
(1, 0, '2011-11-04', 14),
(1, 0, '2011-11-05', 14),
(1, 0, '2011-11-06', 14),
(1, 0, '2011-11-07', 14),
(1, 0, '2011-11-08', 14),
(1, 0, '2011-11-09', 14),
(1, 0, '2011-11-10', 14),
(1, 0, '2011-11-11', 14),
(1, 0, '2011-11-12', 14),
(1, 0, '2011-11-13', 14),
(1, 0, '2011-11-14', 14),
(1, 0, '2011-11-15', 14),
(0, 1, '2011-11-15', 34),
(0, 1, '2011-11-15', 50),
(1, 0, '2011-11-16', 14),
(1, 0, '2011-11-17', 14),
(1, 0, '2011-11-18', 14),
(1, 0, '2011-11-19', 14),
(1, 0, '2011-11-20', 14),
(1, 0, '2011-11-21', 14),
(1, 0, '2011-11-22', 14),
(1, 0, '2011-11-23', 14),
(0, 1, '2011-11-23', 133),
(0, 1, '2011-11-23', 134),
(0, 1, '2011-11-23', 135),
(0, 1, '2011-11-23', 136),
(0, 1, '2011-11-23', 161),
(0, 1, '2011-11-23', 59),
(1, 0, '2011-11-24', 14),
(1, 0, '2011-11-25', 14),
(1, 0, '2011-11-26', 14),
(1, 0, '2011-11-27', 14),
(1, 0, '2011-11-28', 14),
(1, 0, '2011-11-29', 14),
(1, 0, '2011-11-30', 14),
(1, 0, '2011-12-01', 14),
(1, 0, '2011-12-02', 14),
(1, 0, '2011-12-03', 14),
(1, 0, '2011-12-04', 14),
(1, 0, '2011-12-05', 14),
(1, 0, '2011-12-06', 14),
(1, 0, '2011-12-07', 14),
(1, 0, '2011-12-08', 14),
(1, 0, '2011-12-09', 14),
(0, 1, '2011-12-09', 132),
(1, 0, '2011-12-10', 14),
(1, 0, '2011-12-11', 14),
(1, 0, '2011-12-12', 14),
(1, 0, '2011-12-13', 14),
(1, 0, '2011-12-14', 14),
(0, 1, '2011-12-14', 133),
(0, 1, '2011-12-14', 134),
(0, 1, '2011-12-14', 135),
(0, 1, '2011-12-14', 136),
(0, 1, '2011-12-14', 161),
(0, 1, '2011-12-14', 59),
(1, 0, '2011-12-15', 14),
(1, 0, '2011-12-16', 14),
(1, 0, '2011-12-17', 14),
(1, 0, '2011-12-18', 14),
(1, 0, '2011-12-19', 14),
(1, 0, '2011-12-20', 14),
(1, 0, '2011-12-21', 14),
(1, 0, '2011-12-22', 14),
(0, 1, '2011-12-22', 153),
(1, 0, '2011-12-23', 14),
(1, 0, '2011-12-24', 14),
(1, 0, '2011-12-25', 14),
(1, 0, '2011-12-26', 14),
(1, 0, '2011-12-27', 14),
(1, 0, '2011-12-28', 14),
(1, 0, '2011-12-29', 14),
(1, 0, '2011-12-30', 14),
(1, 0, '2011-12-31', 14),
(1, 0, '2012-01-01', 14),
(1, 0, '2012-01-02', 14),
(1, 0, '2012-01-03', 14),
(1, 0, '2012-01-04', 14),
(0, 1, '2012-01-04', 133),
(0, 1, '2012-01-04', 134),
(0, 1, '2012-01-04', 135),
(0, 1, '2012-01-04', 136),
(0, 1, '2012-01-04', 161),
(0, 1, '2012-01-04', 59),
(1, 0, '2012-01-05', 14),
(1, 0, '2012-01-06', 14),
(1, 0, '2012-01-07', 14),
(1, 0, '2012-01-08', 14),
(1, 0, '2012-01-09', 14),
(1, 0, '2012-01-10', 14),
(1, 0, '2012-01-11', 14),
(1, 0, '2012-01-12', 14),
(1, 0, '2012-01-13', 14),
(1, 0, '2012-01-14', 14),
(1, 0, '2012-01-15', 14),
(1, 0, '2012-01-16', 14),
(1, 0, '2012-01-17', 14),
(1, 0, '2012-01-18', 14),
(1, 0, '2012-01-19', 14),
(1, 0, '2012-01-20', 14),
(1, 0, '2012-01-21', 14),
(1, 0, '2012-01-22', 14),
(0, 1, '2012-01-22', 130),
(1, 0, '2012-01-23', 14),
(1, 0, '2012-01-24', 14),
(1, 0, '2012-01-25', 14),
(0, 1, '2012-01-25', 133),
(0, 1, '2012-01-25', 134),
(0, 1, '2012-01-25', 135),
(0, 1, '2012-01-25', 136),
(0, 1, '2012-01-25', 161),
(0, 1, '2012-01-25', 59),
(1, 0, '2012-01-26', 14),
(1, 0, '2012-01-27', 14),
(1, 0, '2012-01-28', 14),
(1, 0, '2012-01-29', 14),
(1, 0, '2012-01-30', 14),
(1, 0, '2012-01-31', 14),
(1, 0, '2012-02-01', 14),
(1, 0, '2012-02-02', 14),
(1, 0, '2012-02-03', 14),
(1, 0, '2012-02-04', 14),
(1, 0, '2012-02-05', 14),
(1, 0, '2012-02-06', 14),
(1, 0, '2012-02-07', 14),
(1, 0, '2012-02-08', 14),
(1, 0, '2012-02-09', 14),
(1, 0, '2012-02-10', 14),
(1, 0, '2012-02-11', 14),
(1, 0, '2012-02-12', 14),
(1, 0, '2012-02-13', 14),
(0, 1, '2012-02-13', 34),
(0, 1, '2012-02-13', 50),
(1, 0, '2012-02-14', 14),
(1, 0, '2012-02-15', 14),
(0, 1, '2012-02-15', 133),
(0, 1, '2012-02-15', 134),
(0, 1, '2012-02-15', 135),
(0, 1, '2012-02-15', 136),
(0, 1, '2012-02-15', 161),
(0, 1, '2012-02-15', 59),
(1, 0, '2012-02-16', 14),
(1, 0, '2012-02-17', 14),
(1, 0, '2012-02-18', 14),
(1, 0, '2012-02-19', 14),
(1, 0, '2012-02-20', 14),
(1, 0, '2012-02-21', 14),
(0, 1, '2012-02-21', 158),
(1, 0, '2012-02-22', 14),
(0, 1, '2012-02-22', 157),
(1, 0, '2012-02-23', 14),
(1, 0, '2012-02-24', 14),
(1, 0, '2012-02-25', 14),
(1, 0, '2012-02-26', 14),
(1, 0, '2012-02-27', 14),
(1, 0, '2012-02-28', 14),
(1, 0, '2012-02-29', 14),
(1, 0, '2012-03-01', 14),
(1, 0, '2012-03-02', 14),
(1, 0, '2012-03-03', 14),
(1, 0, '2012-03-04', 14),
(1, 0, '2012-03-05', 14),
(1, 0, '2012-03-06', 14),
(1, 0, '2012-03-07', 14),
(0, 1, '2012-03-07', 133),
(0, 1, '2012-03-07', 134),
(0, 1, '2012-03-07', 135),
(0, 1, '2012-03-07', 136),
(0, 1, '2012-03-07', 161),
(0, 1, '2012-03-07', 59),
(1, 0, '2012-03-08', 14),
(1, 0, '2012-03-09', 14),
(1, 0, '2012-03-10', 14),
(1, 0, '2012-03-11', 14),
(1, 0, '2012-03-12', 14),
(1, 0, '2012-03-13', 14),
(1, 0, '2012-03-14', 14),
(1, 0, '2012-03-15', 14),
(0, 1, '2012-03-15', 153),
(1, 0, '2012-03-16', 14),
(1, 0, '2012-03-17', 14),
(1, 0, '2012-03-18', 14),
(1, 0, '2012-03-19', 14),
(1, 0, '2012-03-20', 14),
(1, 0, '2012-03-21', 14),
(1, 0, '2012-03-22', 14),
(1, 0, '2012-03-23', 14),
(1, 0, '2012-03-24', 14),
(1, 0, '2012-03-25', 14),
(1, 0, '2012-03-26', 14),
(1, 0, '2012-03-27', 14),
(1, 0, '2012-03-28', 14),
(1, 0, '2012-03-29', 14),
(0, 1, '2012-03-29', 133),
(0, 1, '2012-03-29', 134),
(0, 1, '2012-03-29', 135),
(0, 1, '2012-03-29', 136),
(0, 1, '2012-03-29', 161),
(0, 1, '2012-03-29', 59),
(1, 0, '2012-03-30', 14),
(1, 0, '2012-03-31', 14),
(1, 0, '2012-04-01', 14),
(1, 0, '2012-04-02', 14),
(1, 0, '2012-04-03', 14),
(1, 0, '2012-04-04', 14),
(1, 0, '2012-04-05', 14),
(1, 0, '2012-04-06', 14),
(1, 0, '2012-04-07', 14),
(1, 0, '2012-04-08', 14),
(1, 0, '2012-04-09', 14),
(1, 0, '2012-04-10', 14),
(1, 0, '2012-04-11', 14),
(1, 0, '2012-04-12', 14),
(0, 1, '2012-04-12', 153),
(1, 0, '2012-04-13', 14),
(1, 0, '2012-04-14', 14),
(1, 0, '2012-04-15', 14),
(1, 0, '2012-04-16', 14),
(1, 0, '2012-04-17', 14),
(1, 0, '2012-04-18', 14),
(1, 0, '2012-04-19', 14),
(0, 1, '2012-04-19', 133),
(0, 1, '2012-04-19', 134),
(0, 1, '2012-04-19', 135),
(0, 1, '2012-04-19', 136),
(0, 1, '2012-04-19', 161),
(0, 1, '2012-04-19', 59),
(1, 0, '2012-04-20', 14),
(1, 0, '2012-04-21', 14),
(1, 0, '2012-04-22', 14),
(1, 0, '2012-04-23', 14),
(1, 0, '2012-04-24', 14),
(1, 0, '2012-04-25', 14),
(1, 0, '2012-04-26', 14),
(1, 0, '2012-04-27', 14),
(1, 0, '2012-04-28', 14),
(1, 0, '2012-04-29', 14),
(1, 0, '2012-04-30', 14),
(1, 0, '2012-05-01', 14),
(1, 0, '2012-05-02', 14),
(1, 0, '2012-05-03', 14),
(0, 1, '2012-05-07', 132),
(0, 1, '2012-05-08', 14),
(0, 1, '2012-05-10', 133),
(0, 1, '2012-05-10', 134),
(0, 1, '2012-05-10', 135),
(0, 1, '2012-05-10', 136),
(0, 1, '2012-05-10', 161),
(0, 1, '2012-05-10', 59),
(0, 1, '2012-05-11', 132),
(0, 1, '2012-05-13', 132),
(0, 1, '2012-05-13', 34),
(0, 1, '2012-05-13', 50),
(0, 1, '2012-05-15', 132),
(0, 1, '2012-05-17', 132),
(0, 1, '2012-05-19', 132),
(0, 1, '2012-05-20', 132),
(0, 1, '2012-05-21', 132),
(0, 1, '2012-05-22', 132),
(0, 1, '2012-05-23', 132),
(0, 1, '2012-05-24', 132),
(0, 1, '2012-05-25', 132),
(0, 1, '2012-05-27', 132),
(0, 1, '2012-05-28', 132),
(0, 1, '2012-05-29', 132),
(0, 1, '2012-05-30', 132),
(0, 1, '2012-05-31', 132),
(0, 1, '2012-06-02', 132),
(0, 1, '2012-06-04', 132),
(0, 1, '2012-06-05', 132),
(0, 1, '2012-06-06', 132),
(0, 1, '2012-06-07', 132),
(0, 1, '2012-06-08', 132),
(0, 1, '2012-06-10', 132),
(0, 1, '2012-06-11', 132),
(0, 1, '2012-06-12', 132),
(0, 1, '2012-06-14', 132),
(0, 1, '2012-06-15', 132),
(0, 1, '2012-06-16', 132),
(0, 1, '2012-06-17', 132),
(0, 1, '2012-06-18', 132),
(0, 1, '2012-06-18', 14),
(0, 1, '2012-06-19', 132),
(0, 1, '2012-06-20', 132),
(0, 1, '2012-06-21', 132),
(0, 1, '2012-06-22', 132),
(0, 1, '2012-06-26', 132),
(0, 1, '2012-06-29', 132),
(0, 1, '2012-06-30', 132),
(0, 1, '2012-07-01', 132),
(0, 1, '2012-07-03', 132),
(0, 1, '2012-07-04', 132),
(0, 1, '2012-07-06', 132),
(0, 1, '2012-07-09', 132),
(0, 1, '2012-07-10', 132),
(0, 1, '2012-07-13', 132),
(0, 1, '2012-07-14', 133),
(0, 1, '2012-07-14', 134),
(0, 1, '2012-07-14', 135),
(0, 1, '2012-07-14', 136),
(0, 1, '2012-07-14', 161),
(0, 1, '2012-07-14', 59),
(0, 1, '2012-07-15', 132),
(0, 1, '2012-07-16', 132),
(0, 1, '2012-07-17', 132),
(0, 1, '2012-07-19', 132),
(0, 1, '2012-07-22', 132),
(0, 1, '2012-07-24', 132),
(0, 1, '2012-07-28', 132),
(0, 1, '2012-07-31', 132),
(0, 1, '2012-08-02', 132),
(0, 1, '2012-08-03', 132),
(0, 1, '2012-08-04', 132),
(0, 1, '2012-08-05', 132),
(0, 1, '2012-08-06', 132),
(0, 1, '2012-08-07', 132),
(0, 1, '2012-08-08', 132),
(0, 1, '2012-08-09', 132),
(0, 1, '2012-08-10', 132),
(0, 1, '2012-08-11', 132),
(0, 1, '2012-08-12', 34),
(0, 1, '2012-08-12', 50),
(0, 1, '2012-08-13', 34),
(0, 1, '2012-08-14', 132),
(0, 1, '2012-08-16', 132),
(0, 1, '2012-08-19', 132),
(0, 1, '2012-08-21', 133),
(0, 1, '2012-08-21', 134),
(0, 1, '2012-08-21', 135),
(0, 1, '2012-08-21', 136),
(0, 1, '2012-08-21', 161),
(0, 1, '2012-08-21', 59),
(0, 1, '2012-08-21', 132),
(0, 1, '2012-08-24', 132),
(0, 1, '2012-08-26', 132),
(0, 1, '2012-08-27', 132),
(0, 1, '2012-08-29', 132),
(0, 1, '2012-08-30', 132),
(0, 1, '2012-09-01', 132),
(0, 1, '2012-09-02', 132),
(0, 1, '2012-09-03', 132),
(0, 1, '2012-09-05', 132),
(0, 1, '2012-09-09', 132),
(0, 1, '2012-09-12', 132),
(0, 1, '2012-09-13', 132),
(0, 1, '2012-09-14', 132),
(0, 1, '2012-09-21', 132),
(0, 1, '2012-09-23', 132),
(0, 1, '2012-09-25', 132),
(0, 1, '2012-09-26', 132),
(0, 1, '2012-09-27', 132),
(0, 1, '2012-09-29', 132),
(0, 1, '2012-09-30', 132),
(0, 1, '2012-09-30', 133),
(0, 1, '2012-09-30', 134),
(0, 1, '2012-09-30', 135),
(0, 1, '2012-09-30', 136),
(0, 1, '2012-09-30', 161),
(0, 1, '2012-09-30', 59),
(0, 1, '2012-10-01', 132),
(0, 1, '2012-10-02', 132);

-- --------------------------------------------------------

--
-- Table structure for table `phpads_adviews`
--

CREATE TABLE IF NOT EXISTS `phpads_adviews` (
  `bannerID` mediumint(9) NOT NULL DEFAULT '0',
  `t_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `host` varchar(255) NOT NULL DEFAULT '',
  KEY `clientID` (`bannerID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `phpads_banners`
--

CREATE TABLE IF NOT EXISTS `phpads_banners` (
  `bannerID` mediumint(9) NOT NULL AUTO_INCREMENT,
  `clientID` mediumint(9) NOT NULL DEFAULT '0',
  `active` enum('true','false') NOT NULL DEFAULT 'true',
  `weight` tinyint(4) NOT NULL DEFAULT '1',
  `seq` tinyint(4) NOT NULL DEFAULT '0',
  `banner` blob NOT NULL,
  `width` smallint(6) NOT NULL DEFAULT '0',
  `height` smallint(6) NOT NULL DEFAULT '0',
  `format` enum('gif','jpeg','png','html','url','web','swf') NOT NULL DEFAULT 'gif',
  `url` varchar(255) NOT NULL DEFAULT '',
  `alt` varchar(255) NOT NULL DEFAULT '',
  `status` varchar(255) NOT NULL DEFAULT '',
  `keyword` varchar(255) NOT NULL DEFAULT '',
  `bannertext` varchar(255) NOT NULL DEFAULT '',
  `target` varchar(8) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `autohtml` enum('true','false') NOT NULL DEFAULT 'true',
  PRIMARY KEY (`bannerID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=174 ;

--
-- Dumping data for table `phpads_banners`
--

INSERT INTO `phpads_banners` (`bannerID`, `clientID`, `active`, `weight`, `seq`, `banner`, `width`, `height`, `format`, `url`, `alt`, `status`, `keyword`, `bannertext`, `target`, `description`, `autohtml`) VALUES
(33, 30, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73712f77616974655f6c696c795f706f696e742e6a7067, 575, 84, 'url', 'http://www.globalairphotos.com/property/lily_point/', '', '', 'Squamish', '', '', 'Squamish', 'true'),
(34, 32, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f77682f77616974655f7468696e6b5f6269672e6a7067, 575, 84, 'url', 'http://www.globalairphotos.com/colorprints.html', '', '', 'Whistler', 'Poster prints with graphics sells commercial real estate', '', 'Whistler', 'true'),
(2, 4, 'true', 1, 0, 0x2f62616e6e6572732f62632f73712f706c756d625f7265616c746f722e6a7067, 575, 84, 'url', 'http://www.neilplumb.com', '', '', 'Squamish', 'Neil Plumb (604) 683-7535 / Goddard & Smith International Commercial Real Estate', '', 'Squamish', 'true'),
(42, 39, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d692f7768697474696e6768616d5f68657269746167655f7061726b2e6a7067, 575, 80, 'url', 'http://www.ourlistings.com', '', '', 'Mission Default British_Columbia Lower_Mainland', '*The Whittingham Team* Re/Max Maple Ridge Realty / 1-800-816-2274  Local 604-466-2838', '', 'Mission Default British_Columbia Lower_Mainland', 'true'),
(12, 15, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73712f706c756d625f676f6c665f636f757273652e6a7067, 575, 80, 'url', 'http://www.neilplumb.com', '', '', 'Squamish', 'It pays to play with a winner / Neil Plumb (604) 683-7535 Goddard & Smith International', '', 'Squamish', 'true'),
(52, 47, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6e612f77616974655f6f776c2e6a7067, 575, 80, 'url', 'http://www.globalbirdphotos.com/large.php?family=Owls&bird=Long-eared+Owl&photo_id=91984_01G&size=art-large', '', '', 'Nanaimo', '', '', 'Nanaimo', 'true'),
(53, 48, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6e612f77616974655f7468696e6b5f6269672e6a7067, 575, 84, 'url', 'http://www.globalairphotos.com/colorprints.html', '', '', 'Nanaimo', '', '', 'Nanaimo', 'true'),
(40, 37, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f77682f6c696c795f706f696e742e6a7067, 575, 80, 'url', 'http://www.globalairphotos.com/property/lily_point/', '', '', 'Whistler', '415 acre golf course site for sale in Point Roberts, Washington State', '', 'Whistler', 'true'),
(14, 16, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73712f706c756d625f7365615f746f5f736b792e6a7067, 575, 80, 'url', 'http://www.neilplumb.com', '', '', 'Squamish', 'Neil Plumb (604) 683-7535 / Goddard & Smith International', '', 'Squamish', 'true'),
(15, 17, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73712f706c756d625f6c696f6e736261795f70656d626572746f6e2e6a7067, 575, 80, 'url', 'http://www.neilplumb.com', '', '', 'Squamish', 'Neil Plumb (604) 683-7535 / Goddard & Smith International', '', 'Squamish', 'true'),
(36, 34, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f77682f706c756d625f7265616c746f722e6a7067, 575, 84, 'url', 'http://www.neilplumb.com/', '', '', 'Whistler Default British_Columbia Sunshine_Coast Lower_Mainland', 'Neil Plumb (604) 683-7535 / Goddard & Smith International Commercial Real Estate', '', 'Whistler Default British_Columbia Sunshine_Coast Lower_Mainland', 'true'),
(39, 36, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f77682f706c756d625f6c696f6e736261795f70656d626572746f6e2e6a7067, 575, 80, 'url', 'http://www.neilplumb.com', '', '', 'Whistler Default British_Columbia Sunshine_Coast Lower_Mainland', 'For an experienced commercial real estate professional call Neil Plumb at (604) 683-7535', '', 'Whistler Default British_Columbia Sunshine_Coast Lower_Mainland', 'true'),
(38, 35, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f77682f706c756d625f676f6c665f636f757273652e6a7067, 575, 80, 'url', 'http://www.neilplumb.com', '', '', 'Whistler Default British_Columbia Sunshine_Coast Lower_Mainland', 'It pays to play with a winner / Neil Plumb at (604) 683-7535', '', 'Whistler Default British_Columbia Sunshine_Coast Lower_Mainland', 'true'),
(32, 29, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73712f77616974655f7468696e6b5f6269672e6a7067, 575, 84, 'url', 'http://www.globalairphotos.com', '', '', 'squamish', '', '', '', 'true'),
(35, 33, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f77682f706c756d625f7365615f746f5f736b792e6a7067, 575, 80, 'url', 'http://www.neilplumb.com/', '', '', 'Whistler Default British_Columbia Sunshine_Coast Lower_Mainland', 'Neil Plumb (604) 683-7535 / Goddard & Smith International', '', 'Whistler Default British_Columbia Sunshine_Coast Lower_Mainland', 'true'),
(30, 27, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d722f7768697474696e6768616d5f6d722e6a7067, 575, 80, 'url', 'http://www.ourlistings.com', '', '', 'Maple Ridge Lower_Mainland British_Columbia Default', 'Liz and Bruce Whittingham / Re/Max Maple Ridge Realty / Toll Free 1-800-816-2274', '', 'Maple Ridge Lower_Mainland British_Columbia Default', 'true'),
(129, 142, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73792f7375727265795f6275735f63656e7472652e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=173672', '', '', 'Surrey Lower_Mainland Default British_Columbia', 'Surrey Central Business Park for Sale / Kevin Meikle (604) 683-3111 Royal LePage Commercial', '', 'Surrey Lower_Mainland Default British_Columbia', 'true'),
(43, 40, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d722f77616974655f7468696e6b5f6269672e6a7067, 575, 84, 'url', 'http://www.globalairphotos.com/colorprints.html', '', '', 'Maple Ridge British Columbia Ontario Alberta Manitoba Saskatchewan', 'A poster-sized display with graphics on an aerial photo sells real estate', '', 'Maple Ridge British Columbia Ontario Alberta Manitoba Saskatchewan', 'true'),
(44, 41, 'true', 2, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d722f77616974655f6c696c795f706f696e742e6a7067, 575, 84, 'url', 'http://www.globalairphotos.com/property/lily_point/', '', '', 'Maple Ridge Default British_Columbia Lower_Mainland', '415 acre approved Golf Course Site / Lily Point Estates, Point Roberts, Washington State', '', 'Maple Ridge Default British_Columbia Lower_Mainland', 'true'),
(46, 42, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d722f62697264616e696d6174696f6e2e676966, 575, 80, 'url', 'http://www.globalbirdphotos.com/fine_art_prints.html', '', '', 'Maple Ridge Default British_Columbia Lower_Mainland', 'Think of framed bird photographs as art - It works! Call Don Waite - (604)467-9141 - to learn more', '', 'Maple Ridge Default British_Columbia Lower_Mainland', 'true'),
(48, 44, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f63712f77616974655f626c7565626972642e6a7067, 571, 146, 'url', 'http://www.globalbirdphotos.com/fine_art_prints.html', '', '', 'Port Coquitlam Port Moody', 'Framed Bird Images as Fine Art Prints', '', '', 'true'),
(50, 46, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f63712f77616974655f7468696e6b5f6269672e6a7067, 575, 84, 'url', 'http://www.globalairphotos.com/colorprints.html', '', '', 'Coquitlam', 'Large 4 ft x 5 ft and larger poster prints with graphics sells commercial real estate', '', 'Coquitlam', 'true'),
(54, 49, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6e612f77616974655f6c696c795f706f696e742e6a7067, 575, 84, 'url', 'http://www.globalairphotos.com/property/lily_point/', '', '', 'Nanaimo', '', '', 'Nanaimo', 'true'),
(55, 50, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6e612f77616974655f63617264696e616c2e6a7067, 575, 150, 'url', 'http://www.globalbirdphotos.com/large.php?family=Cardinals&bird=Northern+Cardinal&photo_id=91986-01B&size=art-large', '', '', 'Nanaimo', '', '', 'Nanaimo', 'true'),
(62, 58, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6c672f686565645f6c6f67616e5f6176652e6a7067, 700, 90, 'url', 'http://www.colliersmn.com/prod/cclod.nsf/city/C5AE965A1AF5A32588256D20005FBC84', '', '', 'Langley', '', '', 'Langley', 'true'),
(65, 63, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f63712f6772697474656e5f61795f62726f61647761792e6a7067, 700, 150, 'url', 'http://www.avisonyoung.com/fs-all-van.html', '', '', 'Coquitlam Port Coquitlam Port Moody', '**01/25  Robert Gritten - Avison Young Commercial Real Estate Services - Direct Line 604-647-5063', '', 'Coquitlam Port Coquitlam Port Moody', 'true'),
(71, 72, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f62792f68616e6e61685f6a6a625f7374696c6c5f637265656b2e6a7067, 575, 80, 'url', 'http://www.jjb.com/client/jjb/JJBNA%20Web%20Listing%20db.nsf/d6b39e36062b094885256bd10056619a/87ad340d2d4333cf88256a640062f7e3!OpenDocument', '', '', 'Burnaby Default British_Columbia Lower_Mainland', '4321 Still Creek Dr for Sublease / Howard Malchy - J J Barnicki Vancouver, Ltd - 604-895-2226', '', 'Burnaby Default British_Columbia Lower_Mainland', 'true'),
(72, 73, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f62792f617669735f636c635f676c656e6c796f6e2e6a7067, 575, 80, 'url', 'http://www.glenlyonbusinesspark.com/en/Location.htm', '', '', 'Burnaby Big Bend Lower_MainLand British_Columbia', 'Glenlyon Business Park for Sale / Doug Avis - (604) 775-7177 - Canada Lands Company', '', 'Burnaby Big Bend Lower_Mainland British_Columbia', 'true'),
(68, 66, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6e652f73746f6b65735f61795f636861686b6f5f6d696b615f6d616c6c2e6a7067, 700, 150, 'url', 'http://www.avisonyoung.com/fs-all-van.html', '', '', 'Nelson', 'Brad Stokes - Avison Young Commercial Real Estate Services - 604-647-5073 / Chahko Mika Mall for Sale', '', 'Nelson', 'true'),
(73, 75, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f61622f6d696c6c657474655f6d6163646f6e616c645f6d61727368616c6c5f72642e6a7067, 700, 150, 'url', 'http://www.loopnet.com/xnet/looplink/looplinks/macdonaldcom/qrylongResults.aspx?SearchType=FS&name=/brokers/macdonaldcom', '', '', 'Abbotsford', '**01/25  Residential Land for Sale / Chris Millette - Macdonald Commercial - 604-736-5611', '', 'Abbotford', 'true'),
(74, 77, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f72682f33776573745f63656e7472652e6a7067, 575, 80, 'url', 'http://www.loopnet.com/xnet/looplink/looplinks/macdonaldcom/qrylongResults.aspx?SearchType=FS&name=/brokers/macdonaldcom', '', '', 'Richmond Default British_Columbia Lower_Mainland', 'Three West Centre for Sale / Chris Millette - Macdonald Commercial - 604-736-5611', '', 'Richmond Default British_Columbia Lower_Mainland', 'true'),
(78, 79, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d722f6c696c795f706f696e742e6a7067, 575, 80, 'url', 'http://www.brendajenkins.com/lily.htm', '', '', 'Maple Ridge Default Lower_Mainland British_Columbia', 'Lily Point Estates, Point Roberts / Brenda Jenkins - Re/Max Ridge-Meadows Realty - 604-466-2838', '', 'Maple Ridge Default Lower_Mainland British_Columbia', 'true'),
(79, 81, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d722f6c696c795f706f696e742e6a7067, 575, 80, 'url', 'http://www.brendajenkins.com/lily.htm', '', '', 'Delta Default Lower_Mainland British_Columbia', 'Lily Point Estates for Sale / Brenda Jenkins - Re/Max Ridge Meadows Realty - (604) 467-2838', '', 'Delta Default Lower_Mainland British_Columbia', 'true'),
(83, 85, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f626d2f636f6c6c696572735f6d616b696e5f6c616e64732e6a7067, 575, 80, 'url', 'http://www.colliersmn.com/prod/cclod.nsf/city/90CABEE8CAD2D15288256D4F00742943?OpenDocument', '', '', 'Britannia Mines British Columbia Default Lower_Mainland Briutish_Columbia', 'Colliers International / Scott Peters (604) 661-0889', '', 'Britannia Mines British Columbia Default Lower_Mainland British_columbia', 'true'),
(85, 87, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d692f6f6c73656e5f6d697373696f6e5f7061726b5f6d616c6c2e6a7067, 575, 80, 'url', 'http://www.cls.ca/property.asp?gts=d&gcs=215&fs=Y&pts=0&pr=6&db=0&exp=0&lr=0&src=1&form=adv&pn=1&pgt=d&pgc=215>=d&gc=215&L=1&pid=935054', '', '', 'Mission Default British_Columbia Lower_Mainland', 'Mission Place Mall for Sale / Keith Olsen - Re/Max Commercial Real Estate Services - (604) 263-2823', '', 'Mission Default British_Columbia Lower_Mainland', 'true'),
(86, 88, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f646c2f6f6c73656e5f64656c74615f70726163746963652e6a7067, 700, 150, 'url', 'http://www.remax.ca/cgi/frame.cgi?number=8100', '', '', 'Delta', 'Delta Practice Centre for Sale / Call Keith Olsen - Re/Max Commercial - (604) 263-2823', '', 'Delta', 'true'),
(88, 90, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73792f6f6c73656e5f64656c74615f70726163746963652e6a7067, 700, 150, 'url', 'http://www.remax.ca/cgi/frame.cgi?number=8100', '', '', 'Surrey', 'Delta Practice Centre for Sale / Contact Keith Olsen - Re/Max Commercial Real Estate Services - (604) 263-2823', '', 'Surrey', 'true'),
(89, 92, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f70742f77656962656c7a6168745f70616e7472795f726573742e6a7067, 700, 300, 'url', 'http://www.remax.ca/cgi/frame.cgi?number=8100', '', 'Pantry Restaurant for Sale, Harris Rd & Lougheed Hwy / Call Ted Weibelzaht - Re/Max Treeland Realty - (604) 534-7974', 'Pitt Meadows Pitt_Meadows', '', '', 'Pitt Meadows Pitt_Meadows', 'true'),
(90, 94, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f75632f677261795f75636c75656c65745f6465765f6c616e642e6a7067, 700, 150, 'url', 'http://www.remax.ca/cgi/frame.cgi?number=8100', '', '', 'Ucluelet', 'Oceanfront Development Land for Sale, Ucluelet, BC / Contact Judy Gray - Re/Max Mid-Island Realty - 1-800-600-1718', '', 'Ucluelet', 'true'),
(91, 95, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6c672f6c65655f676c6f756365737465725f657374617465732e6a7067, 575, 80, 'url', 'http://www.johnhlee.com/', '', '', 'Langley Default British_Columbia Lower_Mainland', 'Gloucester Estates Property for Sale / John H. Lee - Re/Max Central - (604) 433-2211', '', 'Langley Default British_Columbia Lower_Mainland', 'true'),
(92, 96, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f72682f72696368617264736f6e5f76616e686f726e652e6a7067, 700, 150, 'url', 'http://www.cbre.com/properties/cbre_sale.htm', '', '', 'Richmond', '9300 Van Horne Way - Distribution Warehouse for Sale / CB Richard Ellis - Bruce Richardson/Jim Szabo - (604) 662-3000', '', 'Richmond', 'true'),
(94, 99, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f70632f776f6f646c65795f62616c6c6f6f6e2e6a7067, 600, 110, 'url', 'http://www.kimwoodley.net', '', '', 'Port_Coquitlam Port_Moody Coquitlam Default Lower_Mainland British_Columbia', 'Kim Woodley - Re/Max All Points Realty - Toll Free 1-800-939-6838 Local 604-936-0422', '', 'Port_Coquitlam Port_Moody Coquitlam Default Lower_Mainland British_Columbia', 'true'),
(95, 101, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f706d2f776f6f646c65795f62616c6c6f6f6e2e6a7067, 600, 110, 'url', 'http://www.kimwoodley.net', '', '', 'Port_Moody', 'Kim Woodley - Re/Max All Points Realty - Toll Free  1-800-939-6838 Local 604-936-0422', '', 'Port_Moody', 'true'),
(128, 141, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f70712f636f6173745f6d6572696469616e2e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=151089', '', '', 'Port_Coquitlam Default British_Columbia Lower_Mainland', 'Meridian Pointe for Sale / Hudge Parmar (604) 683-3111 Royal LePage', '', 'Port_Coquitlam Default British_Columbia Lower_Mainland', 'true'),
(127, 140, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6e772f736170706572746f6e2e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=147722', '', '', 'New_Westminster Default British_Columbia Lower_Mainland', 'Near Sapperton Skytrain Station for Sale / Peter Maddocks (604) 683-3111 Royal LePage Commercial', '', 'New_Westminster Default British_Columbia Lower_Mainland', 'true'),
(98, 103, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f72682f6c65756e675f6361707374616e5f7761792e6a7067, 700, 150, 'url', '', '', '', 'Richmond', '**  02/75  Magdalen R. Leung - 604-214-8833 / Vacant Land for Sale at Northgate Way & Capstan Way', '', 'Richmond', 'true'),
(100, 104, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f72682f6c65756e675f3835383063616d6269652e6a7067, 700, 150, 'url', 'http://www.cls.ca/results.asp?fs=Y&pts=0&szs=0%2C0%2C0&prv=BC&c1=Richmond&pr=6&db=0&exp=0&lr=0&L=1&form=adv&pn=3', '', '', 'Richmond', '**  03/75  Magdalen R. Leung - 604-214-8833 - 8580 Cambie Rd for Sale', '', 'Richmond', 'true'),
(101, 106, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f61622f63612f636f6f6b655f31356176652e6a7067, 700, 100, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&szs=0,0,0&prv=AB&c1=Calgary&pr=6&db=0&exp=0&lr=0&form=adv&pn=4&gt=c&gc=1&L=1&pid=1051940', '', '', 'Calgary', '** 01/75 Richard H. Cooke - 403-299-0479 - Toole Peet & Company / Multi-tenant Concrete Highrise for Sale', '', 'Calgary', 'true'),
(106, 108, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6e612f6672616e6b6c696e5f727574686572666f72642e6a7067, 700, 150, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&szs=0,0,0&prv=BC&c1=Nanaimo&pr=6&db=0&exp=0&lr=0&form=adv&pn=3&gt=c&gc=1&L=1&pid=780959', '', '', 'Nanaimo', '** 01/75 Development Site near Rutherford Mall / Call Jim Franklin - 250-758-4820 - Sutton Group Whitecap', '', 'Nanaimo', 'true'),
(105, 107, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f61622f63612f686f706577656c6c5f6275735f7061726b2e6a7067, 700, 100, 'url', 'http://216.171.233.199/htdocs/multi_html/multimain.asp', '', '', 'Calgary', '**  02/75  Hopewell Business Park, Calgary', '', 'Calgary', 'true'),
(108, 110, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f62792f73696e67685f6e6f7274685f726f61645f76696c6c6167652e6a7067, 575, 80, 'url', 'http://www.globalairphotos.com/large/BC/Burnaby/University/2002/208/1', '', '', 'Burnaby Default Lower_Mainland British_Columbia', 'North Road Village Centre for Sale / Jazz Singh - (604) 644-8911 - Goodrich Realty Corp.', '', 'Burnaby Default Lower_Mainland British_Columbia', 'true'),
(112, 113, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f76632f636f6c6c696572735f756e6971756570726f706572746965732e6a7067, 575, 80, 'url', 'http://www.uniqueproperties.ca', '', '', 'Lower Mainland', 'Colliers International / Mark Lester (604) 661-0890', '', 'Lower Mainland', 'true'),
(113, 116, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f76632f636f6c6c696572735f756e6971756570726f706572746965732e6a7067, 575, 80, 'url', 'http://www.uniqueproperties.ca', '', '', 'Northern_BC', 'Colliers International / Mark Lester / (604) 661-0890', '', 'Northern_BC', 'true'),
(116, 123, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f626d2f636f6c6c696572735f6d616b696e5f6c616e64732e6a7067, 575, 80, 'url', 'http://www.colliersmn.com/prod/cclod.nsf/city/90CABEE8CAD2D15288256D4F00742943?OpenDocument', '', '', 'Default', 'Colliers International / Scott Peters (604) 661-0889', '', 'Default', 'true'),
(114, 119, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f76632f636f6c6c696572735f756e6971756570726f706572746965732e6a7067, 575, 80, 'url', 'http://www.uniqueproperties.ca', '', '', 'Sunshine_Coast', 'Colliers International / Mark Fester (604) 661-0890', '', 'Sunshine_Coast', 'true'),
(115, 122, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f76632f636f6c6c696572735f756e6971756570726f706572746965732e6a7067, 575, 80, 'url', 'http://www.uniqueproperties.ca', '', '', 'Default Lower_Mainland British_Columbia', 'Colliers International / Mark Lester (604) 661-0955', '', 'Default LowerMainland British_Columbia', 'true'),
(118, 129, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f76632f636f6c6c696572735f756e6971756570726f706572746965732e6a7067, 575, 80, 'url', 'http://www.uniqueproperties.ca', '', '', 'Vancouver_Island', 'Colliers International / Mark Lester (604) 661-0890', '', 'Vancouver_Island', 'true'),
(117, 126, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f76632f636f6c6c696572735f756e6971756570726f706572746965732e6a7067, 575, 80, 'url', 'http://www.uniqueproperties.ca', '', '', 'Okanagan', 'Colliers International / mark Lester (604) 661-0890', '', 'Okanagan', 'true'),
(119, 132, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f76632f636f6c6c696572735f756e6971756570726f706572746965732e6a7067, 575, 80, 'url', 'http://www.uniqueproperties.ca', '', '', 'Kootenay', 'Colliers International / Mark Lester (604) 661-0890', '', 'Kootenay', 'true'),
(120, 133, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f61622f686f6262735f726c5f6d745f6c65686d616e2e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=11091', '', '', 'Abbotsford', '2560 Mt Lehman Rd for Sale / Bill Hobbs (604) 640-5808 / Royal Lepage Commercial Inc.', '', 'Abbotsford', 'true'),
(121, 134, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f62792f626c616e63686172645f726c5f676c656e776f6f642e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=5877', '', '', 'Burnaby Default', 'Len Blanchard (604) 640-5838 / 83 acre Glenwood Industrial Estates for Sale', '', 'Burnaby Default', 'true'),
(130, 143, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f76632f726c5f6d61696e5f7374726565742e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=173662', '', '', 'Vancouver Default British_Columbia Lower_Mainland', '627-601 Main Street for Sale / Daf Meyer (604) 683-3111 Royal LePage Commercial', '', 'Vancouver Default British_Columbia Lower_Mainland', 'true'),
(123, 135, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f62792f726c5f726f795f73742e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=141310', '', '', 'Burnaby Lower_Mainland British_Columbia Default', '5505 Roy Street for Sale / Greg Miles (604) 683-3111', '', 'Burnaby Lower_Mainland British_Columbia Default', 'true'),
(124, 136, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6c672f726c5f72616e64616c6c5f676c6f756365737465722e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=167537', '', '', 'Langley Default British_Columbia Lower_Mainland', 'Gloucester Estates / Bill Randall (604) 683-3111 Royal Lepage Commercial', '', 'Langley Default British_Columbia Lower_Mainland', 'true'),
(125, 137, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6c672f726c5f6c616e676c65795f63726f7373696e672e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=182084', '', '', 'Langley Default British_Columbia Lower_Mainland', 'Langley Crossing Shopping Centre for Sale / Peter Gibson (604) 683-3111 Royal LePage Commercial', '', 'Langley Default British_Columbia Lower_Mainland', 'true'),
(126, 138, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d692f73696c76657264616c655f696e647573747269616c5f7061726b2e6a7067, 575, 80, 'url', 'http://matrix.royallepage.com/user/website/ls_TransListingProfilePublic_en.asp?TransID=5005', '', '', 'Mission Default British_Columbia Lower_Mainland', 'Silverdale Industrial Park for Sale / Bill Randall - (604) 683-3111 Royal LePage Commercial', '', 'Mission Default British_Columbia Lower_Mainland', 'true'),
(133, 148, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6b772f6b656c6f776e615f636f632e6a7067, 355, 80, 'url', 'http://www.kelownachamber.org/kelowna_chamber/index.htm', '', '', 'Kelowna', 'Kelowna Chamber of Commerce / (250) 861-1515 Toll free 1 (800) 663-4345', '', 'kelowna', 'true'),
(134, 149, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6b772f6b656c6f776e615f636f632e6a7067, 355, 80, 'url', 'http://www.kelownachamber.org/kelowna_tourism/index.htm', '', '', 'kelowna', 'Tourism Kelowna / (250)861-1515 Toll free 1 (800)663-4345', '', 'kelowna', 'true'),
(135, 150, 'false', 5, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6d722f6d61706c655f72696467655f706d5f636f632e6a7067, 575, 80, 'url', 'http://mrpmchamber.ca/', '', '', 'Maple_Ridge Pitt_Meadows Maple Ridge Pitt Meadows', 'Maple Ridge Pitt Meadows Chamber of Commerce / (604) 463-3366', '', 'Maple_Ridge Pitt_Meadows Maple Ridge Pitt Meadows', 'true'),
(137, 152, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6b772f63616e6164615f6c616e64735f6b656c6f776e612e6a7067, 480, 85, 'url', 'http://www.clc.ca/clpi.nsf/FindDoc/BrandtsCreekCrossing09162002?OpenDocument', '', '', 'kelowna', 'Brandt\\''s Creek Crossing / Canada Lands Company - Doug Avis (604) 775-7177', '', 'kelowna', 'true'),
(138, 155, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f636b2f636c635f6366626368696c6c697761636b2e6a7067, 580, 80, 'url', 'http://www.clc-cfb-chilliwack.com/en/', '', '', 'Chilliwack Sardis Lower_MainLand British_Columbia', '153 acre Chilliwack Lands / Canada Lands Company - Doug Avis (604) 775-7177', '', 'Chilliwack Sardis Lower_MainLand British_Columbia', 'true'),
(146, 162, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f70622f67735f70656d626572746f6e2e6a7067, 573, 81, 'url', 'http://www.neilplumb.com/', '', '', 'Pemberton', 'Neil Plumb (604) 683-7335 / Goddard & Smith International Commercial Real Estate', '', 'Pemberton', 'true'),
(149, 164, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f626d2f706c756d625f6c6f676f2e6a7067, 558, 126, 'url', 'http://www.neilplumb.com/', '', '', 'Britannia Mines', 'Neil Plumb (604) 683-7335 / Goddard & Smith International Commercial Real Estate', '', 'Britannia Mines', 'true'),
(147, 163, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73712f706c756d625f6c6f676f2e6a7067, 558, 126, 'url', 'http://www.neilplumb.com/', '', '', 'Squamish', 'Neil Plumb (604) 683-7535 / Goddard & Smith International Commercial Real Estate', '', 'Squamish', 'true'),
(145, 161, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f70622f706c756d625f6c6f676f2e6a7067, 558, 126, 'url', 'http://www.neilplumb.com/', '', '', 'Whistler', 'Neil Plumb (604) 683-7535 / Goddard & Smith International Commercial Real Estate', '', 'Whistler British Columbia Lower_Mainland', 'true'),
(148, 163, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73712f706c756d625f6c6f676f2e6a7067, 558, 126, 'url', 'http://www.neilplumb.com/', '', '', 'Squamish', 'Neil Plumb (604) 683-7535 / Goddard & Smith International Commercial Real Estate', '', 'Squamish', 'true'),
(150, 165, 'true', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f72682f77616c746f6e5f636f6c6c6567652e6a7067, 580, 80, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&prv=BC&pr=8&db=0&exp=0&lr=0&form=adv&pn=1>=c&gc=1&L=1&pid=934122', '', '', 'Richmond British_Columbia', 'Lawrence Lim (604) 683-7535 or Cellular (604) 728-8080 / Goddard & Smith International Commercial R E', '', 'Tichmond British_Columbia', 'true'),
(151, 166, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f76692f74726176656c6c6572735f696e6e2e6a7067, 580, 85, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&prv=BC&pr=9&db=0&exp=0&lr=0&form=adv&pn=1&gt=c&gc=1&L=1&pid=498471', '', '', 'Victoria Default Vancouver_Island British_Columbia', 'For Sale in Victoria, BC - Contact Firoz Karim (250) 475-3700 / Diversified Properties Ltd.', '', 'Victoria', 'true'),
(152, 168, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6f6e2f776c2f776869746e65792e6a7067, 580, 85, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&prv=ON&pr=9&db=0&exp=0&lr=0&form=adv&pn=1&gt=c&gc=1&L=1&pid=1080350', '', '', 'Waterloo Ontario Ontario_South Ontario_Southeast Ontario_Southwest Ontario_South_Central Default', 'Land for Sale in Waterloo, Ontario - Darren W. Shaw (519) 746-6300 - J.J. Barnicki Whitney Ltd.', '', 'Waterloo Ontario Ontario_South Default', 'true'),
(153, 169, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f72682f6f627269656e5f736f6c642e6a7067, 580, 80, 'url', 'http://www.globalairphotos.com/large/BC/Richmond/North/2003/170/2', '', '', 'Richmond British_Columbia Default', 'Don O\\''Brien sells Richmond Properties (604) 736-5611 / MacDonald Commercial Real Estate', '', 'Richmond British_Columbia Default', 'true'),
(154, 172, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6f6e2f6d692f6d6973735f6c616e642e6a7067, 570, 80, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&prv=ON&pr=8&db=0&exp=0&lr=0&form=adv&pn=1&gt=c&gc=1&L=1&pid=541922', '', '', 'Mississauga Ontario Ontario_South Ontario_Southeast Ontario_Southwest Ontario_South_Central Default', 'Land for Sale in Mississauga, Ontario - Milia Kats (416) 635-1232 - Homelife / Romano Realty Ltd.', '', 'Mississauga Ontario Ontario_South Default', 'true'),
(155, 174, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6d622f77672f77696e6e697065675f73616c652e6a7067, 580, 85, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&prv=MB&pr=6&db=0&exp=0&lr=0&form=adv&pn=1>=c&gc=1&L=1&pid=1083313', '', '', 'Winnipeg Manitoba Default', 'Tony Marino - (204) 989-6900 - Royal LePage Top Producers Real Estate', '', 'Winnipeg Manitoba Default', 'true'),
(157, 177, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6f6e2f6c6f2f636272655f6d61636b656e7a69652e6a7067, 580, 80, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&prv=ON&pr=8&db=0&exp=0&lr=0&form=adv&pn=1&gt=c&gc=1&L=1&pid=996797', '', '', 'Ontario London Default', 'Robert Scott MacKenzie (416) 674-7900 - CB Richard Ellis', '', 'Ontario London Default', 'true'),
(156, 175, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6d622f77672f646f6d62726f77736b692e6a7067, 575, 80, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&prv=MB&pr=6&db=0&exp=0&lr=0&form=adv&pn=1&gt=c&gc=1&L=1&pid=1171258', '', '', 'Winnipeg Manitoba Default', 'Ada Holdings Co. Ltd. - Janelle Dombrowski - (204) 783-6752', '', 'Winnipeg Manitoba Default', 'true'),
(158, 179, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6f6e2f746f2f6d69646c616e645f72657461696c2e6a7067, 585, 85, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&prv=ON&pr=7&db=0&exp=0&lr=0&form=adv&pn=1&gt=c&gc=1&L=1&pid=1068375', '', '', 'Ontario Midland Default', 'Dennis Hauck (705-526-9770 - Royal LePage Midland Real Estate Service', '', 'Ontario Midland Default', 'true'),
(159, 181, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6f6e2f68612f6262735f68616d696c746f6e2e6a7067, 585, 80, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&szs=0,0,0&prv=ON&pr=7&db=0&exp=0&lr=0&form=adv&pn=3>=c&gc=1&L=1&pid=945949', '', '', 'Hamilton Ontario Default Ontario_Southeast Ontario_Southwest Ontario_South_Central', 'Gary D. Stapleton      (905) 634-4567      Blair Blanchard Stapleton Ltd.', '', 'Hamilton Ontario Default Ontario_Southeast Ontario_Southwest Ontario_South_Central', 'true'),
(160, 181, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6f6e2f68612f6262735f68616d696c746f6e2e6a7067, 585, 80, 'url', 'http://www.cls.ca/property.asp?fs=Y&pts=0&szs=0,0,0&prv=ON&pr=7&db=0&exp=0&lr=0&form=adv&pn=3&gt=c&gc=1&L=1&pid=945949', '', '', 'Hamilton Ontario Default Ontario_Southeast Ontario_Southwest Ontario_South_Central', 'Gary D. Stapleton (905) 634-4567 Blair Blanchard Stapleton Ltd.', '', 'Hamilton Ontario Default Ontario_Southeast Ontario_Southwest Ontario_South_Central', 'true'),
(165, 189, 'false', 1, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f706d2f6e6f7274685f72642e6a7067, 585, 85, 'url', 'http://www.globalairphotos.com/large/BC/Port_Moody/Glenayre/2003/072/2', '', '', 'Port Moody Default British Columbia', 'Apartment building for sale (near Burquitlam Plaza) - Bill Goold (604) 876-9950 Re/Max', '', 'Port Moody Default British Columbia', 'true'),
(163, 187, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73792f6775696c64666f72645f6661722e6a7067, 585, 105, 'url', 'http://www.globalairphotos.com/large/BC/Surrey/Guildford/2003/414/2', '', '', 'Surrey Guildford Default British Columbia', '140 suite apartment for sale (opposite Wal-Mart at Guildford) / Bill Goold (604) 876-9950 Re/Max', '', 'Surrey Guildford Default British Columbia', 'true'),
(164, 188, 'false', 1, 1, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f73792f6775696c64666f72645f74696768742e6a7067, 585, 85, 'url', 'http://www.globalairphotos.com/large/BC/Surrey/Guildford/2003/416/2', '', '', 'Surrey Default British Columbia Guildford', '140 suite apartment building for sale (opposite Wal-Mart at Guildford) - Bill Goold (604) 876-9950 Re/Max', '', 'Surrey Default British Columbia Guildford', 'true'),
(166, 193, 'true', 100, 107, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f62632f6f6c2f6865737465725f637265656b2e6a7067, 580, 80, 'url', 'http://www.pwc.com/ca/eng/about/svcs/brs/hestercreek.html', '', '', 'Default', 'Greg Best. Price Waterhouse Coopers (604) 806-7506', '', 'Default', 'true'),
(167, 196, 'false', 25, 124, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f61626f76655f76616e636f757665722e6a7067, 575, 200, 'url', 'http://www.globalairphotos.com/banners/above_vancouver.jpg', '', '', 'Above Vancouver', 'Above & Beyond Vancouver BLOWOUT SPECIAL', '', 'Above Vancouver', 'true'),
(168, 196, 'false', 25, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f3131322d70616765732668617264636f7665722e6a7067, 575, 200, 'url', 'http://www.globalairphotos.com/journal', '', '', '', 'BLOWOUT SPECIAL / Above & Beyond Vancouver Journal / BLOWOUT SPECIAL', '', '', 'true'),
(172, 196, 'false', 25, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f7269646963756c6f75736c795f6c6f775f7072696365732e6a7067, 575, 200, 'url', 'http://www.globalairphotos.com/journal/orderform.pdf', '', '', '', '', '', '', 'true'),
(169, 196, 'false', 25, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6769616e745f626c6f775f6f75745f73616c652e6a7067, 575, 200, 'url', 'http://www.globalairphotos.com/journal', '', '', '', 'BUY NOW / Above & Beyond Vancouver Journal / BUY NOW', '', '', 'true'),
(170, 196, 'false', 25, 0, 0x485454503a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f68756d6f6e676f75735f646973636f756e74732e6a7067, 575, 200, 'url', 'http://www.globalairphotos.com/journal/orderform.pdf', '', '', '', 'DISCOUNTS UP TO 65 % / Above & Beyond Vancouver Journal', '', '', 'true'),
(171, 196, 'false', 25, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f6c696d697465645f737570706c792e6a7067, 575, 200, 'url', 'http://www.globalairphotos.com/journal', '', '', '', 'THE PERFECT CHRISTMAS STOCKING STUFF / Above & Beyond Vancouver Journal', '', '', 'true'),
(173, 196, 'false', 25, 0, 0x687474703a2f2f7777772e676c6f62616c61697270686f746f732e636f6d2f62616e6e6572732f736174697366616374696f6e5f67756172616e746565642e6a7067, 575, 200, 'url', 'http://www.globalairphotos.com/journal/orderform.pdf', '', '', '', 'JUST IN TIME FOR CHRISTMAS / Above & Beyond Vancouver Journal', '', '', 'true');

-- --------------------------------------------------------

--
-- Table structure for table `phpads_clients`
--

CREATE TABLE IF NOT EXISTS `phpads_clients` (
  `clientID` mediumint(9) NOT NULL AUTO_INCREMENT,
  `clientname` varchar(255) NOT NULL DEFAULT '',
  `contact` varchar(255) DEFAULT NULL,
  `email` varchar(64) NOT NULL DEFAULT '',
  `views` mediumint(9) DEFAULT NULL,
  `clicks` mediumint(9) DEFAULT NULL,
  `clientusername` varchar(64) NOT NULL DEFAULT '',
  `clientpassword` varchar(64) NOT NULL DEFAULT '',
  `expire` date DEFAULT '0000-00-00',
  `activate` date DEFAULT '0000-00-00',
  `permissions` mediumint(9) DEFAULT NULL,
  `language` varchar(64) DEFAULT NULL,
  `active` enum('true','false') NOT NULL DEFAULT 'true',
  `weight` tinyint(4) NOT NULL DEFAULT '1',
  `parent` mediumint(9) NOT NULL DEFAULT '0',
  `report` enum('true','false') NOT NULL DEFAULT 'true',
  `reportinterval` mediumint(9) NOT NULL DEFAULT '7',
  `reportlastdate` date NOT NULL DEFAULT '0000-00-00',
  `reportdeactivate` enum('true','false') NOT NULL DEFAULT 'true',
  PRIMARY KEY (`clientID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=197 ;

--
-- Dumping data for table `phpads_clients`
--

INSERT INTO `phpads_clients` (`clientID`, `clientname`, `contact`, `email`, `views`, `clicks`, `clientusername`, `clientpassword`, `expire`, `activate`, `permissions`, `language`, `active`, `weight`, `parent`, `report`, `reportinterval`, `reportlastdate`, `reportdeactivate`) VALUES
(42, 'Waite/Owl(1)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 25, 'false', 7, '0000-00-00', 'true'),
(41, 'Waite/Lily Point', NULL, '', -1, -1, '', '', '2006-01-01', '0000-00-00', NULL, NULL, 'false', 1, 25, 'true', 7, '0000-00-00', 'true'),
(3, 'BC/Squamish', 'Neil Plumb', 'donalde@globalairphotos.com', NULL, NULL, 'neil', 'green', '0000-00-00', '0000-00-00', 0, 'english', 'true', 1, 0, '', 7, '2003-08-20', 'true'),
(4, 'Plumb/G&S/Realtor(1)', NULL, '', -1, -1, '', '', '2003-10-01', '2003-08-26', NULL, NULL, 'false', 1, 3, 'false', 7, '0000-00-00', 'true'),
(34, 'Plumb/Realtor(1)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 31, 'false', 7, '0000-00-00', 'true'),
(35, 'Plumb/G&S/Golf Course(1)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 31, 'false', 7, '0000-00-00', 'true'),
(36, 'Plumb/G&S/Lions Bay to Pemberton(1)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 31, 'false', 7, '0000-00-00', 'true'),
(37, 'Waite/Lily Point(1)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 31, 'false', 7, '0000-00-00', 'true'),
(10, 'BC/Nanaimo', 'Donald E. Waite', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 27, '', 'true', 1, 0, 'false', 7, '2003-08-21', 'true'),
(48, 'Waite/Think Big(1)', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 1, 10, 'false', 7, '0000-00-00', 'true'),
(47, 'Waite/Owl Photo(1)', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 1, 10, 'false', 7, '0000-00-00', 'true'),
(33, 'Plumb/G&S/Sea to Sky(1)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 31, 'false', 7, '0000-00-00', 'true'),
(15, 'Plumb/G&S/Golf Course(1)', NULL, '', -1, -1, '', '', '0000-00-00', '2003-08-25', NULL, NULL, 'true', 1, 3, 'false', 7, '0000-00-00', 'true'),
(16, 'Plumb/G&S/Sea to Sky(1)', NULL, '', -1, -1, '', '', '0000-00-00', '2003-08-25', NULL, NULL, 'true', 1, 3, 'false', 7, '0000-00-00', 'true'),
(17, 'Plumb/G&S/Lions Bay to Pemberton(1)', NULL, '', -1, -1, '', '', '0000-00-00', '2003-08-25', NULL, NULL, 'true', 1, 3, 'false', 7, '0000-00-00', 'true'),
(32, 'Waite/Think Big(1)', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 1, 31, 'false', 7, '0000-00-00', 'true'),
(31, 'BC/Whistler', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-09-30', 'true'),
(30, 'Waite/Lily Point(1)', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 3, 3, 'false', 7, '0000-00-00', 'true'),
(29, 'Waite/Think Big(1)', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 1, 3, 'false', 7, '0000-00-00', 'true'),
(22, 'BC/Coquitlam', 'Kim Woodley', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-09-16', 'true'),
(146, 'BC/Kelowna', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-23', 'true'),
(149, 'Kelowna Tourism', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 146, 'false', 7, '0000-00-00', 'true'),
(25, 'BC/Maple Ridge', 'Bruce Whittingham', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-09-16', 'true'),
(27, 'Whittingham/ReMax/Our Listing(1)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 25, 'false', 7, '0000-00-00', 'true'),
(40, 'Waite/Think Big(1)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 25, 'false', 7, '0000-00-00', 'true'),
(39, '01/25Whittingham/ReMax/Heritage', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 38, 'false', 7, '0000-00-00', 'true'),
(38, 'BC/Mission', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-01', 'true'),
(143, 'RL/Main Street', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 127, 'false', 7, '0000-00-00', 'true'),
(44, 'Waite/Bluebird (De-activated)', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 1, 22, 'false', 7, '0000-00-00', 'true'),
(45, 'Jenkins/Lily Point', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'true', 1, 22, 'false', 7, '0000-00-00', 'true'),
(46, 'Waite/Think Big', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 1, 22, 'false', 7, '0000-00-00', 'true'),
(98, 'BC/Port Coquitlam', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-07', 'true'),
(49, 'Waite/Lily Point(1)', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 1, 10, 'false', 7, '0000-00-00', 'true'),
(50, 'Waite/Cardinal(1)', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 1, 10, 'false', 7, '0000-00-00', 'true'),
(101, 'Woodley/Remax/Balloon', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 100, 'false', 7, '0000-00-00', 'true'),
(57, 'BC/Langley', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-04', 'true'),
(58, 'Heed/Colliers/Logan Ave', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 57, 'false', 7, '0000-00-00', 'true'),
(59, 'BC/Victoria', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-04', 'true'),
(144, 'RL/Pandora Ave', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 59, 'false', 7, '0000-00-00', 'true'),
(61, 'BC/Burnaby', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-04', 'true'),
(62, '03/75Corlett/RL/Big Bend', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 61, 'false', 7, '0000-00-00', 'true'),
(63, 'Gritten/AY/Broadway (De-activated)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 22, 'false', 7, '0000-00-00', 'true'),
(64, 'BC/Nelson', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-04', 'true'),
(66, 'Stokes/AY/Chahko Mika Mall', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 64, 'false', 7, '0000-00-00', 'true'),
(72, '04/74Hannah/JJB/Still Creek', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 61, 'false', 7, '0000-00-00', 'true'),
(73, '01/75Avis/CLC/Glenlyon', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 61, 'false', 7, '0000-00-00', 'true'),
(74, 'BC/Abbotsford', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-05', 'true'),
(75, '01/25Millette/Macdonald/Marshall Road', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 74, 'false', 7, '0000-00-00', 'true'),
(76, 'BC/Richmond', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-05', 'true'),
(77, '10/75Millette/Macdonald/3West Centre', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 76, 'false', 7, '0000-00-00', 'true'),
(79, 'Jenkins/Lily Point (Inactive)', NULL, '', -1, -1, '', '', '2007-12-01', '2003-09-01', NULL, NULL, 'true', 1, 25, 'false', 7, '0000-00-00', 'true'),
(80, 'BC/Delta', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-05', 'true'),
(81, 'Jenkins/Remax/Lily Point', NULL, '', -1, -1, '', '', '2007-09-01', '2003-09-01', NULL, NULL, 'false', 1, 80, 'false', 7, '0000-00-00', 'true'),
(83, '02/75Boer/Juhala/Colliers/Bombardier', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 61, 'false', 7, '0000-00-00', 'true'),
(84, 'BC/Britannia Mines', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-05', 'true'),
(85, '01/10Peters/Colliers/Makin Lands', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 84, 'false', 7, '0000-00-00', 'true'),
(87, '02/25Olson/Remax/Mission Place Mall', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 38, 'false', 7, '0000-00-00', 'true'),
(88, 'Olsen/Delta Practice Centre', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 80, 'false', 7, '0000-00-00', 'true'),
(89, 'BC/Surrey', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-05', 'true'),
(90, 'Olsen/Delta Pracice Centre', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 89, 'false', 7, '0000-00-00', 'true'),
(91, 'BC/Pitt Meadows', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-05', 'true'),
(92, 'Weibelzaht/Pantry Rest', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 91, 'false', 7, '0000-00-00', 'true'),
(93, 'BC/Ucluelet', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-05', 'true'),
(94, 'Gray/ReMax/Ucluelet Development Land', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 93, 'false', 7, '0000-00-00', 'true'),
(95, 'Lee/Re/Max/Gloucester Estates', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 57, 'false', 7, '0000-00-00', 'true'),
(96, '20/75Richardson/CBRE/Van Horne', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 76, 'false', 7, '0000-00-00', 'true'),
(97, '05/75Ollek/CBRE/Burnaby Business Park', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 61, 'false', 7, '0000-00-00', 'true'),
(99, 'Woodley/Remax/Balloon', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 98, 'false', 7, '0000-00-00', 'true'),
(100, 'BC/Port Moody', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-07', 'true'),
(142, 'RL/Surrey Business Centre', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 89, 'false', 7, '0000-00-00', 'true'),
(102, 'Leung/No3Rd (De-activated)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 76, 'false', 7, '0000-00-00', 'true'),
(103, 'Leung/Capstan Way (DE-activated)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 76, 'false', 7, '0000-00-00', 'true'),
(104, 'Leung/8580 Cambie (De-activated)', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'true', 1, 76, 'false', 7, '0000-00-00', 'true'),
(105, 'AB/Calgary', '', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'true', 7, '2006-11-23', 'true'),
(106, '01/75Cooke/15Ave', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 105, 'false', 7, '0000-00-00', 'true'),
(107, '02/75Hopewell Bus Park', NULL, '', -1, -1, '', '', '2004-09-02', '2003-09-01', NULL, NULL, 'false', 1, 105, 'false', 7, '0000-00-00', 'true'),
(108, '0150Franklin/Rutherford', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 10, 'false', 7, '0000-00-00', 'true'),
(110, '06/75Singh/North Road Ville Centre', NULL, '', -1, -1, '', '', '2004-09-01', '2003-09-01', NULL, NULL, 'false', 1, 61, 'false', 7, '0000-00-00', 'true'),
(112, 'BC/Lower Mainland', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-19', 'true'),
(113, 'Lower Mainland / Unique Properties', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 112, 'false', 7, '0000-00-00', 'true'),
(114, 'BC/Northern BC', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-19', 'true'),
(116, 'Colliers/Unique Properties', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 114, 'false', 7, '0000-00-00', 'true'),
(117, 'BC/Sunshine Coast', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-19', 'true'),
(119, 'BC/Sunshine Coast', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 117, 'false', 7, '0000-00-00', 'true'),
(120, 'BC/Home Page', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-19', 'true'),
(122, 'Colliers/Unique Properties', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 120, 'false', 7, '0000-00-00', 'true'),
(123, 'Colliers/Makin Lands', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 120, 'false', 7, '0000-00-00', 'true'),
(124, 'BC/Okanagan', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-19', 'true'),
(126, 'Colliers/Unique Properties', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 124, 'false', 7, '0000-00-00', 'true'),
(127, 'BC/Vancouver Island', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-19', 'true'),
(129, 'Colliers/Unique Properties', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 127, 'false', 7, '0000-00-00', 'true'),
(130, 'BC/Kootenay', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-19', 'true'),
(132, 'Colliers/Unique Properties', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 130, 'false', 7, '0000-00-00', 'true'),
(133, 'Hobbs/RL/Mt Lehman', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 74, 'false', 7, '0000-00-00', 'true'),
(134, 'Blanchard/RL/Glenwood', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 61, 'false', 7, '0000-00-00', 'true'),
(135, 'Miles/RL/Roy St', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 61, 'false', 7, '0000-00-00', 'true'),
(136, 'RL/Randall/Gloucester Estates', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 57, 'false', 7, '0000-00-00', 'true'),
(137, 'RL/Langley Crossing', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 57, 'false', 7, '0000-00-00', 'true'),
(138, 'RL/Randall/Silverdale I P', NULL, '', -1, -1, '', '', '2004-10-01', '2003-10-01', NULL, NULL, 'false', 1, 38, 'false', 7, '0000-00-00', 'true'),
(139, 'BC/New Westminster', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-10-22', 'true'),
(140, 'RL/Sapperton', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 139, 'false', 7, '0000-00-00', 'true'),
(141, 'RL/Parmar/Coast Meridian', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 98, 'false', 7, '0000-00-00', 'true'),
(148, 'Kelowna Chamber of Commerce', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 146, 'false', 7, '0000-00-00', 'true'),
(150, 'Chamber of Commerce', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 25, 'false', 7, '0000-00-00', 'true'),
(152, 'Canada Lands Co / Brandt''s Creek Crossing', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 146, 'false', 7, '0000-00-00', 'true'),
(153, 'BC/Chiliwack', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-11-09', 'true'),
(156, 'BC/Pemberton', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-11-15', 'true'),
(155, 'Canada lands Co - CFB Chilliwack', NULL, '', -1, -1, '', '', '0000-00-00', '0000-00-00', NULL, NULL, 'true', 1, 153, 'false', 7, '0000-00-00', 'true'),
(161, 'G&S/Plumb_New', NULL, '', -1, -1, '', '', '2004-12-01', '2003-11-01', NULL, NULL, 'false', 1, 31, 'false', 7, '0000-00-00', 'true'),
(163, 'Plumb/Logo', NULL, '', -1, -1, '', '', '2004-12-01', '2003-11-01', NULL, NULL, 'false', 1, 3, 'false', 7, '0000-00-00', 'true'),
(162, 'G&S/Plumb1', NULL, '', -1, -1, '', '', '2004-12-01', '2003-11-01', NULL, NULL, 'false', 1, 156, 'false', 7, '0000-00-00', 'true'),
(164, 'Plumb/G&S', NULL, '', -1, -1, '', '', '2004-12-01', '2003-11-01', NULL, NULL, 'false', 1, 84, 'false', 7, '0000-00-00', 'true'),
(165, 'Lim/Walton College', NULL, '', -1, -1, '', '', '2004-12-01', '2003-11-01', NULL, NULL, 'false', 1, 76, 'false', 7, '0000-00-00', 'true'),
(166, 'Diverfified/Travellers Inn', NULL, '', -1, -1, '', '', '2004-12-01', '2003-11-01', NULL, NULL, 'false', 1, 59, 'false', 7, '0000-00-00', 'true'),
(167, 'ON/Waterloo', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-11-15', 'true'),
(168, 'Barnicki/Whitney', NULL, '', -1, -1, '', '', '2004-12-01', '2003-11-01', NULL, NULL, 'false', 1, 167, 'false', 7, '0000-00-00', 'true'),
(169, 'O''Brien/MacDonald', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 76, 'false', 7, '0000-00-00', 'true'),
(170, 'ON/Mississauga', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-11-15', 'true'),
(173, 'MB/Winnipeg', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-11-16', 'true'),
(172, 'Homefore/Romano', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 170, 'false', 7, '0000-00-00', 'true'),
(174, 'RL/Marino', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 173, 'false', 7, '0000-00-00', 'true'),
(175, 'Ada Holdings/Dombrowski', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 173, 'false', 7, '0000-00-00', 'true'),
(176, 'On/London', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-11-16', 'true'),
(177, 'BCRE/MacKenzie', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 176, 'false', 7, '0000-00-00', 'true'),
(178, 'ON/Midland', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-11-16', 'true'),
(179, 'RL/Hauck', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 178, 'false', 7, '0000-00-00', 'true'),
(180, 'On/Hamilton', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2003-11-16', 'true'),
(181, 'BBS/Industrial Land', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 180, 'false', 7, '0000-00-00', 'true'),
(185, 'South Africa / Pietermaritzburg', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2004-01-28', 'true'),
(189, 'Maplewood/North Rd', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 100, 'false', 7, '0000-00-00', 'true'),
(187, 'Maplewood/Guildford/Far', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 89, 'false', 7, '0000-00-00', 'true'),
(188, 'Maplewood/Guildford/Tight', NULL, '', -1, -1, '', '', '0000-00-00', '2003-11-01', NULL, NULL, 'true', 1, 89, 'false', 7, '0000-00-00', 'true'),
(191, 'BC/Oliver', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'true', 7, '2006-11-23', 'true'),
(192, 'BC/Oliver', '', '', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 0, '', 'true', 1, 0, 'false', 7, '2004-03-25', 'true'),
(193, 'Hester Creek', NULL, '', -1, -1, '', '', '2004-05-01', '2004-03-01', NULL, NULL, 'false', 100, 192, 'false', 7, '0000-00-00', 'true'),
(194, 'Don Waite', 'Don Waite', 'donalde@globalairphotos.com', NULL, NULL, 'password', 'password', '0000-00-00', '0000-00-00', 27, '', 'true', 1, 0, 'true', 7, '2006-11-23', 'true'),
(195, 'Don Waite', 'Don Waite', 'donalde@globalairphotos.com', NULL, NULL, '', '', '0000-00-00', '0000-00-00', 27, '', 'true', 1, 0, 'true', 7, '2006-11-23', 'true'),
(196, 'Above & Beyond Vancouver Journal', NULL, '', -1, -1, '', '', '0000-00-00', '2006-01-01', NULL, NULL, 'true', 25, 25, 'true', 7, '0000-00-00', 'true');

-- --------------------------------------------------------

--
-- Table structure for table `phpads_session`
--

CREATE TABLE IF NOT EXISTS `phpads_session` (
  `SessionID` varchar(32) NOT NULL DEFAULT '',
  `SessionData` blob NOT NULL,
  `LastUsed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`SessionID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phpads_session`
--

INSERT INTO `phpads_session` (`SessionID`, `SessionData`, `LastUsed`) VALUES
('phpads4051fd66995d0', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a333a22313536223b7d, '2004-03-15 01:41:46'),
('phpads4063808749260', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a32303a22332c3135362c3139322c3139322c35312c313730223b7d, '2004-03-26 01:27:31'),
('phpads42dcb69d70c11', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a323a223834223b7d, '2005-07-19 08:26:17'),
('phpads456582d7e6054', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a303a22223b7d, '2006-11-23 11:15:40'),
('phpads456628a9cfc35', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a31313a2232352c32352c32352c3235223b7d, '2006-11-24 00:50:06'),
('phpads45668b478dda6', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a323a223531223b7d, '2006-11-24 20:01:30'),
('phpads45674dd3cb0d6', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a383a2235312c35312c3531223b7d, '2006-11-24 20:03:21'),
('phpads456e573bc5241', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a323a223531223b7d, '2006-11-30 04:02:49'),
('phpads4571164a6e5e6', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a323a223531223b7d, '2006-12-02 06:06:47'),
('phpads45720a5cb6d18', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a323a223531223b7d, '2006-12-02 23:21:19'),
('phpads45721d7e0c25e', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a323a223531223b7d, '2006-12-03 00:44:07'),
('phpads4573d4cd5d73a', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a323a223531223b7d, '2006-12-04 08:01:24'),
('phpads45762dafdf633', 0x613a373a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b7d, '2006-12-06 02:41:28'),
('phpads45762dd8ec9ba', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a323a223531223b7d, '2006-12-06 02:42:19'),
('phpads4576317361fdf', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a323a223531223b7d, '2006-12-06 03:03:21'),
('phpads4c4bcb547f5c1', 0x613a383a7b733a383a227573657274797065223b693a313b733a383a226c6f67676564696e223b733a343a2274727565223b733a383a22757365726e616d65223b733a353a2261646d696e223b733a383a2270617373776f7264223b733a363a22706830743073223b733a31333a2273746174735f636f6d70616374223b733a353a2266616c7365223b733a31303a2273746174735f76696577223b733a333a22616c6c223b733a31313a2273746174735f6f72646572223b733a383a2262616e6e65726964223b733a31313a2273746174735f6e6f646573223b733a303a22223b7d, '2010-07-25 05:29:53');

-- --------------------------------------------------------

--
-- Table structure for table `phpads_zones`
--

CREATE TABLE IF NOT EXISTS `phpads_zones` (
  `zoneid` mediumint(9) NOT NULL AUTO_INCREMENT,
  `zonename` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `zonetype` smallint(6) NOT NULL DEFAULT '0',
  `what` blob NOT NULL,
  `width` smallint(6) NOT NULL DEFAULT '0',
  `height` smallint(6) NOT NULL DEFAULT '0',
  `retrieval` enum('random','cookie') NOT NULL DEFAULT 'random',
  `cachecontents` blob,
  `cachetimestamp` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`zoneid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `phpads_zones`
--

INSERT INTO `phpads_zones` (`zoneid`, `zonename`, `description`, `zonetype`, `what`, `width`, `height`, `retrieval`, `cachecontents`, `cachetimestamp`) VALUES
(1, 'header', 'Page header banner zone', 0, '', 468, 60, 'random', 0x613a323a7b693a303b693a303b693a313b613a303a7b7d7d, 1280035793),
(2, 'footer', 'Footer zone', 0, 0x62616e6e657269643a31, 468, 60, 'random', 0x613a323a7b693a303b693a303b693a313b613a303a7b7d7d, 1280035793);

-- --------------------------------------------------------

--
-- Table structure for table `posters`
--

CREATE TABLE IF NOT EXISTS `posters` (
  `province` char(2) NOT NULL DEFAULT '',
  `city` varchar(50) NOT NULL DEFAULT '',
  `sequence` int(10) unsigned NOT NULL DEFAULT '0',
  `id` varchar(20) NOT NULL DEFAULT '',
  `thumbnail` varchar(50) NOT NULL DEFAULT '',
  `large` varchar(50) DEFAULT NULL,
  `pdf` varchar(50) DEFAULT NULL,
  `pdf_size` varchar(50) DEFAULT NULL,
  `display` char(1) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `flight_date` varchar(100) DEFAULT NULL,
  `description` text,
  `record_num` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`province`,`city`,`thumbnail`),
  UNIQUE KEY `record_num` (`record_num`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `posters`
--

INSERT INTO `posters` (`province`, `city`, `sequence`, `id`, `thumbnail`, `large`, `pdf`, `pdf_size`, `display`, `title`, `flight_date`, `description`, `record_num`) VALUES
('AB', 'Calgary', 1, 'cax2001_193', 'cap2001_193_t.jpg', 'cap2001_193_h.jpg', '', '5.4 MB', 'Y', 'Prince''s Island Park, Calgary, Alberta, Canada', '27 September 2001', 'Downtown Calgary and Prince''s Island facing west towards the Rocky Mountains.', 1),
('BC', 'Coquitlam', 2000072, '2000_072', 'cqp2000_072_t.jpg', 'cqp2000_072_h.jpg', 'cqp2000_072.pdf', '7.3 Mb', 'Y', 'Coquitlam Centre & Westwood Plateau, Coquitlam, British Columbia, Canada - 22 August 2000', 'Flight Date 22 August 2000', 'View northward of Coquitlam Centre with Westwood Plateau and Coquitlam Lake in the background.\r\n\r\n', 3),
('BC', 'Maple Ridge', 2001099, '2001_099', 'mrp2001_099_t.jpg', 'mrp2001_099_h.jpg', 'mrp2001_099.pdf', '5.4 Mb', 'Y', 'Old Port Haney & The South Slope, Maple Ridge, British Columbia, Canada - 2001', 'Flight Date 21 September 2001', 'View of Maple Ridge from over the Fraser River with  the Golden Ears Mountains to the north.', 2),
('BC', 'Coquitlam', 2000077, '2000_077', 'cqp2000_077_t.jpg', 'cqp2000_077_h.jpg', 'cqp2000_077.pdf', '6.5 Mb', 'Y', 'Coquitlam Centre & Burrard Inlet, Coquitlam, British Columbia, Canada - 21 September 2000', 'Flight Date 21 September 200', 'View West of Coquitlam Centre with Burnaby Mountain, Simon Fraser University & Downtown Vancouver in the background.\r\n\r\n', 4),
('BC', 'Nanaimo', 2001059, '2001_059', 'nap2001_047_t.jpg', 'nap2001_047_h.jpg', 'nap2001_047.pdf', '5.4 Mb', 'Y', 'Nanaimo Harbour & Newcastle Island, Nanaimo, British Columbia, Canada', 'Flight Date 20 May 2001', 'View northeast of Nanaimo Harbour with Newcastle Island in the background', 5),
('BC', 'Bella Coola', 1, '2000_031', 'bcp2000_031_t.jpg', 'bcp2000_031_h.jpg', 'bcp2000_031.pdf', '5.8 Mb', 'Y', 'The Rainbow Range, Bella Coola, British Columbia, Canada', 'Flight Date 25 September 2000', 'View northwest of the Rainbow Range just outside of Bella Coola, B.C.', 6),
('BC', 'Maple Ridge', 2001038, '2001_038', 'mrp2001_038_t.jpg', 'mrp2001_038_h.jpg', 'mrp2001_038.pdf', '5.6', 'Y', 'The Golden Ears & Mount Baker, Maple Ridge, British Columbia, Canada - 2001', 'Flight Date 9 February 2001', 'View to the southeast of the Golden Ears Peaks, Mount Blanshard & Alouette Mountain showing Mount Baker in the distance.', 7),
('BC', 'Victoria', 2001030, '2001_030', 'vip2001_030_t.jpg', 'vip2001_030_h.jpg', 'vip2001_030.pdf', '7.1 Mb', 'Y', 'Laurel Point & The Inner Harbour, Victoria, British Columbia, Canada', 'Flight Date 20 May 2001', 'View to the northeast featuring Laurel Point & The Inner Harbour with Downtown Victoria and the Coast Mountains of the mainland in the background. * Note the Search Air Rescue helicopter exercise in The Inner Harbour directly in front of the Provincial Parliament Buildings & the Empress Hotel.', 8),
('BC', 'Vancouver', 2001100, '2001_100', 'vcp2001_100_t.jpg', 'vcp2001_100_h.jpg', 'vcp2001_100.pdf', '7.9 Mb', 'Y', 'Downtown Vancouver & Stanley Park, Vancouver, British Columbia, Canada - 2001', 'Flight Date 11 April 2001', 'View northwest showing Vancouver City Hall & False Creek in the foreground, Downtown Vancouver & Stanley Park, & West Vancouver & the Coast Mountains in the background.', 9),
('BC', 'Hedley', 1999001, '1999_001', 'hdp1999_001_t.jpg', 'hdp1999_001_h.jpg', 'hdp1999_001.pdf', '9.1 Mb', 'Y', 'Nickle Plate Mountain, Hedley, British Columbia, Canada', 'Flight Date 27 August 1999', 'View north showing mine buildings on the cliffs of Nickle Plate Mountain above Hedley.', 10),
('BC', 'Kaslo', 2001006, '2001_006', 'kap2001_006_t.jpg', 'kap2001_006_h.jpg', 'kap2001_006.pdf', '7 Mb', 'Y', 'Kaslo, British Columbia, Canada', 'Flight Date 28 September 2001', 'View northwest of the Kaslo Townsite featuring the SS Moyie on the shores of Kootenay Lake.', 11),
('BC', 'New Westminster', 2001052, '2001_052', 'nwp2001_052_t.jpg', 'nwp2001_052_h.jpg', 'nwp2001_052.pdf', '7 Mb', 'Y', 'Westminster Quay & Public Market, New Westminster, British Columbia, Canada', 'Flight Date: 26 June 2001', 'View northwest of the Fraser River, Westminster Quay & Public Market with Burnaby''s Metrotown and Vancouver in the background.  ', 12),
('BC', 'Pitt Meadows', 1988001, '1988_001', 'ptp1988_001_t.jpg', 'ptp1988_001_8x10_72dpi.jpg', 'ptp1988_001_85x11_300dpi.pdf', '5 Mg', 'Y', 'Lower Pitt River & The Golden Ears', '18 June 1988', 'Early morning view of two tugs towing a boom of logs upriver on the Lower Pitt River with the Golden Ears Mountains in the background.', 13),
('AB', 'Lethbridge', 2001065, '2001_065', 'lex2001_065_t.jpg', 'lex2001_065_h.jpg', 'lex2001_065.pdf', '6.6 Mb', 'Y', 'Fort Whoop-up & The High Level Bridge', '27 September 2001', 'View southwest featuring Downtown Lethbridge''s City Hall in the foregound and the ''Fort Whoop-up'' museum and High Level Bridge in the background with the Rocky Mountains in the far distance.', 14),
('BC', 'Whistler', 1, '2000_002', 'whp2000_002_t.jpg', 'whp2000_002_h.jpg', 'whp2000_002.pdf', '5.4 Mb', 'Y', 'Garibaldi Mountain & The Coast Range', '3 December 2001', 'View of Garibaldi Mountain from the south looking north covered in snow with the Coast Range in the far distance.', 15),
('BC', 'Burnaby', 2000033, '2000_033', 'byp2000_033_t.jpg', 'byp2000_033_h.jpg', 'byp2000_033.pdf', '6.4 Mb', 'Y', 'Metrotown Station & Metrotown Centre, Burnaby, British Columbia', '25 May 2001', 'View to the northwest featuring Metrotown Station and Metrotown Centre in the bottom foreground with Vancouver and Stanley Park in the background.', 16),
('BC', 'North Vancouver', 2002023, '2002_023', 'nvp2002_023_t.jpg', 'nvp2002_023_h.jpg', 'nvp2002_023.pdf', '5.3 Mb', 'Y', 'The Lions & Howe Sound, North Vancouver, British Columbia', '28 February 2002', 'View to the northwest toward Gibsons and Howe Sound featuring the Lions Mountains to the north of North Vancouver.', 17),
('BC', 'Coquitlam', 2001102, '2001_102', 'cqp2001_102_t.jpg', 'cqp2001_102_h.jpg', 'cqp2001_102.pdf', '6.1 Mb', 'Y', 'Coquitlam Centre & Westwood Plateau, Coquitlam, British Columbia, Canada - 25 July 2001', '25 July 2001', 'View northward of Coquitlam Centre with Heritage Mountain and the Westwood Plateau in the background. ', 18),
('BC', 'Maple Ridge', 1910001, '1910_001', 'mrp1910_001_t.jpg', 'mrp1910_001_h.jpg', 'mrp1910_001.pdf', '2.7 MB', 'Y', 'Canadian Pacific Railway''s Port Haney Station, Maple Ridge, British Columbia, Canada - 1910', '1910', 'The Canadian Pacific Railway''s Port Haney Station with its award winning rose garden. Note the 30,000 acres of the best available land in British Columbia promoted by the Secretary of the Haney Progressive Association - 3 boats daily - 6 trains daily.\r\nWilliam Van Photo', 19),
('BC', 'Mission', 2002013, '2002_013', 'mip2002_013_t.jpg', 'mip2002_013_h.jpg', 'mip2002_013.pdf', '5.6.MB', 'Y', 'The West Ridge Leading to the Summit of Mount Robie Reid, Mission, British Columbia, Canada - 2002', '6 March 2002', 'The West Ridge leading to the Summit of Mount Robie Reid', 20),
('BC', 'Mission', 2002040, '2002_040', 'mip2002_040_t.jpg', 'mip2002_040_h.jpg', 'mip2002_040.pdf', '5.6 Mb', 'Y', 'The North Ridge Leading to the Summit of Mount Judge Howay, Mission, British Columbia, Canada - 2002', '6 March 2002', 'The North Ridge Leading to the Summit of Mount Judge Howay', 21),
('BC', 'Vancouver', 2001092, '2001_092', 'vcp2001_092_t.jpg', 'vcp2001_092_h.jpg', 'vcp2001_092.pdf', '8 Mb', 'Y', 'B. C. Place Stadium & Downtown, Vancouver, British Columbia, Canada - 2001', '11 April 2001', 'View north of B. C. Place Stadium, General Motors Place with Stanley Park''s Brockton Point, Canada Place, and across Burrard Inlet the Lions Mountains.', 22);

-- --------------------------------------------------------

--
-- Table structure for table `provinces`
--

CREATE TABLE IF NOT EXISTS `provinces` (
  `province` char(2) NOT NULL DEFAULT '',
  `description` varchar(100) NOT NULL DEFAULT '',
  `country` varchar(10) DEFAULT NULL,
  `display` char(1) DEFAULT NULL,
  `sequence` int(5) DEFAULT NULL,
  `record_num` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`province`,`description`,`record_num`),
  UNIQUE KEY `record_num` (`record_num`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `provinces`
--

INSERT INTO `provinces` (`province`, `description`, `country`, `display`, `sequence`, `record_num`) VALUES
('AB', 'AB/Alberta', 'Canada', 'Y', 1, 1),
('BC', 'BC/British Columbia', 'Canada', 'Y', 2, 2),
('MB', 'MB/Manitoba', 'Canada', 'Y', 4, 3),
('NB', 'NB/New Brunswick', 'Canada', 'N', 0, 4),
('NF', 'NF/Newfoundland', 'Canada', 'N', 0, 5),
('NS', 'NS/Nova Scotia', 'Canada', 'N', 0, 6),
('ON', 'ON/Ontario', 'Canada', 'Y', 3, 7),
('PE', 'PE/Prince Edward Is.', 'Canada', 'N', 0, 8),
('QC', 'QC/Quebec', 'Canada', 'N', 0, 9),
('WA', 'WA/Washington', 'Canada', 'N', 20, 11),
('00', 'Other Provinces Coming Soon', 'Canada', 'N', 99, 12),
('MN', 'MN/Minnesota', 'USA', 'Y', 45, 15),
('SK', 'SK/Saskatchewan', 'Canada', 'Y', 6, 14),
('QC', 'QC/Quebec', 'Canada', 'Y', 5, 13);

