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,1042792) and status='A'
 Sanuk - Chiba - Mens Shoes - Casual - Slip- On + Hover or Click to zoom
SANUK

Chiba

style # SMF1047

$65.00

Fast & Free Shipping On Orders over $59.99

Sanuk was started by surfers in southern California in the late `90s who were looking for footwear that reflected their lighthearted way of life. Founder Jeff Kelley was disappointed to see little selection in a category of footwear that had become his main shoe staple: the flip flop. Jeff had always been interested in footwear and with a little help from a few friends Sanuk was born. Years later, the Sanuk brand still delivers out of the ordinary, quality product to surf and specialty shops every season and has helped bring the flip-flop category from a summer only item to something worn all year.
7 8 9 10 11 12 13 14
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details