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,1076487,1076487) and status='A'
UGG AUSTRALIA

Classic Short I I

style # 1016223

$159.99

Fast & Free Shipping On Orders over $59.99

This icon of casual style is a beloved silhouette constructed of twinface and suede. Classic Short II is now pretreated to protect against moisture and staining, and this plush sheepskin boot has been updated with a Treadlite by UGG™ sole, which provides increased cushioning, durability, and traction on both wet and dry surfaces. Approximate shaft height 8 inches.
6 7 8 9 10 11
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details