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 > TH
Adjust search
Results 1-1 of 1 dish:
  • Safari distance from TH (aka within 100 miles)
no image add yours
Default Dish Image
email to a friend
add to a dish set
10
Avg. Review
Weeping Tiger (Seua Rong Hai) at The Atlanta

Soi 2, Sukhumvit Road, Bangkok, TH (85.9 miles away)
+66-2 656 8123

embyorg on 01/16/08

Also known as Tiger Cry. This dish is so amazingly fabulous. No other dish Thai or otherwise will ever compare. I had to beg the stern, mother-henish restaurant Tzaress over a series of weeks to tell more…   [1 review]

Tags: beef  rice  nutty  lime  garlic  edit

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

bighousepink is seeking
sunchokes in a dish
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) 40 queries took 48 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `dishes`20201
2DESCRIBE `users`23231
3DESCRIBE `profiles`68683
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`221
24DESCRIBE `dishes_tags`331
25DESCRIBE `dish_wanteds`881
26DESCRIBE `dish_wanteds_tags`331
27DESCRIBE `dish_wanteds_dishes`331
28SELECT * FROM locations_lookup WHERE locality_name='Ko Tao' AND (administrative_area='TH' OR country_name_code='TH') LIMIT 0,1004
29SELECT * FROM locations_lookup WHERE locality_name='Ko Tao' LIMIT 0,1001
30SELECT * FROM locations_lookup WHERE country_name_code='TH' LIMIT 0,11110
31SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((15*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((15*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((100 - 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`.`longitude` BETWEEN 98.5543283409 AND 101.445671659 AND `Location`.`latitude` BETWEEN 13.5543283409 AND 16.4456716591 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 5111
32SELECT `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` = 1466 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 550
33SELECT `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` = 1466 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
34SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1046' LIMIT 1111
35SELECT `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` = (1046) 110
36SELECT 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='1466' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
37SELECT 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='1466' 111
38SELECT `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=1466 ORDER BY `Image`.`created` DESC LIMIT 1001
39SELECT 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`.`longitude` BETWEEN 98.5543283409 AND 101.445671659 AND `Location`.`latitude` BETWEEN 13.5543283409 AND 16.4456716591 AND `Dish`.`disabled`=0 110
40SELECT `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