Quick Links:
Eat.Shop.Save!
North Mr. Pizza
4040 28th St., NW
Rochester, MN 55901
PH: 507-252-9400
Coupon:
• Save $5 off any order of $25 or more!


print coupon
email coupon
SEARCH
the MarketPlace:
E.G., "Casa Del Rio", "53186"
Featured Coupons
Restaurant Offers:

Retail & Service Offers:

Most Popular
Check out these popular shopping pages:

Search
Local Radar | complete weather
Images.Info.Community!
Happening this Week
Browse Entire Calendar | Submit an Event
Special Sections & Guides
Local and regional homes, lots, acreages, commercial property, & services.
EXPOSED is an edgy monthly magazine geared at the 20-something set.
Southeast Minnesota's guide to real estate and home trends
The insiders' guide to absolutely everything Rochester.
A guide to Southeastern Minnesota 2009-2010.
A comphrehensive listing of regional courses.
A look at the high school, college and pro teams and seasons.
Photo Galleries
View All | Submit Photo
Video & Multimedia
Most Recent Video:
Scroll through the list of "Just In" video below to see todays most recent top videos.
Browse more multimedia by:
Contests & Tickets
Want a Dream Wedding?
Ends Soon! Enter here for your chance to win wonderful prizes!
Click here to enter
Pro Racing Challenge
Pick the winning racer for you chance at national prizes!
Click here to enter
Visit & Do
Destinations:
Hotel Search
Select your price range:
Low: High:
Things to Do:
Diversions
Celebrity News
Lottery
More features
Latest Blog
Elk Run planners announce timeline...
Mar 17, 2010
Advocates of the planned $1 billion Elk Run biotechnology project in Pine Island, Minnesota have ann...
read more
Recent Posts
Select Post by Blogger
Minnesota News
World News
(default) 65 queries took 106 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `onsale_coupons_categories`331
2DESCRIBE `onsale_coupons_categories_divisions`221
3DESCRIBE `onsale_coupons`14142
4DESCRIBE `onsale_merchants`12122
5DESCRIBE `sales_people`551
6DESCRIBE `onsale_merchants_addresses`12121
7DESCRIBE `onsale_merchants_addresses_cities`221
8DESCRIBE `merchant_categories`661
9DESCRIBE `merchant_categories_onsale_merchants`331
10DESCRIBE `onsale_coupons_views`661
11DESCRIBE `onsale_coupons_onsale_coupons_categories`331
12DESCRIBE `special_sections`11112
13DESCRIBE `popular_links`991
14DESCRIBE `about_us_comments`881
15DESCRIBE `contests`15152
16DESCRIBE `contest_icons`331
17DESCRIBE `contest_winners`11111
18DESCRIBE `contest_archives`12121
19DESCRIBE `contest_categories`331
20DESCRIBE `contest_categories_contests`331
21DESCRIBE `contest_archives_contest_categories`331
22SELECT `SpecialSection`.`id`, `SpecialSection`.`img`, `SpecialSection`.`title`, `SpecialSection`.`url`, `SpecialSection`.`copy`, `SpecialSection`.`open_new`, `SpecialSection`.`parent_id`, `SpecialSection`.`lft`, `SpecialSection`.`rght`, `SpecialSection`.`created`, `SpecialSection`.`modified` FROM `special_sections` AS `SpecialSection` WHERE 1 = 1 ORDER BY `SpecialSection`.`lft` DESC 771
23SELECT `PopularLink`.`id`, `PopularLink`.`title`, `PopularLink`.`link_path`, `PopularLink`.`link_color`, `PopularLink`.`parent_id`, `PopularLink`.`lft`, `PopularLink`.`rght`, `PopularLink`.`created`, `PopularLink`.`modified` FROM `popular_links` AS `PopularLink` WHERE 1 = 1 ORDER BY `lft` ASC 17171
24SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id` FROM `onsale_coupons` AS `OnsaleCoupon` WHERE `OnsaleCoupon`.`datestart` <= CURDATE() AND `OnsaleCoupon`.`dateend` >= CURDATE() ORDER BY `OnsaleCoupon`.`created` DESC 67672
25SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_coupons` AS `OnsaleCoupon` LEFT JOIN `onsale_merchants` AS `OnsaleMerchant` ON (`OnsaleCoupon`.`onsale_merchant_id` = `OnsaleMerchant`.`id`) WHERE `OnsaleCoupon`.`id` = 235 ORDER BY `OnsaleCoupon`.`created` DESC LIMIT 1112
26SELECT `OnsaleCouponsView`.`id`, `OnsaleCouponsView`.`date`, `OnsaleCouponsView`.`onsale_coupon_id`, `OnsaleCouponsView`.`screen_views`, `OnsaleCouponsView`.`print_view`, `OnsaleCouponsView`.`mobile_view` FROM `onsale_coupons_views` AS `OnsaleCouponsView` WHERE `OnsaleCouponsView`.`onsale_coupon_id` = (235) 1331334
27SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id`, `OnsaleCouponsOnsaleCouponsCategory`.`id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` JOIN `onsale_coupons_onsale_coupons_categories` AS `OnsaleCouponsOnsaleCouponsCategory` ON (`OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id` = 235 AND `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` = `OnsaleCouponsCategory`.`id`) WHERE 1 = 1 16161
28SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email`, `SalesPerson`.`id`, `SalesPerson`.`first_name`, `SalesPerson`.`last_name`, `SalesPerson`.`email`, `SalesPerson`.`phone` FROM `onsale_merchants` AS `OnsaleMerchant` LEFT JOIN `sales_people` AS `SalesPerson` ON (`OnsaleMerchant`.`sales_person_id` = `SalesPerson`.`id`) WHERE `OnsaleMerchant`.`id` = 39 ORDER BY `OnsaleMerchant`.`name` ASC LIMIT 1111
29SELECT `SalesPerson`.`id`, `SalesPerson`.`first_name`, `SalesPerson`.`last_name`, `SalesPerson`.`email`, `SalesPerson`.`phone` FROM `sales_people` AS `SalesPerson` WHERE `SalesPerson`.`id` = 1 111
30SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`sales_person_id` = (1) 16164
31SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified` FROM `onsale_coupons` AS `OnsaleCoupon` WHERE `OnsaleCoupon`.`onsale_merchant_id` = (39) ORDER BY `OnsaleCoupon`.`created` DESC 661
32SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 39 111
33SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 39 111
34SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 39 111
35SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 39 111
36SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 39 111
37SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 39 111
38SELECT `OnsaleCouponsView`.`id`, `OnsaleCouponsView`.`date`, `OnsaleCouponsView`.`onsale_coupon_id`, `OnsaleCouponsView`.`screen_views`, `OnsaleCouponsView`.`print_view`, `OnsaleCouponsView`.`mobile_view` FROM `onsale_coupons_views` AS `OnsaleCouponsView` WHERE `OnsaleCouponsView`.`onsale_coupon_id` IN (235, 195, 194, 104, 103, 102) 6686686
39SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id`, `OnsaleCouponsOnsaleCouponsCategory`.`id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` JOIN `onsale_coupons_onsale_coupons_categories` AS `OnsaleCouponsOnsaleCouponsCategory` ON (`OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id` IN (235, 195, 194, 104, 103, 102) AND `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` = `OnsaleCouponsCategory`.`id`) WHERE 1 = 1 99991
40SELECT `OnsaleMerchantsAddress`.`id`, `OnsaleMerchantsAddress`.`onsale_merchant_id`, `OnsaleMerchantsAddress`.`address`, `OnsaleMerchantsAddress`.`onsale_merchants_addresses_city_id`, `OnsaleMerchantsAddress`.`state`, `OnsaleMerchantsAddress`.`zip`, `OnsaleMerchantsAddress`.`phone`, `OnsaleMerchantsAddress`.`phone2`, `OnsaleMerchantsAddress`.`fax`, `OnsaleMerchantsAddress`.`email`, `OnsaleMerchantsAddress`.`lat`, `OnsaleMerchantsAddress`.`long` FROM `onsale_merchants_addresses` AS `OnsaleMerchantsAddress` WHERE `OnsaleMerchantsAddress`.`onsale_merchant_id` = (39) 111
41SELECT `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_merchants` AS `OnsaleMerchant` WHERE `OnsaleMerchant`.`id` = 39 111
42SELECT `OnsaleMerchantsAddressesCity`.`id`, `OnsaleMerchantsAddressesCity`.`title` FROM `onsale_merchants_addresses_cities` AS `OnsaleMerchantsAddressesCity` WHERE `OnsaleMerchantsAddressesCity`.`id` = 1 111
43SELECT `MerchantCategory`.`id`, `MerchantCategory`.`title`, `MerchantCategory`.`ad_zone_id`, `MerchantCategory`.`parent_id`, `MerchantCategory`.`lft`, `MerchantCategory`.`rght`, `MerchantCategoriesOnsaleMerchant`.`id`, `MerchantCategoriesOnsaleMerchant`.`merchant_category_id`, `MerchantCategoriesOnsaleMerchant`.`onsale_merchant_id` FROM `merchant_categories` AS `MerchantCategory` JOIN `merchant_categories_onsale_merchants` AS `MerchantCategoriesOnsaleMerchant` ON (`MerchantCategoriesOnsaleMerchant`.`onsale_merchant_id` = 39 AND `MerchantCategoriesOnsaleMerchant`.`merchant_category_id` = `MerchantCategory`.`id`) WHERE 1 = 1 001
44SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` WHERE `OnsaleCouponsCategory`.`title` = 'Let\'s Eat Out' LIMIT 1111
45SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id`, `OnsaleCouponsCategoriesDivision`.`id`, `OnsaleCouponsCategoriesDivision`.`title` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` LEFT JOIN `onsale_coupons_categories_divisions` AS `OnsaleCouponsCategoriesDivision` ON (`OnsaleCouponsCategory`.`onsale_coupons_categories_division_id` = `OnsaleCouponsCategoriesDivision`.`id`) WHERE `OnsaleCouponsCategory`.`id` = (6) 111
46SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleCouponsOnsaleCouponsCategory`.`id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` FROM `onsale_coupons` AS `OnsaleCoupon` JOIN `onsale_coupons_onsale_coupons_categories` AS `OnsaleCouponsOnsaleCouponsCategory` ON (`OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` = 6 AND `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id` = `OnsaleCoupon`.`id`) WHERE 1 = 1 1311315
47SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id` FROM `onsale_coupons` AS `OnsaleCoupon` WHERE `OnsaleCoupon`.`datestart` <= CURDATE() AND `OnsaleCoupon`.`dateend` >= CURDATE() AND `OnsaleCoupon`.`id` IN (1,3,4,5,6,7,10,13,14,15,16,17,18,19,20,21,81,23,24,219,218,217,28,29,30,31,32,145,144,36,190,235,42,43,44,226,223,48,49,50,109,108,54,260,347,259,58,59,60,65,66,67,221,220,78,95,94,96,98,99,265,246,102,103,104,216,126,127,128,129,130,141,142,143,152,157,158,159,215,166,167,168,169,300,346,293,292,182,183,184,247,194,195,369,202,203,204,205,206,207,208,209,210,211,212,213,214,261,267,268,352,272,345,368,289,290,301,302,304,317,318,319,320,373,372,324,325,351,353,371,370) ORDER BY `OnsaleCoupon`.`created` DESC 53532
48SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_coupons` AS `OnsaleCoupon` LEFT JOIN `onsale_merchants` AS `OnsaleMerchant` ON (`OnsaleCoupon`.`onsale_merchant_id` = `OnsaleMerchant`.`id`) WHERE `OnsaleCoupon`.`id` IN (14,99,217,127,15) ORDER BY `OnsaleCoupon`.`created` DESC 553
49SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` WHERE `OnsaleCouponsCategory`.`title` = 'Onsale' LIMIT 1119
50SELECT `OnsaleCouponsCategory`.`id`, `OnsaleCouponsCategory`.`title`, `OnsaleCouponsCategory`.`onsale_coupons_categories_division_id`, `OnsaleCouponsCategoriesDivision`.`id`, `OnsaleCouponsCategoriesDivision`.`title` FROM `onsale_coupons_categories` AS `OnsaleCouponsCategory` LEFT JOIN `onsale_coupons_categories_divisions` AS `OnsaleCouponsCategoriesDivision` ON (`OnsaleCouponsCategory`.`onsale_coupons_categories_division_id` = `OnsaleCouponsCategoriesDivision`.`id`) WHERE `OnsaleCouponsCategory`.`id` = (5) 111
51SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleCouponsOnsaleCouponsCategory`.`id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id`, `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` FROM `onsale_coupons` AS `OnsaleCoupon` JOIN `onsale_coupons_onsale_coupons_categories` AS `OnsaleCouponsOnsaleCouponsCategory` ON (`OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupons_category_id` = 5 AND `OnsaleCouponsOnsaleCouponsCategory`.`onsale_coupon_id` = `OnsaleCoupon`.`id`) WHERE 1 = 1 31312
52SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id` FROM `onsale_coupons` AS `OnsaleCoupon` WHERE `OnsaleCoupon`.`datestart` <= CURDATE() AND `OnsaleCoupon`.`dateend` >= CURDATE() AND `OnsaleCoupon`.`id` IN (192,191,120,119,250,249,93,92,91,121,156,165,176,177,178,193,288,146,147,148,349,348,277,284,316,315,314,327,326,328,350) ORDER BY `OnsaleCoupon`.`created` DESC 14141
53SELECT `OnsaleCoupon`.`id`, `OnsaleCoupon`.`onsale_merchant_id`, `OnsaleCoupon`.`title`, `OnsaleCoupon`.`content`, `OnsaleCoupon`.`extended_content`, `OnsaleCoupon`.`datestart`, `OnsaleCoupon`.`dateend`, `OnsaleCoupon`.`retail_price`, `OnsaleCoupon`.`sale_price`, `OnsaleCoupon`.`conditions`, `OnsaleCoupon`.`img1`, `OnsaleCoupon`.`img2`, `OnsaleCoupon`.`created`, `OnsaleCoupon`.`modified`, `OnsaleMerchant`.`id`, `OnsaleMerchant`.`name`, `OnsaleMerchant`.`website`, `OnsaleMerchant`.`about_us`, `OnsaleMerchant`.`hours`, `OnsaleMerchant`.`logo`, `OnsaleMerchant`.`img1`, `OnsaleMerchant`.`img2`, `OnsaleMerchant`.`menu`, `OnsaleMerchant`.`sales_person_id`, `OnsaleMerchant`.`contact_name`, `OnsaleMerchant`.`contact_email` FROM `onsale_coupons` AS `OnsaleCoupon` LEFT JOIN `onsale_merchants` AS `OnsaleMerchant` ON (`OnsaleCoupon`.`onsale_merchant_id` = `OnsaleMerchant`.`id`) WHERE `OnsaleCoupon`.`id` IN (348,350,349,91,326) ORDER BY `OnsaleCoupon`.`created` DESC 553
54SELECT `ContestCategory`.`id`, `ContestCategory`.`title`, `ContestCategory`.`code` FROM `contest_categories` AS `ContestCategory` WHERE `ContestCategory`.`code` = ('portal_site') 111
55SELECT `Contest`.`id`, `Contest`.`title`, `Contest`.`image`, `Contest`.`short_description`, `Contest`.`long_description`, `Contest`.`link`, `Contest`.`new_window`, `Contest`.`start_date`, `Contest`.`end_date`, `Contest`.`contest_icon_id`, `Contest`.`created`, `Contest`.`modified`, `Contest`.`parent_id`, `Contest`.`lft`, `Contest`.`rght`, `ContestCategoriesContest`.`id`, `ContestCategoriesContest`.`contest_category_id`, `ContestCategoriesContest`.`contest_id` FROM `contests` AS `Contest` JOIN `contest_categories_contests` AS `ContestCategoriesContest` ON (`ContestCategoriesContest`.`contest_category_id` = 3 AND `ContestCategoriesContest`.`contest_id` = `Contest`.`id`) WHERE 1 = 1 552
56SELECT `Contest`.`id`, `Contest`.`title`, `Contest`.`image`, `Contest`.`short_description`, `Contest`.`long_description`, `Contest`.`link`, `Contest`.`new_window`, `Contest`.`start_date`, `Contest`.`end_date`, `Contest`.`contest_icon_id`, `Contest`.`created`, `Contest`.`modified`, `Contest`.`parent_id`, `Contest`.`lft`, `Contest`.`rght`, `ContestIcon`.`id`, `ContestIcon`.`title`, `ContestIcon`.`image` FROM `contests` AS `Contest` LEFT JOIN `contest_icons` AS `ContestIcon` ON (`Contest`.`contest_icon_id` = `ContestIcon`.`id`) WHERE `Contest`.`start_date` <= CURDATE() AND `Contest`.`end_date` >= CURDATE() AND `Contest`.`id` IN (1,8,11,12,14) ORDER BY `lft` ASC 552
57SELECT `ContestWinner`.`id`, `ContestWinner`.`contest_id`, `ContestWinner`.`related_table_name`, `ContestWinner`.`first_name`, `ContestWinner`.`last_name`, `ContestWinner`.`image`, `ContestWinner`.`city`, `ContestWinner`.`prize`, `ContestWinner`.`misc`, `ContestWinner`.`created`, `ContestWinner`.`modified` FROM `contest_winners` AS `ContestWinner` WHERE `ContestWinner`.`related_table_name` = 'contests' AND `ContestWinner`.`contest_id` IN (8, 12, 11, 14, 1) 001
58SELECT `ContestCategory`.`id`, `ContestCategory`.`title`, `ContestCategory`.`code`, `ContestCategoriesContest`.`id`, `ContestCategoriesContest`.`contest_category_id`, `ContestCategoriesContest`.`contest_id` FROM `contest_categories` AS `ContestCategory` JOIN `contest_categories_contests` AS `ContestCategoriesContest` ON (`ContestCategoriesContest`.`contest_id` IN (8, 12, 11, 14, 1) AND `ContestCategoriesContest`.`contest_category_id` = `ContestCategory`.`id`) WHERE 1 = 1 15151
59SELECT `Contest`.`id`, `Contest`.`title`, `Contest`.`image`, `Contest`.`short_description`, `Contest`.`long_description`, `Contest`.`link`, `Contest`.`new_window`, `Contest`.`start_date`, `Contest`.`end_date`, `Contest`.`contest_icon_id`, `Contest`.`created`, `Contest`.`modified`, `Contest`.`parent_id`, `Contest`.`lft`, `Contest`.`rght`, `ContestIcon`.`id`, `ContestIcon`.`title`, `ContestIcon`.`image` FROM `contests` AS `Contest` LEFT JOIN `contest_icons` AS `ContestIcon` ON (`Contest`.`contest_icon_id` = `ContestIcon`.`id`) WHERE `Contest`.`id` IN (8,12,11,14,1) ORDER BY RAND() ASC LIMIT 2222
60SELECT `ContestWinner`.`id`, `ContestWinner`.`contest_id`, `ContestWinner`.`related_table_name`, `ContestWinner`.`first_name`, `ContestWinner`.`last_name`, `ContestWinner`.`image`, `ContestWinner`.`city`, `ContestWinner`.`prize`, `ContestWinner`.`misc`, `ContestWinner`.`created`, `ContestWinner`.`modified` FROM `contest_winners` AS `ContestWinner` WHERE `ContestWinner`.`related_table_name` = 'contests' AND `ContestWinner`.`contest_id` IN (8, 1) 001
61SELECT `ContestCategory`.`id`, `ContestCategory`.`title`, `ContestCategory`.`code`, `ContestCategoriesContest`.`id`, `ContestCategoriesContest`.`contest_category_id`, `ContestCategoriesContest`.`contest_id` FROM `contest_categories` AS `ContestCategory` JOIN `contest_categories_contests` AS `ContestCategoriesContest` ON (`ContestCategoriesContest`.`contest_id` IN (8, 1) AND `ContestCategoriesContest`.`contest_category_id` = `ContestCategory`.`id`) WHERE 1 = 1 661
62DESCRIBE `widgets`661
63SELECT `Widget`.`id`, `Widget`.`name`, `Widget`.`content_feed_url`, `Widget`.`data`, `Widget`.`update_frequency`, `Widget`.`modified` FROM `widgets` AS `Widget` WHERE `Widget`.`name` = 'weather' LIMIT 1112
64DESCRIBE `navigation_links`10102
65SELECT `NavigationLink`.`id`, `NavigationLink`.`title`, `NavigationLink`.`link_path`, `NavigationLink`.`link_color`, `NavigationLink`.`open_new`, `NavigationLink`.`parent_id`, `NavigationLink`.`lft`, `NavigationLink`.`rght`, `NavigationLink`.`created`, `NavigationLink`.`modified` FROM `navigation_links` AS `NavigationLink` WHERE 1 = 1 ORDER BY `lft` ASC 35352
(bloggers) 5 queries took 595 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `blog_posts`6684
2DESCRIBE `blog_providers`9975
3SELECT `QcbloggersProvider`.`id`, `QcbloggersProvider`.`name`, `QcbloggersProvider`.`url_feed`, `QcbloggersProvider`.`url_site`, `QcbloggersProvider`.`featured`, `QcbloggersProvider`.`active`, `QcbloggersProvider`.`display_order`, `QcbloggersProvider`.`parse_p_wrapper`, `QcbloggersProvider`.`parse_p_divider` FROM `blog_providers` AS `QcbloggersProvider` WHERE active = 1 2323213
4SELECT `QcbloggersPost`.`provider`, `QcbloggersPost`.`date_timestamp`, `QcbloggersPost`.`title`, `QcbloggersPost`.`link`, `QcbloggersPost`.`content`, `QcbloggersPost`.`active` FROM `blog_posts` AS `QcbloggersPost` WHERE 1 = 1 ORDER BY `QcbloggersPost`.`date_timestamp` DESC LIMIT 111170
5SELECT `QcbloggersPost`.`title`, `QcbloggersPost`.`link` FROM `blog_posts` AS `QcbloggersPost` WHERE 1 = 1 ORDER BY `QcbloggersPost`.`date_timestamp` DESC LIMIT 55553