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-2 of 2 dishes:
  • Tagged tomatillo AND
  • Trekking distance from Austin, TX 78704 (aka within 30 miles)
Verde Enchiladas at Habanero's Mexican Cafe, photo by frances
email to a friend
add to a dish set
8
Avg. Review
Verde Enchiladas at Habanero's Mexican Cafe

501 W Oltorf St, Austin, TX (0.5 miles away)
(512) 416-0443

frances on 11/16/09

I have been dying to try this place because I've heard such GREAT things about it. And it was great. I normally don't like enchiladas because I feel like they're just too mushy, but I loved these. Nice more…   [1 review]

Tags: tomatillo  enchiladas  chicken  Verde  sauce  Mexican  edit
Chili Relleno at Santa Rita Tex-Mex Cantina, photo by austinfoodie
email to a friend
add to a dish set
9
Avg. Review
Chili Relleno at Santa Rita Tex-Mex Cantina

1206 W 38th St, Austin, TX (4.5 miles away)
(512) 419-7482

austinfoodie on 04/01/09

Spicy on the inside and tender on the outside, the Chili Relleno from Santa Rita is top notch. Baked to perfection and served with rice, guacamole, and black beans, the poblano pepper is stuffed with more…   [1 review]

Tags: Tex-Mex  chili  Relleno  rice  guacamole  black  beans  chicken  tomatillo  sauce  cheese  pico  de  gallo  edit

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 20 queries took 421 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2DESCRIBE `blogbuzz`25251
3DESCRIBE `blogbuzz_votes`551
4DESCRIBE `blogbuzz_comments`661
5DESCRIBE `blogbuzz_dishes`331
6SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((30.242831*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((30.242831*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-97.765788 - 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 ('tomatillo' 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.1994894977 AND -97.3320865023 AND `Location`.`latitude` BETWEEN 29.8091295023 AND 30.6765324977 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 522168
7SELECT `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` IN (3792, 3106) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 20201
8SELECT `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` IN (3792, 3106) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 0028
9SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='229' LIMIT 1119
10SELECT `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` = (229) 440
11SELECT 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='3792' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,11142
12SELECT 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='3792' 117
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=3792 ORDER BY `Image`.`created` DESC LIMIT 11111
14SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1945' LIMIT 1110
15SELECT `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` = (1945) 220
16SELECT 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='3106' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1111
17SELECT 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='3106' 110
18SELECT `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=3106 ORDER BY `Image`.`created` DESC LIMIT 1117
19SELECT 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 ('tomatillo' 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.1994894977 AND -97.3320865023 AND `Location`.`latitude` BETWEEN 29.8091295023 AND 30.6765324977 AND `Dish`.`disabled`=0 11143
20SELECT `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