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
About > Downloads

download something

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

elsigh is seeking
Spicy Szechuan Hot Pot
in San Francisco
Know where to find it?

This Week's Divine Dish

Ribs at Rendezvous Memphis, TN

(dishola_development) 32 queries took 46 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `dish_wanteds`881
2DESCRIBE `users`23232
3DESCRIBE `profiles`68683
4SET NAMES 'UTF8'00
5DESCRIBE `facebook_connect`771
6DESCRIBE `dishes`20202
7DESCRIBE `restaurant_locations`21211
8DESCRIBE `restaurants`771
9DESCRIBE `featured_dishes`10101
10DESCRIBE `images`11111
11DESCRIBE `reviews`11111
12DESCRIBE `reviewsvotes`881
13DESCRIBE `dish_images`771
14DESCRIBE `dish_image_votes`881
15DESCRIBE `tags`221
16DESCRIBE `dishes_tags`331
17DESCRIBE `safaris`882
18DESCRIBE `dishes_safaris`331
19DESCRIBE `safaris_users`334
20DESCRIBE `sets`16161
21DESCRIBE `sets_dishes`662
22DESCRIBE `sets_users`772
23DESCRIBE `dish_wanteds_dishes`331
24DESCRIBE `tokens`771
25DESCRIBE `user_friends`551
26DESCRIBE `bookmarks`551
27DESCRIBE `dish_wanteds_tags`331
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 1002
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` = 34 AND `DishWantedsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishWantedsTag`.`id` ASC 332
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` = 34 AND `DishWantedsDish`.`dish_id` = `Dish`.`id`) WHERE 1 = 1 ORDER BY `DishWantedsDish`.`id` ASC 002
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