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

I'm a nonprofit/taco guy with a Si Se Puede attitude!

elmundodemando

elmundodemando (Mando Rayo)

Add elmundodemando to your Tablemates
Featured on Blog Buzz
Tablemates
Latest Reviews
more ...

About elmundodemando

I'm a nonprofit guy with a Si Se Puede attitude! I do community engagement, volunteerism, social media & tacos at www.tacojournalism.com.

Foodie Fetishes

  • Recommended Food Safari: Tacos
  • And to Drink: Tequlia
  • Your Fantasy Tablemates: The ones that offer to pay. ;)
  • Favorite Cuisine: Tacos
  • Last Meal Request: Tacos
  • Favorite Eating Town: El Paso, TX cuz it's my home

Industry Experience

  • Waiter/Waitress
  • Prep Cook
  • Line Cook
  • Other

Food Writing


Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 72 queries took 120 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
28DESCRIBE `blogbuzz`25251
29DESCRIBE `blogbuzz_votes`551
30DESCRIBE `blogbuzz_comments`661
31DESCRIBE `blogbuzz_dishes`331
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` = 'elmundodemando' LIMIT 1118
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` = (1596) 118
34SELECT COUNT(*) AS `count` FROM `profiles` AS `Profile` WHERE `Profile`.`id` = 1589 110
35UPDATE `profiles` SET `id` = 1589, `user_id` = 1596, `views` = 1253, `modified` = '2012-05-24 20:27:26' WHERE `profiles`.`id` = 158914
36SELECT `Profile`.* FROM `profiles` AS `Profile` LEFT JOIN `users` AS `User` ON (`Profile`.`user_id` = `User`.`id`) WHERE `Profile`.`id` = 1589 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`=1596 ORDER BY RAND() ASC LIMIT 8887
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` = 1367 LIMIT 1111
39SELECT `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` = 1845 LIMIT 1112
40SELECT `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` = 1755 LIMIT 1110
41SELECT `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` = 771 LIMIT 1111
42SELECT 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`=1596 111
43SELECT `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` = 1596 AND `DishImage`.`id` <> '' ORDER BY `DishImage`.`created` DESC LIMIT 44444
44SELECT `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 (2001, 2000, 1999, 1998) 000
45SELECT `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` = 3316 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5110
46SELECT `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` = 3316 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 660
47SELECT `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` = 3316 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 110
48SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='549' LIMIT 1110
49SELECT `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` = (549) 220
50SELECT 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='3316' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
51SELECT 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='3316' 110
52SELECT `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=3316 ORDER BY `Image`.`created` DESC LIMIT 1110
53SELECT 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` = 3316 AND disabled=0 AND `Dish`.`disabled`=0 111
54SELECT `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` = 3297 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5111
55SELECT `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` = 3297 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 220
56SELECT `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` = 3297 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 111
57SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2149' LIMIT 1110
58SELECT `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` = (2149) 110
59SELECT 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='3297' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1115
60SELECT 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='3297' 110
61SELECT `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=3297 ORDER BY `Image`.`created` DESC LIMIT 1110
62SELECT 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` = 3297 AND disabled=0 AND `Dish`.`disabled`=0 111
63SELECT `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` = 3314 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5110
64SELECT `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` = 3314 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 551
65SELECT `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` = 3314 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 001
66SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='212' LIMIT 1110
67SELECT `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` = (212) 330
68SELECT 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='3314' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
69SELECT 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='3314' 110
70SELECT `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=3314 ORDER BY `Image`.`created` DESC LIMIT 1110
71SELECT 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` = 3314 AND disabled=0 AND `Dish`.`disabled`=0 111
72SELECT `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