Product Filters White 80gsm Vinyl TV
Digital Pictures PC Tablet Unspecified Bags Cases Unspecified Coffee Hot Drinks Cold Drinks Sweets/Chocolate Biscuits Breakfast/Snacks Hand/Soap
More...
Brands Kensington Masters Unknown
Nescafe Q Connect Cadburys Robinsons OfficeThings
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`, `integra_fusion`.`fs_p_products`.`emailText` AS image_path 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 642

Go Ahead Cocoa and Hazelnut Goodness Bar (Pack of 16) 35294

Product Code: UN16870 Pack Size: 1

0 Stars
Points 900

Nescafe Gold Blend Coffee 750g 12284102

Product Code: NL82020 Pack Size: 1

0 Stars
Hot Deal
Points 1095

Cadbury Instant Hot Chocolate Sachets 28g (Pack of 50) 915654

Product Code: KS04386 Pack Size: 1

0 Stars
Points 1158

Foxs Glacier Fruits 200g 0401003

Product Code: CPD92056 Pack Size: 12

0 Stars
Points 1203

Crawfords Assorted Mini Biscuit (Pack of 100) 99848

Product Code: BZ02044 Pack Size: 1

0 Stars
Points 1320

Alassio Mondo Trolley Pilot Case Laptop Compartment 2 Combination Locks Leather-look Black Ref 45033

Product Code: 323060 Pack Size: 1

0 Stars
Points 1405

Jacobs Mini Cheddars Original Grab Bag (Pack of 30) 36564

Product Code: UN07621 Pack Size: 1

0 Stars
Points 1530

Canon PIXMA MG3050 All in One Printer 1346C008

Product Code: CO06277 Pack Size: 1

0 Stars
Points 1850

Gino Ferrari Eros 16 Inch Laptop Backpack Red Trim GF507

Product Code: MD59864 Pack Size: 1

0 Stars
Points 2640

Lightpak Master Laptop Backpack with Trolley Nylon Capacity 17in Black Ref 46005

Product Code: 323288 Pack Size: 1

0 Stars
logos