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

Teo

http://www.caffeteo.com/
  • 2 dishes on Dishola
  • 10 is the average score of all their dishes
  • 2 reviews in total
PB & Nutella Gelato at Teo, photo by laura
email to a friend
add to a dish set
Divine Dish
Divine Dish
PB & Nutella Gelato at Teo

1206 W 38th St, Austin, TX
(512) 451-9555

laura on 06/09/08

Peanut butter and nutella. I mean, is there a BETTER combination? I could eat this gelato by the gallon. It's so creamy...so smooth. Think pure cool, silky sweetness on your tongue. And the rich, buttery more…   [1 review]

Tags: peanut butter  nutella  gelato  edit
Salted Carmel Gelato at Teo, photo by laura
email to a friend
add to a dish set
10
Avg. Review
Salted Carmel Gelato at Teo

1206 W 38th St, Austin, TX
(512) 451-9555

laura on 05/30/08

Honestly, folks. Does it get any better on a hot Austin summer afternoon than relishing each lick of a large, dripping scoop of salty caramel gelato? This gelato has the taste and smooth texture of more…   [1 review]

Tags: salt  caramel  gelato  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

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) 21 queries took 18 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` = 1377 LIMIT 1110
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` = (1377) 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='1377'111
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='1377'111
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='1377'110
7SELECT `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 `Location`.`restaurant_id`='1377' AND `Dish`.`disabled`=0 LIMIT 5221
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 (2007, 2024) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 6614
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 (2007, 2024) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 881
10SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1394' 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` = (1394) 220
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='2007' 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='2007' 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=2007 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`='1394' 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` = (1394) 220
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='2024' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
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='2024' 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=2024 ORDER BY `Image`.`created` DESC LIMIT 1110
20SELECT 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`='1377' AND `Dish`.`disabled`=0 110
21SELECT `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