Product Filters Coffee Tea Sweets/Chocolate
Biscuits Binliner/Bags Unspecified
More...
Brands 5 Star Unknown Nescafe
Nestle Magno Paper
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 200

Nestle Blue Riband Milk Chocolate Covered Biscuits Individually Wrapped Ref 12232566 [Pack 8]

Product Code: 100413 Pack Size: 1

Availability: 46 In Stock

0 Stars
Points 200

Nestle Breakaway Milk Chocolate Covered Biscuits Individually Wrapped Ref 12232568 [Pack 8]

Product Code: 100409 Pack Size: 1

Availability: 17 In Stock

0 Stars
Points 200

Nestle Kit Kat Chocolate Bars 2 Finger Bars Ref 12278343 [Pack 8]

Product Code: 713331 Pack Size: 1

Availability: Please Call

0 Stars
Points 250

Fox's Glacier Mints Wrapped Boiled Sweets in Bag 200g Ref A07732

Product Code: 259189 Pack Size: 1

Availability: 100 In Stock

0 Stars
Points 270

McVities Milk Chocolate Digestives Biscuits 250g Ref A06918

Product Code: 609648 Pack Size: 1

Availability: Please Call

0 Stars
Points 300

Crawfords Teatime Varieties Biscuits Assorted 6 Types 275g Ref A07549

Product Code: 386024 Pack Size: 1

Availability: 350 In Stock

0 Stars
Points 1000

Amazon Gift Voucher £10 Value

Product Code: REW7235 Pack Size: 1

Availability: Please Call

0 Stars
Points 1000

Next Gift Voucher £10 Value

Product Code: REW004 Pack Size: 1

Availability: Please Call

0 Stars
Points 1000

W H Smith Gift Voucher £10 Value

Product Code: REW003 Pack Size: 1

Availability: Please Call

0 Stars
Points 1000

Love2shop Gift Vouchers £10 Love2shop Gift Vouchers are accepted at a huge range of stores

Product Code: REW7025 Pack Size: 1

Availability: Please Call

0 Stars

© 2012 Index Computer supplies. All rights reserved.