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 70
Product Code: 713331
Pack Size: 1
Points 80
Product Code: 609648
Pack Size: 1
Points 85
Product Code: 274351
Pack Size: 1
Points 100
Product Code: 461696
Pack Size: 1
Points 105
Product Code: 165453
Pack Size: 1
Points 125
Product Code: 534470
Pack Size: 1
Points 165
Product Code: 667853
Pack Size: 1
Points 170
Product Code: 143056
Pack Size: 1
Points 175
Product Code: 294904
Pack Size: 1
Points 250
Product Code: 810354
Pack Size: 1