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

Momofuku Noodle Bar

  • 3 dishes on Dishola
  • 9.5 is the average score of all their dishes
  • 4 reviews in total
Ginger Scallion at Momofuku Noodle Bar, photo by Mandalina
email to a friend
add to a dish set
9
Avg. Review
Ginger Scallion at Momofuku Noodle Bar

163 1st Ave, New York, NY
(212) 475-7899

Mandalina on 01/08/09

I loved this dish and agree with Laura that it had just the right mix of veggies and noodles. This is the perfect meal for all of you vegetarians out there! more…   [2 reviews]

Tags: ginger  scallion  noodles  cucumber  collard greens  cauliflower  edit
Ramen at Momofuku Noodle Bar, photo by laura
email to a friend
add to a dish set
10
Avg. Review
Ramen at Momofuku Noodle Bar

163 1st Ave, New York, NY
(212) 475-7899

laura on 12/05/08

Yes, indeed; this pork Ramen (also available with chicken) merits a dishola! Why the perfect 10? First, you simply can't beat a heaping, steaming bowl of ramen, loaded with tender pork, rich pork broth, more…   [1 review]

Tags: ramen  pork  noodles  noodle bowl  scallions  broth  edit
Soft Serve Ice Cream at Momofuku Noodle Bar, photo by laura
email to a friend
add to a dish set
Divine Dish
Divine Dish
Soft Serve Ice Cream at Momofuku Noodle Bar

163 1st Ave, New York, NY
(212) 475-7899

laura on 12/05/08

"You've got to get the recipe for this ice cream," my husband urged after his first bite of Momofuku's soft serve Concord Grape-Oatmeal twist. "We'll serve it at our next dinner party." I rolled my more…   [1 review]

Tags: ice cream  soft-serve  oatmeal  Concord grape  granola  edit

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

MrWoo is seeking
Cold Noodles with Sesame Sauce
in Austin, TX
Know where to find it?

This Week's Divine Dish

Screaming Orgasm at Tomo Sushi 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) 26 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2SELECT `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`name_search`, `Restaurant`.`name_dm`, `Restaurant`.`url`, `Restaurant`.`created`, `Restaurant`.`modified` FROM `restaurants` AS `Restaurant` WHERE `Restaurant`.`id` = 1611 LIMIT 1110
3SELECT `Location`.`id`, `Location`.`restaurant_id`, `Location`.`source`, `Location`.`yahoo_id`, `Location`.`yelp_id`, `Location`.`name`, `Location`.`thoroughfare`, `Location`.`locality_name`, `Location`.`sub_administrative_area`, `Location`.`administrative_area`, `Location`.`country_name_code`, `Location`.`postal_code`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`phone1`, `Location`.`phone1_no_format`, `Location`.`phone2`, `Location`.`fax`, `Location`.`closed`, `Location`.`created`, `Location`.`modified` FROM `restaurant_locations` AS `Location` WHERE `Location`.`restaurant_id` = (1611) 111
4SELECT REPLACE(ROUND(AVG(reviews.vote),1), '.0', '') AS vote_avg FROM reviews LEFT JOIN dishes on reviews.dish_id=dishes.id LEFT JOIN restaurant_locations on dishes.location_id=restaurant_locations.id LEFT JOIN restaurants ON restaurant_locations.restaurant_id=restaurants.id WHERE restaurants.id='1611'118
5SELECT COUNT(*) AS vote_count FROM reviews LEFT JOIN dishes on reviews.dish_id=dishes.id LEFT JOIN restaurant_locations on dishes.location_id=restaurant_locations.id LEFT JOIN restaurants ON restaurant_locations.restaurant_id=restaurants.id WHERE restaurants.id='1611'110
6SELECT COUNT(*) AS dish_count FROM dishes LEFT JOIN restaurant_locations on dishes.location_id=restaurant_locations.id LEFT JOIN restaurants ON restaurant_locations.restaurant_id=restaurants.id WHERE restaurants.id='1611'111
7SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name` 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`.`restaurant_id`='1611' AND `Dish`.`disabled`=0 LIMIT 5331
8SELECT `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` IN (2473, 2474, 2477) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 17171
9SELECT `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` IN (2473, 2474, 2477) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 661
10SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1665' LIMIT 1110
11SELECT `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` = (1665) 333
12SELECT 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='2473' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
13SELECT 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='2473' 110
14SELECT `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=2473 ORDER BY `Image`.`created` DESC LIMIT 1110
15SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1665' LIMIT 1110
16SELECT `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` = (1665) 330
17SELECT 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='2474' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
18SELECT 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='2474' 110
19SELECT `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=2474 ORDER BY `Image`.`created` DESC LIMIT 1110
20SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1665' LIMIT 1110
21SELECT `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` = (1665) 330
22SELECT 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='2477' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
23SELECT 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='2477' 110
24SELECT `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=2477 ORDER BY `Image`.`created` DESC LIMIT 1110
25SELECT 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`.`restaurant_id`='1611' AND `Dish`.`disabled`=0 110
26SELECT `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