| 0.0004 |
Select * from material_tooltip_info WHERE material_name LIKE 'Permanent'
|
| 0.0448 |
Select * From products Where `CategoryID` = 'c798R1' AND `Adhesive` LIKE 'Permanent' Order By `productID` desc LIMIT 1
|
| 0.1673 |
SELECT DISTINCT(ColourMaterial) AS Material FROM `products` WHERE CategoryID ='c798R1' AND Adhesive LIKE 'Permanent' and Activate='Y'
and ColourMaterial!='' order by ColourMaterial asc
|
| 0.1662 |
SELECT DISTINCT(Adhesive) AS Adhesive FROM `products` WHERE CategoryID ='c798R1' AND Adhesive LIKE 'Permanent' and Activate='Y'
and Adhesive!='' order by Adhesive asc
|
| 0.1648 |
SELECT DISTINCT(LabelColor) AS Color FROM `products` WHERE CategoryID ='c798R1' AND Adhesive LIKE 'Permanent' and Activate='Y'
and LabelColor!='' order by LabelColor asc
|
| 0.1683 |
SELECT * FROM `products` WHERE CategoryID ='c798R1' AND Adhesive LIKE 'Permanent' AND Activate='Y'
GROUP BY CONCAT(LabelFinish,'',ColourMaterial) order by priority asc
|
| 0.1654 |
SELECT * FROM `products` WHERE CategoryID ='c798R1' AND Adhesive NOT LIKE 'Permanent' AND ProductID <> '155312' AND Activate='Y'
GROUP BY CONCAT(LabelFinish,'',ColourMaterial) order by priority asc
|
| 0.0003 |
SELECT * from page_meta_tags where page_url LIKE 'labels-by-adhesive-rolls/permanent' LIMIT 1
|
| 0.0001 |
SELECT * from page_meta_tags where page_url LIKE 'labels-by-adhesive-rolls/permanent%' LIMIT 1
|
| 0.0001 |
select * from exchange_rates where status LIKE 'active' Order by ID ASC
|
| 0.0017 |
SELECT * FROM temporaryshoppingbasket WHERE SessionID = 'bd562d03570b1170aea7c8704186e5e7' ORDER BY `temporaryshoppingbasket`.`ID` ASC
|
| 0.0042 |
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.0035 |
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 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Polyethylene' order by priority desc
|
| 0.0001 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Polyethylene'
|
| 0.0003 |
Select * from material_tooltip_info WHERE material_code LIKE 'PETP'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Dissolving Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Dissolving Paper'
|
| 0.0004 |
Select * from material_tooltip_info WHERE material_code LIKE 'WTDP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Matt White Fabric Friendly' AND material_type LIKE 'Fabric Friendly Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt White Fabric Friendly' AND material_type LIKE 'Fabric Friendly Paper'
|
| 0.0003 |
Select * from material_tooltip_info WHERE material_code LIKE 'FABP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Paper'
|
| 0.0313 |
Select * from products where LabelFinish LIKE 'Matt White' AND ColourMaterial LIKE 'Paper' AND LabelColor LIKE 'Matt White' AND CategoryID LIKE 'c798R1' AND Adhesive LIKE 'Permanent' LIMIT 1
|
| 0.0004 |
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 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Direct Thermal Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Direct Thermal Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'TEP'
|
| 0.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Polypropylene'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'MWP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Direct Thermal Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Direct Thermal Polypropylene'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'TWPP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Semi Gloss White' AND material_type LIKE 'Paper'
|
| 0.0004 |
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 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Gloss White Inkjet' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Gloss White Inkjet' AND material_type LIKE 'Paper'
|
| 0.0004 |
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 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Polypropylene'
|
| 0.0004 |
Select * from material_tooltip_info WHERE material_code LIKE 'PGWP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Gloss White Inkjet' AND material_type LIKE 'Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Gloss White Inkjet' AND material_type LIKE '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 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' 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 'Rolls' 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 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Pearlescent' AND material_type LIKE 'Paper' order by priority desc
|
| 0.0003 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Pearlescent' AND material_type LIKE 'Paper'
|
| 0.0006 |
Select * from material_tooltip_info WHERE material_code LIKE 'FQP'
|
| 0.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Blockout Cover Up' AND material_type LIKE 'Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'MOP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Clear' AND material_type LIKE 'Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Clear' AND material_type LIKE 'Polypropylene'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'PGCP'
|
| 0.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' 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 'Rolls' 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 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0009 |
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 'Rolls' AND finish_type LIKE 'Metallic' AND material_type LIKE 'Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Metallic' AND material_type LIKE 'Polypropylene'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'PBSP'
|
| 0.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0008 |
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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Matt' AND material_type LIKE 'Paper'
|
| 0.1598 |
Select * from products where LabelFinish LIKE 'Matt' AND ColourMaterial LIKE 'Paper' AND LabelColor LIKE 'Blue' AND CategoryID LIKE 'c798R1' AND Adhesive LIKE 'Permanent' LIMIT 1
|
| 0.0004 |
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 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' AND finish_type LIKE 'Matt' AND material_type LIKE 'Direct Thermal Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt' AND material_type LIKE 'Direct Thermal Paper'
|
| 0.0004 |
Select * from material_tooltip_info WHERE material_code LIKE 'TEPY'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Matt' AND material_type LIKE 'Parcel Paper'
|
| 0.0005 |
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 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Matt' AND material_type LIKE 'Luxury Paper'
|
| 0.1519 |
Select * from products where LabelFinish LIKE 'Matt' AND ColourMaterial LIKE 'Luxury Paper' AND LabelColor LIKE 'Luxury Cream' AND CategoryID LIKE 'c798R1' AND Adhesive LIKE 'Permanent' LIMIT 1
|
| 0.0003 |
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 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0001 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0009 |
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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Fluorescent' AND material_type LIKE 'Paper'
|
| 0.0307 |
Select * from products where LabelFinish LIKE 'Fluorescent' AND ColourMaterial LIKE 'Paper' AND LabelColor LIKE 'Fluorescent Green' AND CategoryID LIKE 'c798R1' AND Adhesive LIKE 'Permanent' LIMIT 1
|
| 0.0004 |
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 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0010 |
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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Paper'
|
| 0.0313 |
Select * from products where LabelFinish LIKE 'Matt White' AND ColourMaterial LIKE 'Paper' AND LabelColor LIKE 'Matt White' AND CategoryID LIKE 'c798R1' AND Adhesive LIKE 'Peelable' LIMIT 1
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'WTR'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0008 |
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 'Rolls' 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 'Rolls' 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.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0009 |
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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Temperature Resistant' AND material_type LIKE 'Polyethylene'
|
| 0.0004 |
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 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0009 |
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 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Direct Thermal Paper' order by priority desc
|
| 0.0003 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Direct Thermal Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'TER'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0008 |
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 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Direct Thermal Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt White' AND material_type LIKE 'Direct Thermal Polypropylene'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'TWPR'
|
| 0.0003 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0009 |
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 'Rolls' 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 'Rolls' AND finish_type LIKE 'Semi Gloss White' AND material_type LIKE 'Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'SGP'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0009 |
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 'Rolls' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Gloss White' AND material_type LIKE 'Polypropylene'
|
| 0.0004 |
Select * from material_tooltip_info WHERE material_code LIKE 'PWRR'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0009 |
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 'Rolls' AND finish_type LIKE 'Clear' AND material_type LIKE 'Polypropylene' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Clear' AND material_type LIKE 'Polypropylene'
|
| 0.0004 |
Select * from material_tooltip_info WHERE material_code LIKE 'PGCR'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0009 |
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 'Rolls' AND finish_type LIKE 'Matt' AND material_type LIKE 'Direct Thermal Paper' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt' AND material_type LIKE 'Direct Thermal Paper'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'TERY'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'COMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0009 |
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 'Rolls' AND finish_type LIKE 'Matt' AND material_type LIKE 'Vinyl' order by priority desc
|
| 0.0002 |
SELECT ahesive as Adhesive FROM `products_adhesive` WHERE type LIKE 'Rolls' AND finish_type LIKE 'Matt' AND material_type LIKE 'Vinyl'
|
| 0.0005 |
Select * from material_tooltip_info WHERE material_code LIKE 'MBV'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Direct Thermal'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Thermal Transfer'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Laser'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0002 |
Select description from materials_compatibility WHERE print_method LIKE 'Inkjet'
AND type LIKE 'INCOMPATIBLE' AND product LIKE 'roll'
|
| 0.0008 |
select rate from exchange_rates where currency_code LIKE 'GBP'
|
GBP (
£ ) 
EUR (
€ ) 
USD (
$ ) 
