Product Filters Sweets/Chocolate Biscuits More...
Brands Unknown Cadburys 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 5

Cadbury Heroes Family Bag 278g Ref A03807

Product Code: 667853 Pack Size: 1

0 Stars
Points 5

Cadbury Signature Biscuit Collection Variety Pack 250g Ref 4042101

Product Code: 595865 Pack Size: 1

0 Stars
Points 10

Crawfords Family Circle Biscuits Re-sealable Box 10 Varieties 720g Assorted Ref 0401018

Product Code: 130405 Pack Size: 1

0 Stars

© 2015 Centrol Office Supplies. All rights reserved.