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 ( REPLACE(`pinfo`.`sku`,`pinfo`.`manufacturer_prefix`,'') LIKE 'RECORD BOOKS%' OR MATCH (`keywords`) AGAINST ('RECORD BOOKS' IN BOOLEAN MODE) ) 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 ('RECORD +BOOKS' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+RECORD +BOOKS' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"RECORD BOOKS"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"RECORD BOOKS"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"RECORD BOOKS"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"RECORD BOOKS"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+RECORD +BOOKS' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='BOOKS',`category_4` ='BOOKS') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'BOOKS,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('BOOKS', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

RECORD BOOKS

Refine Search

  GO
Category

Memo / Subject Notebooks(426)

Learning Books(379)

Appointment Books & Planners(324)

Accounting/Columnar/Record Books & Pads(72)

Creative Learning(41)

Receipt Books(40)

Medical Record Cards(35)

Telephone Message Books & Pads(34)

Reference Books(33)

Journals(26)

Letter, Legal & Jr. Pads(23)

Storage Boxes & Containers(22)

Lab Notebooks(16)

Teaching Flash Cards(15)

Storage Drawers & Accessories(14)

Sales Forms & Refills(11)

Minute & Log Books(9)

Visitor Registration Books(8)

Desktop Organizers(8)

Tickets(7)

Craft Supplies(7)

Automobile Log Books(7)

Standard Ring Binders(7)

Play/Rest Mats(6)

Quadrille Pads(6)

Educational Record Books(6)

Organizer Refills(5)

Contemporary - Laminate(5)

Library Pockets(5)

Book Tapes(5)

Craft Kits(4)

Rugs(4)

Purchase Order Forms(4)

Forms(4)

Teaching Calendars & Planners(4)

Medical Desk Trays(3)

Presentation / View Binders(3)

Telephone / Address Books(3)

Handwriting Paper(3)

Plastic Toys(3)

Wall Planners & Organizers(2)

Backpacks(2)

CD Media(2)

Business Diaries(2)

Time Management Organizers(2)

Magazine Files(2)

Receiving Forms(2)

Steno Pads(2)

Memory Cards/Sticks(2)

Time Cards & Time Clock Accessories(2)

Manila Jackets(2)

Desk Calendars(2)

Loose Leaf Address Book Refills(1)

Job Forms(1)

Calendars & Planners(1)

Packing Slip Forms(1)

Paper Pads/Note Pads(1)

Color Jackets(1)

Personnel Forms(1)

Teaching Aids(1)

Scratch Pads(1)

Correspondence Forms(1)

Puzzles(1)

Top Tab Colored Folders(1)

Payroll Forms(1)

Media Storage Cases/Drawers/Wallets(1)

Desktop File Sorters(1)

Storage Binders(1)

Insulated File Cabinets(1)

Document/Box Files(1)

Posters(1)

Calendar Desk Pads(1)

Bookends(1)

Cassette Recorders(1)

Learning Boards(1)

Medical Scales(1)

Stethoscopes(1)

Book Rings(1)

Report Covers(1)

Charts(1)

Sketch Pads & Drawing Paper(1)

Attendance Systems(1)

Binder Pockets(1)

Dry-Erase Boards(1)

Brand

Shell(206)

At-A-Glance(197)

TOPS(100)

Rediform(93)

Mead(90)

Teacher Created Resources(59)

Roaring Spring(58)

Blue Sky(49)

Carson-Dellosa(42)

Scholastic(42)

Bankers Box(35)

Boorum & Pease(32)

House of Doolittle(30)

Adams(30)

Five Star(29)

Sparco(28)

Business Source(24)

Wilson Jones(23)

Learning Resources(18)

Pacon(17)

Blueline(16)

Brownline(16)

Cambridge(15)

Ampad(15)

Dome(15)

SKILCRAFT(14)

Trend(13)

Black n' Red(13)

Merriam-Webster(12)

Hygloss(9)

Creative Teaching Press(8)

Ashley(8)

Summer Bridge(6)

Ekonomik(6)

New Sprouts(6)

Blue sky(6)

Roylco(5)

Astrobrights(5)

Lorell(5)

Day-Timer(5)

Crayola(5)

Flagship Carpets(4)

Pendaflex(4)

Oxford(4)

The Board Dudes(4)

Scotch(4)

Ward(4)

Maxell(2)

Gears!Gears!Gears!(2)

Cardinal(2)

Tabbies(2)

Oxford University Press(2)

Post-it®(2)

Verbatim(2)

Nature Saver(2)

Houghton Mifflin(2)

Unicor(1)

Smead(1)

Filofax(1)

Three Bear Family(1)

Fellowes(1)

FireKing(1)

Educational Insights(1)

C-Line(1)

Artistic(1)

AmpliVox(1)

Flipside(1)

Chartpak(1)

GoWrite!®(1)

Quality Park(1)

Acco(1)

Smart Snacks(1)

Health o Meter(1)

Jonti-Craft(1)

National(1)

Color

Black(89)

Assorted(52)

Multi(36)

White(36)

Blue(35)

Multicolor(35)

Red(9)

Green(9)

Gray(8)

Clear(7)

Pink(4)

Wood Grain(4)

Brown(4)

Kraft(3)

Navy(3)

Navy Blue(3)

Silver(2)

Manila(2)

Heather(2)

Charcoal Gray(2)

Teal(2)

Olive Green(2)

Camouflage(1)

Cobalt(1)

Purple(1)

Black Cover(1)

Moss(1)

Clear Bucket(1)

Cream(1)

Parchment(1)

Copper(1)

Burgundy(1)

Floral(1)

Dark Brown(1)

Aluminum(1)

Wine(1)

Charcoal(1)

Size

4.25" Height x 3" Diameter - Can(2)

6" Height x 16.50" Width x 6.50" Diameter(1)

Binder Capacity

1"(8)

8 1/4"(1)

Size

Letter(100)

A5(7)

A4(3)

Legal(2)

Jr.Legal(2)

A6(1)

Quarto(1)

Tabloid(1)

Recycled

No(674)

Yes(410)

Price Range

$0-$499.99(1688)

$500-$999.99(4)

$2000-$2499.99(1)

To  GO

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

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