Product Filters Adaptors Network Unspecified
Gamepad Coffee Hot Drinks Cold Drinks Sweets/Chocolate Biscuits Vacuum Unspecified Unspecified
More...
Brands 3COM Unknown D-Link
Coca Cola Nestle Cadburys Magno Paper Own 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 2

Nestle Yorkie Biscuit (Pack of 7) 12130127

Product Code: NL92628 Pack Size: 1

Availability: 250 In Stock

0 Stars
Points 5

Crawfords Teatime Assorted Biscuits 275g 21421

Product Code: BZ16543 Pack Size: 1

Availability: 2466 In Stock

0 Stars
Points 9

Cadbury Heroes Variety Bag A06966

Product Code: BZ50233 Pack Size: 1

Availability: 513 In Stock

0 Stars
Points 12

Maoam Minis Chew Sweets (Pack of 40) 50542

Product Code: HB91939 Pack Size: 1

Availability: Please Call

0 Stars
Points 12

Haribo Giant Happy Cherries Tub 12244

Product Code: HB92624 Pack Size: 1

Availability: 50 In Stock

0 Stars
Points 12

Haribo Giant Dummies (60 Sweet) Tub 135440

Product Code: HB90314 Pack Size: 1

Availability: 85 In Stock

0 Stars
Points 12

Haribo Giant Strawbs (120 Sweet) Drum 9547

Product Code: HB92617 Pack Size: 1

Availability: 91 In Stock

0 Stars
Points 12

Haribo Giant Dummies Zing Tub 13444

Product Code: HB91395 Pack Size: 1

Availability: 68 In Stock

0 Stars
Points 12

Haribo Giant Yellow Bellies Tub 096444

Product Code: HB90279 Pack Size: 1

Availability: 197 In Stock

0 Stars
Points 15

Oreo Biscuits Twin Pack (Pack of 24) 915529

Product Code: KS42491 Pack Size: 1

Availability: 41 In Stock

0 Stars

Copyright © 2019 Office Needs (Essex) Limited | Registered in England & Wales

Powered by Evolution Software