| 0.0007 |
Select * from material_tooltip_info WHERE material_name LIKE 'High Tack'
|
| 0.4833 |
Select * From products Where `CategoryID` = 't16' AND `Adhesive` LIKE 'High Tack' Order By `productID` desc LIMIT 1
|
| 0.1594 |
SELECT DISTINCT(ColourMaterial) AS Material FROM `products` WHERE CategoryID ='t16' AND Adhesive LIKE 'High Tack' and Activate='Y'
and ColourMaterial!='' order by ColourMaterial asc
|
| 0.1601 |
SELECT DISTINCT(Adhesive) AS Adhesive FROM `products` WHERE CategoryID ='t16' AND Adhesive LIKE 'High Tack' and Activate='Y'
and Adhesive!='' order by Adhesive asc
|
| 0.1724 |
SELECT DISTINCT(LabelColor) AS Color FROM `products` WHERE CategoryID ='t16' AND Adhesive LIKE 'High Tack' and Activate='Y'
and LabelColor!='' order by LabelColor asc
|
| 0.1663 |
SELECT * FROM `products` WHERE CategoryID ='t16' AND Adhesive LIKE 'High Tack' AND Activate='Y'
GROUP BY CONCAT(LabelFinish,'',ColourMaterial) order by priority asc
|
| 0.1819 |
SELECT * FROM `products` WHERE CategoryID ='t16' AND Adhesive NOT LIKE 'High Tack' AND ProductID <> '2716' AND Activate='Y'
GROUP BY CONCAT(LabelFinish,'',ColourMaterial) order by priority asc
|
| 0.0005 |
SELECT * from page_meta_tags where page_url LIKE 'labels-by-adhesive-sheets/high-tack' LIMIT 1
|
| 0.0002 |
SELECT * from page_meta_tags where page_url LIKE 'labels-by-adhesive-sheets/high-tack%' LIMIT 1
|
| 0.0001 |
select * from exchange_rates where status LIKE 'active' Order by ID ASC
|
| 0.0019 |
SELECT * FROM temporaryshoppingbasket WHERE SessionID = '09c0127964dbc62659600f57dcc2f98a' ORDER BY `temporaryshoppingbasket`.`ID` ASC
|
| 0.0044 |
SELECT shape_upd, COUNT(*) as num FROM `category` WHERE CategoryActive LIKE 'Y' AND `shape_upd` != ' ' AND labelCategory LIKE 'A4 Labels' Group by shape_upd ORDER BY `category`.`shape_upd` ASC
|
| 0.0034 |
select CategoryName as name,CategoryImage as image from category where CategoryActive LIKE 'Y' AND `specification3` = 'Integrated'
|
| 0.0002 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Vinyl' order by priority desc
|
| 0.0001 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Vinyl'
|
| 0.0003 |
Select * from material_tooltip_info WHERE material_code LIKE 'MBV'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'WTP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0003 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Aluminium Back Coated' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Aluminium Back Coated' AND material_type LIKE 'Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'WASP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0003 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Temperature Resistant' AND material_type LIKE 'Polyethylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Temperature Resistant' AND material_type LIKE 'Polyethylene'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'PETC'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0003 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Security Materials' AND material_type LIKE 'Polyvinyl Chloride' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Security Materials' AND material_type LIKE 'Polyvinyl Chloride'
|
| 0.0004 |
Select * from material_tooltip_info WHERE material_code LIKE 'PVUD'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Polyester' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Polyester'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'WPEP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0003 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Polyethylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Polyethylene'
|
| 0.0004 |
Select * from material_tooltip_info WHERE material_code LIKE 'PETP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0003 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Semi Gloss White' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Semi Gloss White' AND material_type LIKE 'Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'WGP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0002 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Inkjet Paper' order by priority desc
|
| 0.0001 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Inkjet Paper'
|
| 0.0003 |
Select * from material_tooltip_info WHERE material_code LIKE 'GWIP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0003 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Inkjet Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Inkjet Polypropylene'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'PWIP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0005 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Polyester' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Polyester'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'WPGP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0004 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'High Gloss White' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'High Gloss White' AND material_type LIKE 'Paper'
|
| 0.0004 |
Select * from material_tooltip_info WHERE material_code LIKE 'HGP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0004 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Pearlescent' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Pearlescent' AND material_type LIKE 'Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'FQP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0005 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Blockout Cover Up' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Blockout Cover Up' AND material_type LIKE 'Paper'
|
| 0.0006 |
Select * from material_tooltip_info WHERE material_code LIKE 'MOP'
|
| 0.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0004 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Clear' AND material_type LIKE 'Inkjet Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Clear' AND material_type LIKE 'Inkjet Polypropylene'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'PCIP'
|
| 0.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0004 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Clear' AND material_type LIKE 'Polyester' order by priority desc
|
| 0.0003 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Clear' AND material_type LIKE 'Polyester'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'GCPP'
|
| 0.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0004 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Metallic' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Metallic' AND material_type LIKE 'Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'GDP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0004 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Metallic' AND material_type LIKE 'Polyester' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Metallic' AND material_type LIKE 'Polyester'
|
| 0.0725 |
Select * from products where LabelFinish LIKE 'Metallic' AND ColourMaterial LIKE 'Polyester' AND LabelColor LIKE 'Bright Silver' AND CategoryID LIKE 'T16' AND Adhesive LIKE 'Permanent' LIMIT 1
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'BSP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0004 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Luxury Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Luxury Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'FMC'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0003 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Parcel Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Parcel Paper'
|
| 0.0006 |
Select * from material_tooltip_info WHERE material_code LIKE 'BPP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0004 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'BEP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0004 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0003 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Polyester' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Matt' AND material_type LIKE 'Polyester'
|
| 0.0154 |
Select * from products where LabelFinish LIKE 'Matt' AND ColourMaterial LIKE 'Polyester' AND LabelColor LIKE 'Matt Yellow' AND CategoryID LIKE 'T16' AND Adhesive LIKE 'Permanent' LIMIT 1
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'YPEP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0005 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
| 0.0004 |
SELECT colour as LabelColor,imagecode,colour_name FROM `products_colour` WHERE type LIKE 'A4' AND finish_type LIKE 'Fluorescent' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'A4' AND finish_type LIKE 'Fluorescent' AND material_type LIKE 'Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'FGNP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'sheet'
|
| 0.0005 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
GBP (
£ ) 
EUR (
€ ) 
USD (
$ ) 
