Product Filters Tea Sweets/Chocolate More...
Brands Unknown Nestle Cadburys
Tetley
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 75
Nestle Quality Street Assorted Chocolates Box 400g Ref 12102543

Nestle Quality Street Assorted Chocolates Box 400g Ref 12102543

Product Code: 174332 Pack Size: 1
0 Stars
Points 80
Cadbury Favourites Bag Fairtrade Chocolates 350g Ref A06966

Cadbury Favourites Bag Fairtrade Chocolates 350g Ref A06966

Product Code: 667853 Pack Size: 1
0 Stars
Points 250
Tetley Tea Bags Camomile Smile Individually Wrapped Ref A06677 [Pack 25]

Tetley Tea Bags Camomile Smile Individually Wrapped Ref A06677 [Pack 25]

Product Code: 128831 Pack Size: 1
0 Stars
Points 330
Twix Fingers Chocolate Caramel Biscuit Singles Ref A07378 [Pack 24]

Twix Fingers Chocolate Caramel Biscuit Singles Ref A07378 [Pack 24]

Product Code: 179212 Pack Size: 1
0 Stars
Points 350
Cadbury Variety Treatsize Selection Chocolates 22 Bars in 345g Bag Ref A07034

Cadbury Variety Treatsize Selection Chocolates 22 Bars in 345g Bag Ref A07034

Product Code: 798683 Pack Size: 1
0 Stars
Office Paper Supplies
Office Supplies
Office Storage Filing Cabinets

© 2009-2012 Metrik Office Supplies. All rights reserved.