Shopping Cart
now in your cart
0 items
Homepage
Company
Specials
Web
Create an Account
Log In
Contact Us
Categories
BANDOLIERS
BELTS
BICORNS
BUCKLES
BUTTONS
Airforce
Spanish Guardia Civil
Spanish National Police
Spanish Army
More
CAPS
CARTRIDGES
EMBROIDERY
EPAULETS
GALAS / FORRAJERAS
LOW PRICE UNIFORM
SASHES
SHIRTS
TRICORNS
Reviews
Write a review on this product!
Top
»
Catalog
»
BUTTONS
»
More
»
» 01 - BUTTONS 001
Click to enlarge
Big and small brass made convex button nickel plating with stamped constitutional shield.
Ten units packs (six big & four small).
Para elegir la talla adecuada dirijase al apartado de
“Como tomar mis medidas”
/ We suggest that you check our
“How to messure my size”
section to get the right size.
IVA no incluido en el precio / VAT not included
Los precios son para una unidad o pack, para pedidos superiores contactar con nosotros para descuentos. Consultar existencias y plazo de entrega.
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'marisaor_tienda.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '456' and opa.orders_id = opb.orders_id and opb.products_id != '456' 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
[TEP STOP]