LASERGRIPS®: The ULTIMATE UPGRADE FOR YOUR BELOVED .45
John Browning's masterpiece, the formidable 1911 semi-auto platform, dates back over 100 years. With its comfortable ergonomics and legendary stopping power, this pistol is still as popular as ever. With the addition of a 1911 pistol laser sight, this stalwart of four American wars becomes one of the most capable personal defense weapons you can select.
Crimson Trace® offers two laser sighting options for your 1911 handgun: Front Activation Lasergrips® or Side Activation Lasergrips. Based on your operational preference, both are suitable for Government, Commander, Officer's, Compact and Defender variants made by many quality manufacturers. Crimson Trace Lasergrips fit most 1911 models with 3 1/16" separated grip screws on full-size models and 2 11/16" separated grip screws on compacts.
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 'limit 0, 10' at line 1
select p.products_image, p.products_model, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_map, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id left join categories c on c.categories_id = p2c.categories_id where c.categories_status = '1' and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '328' order by limit 0, 10
