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 0
SQL select * from tb_product_reviews where style_id in (0,1078857,1078857) and status='A'
 Chaco - Women's Zx/2 ® Classic - Womens Shoes - Casual - Sandal + Hover or Click to zoom
CHACO

Women's Zx/2 ® Classic

style # J106120

$104.99

Fast & Free Shipping On Orders over $59.99

This simple, timeless sandal is designed to help you meet whatever your day brings to you. This member of the Classic series has adjustable double-straps that will help you find a perfect fit, a toe-loop for a stable fit, and a podiatrist-certified LUVSEAT™ PU footbed for extraordinary support and comfort. The outsole features ChacoGrip™ rubber for ultimate performance.
PATCH/AMBER
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details