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

Currently Filtered by

Category

Games Manipulatives

Refine Search

  GO
 
Brand

Learning Resources(28)

TREND(14)

Carson-Dellosa Publishing(10)

Educational Insights(8)

Creativity Street(4)

Teacher Created Resources(3)

Scholastic(3)

The Board Dudes LeapFrog(2)

 
Manufacturer Part Number

LER7630(1)

LER7566(1)

LER7306(1)

LER8630(1)

LER9119(1)

SC989357(1)

SC987207(1)

LER9164(1)

LER6801(1)

LER6645(1)

LER3039(1)

LER3038(1)

LER2788(1)

LER3332(1)

LER4356(1)

LER6380(1)

LER5052(1)

SC990927(1)

7813(1)

T6070(1)

T6068(1)

T6064(1)

T6071(1)

T6141(1)

T76304(1)

T6142(1)

T6062(1)

T6061(1)

T36002(1)

7831(1)

7816(1)

T36003(1)

T36004(1)

T58102(1)

T58101(1)

LER2509(1)

LER2296(1)

4384(1)

D44046(1)

D44045(1)

4466(1)

95172(1)

2349(1)

95173(1)

D44044(1)

846035(1)

140076(1)

140044(1)

CYD60(1)

140077(1)

158170(1)

846000(1)

158172(1)

2350(1)

2351(1)

LER1207(1)

LER0922(1)

LER0921(1)

LER2075(1)

LER2094(1)

LER2202(1)

LER2102(1)

LER0360(1)

LER0264(1)

2354(1)

2353(1)

2352(1)

2355(1)

2356(1)

LER0176(1)

LER0134(1)

19414AA24(1)

 
Country of Origin

CN(54)

US(14)

KR(2)

VN(1)

TW(1)

 
For Use With

Carson Dellosa Publishing Pocket Chart CDP158174(2)

Scholastic Little Red Tool Box; Magnetic Daily Word-Building Center(1)

Scholastic Little Red Tool Box; Scholastic Alphabet Letters & Pictures Super Set(1)

Scholastic Little Red Tool Box; High-Frequency Word Tiles; Sight-Word Super Set(1)

LER8430(1)

Classroom Kit (LRNLER2102)(1)

Hot Dots and Hot Dots Jr. Card Sets(1)

Additional 4" Geared Clocks (LRNLER2202)(1)

Practicing counting and sorting(1)

Adjustable Pocket Chart Stand LER 2196 (not included)(1)

 
Age Recommendation

Ages 3 and Up(18)

Ages 4 and Up(11)

Ages 5 and Up(4)

Grades K-12(3)

Ages 9 and Up(3)

Grades Pre-K and Up(3)

Grades Pre-K-4(2)

Ages 4 to 7(2)

Grades K and Up(2)

Grades 1-6(2)

Ages 6 and Up(2)

Grades K-1(1)

Ages 4 to 8(1)

Grades 3-12(1)

Ages 5 to 8(1)

Grades 3-4(1)

Ages 3 to 6(1)

Grades 4-5(1)

Grades K-6(1)

Grades 2-3(1)

Ages 2 to 5(1)

Grade 2(1)

Grades 2 and Up(1)

Ages 6 to 13(1)

Grades 2-6(1)

Grades Pre-K(1)

Grades K-4(1)

Ages 8 and Up(1)

Kindergarten(1)

Grade 1(1)

Grade 4(1)

 
Choking Hazard

Warning 1(8)

 
Games/Manipulatives Type

Games(10)

Letters and Numbers(8)

Puzzle(6)

Math Manipulatives(4)

Language Arts(4)

Speech/Language Photo Cards(3)

Learning Clock(3)

Shape Manipulatives(2)

Science Manipulative(2)

Reading Game(2)

Construction Set(2)

Measuring Tools(2)

Math Game(2)

Pocket Chart Cards(2)

Math Learning Games(2)

Learning Mat(1)

Lacing Cards(1)

Science Manipulatives(1)

Magnetic Tabletop Easel(1)

Money Recognition and Counting(1)

Math Card Game(1)

Numbers Game(1)

Alphabet Game(1)

Dominoes(1)

Sequencing Game(1)

Blocks(1)

File Folder Science Games(1)

Chart Pocket Rings(1)

Alphabet Activity(1)

Pattern Cards(1)

Addition & Subtraction Game(1)

Geometric Relations(1)

Math Manipulative(1)

 
Number of Cards

148(3)

Set includes 36 playing cards, 264 chips, caller's mat and cards, and a sturdy storage box.(3)

84(2)

100(2)

109 cards and dividers(1)

135 cards and dividers(1)

182(1)

4(1)