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 > Montclair, CA
Adjust search
Results 1-5 of 20 dishes:
  • Trekking distance from Montclair, CA (aka within 30 miles)
Dry Aged NY Steak at Napa Rose Restaurant, photo by scottysauce
email to a friend
add to a dish set
10
Avg. Review
Dry Aged NY Steak at Napa Rose Restaurant

1600 S Disneyland Dr, Anaheim, CA (22.2 miles away)
(714) 300-7170

scottysauce on 08/24/09

black pepper roasted "45-day aged" brandt beef new york with cheddar & chive yorkshire pudding, roasted parsnips and horseradish creme. with the very first bite of steak it just seemed to melt in my mouth. more…   [1 review]

Tags: bakery  bread  BUDDAHS  HAND  disneyland  DRY  AGED  new  YORK  steak  duck  confit  lobster  pot  pie  napa  rose  SKATE  wing  veal  SWEETBREADS  YORKSHIRE  pudding  edit
Lobster Pot Pie at Napa Rose Restaurant, photo by scottysauce
email to a friend
add to a dish set
9
Avg. Review
Lobster Pot Pie at Napa Rose Restaurant

1600 S Disneyland Dr, Anaheim, CA (22.2 miles away)
(714) 300-7170

scottysauce on 08/24/09

lobster pot pie with veal sweetbreads, celeriac puree, butternut squash and lobster essence. this definitely wasn't your typical tv dinner pot pie for sure. it was a smaller serving but with all the food more…   [1 review]

Tags: bakery  bread  BUDDAHS  HAND  disneyland  DRY  AGED  new  YORK  steak  duck  confit  lobster  pot  pie  napa  rose  SKATE  wing  veal  SWEETBREADS  YORKSHIRE  pudding  edit
Corn Bread Crusted Skate Wing at Napa Rose Restaurant, photo by scottysauce
email to a friend
add to a dish set
9
Avg. Review
Corn Bread Crusted Skate Wing at Napa Rose Restaurant

1600 S Disneyland Dr, Anaheim, CA (22.2 miles away)
(714) 300-7170

scottysauce on 08/24/09

cornbread crusted skate wing with nantucket scallops, cranberry bean puree with bacon, chantrelle butter and "buddah's hand" citron. i had never had skate wing before and had never seen it on any menu more…   [1 review]

Tags: bakery  bread  BUDDAHS  HAND  disneyland  DRY  AGED  new  YORK  steak  duck  confit  lobster  pot  pie  napa  rose  SKATE  wing  veal  SWEETBREADS  YORKSHIRE  pudding  edit
Complimentary Selection of Bread at Napa Rose Restaurant, photo by scottysauce
email to a friend
add to a dish set
8
Avg. Review
Complimentary Selection of Bread at Napa Rose Restaurant

1600 S Disneyland Dr, Anaheim, CA (22.2 miles away)
(714) 300-7170

scottysauce on 08/24/09

the bread they offered was really top notch and i really wanted to eat it all up but i just had to save room for our meal. even the butter had a sweet touch with some fresh rosemary. they had country more…   [1 review]

Tags: Country  white  rolls  sun  dried  tomato  wheat  napa  rose  disneyland  california  grand  sourdough  garlic  crisps  edit
Bone-In Rib Eye Steak at Steakhouse 55, photo by scottysauce
email to a friend
add to a dish set
10
Avg. Review
Bone-In Rib Eye Steak at Steakhouse 55

1150 W Magic Way, Anaheim, CA (22.2 miles away)
(714) 956-6402

scottysauce on 08/24/09

when my steak arrived by cart my eyes were as big as a virgin in a strip club. my ribeye was so huge and cooked to a perfect medium rare. at $36 this 18 ounce masterpiece looked well worth it. it had more…   [1 review]

Tags: BROILED  disneyland  hotel  DRY  RUB  FLAVOR  grilled  juicy  lobster  TAIL  rib  EYE  steak  steakhouse  tender  edit

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 62 queries took 54 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `dishes`20201
2DESCRIBE `users`23231
3DESCRIBE `profiles`68682
4SET NAMES 'UTF8'00
5DESCRIBE `facebook_connect`771
6DESCRIBE `reviews`11111
7DESCRIBE `reviewsvotes`881
8DESCRIBE `images`11111
9DESCRIBE `tokens`771
10DESCRIBE `user_friends`551
11DESCRIBE `bookmarks`551
12DESCRIBE `safaris`881
13DESCRIBE `dishes_safaris`331
14DESCRIBE `safaris_users`330
15DESCRIBE `sets`16161
16DESCRIBE `sets_dishes`661
17DESCRIBE `sets_users`771
18DESCRIBE `restaurant_locations`21211
19DESCRIBE `restaurants`771
20DESCRIBE `featured_dishes`10101
21DESCRIBE `dish_images`771
22DESCRIBE `dish_image_votes`881
23DESCRIBE `tags`220
24DESCRIBE `dishes_tags`338
25DESCRIBE `dish_wanteds`881
26DESCRIBE `dish_wanteds_tags`331
27DESCRIBE `dish_wanteds_dishes`331
28DESCRIBE `blogbuzz`25251
29DESCRIBE `blogbuzz_votes`551
30DESCRIBE `blogbuzz_comments`661
31DESCRIBE `blogbuzz_dishes`331
32SELECT * FROM locations_lookup WHERE locality_name='Montclair' AND (administrative_area='CA' OR country_name_code='CA') LIMIT 0,11111
33SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((34.071*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((34.071*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-117.701 - 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 -118.134701498 AND -117.267298502 AND `Location`.`latitude` BETWEEN 33.6372985023 AND 34.5047014977 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 5553
34SELECT `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 (3521, 3520, 3519, 3518, 3517) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 99992
35SELECT `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 (3521, 3520, 3519, 3518, 3517) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 001
36SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2237' LIMIT 1110
37SELECT `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` = (2237) 440
38SELECT 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='3521' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
39SELECT 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='3521' 110
40SELECT `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=3521 ORDER BY `Image`.`created` DESC LIMIT 1110
41SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2237' LIMIT 1110
42SELECT `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` = (2237) 440
43SELECT 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='3520' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
44SELECT 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='3520' 110
45SELECT `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=3520 ORDER BY `Image`.`created` DESC LIMIT 1110
46SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2237' LIMIT 1110
47SELECT `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` = (2237) 440
48SELECT 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='3519' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
49SELECT 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='3519' 110
50SELECT `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=3519 ORDER BY `Image`.`created` DESC LIMIT 1110
51SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2237' LIMIT 1110
52SELECT `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` = (2237) 440
53SELECT 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='3518' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
54SELECT 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='3518' 110
55SELECT `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=3518 ORDER BY `Image`.`created` DESC LIMIT 1110
56SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2236' LIMIT 1110
57SELECT `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` = (2236) 110
58SELECT 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='3517' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
59SELECT 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='3517' 110
60SELECT `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=3517 ORDER BY `Image`.`created` DESC LIMIT 1110
61SELECT 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 -118.134701498 AND -117.267298502 AND `Location`.`latitude` BETWEEN 33.6372985023 AND 34.5047014977 AND `Dish`.`disabled`=0 111
62SELECT `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