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

    Simply an amazing roll. This is an Uchi classic.

    Comments (0)
  2. Score 10

    Damn. Every time we go to Uchi the freakin' Shag Roll is so freakin' good I can hardly handle it. It's not really a "real sushi eaters" kind of roll but damn, it's good.
    Damn. Love that Shag Roll at Uchi. Gotta have that Shag Roll.

    Comments (1)
    luvr on 02/27/07

    This review was right on!

Loading the map...
Add a new Dish!

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

natanya is seeking
Greasy Spoon Breakfast
in 78732
Know where to find it?

This Week's Divine Dish

Fried Calamari at Apple Annies Cafe Bakery Austin, TX

(dishola_development) 17 queries took 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2SELECT 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
3SELECT 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 110
4SELECT 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 110
5SELECT 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 110
6SELECT `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 5, 52212
7SELECT 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` = 2304 AND `message_public` = 1 110
8SELECT `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` = 2304 AND `message_public` = 1 000
9SELECT 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` = 366 AND `message_public` = 1 110
10SELECT `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` = 366 AND `message_public` = 1 110
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 110
12SELECT `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 220
13SELECT 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 110
14SELECT `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 000
15SELECT 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
16SELECT `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 000
17SELECT `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