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 15
SQL select * from tb_product_reviews where style_id in (0,1087303) and status='A'
 Jag Jeans - Peri Stright Cropped Jean - Apparel - Bottoms - Jeans + Hover or Click to zoom
JAG JEANS

Peri Stright Cropped Jean

style # J2556-331

$68.00

Fast & Free Shipping On Orders over $59.99

Our best selling Peri Straight Leg jean just got even better! We cropped it right above the ankle for the perfect weekday/weekend style cross over. Made in our ultra comfortable Divine Twill and designed with our signature pull on waist band that will keep your midsection smooth and comfortable all day. •fiber content: 97% Cotton, 3% Spandex
2 4 6 8 10 12 14 16
WHITE
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details