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
Shag Roll at Uchi, photo by laura
share on facebook
Avg. Review
Shag Roll
Uchi

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

Tags: sushi  edit
dish it - add your review today!
score Order by: review date
  1. Score 10

    If you have never tried this roll you need to stop what you're doing and go straight to Uchi right now. The eel sauce they put on top of it is the perfect compliment to the roll itself. It's incredible!

    Comments (0)
  2. Score 10

    This is seriously one of the best sushi rolls ever. Sometimes I order 3 of these per visit.

    Comments (0)
  3. Score 10

    The unique texture and combination of flavors make this the best sushi roll I’ve ever had.

    Comments (0)
  4. Score 10

    Oh mommy. Seriously, people. This is the best sushi roll and a MUST for anyone that goes to Uchi. We normally order one to start our meal with and then one to finish our meal. Enjoy!

    Comments (2)
    laura on 01/06/09

    Hiya Liz, is this you? I hope so! Thanks so much for writing a dish review...we really appreciate it! We are so far from our dish-for-dish goal right now...but I'm going on Fox News tomorrow to remedy that. HA! Only for dishola...you couldn't drag me on to Fox otherwise, but hey, it's free publicity. More soon.. xoxo Laura

    islandgirl on 05/31/09

    I agree--this is my favorite roll at Uchi every time I go. I even took out of town guests and my friend emailed me after she got home to find out what kind of sauce it was. Incredible!

  5. Score 10

    I am drooling on my computer

    Comments (0)
Loading the map...
Add a new Dish!

(dishola_development) 32 queries took 90 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2SELECT `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 `Dish`.`id` = 308 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5115
3SELECT `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` = 308 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 111
4SELECT `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` = 308 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 440
5SELECT `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
6SELECT `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
7SELECT 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='308' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,11132
8SELECT 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='308' 1111
9SELECT `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=308 ORDER BY `Image`.`created` DESC LIMIT 1118
10SELECT 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 `Dish`.`id` = 308 AND disabled=0 AND `Dish`.`disabled`=0 111
11SELECT 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 `Review`.`dish_id` = 308 111
12SELECT COUNT(*) AS `count` 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 `DishImage`.`dish_id` = 308 111
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` = 308 115
14SELECT COUNT(*) AS `count` 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` = 308 111
15SELECT `Review`.*, `User`.* FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) WHERE `Review`.`dish_id` = 308 ORDER BY `Review`.`created` DESC LIMIT 5551
16SELECT COUNT(*) AS `count` FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 4441 AND `message_public` = 1 110
17SELECT `Reviewsvote`.*, `User`.* FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 4441 AND `message_public` = 1 000
18SELECT COUNT(*) AS `count` FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 4407 AND `message_public` = 1 110
19SELECT `Reviewsvote`.*, `User`.* FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 4407 AND `message_public` = 1 000
20SELECT COUNT(*) AS `count` FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 4209 AND `message_public` = 1 110
21SELECT `Reviewsvote`.*, `User`.* FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 4209 AND `message_public` = 1 000
22SELECT COUNT(*) AS `count` FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 3101 AND `message_public` = 1 1117
23SELECT `Reviewsvote`.*, `User`.* FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 3101 AND `message_public` = 1 222
24SELECT COUNT(*) AS `count` FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 2329 AND `message_public` = 1 110
25SELECT `Reviewsvote`.*, `User`.* FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 2329 AND `message_public` = 1 000
26SELECT 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 `Review`.`dish_id` = 308 110
27SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id`, `DishImage`.`dish_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 `DishImage`.`dish_id` = 308 ORDER BY `Image`.`created` DESC 221
28SELECT COUNT(*) AS `count` FROM `dish_image_votes` AS `DishImageVote` LEFT JOIN `dish_images` AS `DishImage` ON (`DishImageVote`.`dish_image_id` = `DishImage`.`id`) LEFT JOIN `users` AS `User` ON (`DishImageVote`.`user_id` = `User`.`id`) WHERE `dish_image_id` = 1065 111
29SELECT `DishImageVote`.*, `User`.* FROM `dish_image_votes` AS `DishImageVote` LEFT JOIN `dish_images` AS `DishImage` ON (`DishImageVote`.`dish_image_id` = `DishImage`.`id`) LEFT JOIN `users` AS `User` ON (`DishImageVote`.`user_id` = `User`.`id`) WHERE `dish_image_id` = 1065 001
30SELECT COUNT(*) AS `count` FROM `dish_image_votes` AS `DishImageVote` LEFT JOIN `dish_images` AS `DishImage` ON (`DishImageVote`.`dish_image_id` = `DishImage`.`id`) LEFT JOIN `users` AS `User` ON (`DishImageVote`.`user_id` = `User`.`id`) WHERE `dish_image_id` = 1064 110
31SELECT `DishImageVote`.*, `User`.* FROM `dish_image_votes` AS `DishImageVote` LEFT JOIN `dish_images` AS `DishImage` ON (`DishImageVote`.`dish_image_id` = `DishImage`.`id`) LEFT JOIN `users` AS `User` ON (`DishImageVote`.`user_id` = `User`.`id`) WHERE `dish_image_id` = 1064 001
32SELECT `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