Shop
Wholesale
Contact Us
Help Center
My Account
Home ::
Miltiary Gear
|
Categories
|
BDU & ACU Pants
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1280
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Propper ACU Flame Resistant Trouser MultiCam Our Price: $139.99 You save: $15.00 (10%) Propper ABU Men's Trouser 50/50 Nylon/Cotton Twill Our Price: $34.99 You save: $15.00 (30%) Propper ABU Women's Trouser 50/50 Nylon/Cotton Twill Our Price: $34.99 You save: $15.00 (30%) Propper ACU Flame Resistant Trouser Universal Our Price: $127.99 You save: $2.00 (2%)
BDU & ACU Shirts
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1284
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Propper 2-Pocket BDU Long Sleeve Shirt 60/40 Cotton/Poly Twill Our Price: $29.99 You save: $10.00 (25%) Propper 2-Pocket BDU Ripstop Battle Rip Long Sleeve Shirt 65/3 Our Price: $29.99 You save: $10.00 (25%) Propper BDU 4-Pocket Coat Ripstop Battle Rip 65/35 Poly/Cotton Our Price: $29.99 You save: $10.00 (25%) Propper BDU 4-Pocket Coat 60/40 Cotton/Poly Twill Our Price: $29.99 You save: $10.00 (25%)
Military Jackets
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1285
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Alpha Industries MA-1 Nylon Flight Jacket Our Price: $94.99 You save: $7.01 (7%) Alpha Industries Lightweight 'Hawk' Jacket Our Price: $79.99 You save: $4.01 (5%) Alpha Industries Lightweight 'Hawthorne' Jacket Our Price: $84.99 You save: $3.01 (3%) Alpha Industries 'McGyver' Field Coat Our Price: $94.99 You save: $3.01 (3%)
Military Boots
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1286
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Ridge Desert Storm Boots Suede/Ripstop Nylon 8" Our Price: $99.99 You save: $8.00 (7%) Ridge Desert Storm Zipper Boots Suede/Ripstop Nylon 6" Our Price: $107.99 You save: $10.00 (8%) Ridge Oxford Lite Shoes Black High Gloss Clarino Our Price: $64.99 You save: $8.00 (11%) Ridge Oxford Duty Shoes Black Leather Our Price: $74.99 You save: $10.00 (12%)
Military Headwear
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1287
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 US Army ACU Digital Camo 2-Ply Rip-Stop Army Ranger Fatigue Cap Our Price: $8.99 You save: $1.00 (10%) Woodland Digital Camo Marine Corps Fatigue Cap 2-Ply Poly Cotton Our Price: $8.99 You save: $2.00 (18%) Desert Digital Camo Poly/Cotton 2-Ply Marine Corps Cap Our Price: $8.99 You save: $2.00 (18%) Black Vintage Military Fatigue Cap w/Jolly Roger Our Price: $10.99 You save: $1.00 (8%)
Coveralls & Flightsuits
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1289
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Alpha Industries Kid's NASA Flight Suit Our Price: $45.99 You save: $10.01 (18%) Propper CWU 27P NOMEX Flight Suit Our Price: $169.99 You save: $15.00 (8%) Kids Woodland Camo Insulated Coverall Our Price: $53.99 You save: $16.00 (23%) Kids Air Force Type Flightsuit - Olive Drab Our Price: $36.99 You save: $10.00 (21%)
Law Enforcement
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1304
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Teflon Coated EMT Pants Our Price: $38.99 You save: $10.00 (20%) Waterproof Reflective Rain Parka - Reversible Black to Orange Our Price: $62.99 You save: $22.00 (26%) Rothco Police Spectra Cut Resistant Glove Our Price: $37.99 You save: $4.00 (10%) Black ACU Shirt - Strategic Deployment Uniform (Cotton Ripstop) Our Price: $34.99 You save: $13.00 (27%)
Work & Duty Gear
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1305
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Propper 2-Pocket BDU Long Sleeve Shirt 60/40 Cotton/Poly TwillOur Price: $29.99 You save: $10.00 (25%) Propper Battle Rip TAC.U Trousers Our Price: $39.99 You save: $10.00 (20%) Propper BDU 2-Pocket Short Sleeve Shirt Ripstop Battle Rip 65 Our Price: $24.99 You save: $10.00 (29%) Propper BDU 4-Pocket Coat Ripstop Battle Rip 65/35 Poly/CottonOur Price: $29.99 You save: $10.00 (25%)
EMT & EMS Gear
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1307
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Propper Men's CriticalEdge EMT Pants Our Price: $44.99 You save: $10.00 (18%) Propper Women's EMT CriticalEdge Pants Our Price: $44.99 You save: $10.00 (18%) Womens EMT Pants w/ Expandable Waistband Our Price: $38.99 You save: $9.00 (19%) EMT / EMS Uniform - Midnight Blue - BDU Pants - Zipper Fly Our Price: $26.99 You save: $9.00 (25%)
Eyeglasses & Goggles
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1309
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 58mm Pilot's Aviator Sunglasses - Military Air Force Aviators Our Price: $14.99 You save: $2.00 (12%) Air Force Style Avaiator Sunglasses w/Case Our Price: $9.99 You save: $1.00 (9%) 52mm Pilot's Aviator Sunglasses - Military Air Force Aviators Our Price: $14.99 You save: $2.00 (12%) Aviator Sunglasses - US Airforce Style Aviators Our Price: $7.99 You save: $1.00 (11%)
Military Gloves
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1311
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 GI Wool Glove Liners Our Price: $4.99 You save: $2.00 (29%) Rothco Nomex Flight Gloves Our Price: $32.99 You save: $6.00 (15%) Rothco Special Forces Tactical Gloves-Olive Drab, Tan Our Price: $39.99 You save: $19.00 (32%) Rothco D-3A Black Leather Gloves Our Price: $17.99 You save: $2.00 (10%)
Military Vests
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1312
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Plainclothes Concealed Carry Vest-Khaki, Black Our Price: $48.99 You save: $13.00 (21%) Olive Drab Ranger Vest Our Price: $33.99 You save: $9.00 (21%) Kids Woodland Camo Ranger Vest Our Price: $31.99 You save: $8.00 (20%) Kids Army Digital Camo Ranger Vest Our Price: $31.99 You save: $8.00 (20%)
Military Packs
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1313
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Propper APCU Duffle Bag Our Price: $64.99 You save: $10.00 (13%) Military Vintage Jumbo Backpacks Our Price: $29.99 You save: $5.00 (14%) Canvas Shoulder Bag - 24" - Black / Olive Drab Our Price: $19.99 You save: $4.00 (17%) European Style Military Rucksack/Backpack - Olive Drab or Navy Our Price: $26.99 You save: $7.00 (21%)
ALICE Packs
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1314
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 GI Style Enhanced Large Military ALICE Backpack w/ Frame Our Price: $126.99 You save: $42.00 (25%) GI Style Large ALICE Pack w/ Frame - Black Our Price: $112.99 You save: $30.00 (21%) GI Style Mini ALICE Pack - Olive Drab Our Price: $44.99 You save: $12.00 (21%) GI Style Medium ALICE Pack - No Frame - Olive Drab Our Price: $58.99 You save: $15.00 (20%)
MOLLE Gear
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1315
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Tactical Laptop / Briefcase - MOLLE Attachments Our Price: $79.99 You save: $28.00 (26%) Canteen Covers - 1 Quart MOLLE Compatible - Black / Olive Drab Our Price: $11.99 You save: $1.00 (8%) ACU Digital Camo MOLLE II 2 Quart Bladder Canteen Cover Our Price: $18.99 You save: $1.00 (5%) Medium Military Transport Backpack - MOLLE Compatible - Black Our Price: $51.99 You save: $12.00 (19%)
Rifle Cases
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1317
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Black Assault Rifle Cover 42" - Nylon Our Price: $24.99 You save: $8.00 (24%)
Rucksacks
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1319
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 European Style Military Rucksack/Backpack - Olive Drab or NavyOur Price: $26.99 You save: $7.00 (21%) Military Issue CFP-90 Combat Pack - Black Our Price: $149.99 You save: $75.00 (33%) Military CFP-90 Combat Backpack - Woodland Camouflage Our Price: $149.99 You save: $75.00 (33%) GI Style Mini ALICE Pack - Olive DrabOur Price: $44.99 You save: $12.00 (21%)
Holsters
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1321
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 .45 Cal. Black Canvas Shoulder Holster Our Price: $8.99 You save: $1.00 (10%) Army ACU Digital Camo Modular Holster w/MOLLE II Attachment Our Price: $17.99 You save: $4.00 (18%) Military Tactical Hip Holster - Black Our Price: $18.99 You save: $2.00 (10%) MultiCam MOLLE Tactical Holster Our Price: $28.99 You save: $6.00 (17%)
Patches & Insignia
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1322
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Vietnam Vet 6" Patch Our Price: $5.99 You save: $2.00 (25%) Patch Attach Glue - Permanent Patch Adhesive Our Price: $6.99 You save: $4.00 (36%) First Cavalry Patch Our Price: $7.99 You save: $2.00 (20%) Mac Viet-Sog Patch Our Price: $5.99 You save: $1.00 (14%)
Flags
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1324
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Military Antenna Flags POW/MIA & US Flags Our Price: $2.99 You save: $1.00 (25%) USMC and US Miniature Stick Flags 4" x 6" Our Price: $1.99 You save: $1.00 (33%) 2 Section Steel Flag Pole With Bracket Our Price: $13.99 You save: $2.00 (13%) 2' x 3' U.S. Flag Our Price: $8.99 You save: $1.00 (10%)
Military Watches
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1326
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Nylon Watchbands - Olive Drab / Black Our Price: $4.99 You save: $1.00 (17%) Military Replacement Watchbands - Nylon Our Price: $2.99 You save: $1.00 (25%) Clip On Watch w/LED Light - Olive Drab or Black Our Price: $22.99 You save: $8.00 (26%) Military Field Watch - Olive Drab Our Price: $25.99 You save: $4.00 (13%)
Novelties & Gifts
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1328
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Drill Sergeant Campaign Hat - Trooper Brown - 100% Wool Our Price: $59.99 You save: $18.00 (23%) Engraved Marine Corps Military Ring Our Price: $39.99 You save: $14.00 (26%) Engraved Army Military RingOur Price: $34.99 You save: $19.00 (35%) Engraved Navy Military Ring Our Price: $39.99 You save: $14.00 (26%)
Military Accessories
View All SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_msrp, (p.products_msrp - p.products_price) as products_save, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status
FROM zen_products p
LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN zen_products_to_categories zpc ON p.products_id = zpc.products_id,
zen_products_description pd
WHERE zpc.categories_id = 1329
AND p.products_status = 1
AND p.products_id = pd.products_id
LIMIT 4 Air Force Style Avaiator Sunglasses w/CaseOur Price: $9.99 You save: $1.00 (9%) Military D-Ring Expedition Belt Our Price: $4.99 You save: $1.00 (17%) Sportec Tactical Goggles Our Price: $31.99 You save: $0.50 (2%) Black Sunglass Case Our Price: $7.99 You save: $24.50 (75%) |
