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 500
Product Code: TOY
Pack Size: 1
Points 600
Product Code: JA1348
Pack Size: 1
Points 700
Product Code: PI9362
Pack Size: 1
Points 850
Product Code: JA6117
Pack Size: 1
Points 950
Product Code: JA9996
Pack Size: 1
Points 1198
Product Code: DW6339
Pack Size: 1
Points 1425
Product Code: PE3921
Pack Size: 12
Points 1498
Product Code: HW1969
Pack Size: 1
Points 1700
Product Code: JA9499
Pack Size: 1
Points 1711
Product Code: PE4076
Pack Size: 1
