Product Filters Unspecified Unspecified More...
Brands 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 10

Quality Street Tin 1.2kg

Product Code: REWARD23 Pack Size: 1

Availability: Please Call

0 Stars
Points 12

Baileys The Original Irish Cream 70cl

Product Code: REWARD14 Pack Size: 1

Availability: Please Call

0 Stars
Points 13

Christmas H-Box

Product Code: REWARD15 Pack Size: 1

Availability: Please Call

0 Stars
Points 14

Haig Club Clubman Single Grain Scotch Whisky 70cl

Product Code: REWARD7 Pack Size: 1

Availability: Please Call

0 Stars
Points 15

Prosecco & Chocolates Hamper

Product Code: REWARD16 Pack Size: 1

Availability: Please Call

0 Stars
Points 17

Bombay Sapphire Distilled London Dry Gin 70c

Product Code: REWARD9 Pack Size: 1

Availability: Please Call

0 Stars
Points 17

Tower of Treats

Product Code: REWARD17 Pack Size: 1

Availability: Please Call

0 Stars
Points 17

The Classic Christmas Chocolate Sleekster

Product Code: REWARD18 Pack Size: 1

Availability: Please Call

0 Stars
Points 18

Peroni Nastro Azzurro 24 x 330ml

Product Code: REWARD19 Pack Size: 1

Availability: Please Call

0 Stars
Points 18

San Miguel 24 x 330ml

Product Code: REWARD20 Pack Size: 1

Availability: Please Call

0 Stars

© 2015 Colyer London. All rights reserved.