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,1090363) and status='A'
 Asics - Asics Gt- 1000 7 - Womens Shoes - Athletic - Running + Hover or Click to zoom
ASICS

Asics Gt- 1000 7

style # 1012A030.401

$89.99

Fast & Free Shipping On Orders over $59.99

Exceptional performance meets incredible value. With its balanced support and guided stability, the sleek GT-1000® 7 road stability running shoe for women has been created to protect your feet and help you run further than ever before. Suitable for mid to long-distance runners, the GT-1000® 7 shoe features GEL® technology which combines with a responsive FLYTEFOAM® midsole and SPeVA® 45 lasting foam for exceptional bounce back and comfort. The DUOMAX® support system and GUIDANCE LINE® midsole maintain the structural integrity of the shoe while reducing the overall weight, so feet feel incredibly lightweight yet supported. Featuring an EVA sockliner and a durable AHAR® outsole, this is footwear built to last and will provide support on every step of your journey. ` Weight: 8.43. Heel Height: 20mm. Forefoot Height: 12mm
6.5 7 7.5 8 8.5 9 9.5 10 11
SHARK/BLK
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details