Product Filters Coffee Cold Drinks Biscuits
Unspecified
More...
Brands Unknown Nestle Own Brand
CBS Office Boots Marks & Spencer I Tunes Patersons Tunnocks
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 140

Patersons Luxury Traditional Scottish Shorbread Fingers 380g

Product Code: PSF Pack Size: 1

0 Stars
Points 140

McVitties Milk Chocolate Digestives

Product Code: MCD Pack Size: 1

0 Stars
Points 140

Kit Kat 2 Finger Milk Chocolate Wafer Biscuit Bar Pk7

Product Code: KKAT Pack Size: 1

0 Stars
Points 150

Tunnocks Original Caramel Wafer Biscuits

Product Code: TCW Pack Size: 1

0 Stars
Points 250

Crawfords Assorted Biscuit Selection 285g

Product Code: FF Pack Size: 1

0 Stars
Points 295

Thomas Judge Delectable Dark Chocolate Flapjacks

Product Code: TJF Pack Size: 1

5 Stars
Points 400

Harrogate Sparkling Water Plastic Bottle 500ml Ref P500242C [Pack 24]

Product Code: 123964 Pack Size: 1

0 Stars
Points 400

Costa Roast & Ground Coffee Original 200g Bag

Product Code: COSTA Pack Size: 1

0 Stars
Points 500

Pig Of Happiness - Monkton Mug Pink

Product Code: MM11 Pack Size: 1

0 Stars
Points 1500

Boots Voucher £10

Product Code: BV10 Pack Size: 1

0 Stars