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

Cupcake Royal

http://www.cupcakeroyale.com/
  • 1 dish on Dishola
  • 7 is the average score of all their dishes
  • 3 reviews in total
Cupcake at Cupcake Royal, photo by laura
Divine Dish
Divine Dish
Cupcake at Cupcake Royal

2052 NW Market St, Seattle, WA, 98107 (1774.2 miles away)
206-782-9557

By no means is this an excellent cupcake. The "critic" who reviewed it below must value dry, uninspired cake as a most sought after feature? And their ratio of cake to frosting isn't ideal either, unless more…   [3 reviews]

Tags: cupcake  edit

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

MrWoo is seeking
Cold Noodles with Sesame Sauce
in Austin, TX
Know where to find it?

This Week's Divine Dish

Screaming Orgasm at Tomo Sushi Austin, TX

(dishola_development) 16 queries took 11 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2SELECT `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`name_search`, `Restaurant`.`name_dm`, `Restaurant`.`url`, `Restaurant`.`created`, `Restaurant`.`modified` FROM `restaurants` AS `Restaurant` WHERE `Restaurant`.`id` = 481 LIMIT 1111
3SELECT `Location`.`id`, `Location`.`restaurant_id`, `Location`.`source`, `Location`.`yahoo_id`, `Location`.`yelp_id`, `Location`.`name`, `Location`.`thoroughfare`, `Location`.`locality_name`, `Location`.`sub_administrative_area`, `Location`.`administrative_area`, `Location`.`country_name_code`, `Location`.`postal_code`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`phone1`, `Location`.`phone1_no_format`, `Location`.`phone2`, `Location`.`fax`, `Location`.`closed`, `Location`.`created`, `Location`.`modified` FROM `restaurant_locations` AS `Location` WHERE `Location`.`restaurant_id` = (481) 116
4SELECT REPLACE(ROUND(AVG(reviews.vote),1), '.0', '') AS vote_avg FROM reviews LEFT JOIN dishes on reviews.dish_id=dishes.id LEFT JOIN restaurant_locations on dishes.location_id=restaurant_locations.id LEFT JOIN restaurants ON restaurant_locations.restaurant_id=restaurants.id WHERE restaurants.id='481'110
5SELECT COUNT(*) AS vote_count FROM reviews LEFT JOIN dishes on reviews.dish_id=dishes.id LEFT JOIN restaurant_locations on dishes.location_id=restaurant_locations.id LEFT JOIN restaurants ON restaurant_locations.restaurant_id=restaurants.id WHERE restaurants.id='481'110
6SELECT COUNT(*) AS dish_count FROM dishes LEFT JOIN restaurant_locations on dishes.location_id=restaurant_locations.id LEFT JOIN restaurants ON restaurant_locations.restaurant_id=restaurants.id WHERE restaurants.id='481'111
7SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((30.242831*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((30.242831*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-97.765788 - 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`.`restaurant_id`='481' AND `Dish`.`disabled`=0 LIMIT 5111
8SELECT `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` = 569 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 110
9SELECT `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` = 569 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
10SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='464' LIMIT 1110
11SELECT `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` = (464) 110
12SELECT 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='569' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
13SELECT 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='569' 110
14SELECT `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=569 ORDER BY `Image`.`created` DESC LIMIT 1110
15SELECT 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`.`restaurant_id`='481' AND `Dish`.`disabled`=0 111
16SELECT `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