UPDATE assets SET title='Sound searchers', description='Children with learning needs may lack confidence and require motivating. Here is an activity that makes learning&&&&&early phonics fun! ', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96319_spnycognitive_sip-55.gif'); UPDATE assets SET title='Odds and evens', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046__ce_1205_A2iipb_3.gif'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106433_all pages_mip.pdf'); UPDATE assets SET title='Silly sentences', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046__ce_1205_A2ipb_4.gif'); UPDATE assets SET title='Author profile: Roger McGough', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106448_roger-mcgough_mip.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb4.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb4.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb4.gif'), 'LIT'); UPDATE assets SET title='Royalty', description='This simple non-chronological report from _Literacy Time Ages 5-7_ is all about royalty and includes a diagram of the British Royal Family.', long_description='This simple non-chronological report from _Literacy Time Ages 5-7_ is all about royalty and includes a diagram of the British Royal Family naming Elizabeth II and all of her children and grandchildren. The direct heirs to the throne are shown via arrows and Prince Harry\'s formal name is used (Henry). There is also a simple table using symbols showing three queens, their husbands and children, featuring Elizabeth I, Elizabeth II and Victoria. ', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94835_Royalty_pos.gif'); UPDATE assets SET title='Menu du Jour', description='Sort out this topsy-turvy menu.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_a1post_pb.gif'); UPDATE assets SET title='Peepo!', description='With the Interactive Peepo! poster you can learn how to use the spotlight tool on your interactive whiteboards. Includes instructions for SMART Boards and Promethean ACTIVboards.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103268_ce0406a2iipeepo_pf.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb4.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb4.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb4.gif'), 'HIS'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb4.gif'), 'LIT'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_LT34-scot1106-attain-targets_sip.gif'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106445_LT34-scot0107-attain-targets.gif'); UPDATE assets SET title='Animal cards', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_42-43extra_mip-1.gif'); UPDATE assets SET title='Author profile: Gervase Phinn', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102141_gervaise-phinn_mip.gif'); UPDATE assets SET title='What can they do?', description='Use the illustrations to generate as many related verbs as your children can think of.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb6.gif'), 9) UPDATE assets SET title='Su Doku worksheet 1', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99719_opcp34_sip-1.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb5.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb5.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb5.gif'), 'LIT'); UPDATE assets SET title='The Sound Band', description='A rhyming performance song to the tune of \'Here We Go Round the Mulberry Bush\' from _Literacy Time Ages 5-7_.', long_description='A rhyming performance song to the tune of \'Here We Go Round the Mulberry Bush\' from _Literacy Time Ages 5-7_. Great for teaching poetry with repetition, ryhme and rythmn. Ideal for links with music and for performance with instruments.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106433_SoundBand_pos.gif'); UPDATE assets SET title='English Curriculum ', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_cleng1.gif'); UPDATE assets SET title='The Wheels on the Bus', description='Enjoy learning about going on a bus ride with this fun interactive song', long_description='Enjoy learning about going on a bus ride with this fun interactive song based on The Wheels on the Bus.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=0, age_end=5 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105175_wheels-on-the-bus_int.exe'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b2_sip1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b2_sip1.gif'), 'MTH'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb7.gif'), 'MTH'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb7.gif'), 'SCI'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb2.gif'), 'DT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb2.gif'), 'ICT'); UPDATE assets SET title='Author profile: Philip Reeve', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101027_philip-reeve_sip.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb5.gif'), 'MTH'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb5.gif'), 'SCI'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106433_LT12_nls0107_sip.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'), 'PE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'), 'XCR'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34a.gif'), 4) UPDATE assets SET title='An interview with Brian Patten', description='_Literacy Time Ages 9-11\'s_ exclusive interview with bestselling children\'s writer Brian Patten.', long_description='_Literacy Time Ages 9-11\'s_ exclusive interview with bestselling children\'s author and poet Brian Patten. Features illustrations from his books.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83481_Patten_pos.gif'); UPDATE assets SET title='Connecting words and phrases', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046__ce_1205_A2ipb_2.gif'); UPDATE assets SET title='Silly sentences', description='Get your children using connectives with with these fun cards.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-4.gif'), 9) UPDATE assets SET title='Which tense?', description='Cut-out cards from which children create sentences.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb8.gif'); UPDATE assets SET title='Cartoon', description='A cartoon strip showing a footballer taking a goal ', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_pb8.gif'); UPDATE assets SET title='Welsh Curriculum', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_clwales1.gif'); UPDATE assets SET title='Email from Sarah', description='Emails with instructions, directions, maps and pictures from _Literacy Time Ages 5-7_.', long_description='Emails with instructions, directions, maps and pictures from _Literacy Time Ages 5-7_. Sarah emails her friend Mark with an invitation to her house. She includes a map with directions as an attachment. Mark replies after the visit to say thank you. Children could practise writing and sending their own emails and letters.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102134_Sarahemail_pos.gif'); UPDATE assets SET title='Around the world poster', description='Around the World in eighty squares is a poster which can be viewed on your interactive whiteboard.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105144_AprA1posterfront_wbp.gif'); UPDATE assets SET title='Tell me why!', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_ce05_mip40.gif'); UPDATE assets SET title='Dancing with dolls', description='Create a new dance based around toys coming to life.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'), 'ART'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'), 'XCR'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'), 21) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'), 3) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb1.gif'), 9) DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-29.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-29.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-29.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-29.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-29.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-29.gif'), 'HUM'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-29.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-29.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb2.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb2.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb2.gif'), 'HIS'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb2.gif'), 'LIT'); UPDATE assets SET title='Scottish Guidelines', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_clscot_mip.gif'); UPDATE assets SET title='The Go-Cart Challenge', description='_Junior Education_ bring you the Go-Cart Challenge game for your PC or whiteboard.', long_description='Experience the sounds and sights of a fairground in this Go-Cart Challenge game.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105151_go-cart-ch_int.exe'); UPDATE assets SET title='Snowball sentences poster', description='A missing words game from _Literacy Time Ages 5-7_.', long_description='A missing words game from _Literacy Time Ages 5-7_ on a winter theme. Can the children think of suitable words hidden by the snowballs to make complete sentences? This can be used with the matching photocopiable page.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102135_Snowball_pos.gif'); UPDATE assets SET title='At the Hospital', description='Use this interactive poster which is part of our role play series, for your whiteboard or PC. Take a look and look out for more i-posters in our coming issues.', long_description='The three pictures on the title page each represent a story about a different scenario at the hospital. Jacob\'s story is about an appointment with the doctor at the Out patients ward. Tyler\'s story focuses on what happens at Accident & Emergency, and staying overnight in the Children\'s Ward. The paramedic takes you on a trip in his ambulance. If you are planning to use the interactive poster on a PC, use the mouse to click on the images and icons. If you are planning to use the poster on your interactive whiteboard, simply touch the interactive whiteboard or use an interactive whiteboard pen to touch the images and icons. This will enable you to follow each of the three stories. &&&&&&&&&&On entering each story, you will notice some arrows in the bottom right-hand corner of the screen. Use your mouse or touch/use an interactive whiteboard pen to navigate your way through each of the stories. You will automatically return to the main title page when the story is finished. &&&&&&&&&&Each picture within the three stories contains an interactive element for you and the children to enjoy. This includes text and sounds. To listen to the sounds, use your mouse to click on the appropriate sound icon, or touch/use an interactive whiteboard pen to touch the sound icon on the interactive whiteboard.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101481_atthehospital_int.gif'); UPDATE assets SET title='Using adjectives', description='A fun illustration to develop work on adjectives. ', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb6.gif'), 9) UPDATE assets SET title='Author profile: Brian Moses', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101026_brian-moses_mip.gif'); UPDATE assets SET title='Roman Dictionary', description='A dictionary without illustrations of words with Roman origins from _Literacy Time Ages 7-9_.', long_description='A dictionary of words with Roman origins from _Literacy Time Ages 7-9_. This alphabetic text features word origins, roots and plurals, and shows how language changes over time.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_Rodict_pos.gif'); UPDATE assets SET title='The Sustainable School Game', description='_Junior Education_ brings you an interactive maths game for your whiteboard.', long_description='An interactive maths game for your whiteboard. Don\'t forget to download the accompanying Sustainable School Game worksheets.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105150_sustain-sch-game_int.exe'); UPDATE assets SET title='My Wild Thing and Max', description='Get your children to draw and describe their own Wild Thing and Max.', long_description='Bring literacy to life with a writing activity inspired by a well-known story. See pages 46-47 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47b.gif'), 9) UPDATE assets SET title='The Obstacle Race Game', description='_Junior Education_ bring you the Obstacle Race Game.', long_description='Experience the sounds and sights of a fairground in this Go-Cart Challenge game brought to you by _Junior Education_.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105152_obs-race-game_int.exe'); UPDATE assets SET title='At School', description='Explore the sights and sounds of a real school with this versatile interactive poster from _Child Education_.', long_description='Can you remember your first day at school? If you can, you might remember that feeling of not knowing what to expect! This interactive poster provides you with a fun and interactive way to engage children in what goes on at school. It\'s perfect for the start of the school year when Reception children need settling in. But it\'s also fun for children that are already familiar with the structure of their school day but are ready to move on to learning to tell the time or developing their vocabulary to articulate what they get up to when they\'re at school.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105882_atschool_int.gif'); UPDATE assets SET title='Liverpool website', description='This tourist website from _Literacy Time Ages 7-9_ features linked pages, persuasive language, maps, photos and captions.', long_description='This tourist website from _Literacy Time Ages 7-9_ marks Liverpool\'s 800th birthday in 2007 and its title as European Capital of Culture in 2008. The site features linked pages, persuasive language, maps, photos and captions, and is a great way to link literacy to history and geography.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106448_liverpool_int.gif'); UPDATE assets SET title='Author profile: Kevin McCann', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106447_kevin-mccann_mip.gif'); UPDATE assets SET title='How will it end?', description='A fun and motivating connectives game from _Literacy Time Ages 5-7_. Roll the on-screen dice to select a connective, then make complete sentences using the picture clues.', long_description='A fun and motivating connectives game from _Literacy Time Ages 5-7_. Roll the on-screen dice to select a connective, then make complete sentences using the picture clues. There are 3 levels featuring the connectives:- but so or when because.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106436_how-will-it-end_int.exe'); UPDATE assets SET title='The Fire of London', description='_Literacy Time Ages 9-11_ presents a 17th century poem about The Great Fire of London.', long_description='_Literacy Time Ages 9-11_ presents a 17th century poem about The Great Fire of London in 1666, by contemporary poet John Dryden.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94840_Fire_pos.gif'); UPDATE assets SET title='My favourite toy from the past', description='Children interview a family member to find out about toys from the past.', long_description='See pages 29-32 of the November 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 'ART'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 'HIS'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 20) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 21) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_sip-30.gif'), 9) UPDATE assets SET title='Wildlife poster', description='A colour poster showing the wildlife that exists in urban areas.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105995_je1106online_sip-24.gif'); UPDATE assets SET title='Newspaper report', description='Invite your children to write their own newspaper report about the day when Max was crowned king.', long_description='Bring literacy to life with a writing idea inspired by a well-known story. See pages 46-47 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'), 'PE'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47c.gif'), 9) DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb1.gif'), 'DT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb1.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb1.gif'), 'PSE'); UPDATE assets SET title='Virtual Dig', description='Inspire your pupils with your very own classroom archaeological dig of a Roman villa. See The Virtual Dig on pages 43-45 of the February issue of _Junior Education_ and get supporting material from our online downloadable photocopiable worksheets here.', long_description='Inspire your pupils with your very own classroom archaeological dig of a Roman villa!* Spend some time familiarising yourself with its features. * Photocopy and laminate enough Artefact and Expert Opinion sheets (see Free downloads) for each group. * Take a look at pages 43-45 in your February Junior Education.&&&&&&&&&&Each artefact in the virtual dig has a link to the photographs on the A2 poster.', subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99721_vDigV1_int.exe'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b2_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b2_sip.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b2_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b2_sip.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b2_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b2_sip.gif'), 'LIT'); UPDATE assets SET title='World War II Encyclopaedia', description='A fascinating and child-friendly text about World War II in the style of an encyclopaedia from _Literacy Time Ages 7-9_.', long_description='A fascinating and child-friendly text about World War II in the style of an encyclopaedia from _Literacy Time Ages 7-9_. This accessible text gives information on the world leaders Churchill and Hitler, The Battle of the Britain, Evacuees and The Holocaust. Featuring photographic images, this text links literacy to history and PSHE and introudces The Holocaust in a very sensitive way.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94845_WWIIenc_pos.gif'); UPDATE assets SET title='Calculation cards', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105151_je0307Gamespcp_mip-1.gif'); UPDATE assets SET title='Tell me why!', description='Thought-provoking questions and answers', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_ce05-1_mip40.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b4_sip3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b4_sip3.gif'), 'MTH'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb8.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb8.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb8.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb8.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-28a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-28a.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-28a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-28a.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-28a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-28a.gif'), 'HUM'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-28a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-28a.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb3.gif'), 'DT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb3.gif'), 'ICT'); UPDATE assets SET title='Classic poetry', description='_Literacy Time Ages 9-11_ presents two classic poems from Victorian writers Christina Rossetti and Emily Bronte.', long_description='_Literacy Time Ages 9-11_ presents two classic poems from well-known Victorian writers - \'Song\' by Christina Rossetti and \'Past, Present, Future\' by Emily Bronte.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83481_classicpoetry_pos.gif'); UPDATE assets SET title='Scottish Guidelines', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clscot1.gif'); UPDATE assets SET title='Playground fun', description='Non-chronlogical report on playground games with instructions for simple games from _Literacy Time Ages 5-7_.', long_description='Non-chronlogical report on playground games with instructions for simple games from _Literacy Time Ages 5-7_. This fun report about playground games has instructions on popular and traditional games, and ideas about how to play nicely and safely. Features signs, lists and numbered points.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83470_Playground_pos.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'), 'ART'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'), 'PE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-24a.gif'), 'XCR'); UPDATE assets SET title='Waste record', description='How many bags of rubbish does your school produce in one day? Conduct a school audit using this record.', long_description='See page 22 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22a.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22a.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22a.gif'), 'SCI'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22a.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22a.gif'), 15) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22a.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22a.gif'), 16) UPDATE assets SET title='Wheels all around', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046__ce_1205_A2iipb_2.gif'); UPDATE assets SET title='Author profile: Anne Diamond', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106443_anne-diamond_mip.gif'); UPDATE assets SET title='Author profile: Moira Andrew', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94841_moira-andrew_mip.gif'); UPDATE assets SET title='Family Fun Day poster', description='A recount of a school sports day with photographs and captions from _Literacy Time Ages 5-7_.', long_description='A recount of a school sports day with photographs and captions from _Literacy Time Ages 5-7_. This fun recount from a child\'s point of view is a great way of linking literacy to PE.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101024_FunDay_pos.gif'); UPDATE assets SET title='Past or present? poster game', description='A word endings game from _Literacy Time Ages 5-7_ for practising the endings \'ed\' and \'ing\' in the past and present tense.', long_description='A word endings game from _Literacy Time Ages 5-7_ for practising the endings \'ed\' and \'ing\' in the past and present tense. This game can also be used to practise the spellings of vowel phonemes. Use it with the teaching notes, instructions on how to play, and the blank photocopiable page for making your own versions, using different words.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83470_PastPresent_pos.gif'); UPDATE assets SET title='Toy games (2)', description='Go toy crazy with activities that develop storytelling and art skills.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'), 'ART'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'), 'XCR'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'), 21) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb3.gif'), 9) DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_sip-41a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_sip-41a.gif'), 'GEO'); UPDATE assets SET title='Jungle Story Kit', description='A complete interactive story kit from _Literacy Time Ages 5-7_. Choose from jungle scenes, characters and sound effects to create a storyboard.', long_description='A complete interactive story kit from _Literacy Time Ages 5-7_. Choose from jungle scenes, animal characters, sound effects, speech bubbles and sentences to create a storyboard. Features connectives, sample phrases and full on-screen instructions.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106436_jungle-story-kit_int.exe'); UPDATE assets SET title='The More We Get Together', description='Child Education bring you a catchy tune perfect for circle time.', long_description='Build friendships and teamwork with this catchy tune - ideal for circle time.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105882_morewegettog_int.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb1.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb1.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb1.gif'), 'LIT'); UPDATE assets SET title='Rome in a Day', description='Take your class on a tour around the sights and sounds of Ancient Rome! _Literacy Time Ages 7-9_ brings you this great interactive resource allowing you to explore Rome and visit the key tourist sites with your class.', long_description='Take your class on a tour around the sights and sounds of Ancient Rome! Literacy Time Ages 7-9 brings you this great interactive resource allowing you to explore Rome and visit the key tourist sites with your class. This stunning interactive map and tour (also available in paper format as an A2 poster, inside the November 2006 issue) features sound effects, animation, photographs of modern-day Rome, historic information, captions and clickable boxes. Can be used with the \'Rome in a Day Tour route\' downloadable and photocopiable page.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_rome-in-a-day_int.exe'); UPDATE assets SET title='Oliver Twist ', description='_Literacy Time Ages 9-11_ presents a fabulous multimedia resource on one of Dickens\' most famous novels. Featuring a film clip, audio reading of a chapter, a simple biography of Charles Dickens and much more!', long_description='_Literacy Time Ages 9-11_ presents a fabulous multimedia resource on one of Dickens\' most famous novels. Featuring a clip from David Lean\'s 1948 film of _Oliver Twist_, an audio reading of a chapter, a simple biography of Charles Dickens, a summary of the novel, film stills and images, plus useful website links.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106444_oliver-twist_int.exe'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb7.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb7.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb7.gif'), 'LIT'); UPDATE assets SET title='Past or present? Notes', description='Teaching notes, game instructions and a blank version of the game for the Past or Present? word game poster from _Literacy Time Ages 5-7_.', long_description='Teaching notes, game instructions and a blank version of the game for the Past or Present? word game poster from _Literacy Time Ages 5-7_.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83470_PasPrenotpcp_pos.gif'); UPDATE assets SET title='I wandered lonely as a cloud', description='_Literacy Time Ages 9-11_ presents William Wordsworth\'s classic poem about daffodils.', long_description='_Literacy Time Ages 9-11_ presents William Wordsworth\'s classic poem about daffodils.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94841_daff_pos.gif'); UPDATE assets SET title='Using verbs', description='Improve children\'s writing using carefully chosen verbs in the correct tense.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb5.gif'), 9) UPDATE assets SET title='Wildlife poster', description='Poster showing the wildlife you may find around a river.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105997_Habitats_sip-1.gif'); UPDATE assets SET title='Tudor Troupe board game', description='Take your class on a race around Tudor England to see who will be first to put on a play at the Globe Theatre in London! See pages 31-34 of the June 2006 issue of _Junior Education_.', long_description='You can use your free interactive version of the Tudor Troupe board game here. Project this bold interactive version onto your whiteboard and play the game as a whole class activity. Use one of the four coloured circles as your counter to move around the board. The circles have a drag and drop function. You can also click on dice that randomly generates a number between 1 and 6.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103654_tudorGame_int.gif'); UPDATE assets SET title='Virtual Dig', description='Inspire your pupils with your very own classroom archaeological dig of a Roman villa. See The Virtual Dig on pages 43-45 of the February issue of _Junior Education_ and get supporting material from our online downloadable photocopiable worksheets here.', long_description='Inspire your pupils with your very own classroom archaeological dig of a Roman villa!&&&&&&&&&&* Spend some time familiarising yourself with its features.&&&&&* Photocopy and laminate enough Artefact and Expert Opinion sheets (see Free downloads) for each group.&&&&&* Take a look at pages 43-45 in your February Junior Education.&&&&&&&&&&Each artefact in the virtual dig has a link to the photographs on the A2 poster.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99721_vDig_int.gif'); UPDATE assets SET title='Design a composting poster', description='Challenge your children to create their own composting posters.', long_description='See the Environment special on pages 17-23 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'), 'ART'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'), 'SCI'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'), 15) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'), 16) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb4.gif'), 21) UPDATE assets SET title='A soldier\'s letters', description='_Literacy Time Ages 7-9_ presents real-life letters and postcards from a soldier on campaign in North Africa during World War II.', long_description='_Literacy Time Ages 7-9_ presents real-life letters and postcards from a soldier on campaign in North Africa during World War II. These letters were sent by Private Harry Moses (father of the poet Brian Moses) to his family and friends at home in Kent. Short, accessible and real letters - perfect for links with history.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94845_HarryMoses_pos.gif'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_menu-du-jour_mip.gif'); UPDATE assets SET title='Learning objectives', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT12-eng1106-attain-targets_sip.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb1.gif'), 'DT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb1.gif'), 'ICT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb7.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb7.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb7.gif'), 'LIT'); UPDATE assets SET title='Connecting words and phrases', description='Children investigate the role of connectives through comparing sentences.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-2.gif'), 9) UPDATE assets SET title='N. Ireland attainment targets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT12-ni1106-attain-targets_sip.gif'); UPDATE assets SET title='What did you have?', description='Introduce initial letter sounds with a simple playground chant.', long_description='See page 30 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-31.gif'), 9) UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106441_LT56-scot0107-attain-targets.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b4_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b4_sip.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b4_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b4_sip.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b4_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b4_sip.gif'), 'LIT'); UPDATE assets SET title='Character cards', description='Children act out the moods of characters from these colourful cards.', long_description='Bring literacy to life with a creative drama idea inspired by a well-known story. See pages 46-47 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'), 'MUS'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'), 'PE'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'), 2) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-47a.gif'), 9) UPDATE assets SET title='Wonderful wizard', description='An illustration for children to add to and label using adjectives.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb8.gif'), 9) UPDATE assets SET title='Scottish Guidelines', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_clscot1.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b3_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b3_sip.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b3_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b3_sip.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b3_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b3_sip.gif'), 'LIT'); UPDATE assets SET title='Activity chart', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=0, age_end=5 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28chart_mip.gif'); UPDATE assets SET title='At the Post Office', description='Use this interactive poster which is part of our role play series, for your whiteboard or PC. Take a look and look out for more i-posters in _Child Education_.', long_description='This interactive poster takes children on a journey - it shows them what happens when you write a letter and post it...covering everything from going to the post office to buy a stamp, to posting it and seeing where it goes next. Finally, the children can see the letter being posted through a letterbox and the delight on the recipient\'s face at receiving their letter. If you are planning to use the interactive poster on a PC, the children will need to use the mouse to click on the images, sounds and question buttons. If you are planning to use the poster on an interactive whiteboard, simply touch the interactive whiteboard [if you\'re using a SMART board] or use your interactive whiteboard pen to touch the images and buttons. Simply click the arrows to take you through the poster.&&&&&&&&&&Use the poster as a great introduction to role play - encourage speaking and listening by letting the children share their own experiences. Ask the children to close their eyes and listen to some of the sounds - for example, the sound of a letter dropping through a letterbox, the recorded voice saying \'Cashier number two please\' - do they recognise the sounds?&&&&&&&&&&On the left hand side of the interactive poster, you\'ll see an envelope - click here to listen to our song \'Knock, knock, knock\'. Let the children listen and then you can all join in - the link will provide you with the words. The stop/start buttons will allow you to stop and start the music - and then you can click to return to the main poster.&&&&&&&&&&Don\'t forget to make use of the role-play activities in the May issue of Child Education to accompany this interactive resource.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103270_atthepostoffice_int.gif'); UPDATE assets SET title='Theatrical mask', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98016_je0905_pb41.gif'); UPDATE assets SET title='Making sentences longer', description='Get your class to use the connective word cards to make short sentences longer.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-3.gif'), 9) DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb4.gif'), 'DT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb4.gif'), 'ICT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb4.gif'), 'XCR'); UPDATE assets SET title='Welsh Curriculum', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clwales1.gif'); UPDATE assets SET title='Northern Irish Curriculum ', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_clni.gif'); UPDATE assets SET title='Past, present and future', description='Children practise using past, present and future tenses with this set of sentences.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb7.gif'), 9) DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb5.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb5.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb5.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb3.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb3.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb3.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb2.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb2.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb2.gif'), 'LIT'); UPDATE assets SET title='Connecting words & phrases', description='Introduce children to different connectives used in writing.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046_A2ipb_pb-1.gif'), 9) UPDATE assets SET title='Poster: Coastal environment', description='

