Product Filters Mini Bags Cases
Cash Cold Drinks Coffee Maker Sweets/Chocolate Biscuits Cups/Mugs/Glasses Unspecified
More...
Brands 5 Star Filofax Unknown
Coca Cola Nestle Cadburys Dealer Worker
More...

SELECT `integra_fusion`.`fs_p_products`.`IdProduct`, `integra_fusion`.`fs_p_products`.`smallImageUrl`, `integra_fusion`.`fs_p_products`.`sku`, `integra_fusion`.`fs_p_products`.`vatCode`, `integra_fusion`.`fs_p_products`.`recycled`, `integra_fusion`.`fs_p_products`.`economy`, `integra_fusion`.`fs_p_products`.`priority`, `integra_fusion`.`fs_p_products`.`packSize1`, `integra_fusion`.`fs_p_products`.`packSize2`, `integra_fusion`.`fs_p_products`.`description`, `catalogues_products`.`rrpPrice`, `products_rewards`.`points` FROM `catalogues_products` INNER JOIN `products_rewards` ON `products_rewards`.`IdProduct` = `catalogues_products`.`idProductCatalogue` INNER JOIN `catalogues_customers` ON `catalogues_products`.`IdCatalogueProduct` = `catalogues_customers`.`idCatalogue` INNER JOIN `integra_fusion`.`fs_p_products` ON `products_rewards`.`IdProduct` = `integra_fusion`.`fs_p_products`.`IdProduct` WHERE `catalogues_products`.`active` = -1 AND `catalogues_customers`.`IdCustomer` = 0 ORDER BY `products_rewards`.`points` ASC

Points 80
Nestle Kit Kat Chocolate Bars 2 Finger Bars Ref 12097518 [Pack 9]

Nestle Kit Kat Chocolate Bars 2 Finger Bars Ref 12097518 [Pack 9]

Product Code: 713331 Pack Size: 1
0 Stars
Our Top Seller
Points 80
McVities MiniChoc HobNobs Biscuits 125g Ref A07452

McVities MiniChoc HobNobs Biscuits 125g Ref A07452

Product Code: 274351 Pack Size: 1
0 Stars
Points 80
McVities Milk Chocolate Digestives Biscuits 250g Ref A06918

McVities Milk Chocolate Digestives Biscuits 250g Ref A06918

Product Code: 609648 Pack Size: 1
0 Stars
Points 100
Portwest High Visibility Vest Polyester Small-Medium Yellow Ref C470YER S/M

Portwest High Visibility Vest Polyester Small-Medium Yellow Ref C470YER S/M

Product Code: 136714 Pack Size: 1
0 Stars
Points 200
Cadbury Signature Biscuit Collection Variety Pack 300g Ref A06018

Cadbury Signature Biscuit Collection Variety Pack 300g Ref A06018

Product Code: 595865 Pack Size: 1
0 Stars
Points 200
Emsa City Cup Vacuum Insulated Stainless Steel Liner 0.2 Litre Red Ref 504843

Emsa City Cup Vacuum Insulated Stainless Steel Liner 0.2 Litre Red Ref 504843

Product Code: 166821 Pack Size: 1
0 Stars
Points 200
5 Star Cash Box 8 Inch W150xD200xH78mm Blue

5 Star Cash Box 8 Inch W150xD200xH78mm Blue

Product Code: 918893 Pack Size: 1
0 Stars
Points 400
Coca Cola Diet Coke Soft Drink Can 330ml Ref A00749 [Pack 24]

Coca Cola Diet Coke Soft Drink Can 330ml Ref A00749 [Pack 24]

Product Code: 507583 Pack Size: 1
0 Stars
Points 400
Coca Cola Coke Soft Drink Can 330ml Ref A00768 [Pack 24]

Coca Cola Coke Soft Drink Can 330ml Ref A00768 [Pack 24]

Product Code: 507591 Pack Size: 1
0 Stars
Points 400
Krusell Hector Universal Mobile Phone Case Fits Phones Up To 115x18x61mm Black Ref SPKCHL

Krusell Hector Universal Mobile Phone Case Fits Phones Up To 115x18x61mm Black Ref SPKCHL

Product Code: 223828 Pack Size: 1
0 Stars

2009-2010 © Absolute Office Ltd