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
no image add yours
Default Dish Image
email to a friend
add to a dish set
share on facebook
9
Avg. Review
JJ's Veggie
Fricano's Deli Catering

104 E 31st St Austin, TX
(512) 482-9980

1st review by krishelle

Tags: sandwich  vegetarian  deli  edit
dish it - add your review today!
  1. Make krishelle a Tablemate
    krishelle on 11/11/09
    Score 9

    JJ's Veggie is a huge sandwich loaded with fresh avocado, spinach, tomatos, sprouts , red onion, cucumbers and provolone (chedder too but I request it without). The wheat bread is hearty and healthy. I usually just dress the sandwich with spicy mustard, but the house made roasted red pepper hummus is a delicious add on. A pickle spear always accompanies as an extra perk.

    Comments (1)
    laura on 11/11/09

    Can't wait to try this place...I've been hearing some great buzz.

    add a comment
Loading the map...
Add a new Dish!

Dish Roulette

Hungry for something but don't know what?

Dish Wanted

natanya is seeking
Greasy Spoon Breakfast
in 78732
Know where to find it?

This Week's Divine Dish

Fried Calamari at Apple Annies Cafe Bakery 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) 20 queries took 44 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SET NAMES 'UTF8'00
2SELECT `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 `Dish`.`id` = 3718 AND disabled=0 AND `Dish`.`disabled`=0 LIMIT 5111
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` = 3718 AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC 331
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` = 3718 AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 000
5SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2349' 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` = (2349) 330
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='3718' 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='3718' 111
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=3718 ORDER BY `Image`.`created` DESC LIMIT 10013
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 `Dish`.`id` = 3718 AND disabled=0 AND `Dish`.`disabled`=0 110
11SELECT 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 `Review`.`dish_id` = 3718 1115
12SELECT COUNT(*) AS `count` 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 `DishImage`.`dish_id` = 3718 110
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` = 3718 110
14SELECT COUNT(*) AS `count` 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` = 3718 110
15SELECT `Review`.*, `User`.* FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) WHERE `Review`.`dish_id` = 3718 ORDER BY `Review`.`created` DESC LIMIT 5111
16SELECT COUNT(*) AS `count` FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 4323 AND `message_public` = 1 119
17SELECT `Reviewsvote`.*, `User`.* FROM `reviewsvotes` AS `Reviewsvote` LEFT JOIN `reviews` AS `Review` ON (`Reviewsvote`.`review_id` = `Review`.`id`) LEFT JOIN `users` AS `User` ON (`Reviewsvote`.`user_id` = `User`.`id`) WHERE `review_id` = 4323 AND `message_public` = 1 111
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 `Review`.`dish_id` = 3718 110
19SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id`, `DishImage`.`dish_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 `DishImage`.`dish_id` = 3718 ORDER BY `Image`.`created` DESC 001
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