Product Filters Other Size Recycled Dictionary/Thesaurus
Unspecified Unspecified Non-Magnetic Webcams Wallets Alarms Coffee Coffee Maker Sweets/Chocolate Biscuits Accessories Air Freshener
More...
Brands Biro Bic Collins Unknown
Q Connect Seager Post-It Z Notes Nestle CPD Cadburys Trust
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` 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 50
Q-Connect Duo Nib Felt Tip Pen KF02336

Q-Connect Duo Nib Felt Tip Pen KF02336

Product Code: KF02336 Pack Size: 10
0 Stars
Points 50
Q-Connect Photo Album 30 Pockets Red KF02757

Q-Connect Photo Album 30 Pockets Red KF02757

Product Code: KF02757 Pack Size: 1
0 Stars
Points 100
Neutradol One Touch Odour Destroyer KMS22825

Neutradol One Touch Odour Destroyer KMS22825

Product Code: CPD00061 Pack Size: 1
0 Stars
Points 100
Q-Connect CD Wallet 24 Capacity Black

Q-Connect CD Wallet 24 Capacity Black

Product Code: KF02204 Pack Size: 1
0 Stars
Points 100
Bic Velleda Dry Wipe Board 190x260mm Blue 218 002183

Bic Velleda Dry Wipe Board 190x260mm Blue 218 002183

Product Code: CN218 Pack Size: 1
0 Stars
Points 150
3M Post-it Note Recycled Z-Note Deskgrip Dispenser 76x76mm B330-1R-EU

3M Post-it Note Recycled Z-Note Deskgrip Dispenser 76x76mm B330-1R-EU

Product Code: 3M27406 Pack Size: 1
0 Stars
Recycled Product
Points 150
Seager Sonca Safeguard Key Ring Panic Alarm 5184SP

Seager Sonca Safeguard Key Ring Panic Alarm 5184SP

Product Code: SW42021 Pack Size: 1
0 Stars
Points 150
Cafe Direct Fair Trade Organic Roast/Ground Machu Picchu Coffee 227gm TWI12026

Cafe Direct Fair Trade Organic Roast/Ground Machu Picchu Coffee 227gm TWI12026

Product Code: GAL00944 Pack Size: 1
0 Stars
Points 160
Collins Gem English Dictionary ISBN:9780007290338

Collins Gem English Dictionary ISBN:9780007290338

Product Code: CL29033 Pack Size: 1
0 Stars
Points 185
Cadburys Variety Bag A06966

Cadburys Variety Bag A06966

Product Code: BZ50233 Pack Size: 1
0 Stars

2009-2010 © Forth Office Supplies