SELECT products.ID, products.INV_NUMBER as TITLE,products.FAKE_URL FROM products, cat_prod WHERE cat_prod.CAT_ID='10' AND products.ID=cat_prod.PROD_ID ORDER BY INV_NUMBER
Front zipper pocket, mesh pocket and cell phone pocket, inside pocket under flap, adjustable should strap with sliding comfort pad, heavy duty zipper and metal hardware.