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-5 of 8 dishes:
  • Tagged pineapple AND
  • Trekking distance from Austin, TX 78704 (aka within 30 miles)
Camarones Al Pastor at La Condesa, photo by poco-cocoa
email to a friend
add to a dish set
9
Avg. Review
Camarones Al Pastor at La Condesa

400-A W 2nd Street, Austin, TX (1.9 miles away)
(512) 499-0300

poco-cocoa on 07/11/09

So good. The chile sauce reminded me of red enchiladas in New Mexico… deep and dark and delicious. more…   [2 reviews]

Tags: taco  taquitos  shrimp  achiote  guajillo  chile  pineapple  onion  cilantro  edit
Alma Blanca at La Condesa, photo by poco-cocoa
email to a friend
add to a dish set
10
Avg. Review
Alma Blanca at La Condesa

400-A W 2nd Street, Austin, TX (1.9 miles away)
(512) 499-0300

poco-cocoa on 07/11/09

Habanero-infused Chinaco Blanco, ginger essence, aloe vera-lemongrass syrup, pineapple juice, fresh corn and hoja de hierba santa, with a hibiscus-rose infused salt rim. Wow… this one was so interesting, more…   [2 reviews]

Tags: cocktail  habanero  lemongrass  pineapple  edit
Chorizo Gordita at Taqueria Star, photo by natanya
email to a friend
add to a dish set
8
Avg. Review
Chorizo Gordita at Taqueria Star

343 S Congress Ave, Austin, TX, 78704 (1.5 miles away)
(512) 909-8423

natanya on 04/10/09

This gordita is full of surprises: spicy chorizo is griddled by hand and mixed with pineapple for a savory and sweet combination that you won't quickly forget. The gordita is large and crispy, which is more…   [1 review]

Tags: gordita  chorizo  black  beans  taco truck  pineapple  edit
El Cubico at La Condesa, photo by laura
email to a friend
add to a dish set
9
Avg. Review
El Cubico at La Condesa

400-A W 2nd Street, Austin, TX (1.9 miles away)
(512) 499-0300

laura on 03/03/09

Though this drink might smell like an old cigar, don't let its distinct aroma prevent you from trying it. That cigar smell is actually whole leaf tobacco-infused sauza hornitos reposado, as well as a more…   [1 review]

Tags: cocktail  tequila  mezcal  lemon  pineapple  vanilla  edit
no image add yours
Default Dish Image
email to a friend
add to a dish set
10
Avg. Review
Kona Tacos at Cuatros

1004 W 24th St, Austin, TX (3.3 miles away)
(512) 243-6361

carablossom on 01/08/09

Heaven! The pulled pork is flavorful and spicy, with just the right heat to make me sweat but it still tastes great! And I love the pineapple, whose sweetness cuts that heat just a shade for me, and more…   [1 review]

Tags: tacos  pulled  pork  pineapple  edit

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

msparand is seeking
NY-style Pizza
in San Francisco, CA
Know where to find it?

This Week's Divine Dish

Screaming Orgasm at Tomo Sushi Austin, TX

Highest Rated Dishes

  1. Screaming Orgasm at Tomo Sushi
  2. Shag Roll at Uchi
  3. Sausage, Ricotta Cheese and Roasted Red Pepper Pizza #6 at Home Slice Pizza
  4. Khuroos-E-Tursh at Clay Pit
  5. Suppli at Enoteca

Copyright dishola® 2006-9. All rights reserved. | Terms of Use | Privacy Policy | Contact
(dishola_development) 31 queries took 305 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2SELECT `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 ('pineapple' 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 555163
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` IN (3043, 3065, 3125, 3050, 2701) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 29291
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` IN (3043, 3065, 3125, 3050, 2701) 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`='2016' LIMIT 1110
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` = (2016) 23230
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='3043' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
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='3043' 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=3043 ORDER BY `Image`.`created` DESC LIMIT 1110
10SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2016' 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` = (2016) 23230
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='3065' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
13SELECT 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='3065' 110
14SELECT `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=3065 ORDER BY `Image`.`created` DESC LIMIT 1110
15SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2060' LIMIT 1110
16SELECT `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` = (2060) 220
17SELECT 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='3125' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
18SELECT 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='3125' 110
19SELECT `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=3125 ORDER BY `Image`.`created` DESC LIMIT 1110
20SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2016' LIMIT 1110
21SELECT `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` = (2016) 23230
22SELECT 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='3050' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
23SELECT 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='3050' 110
24SELECT `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=3050 ORDER BY `Image`.`created` DESC LIMIT 1110
25SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1825' LIMIT 1110
26SELECT `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` = (1825) 220
27SELECT 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='2701' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1110
28SELECT 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='2701' 110
29SELECT `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=2701 ORDER BY `Image`.`created` DESC LIMIT 1000
30SELECT 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 ('pineapple' 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 11141
31SELECT `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