Time Restored Limited

INVALID SQL: 1 : Can't create/write to file '/tmp/#sql_cc9_0.MYI' (Errcode: 28)
SQL QUERY FAILURE: SELECT xcart_products.*, MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price, xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM( xcart_products, xcart_pricing , xcart_products_categories, xcart_categories )LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND (xcart_pricing.variantid = 0 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_products_categories.categoryid='9' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid ORDER BY xcart_products.productcode ASC, xcart_products.product ASC LIMIT 0, 10
Time Restored Limited :: Hands

Home

About Us

Our Products

Search:

Our Products

Help

Privacy Statement

Terms & Conditions

About Us

Postage and Packaging

Time Restored Limited :: Hands

At present all hands are made to order, and can be cut from brass or steel. They are hand-cut in the traditional way and then fettled or sculpted if steel, and embossed if brass. When ordering please choose the pattern you require from a standard reference book such as Barder, Britten, Cescinsky and Webster, Loomes, Robey, Robinson or Rose.

For steel hands we will need to know:

Length of hand from centre to tip

Mild or carbon steel

Fettled and polished, or left as cut

Thickness of material

Diameter of boss

Style or pattern

Blued or left bright

For brass hands we will need to know:

Length of hand from centre to tip

Fettled and embossed or left as cut

Thickness of material

Diameter of boss

Style or pattern

Gilded or un-gilded

We are happy to undertake supplying single hands to suit one of a missing pair, or complete sets of hands. Seconds hands, date hands, strike/silent hands....anything you require. Hands are usually despatched within two weeks.

Please telephone or e-mail your order.

Hands

There are no available products under this category.