Scholastic UK Asset Database

search

UPDATE assets SET title='Picture Alphabet', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85179_snpydyslexiales_mip58.gif');
UPDATE assets SET title='I have been a busy bee', description=null, long_description=null, subscriber_only=false   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! ', long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96319_spnycognitive_sip-90.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100081_100wbrec_sip-95.gif');
UPDATE assets SET title='Science', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100109_100WB4_sip-105.gif');
UPDATE assets SET title='Rhythmic Patterns', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99438_50stnfy6_sip-99.gif');
UPDATE assets SET title='Fridge words', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17897_wg-poetry7-9_sip23.gif');
UPDATE assets SET title='Dinosaurs (2)', description='Dinosaurs (2) teachers notes.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81807_an100lity3act_mip.gif');
UPDATE assets SET title='Pick a poem', description='Pick a poem photocopiable activity sheet', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82032_nbispeakles_mip.gif');
UPDATE assets SET title='Close clues', description='Close clues photocopiable activity sheet', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99299_NoFussEng7-11act_mip.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83920_hselectract_mip.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83920_hselectract_sip8.gif');
UPDATE assets SET title='Lovely lenses', description='Lovely lenses photocopiable activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90135_hsmicro_sip-39.gif');
UPDATE assets SET title='The Christmas Story', description='The Christmas story photocopiable sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28322_ffxmaseaster_sip42.gif');
UPDATE assets SET title='Variety of sentence structure', description='Teachers notes on sentence structure.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99442_50litmal9-11act_mip.gif');
UPDATE assets SET title='Odd one out', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91345_ne-photocop_sip52.gif');
UPDATE assets SET title='Traffic jams', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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\'.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%27325_outplayact_mip1.gif');
UPDATE assets SET title='Happy Hanukkah', description='Hold your own celebration', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28739_hanukkahroshact_mip1.gif');
UPDATE assets SET title='Find the totals ', description='Find the totals differentiated sheets', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4533_Y1findtotals_mip.gif');
UPDATE assets SET title='Making it better', description='Making it better activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%98378_eypcpscienles_mip.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83921_hsforcesact_sip12.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83921_hsforcesact_sip32.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83921_hsforcesact_sip34.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83921_hsforcesact_sip48.gif');
UPDATE assets SET title='Recipe for a poem', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17896_wg-po5-7_sip4.gif');
UPDATE assets SET title='Spaceman Sid', description='Spaceman Sid teachers\' notes', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99043_camaths5-7act_mip.gif');
UPDATE assets SET title='Unconvensional vowels', description='Teachers notes exploring the occurrence of certain letter strings.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99441_50litmal7-9act_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.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%89906_100hist5to7act_mip.gif');
UPDATE assets SET title='Halloween', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102034_bifestivals_sip-13.gif');
UPDATE assets SET title='Advent', description=null, long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102034_bifestivals_sip-8.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81810_100lity6act_mip.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81810_100lity6les_mip-1.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81810_100lity6les_mip-2.gif');
UPDATE assets SET title='A good recount should have:', description='UNIT 5 Note-taking and recount photocopiable activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81809_100lity5les_mip.gif');
UPDATE assets SET title='Good luck', description='Mathematical development', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30744_ffchinesenyact_mip.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%84374_nbiwetplayles_mip.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%84374_nbiwetplayles_sip20.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%84374_nbiwetplayles_sip69.gif');
UPDATE assets SET title='Learning to talk', description='Photocopiable teachers\' notes.', long_description=null, subscriber_only=false   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 ', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81786_an100litrecles_mip.gif');
UPDATE assets SET title='Stage one activities: Listening', description='Stage one activities - Listening', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103281_phonics_sip-55.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip12.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip16.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip18.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip31.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83922_hsplantsact_sip33.gif');
UPDATE assets SET title='A guidebook about Ancient Greece', description='Teachers\' guide looking at assessment strategy.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%89931_100hist7to11act_mip.gif');
UPDATE assets SET title='In like a lion out like a lamb', description='In like a lion out like a lamb activity sheet', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95750_h2teach-art_sip73.gif');
UPDATE assets SET title='Buddhism', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97627_ycwhiteboard4-7_sip-29.gif');
UPDATE assets SET title='Questions and question marks', description='Teachers\' notes looking at questions and taking turns.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99440_50litmal5-7act_mip.gif');
UPDATE assets SET title='The Harvest cornucopia', description=null, long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95921_artseasonsact_sip14.gif');
UPDATE assets SET title='What happens next?', description='What happens next teachers\' notes', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81789_100LitHoursY2_sip61.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.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82029_bigram_sip80.gif');
UPDATE assets SET title='New school - new friends', description='New school - new friends teachers\' notes', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91551_nbicircleles_mip.gif');
UPDATE assets SET title='Chinese dragon mask template', description='Photocopiable activity sheet.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90162_100assemact5-7p88.gif');
UPDATE assets SET title='Under canvas', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91295_ne-creative_sip53.gif');
UPDATE assets SET title='Celebrations', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97501_rrre1_sip-56.gif');
UPDATE assets SET title='Mental Math Starters', description='Number spotter, Outdoor Counting and Number Swap shop.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94813_50mathslal5-7les_mip.gif');
UPDATE assets SET title='One, two, buckle my shoe', description='One, two, buckle my shoe photocopiable activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94117_100m_harecles_mip.gif');
UPDATE assets SET title='Castle scenes', description='Castle scenes photocopiable activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102204_eypcpd_mles_mip-21.gif');
UPDATE assets SET title='Ben\'s Diary', description='Teachers\' notes looking at days of the week and do, when, school, help, by, just.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96241_bihigfreqworact_mip.gif');
UPDATE assets SET title='Slice of pie', description='Slice of pie activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99256_NoFussMaths5-7_sip90.gif');
UPDATE assets SET title='Seaside resort word cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86366_rrgeog4act_mip.gif');
UPDATE assets SET title='Make the most of your hands', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95398_youcan4-7_sip-56.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip19.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip20.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip21.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip42.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip43.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip44.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30563_fsey-favthem_sip45.gif');
UPDATE assets SET title='Finding all the possibilities', description='Finding all the possibilities example page', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99473_camaths7-11les_mip.gif');
UPDATE assets SET title='Overcome apprehension', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96451_ycofsted_sip-55.gif');
UPDATE assets SET title='Carpet fitter', description='Carpet fitter teachers\' notes', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94125_100mh_a6les_mip.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.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82031_nbiphonicles_sip88.gif');
UPDATE assets SET title='The friendly scarecrow', description='The friendly scarecrow photocopiable activity sheets', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86250_ffharv_sip38.gif');
UPDATE assets SET title='Festival planner', description=null, long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86250_ffharvact_mip.gif');
UPDATE assets SET title='Percy\'s hungry', description='Percy\'s hungry teachers notes', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94121_mathwrkassy2_sip-34.gif');
UPDATE assets SET title='Building poems', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17898_wg-po9-11_sip17.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83862_50less9-11_sip118.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83862_50less9-11_sip23.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83862_50less9-11_sip24.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83862_50less9-11_sip36.gif');
UPDATE assets SET title='How does it feel?', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4232_behav_sip47.gif');
UPDATE assets SET title='Disaster story', description='Teachers\' notes on storytelling techniques and to understand the effects of severe weather conditions.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90158_nbidramales_mip-1.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83923_hsminibeastsact_sip22.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83923_hsminibeastsact_sip28.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83923_hsminibeastsact_sip35.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83923_hsminibeastsact_sip41.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83918_hsanimalact_sip16.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83918_hsanimalact_sip18.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83918_hsanimalact_sip40.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83918_hsanimalact_sip46.gif');
UPDATE assets SET title='Planning a news story', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%17903_wg-news9-11_sipp22.gif');
UPDATE assets SET title='Heavier and lighter', description='Heavier and lighter teachers\' notes', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4532_an100mathsrecact_p68.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83859_50litlal7-9act_mip.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83859_50litlal7-9les_mip.gif');
UPDATE assets SET title='I Hear Thunder', description='I Hear Thunder photocopiable activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30588_fsey-circle_sip45.gif');
UPDATE assets SET title='Main groups of living things', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99266_NoFussSci5-7_sip83.gif');
UPDATE assets SET title='Telephone: It\'s for you!', description='It\'s for you photocopiable activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102205_eypcpictles_mip-21.gif');
UPDATE assets SET title='Minibeast maths', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%91341_ne-themes_sip60.gif');
UPDATE assets SET title='Termly planning grid', description='Planning grid', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%4534_100mathsy2_sip-35.gif');
UPDATE assets SET title='Manage your stress levels', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%95429_youcan7-11_sip-57.gif');
UPDATE assets SET title='Allergy', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28626_a-zguide_sip10.gif');
UPDATE assets SET title='Attachment', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%28626_a-zguide_sip25.gif');
UPDATE assets SET title='Jigsaw faces', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99447_teymyself_sip-33.gif');
UPDATE assets SET title='Planner', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99447_teymyselfles_mip.gif');
UPDATE assets SET title='Up and away', description='Teachers notes on counting on Takes and adders', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%94814_50mathslal7-9les_mip1.gif');
UPDATE assets SET title='Weather warning cards', description=null, long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%82033_social-skills_sip64.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83726_cookfun_sip5.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83726_cookfunact_mip.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85801_hssoundact_sip12.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85801_hssoundact_sip17.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85801_hssoundact_sip29.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%85801_hssoundact_sip48.gif');
UPDATE assets SET title='The Hot Seat game', description=null, long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104173_qfy6comp_sip-77.gif');
UPDATE assets SET title='India word cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86363_rrgeog3act_mip.gif');
UPDATE assets SET title='Appeal to a range of learning styles', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99155_ycthink7-11_sip-58.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip12.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip18.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip27.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip39.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%83917_hshumanbodyact_sip47.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%86362_rrgeog2act_mip.gif');
UPDATE assets SET title='Dear diary', description='Dear diary photocopiable activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101219_rrsuitcase_sip-7.gif');
UPDATE assets SET title='Which way out?', description='Photocopiable sample activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90247_storiesact_mip.gif');
UPDATE assets SET title='In Mexico', description='In Mexico - teachers\' notes', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99448_fsmulti_sip-13.gif');
UPDATE assets SET title='Food mix and match', description='Photocopiable activity sheet.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81788_an100lity1act_p8.gif');
UPDATE assets SET title='Sun exclusive', description='Sun exclusive photocopiable activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90134_hsearth_sip-41.gif');
UPDATE assets SET title='How to catch a gingerbread man', description='How to catch a gingerbread man photocopiable activity sheet', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%81808_an100lity4les_mip-2.gif');
UPDATE assets SET title='Holiday Time ', description='Holiday Time music', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%96774_fsrole_sip-41.gif');
UPDATE assets SET title='Divas and light', description='Hold your own celebration', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30743_ff-divaliact_mip1.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30565_fsey-action_sip30.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30565_fsey-action_sip31.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30565_fsey-action_sip32.gif');
UPDATE assets SET title='Sample Page', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%30565_fsey-action_sip33.gif');
UPDATE assets SET title='Moon watching', desc