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
Dishes > NZ
Adjust search
Results 1-1 of 1 dish:
  • Safari distance from NZ (aka within 100 miles)
no image add yours
Default Dish Image
email to a friend
add to a dish set
10
Avg. Review
Chestnut Flour Pappardelle with Porcini Mushrooms, Pistachio, and Gorgonzola at Logan Brown

192 Cuba St, Te Aro, NZ (45.2 miles away)
+64 4 801 5114

abidonfood on 10/19/08

wow, wasn't really sure what to expect based on the description, but it was the only veggie entree on the menu. but it CERTAINLY didn't disappoint... I'm a sucker for fresh pasta and the chestnut more…   [1 review]

Tags: pappardelle  porcini  mushroom  pistachio  gorgonzola  edit

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

diva is seeking
Dishes in Chicago!
in Chicago, IL
Know where to find it?

This Week's Divine Dish

Fried Calamari at Apple Annies Cafe Bakery Austin, TX

Highest Rated Dishes

  1. Screaming Orgasm at Tomo Sushi
  2. Shag Roll at Uchi
  3. Sausage, Ricotta Cheese and Roasted Red Pepper Pizza #6 at Home Slice Pizza
  4. Khuroos-E-Tursh at Clay Pit
  5. Suppli at Enoteca

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 18 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2DESCRIBE `blogbuzz`25251
3DESCRIBE `blogbuzz_votes`551
4DESCRIBE `blogbuzz_comments`661
5DESCRIBE `blogbuzz_dishes`331
6SELECT * FROM locations_lookup WHERE locality_name='Te Aro' AND (administrative_area='NZ' OR country_name_code='NZ') LIMIT 0,1001
7SELECT * FROM locations_lookup WHERE locality_name='Te Aro' LIMIT 0,1001
8SELECT * FROM locations_lookup WHERE country_name_code='NZ' LIMIT 0,1111
9SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((-41*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((-41*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((174 - Location.longitude) * pi()/180)))) * 180/pi()) * 60 * 1.1515) as distance_from_user FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) LEFT JOIN `users` AS `User` ON (`Dish`.`user_id` = `User`.`id`) LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`longitude` BETWEEN 172.554328341 AND 175.445671659 AND `Location`.`latitude` BETWEEN -42.4456716591 AND -39.5543283409 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 5111
10SELECT `Tag`.`id`, `Tag`.`tag`, `DishesTag`.`id`, `DishesTag`.`dish_id`, `DishesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `dishes_tags` AS `DishesTag` ON (`DishesTag`.`dish_id` = 2362 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 550
11SELECT `DishSet`.`id`, `DishSet`.`user_id`, `DishSet`.`name`, `DishSet`.`description`, `DishSet`.`private`, `DishSet`.`location`, `DishSet`.`country_name_code`, `DishSet`.`administrative_area`, `DishSet`.`locality_name`, `DishSet`.`postal_code`, `DishSet`.`latitude`, `DishSet`.`longitude`, `DishSet`.`count_users`, `DishSet`.`count_dishes`, `DishSet`.`created`, `DishSet`.`modified`, `SetsDish`.`id`, `SetsDish`.`set_id`, `SetsDish`.`dish_id`, `SetsDish`.`order`, `SetsDish`.`created`, `SetsDish`.`modified` FROM `sets` AS `DishSet` JOIN `sets_dishes` AS `SetsDish` ON (`SetsDish`.`dish_id` = 2362 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 110
12SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1588' LIMIT 1110
13SELECT `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` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (1588) 110
14SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='2362' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
15SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='2362' 110
16SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` 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 dish_id=2362 ORDER BY `Image`.`created` DESC LIMIT 1000
17SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) LEFT JOIN `users` AS `User` ON (`Dish`.`user_id` = `User`.`id`) LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`longitude` BETWEEN 172.554328341 AND 175.445671659 AND `Location`.`latitude` BETWEEN -42.4456716591 AND -39.5543283409 AND `Dish`.`disabled`=0 111
18SELECT `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