query
RESULTSET
query
  AGE_RANGE CUSTOMER_ID CUSTOM_RATING_1 CUSTOM_RATING_2 CUSTOM_RATING_3 DTE EMAIL_ADDRESS FULL_NAME GENDER HOW_LONG LOCATION NICKNAME OVERALL_RATING PRODUCT_REVIEW_ID REVIEW REVIEW_TITLE STATE_REGION STATUS STYLE_ID YOUR_CITY
CACHED false
EXECUTIONTIME 16
SQL select * from tb_product_reviews where style_id in (0,1039638) and status='A'
CHACO

Z/2 Yampa- Mens

style # Z/2 YAMPA-MENS

$104.99

Fast & Free Shipping On Orders over $59.99

Adjust this bad boy around your big toe and get ready for serious adventuring. Chaco’s lightweight Yampa outsole provides excellent traction, while the LUVSEAT™ platform provides vital alignment and support to keep you on your feet.
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details