Product Filters Hot Drinks Unspecified Sweets/Chocolate
Biscuits Office Cleaning Unspecified Unspecified
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 350

Quality Street Chocolates Box

Product Code: QUALITYST Pack Size: 1

Availability: 3 In Stock

0 Stars
Points 1000

Green and Blacks Chocolate Miniature Bars Classic Selection

Product Code: GBGIFT Pack Size: 1

Availability: 3 In Stock

0 Stars
Points 1500

Clipper Fair Trade Hot Chocolate Drink Mix 1KG

Product Code: FTHCGIFT Pack Size: 1

Availability: 2 In Stock

0 Stars
Points 1800

Kleenex Oval Tissue Box Deluxe 3Ply

Product Code: KLNXOVAL Pack Size: 10

Availability: 3 In Stock

0 Stars
Points 1800

RETRO SWEETS 300G CUBE GIFT BOX FOR REWARDS

Product Code: SWEETCUBE Pack Size: 0

Availability: 5 In Stock

0 Stars
Points 2000

Costa Coffee Gift Voucher

Product Code: costagift Pack Size: 1

Availability: 5 In Stock

0 Stars
Recycled Product
Points 3500

Box of assorted Biscuits

Product Code: biscuitbox Pack Size: 1

Availability: 2 In Stock

0 Stars
Points 4000

Love 2 Shop High Street Voucher

Product Code: love2shop Pack Size: 1

Availability: 3 In Stock

0 Stars
Recycled Product
Points 4000

John Lewis and Waitrose Gift Card

Product Code: jlewisgft Pack Size: 1

Availability: 3 In Stock

0 Stars
Points 5500

Pizza Express Gift Voucher

Product Code: pexprssgft Pack Size: 0

Availability: 5 In Stock

0 Stars