Tartan Plus

Clan Crest Kilt Pin

In Scotland's turbulent past it was the custom for Clan Chiefs to give their followers a metal plate of their crest, to be worn as a badge of allegiance which fastened to their clothing with a strap and buckle.

When not in use the belt was coiled around the crest and this convention is used in the clan crest badges of today.

Only a Clan Chief may wear the crest without the strap and buckle.

To search for your Clan Name CLICK HERE.

1.75" (4.5cm) Diameter

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 '' at line 7
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status 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 p2c.products_id = s.products_id where 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 = '67' order by ]