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
hamburgler's Profile

Kong me.

hamburgler

hamburgler (Billy)

  • Last Login:
    June 3, 2009
  • Member Since:
    December 12, 2007
  • Homebase:
    Austin, TX
  • Profile URL:
  • Profile Views:
    2738
Add hamburgler to your Tablemates
Tablemates
Latest Reviews
more ...

About hamburgler

I live in my mom's basement. I play Donkey Kong. What ever happened to the QT Squart? Do you smell that? Who wants to be my girlfriend? Hey, Swayze-How's it going? (What a loser). Anyway, I have the high score. Where's my Motorhead tape? I once punched Harry Knowles in the neck and my hand still smells like it.

Foodie Fetishes

  • Recommended Food Safari: Hill-berts on South Lamar. Get the fries, dude.
  • And to Drink: Vanilla Shake
  • Your Fantasy Tablemates: Bill Shatner. I love the Shat.
  • Favorite Cuisine: Ground meat with cheese. And pork fritters. You Johnny Rebs have no idea...
  • Last Meal Request: Pizza Hut taco pizza refrigerated overnight and then reheated in the oven. Before you judge me, try it first.
  • Favorite Eating Town: Austin, jackass.

Industry Experience

  • Host/Hostess
  • Waiter/Waitress
  • Prep Cook
  • Behind the scenes (PR, Accounting, etc...)

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 78 queries took 66 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`111110
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
28DESCRIBE `blogbuzz`25251
29DESCRIBE `blogbuzz_votes`551
30DESCRIBE `blogbuzz_comments`661
31DESCRIBE `blogbuzz_dishes`330
32SELECT `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` = 'hamburgler' LIMIT 1111
33SELECT `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` = (652) 000
34SELECT COUNT(*) AS `count` FROM `profiles` AS `Profile` WHERE `Profile`.`id` = 644 110
35UPDATE `profiles` SET `id` = 644, `user_id` = 652, `views` = 2739, `modified` = '2012-05-24 20:29:58' WHERE `profiles`.`id` = 64412
36SELECT `Profile`.* FROM `profiles` AS `Profile` LEFT JOIN `users` AS `User` ON (`Profile`.`user_id` = `User`.`id`) WHERE `Profile`.`id` = 644 LIMIT 1110
37SELECT `Friend_Friend`.* FROM `user_friends` AS `Friend` LEFT JOIN `users` AS `User` ON (`Friend`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `Friend_Friend` ON (`Friend`.`friend_id` = `Friend_Friend`.`id`) WHERE `Friend`.`user_id`=652 ORDER BY RAND() ASC LIMIT 8440
38SELECT `User`.`id`, `User`.`name`, `User`.`realname`, `User`.`email`, `User`.`created`, `User`.`classification`, `User`.`image_150`, `User`.`image_48`, `User`.`image_16`, `Profile`.`views` 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`.`id` = 637 LIMIT 1110
39SELECT COUNT(*) AS `count` FROM `user_friends` AS `Friend` LEFT JOIN `users` AS `User` ON (`Friend`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `Friend_Friend` ON (`Friend`.`friend_id` = `Friend_Friend`.`id`) WHERE `Friend`.`user_id`=652 110
40SELECT `DishImage`.`id`, `DishImage`.`dish_id`, `DishImage`.`image_id`, `DishImage`.`original_image_id`, `DishImage`.`description`, `DishImage`.`created`, `DishImage`.`modified`, `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`, `Image`.`id`, `Image`.`user_id`, `Image`.`filepath`, `Image`.`mime_type`, `Image`.`filename`, `Image`.`crop_x`, `Image`.`crop_y`, `Image`.`width`, `Image`.`height`, `Image`.`created`, `Image`.`modified`, `OriginalImage`.`id`, `OriginalImage`.`user_id`, `OriginalImage`.`filepath`, `OriginalImage`.`mime_type`, `OriginalImage`.`filename`, `OriginalImage`.`crop_x`, `OriginalImage`.`crop_y`, `OriginalImage`.`width`, `OriginalImage`.`height`, `OriginalImage`.`created`, `OriginalImage`.`modified` 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 `Image`.`user_id` = 652 AND `DishImage`.`id` <> '' ORDER BY `DishImage`.`created` DESC LIMIT 44410
41SELECT `DishImageVote`.`id`, `DishImageVote`.`user_id`, `DishImageVote`.`dish_image_id`, `DishImageVote`.`vote`, `DishImageVote`.`message`, `DishImageVote`.`message_public`, `DishImageVote`.`created`, `DishImageVote`.`modified` FROM `dish_image_votes` AS `DishImageVote` WHERE `DishImageVote`.`dish_image_id` IN (1214, 1206, 1028, 1027) 220
42SELECT `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 `Dish`.`id` = 2161 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5110
43SELECT `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` = 2161 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 440
44SELECT `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` = 2161 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
45SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='545' 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` = (545) 10100
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='2161' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
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='2161' 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=2161 ORDER BY `Image`.`created` DESC LIMIT 1110
50SELECT 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 `Dish`.`id` = 2161 AND disabled=0 AND `Dish`.`disabled`=0 110
51SELECT `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 `Dish`.`id` = 2178 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5110
52SELECT `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` = 2178 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 330
53SELECT `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` = 2178 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
54SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1479' LIMIT 1110
55SELECT `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` = (1479) 110
56SELECT 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='2178' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
57SELECT 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='2178' 110
58SELECT `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=2178 ORDER BY `Image`.`created` DESC LIMIT 1110
59SELECT 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 `Dish`.`id` = 2178 AND disabled=0 AND `Dish`.`disabled`=0 110
60SELECT `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 `Dish`.`id` = 1967 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5110
61SELECT `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` = 1967 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 220
62SELECT `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` = 1967 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 220
63SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1369' LIMIT 1110
64SELECT `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` = (1369) 110
65SELECT 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='1967' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,11110
66SELECT 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='1967' 110
67SELECT `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=1967 ORDER BY `Image`.`created` DESC LIMIT 1110
68SELECT 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 `Dish`.`id` = 1967 AND disabled=0 AND `Dish`.`disabled`=0 110
69SELECT `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 `Dish`.`id` = 1966 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5110
70SELECT `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` = 1966 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 440
71SELECT `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` = 1966 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 441
72SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1368' LIMIT 1111
73SELECT `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` = (1368) 110
74SELECT 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='1966' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
75SELECT 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='1966' 110
76SELECT `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=1966 ORDER BY `Image`.`created` DESC LIMIT 1111
77SELECT 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 `Dish`.`id` = 1966 AND disabled=0 AND `Dish`.`disabled`=0 110
78SELECT `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