truncate table `accounting`;
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('1', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '85.00', '2', 'John', 'Doe', '2006-06-29 17:02:00', '9', 'New Cars', 'yes', '506889361', '90', '10', '1', '42');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('2', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '85.00', '2', 'John', 'Doe', '2006-06-29 17:12:34', '9', 'New Cars', 'yes', '506889367', '90', '10', '2', '42');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('3', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '85.00', '2', 'John', 'Doe', '2006-06-29 17:18:30', '9', 'New Cars', 'yes', '506889374', '90', '10', '3', '42');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('4', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '85.00', '2', 'John', 'Doe', '2006-06-29 17:24:46', '9', 'New Cars', 'yes', '506889380', '90', '10', '4', '42');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('5', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '85.00', '2', 'John', 'Doe', '2006-06-29 17:31:26', '9', 'New Cars', 'yes', '506889384', '90', '10', '5', '42');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('6', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '85.00', '2', 'John', 'Doe', '2006-06-29 17:37:22', '8', 'Used Cars', 'yes', '506889387', '90', '10', '6', '42');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('7', 'Free Ad Listing', 'Free ad listing with 4 photo(s) for 90 days!', '0.00', '2', 'John', 'Doe', '2006-06-29 17:43:10', '12', 'Bikes', 'yes', '', '90', '4', '1', '43');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('8', 'Standard Online Feature', '* Highlighted background on search results and browse pages.\r\n* Top of page placement on browse pages.\r\n* Featured randomly on front page', '10.00', '2', 'John', 'Doe', '2006-06-29 17:55:44', '9', 'New Cars', 'yes', '506889424', '0', '0', '0', '0');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('9', 'Standard Online Feature', '* Highlighted background on search results and browse pages.\r\n* Top of page placement on browse pages.\r\n* Featured randomly on front page', '0.00', '2', 'John', 'Doe', '2006-06-29 17:57:43', '9', 'New Cars', 'yes', '', '0', '0', '0', '0');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('10', 'Standard Online Feature', '* Highlighted background on search results and browse pages.\r\n* Top of page placement on browse pages.\r\n* Featured randomly on front page', '0.00', '2', 'John', 'Doe', '2006-06-29 17:58:12', '9', 'New Cars', 'yes', '', '0', '0', '0', '0');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('11', 'Standard Online Feature', '* Highlighted background on search results and browse pages.\r\n* Top of page placement on browse pages.\r\n* Featured randomly on front page', '0.00', '2', 'John', 'Doe', '2006-06-29 17:58:39', '12', 'Bikes', 'yes', '', '0', '0', '0', '0');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('12', 'Free Ad Listing', 'Free ad listing with 4 photo(s) for 90 days!', '0.00', '2', 'John', 'Doe', '2006-06-29 17:59:03', '12', 'Bikes', 'yes', '', '90', '4', '2', '43');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('13', 'Free Ad Listing', 'Free ad listing with 4 photo(s) for 90 days!', '0.00', '2', 'John', 'Doe', '2006-06-29 18:01:08', '23', 'Movies & DVD', 'yes', '', '90', '4', '3', '43');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('14', 'Free Ad Listing', 'Free ad listing with 4 photo(s) for 90 days!', '0.00', '2', 'John', 'Doe', '2006-06-29 18:03:49', '23', 'Movies & DVD', 'yes', '', '90', '4', '4', '43');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('15', 'Standard Online Feature', '* Highlighted background on search results and browse pages.\r\n* Top of page placement on browse pages.\r\n* Featured randomly on front page', '0.00', '2', 'John', 'Doe', '2006-06-29 18:10:18', '23', 'Movies & DVD', 'yes', '', '0', '0', '0', '0');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('16', 'Free Ad Listing', 'Free ad listing with 4 photo(s) for 90 days!', '0.00', '2', 'John', 'Doe', '2006-06-29 18:11:35', '16', 'Computers', 'yes', '', '90', '4', '5', '43');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('17', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '85.00', '2', 'John', 'Doe', '2006-06-29 18:19:34', '31', 'Homes for Sale', 'yes', '506889464', '90', '10', '1', '44');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('18', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '85.00', '2', 'John', 'Doe', '2006-06-29 18:29:29', '31', 'Homes for Sale', 'yes', '506889468', '90', '10', '2', '44');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('19', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '85.00', '2', 'John', 'Doe', '2006-06-29 18:36:16', '32', 'Rentals', 'yes', '506889471', '90', '10', '1', '45');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('20', 'Free Ad Listing', 'Free ad listing with 4 photo(s) for 90 days!', '0.00', '2', 'John', 'Doe', '2006-06-29 18:41:02', '3', 'Jobs', 'yes', '', '90', '4', '1', '46');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('21', 'Standard Online Feature', '* Highlighted background on search results and browse pages.\r\n* Top of page placement on browse pages.\r\n* Featured randomly on front page', '0.00', '2', 'John', 'Doe', '2006-06-29 18:45:32', '31', 'Homes for Sale', 'yes', '', '0', '0', '0', '0');
INSERT INTO `accounting` (`ID`, `Title`, `Description`, `Amount`, `MemberID`, `FName`, `LName`, `PostDate`, `CategoryID`, `CategoryDescription`, `Used`, `TransactionID`, `Days`, `Photos`, `ListingID`, `TypeID`) VALUES ('22', 'Standard Online Feature', '* Highlighted background on search results and browse pages.\r\n* Top of page placement on browse pages.\r\n* Featured randomly on front page', '0.00', '2', 'John', 'Doe', '2006-06-29 18:45:58', '32', 'Rentals', 'yes', '', '0', '0', '0', '0');
truncate table `admin`;
INSERT INTO `admin` (`ID`, `Username`, `Password`, `GoogleMapKey`, `ShowNumAds`, `ShowGTZero`, `Email`, `PageTitle`, `MetaDescription`, `MetaKeywords`, `Banner`, `FreeMode`, `Domain`, `NumAds`, `DefaultCountry`, `DistanceType`, `YahooWeatherRSS`, `SSL`, `DefaultGateway`) VALUES ('1', 'admin', 'admin', '', 'yes', 'yes', 'example@example.com', 'PHP Classifieds Script', 'PHP Classifieds Script -- PHP Classiefieds', 'PHP Classifieds Script -- PHP Classiefieds', 'banner.jpg', 'no', 'http://www.yourdomain.com', '5', 'USA', 'Miles', 'http://xml.weather.yahoo.com/forecastrss?p=USNY0996&u=f', 'no', '1');
truncate table `advertisers`;
INSERT INTO `advertisers` (`ID`, `Name`, `Company`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Email`, `Phone`, `Notes`) VALUES ('2', 'John Doe', 'Example Co.', '123 Someplace Drive', 'New York City', 'NY', '12345', 'example@example.com', '888 111 2222', 'Customer is paid for next 3 terms.');
INSERT INTO `advertisers` (`ID`, `Name`, `Company`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Email`, `Phone`, `Notes`) VALUES ('3', 'Jane Doe', 'Foobar Co.', '2344 Another Place', 'New York City', 'NY', '12345', 'jane@example.com', '898 333 4567', 'Customer is past due on account. Called on 06/07/06 no answer.');
truncate table `advertisments`;
INSERT INTO `advertisments` (`ID`, `AdvertiserID`, `Hits`, `Photo`, `URL`, `Text`, `Title`) VALUES ('6', '2', '1', 'kkxwiaqcqvvh.jpg', 'http://staples.com', 'Test Ad.', 'Staples.com');
INSERT INTO `advertisments` (`ID`, `AdvertiserID`, `Hits`, `Photo`, `URL`, `Text`, `Title`) VALUES ('4', '3', '1', 'ghlecluvrsqb.jpg', 'http://bestbuy.com', 'Summer Sale!', 'Best Buy');
truncate table `banned`;
truncate table `categories`;
INSERT INTO `categories` (`ID`, `Title`, `FatherID`, `Locked`, `TypeID`, `PageTitle`, `MetaKeywords`, `MetaDescription`, `PaymentPackages`, `PageHeader`, `PageFooter`) VALUES ('1', 'For Sale', '0', 'no', '42', 'For Sale', 'For Sale', 'For Sale', '', '', '');
INSERT INTO `categories` (`ID`, `Title`, `FatherID`, `Locked`, `TypeID`, `PageTitle`, `MetaKeywords`, `MetaDescription`, `PaymentPackages`, `PageHeader`, `PageFooter`) VALUES ('2', 'Autos', '0', 'no', '42', 'Autos', 'Autos', 'Autos', '', 'The category Page Header can be editited in the admin panel > categories. You can create professional looking HTML using the WYSIWYG H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.H T M L Editor.You are here: Home » About Us
\r\nAbout Us \r\nThe page can be editited in the admin panel using a WYSIWYG EDITOR . Add and edit professional H T M L pages with out any knowlage of HTML!
\r\nYour Companey Name Here
\r\n124564 Address Road
');
INSERT INTO `documents` (`ID`, `Name`, `Code`) VALUES ('2', 'Why Join?', 'You are here: Home » Why Join \r\nWhy Join? \r\nJoin today and you can:
\r\n\r\n Save Ads \r\n Add your persional ad to site. \r\n This page can be edited from the admin panel editor ! \r\n \r\nSign Up | Sign In
');
truncate table `featurepackage`;
INSERT INTO `featurepackage` (`ID`, `Title`, `Description`, `Price`, `Highlight`, `HighlightColor`, `MaxFeatured`) VALUES ('1', 'Standard Online Feature', '* Highlighted background on search results and browse pages.\r\n* Top of page placement on browse pages.\r\n* Featured randomly on front page', '19.99', 'yes', '#FFFFCC', '20');
truncate table `gateways`;
INSERT INTO `gateways` (`ID`, `Title`, `Description`, `Code`, `Form`) VALUES ('1', 'Authorize.NET AIM (Advanced Intagration)', 'PHPAUTHNET AIM gives you the ability to easily process transactions through the authorize.net gateway. Using the best of web security, AIM does more to eliminate unauthorized transactions and optimize transaction security than any other connection method.', '## ENTER YOUR AUTH.NET INFO ##\r\n$auth_net_login_id = "cnpdev3969";\r\n$auth_net_tran_key = "QxSxSS2H9Df2zUTn";\r\n## DO NOT MODIFY BELOW ##\r\n$auth_net_test_mode = true;\r\n$process_page = "gateways/authorize_net.php";\r\n', '\r\n\r\n \r\n\r\n \r\n \r\n\r\nCard Number \r\n\r\nExpiration Date ');
INSERT INTO `gateways` VALUES (2, 'PayPal', 'PayPal is an account-based system that lets anyone with an email address securely send and receive online payments using their credit card or bank account. It is the most popular way to electronically pay for eBay auctions and it is becoming a cheap way for merchants to accept credit cards on their on-line storefronts instead of using a traditional payment gateway.', '## ENTER YOUR PayPal INFO ##\r\n$paypal_email = "sandbox@phpclassifieds.com";\r\n$currency_code = "USD";\r\n$sandbox = false;\r\n## DO NOT MODIFY BELOW ##\r\n$process_page = "gateways/paypal.php";\r\n', '\r\n \r\n \r\n\r\n ');
truncate table `log`;
truncate table `members`;
INSERT INTO `members` (`ID`, `FName`, `LName`, `Email`, `Password`, `LastLogin`, `Phone`) VALUES ('2', 'John', 'Doe', 'admin@admin.com', 'admin', '2006-07-12 00:10:00', '888-111-12-1322');
truncate table `packages`;
INSERT INTO `packages` (`ID`, `Title`, `Description`, `Days`, `Price`, `Photos`) VALUES ('1', 'Total Online Basic Coverage', '', '14', '4.95', '1');
INSERT INTO `packages` (`ID`, `Title`, `Description`, `Days`, `Price`, `Photos`) VALUES ('2', 'Total Online Delux Coverage', 'List your ad for 90 days with up to 10 photos!', '90', '85.00', '10');
INSERT INTO `packages` (`ID`, `Title`, `Description`, `Days`, `Price`, `Photos`) VALUES ('3', 'Total Online Coverage Premier', 'List your ad for 21 days with up to 6 photos!', '21', '9.99', '6');
INSERT INTO `packages` (`ID`, `Title`, `Description`, `Days`, `Price`, `Photos`) VALUES ('4', 'Free Ad Listing', 'Free ad listing with 4 photo(s) for 90 days!', '90', '0.00', '4');
truncate table `phonecarier`;
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('1', '3 River Wireless', 'phonenumber@sms.3rivers.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('3', 'ACS Wireless', 'phonenumber@paging.acswireless.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('5', 'Advantage Communications', '10digitpagernumber@advantagepaging.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('7', 'Airtouch Pagers', '10digitpagernumber@myairmail.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('9', 'Airtouch Pagers', '10digitpagernumber@alphapage.airtouch.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('11', 'Airtouch Pagers', '10digitpagernumber@airtouch.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('13', 'Airtouch Pagers', '10digitpagernumber@airtouchpaging.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('15', 'AlphNow', 'pin@alphanow.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('17', 'Alltel', '10digitphonenumber@alltelmessage.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('19', 'Alltel PCS', '10digitphonenumber@message.alltel.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('21', 'Ameritech Paging (see also American Messaging)', '10digitpagernumber@paging.acswireless.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('23', 'Ameritech Paging (see also American Messaging)', '10digitpagernumber@pageapi.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('25', 'American Messaging (SBC/Ameritech)', '10digitpagernumber@page.americanmessaging.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('27', 'Ameritech Clearpath', '10digitpagernumber@clearpath.acswireless.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('29', 'Andhra Pradesh Airtel', 'phonenumber@airtelap.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('31', 'Arch Pagers (PageNet)', '10digitpagernumber@archwireless.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('33', 'Arch Pagers (PageNet)', '10digitpagernumber@epage.arch.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('35', 'Arch Pagers (PageNet)', '10digitpagernumber@archwireless.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('37', 'AT&T Free2Go', '10digitphonenumber@mmode.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('39', 'AT&T PCS', '10digitphonenumber@mobile.att.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('41', 'AT&T Pocketnet PCS', '10digitphonenumber@dpcs.mobile.att.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('43', 'Beepwear', 'pagernumber@beepwear.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('45', 'BeeLine GSM', 'phonenumber@sms.beemail.ru');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('47', 'Bell Atlantic', 'phonenumber@message.bam.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('49', 'Bell Canada', 'phonenumber@txt.bellmobility.ca');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('51', 'Bell Canada', 'phonenumber@bellmobility.ca');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('53', 'Bell Mobility (Canada)', 'phonenumber@txt.bell.ca');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('55', 'Bell Mobility', 'number@txt.bellmobility.ca');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('57', 'Bell South (Blackberry)', 'number@bellsouthtips.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('59', 'Bell South', 'phonenumber@sms.bellsouth.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('61', 'Bell South', 'phonenumber@wireless.bellsouth.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('63', 'Bell South', 'phonenumber@blsdcs.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('65', 'Bell South', 'phonenumber@bellsouth.cl');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('67', 'Bell South Mobility', 'phonenumber@blsdcs.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('69', 'Blue Sky Frog', 'phonenumber@blueskyfrog.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('71', 'Bluegrass Cellular', 'phonenumber@sms.bluecell.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('73', 'Boost', 'phonenumber@myboostmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('75', 'BPL mobile', 'phonenumber@bplmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('77', 'Carolina West Wireless', '10digitnumber@cwwsms.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('79', 'Carolina Mobile Communications', '10digitpagernumber@cmcpaging.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('81', 'Cellular One East Coast', 'phonenumber@phone.cellone.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('83', 'Cellular One South West', 'phonenumber@swmsg.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('85', 'Cellular One PCS', 'phonenumber@paging.cellone-sf.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('87', 'Cellular One', '10digitphonenumber@mobile.celloneusa.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('89', 'Cellular One', 'phonenumber@cellularone.txtmsg.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('91', 'Cellular One', 'phonenumber@cellularone.textmsg.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('93', 'Cellular One', 'phonenumber@cell1.textmsg.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('95', 'Cellular One', 'phonenumber@message.cellone-sf.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('97', 'Cellular One', 'phonenumber@sbcemail.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('99', 'Cellular One West', 'phonenumber@mycellone.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('101', 'Cellular South', 'phonenumber@csouth1.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('103', 'Centennial Wireless', '10digitnumber@cwemail.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('105', 'Central Vermont Communications', '10digitpagernumber@cvcpaging.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('107', 'CenturyTel', 'phonenumber@messaging.centurytel.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('109', 'Chennai RPG Cellular', 'phonenumber@rpgmail.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('111', 'Chennai Skycell / Airtel', 'phonenumber@airtelchennai.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('113', 'Cincinnati Bell', 'phonenumber@mobile.att.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('115', 'Cingular', 'mobilenumber@page.cingular.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('117', 'Cingular', '10digitphonenumber@cingularme.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('119', 'Cingular Wireless', '10digitphonenumber@mycingular.textmsg.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('121', 'Cingular Wireless', '10digitphonenumber@mobile.mycingular.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('123', 'Cingular Wireless', '10digitphonenumber@mobile.mycingular.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('125', 'Clearnet', 'phonenumber@msg.clearnet.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('127', 'Comcast', 'phonenumber@comcastpcs.textmsg.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('129', 'Communication Specialists', '7digitpin@pageme.comspeco.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('131', 'Communication Specialist Companies', 'pin@pager.comspeco.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('133', 'Comviq', 'number@sms.comviq.se');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('135', 'Cook Paging', '10digitpagernumber@cookmail.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('137', 'Corr Wireless Communications', 'phonenumber@corrwireless.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('139', 'Delhi Aritel', 'phonenumber@airtelmail.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('141', 'Delhi Hutch', 'phonenumber@delhi.hutch.co.in');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('143', 'Digi-Page / Page Kansas', '10digitpagernumber@page.hit.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('145', 'Dobson Cellular Systems', 'phonenumber@mobile.dobson.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('147', 'Dobson-Alex Wireless / Dobson-Cellular One', 'phonenumber@mobile.cellularone.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('149', 'DT T-Mobile', 'phonenumber@t-mobile-sms.de');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('151', 'Dutchtone / Orange-NL', 'phonenumber@sms.orange.nl');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('153', 'Edge Wireless', 'phonenumber@sms.edgewireless.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('155', 'EMT', 'phonenumber@sms.emt.ee');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('157', 'Escotel', 'phonenumber@escotelmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('159', 'Fido', 'phonenumber@fido.ca');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('161', 'Galaxy Corporation', '10digitpagernumber.epage@sendabeep.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('163', 'GCS Paging', 'pagernumber@webpager.us');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('165', 'Goa BPLMobil', 'phonenumber@bplmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('167', 'Golden Telecom', 'phonenumber@sms.goldentele.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('169', 'GrayLink / Porta-Phone', '10digitpagernumber@epage.porta-phone.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('171', 'GTE', 'number@airmessage.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('173', 'GTE', 'number@gte.pagegate.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('175', 'GTE', '10digitphonenumber@messagealert.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('177', 'Gujarat Celforce', 'phonenumber@celforce.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('179', 'Houston Cellular', 'number@text.houstoncellular.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('181', 'Idea Cellular', 'phonenumber@ideacellular.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('183', 'Infopage Systems', 'pinnumber@page.infopagesystems.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('185', 'Inland Cellular Telephone', 'phonenumber@inlandlink.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('187', 'The Indiana Paging Co', 'last4digits@pager.tdspager.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('189', 'JSM Tele-Page', 'pinnumber@jsmtel.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('191', 'Kerala Escotel', 'phonenumber@escotelmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('193', 'Kolkata Airtel', 'phonenumber@airtelkol.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('195', 'Kyivstar', 'number@smsmail.lmt.lv');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('197', 'Lauttamus Communication', 'pagernumber@e-page.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('199', 'LMT', 'phonenumber@smsmail.lmt.lv');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('201', 'Maharashtra BPL Mobile', 'phonenumber@bplmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('203', 'Maharashtra Idea Cellular', 'phonenumber@ideacellular.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('205', 'Manitoba Telecom Systems', 'phonenumber@text.mtsmobility.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('207', 'MCI Phone', 'phonenumber@mci.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('209', 'MCI', 'phonenumber@pagemci.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('211', 'Meteor', 'phonenumber@mymeteor.ie');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('213', 'Meteor', 'phonenumber@sms.mymeteor.ie');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('215', 'Metrocall', '10digitpagernumber@page.metrocall.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('217', 'Metrocall 2-way', '10digitpagernumber@my2way.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('219', 'Metro PCS', '10digitphonenumber@mymetropcs.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('221', 'Metro PCS', '10digitphonenumber@metropcs.sms.us');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('223', 'Microcell', 'phonenumber@fido.ca');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('225', 'Midwest Wireless', 'phonenumber@clearlydigital.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('227', 'MiWorld', 'phonenumber@m1.com.sg');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('229', 'Mobilecom PA', '10digitpagernumber@page.mobilcom.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('231', 'Mobilecomm', 'number@mobilecomm.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('233', 'Mobileone', 'phonenumber@m1.com.sg');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('235', 'Mobilfone', 'phonenumber@page.mobilfone.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('237', 'Mobility Bermuda', 'phonenumber@ml.bm');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('239', 'Mobistar Belgium', 'phonenumber@mobistar.be');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('241', 'Mobitel Tanzania', 'phonenumber@sms.co.tz');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('243', 'Mobtel Srbija', 'phonenumber@mobtel.co.yu');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('245', 'Morris Wireless', '10digitpagernumber@beepone.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('247', 'Motient', 'number@isp.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('249', 'Movistar', 'number@correo.movistar.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('251', 'Mumbai BPL Mobile', 'phonenumber@bplmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('253', 'Mumbai Orange', 'phonenumber@orangemail.co.in');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('255', 'NBTel', 'number@wirefree.informe.ca');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('257', 'Netcom', 'phonenumber@sms.netcom.no');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('259', 'Nextel', '10digitphonenumber@messaging.nextel.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('261', 'Nextel', '10digitphonenumber@page.nextel.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('263', 'Nextel', '10digitphonenumber@nextel.com.br');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('265', 'NPI Wireless', 'phonenumber@npiwireless.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('267', 'Ntelos', 'number@pcs.ntelos.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('269', 'O2', 'name@o2.co.uk');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('271', 'O2', 'number@o2imail.co.uk');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('273', 'O2 (M-mail)', 'number@mmail.co.uk');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('275', 'Omnipoint', 'number@omnipoint.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('277', 'Omnipoint', '10digitphonenumber@omnipointpcs.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('279', 'One Connect Austria', 'phonenumber@onemail.at');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('281', 'OnlineBeep', '10digitphonenumber@onlinebeep.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('283', 'Optus Mobile', 'phonenumber@optusmobile.com.au');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('285', 'Orange', 'phonenumber@orange.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('287', 'Orange Mumbai', 'phonenumber@orangemail.co.in');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('289', 'Orange - NL / Dutchtone', 'phonenumber@sms.orange.nl');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('291', 'Oskar', 'phonenumber@mujoskar.cz');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('293', 'P&T Luxembourg', 'phonenumber@sms.luxgsm.lu');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('295', 'Pacific Bell', 'phonenumber@pacbellpcs.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('297', 'PageMart', '7digitpinnumber@pagemart.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('299', 'PageMart Advanced /2way', '10digitpagernumber@airmessage.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('301', 'PageMart Canada', '10digitpagernumber@pmcl.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('303', 'PageNet Canada', 'phonenumber@pagegate.pagenet.ca');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('305', 'PageOne NorthWest', '10digitnumber@page1nw.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('307', 'PCS One', 'phonenumber@pcsone.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('309', 'Personal Communication', 'sms@pcom.ru (number in subject line)');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('311', 'Pioneer / Enid Cellular', 'phonenumber@msg.pioneerenidcellular.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('313', 'PlusGSM', 'phonenumber@text.plusgsm.pl');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('315', 'Pondicherry BPL Mobile', 'phonenumber@bplmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('317', 'Powertel', 'phonenumber@voicestream.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('319', 'Price Communications', 'phonenumber@mobilecell1se.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('321', 'Primeco', '10digitnumber@email.uscc.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('323', 'Primtel', 'phonenumber@sms.primtel.ru');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('325', 'ProPage', '7digitpagernumber@page.propage.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('327', 'Public Service Cellular', 'phonenumber@sms.pscel.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('329', 'Qualcomm', 'name@pager.qualcomm.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('331', 'Qwest', '10digitphonenumber@qwestmp.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('333', 'RAM Page', 'number@ram-page.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('335', 'Rogers AT&T Wireless', 'phonenumber@pcs.rogers.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('337', 'Rogers Canada', '10digitphonenumber@pcs.rogers.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('339', 'Safaricom', 'phonenumber@safaricomsms.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('341', 'Satelindo GSM', 'phonenumber@satelindogsm.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('343', 'Satellink', '10digitpagernumber.pageme@satellink.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('345', 'SBC Ameritech Paging (see also American Messaging)', '10digitpagernumber@paging.acswireless.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('347', 'SCS-900', 'phonenumber@scs-900.ru');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('349', 'SFR France', 'phonenumber@sfr.fr');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('351', 'Skytel Pagers', '7digitpinnumber@skytel.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('353', 'Skytel Pagers', 'number@email.skytel.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('355', 'Simple Freedom', 'phonenumber@text.simplefreedom.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('357', 'Smart Telecom', 'phonenumber@mysmart.mymobile.ph');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('359', 'Southern LINC', '10digitphonenumber@page.southernlinc.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('361', 'Southwestern Bell', 'number@email.swbw.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('363', 'Sprint', '10digitphonenumber@sprintpaging.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('365', 'Sprint PCS', '10digitphonenumber@messaging.sprintpcs.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('367', 'ST Paging', 'pin@page.stpaging.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('369', 'SunCom', 'number@tms.suncom.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('371', 'SunCom', 'number@suncom1.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('373', 'Sunrise Mobile', 'phonenumber@mysunrise.ch');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('375', 'Sunrise Mobile', 'phonenumber@freesurf.ch');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('377', 'Surewest Communicaitons', 'phonenumber@mobile.surewest.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('379', 'Swisscom', 'phonenumber@bluewin.ch');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('381', 'T-Mobile', '10digitphonenumber@tmomail.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('383', 'T-Mobile', '10digitphonenumber@voicestream.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('385', 'T-Mobile Austria', 'phonenumber@sms.t-mobile.at');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('387', 'T-Mobile Germany', 'phonenumber@t-d1-sms.de');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('389', 'T-Mobile UK', 'phonenumber@t-mobile.uk.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('391', 'Tamil Nadu BPL Mobile', 'phonenumber@bplmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('393', 'Tele2 Latvia', 'phonenumber@sms.tele2.lv');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('395', 'Telefonica Movistar', 'phonenumber@movistar.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('397', 'Telenor', 'phonenumber@mobilpost.no');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('399', 'Teletouch', '10digitpagernumber@pageme.teletouch.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('401', 'Telia Denmark', 'phonenumber@gsm1800.telia.dk');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('403', 'Telus', 'phonenumber@msg.telus.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('405', 'TIM', '10digitphonenumber@timnet.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('407', 'Triton', 'phonenumber@tms.suncom.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('409', 'TSR Wireless', 'pagernumber@alphame.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('411', 'TSR Wireless', 'pagernumber@beep.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('413', 'UMC', 'phonenumber@sms.umc.com.ua');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('415', 'Unicel', 'phonenumber@utext.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('417', 'Uraltel', 'phonenumber@sms.uraltel.ru');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('419', 'US Cellular', '10digitphonenumber@email.uscc.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('421', 'US Cellular', '10digitphonenumber@uscc.textmsg.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('423', 'US West', 'number@uswestdatamail.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('425', 'Uttar Pradesh Escotel', 'phonenumber@escotelmobile.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('427', 'Verizon Pagers', '10digitpagernumber@myairmail.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('429', 'Verizon PCS', '10digitphonenumber@vtext.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('431', 'Verizon PCS', '10digitphonenumber@myvzw.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('433', 'Vessotel', 'phonenumber@pager.irkutsk.ru');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('435', 'Virgin Mobile', 'phonenumber@vmobl.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('437', 'Virgin Mobile', 'phonenumber@vxtras.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('439', 'Vodafone Italy', 'number@sms.vodafone.it');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('441', 'Vodafone Japan', 'phonenumber@c.vodafone.ne.jp');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('443', 'Vodafone Japan', 'phonenumber@h.vodafone.ne.jp');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('445', 'Vodafone Japan', 'phonenumber@t.vodafone.ne.jp');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('447', 'Vodafone UK', 'phonenumber@vodafone.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('449', 'VoiceStream / T-Mobile', '10digitphonenumber@voicestream.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('451', 'WebLink Wiereless', 'pagernumber@airmessage.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('453', 'WebLink Wiereless', 'pagernumber@pagemart.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('455', 'West Central Wireless', 'phonenumber@sms.wcc.net');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('457', 'Western Wireless', 'phonenumber@cellularonewest.com');
INSERT INTO `phonecarier` (`ID`, `Name`, `Email`) VALUES ('459', 'Wyndtell', 'number@wyndtell.com');
truncate table `photos`;
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('21', '12', '1', 'jsnlynfcvkwj.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('22', '12', '1', 'njjjmwxgfapl.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('23', '12', '1', 'xsuaanxknpeq.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('24', '12', '1', 'eejadyhegesa.jpg', '4');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('25', '12', '2', 'pcictzipiqvx.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('26', '12', '2', 'crxnfrantyie.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('27', '12', '2', 'yfavgcvxwzze.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('28', '12', '2', 'rguhbkmwqoxb.jpg', '4');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('29', '35', '1', 'vzkbnvmjtent.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('30', '35', '1', 'czpgentnfzpt.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('31', '35', '1', 'cimiwfgwsrbt.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('32', '37', '1', 'hzcenifkwcbu.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('36', '42', '1', 'mbgvenqgnhvz.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('37', '42', '1', 'tyswttqczqwc.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('38', '42', '1', 'jykpykciuwsx.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('39', '42', '1', 'nkcelpnbapre.jpg', '4');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('40', '42', '1', 'dwpvogugvhit.jpg', '5');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('41', '42', '1', 'hmbqrnfaaykt.jpg', '6');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('42', '42', '2', 'zvtxzvnpenwq.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('43', '42', '2', 'ptslyzqfosyw.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('44', '42', '2', 'mjhcuxfvijby.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('45', '42', '2', 'qlptjsftfdko.jpg', '4');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('46', '42', '2', 'ogboggpetlum.jpg', '5');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('47', '42', '2', 'qrsabredtjwj.jpg', '6');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('48', '42', '3', 'qdwphkvrsduy.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('49', '42', '3', 'xahcuymfajrd.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('50', '42', '3', 'vdhzgatwhxko.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('51', '42', '4', 'emabathvsndo.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('52', '42', '4', 'uokstbmqalue.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('53', '42', '4', 'hlwicgmwpbmp.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('54', '42', '4', 'glybnlhfzspc.jpg', '4');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('55', '42', '4', 'vuanjwkgbppy.jpg', '5');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('56', '42', '4', 'luewtiaenanu.jpg', '6');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('57', '42', '4', 'oofbmwdvbocb.jpg', '7');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('58', '42', '4', 'pnqzsfdlgxtl.jpg', '8');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('59', '42', '5', 'jjrnqjdclvmi.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('60', '42', '5', 'uysqplujydnl.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('61', '42', '5', 'qldfonfrdsmy.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('62', '42', '6', 'gttxmgxybsaa.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('63', '42', '6', 'kyligzywnlbz.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('64', '42', '6', 'aytcxxvabdpu.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('65', '42', '6', 'ttdyxgrwvflh.jpg', '4');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('66', '42', '6', 'izzkgycpktuu.jpg', '5');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('67', '43', '1', 'tymicnhtfcff.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('68', '43', '2', 'cpkverordqyi.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('69', '43', '3', 'wvdwyymeosbn.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('70', '43', '4', 'dabjtompslsq.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('71', '43', '5', 'objoqvsajgbn.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('72', '44', '1', 'zeddufrhlgqz.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('73', '44', '1', 'couqkrwzsjqz.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('74', '44', '1', 'cmpaijxfsyss.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('75', '44', '1', 'qhvreetrpbyp.jpg', '4');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('77', '44', '2', 'lzqsmjcdqite.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('78', '44', '2', 'nazcfxbdfppf.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('80', '44', '2', 'fzfocteibnru.jpg', '3');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('81', '44', '2', 'uwgupgjlkfeo.jpg', '4');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('82', '44', '2', 'rudvuncgrjte.jpg', '5');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('83', '45', '1', 'fkjhvxexjmzo.jpg', '1');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('84', '45', '1', 'epexgohzdiah.jpg', '2');
INSERT INTO `photos` (`ID`, `TypeID`, `ListingID`, `Location`, `POrder`) VALUES ('85', '45', '1', 'caeeqmtjfeok.jpg', '3');
truncate table `savedlistings`;
truncate table `tt_42`;
INSERT INTO `tt_42` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Year`, `Make`, `Body Style`, `Price ($)`, `Mileage`, `Condition`, `Exterior Color`, `Interior Color`, `Transmission`, `Doors`, `Engine Cylinders`, `Drive Train`, `VIN`, `Features`) VALUES ('1', '2006 Honda Civic Hybrid 4dr Sedan Base', '25', '2006-06-29', 'The Honda Civic Hybrid is a hybrid version of the Honda Civic sedan.\r\n\r\nFor the 2003 model of the Civic, Honda added a continuously variable transmission and a Integrated Motor Assist hybrid system similar to that of the Insight, creating a fuel efficient hybrid sedan. It is an assist hybrid.\r\n\r\nIt was redesigned in 2006 and based off the new Civic platform. Before the 2006 model year, the electric motor was not able to drive the car itself but provided useful assistance to the gasoline engine during heavy load situations like accelerating. Starting in 2006, however, the electric motor is able to maintain the car at a low speed cruise (20-30 mph) without power from the gasoline engine. (Copied From Wikipedia, the free encyclopedia)', '9', 'yes', '2', '2010-09-27', '40.764121', '-73.996026', '645 11th Ave', 'New York', 'NY', '10036', 'USA', '2006', 'Honda', 'Sedan', '22150', '0', 'Excellent', 'Black', 'Beige', 'Automatic', '4', '10', 'Other', 'N/A', 'Alarm,Alloy Wheels,Anti-Lock Brakes,Bucket Seats,CD Changer,CD Player,Cruise Control,Driver Airbag,DVD,Leather Interior,Memory Seats,Navigation System,Passenger Airbag,Power Locks,Power Seats,Power Steering,Power Windows');
INSERT INTO `tt_42` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Year`, `Make`, `Body Style`, `Price ($)`, `Mileage`, `Condition`, `Exterior Color`, `Interior Color`, `Transmission`, `Doors`, `Engine Cylinders`, `Drive Train`, `VIN`, `Features`) VALUES ('2', '2006 Honda Accord 4dr Sedan 2.4 SE', '8', '2006-06-29', 'The Honda Accord is an automob2006 Honda Accord 4dr Sedan ile manufactured by Honda. The Accord was introduced in 1976 as a mid-sized hatchback, with styling similar to an upsized contemporary Honda Civic. A conventional four-door sedan was debuted in 1977. (Copied From: From Wikipedia, the free encyclopedia)', '9', 'yes', '2', '2010-09-27', '40.764121', '-73.996026', '645 11th Ave', 'New York', 'NY', '10036', 'USA', '2006', 'Honda', 'Sedan', '18884', '0', 'Excellent', 'Silver', 'Beige', 'Automatic', '4', '4', '2WD', 'N/A', 'Alarm,Alloy Wheels,Anti-Lock Brakes,Bucket Seats,Cassette Radio,CD Changer,CD Player,Cruise Control,Driver Airbag,DVD,Fog Lights,Front A/C,Leather Interior,Memory Seats,Navigation System,Passenger Airbag,Power Locks');
INSERT INTO `tt_42` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Year`, `Make`, `Body Style`, `Price ($)`, `Mileage`, `Condition`, `Exterior Color`, `Interior Color`, `Transmission`, `Doors`, `Engine Cylinders`, `Drive Train`, `VIN`, `Features`) VALUES ('3', '2006 Aston Martin V8 Vantage 2dr Coupe Base', '3', '2006-06-29', 'The modern Aston Martin V8 Vantage is a compact sports car. Aston Martin previously used the "Vantage" name on its highest-performance vehicles, and notably used the "V8 Vantage" name on their supercar of the 1970s and 1980s. The modern car, in contrast, is the lowest line in Aston\'s 3-model lineup, and is intended as an affordable volume model to compete with the Porsche 911.\r\n\r\nThe V8 Vantage was first seen at the Geneva Motor Show in 2005. The two seat, two door coupe has a bonded aluminium structure for strength and lightness. The 4.38 m (14.4 ft)-long coupe has a hatchback-style tailgate for practicality, with a large luggage shelf behind the seats. Note that Aston Martin invented the hatchback body style with the 1953 DB2/4.\r\n\r\nThe V8 Vantage is powered by a 4.3 L (4280 cc) quad-cam 32-valve V8 which produces 380 hp (283 kW) at 7000 rpm and 302 ft·lbf (409 N·m) at 5000 rpm. This engine is unique to Aston Martin and features race-style dry-sump lubrication, which enables it to be mounted low to lower the centre of gravity. The engine, based on the Jaguar AJ-V8 engine, is assembled by hand at the AM facility in Cologne, Germany, which also builds the V12 for the DB9 and Vanquish. The cylinder block, cylinder heads, crankshaft, connecting rods, pistons, camshafts, inlet and exhaust manifolds, lubrication system and engine management are all unique to the Aston Martin version.\r\n\r\nThe V8 Vantage can accelerate to 60 mph (97 km/h) in 4.9 seconds. The V8 Vantage is able to keep up with its more powerful relative, the Aston Martin DB9, because of its lighter weight. The engine is front mid-mounted with a rear-mounted transaxle, giving a 49:51 front:rear weight distribution.\r\n\r\nThere will also be a V8 Volante in early 2007. (Copied From: From Wikipedia, the free encyclopedia)', '9', 'no', '2', '2010-09-27', '40.764121', '-73.996026', ' 645 11th Ave', 'New York', 'NY', '10036', 'USA', '2006', 'Aston Martin', 'Other', '111350', '0', 'Excellent', 'Burgundy', 'Beige', 'Automanual', '2', '8', '2WD', 'N/A', 'Alarm,Alloy Wheels,Anti-Lock Brakes,Bucket Seats,Cassette Radio,CD Changer,CD Player,Cruise Control,Driver Airbag,DVD,Fog Lights,Front A/C,Leather Interior,Memory Seats,Navigation System,Passenger Airbag,Power Locks,Power Sea');
INSERT INTO `tt_42` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Year`, `Make`, `Body Style`, `Price ($)`, `Mileage`, `Condition`, `Exterior Color`, `Interior Color`, `Transmission`, `Doors`, `Engine Cylinders`, `Drive Train`, `VIN`, `Features`) VALUES ('4', '2006 BMW 325 2dr Rear-wheel Drive Coupe Ci', '4', '2006-06-29', 'The 2006 BMW 3 Series sets a new benchmark for how all other sport sedans will be judged. For four generations, the 3 Series has set the standard for pure driving performance in its class. The time has come for drivers to enjoy more. Come and experience the 2006 BMW 3 Series. (Copied From: bmsusa.com )', '9', 'no', '2', '2010-09-27', '40.770409', '-73.991681', '622 W 57th St', 'New York', 'NY', '10019', 'USA', '2006', 'BMW', 'Coupe', '32158', '0', 'Excellent', 'Silver', 'Beige', 'Manual', '2', '6', '4WD', 'N/A', 'Alarm,Alloy Wheels,Anti-Lock Brakes,Bucket Seats,Cassette Radio,CD Changer,CD Player,Cruise Control,Driver Airbag,DVD,Fog Lights,Front A/C,Leather Interior,Memory Seats,Navigation System,Passenger Airbag,Power Locks,Power Sea');
INSERT INTO `tt_42` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Year`, `Make`, `Body Style`, `Price ($)`, `Mileage`, `Condition`, `Exterior Color`, `Interior Color`, `Transmission`, `Doors`, `Engine Cylinders`, `Drive Train`, `VIN`, `Features`) VALUES ('5', '2006 BMW M 2dr Roadster Base', '7', '2006-06-29', ' The new BMW M Roadster - the high-performance two seater is reborn\r\n\r\nBMW has announced details of the latest M car – the new BMW Z4 M Roadster. Three-years after the Z4’s launch as the most performance-focussed roadster on the market, BMW M have turned their attentions to the Z4, creating BMW’s fastest accelerating open-top. With 343hp equating to 106hp per litre, zero to 62mph acceleration of 5.0 seconds and an electronically limited top speed of 155mph, the new M Roadster is set to re-write the rulebook for performance, agility and dynamism. (Copied From: tuningnews.net )', '9', 'yes', '2', '2010-09-27', '40.770409', '-73.991681', '622 W 57th St', 'New York', 'NY', '10019', 'USA', '2006', 'BMW', 'Coupe', '35999', '0', 'Excellent', 'Burgundy', 'Beige', 'Manual', '2', '6', '2WD', 'N/A', 'Alarm,Alloy Wheels,Anti-Lock Brakes,Bucket Seats,Cassette Radio,CD Changer,CD Player,Cruise Control,Driver Airbag,DVD,Fog Lights,Front A/C,Leather Interior,Memory Seats,Navigation System,Passenger Airbag,Power Locks,Power Sea');
INSERT INTO `tt_42` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Year`, `Make`, `Body Style`, `Price ($)`, `Mileage`, `Condition`, `Exterior Color`, `Interior Color`, `Transmission`, `Doors`, `Engine Cylinders`, `Drive Train`, `VIN`, `Features`) VALUES ('6', 'Hyundai SONATA GL', '3', '2006-06-29', 'It might surprise you to know that Hyundai is the fourth best-selling import in North America behind Honda, Toyota and Nissan. It got there by steadily improving its products and delivering great value. The all-new Sonata sedan continues Hyundai’s mission with three trim levels priced from $17,895 to $22,895. You’d be hard pressed to find a sedan in this segment that offers more standard features and includes a 10-year/100,000-mile limited powertrain warranty and 5-yr/60,000-mi basic coverage. (Copied From: About.com )', '8', 'no', '2', '2010-09-27', '40.734877', '-74.007748', '137 Perry St', 'New York', 'NY', '10014', 'USA', '2005', 'Hyundai', 'Sedan', '16000', '22900', 'Excellent', 'Blue', 'Beige', 'Automanual', '2', '4', '2WD', 'N/A', 'Alarm,Bucket Seats,Cassette Radio,CD Player,Cruise Control,Driver Airbag,DVD,Power Seats,Power Steering,Power Windows,Rear Window Defroster,Site Airbag,Third Row Seats,Tinted Glass');
truncate table `tt_43`;
INSERT INTO `tt_43` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Price ($)`, `Website URL`) VALUES ('1', 'GT Avalanche 3.0 Disc 2005', '9', '2006-06-29', '* Frame: GT Triple Triangle design 6061 aluminum with pressure formed downtube, zero stack headtube, Disc compatible with removeable der. Hanger\r\n* Fork: SR Suntour XC-60 one piece aluminum lowers with disc mount and preload adjustment\r\n* Crankset: Suntour XCC-252, 42-32-22\r\n* Bottom Bracket: Cartridge Sealed\r\n* Pedals: High Impact nylon platform\r\n* Front Derailleur: Suntour XC-202\r\n* Rear Derailleur: Shimano Acera\r\n* Shifters: Shimano ST-EF29\r\n* Rear Cogs: Shimano Eight Speed, 11-32 ratio\r\n* Rims: Alloy Double Wall ATB\r\n* Tires: Tioga Factory Extreme Front and Factory XC rear 26 x 1.95\r\n* Front Hub: Alloy QR for Disc\r\n* Rear Hub: Alloy 8 speed Cassette with QR for Disc\r\n* Spokes: Stainless steel, 14 gauge\r\n* Nipples: Brass CP\r\n* Front Brake: Tektro IO, cable actuated disc brake\r\n* Rear Brake: Tektro IO, cable actuated disc brake\r\n* Brake Levers: Shimano ST-EF29\r\n* Handlebar: 20 mm Rise, 6-degree bend, anatomically sized\r\n* Stem: GT ATB, threadless 25 degree rise with two bolt alum face plate\r\n* Grips: GT Lock-down\r\n* Headset: TH Zero Stack system for 1 1/8"\r\n* Saddle: WTB Speed V\r\n* Seat Post: Alloy Micro adjust\r\n* Seat Clamp: GT Forged Alum QR\r\n* Color(s): 1.Bright Silver, 2.Black\r\n* Size(s): S, M, L, XL\r\n(Copied From: gallery.bcentral.com)', '12', 'yes', '2', '2010-09-27', '40.734877', '-74.007748', '137 Perry St', 'New York', 'NY', '10014', 'USA', '399.99', 'http://bikes.com');
INSERT INTO `tt_43` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Price ($)`, `Website URL`) VALUES ('2', 'Iron Horse Warrior Race 2005', '2', '2006-06-29', '* FRAME: ALLOY 6061 FRAME, 1 1/8" ZERO STACK HEADTUBE, REPLACEABLE DROPOUT AND DISC MOUNTS, FENDER MOUNTS, MONOSTAY\r\n* FORK: ROCK SHOX PILOT, 100MM\r\n* HANDLEBAR: EASTON 1" RISE, 31.8MM CLAMP\r\n* STEM: EASTON\r\n* HEADSET: ZERO STACK THREADLESS, 1 1/8"\r\n* BB: TRUVATIV GIGAPIPE ISIS\r\n* CRANK: TRUVATIV FIREX SX\r\nRINGS 44/32/22\r\n* PEDAL: CRANK BRO CLIPLESS EGGBEATER\r\n* CHAIN: SHIMANO HG-73\r\n* SEAT: WTB ROCKET V RACE W/CROMO RAIL\r\n* SEAT POST: EASTON, 27.0MM\r\n* F. HUB: ALLOY QR, DISC MOUNT, 32HOLE\r\n* R. HUB: SHIMANO ALLOY QR 32H\r\n* F. DER: SHIMANO DEORE\r\n* R. DER: SRAM X.9\r\n* SHIFTER: SRAM X.7 TRIGGER\r\n* FREEWHEEL: SRAM PG-970, 11/32T, 9 SPEED\r\n* BRAKES: HAYES HYDRAULIC HFX 9 XC DISC BRAKE W/ 6" MUD CUTTER ROTOR\r\n* BRAKE LEVER: HAYES HFX-9-XC\r\n* RIM: WTB SPEED DISC 32H WITH EYELETS\r\n* SPOKE: 14G STAINLESS-BLACK W/ SILVER NIPPLE\r\n* TIRES: WTB WEIRWOLF 2.1\r\n* SIZE: 13.5", 15.5", 17.5", 19.5", 21.5" (Examlpe Copied From: gallery.bcentral.com)', '12', 'no', '2', '2010-09-27', '40.764121', '-73.996026', '645 11th Ave', 'New York', 'NY', '10036', 'USA', '199.99', 'http://bikes.com');
INSERT INTO `tt_43` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Price ($)`, `Website URL`) VALUES ('3', 'Dave (1993)', '2', '2006-06-29', 'Bill Mitchell is the philandering and distant President of the United States. Dave Kovic is a sweet-natured and caring Temp Agency operator, who by a staggering coincidence looks exactly like the President. As such, when Mitchell wants to escape an official luncheon, the Secret Service hires Dave to stand in for him. Unfortunately, Mitchell suffers a severe stroke whilst having sex with one of his aides, and Dave finds himself stuck in the role indefinitely. The corrupt and manipulative Chief of Staff, Bob Alexander, plans to use Dave to elevate himself to the White House - but unfortunately, he doesn\'t count on Dave enjoying himself in office, using his luck to make the country a better place, and falling in love with the beautiful First Lady...', '23', 'no', '2', '2010-09-27', '40.764121', '-73.996026', '645 11th Ave', 'New York', 'NY', '10036', 'USA', '6.47', 'http://amazon.com');
INSERT INTO `tt_43` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Price ($)`, `Website URL`) VALUES ('4', 'Rush Hour (New Line Platinum Series) (1998)', '6', '2006-06-29', 'Realizing that the FBI and their by the book tactics may be unsuccessful, the Chinese consul recruits the aid of a loyal Hong Kong inspector to help rescue his kidnapped daughter. Outlawed by the FBI, the inspector must form an unlikely partnership with a cocky, street smart LAPD officer who prefers doing things his own way.', '23', 'yes', '2', '2010-09-27', '40.764121', '-73.996026', '645 11th Ave', 'New York', 'NY', '10036', 'USA', '7.48', 'http://www.amazon.com/gp/product/0780625145/ref=br_lf_d_/104');
INSERT INTO `tt_43` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Price ($)`, `Website URL`) VALUES ('5', 'Inspiron E1405', '2', '2006-06-29', 'Intel® CoreTM Duo Processor T2500 (2GHz/667MHz FSB/2MB Cache)\r\nGenuine Windows® XP Professional Edition\r\n\r\nUp to 2GB of Dual Channel DDR2 memory provides blazing performance.\r\n \r\nDDR2 dual channel1 memory offers excellent performance and bandwidth. This memory architecture is designed to help improve overall system performance and reduce power consumption. As demands from processors, graphics and networking increase, DDR2 is the new standard in notebook memory. \r\n\r\nStandard:\r\n14.1" Widescreen TFT Active Matrix WXGA (1280 x 800) display.\r\nIntegrated Intel® Media Accelerator 950 Graphics.\r\n \r\nOptional:\r\n14.1" Widescreen TFT Active Matrix WXGA+ (1440 x 900) display with TrueLifeTM . \r\n\r\nStandard:\r\nIntegrated stereo sound.\r\n \r\nOptional:\r\nIntegrated Sound Blaster Audigy ADVANCED HD Audio.\r\n\r\n \r\nUp to 100GB hard drive lets you store and access abundant data on your notebook. \r\n\r\n * IEEE 1394 integrated port (1394 cable and software sold separately)\r\n * 4 USB 2.0 (Universal Serial Bus) compliant 4-pin connectors\r\n * RJ45 Ethernet port\r\n * RJ11 Modem port\r\n * Video: 15-pin monitor connector\r\n * S-Video: 7-pin mini-DIN connector\r\n * 5-in-1 removable memory card reader\r\n * Audio jacks: Stereo headphones/speakers miniconnector (same as line-out), microphone miniconnector', '16', 'no', '2', '2010-09-27', '40.764121', '-73.996026', '645 11th Ave', 'New York', 'Ny', '10036', 'USA', '722', 'http://www.dell.com/content/products/productdetails.aspx/ent');
truncate table `tt_44`;
INSERT INTO `tt_44` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Price ($)`, `Property Type`, `Bed(s)`, `Bath(s)`, `Date property is available`, `Open house date`, `Open house time`, `Square Footage`, `Lot Size`, `Garage`, `Year Built`, `School District`, `Neighborhood`, `Features`, `Virtual Tour URL`) VALUES ('1', '350 West 50th Street', '10', '2006-06-29', 'High floor super bright studio with separate kitchen, walk in closet and entry foyer. Worldwide Plaza is a full service condominium located only blocks away from Rockefeller Center, Broadway theaters, Columbus Circle, Central Park and Hudson River Park. (Example Copied From: elliman.com)', '31', 'no', '2', '2010-09-27', '40.762891', '-73.987590', '350 West 50th Street', 'New York', 'NY', '10036', 'USA', '550000', 'Condo/Townhouse', '2', '1', '06/22/2006', '06/22/06 - 07/21/06', '9:00AM to 3:00PM', '417', '0', '1', '1995', 'N/A', 'Clinton', 'Balcony,Bike Paths,Boating,Pool,Sports Complex', '');
INSERT INTO `tt_44` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Price ($)`, `Property Type`, `Bed(s)`, `Bath(s)`, `Date property is available`, `Open house date`, `Open house time`, `Square Footage`, `Lot Size`, `Garage`, `Year Built`, `School District`, `Neighborhood`, `Features`, `Virtual Tour URL`) VALUES ('2', '10 West St', '10', '2006-06-29', 'Come home to this generously proportioned and gracefully appointed 3 bedroom, formal dining room, and library in the luxurious Residences at The Ritz-Carlton in Battery Park. Floor-to-ceiling and wall-to-wall, this grand penthouse has been sculpted with an exacting eye for detail. Floors are of rich mahogany herringbone and fine marble. Meticulous in every detail, this magnificent corner home offers spectacular Statue of Liberty and NY Harbor views from floor to ceiling windows in every room. The kitchen is outfitted with premier appliances, including a Sub Zero refrigerator, Viking stove, two wine refrigerators, fine wood custom cabinetry and granite counter tops. Marble master bath features a large soaking tub and frameless, glass-enclosed shower with elegant fixtures and hardware throughout. The Ritz-Carlton residents may dine on cuisine prepared in their own gourmet kitchens, or served by exclusive in-home butler service from the hotel\'s fine restaurants. All other hotel amenities, from the concierge to the business center are available to residents as well. (Example Copied From: http://realestate.nytimes.com)', '31', 'yes', '2', '2010-09-27', '40.728648', '-73.994751', '10 West St', 'New York', 'NY', '10280', 'USA', '5900000', 'Condo/Townhouse', '6', '5', '06/05/06', '06/22/06 - 07/21/06', '9:00AM to 3:00PM', '3991', '0', '1', '2001', 'N/A', 'N/A', 'Balcony,Bike Paths,Boating,Cable/Satellite TV,Carpeted Floors,Clubhouse,Courtyard,Near Public Transportation,Pool,Tennis Courts,Washer/Dryer,Wheelchair Access', '');
truncate table `tt_45`;
INSERT INTO `tt_45` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Rent ($)`, `Property Type`, `Bed(s)`, `Bath(s)`, `Security Deposit`, `Date unit is available`, `Square Footage`, `Year Built`, `School District`, `Neighborhood`, `Features`, `Pets`, `Virtual Tour URL`) VALUES ('1', '119 ST New York', '19', '2006-06-29', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Sed porttitor dolor in nibh. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis vel tellus et est auctor suscipit. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vestibulum tristique ante vitae est. Mauris in magna sit amet pede vehicula iaculis. Integer est massa, consequat sed, porttitor sed, molestie vel, eros. Sed sit amet orci vitae massa posuere viverra. Aenean ultricies justo sed quam. Duis sed nibh in elit egestas commodo. Suspendisse fermentum. Nulla facilisi. Cras luctus interdum turpis. Donec pellentesque est sit amet metus. Integer erat. Vivamus sed mi. Proin tincidunt orci eu dui. Vivamus ullamcorper dictum justo. Duis eget tellus.\r\n\r\nNunc accumsan odio eu nisi. Vivamus pretium convallis purus. Aliquam fermentum ultrices metus. Vestibulum nonummy, ipsum in lobortis dapibus, sapien felis placerat turpis, condimentum accumsan nunc nulla et eros. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer quam enim, porta eu, eleifend lacinia, pulvinar nec, eros. In posuere dui sit amet urna. Nam tristique volutpat orci. Etiam nunc. Nam luctus dapibus nisi. Nullam vitae risus eu tortor ullamcorper imperdiet. Maecenas lobortis dictum turpis. In hac habitasse platea dictumst. Curabitur tempus ultrices enim. Praesent eget urna. Duis convallis, tortor vitae lobortis fermentum, sem dui faucibus urna, placerat nonummy sem sapien non leo. Vestibulum urna. Ut blandit. Cras pede enim, egestas in, convallis nec, placerat eu, nisi. Aenean sed elit. ', '32', 'yes', '2', '2010-09-27', '', '', 'West 118th Street', '(Harlem) New York', 'NY', '10026', 'USA', '1463', 'Apartments', '2', '2.5', '3000', 'As of 06/22/06', '1200', '2001', 'Harlem', 'Brownstone', 'Air Conditioning,Alarm,Association Fee,Disposal,Fireplace,Fitness Center,Gas Range,Golf Course,Hardwood Floors,Microwave,Near Public Transportation', 'Dogs/Cats Ok', '');
truncate table `tt_46`;
INSERT INTO `tt_46` (`ID`, `Title`, `Hits`, `PostDate`, `Description`, `CategoryID`, `Featured`, `MemberID`, `ExpireDate`, `Latitude`, `Longitude`, `Address`, `City`, `State/Province`, `Zip/Postal`, `Country`, `Required skills`, `Job length`, `Pay rate`, `Start date`) VALUES ('1', 'PHP/MySQL Programmer', '4', '2006-06-29', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Sed porttitor dolor in nibh. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis vel tellus et est auctor suscipit. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vestibulum tristique ante vitae est. Mauris in magna sit amet pede vehicula iaculis. Integer est massa, consequat sed, porttitor sed, molestie vel, eros. Sed sit amet orci vitae massa posuere viverra. Aenean ultricies justo sed quam. Duis sed nibh in elit egestas commodo. Suspendisse fermentum. Nulla facilisi. Cras luctus interdum turpis. Donec pellentesque est sit amet metus. Integer erat. Vivamus sed mi. Proin tincidunt orci eu dui. Vivamus ullamcorper dictum justo. Duis eget tellus.\r\n\r\nNunc accumsan odio eu nisi. Vivamus pretium convallis purus. Aliquam fermentum ultrices metus. Vestibulum nonummy, ipsum in lobortis dapibus, sapien felis placerat turpis, condimentum accumsan nunc nulla et eros. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Integer quam enim, porta eu, eleifend lacinia, pulvinar nec, eros. In posuere dui sit amet urna. Nam tristique volutpat orci. Etiam nunc. Nam luctus dapibus nisi. Nullam vitae risus eu tortor ullamcorper imperdiet. Maecenas lobortis dictum turpis. In hac habitasse platea dictumst. Curabitur tempus ultrices enim. Praesent eget urna. Duis convallis, tortor vitae lobortis fermentum, sem dui faucibus urna, placerat nonummy sem sapien non leo. Vestibulum urna. Ut blandit. Cras pede enim, egestas in, convallis nec, placerat eu, nisi. Aenean sed elit.\r\n\r\nDuis bibendum, nunc sed gravida luctus, ante metus feugiat leo, nec aliquet lorem felis in nunc. Phasellus tempus. Mauris ullamcorper nisl a est imperdiet interdum. Praesent lacus neque, tempus ut, vestibulum ut, adipiscing sed, mauris. Nullam massa est, mollis sed, interdum quis, pretium id, purus. Ut lobortis. In mauris. Donec volutpat nulla quis purus. Phasellus nunc. Cras rhoncus, leo id mattis auctor, qu', '3', 'no', '2', '2010-09-27', '40.764121', '-73.996026', '645 11th Ave', 'New York', 'NY', '10036', 'USA', 'PHP, MySQL, Dreamweaver, BS in Computer Science, Master in Info Tec.', 'Permanent', '120,000 Annual', '06/20/06');
truncate table `types`;
INSERT INTO `types` (`ID`, `Title`, `Mapping`, `Photos`) VALUES ('43', 'For Sale Ads', 'yes', 'yes');
INSERT INTO `types` (`ID`, `Title`, `Mapping`, `Photos`) VALUES ('44', 'Home Ads', 'yes', 'yes');
INSERT INTO `types` (`ID`, `Title`, `Mapping`, `Photos`) VALUES ('42', 'Autos Ads', 'yes', 'yes');
INSERT INTO `types` (`ID`, `Title`, `Mapping`, `Photos`) VALUES ('45', 'Rental Ads', 'yes', 'yes');
INSERT INTO `types` (`ID`, `Title`, `Mapping`, `Photos`) VALUES ('46', 'Job Ads', 'yes', 'no');
truncate table `votes`;
INSERT INTO `votes` (`ID`, `ListingID`, `Approved`, `IP`, `Date`, `Vote`, `TypeID`) VALUES ('1', '1', 'yes', '24.31.211.219', '2006-06-24', '10', '41');
INSERT INTO `votes` (`ID`, `ListingID`, `Approved`, `IP`, `Date`, `Vote`, `TypeID`) VALUES ('2', '2', 'yes', '199.120.31.20', '2006-06-27', '10', '40');
INSERT INTO `votes` (`ID`, `ListingID`, `Approved`, `IP`, `Date`, `Vote`, `TypeID`) VALUES ('3', '1', 'yes', '199.120.31.20', '2006-06-27', '9', '40');
INSERT INTO `votes` (`ID`, `ListingID`, `Approved`, `IP`, `Date`, `Vote`, `TypeID`) VALUES ('4', '2', 'yes', '199.120.31.20', '2006-06-28', '10', '40');
INSERT INTO `votes` (`ID`, `ListingID`, `Approved`, `IP`, `Date`, `Vote`, `TypeID`) VALUES ('5', '1', 'yes', '199.120.31.20', '2006-06-29', '8', '40');
INSERT INTO `votes` (`ID`, `ListingID`, `Approved`, `IP`, `Date`, `Vote`, `TypeID`) VALUES ('6', '1', 'yes', '199.120.31.20', '2006-06-29', '10', '42');
INSERT INTO `votes` (`ID`, `ListingID`, `Approved`, `IP`, `Date`, `Vote`, `TypeID`) VALUES ('7', '4', 'yes', '199.120.31.20', '2006-06-29', '10', '42');
