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,1088762,1088762) and status='A'
 Z Supply - Z Supply | Pocket Tee - Burnout V- Neck - Apparel - T- Shirts + Hover or Click to zoom
Z SUPPLY

Z Supply | Pocket Tee - Burnout V- Neck

style # ZT144034

$26.99 Compare at $34.00

Fast & Free Shipping On Orders over $59.99

The Pocket Tee from Z Supply being our favorite tee is an understatement. Made from our Signature Burnout jersey fabric, this tee is complete with a curved V-neckline and a slouchy, raw-edge pocket. Because of its soft feel and chic fit, you`ll want to stock up in every color. FABRIC 55% Cotton 45% Polyester CARE Our Signature Burnout garments are specially treated for perfectly imperfect variations in color that will evolve with wear and washing. To care, hand wash or machine wash cold, gentle cycle, and lay flat to dry, as a heated dryer will accelerate the aging process. Wash before wearing. FIT Relaxed Fit. Model is wearing Size S SPECS Bust: 36` Length: 28`
XS S M L XL
Call Us: 770-642-0051
Fast & Free Shipping on Orders over $59.99! Click for Details