0

 

Total:$0.00

QUICK VIEW 0
 

 
 
 
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_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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` 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 WHERE ((`desc_short` like 'tax forms' OR `desc_long` like 'tax forms' OR `desc_title` like 'tax forms' OR `keywords` like 'tax forms' OR `category_1` like 'tax forms' OR `category_2` like 'tax forms' OR `category_3` like 'tax forms' OR `category_4` like 'tax forms' OR `manufacturer_name` like 'tax forms' OR `color` like 'tax forms') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>tax>taxes)+(>forms>forms)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"tax forms"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%tax forms%' OR `pinfo`.`sku` like '%taxforms%' OR (FIND_IN_SET('tax forms', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('tax forms', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('tax forms', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('tax forms', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('tax forms', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'tax forms' ELSE `pinfo`.`desc_title` like 'tax forms' END))) 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 `pinfo`.`sku` LIKE '%tax forms' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('tax +forms' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+tax +forms' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"tax forms"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"tax forms"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"tax forms"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"tax forms"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+tax +forms' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='forms',`category_4` ='forms') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'forms,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('forms', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Tax Forms

Refine Search

  GO
 
Category

Big & Tall Chairs(34)

Desktop Risers(33)

Tax Forms(16)

Forms(5)

Displays(1)

 
Brand

TOPS(22)

Lorell(20)

Safco(18)

Kantek(8)

Victor(7)

HON(6)

Basyx by HON(3)

Fellowes(2)

Office Star(2)

Mayline(1)

 
Color

Black(44)

White(9)

Silver(6)

Natural(2)

Aluminum(2)

Navy(1)

 
Size

Legal(3)

 
Recycled

No(48)

 
Sheet Size

5 1/2" Width x 8 1/2" Length(4)

5 1/2" Width x 8" Length(3)

11" Width x 8 1/2" Length(3)

9 x 11(3)

3 21/32" Width x 8" Length(1)

9 1/2 x 11(1)

9" Width x 11" Length(1)

8 1/2 x 11(1)

8 1/2" Width x 11" Length(1)

 
 
 

© 2018-2019 Regal Office Supplies, All Rights Reserved