We are please to introduce Raisons Overseas as a Leading Manufacturers , Exporters , Wholesales Suppliers , Dealers and Drop shipper offering complete Chainmail Armor Related Solutions to Medieval Armor Reenactors and Historical Weapons Lovers.
Raisons Overseas ( www.raisonsbrassband.com ) Specialize in Manufacturing of all kind of Chainmail Shirts like MS Mild Steel Chainmail , Alumium / Aluminium Chainmail , SS Stainless Steel Chain mail , in the following chainmail patterns like Butted Chain mail , Round Riveted Chainmail , Round Riveted With Close Warser / Warshel , Flat Riveted Chainmail , Flat Riveted with Close Ring washer , Wedge Riveted , Wedge Riveted with Close Ring in all ring size starting from 6 MM , 7 MM , 8 MM , 9 MM AND 10 MM in 16 Gauge , 17 Gauge and 18 Gauge .
We make Chainmail Shirts , Sleeveless Vest , Children Size Chainmail Costumes, Women Chainmail Clothings , Chainmail Jewelry , Hauberk , Haubergeon , Chainmail Camail , Chainmail Leggings , Chainmail Chauses , Coif / Hood , Lorica Integra , Lorica Hamata, Chain mail Gloves Gauntlets etc in Small ( S ) , Medium ( M ) , Large ( L ) , Extra Large ( XL ) and Extra Extra Large Size ( XXL ) . Custom made orders are also welcome in any shape and any design .
All kind of inquiries are welcome . We deliver all over the world. We also sale through Amazon.com under the brand name of : Gifts-Mart .
We have our Own Office in United States too .
Buyers can contact at :
OUR USA OFFICE
Mr. William Raisons Overseas
C/O Fast Track Express 149-05, 177th ST FL 1 Jamaica, NY 11434 United States Ph: 8886618857
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'raisonsb_newdb.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT
select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10