UPDATE assets SET title='Dear diary', description='Dear diary photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101219_rrsuitcase_sip-15.gif' );
UPDATE assets SET title='Places', description='Places photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101219_rrsuitcase_sip-18.gif' );
UPDATE assets SET title='Talk about it', description='Shared reading activities' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101219_rrsuitcase_sip-20.gif' );
UPDATE assets SET title='Shared reading ', description='Shared reading activities' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101219_rrsuitcase_sip-7.gif' );
UPDATE assets SET title='Halloween', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102034_bifestivals_sip-13.gif' );
UPDATE assets SET title='Advent', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102034_bifestivals_sip-23.gif' );
UPDATE assets SET title='Purim', description='Teachers\' notes on understanding more about Purim and the story behind the festival.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102034_bifestivals_sip-57.gif' );
UPDATE assets SET title='Palm Sunday', description='Teachers\' notes on learning more about Palm Sunday.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102034_bifestivals_sip-62.gif' );
UPDATE assets SET title='Rosh Hashana', description='Teachers\' notes on understanding what the Jewish New Year means and how it is celebrated.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102034_bifestivals_sip-8.gif' );
UPDATE assets SET title='Castle scenes', description='Castle scenes photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102204_eypcpd_mact_mip.gif' );
UPDATE assets SET title='Toys', description='Toys teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102204_eypcpd_mles_mip-11.gif' );
UPDATE assets SET title='Example from Toys chapter', description='Example from Toys chapter teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102204_eypcpd_mles_mip-21.gif' );
UPDATE assets SET title='Telephone: It\'s for you!', description='It\'s for you photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102205_eypcpictact_mip1.gif' );
UPDATE assets SET title='How things work', description='How things work teachers notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102205_eypcpictles_mip-11.gif' );
UPDATE assets SET title='How things work', description='How things work teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102205_eypcpictles_mip-21.gif' );
UPDATE assets SET title='Stage one activities: Listening', description='Stage one activities - Listening' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103281_phonics_sip-13.gif' );
UPDATE assets SET title='Sample minibook', description='Example pages from minibook' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103281_phonics_sip-173.gif' );
UPDATE assets SET title='Rhyming pictures', description='Rhyming pictures photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103281_phonics_sip-22.gif' );
UPDATE assets SET title='Phoneme cards', description='Phoneme cards actvity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103281_phonics_sip-43.gif' );
UPDATE assets SET title='Consonants and short vowels', description='Consonants and short vowels teachers\' notes.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103281_phonics_sip-55.gif' );
UPDATE assets SET title='The Hot Seat game', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104173_qfy6comp_sip-19.gif' );
UPDATE assets SET title='Understanding Evaluation', description='Teachers\' notes on how to find the answer to an evaluation question and back it up with evidence in the text.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104173_qfy6comp_sip-44.gif' );
UPDATE assets SET title='The scarecrow', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104173_qfy6comp_sip-45.gif' );
UPDATE assets SET title='Playing the game', description='Playing the game activity' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104173_qfy6comp_sip-46.gif' );
UPDATE assets SET title='Word web', description='Word web activity' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104173_qfy6comp_sip-47.gif' );
UPDATE assets SET title='Kasper in the Glitter', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104173_qfy6comp_sip-76.gif' );
UPDATE assets SET title='Kasper in the Glitter Quiz', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104173_qfy6comp_sip-77.gif' );
UPDATE assets SET title='Recipe for a poem', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17896_wg-po5-7_sip11.gif' );
UPDATE assets SET title='Look at me - Teacher\'s notes', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17896_wg-po5-7_sip17.gif' );
UPDATE assets SET title='The seasons', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17896_wg-po5-7_sip26.gif' );
UPDATE assets SET title='Ten green dragons', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17896_wg-po5-7_sip4.gif' );
UPDATE assets SET title='Fridge words', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17897_wg-poetry7-9_sip23.gif' );
UPDATE assets SET title='Building poems', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17898_wg-po9-11_sip17.gif' );
UPDATE assets SET title='Planning a news story', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17903_wg-news9-11_sipp22.gif' );
UPDATE assets SET title='Traffic jams', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%27325_outplay_sip53.gif' );
UPDATE assets SET title='How does it feel?', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%27325_outplay_sip54.gif' );
UPDATE assets SET title='The spider\'s web', description='Activity for Early Learning Goals \'Handle tools, objects, construction and malleable materials safely and with increasing control\'.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%27325_outplay_sip56.gif' );
UPDATE assets SET title='Memory game', description='Photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%27325_outplayact_mip1.gif' );
UPDATE assets SET title='The Christmas Story', description='The Christmas story photocopiable sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28322_festfunact_mip1.gif' );
UPDATE assets SET title='Cross-curricular ideas', description='Five little elves, Christmas twister' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28322_ffxmaseaster_sip12.gif' );
UPDATE assets SET title='Role-play ideas', description='Santa\'s workshop - teachers notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28322_ffxmaseaster_sip17.gif' );
UPDATE assets SET title='Cross-curricular ideas', description='New life and Smooth eggs and bumpy eggs activities' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28322_ffxmaseaster_sip35.gif' );
UPDATE assets SET title='Hold your own celebration', description='Bun party teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28322_ffxmaseaster_sip40.gif' );
UPDATE assets SET title='The Easter story', description='The Easter story photocopiable sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28322_ffxmaseaster_sip42.gif' );
UPDATE assets SET title='Allergy', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28626_a-zguide_sip10.gif' );
UPDATE assets SET title='Attachment', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28626_a-zguide_sip12.gif' );
UPDATE assets SET title='Attention difficulties and AD/HD', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28626_a-zguide_sip13.gif' );
UPDATE assets SET title='Disability act', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28626_a-zguide_sip25.gif' );
UPDATE assets SET title='Happy Hanukkah', description='Hold your own celebration' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28739_hanukkahrosh_sip18.gif' );
UPDATE assets SET title='Hanukkah rhymes', description='Hanukkah rhymes, party invitation plus photocopiable activity sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28739_hanukkahroshact_mip1.gif' );
UPDATE assets SET title='Mary, Mary Quite Contrary', description='Mary, Mary Quite Contrary photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip19.gif' );
UPDATE assets SET title='If Your Happy and You Know It', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip20.gif' );
UPDATE assets SET title='If Your Happy and You Know It', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip21.gif' );
UPDATE assets SET title='Mary, Mary Quite Contrary', description='Mary, Mary Quite Contrary photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip42.gif' );
UPDATE assets SET title='Mary, Mary Quite Contrary', description='Mary, Mary Quite Contrary photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip43.gif' );
UPDATE assets SET title='Mary, Mary Quite Contrary', description='Mary, Mary Quite Contrary photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip44.gif' );
UPDATE assets SET title='Mary, Mary Quite Contrary', description='Mary, Mary Quite Contrary photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip45.gif' );
UPDATE assets SET title='The Grand Old Duke of York', description='The Grand Old Duke of York finger puppet template' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30565_fsey-action_sip30.gif' );
UPDATE assets SET title='The Grand Old Duke of York', description='The Grand Old Duke of York finger puppet template' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30565_fsey-action_sip31.gif' );
UPDATE assets SET title='The Grand Old Duke of York', description='The Grand Old Duke of York finger puppet template' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30565_fsey-action_sip32.gif' );
UPDATE assets SET title='The Grand Old Duke of York', description='The Grand Old Duke of York finger puppet template' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30565_fsey-action_sip33.gif' );
UPDATE assets SET title='I Hear Thunder', description='I Hear Thunder photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30588_fsey-circle_sip42.gif' );
UPDATE assets SET title='I Hear Thunder', description='I Hear Thunder photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30588_fsey-circle_sip43.gif' );
UPDATE assets SET title='I Hear Thunder', description='I Hear Thunder photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30588_fsey-circle_sip44.gif' );
UPDATE assets SET title='I Hear Thunder', description='I Hear Thunder photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30588_fsey-circle_sip45.gif' );
UPDATE assets SET title='Divas and light', description='Hold your own celebration' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30743_ff-divali_sip18.gif' );
UPDATE assets SET title='Divali - Happy New Year', description='Divali - Happy New Year photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30743_ff-divaliact_mip1.gif' );
UPDATE assets SET title='Good luck', description='Mathematical development' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30744_ffchineseny_sip16.gif' );
UPDATE assets SET title='Beautiful boats', description='Creative development' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30744_ffchineseny_sip36.gif' );
UPDATE assets SET title='Background information and planning', description='Background information and planning teachers notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30744_ffchineseny_sip5.gif' );
UPDATE assets SET title='Festival planner', description='Festival planner sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30744_ffchinesenyact_mip.gif' );
UPDATE assets SET title='How does it feel?', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4232_behav_sip27.gif' );
UPDATE assets SET title='Two little hands', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4232_behav_sip47.gif' );
UPDATE assets SET title='Heavier and lighter', description='Heavier and lighter teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4532_an100mathsrecact_mip1.gif' );
UPDATE assets SET title='Unit 10 ', description='Teachers\' notes grid' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4532_an100mathsrecact_p65.gif' );
UPDATE assets SET title='Heavier and lighter', description='Heavier and lighter teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4532_an100mathsrecact_p68.gif' );
UPDATE assets SET title='Find the totals ', description='Find the totals differentiated sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4533_Y1findtotals_mip.gif' );
UPDATE assets SET title='Termly planning grid', description='Planning grid' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4534_100mathsy2_sip-142.gif' );
UPDATE assets SET title='2D and 3D shapes', description='Planning grid' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4534_100mathsy2_sip-34.gif' );
UPDATE assets SET title='Teachers\' notes', description='Unit 6 lesson 1 and lesson 2' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4534_100mathsy2_sip-35.gif' );
UPDATE assets SET title='Learning to talk', description='Photocopiable teachers\' notes.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81786_an100litrecact_mip.gif' );
UPDATE assets SET title='\'My History\' recount', description='Teachers\' notes ' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81786_an100litrecles_mip.gif' );
UPDATE assets SET title='Food mix and match', description='Photocopiable activity sheet.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81788_an100lity1act_mip.gif' );
UPDATE assets SET title='Making a story tape', description='Teachers notes on making a story tape' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81788_an100lity1act_p124.gif' );
UPDATE assets SET title='Modelling writing ', description='Teachers notes on modelling writing.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81788_an100lity1act_p22.gif' );
UPDATE assets SET title='Non-fiction 1', description='Create a supermarket' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81788_an100lity1act_p27.gif' );
UPDATE assets SET title='NLS objectives', description='NLS grid' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81788_an100lity1act_p8.gif' );
UPDATE assets SET title='What happens next?', description='What happens next teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81789_100LitHoursY2_sip60.gif' );
UPDATE assets SET title='A walk in the dark woods', description='A walk in the dark woods: part 1 photocopiable sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81789_100LitHoursY2_sip61.gif' );
UPDATE assets SET title='Dinosaurs (2)', description='Dinosaurs (2) teachers notes.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81807_an100lity3_sip-119.gif' );
UPDATE assets SET title='Bird watchers reports', description='Bird watchers reports teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81807_an100lity3_sip-74.gif' );
UPDATE assets SET title='Birds', description='Birds photocopiable' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81807_an100lity3act_mip.gif' );
UPDATE assets SET title='How to catch a gingerbread man', description='How to catch a gingerbread man photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81808_an100lity4act_mip.gif' );
UPDATE assets SET title='Persuasive language', description='Persuasive writing teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81808_an100lity4les_mip-1.gif' );
UPDATE assets SET title='How to help', description='How to help teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81808_an100lity4les_mip-2.gif' );
UPDATE assets SET title='A good recount should have:', description='UNIT 5 Note-taking and recount photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81809_100lity5act_mip.gif' );
UPDATE assets SET title='Plot cards', description='Plot cards teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81809_100lity5les_mip.gif' );
UPDATE assets SET title='Film review', description='Film review photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81810_100lity6act_mip.gif' );
UPDATE assets SET title='Emails', description='writing emails teachers notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81810_100lity6les_mip-1.gif' );
UPDATE assets SET title='Film review', description='Film review teachers notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81810_100lity6les_mip-2.gif' );
UPDATE assets SET title='What can you do?', description='Teachers\' notes on learning the function of verbs in sentences by collecting and classifying examples of verbs from own knowledge.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82029_bigram_sip22.gif' );
UPDATE assets SET title='All together now...', description='All together now... photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82029_bigram_sip29.gif' );
UPDATE assets SET title='The subject sack', description='Teachers\' notes on securing the use of simple sentences in their own writing and to write in full sentences.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82029_bigram_sip38.gif' );
UPDATE assets SET title='I say...', description='I say.... photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82029_bigram_sip76.gif' );
UPDATE assets SET title='Word detectives', description='Teachers\' notes looking at the use awareness of grammar to decipher new or unfamiliar words.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82029_bigram_sip80.gif' );
UPDATE assets SET title='Match the middles', description='Teachers\' notes on distinguishing the correct medial sound in given words and matching these words to a second word with the same medial sound.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82031_nbiphonicles_sip17.gif' );
UPDATE assets SET title='Match the middles', description='Match the middles photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82031_nbiphonicles_sip29.gif' );
UPDATE assets SET title='Does your toe know?', description='Teachers\' notes on identifying the correct spelling pattern for the oa sound in a range of words.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82031_nbiphonicles_sip62.gif' );
UPDATE assets SET title='Drop it', description='Teachers\' notes on practising rules for adding suffixes to common words.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82031_nbiphonicles_sip87.gif' );
UPDATE assets SET title='Syllable scramble', description='Teachers\' notes on building common words in a given category from syllables.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82031_nbiphonicles_sip88.gif' );
UPDATE assets SET title='Pick a poem', description='Pick a poem photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82032_nbispeakact_mip.gif' );
UPDATE assets SET title='Pick a poem', description='Teachers\' notes on read or recite with expression, using different voices, including \'narration\' voice and facial expression as and when appropriate.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82032_nbispeakles_mip.gif' );
UPDATE assets SET title='Weather warning cards', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82033_social-skills_sip20.gif' );
UPDATE assets SET title='Can I play?', description='Teachers\' notes on exploring considering other people\'s feelings and to link action consequences.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82033_social-skills_sip35.gif' );
UPDATE assets SET title='Story song', description='Teachers\' notes on learning a song and substituting sounds for some of the  words.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82033_social-skills_sip52.gif' );
UPDATE assets SET title='Problem puppets', description='Teachers\' notes on making finger puppets and using them in a role-play to encourage appropriate speaking and listening.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82033_social-skills_sip57.gif' );
UPDATE assets SET title='Guess the sound', description='Guess the sound photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82033_social-skills_sip64.gif' );
UPDATE assets SET title='Introduction', description='Page 5 of Cookery Fun' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83726_cookfun_sip5.gif' );
UPDATE assets SET title='Welsh Rarebit Recipe', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83726_cookfunact_mip.gif' );
UPDATE assets SET title='Lucky dip stories', description='Lucky dip stories teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83812_bi10mingamles_mip.gif' );
UPDATE assets SET title='Next in line', description='Next in line teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83812_bi10mingamles_sip26.gif' );
UPDATE assets SET title='History detectives', description='History detectives teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83812_bi10mingamles_sip55.gif' );
UPDATE assets SET title='Persuasive writing', description='Photocopiable activity sheet.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83859_50litlal7-9act_mip.gif' );
UPDATE assets SET title='Persuasive writing ', description='Teachers\' notes to go with the Persuasive writing activity sheet.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83859_50litlal7-9les_mip.gif' );
UPDATE assets SET title='Write-A-Rap Rap', description='Poem by Tony Mitten' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83862_50less9-11_sip118.gif' );
UPDATE assets SET title='Writing speech', description='Writing speech activity sheet.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83862_50less9-11_sip23.gif' );
UPDATE assets SET title='Sentences make sense', description='Teachers\' notes explore ambiguities that arise from sentence contractions, for example, through signs and headlines.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83862_50less9-11_sip24.gif' );
UPDATE assets SET title='Complex sentences', description='Teachers notes on forming complex sentences.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83862_50less9-11_sip36.gif' );
UPDATE assets SET title='Body facts', description='Body facts photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip12.gif' );
UPDATE assets SET title='Get fit with Frankenstein', description='Get fit with Frankenstein photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip18.gif' );
UPDATE assets SET title='Alcohol', description='Alcohol photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip27.gif' );
UPDATE assets SET title='The heart', description='The heart photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip39.gif' );
UPDATE assets SET title='You food and where it goes', description='You food and where it goes photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip47.gif' );
UPDATE assets SET title='See like a rabbit', description='See like a rabbit photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83918_hsanimalact_sip16.gif' );
UPDATE assets SET title='Evolution', description='Evolution photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83918_hsanimalact_sip18.gif' );
UPDATE assets SET title='Extinct or endangered', description='Extinct or endangered photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83918_hsanimalact_sip40.gif' );
UPDATE assets SET title='Bears beware quiz', description='Bears beware quiz activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83918_hsanimalact_sip46.gif' );
UPDATE assets SET title='Safety first', description='Safety first photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83920_hselectract_mip.gif' );
UPDATE assets SET title='Teachers notes', description='Sample teachers notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83920_hselectract_sip8.gif' );
UPDATE assets SET title='Newton\'s first law', description='Newton\'s first law photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83921_hsforcesact_sip12.gif' );
UPDATE assets SET title='Air resistance', description='Air resistance photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83921_hsforcesact_sip32.gif' );
UPDATE assets SET title='Juggling', description='Juggling photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83921_hsforcesact_sip34.gif' );
UPDATE assets SET title='Wordsearch puzzle', description='Science wordsearch puzzle photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83921_hsforcesact_sip48.gif' );
UPDATE assets SET title='Poisonous plants!', description='Poisonous plants! photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip12.gif' );
UPDATE assets SET title='Attack of the killer plants!', description='Attack of the killer plants! photocopiable activity sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip16.gif' );
UPDATE assets SET title='Fantastic foods', description='Fantastic foods photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip18.gif' );
UPDATE assets SET title='Brutal bug eaters', description='Brutal bug eaters photocopiable activity sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip31.gif' );
UPDATE assets SET title='Powerful Plants', description='Powerful plants photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip33.gif' );
UPDATE assets SET title='Savage spiders ', description='Savage spiders photocopiable activity sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83923_hsminibeastsact_sip22.gif' );
UPDATE assets SET title='Busy Bees', description='Busy Bees photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83923_hsminibeastsact_sip28.gif' );
UPDATE assets SET title='Ugly bug parade', description='Ugly bug parade photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83923_hsminibeastsact_sip35.gif' );
UPDATE assets SET title='Maria Merien\'s world of brilliant bugs', description='Maria Merien\'s world of brilliant bugs photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83923_hsminibeastsact_sip41.gif' );
UPDATE assets SET title='Table buddies', description='Teachers\' notes to go with Misfits photocopiable sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%84374_nbiwetplayles_mip.gif' );
UPDATE assets SET title='Loony limericks', description='Teachers\' notes that go with the Loony Limericks Photocopiable sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%84374_nbiwetplayles_sip20.gif' );
UPDATE assets SET title='Balloon bash tournament', description='Teachers\' notes to go with the Balloon bash tournament photocopiable sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%84374_nbiwetplayles_sip69.gif' );
UPDATE assets SET title='Picture Alphabet', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85179_snpydyslexiales_mip45.gif' );
UPDATE assets SET title='Who am I?', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85179_snpydyslexiales_mip58.gif' );
UPDATE assets SET title='Sounding it out', description='Sounding it out photcopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85801_hssoundact_sip12.gif' );
UPDATE assets SET title='Blimey, it\'s Beethoven!', description='Blimey, it\'s Beethoven! photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85801_hssoundact_sip17.gif' );
UPDATE assets SET title='Shattering sounds', description='Shattering sounds photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85801_hssoundact_sip29.gif' );
UPDATE assets SET title='Could you be a sound scientist?', description='Could you be a sound scientist? photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85801_hssoundact_sip48.gif' );
UPDATE assets SET title='The friendly scarecrow', description='The friendly scarecrow photocopiable activity sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86250_ffharv_sip38.gif' );
UPDATE assets SET title='Festival planner', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86250_ffharv_sip7.gif' );
UPDATE assets SET title='Harvest planner and rhymes', description='Festival planner, Harvest Rhymes and photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86250_ffharvact_mip.gif' );
UPDATE assets SET title='Map of the British Isles', description='Map of the British Isles photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86362_rrgeog2act_mip.gif' );
UPDATE assets SET title='India word cards', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86363_rrgeog3act_mip.gif' );
UPDATE assets SET title='Seaside resort word cards', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86366_rrgeog4act_mip.gif' );
UPDATE assets SET title='Making a Great Fire of London frieze', description='Activities for making a frieze displaying work on the Great Fire of London.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%89906_100hist5to7_sip-127.gif' );
UPDATE assets SET title='A Seaside role play', description='Photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%89906_100hist5to7_sip-73.gif' );
UPDATE assets SET title='A picture of Brunel', description='Photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%89906_100hist5to7act_mip.gif' );
UPDATE assets SET title='A guidebook about Ancient Greece', description='Teachers\' guide looking at assessment strategy.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%89931_100hist7to11_sip-114.gif' );
UPDATE assets SET title='Find out about Ancient Egypt from artefacts', description='Teachers\' notes looking at finding out about the events, people and changes studied from artefacts.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%89931_100hist7to11_sip-67.gif' );
UPDATE assets SET title='Dress a rich or poor Tudor boy', description='Photocopiable activity sheet.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%89931_100hist7to11act_mip.gif' );
UPDATE assets SET title='Moon watching', description='Cross-curricular ideas teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90007_fframa-eid_sip11.gif' );
UPDATE assets SET title='Rhymes', description='Rhymes photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90007_fframa-eid_sip22.gif' );
UPDATE assets SET title='Eid Mubarak', description='Display ideas' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90007_fframa-eid_sip38.gif' );
UPDATE assets SET title='Eid is here', description='Eid is here photocopiable sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90007_fframa-eid_sip42.gif' );
UPDATE assets SET title='Sun exclusive', description='Sun exclusive photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90134_hsearth_sip-14.gif' );
UPDATE assets SET title='Crazy constellations', description='Crazy constellations photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90134_hsearth_sip-16.gif' );
UPDATE assets SET title='Greedy grasping gravity', description='Greedy grasping gravity photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90134_hsearth_sip-36.gif' );
UPDATE assets SET title='Solar system wordsearch', description='Solar system wordsearch photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90134_hsearth_sip-41.gif' );
UPDATE assets SET title='Lovely lenses', description='Lovely lenses photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90135_hsmicro_sip-13.gif' );
UPDATE assets SET title='Make your own microscope', description='Make your own microscope photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90135_hsmicro_sip-17.gif' );
UPDATE assets SET title='House of horrors', description='House of horrors photocopiable activity sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90135_hsmicro_sip-38.gif' );
UPDATE assets SET title='Pillow problems', description='Pillow problems photocopiable activity sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90135_hsmicro_sip-39.gif' );
UPDATE assets SET title='Disaster story', description='Teachers\' notes on storytelling techniques and to understand the effects of severe weather conditions.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90158_nbidrama_sip-27.gif' );
UPDATE assets SET title='Rumour chain', description='Teachers\' notes about learning the importance of storytelling in drama;
 to imagine what life was like in the court of Henry VIII.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90158_nbidramales_mip-1.gif' );
