Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` WHERE (`pinfo`.`sku` IN ('WOOD24HCRLO','WOOD24HCRMH','WOOD24HCRMO','WOOD24HCRNLO','WOOD24HCRNMH','WOOD24HCRNMO','WOOD24SCRLO','WOOD24SCRLO58','WOOD24SCRMH','WOOD24SCRMH58','WOOD24SCRMO','WOOD24SCRMO58','WOOD32HCRLO','WOOD32HCRMH','WOOD32HCRMO','WOOD32HCRNLO','WOOD32HCRNMH','WOOD32HCRNMO','WOOD32SCRLO','WOOD32SCRLO58','WOOD32SCRMH','WOOD32SCRMH58','WOOD32SCRMO','WOOD32SCRMO58','WOOD36HCRLO','WOOD36HCRMH','WOOD36HCRMO','WOOD36HCRNLO','WOOD36HCRNMH','WOOD36HCRNMO','WOOD36SCRLO','WOOD36SCRLO58','WOOD36SCRMH','WOOD36SCRMH58','WOOD36SCRMO','WOOD36SCRMO58','WOOD48DCRLO','WOOD48DCRLO58','WOOD48DCRMH','WOOD48DCRMH58','WOOD48DCRMO','WOOD48DCRMO58','WOOD64DCRLO','WOOD64DCRLO58','WOOD64DCRMH','WOOD64DCRMH58','WOOD64DCRMO','WOOD64DCRMO58','WOOD72DCRLO','WOOD72DCRLO58','WOOD72DCRMH','WOOD72DCRMH58','WOOD72DCRMO','WOOD72DCRMO58','WOODAC121LO','WOODAC121MH','WOODAC121MO','WOODAC12FSLO','WOODAC12FSMH','WOODAC12FSMO','WOODAC192LO','WOODAC192MH','WOODAC192MO','WOODAC194LO','WOODAC194MH','WOODAC194MO','WOODAC263LO','WOODAC263MH','WOODAC263MO','WOODAC266LO','WOODAC266MH','WOODAC266MO','WOODAC269LO','WOODAC269MH','WOODAC269MO','WOODAC3412LO','WOODAC3412MH','WOODAC3412MO','WOODAC344LO','WOODAC344MH','WOODAC344MO','WOODAC348LO','WOODAC348MH','WOODAC348MO','WOODAC4812LO','WOODAC4812MH','WOODAC4812MO','WOODAC486LO','WOODAC486MH','WOODAC486MO','WOODACDIV','WOODBCC13LO','WOODBCC13MH','WOODBCC13MO','WOODBCC26LO','WOODBCC26MH','WOODBCC26MO','WOODBCC39LO','WOODBCC39MH','WOODBCC39MO','WOODBCC412LO','WOODBCC412MH','WOODBCC412MO','WOODBR16TTLO','WOODBR16TTMH','WOODBR16TTMO','WOODBR244LO','WOODBR244MH','WOODBR244MO','WOODCH10FSLO','WOODCH10FSMH','WOODCH10FSMO','WOODCH1410LO','WOODCH1410MH','WOODCH1410MO','WOODCH141LO','WOODCH141MH','WOODCH141MO','WOODCH142LO','WOODCH142MH','WOODCH142MO','WOODCH143LO','WOODCH143MH','WOODCH143MO','WOODCH145LO','WOODCH145MH','WOODCH145MO','WOODCH151LO','WOODCH151MH','WOODCH151MO','WOODCH1710LO','WOODCH1710MH','WOODCH1710MO','WOODCH171LO','WOODCH171MH','WOODCH171MO','WOODCH173LO','WOODCH173MH','WOODCH173MO','WOODCH174LO','WOODCH174MH','WOODCH174MO','WOODCH175LO','WOODCH175MH','WOODCH175MO','WOODCH177LO','WOODCH177MH','WOODCH177MO','WOODCH17FSLO','WOODCH17FSMH','WOODCH17FSMO','WOODCHD151LO','WOODCHD151MH','WOODCHD151MO','WOODFEC10LO','WOODFEC10MH','WOODFEC10MO','WOODFEC11LO','WOODFEC11MH','WOODFEC11MO','WOODFEC20LO','WOODFEC20MH','WOODFEC20MO','WOODFEC21LO','WOODFEC21MH','WOODFEC21MO','WOODGBS111LO','WOODGBS111MH','WOODGBS111MO','WOODGBS112LO','WOODGBS112MH','WOODGBS112MO','WOODGBS113LO','WOODGBS113MH','WOODGBS113MO','WOODGBS114LO','WOODGBS114MH','WOODGBS114MO','WOODGBW111LO','WOODGBW111MH','WOODGBW111MO','WOODGBW112LO','WOODGBW112MH','WOODGBW112MO','WOODGBW113LO','WOODGBW113MH','WOODGBW113MO','WOODGBW114LO','WOODGBW114MH','WOODGBW114MO','WOODHCR2BLO','WOODHCR2BMH','WOODHCR2BMO','WOODHCR2NLO','WOODHCR2NMH','WOODHCR2NMO','WOODHCR2WLO','WOODHCR2WMH','WOODHCR2WMO','WOODHCR5BLO','WOODHCR5BMH','WOODHCR5BMO','WOODHCR5NLO','WOODHCR5NMH','WOODHCR5NMO','WOODHCR5WLO','WOODHCR5WMH','WOODHCR5WMO','WOODHSD2BLO','WOODHSD2BMH','WOODHSD2BMO','WOODHSD2NLO','WOODHSD2NMH','WOODHSD2NMO','WOODHSD3BLO','WOODHSD3BMH','WOODHSD3BMO','WOODHSD3NLO','WOODHSD3NMH','WOODHSD3NMO','WOODHSD4BLO','WOODHSD4BMH','WOODHSD4BMO','WOODHSD4NLO','WOODHSD4NMH','WOODHSD4NMO','WOODKEYLO','WOODLD2412LO','WOODLD2412MH','WOODLD2412MO','WOODLD248LO','WOODLD248MH','WOODLD248MO','WOODLD4912LO','WOODLD4912MH','WOODLD4912MO','WOODLD4916LO','WOODLD4916MH','WOODLD4916MO','WOODLD4924LO','WOODLD4924MH','WOODLD4924MO','WOODLD498LO','WOODLD498MH','WOODLD498MO','WOODLDFSLO','WOODLDFSMH','WOODLDFSMO','WOODLHT1LO','WOODLHT1MH','WOODLHT1MO','WOODLM12LO','WOODLM12MH','WOODLM12MO','WOODLM16LO','WOODLM16MH','WOODLM16MO','WOODLM24FSLO','WOODLM24FSMH','WOODLM24FSMO','WOODLM4LO','WOODLM4MH','WOODLM4MO','WOODLM6LO','WOODLM6MH','WOODLM6MO','WOODLM8TTLO','WOODLM8TTMH','WOODLM8TTMO','WOODLM9LO','WOODLM9MH','WOODLM9MO','WOODLMFSLO','WOODLMFSMH','WOODLMFSMO','WOODLR2LOBLK','WOODLR2LOBRN','WOODLR2LOTAN','WOODLR2LOTAP','WOODLR2MHBLK','WOODLR2MHBRN','WOODLR2MHTAN','WOODLR2MHTAP','WOODLR2MOBLK','WOODLR2MOBRN','WOODLR2MOTAN','WOODLR2MOTAP','WOODLR3LOBLK','WOODLR3LOBRN','WOODLR3LOTAN','WOODLR3LOTAP','WOODLR3MHBLK','WOODLR3MHBRN','WOODLR3MHTAN','WOODLR3MHTAP','WOODLR3MOBLK','WOODLR3MOBRN','WOODLR3MOTAN','WOODLR3MOTAP','WOODLR4LOBLK','WOODLR4LOBRN','WOODLR4LOTAN','WOODLR4LOTAP','WOODLR4MHBLK','WOODLR4MHBRN','WOODLR4MHTAN','WOODLR4MHTAP','WOODLR4MOBLK','WOODLR4MOBRN','WOODLR4MOTAN','WOODLR4MOTAP','WOODLRLOBLK','WOODLRLOBRN','WOODLRLOTAN','WOODLRLOTAP','WOODLRMHBLK','WOODLRMHBRN','WOODLRMHTAN','WOODLRMHTAP','WOODLRMOBLK','WOODLRMOBRN','WOODLRMOTAN','WOODLRMOTAP','WOODLT1LO','WOODLT1MH','WOODLT1MO','WOODLT4LO','WOODLT4MH','WOODLT4MO','WOODLT8LO','WOODLT8MH','WOODLT8MO','WOODMM12LO','WOODMM12MH','WOODMM12MO','WOODMM3LO','WOODMM3MH','WOODMM3MO','WOODMM4LO','WOODMM4MH','WOODMM4MO','WOODMM6LO','WOODMM6MH','WOODMM6MO','WOODMM9LO','WOODMM9MH','WOODMM9MO','WOODMR10FSLO','WOODMR10FSMH','WOODMR10FSMO','WOODMR14FSLO','WOODMR14FSMH','WOODMR14FSMO','WOODMR16TTLO','WOODMR16TTMH','WOODMR16TTMO','WOODMR20FSLO','WOODMR20FSMH','WOODMR20FSMO','WOODMR244LO','WOODMR244MH','WOODMR244MO','WOODMR248LO','WOODMR248MH','WOODMR248MO','WOODMR3614LO','WOODMR3614MH','WOODMR3614MO','WOODMR367LO','WOODMR367MH','WOODMR367MO','WOODMR40SPLO','WOODMR40SPMH','WOODMR40SPMO','WOODMR4810LO','WOODMR4810MH','WOODMR4810MO','WOODMR4820LO','WOODMR4820MH','WOODMR4820MO','WOODMR7FSLO','WOODMR7FSMH','WOODMR7FSMO','WOODMT1LO','WOODMT1MH','WOODMT1MO','WOODMT2LO','WOODMT2MH','WOODMT2MO','WOODOCHO201LO','WOODOCHO201MH','WOODOCHO201MO','WOODOCHS151LO','WOODOCHS151MH','WOODOCHS151MO','WOODPCH151LO','WOODPCH151MH','WOODPCH151MO','WOODPCH243LO','WOODPCH243MH','WOODPCH243MO','WOODPCH365LO','WOODPCH365MH','WOODPCH365MO','WOODPT1LO','WOODPT1MH','WOODPT1MO','WOODWCG2LO','WOODWCG2MH','WOODWCG2MO','WOODWCT1LO','WOODWCT1MH','WOODWCT1MO','WOODWCX1LO','WOODWCX1MH','WOODWCX1MO','WOODWD1721MH','WOODWD1721OAK','WOODWR31LO','WOODWR31MH','WOODWR31MO','WOODWR31UN','WOODWR32LO','WOODWR32MH','WOODWR32MO','WOODWR32UN','WOODWR33LO','WOODWR33MH','WOODWR33MO','WOODWR33UN','WOODWR34LO','WOODWR34MH','WOODWR34MO','WOODWR34UN','WOODWR35LO','WOODWR35MH','WOODWR35MO','WOODWR35UN','WOODWR36LO','WOODWR36MH','WOODWR36MO','WOODWR36UN','WOODWR37LO','WOODWR37MH','WOODWR37MO','WOODWR37UN','WOODWR41LO','WOODWR41MH','WOODWR41MO','WOODWR41UN','WOODWR42LO','WOODWR42MH','WOODWR42MO','WOODWR42UN','WOODWR43LO','WOODWR43MH','WOODWR43MO','WOODWR43UN','WOODWR44LO','WOODWR44MH','WOODWR44MO','WOODWR44UN','WOODWR45LO','WOODWR45MH','WOODWR45MO','WOODWR45UN','WOODWR46LO','WOODWR46MH','WOODWR46MO','WOODWR46UN','WOODWR47LO','WOODWR47MH','WOODWR47MO','WOODWR47UN','WOODWRD31LO','WOODWRD31MH','WOODWRD31MO','WOODWRD31UN','WOODWRD32LO','WOODWRD32MH','WOODWRD32MO','WOODWRD32UN','WOODWRD33LO','WOODWRD33MH','WOODWRD33MO','WOODWRD33UN','WOODWRD34LO','WOODWRD34MH','WOODWRD34MO','WOODWRD34UN','WOODWRD35LO','WOODWRD35MH','WOODWRD35MO','WOODWRD35UN','WOODWRD36LO','WOODWRD36MH','WOODWRD36MO','WOODWRD36UN','WOODWRD37LO','WOODWRD37MH','WOODWRD37MO','WOODWRD37UN','WOODWRD3LO','WOODWRD3MH','WOODWRD3MO','WOODWRD3UN','WOODWRD41LO','WOODWRD41MH','WOODWRD41MO','WOODWRD41UN','WOODWRD42LO','WOODWRD42MH','WOODWRD42MO','WOODWRD42UN','WOODWRD43LO','WOODWRD43MH','WOODWRD43MO','WOODWRD43UN','WOODWRD44LO','WOODWRD44MH','WOODWRD44MO','WOODWRD44UN','WOODWRD45LO','WOODWRD45MH','WOODWRD45MO','WOODWRD45UN','WOODWRD46LO','WOODWRD46MH','WOODWRD46MO','WOODWRD46UN','WOODWRD47LO','WOODWRD47MH','WOODWRD47MO','WOODWRD47UN','WOODWRD4LO','WOODWRD4MH','WOODWRD4MO','WOODWRD4UN','WOODXR1LO','WOODXR1MH','WOODXR1MO','')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN MATCH(`desc_short`) AGAINST ('woodmagazinerack' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+woodmagazinerack' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"woodmagazinerack"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"woodmagazinerack"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"woodmagazinerack"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"woodmagazinerack"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+woodmagazinerack' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='woodmagazinerack',`category_4` ='woodmagazinerack') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'woodmagazinerack,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('woodmagazinerack', `pinfo`.`desc_title`)) DESC

Currently Filtered by

woodmagazineracks

Woodmagazineracks

Refine Search

  GO
Category

Literature Organizers/Sorters(3)

Wall Sorters/Racks(2)

Shelf(2)

Wall Files, Pockets & Accessories(1)

Brand

Safco(1)

Valuline(1)

Color

Cherry(1)

Oak Frame(1)

Recycled

No(2)

Price Range

$0-$499.99(534)

$500-$999.99(6)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Shop Our Solutions is a Division of American Office Solutions,Inc., All Rights Reserved