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.
Sticky Toffee Pudding

new users

By registering for an account at Dishola you'll be able to add your favorite dishes, vote on all the dishes, upload pictures, and write reviews.

Optional, but will help your friends find you on dishola.
Minimum 3 characters. No spaces.
i.e. Austin, TX or San Francisco, CA

sign in

Forgot your username/password?

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

bighousepink is seeking
Yellowtail Sashimi
in Mexico City, Mex
Know where to find it?

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 32 queries took 37 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`23231
2DESCRIBE `profiles`68683
3SET NAMES 'UTF8'00
4DESCRIBE `facebook_connect`771
5DESCRIBE `dishes`20201
6DESCRIBE `restaurant_locations`21212
7DESCRIBE `restaurants`771
8DESCRIBE `featured_dishes`10102
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`662
24DESCRIBE `sets_users`771
25DESCRIBE `tokens`771
26DESCRIBE `user_friends`552
27DESCRIBE `bookmarks`551
28SELECT `DishWanted`.`id`, `DishWanted`.`user_id`, `DishWanted`.`name`, `DishWanted`.`location`, `DishWanted`.`message`, `DishWanted`.`description`, `DishWanted`.`created`, `DishWanted`.`modified`, `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` FROM `dish_wanteds` AS `DishWanted` LEFT JOIN `users` AS `User` ON (`DishWanted`.`user_id` = `User`.`id`) WHERE DATE_SUB(CURDATE(),INTERVAL 60 DAY) <= `DishWanted`.`created` ORDER BY RAND() ASC LIMIT 1001
29SELECT `DishWanted`.`id`, `DishWanted`.`user_id`, `DishWanted`.`name`, `DishWanted`.`location`, `DishWanted`.`message`, `DishWanted`.`description`, `DishWanted`.`created`, `DishWanted`.`modified`, `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` FROM `dish_wanteds` AS `DishWanted` LEFT JOIN `users` AS `User` ON (`DishWanted`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY RAND() ASC LIMIT 1114
30SELECT `Tag`.`id`, `Tag`.`tag`, `DishWantedsTag`.`id`, `DishWantedsTag`.`dish_wanted_id`, `DishWantedsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `dish_wanteds_tags` AS `DishWantedsTag` ON (`DishWantedsTag`.`dish_wanted_id` = 41 AND `DishWantedsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishWantedsTag`.`id` ASC 220
31SELECT `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`, `DishWantedsDish`.`id`, `DishWantedsDish`.`dish_id`, `DishWantedsDish`.`dish_wanted_id` FROM `dishes` AS `Dish` JOIN `dish_wanteds_dishes` AS `DishWantedsDish` ON (`DishWantedsDish`.`dish_wanted_id` = 41 AND `DishWantedsDish`.`dish_id` = `Dish`.`id`) WHERE 1 = 1 ORDER BY `DishWantedsDish`.`id` ASC 000
32SELECT `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