BR MODS - SELECT `catalogues_products`.`active`, `catalogues_products`.`rrpPrice`, `catalogues_products`.`brandGroup`, `catalogues_products`.`ISPCFull`, `catalogues_products`.`ISPCStandard`, `catalogues_products`.`IdCatProduct`, `integra_fusion`.`fs_p_products`.`IdProduct`, `integra_fusion`.`fs_p_products`.`description`, `integra_fusion`.`fs_p_products`.`smallImageUrl`, `integra_fusion`.`fs_p_products`.`sku`, `integra_fusion`.`fs_p_products`.`vatCode`, `integra_fusion`.`fs_p_products`.`packSize1`, `integra_fusion`.`fs_p_products`.`packSize2`, `integra_fusion`.`fs_p_products`.`recycled`, `integra_fusion`.`fs_p_products`.`economy`, `integra_fusion`.`fs_p_products`.`priority` FROM `catalogues_products` INNER JOIN `catalogues_customers` ON `catalogues_products`.`IdCatalogueProduct` = `catalogues_customers`.`idCatalogue` INNER JOIN `integra_fusion`.`fs_p_products` ON `catalogues_products`.`idProductCatalogue` = `integra_fusion`.`fs_p_products`.`IdProduct` INNER JOIN `products_offers_list` ON `catalogues_products`.`idProductCatalogue` = `products_offers_list`.`IdProduct` LEFT JOIN `products_sort` ON `catalogues_products`.`IdProductCatalogue` = `products_sort`.`IdProduct` WHERE `integra_fusion`.`fs_p_products`.`active` = -1 AND `catalogues_products`.`active` = -1 AND `catalogues_customers`.`IdCustomer` = 0 AND `products_offers_list`.`idOfferList`=2 ORDER BY `catalogues_products`.`priority` ASC, `integra_fusion`.`fs_p_products`.`description` ASC, `catalogues_products`.`rrpPrice` ASC;

Product Filters Recycled Products 2Hole A4 A4 Size
Assorted Desktop Staplers Dividers Pocket White 80gsm White 80gsm White Plain White Plain White Plain White Window White Window White Window Yellow Standard Sizes
More...
Brands Filofax Nice Price Own Brand
Q Connect
More...
Our Price £51.99 ex Vat
Add to My Favourites

Q Connect Board Lever Arch File A4

Product Code: KF20001 Pack Size: 10 More Information
0 Stars
Our Top Seller
Our Price £4.95 ex Vat RRP: £31.69 You Save: 84%
Add to My Favourites
0 Stars
Our Top SellerHot Deal
Our Price £45.59 ex Vat
Add to My Favourites
0 Stars
Our Top Seller
Our Price £53.09 ex Vat
Add to My Favourites
0 Stars
Our Top Seller
Our Price £49.59 ex Vat
Add to My Favourites
0 Stars
Our Top Seller
Our Price £61.99 ex Vat
Add to My Favourites
0 Stars
Our Top Seller
Our Price £56.49 ex Vat
Add to My Favourites
0 Stars
Our Top SellerHot Deal
Our Price £61.99 ex Vat
Add to My Favourites
0 Stars
Our Top Seller
Our Price £4.69 ex Vat
Add to My Favourites
0 Stars
Our Top Seller
Our Price £45.99 ex Vat
Add to My Favourites
0 Stars
Our Top Seller

© 2009-2010 DIO (UK) Ltd. All rights reserved.