Appalachian Military Surplus Stores

Military Surplus Stores ammo

Military Surplus Tactical Gear

Military Surplus Stores tents

Military Surplus BDUs

Military Surplus Stores camouflage and concealment

Military surplus stores surplus items
Military Surplus Stores
  Home » Catalog » BlackHawk My Account  |  Duffle bag contents  |  Checkout   
Military Surplus Gear
Camouflage and Concealment->
Camping and Field Gear->
Clothing and Uniforms->
Knives and Bayonets
Law Enforcement Gear->
Surplus->
Tactical Gear & Equipment->
Testing Area
Weekly Specials
Multicam
Sale Items more
SPEC-OPS Sling 101 3-Point Sling
SPEC-OPS Sling 101 3-Point Sling
$24.95
$22.46
Information
Shipping & Returns
Privacy Statement
Contact Us
Show by Manufacturer:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where p.products_status = '1' and pd.products_id = p.products_id and pd.language' at line 1

select count(*) as total from ((products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '24'

[TEP STOP]