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 > Austin, TX 78704
Adjust search
Results 1-5 of 30 dishes:
  • Tagged Thai AND
  • Trekking distance from Austin, TX 78704 (aka within 30 miles)
no image add yours
Default Dish Image
email to a friend
add to a dish set
10
Avg. Review
Yellow Curry at 888 Vietnamese Restaurant

2400 E Oltorf St, Austin, TX (2.5 miles away)
(512) 448-4722

mishmash on 09/30/09

A beautiful version of Thai Yellow Curry made by a Vietnamese chef. It's so divinely creamy and aromatic, even the vegetarian tofu version wows! more…   [1 review]

Tags: curry  Thai  asian  tofu  edit
Pad Kee Mao at Titaya's Thai Cuisine, photo by frances
email to a friend
add to a dish set
10
Avg. Review
Pad Kee Mao at Titaya's Thai Cuisine

5501 N Lamar Blvd, Austin, TX (6.1 miles away)
(512) 458-1792

ezh2o on 09/16/09

Titaya's is one of my favorite place's in town period. Try the catfish, or the Green Curry, both will knock your socks off. Even the tried and true fish cakes and Pad Thai are delicious here, and I more…   [2 reviews]

Tags: Pad Kee Mao  Titayas  Thai  asian  bell pepper  spicy  edit
Shrimp Spring Roll at Titaya's Thai Cuisine, photo by frances
email to a friend
add to a dish set
8
Avg. Review
Shrimp Spring Roll at Titaya's Thai Cuisine

5501 N Lamar Blvd, Austin, TX (6.1 miles away)
(512) 458-1792

frances on 09/16/09

The fact that only half of the appetizer dish is featured, since I ate the other half before I realized I should take the picture is enough to let you know that this dish is a good deal! These shrimp more…   [1 review]

Tags: spring roll  Thai  shrimp  asian  edit
no image add yours
Default Dish Image
email to a friend
add to a dish set
10
Avg. Review
#44 - Bun with grilled pork and eggroll at Hai KY

1931 E Oltorf St Ste B, Austin, TX (2.1 miles away)
(512) 693-2464

foodluver on 09/13/09

Very good! One of the best places to get vermicelli in town. Not many places make it this good. This particular entree with grilled pork and eggrolls is the best in my opinion. Delish! more…   [2 reviews]

Tags: Thai  Vietnamese  noodle bowl  edit
Tom Khlong at Madam Mam's Noodles & More, photo by far
email to a friend
add to a dish set
10
Avg. Review
Tom Khlong at Madam Mam's Noodles & More

2700 W Anderson Ln, Austin, TX (8.4 miles away)
(512) 371-9930

far on 07/21/09

The second of two of my favorite dishes at Madam Mam’s is the Tom Khlong (Chicken and rice sticks in hot and spicy soup made of roasted galanga, shallots, thai peppers and garlic mixed with lemongrass, more…   [1 review]

Tags: tom  khlong  Thai  edit

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 61 queries took 342 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`551
12DESCRIBE `safaris`881
13DESCRIBE `dishes_safaris`331
14DESCRIBE `safaris_users`331
15DESCRIBE `sets`16161
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`220
24DESCRIBE `dishes_tags`331
25DESCRIBE `dish_wanteds`881
26DESCRIBE `dish_wanteds_tags`331
27DESCRIBE `dish_wanteds_dishes`330
28DESCRIBE `blogbuzz`25251
29DESCRIBE `blogbuzz_votes`551
30DESCRIBE `blogbuzz_comments`661
31DESCRIBE `blogbuzz_dishes`331
32SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((30.2414*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((30.2414*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-97.7687 - 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 ('thai' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`)) AND `Location`.`longitude` BETWEEN -98.2024014977 AND -97.3349985023 AND `Location`.`latitude` BETWEEN 29.8076985023 AND 30.6751014977 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 555162
33SELECT `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 (3645, 3596, 3595, 1416, 3409) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 20200
34SELECT `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 (3645, 3596, 3595, 1416, 3409) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 550
35SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1136' LIMIT 1110
36SELECT `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` = (1136) 330
37SELECT 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='3645' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,11111
38SELECT 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='3645' 110
39SELECT `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=3645 ORDER BY `Image`.`created` DESC LIMIT 1000
40SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='757' LIMIT 1110
41SELECT `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` = (757) 550
42SELECT 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='3596' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
43SELECT 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='3596' 110
44SELECT `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=3596 ORDER BY `Image`.`created` DESC LIMIT 1110
45SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='757' LIMIT 1110
46SELECT `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` = (757) 550
47SELECT 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='3595' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
48SELECT 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='3595' 110
49SELECT `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=3595 ORDER BY `Image`.`created` DESC LIMIT 1110
50SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='235' LIMIT 1110
51SELECT `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` = (235) 440
52SELECT 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='1416' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
53SELECT 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='1416' 110
54SELECT `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=1416 ORDER BY `Image`.`created` DESC LIMIT 1000
55SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2194' LIMIT 1110
56SELECT `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` = (2194) 440
57SELECT 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='3409' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
58SELECT 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='3409' 110
59SELECT `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=3409 ORDER BY `Image`.`created` DESC LIMIT 1110
60SELECT 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 ('thai' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`)) AND `Location`.`longitude` BETWEEN -98.2024014977 AND -97.3349985023 AND `Location`.`latitude` BETWEEN 29.8076985023 AND 30.6751014977 AND `Dish`.`disabled`=0 11139
61SELECT `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