SELECT SQL_CALC_FOUND_ROWS * ,LEAST(IF(price1_1 > 0, (price1_1 * (1-(discount/100))),9999), IF(price2_1 > 0, (price2_1 * (1-(discount/100))),9999), IF(price3_1 > 0, (price3_1 * (1-(discount/100))),9999), IF(price4_1 > 0, (price4_1 * (1-(discount/100))),9999), IF(price5_1 > 0, (price5_1 * (1-(discount/100))),9999), IF(price6_1 > 0, (price6_1 * (1-(discount/100))),9999)) AS priceMin FROM `jos_virtuemart_products_en_gb` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jos_productPrices` ON p.`virtuemart_product_id` = `jos_productPrices`.`product_id` LEFT JOIN `jos_productDetails` ON p.`virtuemart_product_id` = `jos_productDetails`.`product_id` LEFT JOIN `jos_virtuemart_product_categories` ON p.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `jos_virtuemart_product_categories`.`virtuemart_category_id` WHERE ( p.`published`="1" AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 210) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Get Quote fixed at Live Price
Thank You for your enquiry!We will be in touch soon
Live price deal
Min. 1000 per order
For info or to order call0844 8117 566or email: firstname.lastname@example.org
As contactless card payments become more popular, it is important to consider the security of your card in public. With some scammers able to skim details from your card through your wallet and even your clothes, the CardCop presents a valuable line of protection against fraud. Made from Aluminium Ferrule infused DuraMesh plastic, the CardCop will stop any and all attempts to steal your card data. Simply slip your card inside the CardCop and the card is totally safe from any scanning devices. The Card Cop is also useful on the London Underground, where ticket machines can often scan both your Oyster Card and Debit Card, meaning you get charged more than once. Isolate one card in the CardCop and stop worrying about multiple payments being taken.
Full colour print to 1 position
There is a screen setup cost of £60.75 per position/ imprint type.