UPDATE assets SET title='Chinese dragon mask template', description='Photocopiable activity sheet.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90162_100assemact5-7_mip.gif' );
UPDATE assets SET title='World Red Cross Day', description='Look at the work of charities.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90162_100assemact5-7p45.gif' );
UPDATE assets SET title='Anti-bullying medicine', description='Learn how to deal with bullying.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90162_100assemact5-7p88.gif' );
UPDATE assets SET title='Remembrance Day', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90169_100assemact7-11_mip.gif' );
UPDATE assets SET title='Boasting', description='Recognise that it is important to have an honest opinion of ourselves but not &&&&&to boast about things that are not true.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90169_100assemact7-11p103.gif' );
UPDATE assets SET title='Reduce SATs stress', description='Look at some stressreducing strategies for children during their SATs.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90169_100assemact7-11p151.gif' );
UPDATE assets SET title='Which way out?', description='Photocopiable sample activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90247_stories_sip63.gif' );
UPDATE assets SET title='What comes next?', description='Photocopiable sample activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90247_stories_sip9.gif' );
UPDATE assets SET title='Tell the story', description='Photocopiable sample activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90247_storiesact_mip.gif' );
UPDATE assets SET title='Under canvas', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91295_ne-creative_sip14.gif' );
UPDATE assets SET title='Scare those crows!', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91295_ne-creative_sip41.gif' );
UPDATE assets SET title='I\'m a little snail song', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91295_ne-creative_sip53.gif' );
UPDATE assets SET title='Minibeast maths', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91341_ne-themes_sip20.gif' );
UPDATE assets SET title='All of a twitter', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91341_ne-themes_sip34.gif' );
UPDATE assets SET title='Clothes for all weathers', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91341_ne-themes_sip37.gif' );
UPDATE assets SET title='Celebrate with style', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91341_ne-themes_sip53.gif' );
UPDATE assets SET title='Fishy friends', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91341_ne-themes_sip60.gif' );
UPDATE assets SET title='Odd one out', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91345_ne-photocop_sip.gif' );
UPDATE assets SET title='Colourful tents', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91345_ne-photocop_sip10.gif' );
UPDATE assets SET title='Best for baby', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91345_ne-photocop_sip16.gif' );
UPDATE assets SET title='Incy Wincy Spider', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91345_ne-photocop_sip26.gif' );
UPDATE assets SET title='Make a windmill', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91345_ne-photocop_sip52.gif' );
UPDATE assets SET title='New school - new friends', description='New school - new friends teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91551_nbicircle_sip-22.gif' );
UPDATE assets SET title='In common', description='Teachers\' notes looking at differences and similarities between people.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91551_nbicircle_sip-89.gif' );
UPDATE assets SET title='Choices', description='Teachers\' notes looking at choices people make' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91551_nbicircleles_mip.gif' );
UPDATE assets SET title='One, two, buckle my shoe', description='One, two, buckle my shoe photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94117_100m_harecact_mip.gif' );
UPDATE assets SET title='Recognising numerals', description='Recognising numerals teachers notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94117_100m_harecles_mip.gif' );
UPDATE assets SET title='Percy\'s hungry', description='Percy\'s hungry teachers notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94121_100m_ha2act_mip.gif' );
UPDATE assets SET title='Assess and review', description='Assess and review sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94121_mathwrkassy2_sip-125.gif' );
UPDATE assets SET title='NNS objectives', description='NNS objectives grid' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94121_mathwrkassy2_sip-34.gif' );
UPDATE assets SET title='Carpet fitter', description='Carpet fitter teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94125_100m_ha6act_mip.gif' );
UPDATE assets SET title='Frozen fingers', description='Frozen fingers teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94125_100mh_a6les_mip.gif' );
UPDATE assets SET title='Mental Math Starters', description='Number spotter, Outdoor Counting and Number Swap shop.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94813_50mathslal5-7_sip-17.gif' );
UPDATE assets SET title='Five little ducks, Grabbing ducks', description='Five little ducks, Grabbing ducks' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94813_50mathslal5-7_sip-18.gif' );
UPDATE assets SET title='Mrs Odd and Mr Even', description='Teachers notes looking at odd and even numbers.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94813_50mathslal5-7les_mip.gif' );
UPDATE assets SET title='Up and away', description='Teachers notes on counting on Takes and adders' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94814_50mathslal7-9les_mip.gif' );
UPDATE assets SET title='Takes and adders', description='Counting on and back' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94814_50mathslal7-9les_mip1.gif' );
UPDATE assets SET title='Make the most of your hands', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95398_youcan4-7_sip-10.gif' );
UPDATE assets SET title='Manage your stress levels', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95398_youcan4-7_sip-11.gif' );
UPDATE assets SET title='Develop better cooperation', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95398_youcan4-7_sip-20.gif' );
UPDATE assets SET title='Ten rules for a calm classroom', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95398_youcan4-7_sip-56.gif' );
UPDATE assets SET title='Manage your stress levels', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95429_youcan7-11_sip-11.gif' );
UPDATE assets SET title='Keep it calm in the corridors', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95429_youcan7-11_sip-32.gif' );
UPDATE assets SET title='Help your children to \'read\' people', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95429_youcan7-11_sip-42.gif' );
UPDATE assets SET title='\'Reading\' people activity', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95429_youcan7-11_sip-57.gif' );
UPDATE assets SET title='In like a lion out like a lamb', description='In like a lion out like a lamb activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95750_h2teach-art_sip72.gif' );
UPDATE assets SET title='In like a lion out like a lamb masks', description='In like a lion out like a lamb photocopiable.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95750_h2teach-art_sip73.gif' );
UPDATE assets SET title='The Harvest cornucopia', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95921_artseasonsact_sip12.gif' );
UPDATE assets SET title='Harvest corucopia platter template', description='Photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95921_artseasonsact_sip13.gif' );
UPDATE assets SET title='Cornucopia pull out', description='Photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95921_artseasonsact_sip14.gif' );
UPDATE assets SET title='Ben\'s Diary', description='Teachers\' notes looking at days of the week and do, when, school, help, by, just.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96241_bihigfreqwor_sip-14.gif' );
UPDATE assets SET title='At the seaside', description='At the seaside photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96241_bihigfreqwor_sip-80.gif' );
UPDATE assets SET title='Jack and the snowman', description='Jack and the snowman photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96241_bihigfreqworact_mip.gif' );
UPDATE assets SET title='I have been a busy bee', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96319_spnycognitive_sip-32.gif' );
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! ' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96319_spnycognitive_sip-55.gif' );
UPDATE assets SET title='Which way?', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96319_spnycognitive_sip-63.gif' );
UPDATE assets SET title='The Vikings are here!', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96319_spnycognitive_sip-90.gif' );
UPDATE assets SET title='Overcome apprehension', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96451_ycofsted_sip-13.gif' );
UPDATE assets SET title='Tackle Ofsted forms!', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96451_ycofsted_sip-17.gif' );
UPDATE assets SET title='Include the six AOL and the ELG', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96451_ycofsted_sip-36.gif' );
UPDATE assets SET title='Starter checklist', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96451_ycofsted_sip-55.gif' );
UPDATE assets SET title='Holiday Time ', description='Holiday Time music' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96774_fsrole_sip-38.gif' );
UPDATE assets SET title='Holiday Time ', description='Holiday Time rhyme' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96774_fsrole_sip-39.gif' );
UPDATE assets SET title='Holiday Time ', description='Holiday Time teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96774_fsrole_sip-40.gif' );
UPDATE assets SET title='Holiday Time ', description='Holiday Time photocopiable sheets' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96774_fsrole_sip-41.gif' );
UPDATE assets SET title='Celebrations', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97501_rrre1_sip-33.gif' );
UPDATE assets SET title='Celebrations 2', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97501_rrre1_sip-46.gif' );
UPDATE assets SET title='Celebration word cards', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97501_rrre1_sip-53.gif' );
UPDATE assets SET title='Design an Id-ul-Fitr card', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97501_rrre1_sip-56.gif' );
UPDATE assets SET title='Buddhism', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97534_rrre2_sip-69.gif' );
UPDATE assets SET title='Buddhism 2', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97534_rrre2_sip-72.gif' );
UPDATE assets SET title='Prince Siddhattha - the Buddha story', description='Prince Siddhattha  the Buddha' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97534_rrre2_sip-76.gif' );
UPDATE assets SET title='Prince Siddhattha and the Four Sights', description='Prince Siddhattha and the Four Sights' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97534_rrre2_sip-77.gif' );
UPDATE assets SET title='Number line activities', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97627_ycwhiteboard4-7_sip-22.gif' );
UPDATE assets SET title='Shared reading', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97627_ycwhiteboard4-7_sip-29.gif' );
UPDATE assets SET title='Demonstrate angles', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97628_ycwhiteboard7-11_sip-26.gif' );
UPDATE assets SET title='Investigate sound', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97628_ycwhiteboard7-11_sip-40.gif' );
UPDATE assets SET title='Title of lesson', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97628_ycwhiteboard7-11_sip-61.gif' );
UPDATE assets SET title='Show video resources', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97628_ycwhiteboard7-11_sip-9.gif' );
UPDATE assets SET title='Making it better', description='Making it better activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98376_eypcpcommact_mip.gif' );
UPDATE assets SET title='Ourselves ', description='Ourselves teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98376_eypcpcommles_mip-1.gif' );
UPDATE assets SET title='Toys and games', description='Toys and games teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98376_eypcpcommles_mip-2.gif' );
UPDATE assets SET title='Materials', description='Materials teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98378_eypcpscien_sip-28.gif' );
UPDATE assets SET title='Bubble play', description='Bubble play photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98378_eypcpscien_sip-39.gif' );
UPDATE assets SET title='Trees', description='Trees photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98378_eypcpscien_sip-49.gif' );
UPDATE assets SET title='The world around us', description='The world around us teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98378_eypcpscienles_mip.gif' );
UPDATE assets SET title='Spaceman Sid', description='Spaceman Sid teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99043_camaths5-7_sip-14.gif' );
UPDATE assets SET title='Spaceman Sid', description='Spaceman Sid teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99043_camaths5-7_sip-15.gif' );
UPDATE assets SET title='Mrs Muddle', description='Mrs Muddle teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99043_camaths5-7_sip-60.gif' );
UPDATE assets SET title='Mrs Muddle', description='Mrs Muddle teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99043_camaths5-7_sip-61.gif' );
UPDATE assets SET title='Spaceman Sid and Mrs Muddle ', description='Spaceman Sid and Mrs Muddle photocopiable activity sheets.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99043_camaths5-7act_mip.gif' );
UPDATE assets SET title='Appeal to a range of learning styles', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99154_ycthink4-7_sip-23.gif' );
UPDATE assets SET title='Think about time passing', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99154_ycthink4-7_sip-31.gif' );
UPDATE assets SET title='Questions and answer guidlines', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99154_ycthink4-7act_mip.gif' );
UPDATE assets SET title='Help your children to use memory strategies', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99155_ycthink7-11_sip-15.gif' );
UPDATE assets SET title='Explore actions and consequences', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99155_ycthink7-11_sip-38.gif' );
UPDATE assets SET title='Use language to inspire dance', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99155_ycthink7-11_sip-53.gif' );
UPDATE assets SET title='Chain of consequences', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99155_ycthink7-11_sip-58.gif' );
UPDATE assets SET title='Slice of pie', description='Slice of pie activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99256_NoFussMaths5-7_sip22.gif' );
UPDATE assets SET title='Telephones', description='Telephones photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99256_NoFussMaths5-7_sip23.gif' );
UPDATE assets SET title='Number chains', description='Number chains photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99256_NoFussMaths5-7_sip36.gif' );
UPDATE assets SET title='Shape sorting ', description='Shape sorting photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99256_NoFussMaths5-7_sip90.gif' );
UPDATE assets SET title='Main groups of living things', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99266_NoFussSci5-7_sip83.gif' );
UPDATE assets SET title='Close clues', description='Close clues photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99299_NoFussEng7-11act_mip.gif' );
UPDATE assets SET title='Questions and question marks', description='Teachers\' notes looking at questions and taking turns.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99440_50litmal5-7_sip-18.gif' );
UPDATE assets SET title='Verb tenses', description='Photocopiable activity sheets.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99440_50litmal5-7act_mip.gif' );
UPDATE assets SET title='Unconvensional vowels', description='Teachers notes exploring the occurrence of certain letter strings.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99441_50litmal7-9_sip-18.gif' );
UPDATE assets SET title='Colourful collective nouns', description='Photocopiable activity sheet.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99441_50litmal7-9act_mip.gif' );
UPDATE assets SET title='Variety of sentence structure', description='Teachers notes on sentence structure.' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99442_50litmal9-11_sip-20.gif' );
UPDATE assets SET title='Active or passive', description='Photocopiable activity sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99442_50litmal9-11act_mip.gif' );
UPDATE assets SET title='Jigsaw faces', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99447_teymyself_sip-19.gif' );
UPDATE assets SET title='Family treasure hunt', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99447_teymyself_sip-33.gif' );
UPDATE assets SET title='Planner', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99447_teymyself_sip-7.gif' );
UPDATE assets SET title='Shoe Prints', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99447_teymyself_sip-76.gif' );
UPDATE assets SET title='Animal sounds we can make', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99447_teymyself_sip-88.gif' );
UPDATE assets SET title='Matching bodies', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99447_teymyselfles_mip.gif' );
UPDATE assets SET title='In Mexico', description='In Mexico - teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99448_fsmulti_sip-12.gif' );
UPDATE assets SET title='In Mexico - Tortilla recipe', description='In Mexico - Tortilla recipe photocopiable sheet' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99448_fsmulti_sip-13.gif' );
UPDATE assets SET title='Finding all the possibilities', description='Finding all the possibilities example page' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99473_camaths7-11_sip-7.gif' );
UPDATE assets SET title='Mr Ram the mind reader', description='Mr Ram the mind reader teachers\' notes' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99473_camaths7-11les_mip.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100081_100wbrec_sip-103.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100081_100wbrec_sip-154.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100081_100wbrec_sip-174.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100081_100wbrec_sip-70.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100081_100wbrec_sip-95.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104536_wwp_sip-53.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104536_wwp_sip-6.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104536_wwp_sip-7.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104536_wwp_sip-9.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104538_pwb_sip-16.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104538_pwb_sip-17.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104538_pwb_sip-40.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104538_pwb_sip-41.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99433_50stnfy1_sip-107.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99433_50stnfy1_sip-130.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99433_50stnfy1_sip-16.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99433_50stnfy1_sip-43.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99434_50stnfy2_sip-112.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99434_50stnfy2_sip-127.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99434_50stnfy2_sip-70.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99434_50stnfy2_sip-77.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99437_50stnfy5_sip-141.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99437_50stnfy5_sip-157.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99437_50stnfy5_sip-16.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99437_50stnfy5_sip-25.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99437_50stnfy5_sip-33.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99438_50stnfy6_sip-10.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99438_50stnfy6_sip-136.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99438_50stnfy6_sip-51.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99438_50stnfy6_sip-99.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100109_100WB4_sip-105.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100109_100WB4_sip-156.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100109_100WB4_sip-174.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100109_100WB4_sip-21.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100109_100WB4_sip-92.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100110_100wb5_sip-148.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100110_100wb5_sip-150.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100110_100wb5_sip-163.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100110_100wb5_sip-82.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100111_100wb6_sip-135.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100111_100wb6_sip-136.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100111_100wb6_sip-172.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100111_100wb6_sip-25.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100111_100wb6_sip-68.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100112_100WB2_sip-139.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100112_100WB2_sip-164.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100112_100WB2_sip-41.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100112_100WB2_sip-71.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94814_50mathslal7-9les_sip-.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97627_ycwhiteboard4-7_sip-4.gif' );
UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97627_ycwhiteboard4-7_sip-6.gif' );