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

don't melt cheese on chinese food!

scottysauce

scottysauce (Scotty)

Tablemates
Latest Reviews
more ...

About scottysauce

I'm 35 and live in the s.f. bay area. i love cooking and everything that has to do with food. i love writing reviews on food and restaurants and taking pictures of the food i come across

Foodie Fetishes

  • Recommended Food Safari: tri valley east bay area
  • And to Drink: orangina
  • Your Fantasy Tablemates: eddie vedder tyler florence jenny mccarthy mitch hedberg
  • Favorite Cuisine: burrito's, sandwiches, burgers, pizza & bbq
  • Last Meal Request: val's burgers in hayward gay nineties pizza in pleasanton
  • Favorite Eating Town: tri valley- east bay area

Industry Experience

  • Cooking School
  • Waiter/Waitress
  • Prep Cook
  • Caterer

Food Writing

  • I've had food articles and/or reviews published.

(dishola_development) 33 queries took 31 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2DESCRIBE `blogbuzz`25251
3DESCRIBE `blogbuzz_votes`551
4DESCRIBE `blogbuzz_comments`661
5DESCRIBE `blogbuzz_dishes`331
6SELECT `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` = 'scottysauce' LIMIT 1111
7SELECT `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` = (2165) 000
8SELECT COUNT(*) AS `count` FROM `profiles` AS `Profile` WHERE `Profile`.`id` = 2158 110
9UPDATE `profiles` SET `id` = 2158, `user_id` = 2165, `views` = 274, `modified` = '2012-05-24 20:55:38' WHERE `profiles`.`id` = 2158116
10SELECT `Profile`.* FROM `profiles` AS `Profile` LEFT JOIN `users` AS `User` ON (`Profile`.`user_id` = `User`.`id`) WHERE `Profile`.`id` = 2158 LIMIT 1111
11SELECT `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`=2165 ORDER BY RAND() ASC LIMIT 8110
12SELECT 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`=2165 110
13SELECT `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` = 2165 AND `DishImage`.`id` <> '' ORDER BY `DishImage`.`created` DESC LIMIT 4447
14SELECT `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 (2211, 2210, 2209, 2208) 000
15SELECT `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` = 3533 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5110
16SELECT `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` = 3533 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 12121
17SELECT `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` = 3533 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
18SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2249' LIMIT 1110
19SELECT `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` = (2249) 110
20SELECT 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='3533' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
21SELECT 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='3533' 110
22SELECT `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=3533 ORDER BY `Image`.`created` DESC LIMIT 1110
23SELECT 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` = 3533 AND disabled=0 AND `Dish`.`disabled`=0 110
24SELECT `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` = 3532 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5110
25SELECT `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` = 3532 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 16161
26SELECT `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` = 3532 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
27SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2248' LIMIT 1110
28SELECT `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` = (2248) 110
29SELECT 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='3532' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
30SELECT 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='3532' 110
31SELECT `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=3532 ORDER BY `Image`.`created` DESC LIMIT 1110
32SELECT 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` = 3532 AND disabled=0 AND `Dish`.`disabled`=0 110
33SELECT `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