Product Filters Unspecified Hard Bags
Toaster Sweets/Chocolate Biscuits
More...
Brands Masters Unknown Verbatim
Nestle Cadburys My Brand
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 300

Cadbury Signature Biscuits 15388

Product Code: BZ70916 Pack Size: 1

0 Stars
Points 1000

Nestle KitKat Four Finger Box of 48 12278388

Product Code: NL18174 Pack Size: 1

0 Stars
Points 1150

Igenix 2 Slice Steel Toaster FCL103/H

Product Code: HID52925 Pack Size: 1

0 Stars
Points 2000

Verbatim Store n Go USB 3.0 Portable 500GB Silver Hard Drive 53021

Product Code: VM30213 Pack Size: 1

0 Stars
Points 3200

Monolith Multifunctional Nylon Black Laptop Backpack and Grey 2399

Product Code: HM23990 Pack Size: 1

0 Stars
Points 3500

Fuji A170 Digital Camera

Product Code: DP10222 Pack Size: 0

0 Stars

© 2012 Delta Pi Office Equipment. All rights reserved.