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` 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
&pound10 John Lewis/Waitrose Gift Voucher (Not for resale)

£10 John Lewis/Waitrose Gift Voucher (Not for resale)

Product Code: Johnlewis10 Pack Size: 1
0 Stars
Points 200
&pound10 Thomas Cook Voucher (Not for resale)

£10 Thomas Cook Voucher (Not for resale)

Product Code: THOMASCOOK10 Pack Size: 1
0 Stars
Points 200
&pound10 Debenhams Voucher (Not for resale)

£10 Debenhams Voucher (Not for resale)

Product Code: DEBENHAMS10 Pack Size: 1
0 Stars
Points 200
&pound10 hmv Voucher (Not for resale)

£10 hmv Voucher (Not for resale)

Product Code: HMV10 Pack Size: 1
0 Stars
Points 200
&pound10 Halfords Voucher (Not for resale)

£10 Halfords Voucher (Not for resale)

Product Code: HALFORDS10 Pack Size: 1
0 Stars
Points 200
&pound10 Sainsbury Voucher (Not for resale)

£10 Sainsbury Voucher (Not for resale)

Product Code: SAINSBURY10 Pack Size: 1
0 Stars
Points 200
&pound10 Asda Voucher (Not for resale)

£10 Asda Voucher (Not for resale)

Product Code: ASDA10 Pack Size: 1
0 Stars
Points 200
&pound10 Game Voucher (Not for resale)

£10 Game Voucher (Not for resale)

Product Code: Game10 Pack Size: 1
0 Stars
Points 200
&pound10 Next Voucher (Not for resale)

£10 Next Voucher (Not for resale)

Product Code: Next10 Pack Size: 1
0 Stars
Points 200
&pound10 Boots Voucher (Not for resale)

£10 Boots Voucher (Not for resale)

Product Code: Boots10 Pack Size: 1
0 Stars

© 2009-2010 Paperplus (UK) Ltd. All rights reserved.