Product Filters Unspecified Cold Drinks Biscuits
Unspecified Unspecified
More...
Brands Coca Cola 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 140

Coca Cola Coke Soft Drink Can 330ml Ref 0402002 [Pack 24]

Product Code: 507591 Pack Size: 1

Availability: 81 In Stock

0 Stars
Points 165

One 4 All Voucher

Product Code: VOUCHER15 Pack Size: 1

Availability: Please Call

0 Stars
Points 230

Nestle Big Chocolate Box Assorted 99 - 106 Calories Per Bar Ref 12391006 [Pack 70]

Product Code: 107430 Pack Size: 1

Availability: Please Call

0 Stars
Hot Deal
Points 430

Hama Inductive Charger Compact Design Ref 178220

Product Code: 156159 Pack Size: 1

Availability: Please Call

0 Stars
Points 860

Archos Access 101 3G Tablet

Product Code: 4548085 Pack Size: 1

Availability: Please Call

0 Stars

Copyright © 2018 Quest Systems | Registered in Ireland

Powered by Evolution Software