Dishola: Reviews by the Dish

dishola /dish•ō•lâ/
v. To share the love of food - dish by dish. n. The ultimate source to find real meals at real places that rule.
Derrick Sky Vegan Chocolates
zimmern's Profile
zimmern

zimmern (Andrew Zimmern)

Tablemates
no tablemates yet

About zimmern

When he’s not boarding trains, boats, and planes to eat whale with the Eskimos or bull’s balls with Spaniards, Andrew resides with his wife Rishia and their son, Noah, in St. Paul. Andrew Zimmern is a restaurant critic for Mpls. St.Paul Magazine.

Industry Experience

Food Writing

  • I've had food articles and/or reviews published.

(dishola_development) 14 queries took 33 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2DESCRIBE `blogbuzz`25251
3DESCRIBE `blogbuzz_votes`551
4DESCRIBE `blogbuzz_comments`661
5DESCRIBE `blogbuzz_dishes`331
6SELECT `User`.`id`, `User`.`name`, `User`.`realname`, `User`.`email`, `User`.`password`, `User`.`validated`, `User`.`count_dishes`, `User`.`count_reviews`, `User`.`count_reviews_votes`, `User`.`count_photos`, `User`.`count_must_trys`, `User`.`count_tablemates`, `User`.`count_sets`, `User`.`fb_sig_user`, `User`.`twitter_key`, `User`.`twitter_secret`, `User`.`created`, `User`.`modified`, `User`.`classification`, `User`.`image_150`, `User`.`image_48`, `User`.`image_16`, `User`.`image_normal`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`send_review_notification`, `Profile`.`send_friend_notification`, `Profile`.`send_dishset_notification`, `Profile`.`send_news`, `Profile`.`blogbuzz_100_MI_FROM_AUSTIN`, `Profile`.`blogbuzz_100_MI_FROM_SF`, `Profile`.`location`, `Profile`.`location_string`, `Profile`.`country_name_code`, `Profile`.`administrative_area`, `Profile`.`locality_name`, `Profile`.`postal_code`, `Profile`.`latitude`, `Profile`.`longitude`, `Profile`.`birthday`, `Profile`.`icon`, `Profile`.`views`, `Profile`.`about`, `Profile`.`reviews_sort`, `Profile`.`casual_strangest`, `Profile`.`passionate_classes`, `Profile`.`passionate_festivals`, `Profile`.`passionate_entertain`, `Profile`.`passionate_hottest`, `Profile`.`passionate_safari`, `Profile`.`passionate_cook`, `Profile`.`professional_ever`, `Profile`.`passionate_strangest`, `Profile`.`professional_exp_manager`, `Profile`.`professional_exp_host`, `Profile`.`professional_exp_waiter`, `Profile`.`professional_exp_sommelier`, `Profile`.`professional_exp_prep`, `Profile`.`professional_exp_line`, `Profile`.`professional_exp_sous`, `Profile`.`professional_exp_pastry`, `Profile`.`professional_exp_chef`, `Profile`.`professional_exp_teach`, `Profile`.`professional_exp_cater`, `Profile`.`professional_exp_owner`, `Profile`.`professional_exp_investor`, `Profile`.`professional_exp_behind`, `Profile`.`professional_exp_other`, `Profile`.`professional_school`, `Profile`.`writing_ever`, `Profile`.`professional_blog`, `Profile`.`professional_books`, `Profile`.`professional_critic`, `Profile`.`industry_currently`, `Profile`.`created`, `Profile`.`timestamp`, `Profile`.`favorite_cuisine`, `Profile`.`last_meal_request`, `Profile`.`favorite_eating_town`, `Profile`.`recommended_food_safari`, `Profile`.`and_to_drink`, `Profile`.`fantasy_tablemates`, `Profile`.`tip_motto_quote`, `Profile`.`tip_motto_quote_top`, `Profile`.`tip_motto_quote_left`, `Profile`.`header_image`, `Profile`.`last_login`, `Profile`.`modified`, `Profile`.`image_small`, `Profile`.`image`, `Profile`.`twitter_auto_review`, `FacebookConnect`.`id`, `FacebookConnect`.`user_id`, `FacebookConnect`.`fb_sig_user`, `FacebookConnect`.`fb_sig_session_key`, `FacebookConnect`.`share_item`, `FacebookConnect`.`created`, `FacebookConnect`.`modified` FROM `users` AS `User` LEFT JOIN `profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `facebook_connect` AS `FacebookConnect` ON (`FacebookConnect`.`user_id` = `User`.`id`) WHERE `User`.`name` = 'zimmern' LIMIT 1111
7SELECT `Blogbuzz`.`id`, `Blogbuzz`.`user_id`, `Blogbuzz`.`editor_user_id`, `Blogbuzz`.`title`, `Blogbuzz`.`editor_blurb`, `Blogbuzz`.`short_blurb`, `Blogbuzz`.`long_blurb`, `Blogbuzz`.`source_name`, `Blogbuzz`.`source_url`, `Blogbuzz`.`source_publish_date`, `Blogbuzz`.`publish_date`, `Blogbuzz`.`location`, `Blogbuzz`.`location_string`, `Blogbuzz`.`country_name_code`, `Blogbuzz`.`administrative_area`, `Blogbuzz`.`locality_name`, `Blogbuzz`.`postal_code`, `Blogbuzz`.`latitude`, `Blogbuzz`.`longitude`, `Blogbuzz`.`photo_large_id`, `Blogbuzz`.`photo_small_id`, `Blogbuzz`.`photo_credit`, `Blogbuzz`.`disabled`, `Blogbuzz`.`created`, `Blogbuzz`.`modified` FROM `blogbuzz` AS `Blogbuzz` WHERE `Blogbuzz`.`user_id` = (266) 0012
8SELECT COUNT(*) AS `count` FROM `profiles` AS `Profile` WHERE `Profile`.`id` = 256 1111
9UPDATE `profiles` SET `id` = 256, `user_id` = 266, `views` = 1552, `modified` = '2012-05-24 20:58:28' WHERE `profiles`.`id` = 25612
10SELECT `Profile`.* FROM `profiles` AS `Profile` LEFT JOIN `users` AS `User` ON (`Profile`.`user_id` = `User`.`id`) WHERE `Profile`.`id` = 256 LIMIT 1110
11SELECT `Friend_Friend`.* FROM `user_friends` AS `Friend` LEFT JOIN `users` AS `User` ON (`Friend`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `Friend_Friend` ON (`Friend`.`friend_id` = `Friend_Friend`.`id`) WHERE `Friend`.`user_id`=266 ORDER BY RAND() ASC LIMIT 8001
12SELECT COUNT(*) AS `count` FROM `user_friends` AS `Friend` LEFT JOIN `users` AS `User` ON (`Friend`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `Friend_Friend` ON (`Friend`.`friend_id` = `Friend_Friend`.`id`) WHERE `Friend`.`user_id`=266 111
13SELECT `DishImage`.`id`, `DishImage`.`dish_id`, `DishImage`.`image_id`, `DishImage`.`original_image_id`, `DishImage`.`description`, `DishImage`.`created`, `DishImage`.`modified`, `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created`, `Image`.`id`, `Image`.`user_id`, `Image`.`filepath`, `Image`.`mime_type`, `Image`.`filename`, `Image`.`crop_x`, `Image`.`crop_y`, `Image`.`width`, `Image`.`height`, `Image`.`created`, `Image`.`modified`, `OriginalImage`.`id`, `OriginalImage`.`user_id`, `OriginalImage`.`filepath`, `OriginalImage`.`mime_type`, `OriginalImage`.`filename`, `OriginalImage`.`crop_x`, `OriginalImage`.`crop_y`, `OriginalImage`.`width`, `OriginalImage`.`height`, `OriginalImage`.`created`, `OriginalImage`.`modified` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE `Image`.`user_id` = 266 AND `DishImage`.`id` <> '' ORDER BY `DishImage`.`created` DESC LIMIT 4001
14SELECT `DishSet`.*, `DishSet`.`id` FROM `sets` AS `DishSet` LEFT JOIN `users` AS `User` ON (`DishSet`.`user_id` = `User`.`id`) WHERE `DishSet`.`name` <> "Must Try" AND `DishSet`.`count_dishes` > 0 ORDER BY `DishSet`.`modified` DESC LIMIT 5550