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 > Santa Rosa, CA
Adjust search
Results 1-5 of 21 dishes:
  • Trekking distance from Santa Rosa, CA (aka within 30 miles)
Small Sirloin at Cattlemen's, photo by kblood
email to a friend
add to a dish set
6
Avg. Review
Small Sirloin at Cattlemen's

5012 Petaluma Blvd N, Petaluma, CA (16.8 miles away)
(707) 763-4114

kblood on 10/05/09

The Small Sirloin at the Cattlemens is a great deal -- $16 bucks for a nice hunk of meat (cooked exactly to order), served with a sour cream-studded baked potato, "all you can eat salad" and hot-out-of-the-oven more…   [1 review]

Tags: steak  beef  Cattlemens  Petaluma  california  edit
Japanese Bluefish Tuna with Yukon Gold Potato, Niçoise Olives, Pickled Pearl Onion and Jirdori Hen Egg Emulsion at The French Laundry, photo by kblood
email to a friend
add to a dish set
8
Avg. Review
Japanese Bluefish Tuna with Yukon Gold Potato, Niçoise Olives, Pickled Pearl Onion and Jirdori Hen Egg Emulsion at The French Laundry

6640 Washington St, Yountville, CA (22.5 miles away)
(707) 944-2380

kblood on 09/09/09

The perfectly crisp little potato balls and Niçoise Olives were, in my opinion, the best parts of this dish. more…   [1 review]

Tags: tuna  French  laundry  olives  edit
Cornets at The French Laundry, photo by kblood
email to a friend
add to a dish set
10
Avg. Review
Cornets at The French Laundry

6640 Washington St, Yountville, CA (22.5 miles away)
(707) 944-2380

kblood on 09/07/09

The now classic amuse-bouche of Salmon Tartare with Sweet Red Onion Crème Fraîche as shown in The French Laundry Cookbook (pages 6-7). One bite of extreme pleasure: crunchy, smooth, lemony and salty more…   [1 review]

Tags: amuse-bouche  salmon  French  laundry  lemon  edit
Gougères at The French Laundry, photo by kblood
email to a friend
add to a dish set
9
Avg. Review
Gougères at The French Laundry

6640 Washington St, Yountville, CA (22.5 miles away)
(707) 944-2380

kblood on 09/07/09

Gougère: an amuse-bouche made with Gruyère cheese. These hot cheese puffs were much smaller than what I've made / been served in the past. One marble-size piece was offered for each person. Every piece more…   [1 review]

Tags: French  laundry  restaurants  gougere  cheese  gruyere  amuse-bouche  napa  california  edit
The Chicken Skillet Breakfast at Gillwoods Cafe Saint Helena, photo by scottysauce
email to a friend
add to a dish set
10
Avg. Review
The Chicken Skillet Breakfast at Gillwoods Cafe Saint Helena

1313 Main St, St Helena, CA (15.8 miles away)
(707) 963-1788

scottysauce on 08/24/09

i decided to order the chicken skillet breakfast for $11.90 and as soon as i saw this presented in front of my my mouth dropped. this skillet was huge and piled high with layers of diced potatoes, mushrooms, more…   [1 review]

Tags: breakfast  cafe  cheese  CHEKEN  breast  eggs  napa  skillet  ST  HELENA  veggies  wine  Country  edit

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 61 queries took 44 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`553
12DESCRIBE `safaris`881
13DESCRIBE `dishes_safaris`335
14DESCRIBE `safaris_users`331
15DESCRIBE `sets`16163
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`221
24DESCRIBE `dishes_tags`331
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 `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((38.5021*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((38.5021*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-122.7619 - 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 -123.195601498 AND -122.328198502 AND `Location`.`latitude` BETWEEN 38.0683985023 AND 38.9358014977 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 5553
33SELECT `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 (3653, 3576, 3569, 3566, 3527) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 36361
34SELECT `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 (3653, 3576, 3569, 3566, 3527) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
35SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2311' LIMIT 1110
36SELECT `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` = (2311) 110
37SELECT 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='3653' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
38SELECT 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='3653' 110
39SELECT `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=3653 ORDER BY `Image`.`created` DESC LIMIT 1110
40SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1171' LIMIT 1110
41SELECT `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` = (1171) 440
42SELECT 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='3576' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
43SELECT 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='3576' 110
44SELECT `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=3576 ORDER BY `Image`.`created` DESC LIMIT 1110
45SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1171' LIMIT 1110
46SELECT `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` = (1171) 440
47SELECT 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='3569' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
48SELECT 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='3569' 110
49SELECT `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=3569 ORDER BY `Image`.`created` DESC LIMIT 1110
50SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1171' LIMIT 1110
51SELECT `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` = (1171) 440
52SELECT 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='3566' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
53SELECT 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='3566' 110
54SELECT `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=3566 ORDER BY `Image`.`created` DESC LIMIT 1110
55SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2243' LIMIT 1110
56SELECT `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` = (2243) 110
57SELECT 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='3527' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
58SELECT 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='3527' 110
59SELECT `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=3527 ORDER BY `Image`.`created` DESC LIMIT 1110
60SELECT 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 -123.195601498 AND -122.328198502 AND `Location`.`latitude` BETWEEN 38.0683985023 AND 38.9358014977 AND `Dish`.`disabled`=0 111
61SELECT `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