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
Adjust search
No dish results in your area, try adjusting your search.
  • Tagged Vienna and hot and dog AND
  • Trekking distance from Austin, TX 78704 (aka within 30 miles)

There aren't any dishes that match your search yet. Dang!


How about adding one?


Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 38 queries took 1197 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `dishes`20201
2DESCRIBE `users`23231
3DESCRIBE `profiles`68682
4SET NAMES 'UTF8'00
5DESCRIBE `facebook_connect`771
6DESCRIBE `reviews`11111
7DESCRIBE `reviewsvotes`881
8DESCRIBE `images`11111
9DESCRIBE `tokens`771
10DESCRIBE `user_friends`551
11DESCRIBE `bookmarks`551
12DESCRIBE `safaris`881
13DESCRIBE `dishes_safaris`331
14DESCRIBE `safaris_users`331
15DESCRIBE `sets`16161
16DESCRIBE `sets_dishes`661
17DESCRIBE `sets_users`771
18DESCRIBE `restaurant_locations`21211
19DESCRIBE `restaurants`771
20DESCRIBE `featured_dishes`10101
21DESCRIBE `dish_images`771
22DESCRIBE `dish_image_votes`881
23DESCRIBE `tags`220
24DESCRIBE `dishes_tags`330
25DESCRIBE `dish_wanteds`881
26DESCRIBE `dish_wanteds_tags`330
27DESCRIBE `dish_wanteds_dishes`331
28DESCRIBE `blogbuzz`25251
29DESCRIBE `blogbuzz_votes`551
30DESCRIBE `blogbuzz_comments`661
31DESCRIBE `blogbuzz_dishes`330
32SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((30.2414*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((30.2414*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-97.7687 - 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 ('vienna' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'hot' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'dog' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`)) AND `Location`.`longitude` BETWEEN -98.2024014977 AND -97.3349985023 AND `Location`.`latitude` BETWEEN 29.8076985023 AND 30.6751014977 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 500160
33SELECT 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 ('vienna' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'hot' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'dog' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`)) AND `Location`.`longitude` BETWEEN -98.2024014977 AND -97.3349985023 AND `Location`.`latitude` BETWEEN 29.8076985023 AND 30.6751014977 AND `Dish`.`disabled`=0 11141
34SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((30.2414*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((30.2414*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-97.7687 - 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 ('vienna' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'hot' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'dog' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`)) AND `Location`.`longitude` BETWEEN -112.225416591 AND -83.3119834095 AND `Location`.`latitude` BETWEEN 15.7846834095 AND 44.6981165905 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 500175
35SELECT 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 ('vienna' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'hot' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'dog' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`)) AND `Location`.`longitude` BETWEEN -112.225416591 AND -83.3119834095 AND `Location`.`latitude` BETWEEN 15.7846834095 AND 44.6981165905 AND `Dish`.`disabled`=0 11144
36SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((30.2414*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((30.2414*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-97.7687 - 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 ('vienna' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'hot' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'dog' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`)) AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 500238
37SELECT 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 ('vienna' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'hot' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`) AND 'dog' IN (SELECT LOWER(tag) FROM tags LEFT JOIN dishes_tags ON `tags`.`id`=`dishes_tags`.`tag_id` WHERE `dishes_tags`.`dish_id`=`Dish`.`id`)) AND `Dish`.`disabled`=0 11310
38SELECT `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 5552