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

Amy's Ice Cream

  • 1 dish on Dishola
  • is the average score of all their dishes
  • 0 reviews in total
no image add yours
Default Dish Image
Avg. Review
Pretty Hate Machine at Amy's Ice Cream

Westgate Blvd, Austin, TX

Notice (8): Undefined index:  User [APP/views/elements/dish_title_submitted.thtml, line 112]
Notice (8): Undefined index:  modified [APP/views/elements/dish_title_submitted.thtml, line 115]
on 01/01/70

Notice (8): Undefined index:  review [APP/views/elements/dish.thtml, line 206]
more…   [
Notice (8): Undefined index:  count [APP/views/elements/dish.thtml, line 212]
reviews]

Tags: ice cream  fudge  chocolate  Reeses  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) 15 queries took 4 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` = 2134 LIMIT 1110
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` = (2134) 111
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='2134'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='2134'111
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='2134'111
7SELECT `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 `Location`.`restaurant_id`='2134' AND `Dish`.`disabled`=0 LIMIT 5110
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` = 3509 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 440
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` = 3509 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`='2229' 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` = (2229) 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='3509' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1000
13SELECT `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=3509 ORDER BY `Image`.`created` DESC LIMIT 1000
14SELECT 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`='2134' AND `Dish`.`disabled`=0 111
15SELECT `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