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
dinergalore's Profile
no image add yours
Default Dish Image
email to a friend
add to a dish set
9
Avg. Review
Carne Pibil at Hecho En Mexico

6001 W William Cannon Dr # 301, Austin, TX
(512) 301-0058

dinergalore on 11/17/09

The Carne Pibil at Hecho en Mexico Austin is out of this world! The myriad flavors in this dish blend wonderfully, but also stand out individually as you savor the dish. The bonus, for me, is that this delectable entree comes wrapped in a banana leaf package (it's like a little gift on your plate!)

Tags: traditional  Mexican  edit

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 39 queries took 112 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`23231
2DESCRIBE `profiles`68682
3SET NAMES 'UTF8'00
4DESCRIBE `facebook_connect`771
5DESCRIBE `dishes`20201
6DESCRIBE `restaurant_locations`21211
7DESCRIBE `restaurants`771
8DESCRIBE `featured_dishes`10101
9DESCRIBE `images`11111
10DESCRIBE `reviews`11111
11DESCRIBE `reviewsvotes`881
12DESCRIBE `dish_images`771
13DESCRIBE `dish_image_votes`881
14DESCRIBE `tags`221
15DESCRIBE `dishes_tags`331
16DESCRIBE `safaris`881
17DESCRIBE `dishes_safaris`331
18DESCRIBE `safaris_users`331
19DESCRIBE `dish_wanteds`881
20DESCRIBE `dish_wanteds_tags`331
21DESCRIBE `dish_wanteds_dishes`331
22DESCRIBE `sets`16161
23DESCRIBE `sets_dishes`661
24DESCRIBE `sets_users`771
25DESCRIBE `tokens`771
26DESCRIBE `user_friends`551
27DESCRIBE `bookmarks`551
28SELECT `User`.`id`, `User`.`name`, `User`.`realname`, `User`.`email`, `User`.`password`, `User`.`validated`, `User`.`count_dishes`, `User`.`count_reviews`, `User`.`count_reviews_votes`, `User`.`count_photos`, `User`.`count_must_trys`, `User`.`count_tablemates`, `User`.`count_sets`, `User`.`fb_sig_user`, `User`.`twitter_key`, `User`.`twitter_secret`, `User`.`created`, `User`.`modified`, `User`.`classification`, `User`.`image_150`, `User`.`image_48`, `User`.`image_16`, `User`.`image_normal`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`send_review_notification`, `Profile`.`send_friend_notification`, `Profile`.`send_dishset_notification`, `Profile`.`send_news`, `Profile`.`blogbuzz_100_MI_FROM_AUSTIN`, `Profile`.`blogbuzz_100_MI_FROM_SF`, `Profile`.`location`, `Profile`.`location_string`, `Profile`.`country_name_code`, `Profile`.`administrative_area`, `Profile`.`locality_name`, `Profile`.`postal_code`, `Profile`.`latitude`, `Profile`.`longitude`, `Profile`.`birthday`, `Profile`.`icon`, `Profile`.`views`, `Profile`.`about`, `Profile`.`reviews_sort`, `Profile`.`casual_strangest`, `Profile`.`passionate_classes`, `Profile`.`passionate_festivals`, `Profile`.`passionate_entertain`, `Profile`.`passionate_hottest`, `Profile`.`passionate_safari`, `Profile`.`passionate_cook`, `Profile`.`professional_ever`, `Profile`.`passionate_strangest`, `Profile`.`professional_exp_manager`, `Profile`.`professional_exp_host`, `Profile`.`professional_exp_waiter`, `Profile`.`professional_exp_sommelier`, `Profile`.`professional_exp_prep`, `Profile`.`professional_exp_line`, `Profile`.`professional_exp_sous`, `Profile`.`professional_exp_pastry`, `Profile`.`professional_exp_chef`, `Profile`.`professional_exp_teach`, `Profile`.`professional_exp_cater`, `Profile`.`professional_exp_owner`, `Profile`.`professional_exp_investor`, `Profile`.`professional_exp_behind`, `Profile`.`professional_exp_other`, `Profile`.`professional_school`, `Profile`.`writing_ever`, `Profile`.`professional_blog`, `Profile`.`professional_books`, `Profile`.`professional_critic`, `Profile`.`industry_currently`, `Profile`.`created`, `Profile`.`timestamp`, `Profile`.`favorite_cuisine`, `Profile`.`last_meal_request`, `Profile`.`favorite_eating_town`, `Profile`.`recommended_food_safari`, `Profile`.`and_to_drink`, `Profile`.`fantasy_tablemates`, `Profile`.`tip_motto_quote`, `Profile`.`tip_motto_quote_top`, `Profile`.`tip_motto_quote_left`, `Profile`.`header_image`, `Profile`.`last_login`, `Profile`.`modified`, `Profile`.`image_small`, `Profile`.`image`, `Profile`.`twitter_auto_review`, `FacebookConnect`.`id`, `FacebookConnect`.`user_id`, `FacebookConnect`.`fb_sig_user`, `FacebookConnect`.`fb_sig_session_key`, `FacebookConnect`.`share_item`, `FacebookConnect`.`created`, `FacebookConnect`.`modified` FROM `users` AS `User` LEFT JOIN `profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `facebook_connect` AS `FacebookConnect` ON (`FacebookConnect`.`user_id` = `User`.`id`) WHERE `User`.`name` = 'dinergalore' LIMIT 1111
29SELECT `Blogbuzz`.`id`, `Blogbuzz`.`user_id`, `Blogbuzz`.`editor_user_id`, `Blogbuzz`.`title`, `Blogbuzz`.`editor_blurb`, `Blogbuzz`.`short_blurb`, `Blogbuzz`.`long_blurb`, `Blogbuzz`.`source_name`, `Blogbuzz`.`source_url`, `Blogbuzz`.`source_publish_date`, `Blogbuzz`.`publish_date`, `Blogbuzz`.`location`, `Blogbuzz`.`location_string`, `Blogbuzz`.`country_name_code`, `Blogbuzz`.`administrative_area`, `Blogbuzz`.`locality_name`, `Blogbuzz`.`postal_code`, `Blogbuzz`.`latitude`, `Blogbuzz`.`longitude`, `Blogbuzz`.`photo_large_id`, `Blogbuzz`.`photo_small_id`, `Blogbuzz`.`photo_credit`, `Blogbuzz`.`disabled`, `Blogbuzz`.`created`, `Blogbuzz`.`modified` FROM `blogbuzz` AS `Blogbuzz` WHERE `Blogbuzz`.`user_id` = (2414) 001
30SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (SELECT (user_id) FROM reviews WHERE reviews.dish_id=Dish.id AND user_id='2414') AS reviewed_by_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 `Dish`.`disabled`=0 HAVING reviewed_by_user='2414' ORDER BY `last_review_date` DESC LIMIT 51130
31SELECT `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` = 3827 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 220
32SELECT `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` = 3827 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
33SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2414' LIMIT 1110
34SELECT `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` = (2414) 110
35SELECT 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='3827' AND reviews.user_id='2414' AND reviews.disabled=0 LIMIT 0,1110
36SELECT 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='3827' 110
37SELECT `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=3827 ORDER BY `Image`.`created` DESC LIMIT 1000
38SELECT COUNT(*) AS count, (SELECT (user_id) FROM reviews WHERE reviews.dish_id=Dish.id AND user_id='2414') AS reviewed_by_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 Dish.disabled=0 GROUP BY reviewed_by_user HAVING reviewed_by_user='2414'1153
39SELECT `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