Product List

My Basket

Top Sellers

My Account

Customer Services

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`=1 ORDER BY `catalogues_products`.`priority` ASC, `integra_fusion`.`fs_p_products`.`description` ASC, `catalogues_products`.`rrpPrice` ASC;