Welcome to Frank Berry Otter

Don't forget to add BLOCKDEC as a product line to your December blocking orders for 50% off!

SELECT `catalogues_products`.`rrpPrice`, `integra_fusion`.`fs_p_products`.`idProduct`, `integra_fusion`.`fs_p_products`.`description`, `integra_fusion`.`fs_p_products`.`packSize1`, `integra_fusion`.`fs_p_products`.`sku`, `integra_fusion`.`fs_p_products`.`imageUrl` FROM `catalogues_customers` INNER JOIN `catalogues_products` ON `catalogues_products`.`IdCatalogueProduct` = `catalogues_customers`.`idCatalogue` INNER JOIN `products_offers_list` ON `products_offers_list`.`idProduct` = `catalogues_products`.`idProductCatalogue` INNER JOIN `integra_fusion`.`fs_p_products` ON `catalogues_products`.`idProductCatalogue` = `integra_fusion`.`fs_p_products`.`idProduct` WHERE `products_offers_list`.`idOfferList` = 2 AND `catalogues_products`.`active` = -1 AND `integra_fusion`.`fs_p_products`.`active` = -1 AND `catalogues_customers`.`idCustomer` = 0 ORDER BY RAND() LIMIT 0,4;"

© 2012 Frank Berry Otter. All rights reserved.