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
Dishes > Austin, TX 78704
Adjust search
Results 1-1 of 1 dish:
  • Tagged Butterscotch AND
  • Trekking distance from Austin, TX 78704 (aka within 30 miles)
Box of Cookies at Cookie Lounge - CLOSED :(, photo by laura
Divine Dish
Divine Dish
Box of Cookies at Cookie Lounge - CLOSED :(

2222 Rio Grande St, Austin, TX, 78705 (3.4 miles away)
512.478.BAKE (2253)

Want to treat yourself (or someone else) to something really special? Head to Austin's Cookie Lounge, helmed by Mark Chapman (former executive pastry chef at the nearby Driskill Hotel) and order a homemade, more…   [1 review]

Tags: cookies  Belgian chocolate  vanilla  sweet cream  candied  ginger  oatmeal  Butterscotch  almonds  edit

(dishola_development) 11 queries took 335 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2SELECT `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 ('butterscotch' 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 511167
3SELECT `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` = 2928 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 990
4SELECT `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` = 2928 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 330
5SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1965' LIMIT 1113
6SELECT `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` = (1965) 1119
7SELECT 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='2928' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
8SELECT 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='2928' 110
9SELECT `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=2928 ORDER BY `Image`.`created` DESC LIMIT 1111
10SELECT 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 ('butterscotch' 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 11144
11SELECT `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