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 200
Product Code: 100413
Pack Size: 1
Availability: Please Call
Points 200
Product Code: 100409
Pack Size: 1
Availability: 61 In Stock
Points 200
Product Code: 713331
Pack Size: 1
Availability: 62 In Stock
Points 250
Product Code: 259189
Pack Size: 1
Availability: 122 In Stock
Points 270
Product Code: 609648
Pack Size: 1
Availability: Please Call
Points 300
Product Code: 386024
Pack Size: 1
Availability: 240 In Stock
Points 1000
Product Code: REW7235
Pack Size: 1
Availability: Please Call
Points 1000
Product Code: REW004
Pack Size: 1
Availability: Please Call
Points 1000
Product Code: REW003
Pack Size: 1
Availability: Please Call
Points 1000
Product Code: REW7025
Pack Size: 1
Availability: Please Call
![Nestle Blue Riband Milk Chocolate Covered Biscuits Individually Wrapped Ref 12232566 [Pack 8]](https://e7ut8we.cloudimg.io/s/fit/100x100/http://cdn.fusionplus.net/productimages/openrange/100413.jpg)
![Nestle Breakaway Milk Chocolate Covered Biscuits Individually Wrapped Ref 12232568 [Pack 8]](https://e7ut8we.cloudimg.io/s/fit/100x100/http://cdn.fusionplus.net/productimages/openrange/100409.jpg)
![Nestle Kit Kat Chocolate Bars 2 Finger Bars Ref 12278343 [Pack 8]](https://e7ut8we.cloudimg.io/s/fit/100x100/http://cdn.fusionplus.net/productimages/openrange/713331.jpg)