A scene of the coastline showing a variety of marine life.

', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105150_habitatspcp_sip-1.gif'); UPDATE assets SET title='Making mischief', description='Use this poem to inspire your class in a dance activity.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'), 'PE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'), 'XCR'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'), 2) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'), 3) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb4.gif'), 9) UPDATE assets SET title='Author profile: Paul Shipton', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102138_paul-shipton_mip.gif'); UPDATE assets SET title='Making sentences longer', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046__ce_1205_A2ipb_3.gif'); UPDATE assets SET title='Wildlife poster', description='Colour picture of the wildlife seen in the Scottish Highlands.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105996_je1206pcp27_sip-1.gif'); UPDATE assets SET title='Billy Goats Gruff', description='Get into character through story-inspired music and movement activities.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105882_billy-goats-gruff_int.swf'); UPDATE assets SET title='Pirate poster', description='Sail the seven seas and sing along with this animated pirate poster.', long_description='Sail the seven seas and sing along with this animated pirate poster. See also: _Child Education_ March 2007 for linking activities.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105133_pirate-poster_int.exe'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-24a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-24a.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-24a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-24a.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-24a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-24a.gif'), 'PSE'); UPDATE assets SET title='Snarglefoot Pie', description='This nonsense recipe from _Literacy Time Ages 7-9_ uses fantastical minibeasts to make teaching instructions fun!', long_description='This nonsense recipe from _Literacy Time Ages 7-9_ uses fantastical minibeasts to make teaching instructions fun! Can you imagine what Fumble-whompers look like and what Toppleturner milk might taste of? A motivating approach to instruction writing and imperative verbs.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102138_Snargle_pos.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b1_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b1_sip.gif'), 'MTH'); UPDATE assets SET title='Beside the seaside', description='Take a stroll along a Victorian pier using this month\'s mystery snapshots.', long_description='Take a stroll along a Victorian pier using this month\'s mystery snapshots. The aim of this series is to get children thinking about images as sources of evidence. Each month a different Key Stage 1 history topic will be addressed.&&&&&&&&&&In April\'s issue, we look at the Victorian pleasure pier. Read pages 48 and 49 of _Child Education_ for more information.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105134_beside-the-seaside_int.gif'); UPDATE assets SET title='Author profile: John Rice', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94837_john-rice_mip.gif'); UPDATE assets SET title='Around the town', description='A vibrant poster showing the birds-eye view of a town, which can be viewed on your interactive whiteboard.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106601_ce01006a2ii_pb-5.gif'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106445_LT34-ni0107-attain-targets.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705-34a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705-34a.gif'), 'MTH'); UPDATE assets SET title='Using adjectives', description='Help children to improve their writing using carefully chosen adjectives.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb5.gif'), 9) UPDATE assets SET title='Famous diaries', description='_Literacy Time Ages 9-11_ presents real life diary extracts from the Victorian era.', long_description='_Literacy Time Ages 9-11_ presents real life diary extracts from the Victorian era. Read the thoughts of the eminent novelist Sir Walter Scott and the sister of the famous poet William Wordsworth.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83481_diaries_pos.gif'); UPDATE assets SET title='Play Noddy\'s Paint It! Game', description='Noddy\'s Paint It game is a great fun way to learn colours. ', long_description='Paint a picture of Noddy - without using any paint or paintbrushes! Pre-schoolers will love this fun activity. Point out the different functions, including how they can mix different coloured paints by clicking on two colours and pressing the \'mix\' button. Great for developing their mouse control and fine motor skills. TM Enid Blyton Limited (a Chorion company). All rights reserved. See pages 25-27 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'), 'ART'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'), 'DT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'), 'ICT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'), 'XCR'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'), 11) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'), 14) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'), 2) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_play_colour_int.gif'), 21) UPDATE assets SET title='Hurt No Living Thing', description='_Literacy Time Ages 7-9_ presents a classic poem by Christina Rossetti about looking after minibeasts.', long_description='_Literacy Time Ages 7-9_ presents a classic poem by well-known Victorian writer Christina Rossetti about looking after minibeasts.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102138_bugpoetry_pos.gif'); UPDATE assets SET title='Sleeping Beauty poster', description='A poster showing a scene from the fairytale ', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=0, age_end=5 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28a3ii_pf.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb5.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-35.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-35.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-35.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-35.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-35.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_sip-35.gif'), 'LIT'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106433_LT12-scot0107-attain-targets_sip.gif'); UPDATE assets SET title='Where you live', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046__ce_1205_A2iipb_4.gif'); UPDATE assets SET title='Poster activities', description='Help children to be aware of the environment with these fun ideas.', long_description='See the Environment special on pages 17-23 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'), 'ART'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'), 'SCI'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'), 10) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'), 15) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'), 16) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb1.gif'), 21) UPDATE assets SET title='Blair wins again!', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_sip-21a.gif'); UPDATE assets SET title='Wendell the Wizard Worm (2)', description='Introduce children to the idea of composting with the story of Wendell the Wizard Worm. (Part 2)', long_description='See page 23 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'), 'SCI'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'), 15) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'), 16) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23b.gif'), 7) UPDATE assets SET title='Author profile: Anthony Browne', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106435_anthony-browne_mip.gif'); UPDATE assets SET title='Author profile: David Clayton', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94841_david-clayton_sip.gif'); UPDATE assets SET title='Crystal Rain Forest', description='Use the webcams to explore the wildlife of the \'Azon Rain Forest\' (see pages 48-49 of the June issue of _ChildEd_ for linking activities and resources).', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_forestcam_int.exe'); UPDATE assets SET title='English Curriculum', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_cleng1.gif'); UPDATE assets SET title='Connecting words and phrases', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046__ce_1205_A2ipb_1.gif'); UPDATE assets SET title='Count on/count back', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_sip-34a.gif'); UPDATE assets SET title='Growth poster', description='A poster showing the life cycle of a frog', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=0, age_end=5 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28a2_pf.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb6.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb6.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb6.gif'), 'LIT'); UPDATE assets SET title='Author profile: Sheila Hoeman', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94845_sheila-hoeman_mip.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb3.gif'), 'DT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb3.gif'), 'GEO'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb3.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb3.gif'), 'PSE'); UPDATE assets SET title='Draft Framework', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_LT34-eng1106-attain-targets_sip.gif'); UPDATE assets SET title='Virtual Dig', description='Inspire your pupils with your very own classroom archaeological dig of a Roman villa. See The Virtual Dig on pages 43-45 of the February issue of _Junior Education_ and get supporting material from our online downloadable photocopiable worksheets here.', long_description='Inspire your pupils with your very own classroom archaeological dig of a Roman villa!* Spend some time familiarising yourself with its features. * Photocopy and laminate enough Artefact and Expert Opinion sheets (see Free downloads) for each group. * Take a look at pages 43-45 in your February Junior Education.&&&&&&&&&&Each artefact in the virtual dig has a link to the photographs on the A2 poster.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99721_virtual-dig_int.gif'); UPDATE assets SET title='Sentence shuffle', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_onlinepcps_mip2.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2i-b1_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2i-b1_sip.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2i-b1_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2i-b1_sip.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2i-b1_sip.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2i-b1_sip.gif'), 'LIT'); UPDATE assets SET title='Black Country Living Museum', description='A recount of a day out at the Black Country Living Museum from _Literacy Time Ages 9-11_. This interactive scrapbook with turning pages features photos, captions, a map and pull out pages. ', long_description='A recount of a day out at the Black Country Living Museum from _Literacy Time Ages 9-11_. This interactive scrapbook with turning pages features photos, captions, a map and pull out pages. Written from the viewpoint of a ten-year-old boy, this lively text will inspire all your children to write their own recounts.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106444_bcountry-museum_int.exe'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-41.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-41.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-41.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-41.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-41.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-41.gif'), 'LIT'); UPDATE assets SET title='Alfie\'s World', description='Explore Alfie\'s World with Child Education\'s great interactive poster for your class PC or whiteboard.', long_description='Explore the countryside with this delightful interactive poster based on _Alfie\'s World_ by Shirley Hughes (Bodley Head Children\'s Books, ISBN 0370328949). See also: Child Education February 2007 for linking activities and an exclusive interview with Shirley Hughes.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105132_alfies-world_int.exe'); UPDATE assets SET title='Streets ahead', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99046__ce_1205_A2iipb_1.gif'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106445_LT34_nls0107_sip.gif'); UPDATE assets SET title='Wendell the Wizard Worm (1)', description='Introduce children to the idea of composting with the story of Wendell the Wizard Worm. (Part 1)', long_description='See page 23 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'), 'SCI'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'), 15) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'), 16) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-23a.gif'), 7) DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_sip-37a.gif'), 'RE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb2.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb2.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb4.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb4.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb4.gif'), 'RE'); UPDATE assets SET title='Toy games', description='Go toy crazy with activities that develop art, movement and play skills.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'), 'ART'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'), 'PE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'), 'XCR'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'), 10) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99045_ce1105_pb2.gif'), 21) UPDATE assets SET title='Northern Irish Curriculum', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clni1.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb3.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb3.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb3.gif'), 'HIS'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb3.gif'), 'LIT'); UPDATE assets SET title='Keep-fit fun for everyone', description='Get your class fit and healthy with this sports chant performance poem.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105134_A2i_CE0407_pb.gif'); UPDATE assets SET title='Scotland attainment targets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT12-scot1106-attain-targets_sip.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb6.gif'), 'XCR'); UPDATE assets SET title='The eruption of Vesuvius', description='_Literacy Time Ages 9-11_ presents a real life eye witness account of the eruption of Vesuvius in 79AD.', long_description='_Literacy Time Ages 9-11_ presents a real life eye witness account of the eruption of Vesuvius in Pompeii in 79AD. Written by Roman senator Pliny the Younger (c61-112AD).', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94840_vesuvius_pos.gif'); UPDATE assets SET title='what can we compost?', description='Get your class to identify items for composting or rubbish/recycling.', long_description='See the Environment special on pages 17-23 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'), 'SCI'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'), 10) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'), 15) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb3.gif'), 16) UPDATE assets SET title='Brick patterns', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_onlinepcps_mip.gif'); UPDATE assets SET title='In Flanders Fields', description='The poem \'In Flanders Fields\' by war poet and soldier John McCrae uses the symbolism of a poppy, presented by _Literacy Time Ages 7-9_.', long_description='The poem \'In Flanders Fields\' by war poet and soldier John McCrae uses the symbolism of a poppy, presented by _Literacy Time Ages 7-9_. This well-known and moving poem from the First World War was written by a Canadian soldier who witnessed his friend\'s death. It uses the poppy as a dramatic symbol and is accompanied by a short extract from Shakespeare\'s _Hamlet_ that also features flowers as symbols.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106445_Flanders_pos.gif'); UPDATE assets SET title='SMART tip', description='Great SMART board tips from _Junior Education_', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103655_smart-tip1_int.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb8.gif'), 'SCI'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_WebPage_sip-21a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_WebPage_sip-21a.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_WebPage_sip-21a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_WebPage_sip-21a.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_WebPage_sip-21a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_WebPage_sip-21a.gif'), 'PSE'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106441_LT56-ni0107-attain-targets.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb6.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb6.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb6.gif'), 'LIT'); UPDATE assets SET title='Welsh Curriculum', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_clwales_mip.gif'); UPDATE assets SET title='Author profile: Alison Milford', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94844_alison-milford_mip.gif'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106434_LT56-ni0307-attain-targets.gif'); UPDATE assets SET title='What can we compost?', description='Get your class to identify things that can be composted.', long_description='See page 22 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22b.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22b.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22b.gif'), 'SCI'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22b.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22b.gif'), 15) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22b.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_sip-22b.gif'), 16) UPDATE assets SET title='The rotting rate', description='Illustrated poster to raise children\'s awareness of the rotting rates of common items.', long_description='See the Environment special on pages 17-23 of the October 2005 issue of _Child Education_.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'), 'SCI'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'), 10) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'), 15) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb2.gif'), 16) UPDATE assets SET title='Author profile: Brian Moses', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94839_brian-moses_mip.gif'); UPDATE assets SET title='Safari park animals 3', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105144_cet0407a1_pb-2.gif'); UPDATE assets SET title='At the Supermarket', description='_Child Education_ bring you the sights and sounds of a real supermarket with this fun, lively interactive poster. Great to use on either your IWB or your PC.', long_description='Every shopping trip begins with a shopping list. Together with the children, make a list of all the things you want to buy from the supermarket. Scribe the list on the whiteboard, demonstrating use of commas and fullstops. Once you have made a whole-class shopping list, get the class to think about which sections of the supermarket they will have to visit. Stick cards around the classroom with the names of the food sections on them (meat, dairy, cereal, bakery, fish, fruit and veg, and so on). Give each child an item from the list and ask them to go to the section where they think they might find it.&&&&&&&&&&Ask the children to imagine they are a character from a story or fairytale. What might their character buy from a supermarket? What wouldn\'t they buy and why?&&&&&&&&&&Ask the children to think about the people who help us at the supermarket. Get the children to prepare and act out situations where each of these job roles is shown in action.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104598_atthesupermarket_int.gif'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106433_LT12-ni0107-attain-targets.gif'); UPDATE assets SET title='Shopping Trolley Poem', description='A fantastic literacy resource for your whiteboard from _Junior Education_.', long_description='The great _Shopping Trolley_ interactive poster by Brian Moses.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105994_shopping-trolley_int.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb8.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb8.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98255_ce0705_pb8.gif'), 'LIT'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb6.gif'), 'MTH'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb6.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98022_ce0605_pb6.gif'), 'SCI'); UPDATE assets SET title='Mafia Cats', description='_Literacy Time Ages 9-11_ presents the poem \'Mafia Cats\' by Roger McGough. This humorous poem from an award-winning poetry collection has wonderful illustrations and is read by Roger himself!', long_description='_Literacy Time Ages 9-11_ presents the poem \'Mafia Cats\' by renowned Liverpool poet Roger McGough. This humorous poem from an award-winning poetry collection _Bad, Bad Cats_ has wonderful illustrations and is read by Roger himself! Bring poetry to life and hear how the poet intended his work to be heard.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106448_mafia-cats_int.exe'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-39a.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-39a.gif'), 'MTH'); UPDATE assets SET title='Grimlin the wizard', description='Ask your children to identify all the adjectives in this illustrated story. ', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'), 'LIT'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'), 13) DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99044_ce1005_pb7.gif'), 9) DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'), 'PE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'), 'XCR'); DELETE FROM assets_keywords WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'); INSERT INTO assets_keywords (asset_id, keyword_id) VALUES (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_sip-34b.gif'), 4) UPDATE assets SET title='A country walk', description='Explore landscapes and different geographical areas with this new series of fictional locations.', long_description='Explore landscapes and different geographical areas with this new series of fictional locations. The aim of this series is to get children to think about how people use their local environment for work and leisure.&&&&&&&&&&In June\'s issue, we look at a typical English countryside. Read pages 40 and 41 of _Child Education_ for more information.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_country-walk_int.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb7.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb7.gif'), 'KUW'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb7.gif'), 'PSD'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb7.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98256_ce0805_pb7.gif'), 'PSE'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb1.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb1.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb1.gif'), 'HIS'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb1.gif'), 'LIT'); UPDATE assets SET title='Thesaurus', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102137_thesaurus_pos.gif'); UPDATE assets SET title='Tell me why!', description='Thought-provoking questions and answers', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_ce05-2_mip40.gif'); UPDATE assets SET title='Northern Irish Curriculum ', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_clni1.gif'); UPDATE assets SET title='Prefixes and Suffixes', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_onlinepcps_mip3.gif'); UPDATE assets SET title='Poster - Victorian Sreet', description='Poster showing a scene of a busy street from the Victorian era.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102470_jetibc_sip.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b3_sip2.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98021_ce05-a2ii-b3_sip2.gif'), 'MTH'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb8.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb8.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb8.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98757_ce0905_pb8.gif'), 'LIT'); UPDATE assets SET title='Rockin\' Robot Karaoke', description='A fun sing-a-long resource from the _Child Education_ team.', long_description='Sing a long to this fun resource (see pages 20-21 of the July issue of ChildEd for linking activities and resources). Click on the image above to begin. Use the refresh button on your browser to start the song again.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105137_rockin-robot_int.exe'); UPDATE assets SET title='Worksheets', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105167_jet0707clinkwal_sip-1.gif'); UPDATE assets SET title='Witch\'s cabin', description='Fall under the spell of our new interactive resource, by taking a peek inside a spooky home...', long_description='The door is locked and you don\'t have a key - but don\'t let that stop you taking a sneaky peek inside, to find out all you can about the mysterious owner. This exclusive resource is best viewed full screen on an interactive whiteboard. By pointing at different areas of the screen, children will be able to move the keyhole and uncover sections of the picture, bit by bit. When you\'re done exploring, the whole image can be revealed so children can see the room in all its spooky glory.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_keyhole.exe'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807a2i_pb-1.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807a2i_pb-1.gif'), 'HIS'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_harbour.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_harbour.gif'), 'GEO'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_a1post.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_a1post.gif'), 'HIS'); UPDATE assets SET title='Hands that tell a story (mp3)', description='\'Hands that tell a story\' provides a great starting point for children to explore Indian dance.', long_description='Indian dance has become a popular art form in the western world due to its vibrant and visual impact. As you listen to the music, display the Indian dance hand gestures poster included in August ChildEd and get the children to perform the accompanying gestures. You can also download the activities, lyrics and music that appear on the back of the poster.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_song.gif'); UPDATE assets SET title='Granny Is (mp3)', description='Listen to Val Bloom perform \'Granny Is\', a poem written in Jamaican Patois, inspired by her grandmother.', long_description='Val Bloom was born in Jamaica and came to Britain in 1979. She is a poet and author. Listen to her perform \'Granny Is\', a poem written in Jamaican Patois. To look at the poem it may first appear totally alien to a non-speaker, but hearing it aloud will often reveal its meaning.', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_granny.gif'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_granny.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_granny.gif'), 'CLL'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_granny.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_granny.gif'), 'ENG'); DELETE FROM assets_subject_categories WHERE asset_id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_granny.gif'); INSERT INTO assets_subject_categories (asset_id, subject_category_id) VALUES ((SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0807_granny.gif'), 'LIT'); UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105138_ce0907_keyhole.gif'); UPDATE assets SET title='Interactive Flash', description='Ice grotto', long_description='The door is locked and you don\'t have a key - but don\'t let that stop you taking a sneaky peek inside, to find out all you can about the mysterious owner. This exclusive resource is best viewed full screen on an interactive whiteboard. By pointing at different areas of the screen, children will be able to move the keyhole and uncover sections of the picture, bit by bit. When you\'re done exploring, the whole image can be revealed so children can see the room in all its spooky glory.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112093_ce0907_keyhole.exe'); UPDATE assets SET title='People who work at night', description='People who work at night', long_description='What is it like to be at work when everyone else is asleep? Children can find out by listening to and watching four short interviews - with a fire officer, a supermarket worker, a midwife and an airline pilot.', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112380_people-work-night_int.exe'); UPDATE assets SET title='Nocturnal animals', description='Nocturnal animals', long_description='Interactive non-chronological report. Spot the animals in the night time woodland scene to find out more about nocturnal wildlife in the UK. ', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112380_nocturnal-animals_int.exe'); UPDATE assets SET title='Stories of the sea', description='Stories of the sea', long_description='Electronic story frame for planning and telling stories on a sea theme. With a choice of characters, settings, opening and ending sentences, connectives, speech and thought bubbles, similes, metaphors and sound effects. ', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112720_stories-of-the-sea_int.exe'); UPDATE assets SET title='The Tale Coat', description='The Tale Coat', long_description='An interactive story \'jukebox\' in which children can click on the images on Taffy Thomas\' famous Tale Coat to hear the storyteller tell three traditional tales - The Clever Wish, The Little Cobblestone Maker and Coyote and the Fire Witch. ', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112730_tale-coat_int.exe'); UPDATE assets SET title='Coastal erosion - the quiet crisis', description='Coastal erosion - the quiet crisis', long_description='Multi-media information text with links to geography, featuring a video about coastal erosion on the Isle of Walney, Cumbria. Ideal for work on information and recount texts and persuasive language. ', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112720_coastal-erosion_int.exe'); UPDATE assets SET title='My Mum\'s Sari', description='My Mum\'s Sari', long_description='Poet Bashabi Fraser reads her delightful observational poem, \'My Mum\'s Sari\', written from the viewpoint of a young child. Text with audio version. ', subscriber_only=true, is_visible=true, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112730_my-mums-sari_int.exe'); UPDATE assets SET title='Jack & the Beans Talk - Old Wifie', description='Jig with Jack with this great audio resource _Old Wifie_ from Child Education\'s Oct 2007 issue.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_oldwifies_aud.gif'); UPDATE assets SET title='Right or wrong? (3)', description='Child Education October 2007 Road Safety photocopiable resource.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007A2i_pb-4.gif'); UPDATE assets SET title='Thesaurus', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=7 , age_end=9 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106445_thesaurus_pos.pdf'); UPDATE assets SET title='Diaries', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94841_diaries_pos.pdf'); UPDATE assets SET title='Mystery Scene\'s (2)', description='Child Education October 2007\'s Mystery Scene resource.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007A2ii_pb-6.gif'); UPDATE assets SET title='Jack & the Beans Talk - Lot in the Pot', description='Jig with Jack with this great audio resource _Lot in the Pot_ from Child Education\'s Oct 2007 issue.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_lotinpot_aud.gif'); UPDATE assets SET title='Woodland Den', description='Explore this snug and inviting scene and guess (who, or what!) might live there from Child Education\'s Through the Keyhole interactive series (October 2007).', long_description='This woodland den looks warm and exciting - but who might live in a home like this? The door is locked and there\'s no key under the mat but don\'t let that stop your class taking a peek through the keyhole. See page 51 of Child Education\'s October 2007 issue.', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_woodland_int.exe'); UPDATE assets SET title='Mystery Scene\'s (1)', description='Child Education October 2007\'s Mystery Scene resource.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007A2ii_pb-5.gif'); UPDATE assets SET title='Mystery Scene\'s (4)', description='Child Education October 2007\'s Mystery Scene resource.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007A2ii_pb-8.gif'); UPDATE assets SET title='Whatever Happened to Baby Drac? (1)', description='Great maths investigations directly linked to the Renewed Framework for Mathmatics (Child Education October 2007).', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007onlinemaths2_mip-3.gif'); UPDATE assets SET title='A Life of Drawing', description='Jan Pienkowski reflects on a career in illustration.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007onlineDrawing_sip-1.gif'); UPDATE assets SET title='Poster Front', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_road-safety_pos.gif'); UPDATE assets SET title='Jack and the Beans Talk - Fee Fi Fo Fum', description='Jig with Jack with this great audio resource _Fee Fi Fo Fum_ from Child Education\'s Oct 2007 issue.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_feefifo_aud.gif'); UPDATE assets SET title='The Green Cross Code', description='Cross the road safely with this Child Education photocopiable resource.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007A2i_pb-1.gif'); UPDATE assets SET title='Jack & the Beans Talk - Telling a Story', description='Jig with Jack with this great audio resource _Telling a story_ from Child Education\'s Oct 2007 issue.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_tellingstory_aud.gif'); UPDATE assets SET title='Road Safety Whiteboard Poster', description='Child Education October 2007\'s Road Safety whiteboard poster.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007onlineRoadSafety_pos.gif'); UPDATE assets SET title='Mystery Scene\'s (3)', description='Child Education October 2007\'s Mystery Scene resource.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007A2ii_pb-7.gif'); UPDATE assets SET title='Sample musical fairytale adventure', description='Sample musical fairytale adventure from Shoofly.', long_description='Jack and the Beans Talk is the lead title in a series of interactive resources from Shoo Fly Publishing for Key Stage 1 and 2 children. Here is a sample of the \'Mini Bean Operetta".', subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_shoofly-sample_int.exe'); UPDATE assets SET title='Royalty', description=null, long_description=null, subscriber_only=false, is_visible=false, exclusive_online=false, age_start=5 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94835_Royalty_posindd.pdf'); UPDATE assets SET title='Instructions for moving along a route', description='Great maths investigations directly linked to the Renewed Framework for Mathmatics (Child Education October 2007).', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007onlinemaths_mip-4.gif'); UPDATE assets SET title='Jack & the Beans Talk - Bean Polka', description='Jig with Jack with this great audio resource _Bean Polka_ from Child Education\'s Oct 2007 issue.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_beanpolka_aud.gif'); UPDATE assets SET title='Right or wrong? (2)', description='Child Education October 2007 Road Safety photocopiable resource.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007A2i_pb-3.gif'); UPDATE assets SET title='Right or wrong?', description='Child Education October 2007 Road Safety photocopiable resource.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_ce1007A2i_pb-2.gif'); UPDATE assets SET title='Jack and the Beans Talk - Dancing Bean', description='Jig with Jack with this great audio resource _Dancing Bean_ from Child Education\'s Oct 2007 issue.', long_description=null, subscriber_only=false, is_visible=true, exclusive_online=false, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_dansingbean_aud.gif'); UPDATE assets SET title='This is indeed India!', description=null, long_description=null, subscriber_only=true, is_visible=true, exclusive_online=false, age_start=9 , age_end=11 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83481_India_pos.pdf'); UPDATE assets SET title='At the Zoo - webquest', description='A Child Education PowerPoint resource for creating a webquest that links the teaching of life cycles.', long_description='See Child Education\'s Point Click Create activity (pages 23-25)', subscriber_only=false, is_visible=true, exclusive_online=true, age_start=4 , age_end=7 WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%112094_DIY-zooweb_ppt.gif');