Product Filters 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 400

Love2shop Five Pound Gift Voucher (Please note: this product is used in our Rewards point programme and not for sale)

Product Code: L2S5PV Pack Size: 1

Availability: Please Call

0 Stars
Points 400

Amazon.co.uk £5 eGift Voucher (Please note: this product is used in our Rewards point programme and not for sale)

Product Code: amazon52V Pack Size: 1

Availability: Please Call

0 Stars
Points 800

Amazon.co.uk £10 eGift Voucher (Please note: this product is used in our Rewards point programme and not for sale)

Product Code: amazon10 Pack Size: 0

Availability: Please Call

0 Stars
Points 800

Love2shop Ten Pound Gift Voucher (Please note: this product is used in our Rewards point programme and not for sale)

Product Code: L2S10PV Pack Size: 1

Availability: Please Call

0 Stars
Points 1200

Amazon.co.uk £15 eGift Voucher (Please note: this product is used in our Rewards point programme and not for sale)

Product Code: amazon15 Pack Size: 0

Availability: Please Call

0 Stars
Points 1600

Amazon.co.uk £20 eGift Voucher (Please note: this product is used in our Rewards point programme and not for sale)

Product Code: amazon20 Pack Size: 0

Availability: Please Call

0 Stars
Points 1600

Love2shop Twenty Pound Gift Voucher (Please note: this product is used in our Rewards point programme and not for sale)

Product Code: L2S20PV Pack Size: 1

Availability: Please Call

0 Stars
Points 4000

Amazon.co.uk £50 eGift Voucher (Please note: this product is used in our Rewards point programme and not for sale)

Product Code: amazon50 Pack Size: 0

Availability: Please Call

0 Stars