facebook
 
 
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 (`category_id` IN ('113617')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 '%Posters' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Posters' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Posters' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Posters"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Posters"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Posters"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Posters"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Posters' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Posters',`category_4` ='Posters') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Posters,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Posters', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Posters

Refine Search

  GO
 
Brand

Impact Products(8)

Trend(7)

Teacher Created Resources(4)

Creative Teaching Press(3)

Scholastic(2)

 
Color

Multicolor(15)

Assorted(6)

Black(1)

White(1)

 
Recycled

No(23)

 
Height

19"(8)

0.8"(4)

20"(2)

18"(2)

13"(1)

22"(1)

7"(1)

6"(1)

 
Manufacturer Part Number

5649(1)

32280(1)

TA67938(1)

T-A67920(1)

T-A67909(1)

T-A67908(1)

A67924(1)

10980(1)

6661(1)

6658(1)

6656(1)

1338227149(1)

7284(1)

0439152917(1)

799078CT(1)

799078(1)

799077CT(1)

799077(1)

799073CT(1)

799073(1)

799072CT(1)

799072(1)

7424(1)

TA67940(1)

 
Country of Origin

United States(22)

China(2)

 
Width

13.4"(12)

24"(6)

32"(2)

17"(1)

9.2"(1)

 
Material

Plastic(8)

 
Weight (Approximate)

1.10 lb(2)

1 lb(2)

 
Shape

36 x Passport(1)

 
Length

6"(4)

19"(3)

11.5"(1)

 
Placement

Wall Mountable(1)

 
Grade

3-6(1)

 
Skill Learning

Classroom(6)

Character Building(4)

Decoration(4)

Chemical(2)

Symbol(2)

Motivation(2)

Visual Attention(2)

Educational(1)

Writing(1)

School(1)

Creativity(1)

 
Recommended Age

All Ages(3)

 
Language

English(10)

Spanish(4)

 
Theme/Subject

Motivation(7)

Guidance(6)

Learning(6)

Fun(5)

Inspiration(3)

Safety(2)

Encouragement(2)

Attitude & Smiles(1)

 
Print/Message

Honesty(1)

Go instead where there is no path and leave a trail(1)

The journey is the prize(1)

Kind words are the music of the world(1)

Wherever you go, you always leave a footprint(1)

Be Accepting Be Caring Be Compassionate Be Honest Be Respectful Be Understanding Be You!(1)

Surround yourself with who you want to be(1)

Trash The Hate(1)

Attitude + Ability = Success(1)

Attention! Only Positive Attitudes Allowed In This Area(1)

People May Forget What You Say or do, But They Won't Forget How You Make Them Feel(1)

Be A Winner Not A Whiner(1)

Cool for School(1)

Rocking in My School Shoes(1)

Reading Rocks!(1)

Reading is Groovy!(1)

Be failing to prepare, you are preparing to fail(1)

Responsibility(1)

You never Fail until you stop Trying(1)

Spoken word can't be erased - Don't blurt what might hurt(1)

Right is Right even if no one is doing it(1)

A kind word is never wasted...(1)

Set a Goal, Make a plan, Get to Work, Stick to It and Reach Goal(1)

Teachers Who Love Teaching Teach Children To Love Learning(1)

Without Hard Work Nothing Grows But Weeds(1)

Dream it, Believe it, Achieve it(1)

Think Outside the Box(1)

Never Stop Learning(1)

Self-Discipline(1)

Respect(1)

Perseverance(1)

Good Judgement(1)

No one can make you feel inferior without your consent(1)

 
Printed Design/Pattern/Texture

Superhero Character(1)

Chalkboard(1)

Pete the Cat(1)

 
Product Type

Poster(23)

Sticker(1)

 
Packaged Quantity

6 / Pack(7)

1 Each(5)

10 / Carton(4)

30 / Pack(2)

4 / Pack(2)

4 / Set(1)

5 / Pack(1)

36 / Pack(1)

1 / Pack(1)

 
Assembly Required

No(24)

 
Product Model

TA-67920(1)

 
Product Line

ARGUS(5)

Chalk It Up!(1)

Classic Accents(1)