The Leading Source Of Specialized Military Ammunition In America


50 BMG, M-9, Nickel Plated Machinegun Links (50ct.)

$19.95

50ct., U.S., M-9, .50 BMG Machinegun Links. Nickel Plated! (Note: Brass casings shown for demonstration purposes only and are not included.)

Condition: New

International Shipping: YES


Add to Cart:

  • Model: LINK-M9-50
  • Shipping Weight: 1.5lbs
  • 3 Units in Stock


This product was added to our catalog on Wednesday 11 February, 2009.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'deucecart.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from zen_orders_products opa, zen_orders_products opb, zen_orders o, zen_products p where opa.products_id = '195' and opa.orders_id = opb.orders_id and opb.products_id != '195' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]