Regimental Gifts

Freedom Scroll LF Cufflinks, Regimental Gifts

Freedom Scroll LF Cufflinks

This unique range of jewellery has been designed and made for the Fusilier Museum by the artist Allison Wiffen.  She has used photographic images of the building and collection and has created a beautiful range of high quality ceramic jewellery.  If you are searching for an exclusive gift then look no further! 

These cufflinks are based on an image of the Lancashire Fusilier Freedom Scrolls found in the museum.

£45.00

You may also be interested in

'0' OR p.stockaction = 'show') GROUP BY p.productid ORDER BY p.name LIMIT " . $related_products . ""; $result_related = $db->query($sql_related); $col = 1; while ($row_related = $result_related->fetch()) { $sql_category = "SELECT c.parent AS parent1, c2.parent AS parent2 FROM productcategories pc JOIN categories c ON pc.categoryid = c.categoryid LEFT JOIN categories c2 ON c2.categoryid = c.parent WHERE pc.productid = '" . mysql_real_escape_string($row_related['productid']) . "'"; $result_category = $db->query($sql_category); $row_category = $result_category->fetch(); if ($row_category['parent2'] == 0) { $parents = $row_category['parent1'] . '/'; } else { $parents = $row_category['parent1'] . '/' . $row_category['parent2'] . '/'; } $sql_image = "SELECT pi.filename FROM productimages pi WHERE pi.productid = '" . mysql_real_escape_string($row_related['productid']) . "' ORDER BY pi.order LIMIT 1"; $result_image = $db->query($sql_image); if ($result_image->size() == 0) { $filename = 'no_image.jpg'; } else { $row_image = $result_image->fetch(); $filename = $row_image['filename']; } $sql_prices = "SELECT *, r.fldPrice AS reducedTo FROM stock s LEFT JOIN ( SELECT * FROM reductions WHERE ( fldDateStart IS NULL OR fldDateStart <= NOW() ) AND ( fldDateEnd IS NULL OR fldDateEnd >= NOW() ) ) AS r ON r.fldProductID = s.productid WHERE s.productid = '" . mysql_real_escape_string($row_related['productid']) . "' AND s.status = 'live' ORDER BY s.price"; $result_prices = $db->query($sql_prices); $row_prices = $result_prices->fetch(); $price = $row_prices['price']; $reducedPrice = $row_prices['reducedTo']; // Figure out image size for markup $tmpImagePath = 'http://'.$serverName.'/product_images/image_resize.php?image='.urlencode($filename).'&max_width=85&max_height=125'; $tmpImageData = getimagesize($tmpImagePath); if(is_null($reducedPrice)) $priceDisplay = '£'.number_format(round($price,2),2); else $priceDisplay = 'was £'.number_format(round($price,2),2).'
now £'.number_format(round($reducedPrice,2),2).''; echo '
' // echo ''."\n"; if($col == 3) $col = 1; else $col++; $related_prods .= '\'' . $row_related['productid'] . '\','; } if (strlen($related_prods) > 0) { $related_prods .= 'END'; $related_prods = str_replace(',END','',$related_prods); $related_sql = "AND p.productid NOT IN (" . $related_prods . ")"; } $leftover_related = $related_products - $result_related->size(); if ($leftover_related > 0) { $sql_leftover = "SELECT p.name,p.seoname, p.productid, p.description FROM products p JOIN stock s ON s.productid = p.productid WHERE p.productid != '" . mysql_real_escape_string($row_product['productid']) . "' " . mysql_real_escape_string($related_sql) . " AND p.status = 'live' AND s.status = 'live' AND (s.stock > '0' OR p.stockaction = 'show') AND s.price > 0 GROUP BY p.productid ORDER BY RAND() LIMIT 6"; $result_leftover = $db->query($sql_leftover); while ($row_leftover = $result_leftover->fetch()) { $sql_category = "SELECT c.parent AS parent1, c2.parent AS parent2 FROM productcategories pc JOIN categories c ON pc.categoryid = c.categoryid LEFT JOIN categories c2 ON c2.categoryid = c.parent WHERE pc.productid = '" . mysql_real_escape_string($row_leftover['productid']) . "'"; $result_category = $db->query($sql_category); $row_category = $result_category->fetch(); if ($row_category['parent2'] == 0) { $parents = $row_category['parent1'] . '/'; } else { $parents = $row_category['parent1'] . '/' . $row_category['parent2'] . '/'; } $sql_image = "SELECT pi.filename FROM productimages pi WHERE pi.productid = '" . mysql_real_escape_string($row_leftover['productid']) . "' ORDER BY pi.order LIMIT 1"; $result_image = $db->query($sql_image); if ($result_image->size() == 0) { $filename = 'no_image.jpg'; } else { $row_image = $result_image->fetch(); $filename = $row_image['filename']; } $sql_prices = "SELECT *, r.fldPrice AS reducedTo FROM stock s LEFT JOIN ( SELECT * FROM reductions WHERE ( fldDateStart IS NULL OR fldDateStart <= NOW() ) AND ( fldDateEnd IS NULL OR fldDateEnd >= NOW() ) ) AS r ON r.fldProductID = s.productid WHERE s.productid = '" . mysql_real_escape_string($row_leftover['productid']) . "' AND s.status = 'live' ORDER BY s.price"; $result_prices = $db->query($sql_prices); $row_prices = $result_prices->fetch(); $price = $row_prices['price']; $reducedPrice = $row_prices['reducedTo']; // Figure out image size for markup $tmpImagePath = 'http://'.$serverName.'/product_images/image_resize.php?image='.urlencode($filename).'&max_width=85&max_height=125'; $tmpImageData = getimagesize($tmpImagePath); if(is_null($reducedPrice)) $priceDisplay = '£'.number_format(round($price,2),2); else $priceDisplay = 'was £'.number_format(round($price,2),2).'
now £'.number_format(round($reducedPrice,2),2).''; if(!empty($row_leftover['description'])){ $description = $row_leftover['description']; } else { $description = "No description set"; } echo '
' .'Image preview of '.htmlentities($row_leftover['name'], ENT_QUOTES, 'UTF-8').'' .'
' .'

'.htmlentities($row_leftover['name'], ENT_QUOTES, 'UTF-8').'

'."\n" .'

'.substr(strip_tags($description), 0, 40).'...

' .'
' .'
'."\n"; $col++; } } // Slightly messy markup but we need to pad the columns out for this design to work if($col > 1) { while($col < 4) { echo '
 
'; $col++; } } ?>

Secure online shopping

You can pay online with these credit and debit cards:

Visa, Mastercard, Switch, Solo, Maestro • Thawte SSL Security

Terms & Conditions | Contact | Site Map

The Fusilier Museum is a Registered Charity (Registered in England No. 206186), Tel: 01494 601 300

eCommerce development leeds by newmediaboutique

*/ ?>