Custom Rifles

Quality knows no boundaries! Professionals seek precision and reliability, G.A. Precision delivers that to operators in over 25 countries.

Our main goal at G.A. Precision is to build a rifle fit for you in the best possible time frame we can. Give us a call and we can discuss your future needs in a rifle whether it be for an upcoming hunt, tactical competition, or just fun!

  1. Home
  2. Custom Rifles
SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (213, 435, 223, 222, 218, 214, 2236, 2235, 2233)) AND (t_d.attribute_id IN ('73', '87', '88', '89', '109', '110', '111', '119', '122', '134', '196', '198', '216')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (213, 435, 223, 222, 218, 214, 2236, 2235, 2233)) AND (t_d.attribute_id IN ('76', '197')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (213, 435, 223, 222, 218, 214, 2236, 2235, 2233)) AND (t_d.attribute_id IN ('78', '121')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (213, 435, 223, 222, 218, 214, 2236, 2235, 2233)) AND (t_d.attribute_id IN ('79', '80', '94', '95', '241', '240')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (213, 435, 223, 222, 218, 214, 2236, 2235, 2233)) AND (t_d.attribute_id IN ('97', '123', '125', '126', '127', '128', '131', '135', '199', '200', '201', '218', '249', '252')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))