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

Uchi

http://www.uchiaustin.com/
  • 33 dishes on Dishola
  • 8.9 is the average score of all their dishes
  • 48 reviews in total
Crudo at Uchi, photo by far
Avg. Review
Crudo at Uchi

801 S Lamar Blvd, Austin, TX (1.1 miles away)
(512) 916-4808

Anything at Uchi has been great, but the Crudo, sea bass with orange oil, is fragrantly haunting. more…   [2 reviews]

Tags: sea  bass  edit
Okashi at Uchi, photo by far
Avg. Review
Okashi at Uchi

801 S Lamar Blvd, Austin, TX (1.1 miles away)
(512) 916-4808

Okashi: Chocolate wasabi fondant, pistachio sorbet, orange crisp .... I don’t like chocolate, so I didn’t taste this, but I had to take a picture nonetheless. more…   [1 review]

Tags: chocolate  pistachio  orange  edit
Jizake Crème Caramel with brown butter sorbet and ginger consommé at Uchi, photo by far
Avg. Review
Jizake Crème Caramel with brown butter sorbet and ginger consommé at Uchi

801 S Lamar Blvd, Austin, TX (1.1 miles away)
(512) 916-4808

The Crème Caramel is always good. The ginger consommé gives another dimension of flavors that makes it delicious. more…   [1 review]

Tags: creme  caramel  ginger  sorbet  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

(dishola_development) 26 queries took 35 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` = 248 LIMIT 11112
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` = (248) 110
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='248'112
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='248'1115
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='248'110
7SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((30.242831*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((30.242831*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-97.765788 - 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`.`restaurant_id`='248' AND `Dish`.`disabled`=0 LIMIT 30, 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 (3418, 3419, 3420) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 991
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 (3418, 3419, 3420) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 771
10SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='231' 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` = (231) 33330
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='3418' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
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='3418' 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=3418 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`='231' 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` = (231) 33330
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='3419' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
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='3419' 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=3419 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`='231' 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` = (231) 33330
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='3420' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
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='3420' 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=3420 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`='248' AND `Dish`.`disabled`=0 111
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