Product Filters Biscuits Unspecified More...
Brands Unknown 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 3650
McVities Victoria Luxury Biscuit Selection 800g Ref A01688

McVities Victoria Luxury Biscuit Selection 800g Ref A01688

Product Code: 130413 Pack Size: 1
0 Stars
Points 20000
Nintendo DS Lite

Nintendo DS Lite

Product Code: Nintendods Pack Size: 1
5 Stars
Points 23600
Apple Ipod Nano 8GB

Apple Ipod Nano 8GB

Product Code: Nano8gg Pack Size: 01
0 Stars
Points 37000
Wii Console with Sports Resort Package

Wii Console with Sports Resort Package

Product Code: wiisports Pack Size: 0
0 Stars

2009-2010 © SOS Office Supplies