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 > Litchfield, CT
Adjust search
Results 1-5 of 6 dishes:
  • Trekking distance from Litchfield, CT (aka within 30 miles)
Butternut Squash Ravioli at at the corner, photo by jacque
email to a friend
add to a dish set
9
Avg. Review
Butternut Squash Ravioli at at the corner

3 West St, Litchfield, CT, 06759 (1.5 miles away)

jacque on 09/29/09

Colossal raviolis - quite possibly homemade - filled with slightly sweet butternut squash mixture. Topped with sage beurre blanc sauce and amaretto biscotti crumbs - tastes like Thanksgiving! more…   [1 review]

Tags: butternut  squash  vegetarian  ravioli  beurre blanc  sage  biscotti  edit
Sunday Supper Part 2 - Actually this is the Appetizer at Stagecoach Tavern, photo by jacque
email to a friend
add to a dish set
9
Avg. Review
Sunday Supper Part 2 - Actually this is the Appetizer at Stagecoach Tavern

854 S Undermountain Rd, Sheffield, MA (24.9 miles away)
(413) 229-8585

jacque on 07/09/09

You just can't beat farm to plate produce and this soup made full advantage of nature's bounty. Chilled puree of three spring greens - I have no idea which ones - velvety smooth and light. Accompanied more…   [1 review]

Tags: soup  green  spring  radish  mojito  strawberries  mint  vegetarian  edit
Sunday Supper at Stagecoach Tavern, photo by jacque
email to a friend
add to a dish set
10
Avg. Review
Sunday Supper at Stagecoach Tavern

854 S Undermountain Rd, Sheffield, MA (24.9 miles away)
(413) 229-8585

jacque on 07/09/09

First of all this place is all you could want in a colonial inn - dark wood, fireplace, stiff drinks and a painting of Napoleon. On Sundays - most other times too - pretty much the entire menu is locally more…   [1 review]

Tags: organic  local  polenta  shitake  arugula  eggs  vegetarian  edit
Little John (PB&J) Sandwich at Harney and Sons: The Store, photo by jacque
email to a friend
add to a dish set
10
Avg. Review
Little John (PB&J) Sandwich at Harney and Sons: The Store

13 Main St, 1 Railroad Plaza, Millerton, NY (20.4 miles away)
(518) 789-2121

jacque on 04/25/09

Peanut butter and jelly sandwiches make me feel like I'm getting away with something - like playing hooky or seeing a film in the afternoon. This one is particularly giddy/guilt inducing - smooth (they more…   [1 review]

Tags: peanut  butter  jelly  multi-grain bread  edit
Ricotta Gnocchi at John Andrews Restaurant, photo by jacque
email to a friend
add to a dish set
8
Avg. Review
Ricotta Gnocchi at John Andrews Restaurant

Rte 23, Egremont, MA (30.4 miles away)
(413) 528-3469

jacque on 01/26/09

We had some trouble finding this place so I was HUNGRY by the time we sat down. Good thing the portions could feed a family of four if they left one kid at home. Huge, plump gnocchi made of ricotta and more…   [1 review]

Tags: vegetarian  pasta  gnocchi  spinach  ricotta  brown butter  Parmesan  sage  edit

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

bighousepink is seeking
sunchokes in a dish
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) 58 queries took 65 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`883
13DESCRIBE `dishes_safaris`332
14DESCRIBE `safaris_users`331
15DESCRIBE `sets`16162
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
28SELECT * FROM locations_lookup WHERE locality_name='Litchfield' AND (administrative_area='CT' OR country_name_code='CT') LIMIT 0,11126
29SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((41.7559*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((41.7559*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-73.2154 - 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 -73.6491014977 AND -72.7816985023 AND `Location`.`latitude` BETWEEN 41.3221985023 AND 42.1896014977 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 5552
30SELECT `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 (3635, 3363, 3362, 3190, 2900) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 34340
31SELECT `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 (3635, 3363, 3362, 3190, 2900) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
32SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2304' LIMIT 1110
33SELECT `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` = (2304) 110
34SELECT 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='3635' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
35SELECT 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='3635' 110
36SELECT `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=3635 ORDER BY `Image`.`created` DESC LIMIT 1110
37SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2183' LIMIT 1110
38SELECT `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` = (2183) 220
39SELECT 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='3363' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
40SELECT 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='3363' 110
41SELECT `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=3363 ORDER BY `Image`.`created` DESC LIMIT 1110
42SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2183' LIMIT 1110
43SELECT `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` = (2183) 220
44SELECT 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='3362' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
45SELECT 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='3362' 110
46SELECT `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=3362 ORDER BY `Image`.`created` DESC LIMIT 1110
47SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2083' LIMIT 1110
48SELECT `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` = (2083) 110
49SELECT 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='3190' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
50SELECT 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='3190' 110
51SELECT `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=3190 ORDER BY `Image`.`created` DESC LIMIT 1110
52SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1947' LIMIT 1110
53SELECT `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` = (1947) 110
54SELECT 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='2900' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
55SELECT 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='2900' 110
56SELECT `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=2900 ORDER BY `Image`.`created` DESC LIMIT 1110
57SELECT 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 -73.6491014977 AND -72.7816985023 AND `Location`.`latitude` BETWEEN 41.3221985023 AND 42.1896014977 AND `Dish`.`disabled`=0 111
58SELECT `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