ROA77510 - Group SKU's

SELECT `csh`.`header_name`,`csh`.`header_value`,`csh`.`sku`,`sf`.`level` FROM (SELECT `pinfo`.`sku` 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 WHERE `pinfo`.`sku` IN ('ROA77510','ROA77512','ROA77513') GROUP BY `pinfo`.`sku`) AS `sku_table` LEFT JOIN `custom_sku_header` AS `csh` FORCE INDEX(`search_fitler`) ON `csh`.`sku`=`sku_table`.`sku` INNER JOIN `search_filter` AS `sf` ON `sf`.`search_filter`=`csh`.`header_name` WHERE `sf`.`status` =1 AND `sf`.`level` IN (1,2) AND `sku_table`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`)

Currently Filtered by

Refine Search

  GO
 
Category Filter

Paper Pads/note Pads(3)

 
Brand

Roaring Spring(3)

 
Height

8 1/2"(3)

 
Paper Color(s)

White(3)

 
Item Description Unit Price / Qty

Exam Blue Book, Legal Rule, 8 1/2 x 7, White, 4 Sheets/8 Pages

Item #:ROA77510



$0.40/EA

Exam Blue Book, Legal Rule, 8 1/2 x 7, White, 8 Sheets/16 Pages

Item #:ROA77512



$0.48/EA

Exam Blue Book, Legal Rule, 8 1/2 x 7, White, 12 Sheets/24 Pages

Item #:ROA77513



$0.62/EA

Scroll To Top
 
AbilityOne Distributor Wildcard SSL Certificates

© 2018-2019 United Supply Corp, All Rights Reserved