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', description='Cross-curricular ideas teachers\' notes', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   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', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90007_fframa-eid_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 '%83812_bi10mingamles_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 '%83812_bi10mingamles_sip26.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 '%83812_bi10mingamles_sip55.gif');
UPDATE assets SET title='Demonstrate angles', description=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   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=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%97628_ycwhiteboard7-11_sip-9.gif');
UPDATE assets SET title='Remembrance Day', description=null, long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   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.', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%90169_100assemact7-11p151.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 '%97627_ycwhiteboard4-7_sip-4.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 '%97627_ycwhiteboard4-7_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 '%94814_50mathslal7-9les_sip-.gif');
UPDATE assets SET title='Sleeping Beauty', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28A3iiback_pb-1.gif');
UPDATE assets SET title='Forming an opinion', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105163_jet0307a1_pb-4.gif');
UPDATE assets SET title='Seaside plant hunt', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100729_cet0206_extra_sip-2.gif');
UPDATE assets SET title='Arrow Maze and Number Maze solutions', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103656_pcp29-32_mip-1.gif');
UPDATE assets SET title='Relationship between the outer and inner circles ', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105164_Outerpcp_sip-1.gif');
UPDATE assets SET title='Mixing flesh tones', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_pb3.gif');
UPDATE assets SET title='The Great Wall', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102142_lt561145_sip-16.gif');
UPDATE assets SET title='Sharing a Shell song', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105175_ne0307a2ii_pb-5.gif');
UPDATE assets SET title='Castles are big', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104312_ne05a2i_pb-2.gif');
UPDATE assets SET title='Gloassary: Ancient Greece', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105162_jet0207ifc_sip-1.gif');
UPDATE assets SET title='Seaside history', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100729_a1_pb-5.gif');
UPDATE assets SET title='Artefact adverts 1', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103655_onlinehist_mip-1.gif');
UPDATE assets SET title='Natural and made objects', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101781_all-pages_sip1.gif');
UPDATE assets SET title='Meeting Lord Nelson', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101431_CE_0106_pcp_17.gif');
UPDATE assets SET title='Communication methods', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jetA1b_pb-8.gif');
UPDATE assets SET title='Around our school', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105882_ce0906A2i_pb-1.gif');
UPDATE assets SET title='School compost survey', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102470_jetA1b_pb-2.gif');
UPDATE assets SET title='Story title', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT121127_sip-10.gif');
UPDATE assets SET title='Feature page plan', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_pb2.gif');
UPDATE assets SET title='Menu du Jour', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_a1post_pb.gif');
UPDATE assets SET title='Tell me why!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105132_ce0207p36_sip-1.gif');
UPDATE assets SET title='Invisible ink', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105151_je0307_pb-3.gif');
UPDATE assets SET title='Wales National Curriculum Problem solving', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104715_jet0806clinkswal_mip.gif');
UPDATE assets SET title='Peepo!', description='
Peepo poster to use on your whiteboard
', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103268_ce0406a2iipeepo_pf.gif');
UPDATE assets SET title='John Sadler the valet', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102467_je0306a2ii_pb-5.gif');
UPDATE assets SET title='Reflection: Prefixes and Suffixes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_onlinepcps3.gif');
UPDATE assets SET title='Make a textile present', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105166_jet0607a1_pb-8.gif');
UPDATE assets SET title='Ants, ants, ants!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105132_ce0207a2i_pb-3.gif');
UPDATE assets SET title='Shakespeare', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102140_lt560743_sip-9.gif');
UPDATE assets SET title='Welsh National Curriculum Australia', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105165_clinkwal_mip-1.gif');
UPDATE assets SET title='The diary of a plant', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104162_ce0606A2i_pb-2.gif');
UPDATE assets SET title='Word games', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101024_LT120524_sip-15.gif');
UPDATE assets SET title='If I was a superhero...', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104140_ne0406a2i_pb-2.gif');
UPDATE assets SET title='Zorgon factsheet', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105131_ce0107a2i_pb-3.gif');
UPDATE assets SET title='Important Greek gods and goddesses', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105162_jet0207a1_pb-8.gif');
UPDATE assets SET title='Moving ant trail', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105132_ce0207a2i_pb-4.gif');
UPDATE assets SET title='A topsy-turvy tea party', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_ce0607a2i_pb-3.gif');
UPDATE assets SET title='Stop the rot!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105151_je0307_pb-4.gif');
UPDATE assets SET title='The National Curriuculum in Wales History (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clwales4.gif');
UPDATE assets SET title='Assessing writing', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102134_LT120725_sip-5.gif');
UPDATE assets SET title='Cook\'s tools', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105177_ne0507a2i_pb-4.gif');
UPDATE assets SET title='Scotland', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT121127Scot_sip-1.gif');
UPDATE assets SET title='Word trainer', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101026_lt34cov_sip-10.gif');
UPDATE assets SET title='Brick patterns', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cet0406extrapcps_mip.gif');
UPDATE assets SET title='Broken sentences', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102140_lt560743_sip-11.gif');
UPDATE assets SET title='Clown face', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105179_ne0707a2ii_pb-7.gif');
UPDATE assets SET title='Recipe for a happy healthy school', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105086_ce0806A2ii_pb-8.gif');
UPDATE assets SET title='The wibbly five-fingered wiggler', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100729_a3_pb-1.gif');
UPDATE assets SET title='Powerful synonyms', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_onlinepcps_mip1.gif');
UPDATE assets SET title='Friends are Special', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_mrmen03_sip.gif');
UPDATE assets SET title='Draft Framework', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102142_lt561145Eng_mip-11.gif');
UPDATE assets SET title='Which material am I?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103655_all-worksheets_sip-1.gif');
UPDATE assets SET title='Introducing the poster', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105133_ce0307a2ii_pb-5.gif');
UPDATE assets SET title='Time connectives', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101024_LT120524_sip-5.gif');
UPDATE assets SET title='What I know', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT121127_sip-13.gif');
UPDATE assets SET title='Northern Ireland', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_lt341150NI_mip-1.pdf');
UPDATE assets SET title='Make a match', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005_pb3.gif');
UPDATE assets SET title='Animal watch pictographs', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_ce0607a2ii_pb-7.gif');
UPDATE assets SET title='My furniture', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103268_extrap33-36_sip.gif');
UPDATE assets SET title='Animal cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_42-43extra_mip-1.gif');
UPDATE assets SET title='World rivers', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005_pb4.gif');
UPDATE assets SET title='Castles', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104312_ne05a2ii_pb-6.gif');
UPDATE assets SET title='Rome in a day', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_lt341150_sip-5.gif');
UPDATE assets SET title='Character cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_ce0507a2ii_pb-5.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_ce0206_a2ii_pb-6.gif');
UPDATE assets SET title='Different qualities', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105163_jet0307a1_pb-1.gif');
UPDATE assets SET title='At home (1)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cet0406a1_pb-1.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103653_je0506A2i_pb-3.gif');
UPDATE assets SET title='Character emotions', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101026_lt34cov_sip-8.gif');
UPDATE assets SET title='The National Curriuculum in Wales ICT', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_clwales.gif');
UPDATE assets SET title='Hospital workers', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105176_ne0407a2i_pb-4.gif');
UPDATE assets SET title='Communication', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104622_NE09A1_pb-8.gif');
UPDATE assets SET title='Fact or opinion?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102141_lt560944_sip-11.gif');
UPDATE assets SET title='Changing faces', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105179_ne0707a2i_pb-4.gif');
UPDATE assets SET title='Tudor Troupe board game', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103654_je0606TudorRules_sip.gif');
UPDATE assets SET title='My name is...', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105882_ce0906A2ii_pb-7.gif');
UPDATE assets SET title='The National Curriuculum in Wales ICT cont.', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_clwales3.gif');
UPDATE assets SET title='Cave of wonders', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105142_ce1206a2ii_pb-6.gif');
UPDATE assets SET title='Northern Ireland National Curriculum Problem solving ', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104715_jet0806clinksni_mip.gif');
UPDATE assets SET title='War and Peace', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105154_je0607a2ii_pb-7.gif');
UPDATE assets SET title='I spy tree leaves', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102468_je0406a2i_pb-1.gif');
UPDATE assets SET title='Poster Back - questions', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105131_ce0107a2ii_pb-6.gif');
UPDATE assets SET title='Around our school', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105882_ce-worksheets_mip.gif');
UPDATE assets SET title='Did you know...', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005_pb1.gif');
UPDATE assets SET title='Animal dominoes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105133_ce0307a2ii_pb-7.gif');
UPDATE assets SET title='Festival notes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104620_NE07A1_pb-7.gif');
UPDATE assets SET title='Flying dinosaur', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104313_ne0606a1_pb-6.gif');
UPDATE assets SET title='Go-Cart Challenge: Calculation cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105151_GoCartpcp_mip-1.gif');
UPDATE assets SET title='Hoppy and Poppy\'s great adventure - clues 3 & 4', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105134_ce0407a2ii_pb-6.gif');
UPDATE assets SET title='Changes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_ceta10606_pb-4.gif');
UPDATE assets SET title='Keep your head & Fast and slow', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105153_je0507_pb-1.gif');
UPDATE assets SET title='How to see a plant grow', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104162_ce0606A2i_pb-4.gif');
UPDATE assets SET title='National Curriculum for Wales - Life processes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105164_clinkwal_mip-1.gif');
UPDATE assets SET title='Download All', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_all pages_mip-1.pdf');
UPDATE assets SET title='Sound and hearing', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101481_ce0306a2iback_pb-3.gif');
UPDATE assets SET title='Number rhymes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT121127_sip-5.gif');
UPDATE assets SET title='Film synopsis', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103270_ce050638-40_mip.gif');
UPDATE assets SET title='Roman soldier', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_lt341150_sip-7.gif');
UPDATE assets SET title='Useful stitches', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105166_jet0607a3_pb-09.gif');
UPDATE assets SET title='Butterfly life cycle', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_cetibc0606_sip-1.gif');
UPDATE assets SET title='Sleep', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105904_eyab33a3i_pb-1.gif');
UPDATE assets SET title='Pretty pasta', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105177_ne0507a2ii_pb-8.gif');
UPDATE assets SET title='Pineapple and apple pizza', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105177_ne0507a2ii_pb-7.gif');
UPDATE assets SET title='English National Curriculum History', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_cleng1.gif');
UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105175_wheels-on-the-bus_int.exe');
UPDATE assets SET title='Come fly with me', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_ce0507a2i_pb-3.gif');
UPDATE assets SET title='Beside the seaside', description='Take a stroll along a Victorian pier using this month\'s mystery snapshots.', long_description='Take a stroll along a Victorian pier using this month\'s mystery snapshots.', subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106448_ex-july-littime_int.gif');
UPDATE assets SET title='Which material am I?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103655_je0706_sip-27.gif');
UPDATE assets SET title='Dinosaurs', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104313_ne0606a1_pb-1.gif');
UPDATE assets SET title='Character cards (2)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_jet0706a1_pb-4.gif');
UPDATE assets SET title='Chembakolli: A forest home', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103655_chembakolli_mip-36.gif');
UPDATE assets SET title='What did I do?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105153_je0507_pb-2.gif');
UPDATE assets SET title='Frankenstein\'s Monster', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_pb6.gif');
UPDATE assets SET title='The Sustainable School Game: How to play', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105150_je0207_pb-7.gif');
UPDATE assets SET title='Hand bones', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_a3pb2.gif');
UPDATE assets SET title='Menu du Jour', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_all-worksheets_mip.gif');
UPDATE assets SET title='Sounds Ahoy!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT121127_sip-7.gif');
UPDATE assets SET title='Northern Ireland Curriculum links Information Technology', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_clni1.gif');
UPDATE assets SET title='Food for thought', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jetibc_sip.gif');
UPDATE assets SET title='National Curriculum in Wales Introducing Islam', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_jet0506clinkswa_mip-1.gif');
UPDATE assets SET title='Locking mechanisms', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_pb8.gif');
UPDATE assets SET title='Mythical beasts', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102142_LT56-11_mip-1.gif');
UPDATE assets SET title='Doctor\'s instruments', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105176_ne0407a2i_pb-1.gif');
UPDATE assets SET title='Chinese sayings', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102142_lt561145_sip-14.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines Problem solving', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104715_jet0806clinksscot_mip.gif');
UPDATE assets SET title='What would you like?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103653_je0506pcp42-43_mip-1.gif');
UPDATE assets SET title='Autumn is here!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105902_eyab31a3ii_pb-8.gif');
UPDATE assets SET title='Butterfly book', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_ce0507a2i_pb-1.gif');
UPDATE assets SET title='Check it out!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101027_LT560542_sip-6.gif');
UPDATE assets SET title='Cow and Cheetah', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105086_ce0806A2i_pb-4.gif');
UPDATE assets SET title='Junior education back issues index (Sept 2005 - Feb 2006)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103656_pcpindex_mip-1.gif');
UPDATE assets SET title='10 golden rules for cooking', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105177_ne0507a2ii_pb-5.gif');
UPDATE assets SET title='Punch and Judy characters', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103270_all-worksheets_mip-1.gif');
UPDATE assets SET title='Picasso portraits', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_a3pb2.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103654_je0606A2i_pb-3.gif');
UPDATE assets SET title='Exploring reflective and rotational symmetry', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_jet0506a3pb-1.gif');
UPDATE assets SET title='Aboriginal art', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28p43_sip.gif');
UPDATE assets SET title='Superhero powers', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104140_ne-apr06-allpages_pb.gif');
UPDATE assets SET title='What time is it?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105175_ne0307a2ii_pb-7.gif');
UPDATE assets SET title='Pussy Cat\'s visit to London - Learning objectives', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_28-29extra_mip.gif');
UPDATE assets SET title='What\'s what?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005_pb2a.gif');
UPDATE assets SET title='Homes: English National Curriculum, QCA and Foundation Stage links', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cet0406cleng_mip.gif');
UPDATE assets SET title='Teachers\' notes: The Sustainable School Game ', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105150_je0207_pb-5.gif');
UPDATE assets SET title='Brown girl in the ring', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105903_eyab32a3i_pb-6.gif');
UPDATE assets SET title='Superheroland', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104140_ne0406a2ii_pb-5.gif');
UPDATE assets SET title='T-shirt design sheet', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105166_jet0607a1_pb-6.gif');
UPDATE assets SET title='Junior education Topics back issues index (Sept 2005 - Aug 2006)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104715_jet0806ifc_sip.gif');
UPDATE assets SET title='Butterfly days', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_cetifc0606_sip-1.gif');
UPDATE assets SET title='Risk assessment', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105173_all-wrkshts_pb.gif');
UPDATE assets SET title='Setting foot in Australia', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105165_jet0507a1_pb-7.gif');
UPDATE assets SET title='National Curriculum Wales Ancient Greece', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105162_clinkwal_sip-1.gif');
UPDATE assets SET title='Pop-up book', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_ce0206_a2i_pb-4.gif');
UPDATE assets SET title='English National Curriculum Geography cont.', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005cleng_sip-3.gif');
UPDATE assets SET title='Northern Ireland Curriculum links Information Technology cont.', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_clni2.gif');
UPDATE assets SET title='Cartoon', description='A cartoon strip showing a footballer taking a goal ', long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_pb8.gif');
UPDATE assets SET title='Picture of a parrot', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28a5a_sip.gif');
UPDATE assets SET title='Northern Ireland National Curriculum Ancient Greece', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105162_clinkni_sip-1.gif');
UPDATE assets SET title='Santa\'s on his sleigh', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105142_all-worksheets-mip.gif');
UPDATE assets SET title='English National Curriculum Materials', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_jet0706clinkseng_mip.gif');
UPDATE assets SET title='Sunglasses template', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104162_ce060628_sip.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101481_ce0306a2iback_pb-2.gif');
UPDATE assets SET title='Whole-class story book', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_ce0206_a2i_pb-1.gif');
UPDATE assets SET title='Creating characters', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102137_LT34_sip-15.gif');
UPDATE assets SET title='The National Curriculum in Wales Science', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_clwales1.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102467_je0306a2i_pb-3.gif');
UPDATE assets SET title='Australia timeline', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105165_jet0507ibc_sip-1.gif');
UPDATE assets SET title='Elly Nash', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101026_lt34cov_sip-16.gif');
UPDATE assets SET title='Around the world in eighty squares', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105144_AprA1posterfront_wbp.gif');
UPDATE assets SET title='Northern Ireland National Curriculum Materials', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_jet0706clinksni_mip-1.gif');
UPDATE assets SET title='Out and about in Paris', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103656_je0806a2i_pb-4.gif');
UPDATE assets SET title='English National Curriculum ICT cont.', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_cleng2.gif');
UPDATE assets SET title='Greek myths - The City of Athens', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105162_jet0207a1_pb-6.gif');
UPDATE assets SET title='Draft Literacy Framework', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT121127Eng_mip-1.gif');
UPDATE assets SET title='Georgie meets Lord Nelson (1)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101431_CE_0106_pcp_19.gif');
UPDATE assets SET title='Year Planner', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102134_LT120725_sip-16.gif');
UPDATE assets SET title='Tell me why!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_ce05_mip40.gif');
UPDATE assets SET title='Muslim communities around the world', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_all-worksheets_mip-1.gif');
UPDATE assets SET title='Year 3: Light and shadows/circuits and switches activity ideas', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102467_complete_mip-1.gif');
UPDATE assets SET title='Jumping mazes: Arrow Maze', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103656_je0806a2ii_pb-5.gif');
UPDATE assets SET title='The National Curriuculum in Wales Geography', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005clwales_sip-1.gif');
UPDATE assets SET title='Meeting the Head', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105882_ce0906A2i_pb-3.gif');
UPDATE assets SET title='Box and tag', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104313_ne0606a1_pb-8.gif');
UPDATE assets SET title='Family fun day', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101024_LT120524_sip-4.gif');
UPDATE assets SET title='Follow the clue (1)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104622_NE09A1_pb-6.gif');
UPDATE assets SET title='Story skeleton', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102140_lt560743_sip-13.gif');
UPDATE assets SET title='Mr Prendergast\'s suitcase', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_jetibc_sip.gif');
UPDATE assets SET title='Decorative stitches', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105166_jet0607a3_pb-10.gif');
UPDATE assets SET title='Homes: Scottish 5-14 National Guidelines', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_clscot_mip.gif');
UPDATE assets SET title='Self audit sheet 1', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105152_Perfman_mip-1.gif');
UPDATE assets SET title='Punctuation Race', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101024_LT120524_sip-8.gif');
UPDATE assets SET title='Nature\'s playground', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105173_ne0107a2i_pb-1.gif');
UPDATE assets SET title='Poster questions', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_a3pb1.gif');
UPDATE assets SET title='Northern Ireland Curriculum links Geography', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005clni_sip-1.gif');
UPDATE assets SET title='English National Curriculum Science (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_cleng2.gif');
UPDATE assets SET title='Fat balls recipe', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105904_eyab33a2_pb-2.gif');
UPDATE assets SET title='Shopping', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104621_ne-all-work_pb-1.gif');
UPDATE assets SET title='Jean-Baptiste Siméon Chardin - The Jar of Apricots', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103655_je0706A2i_pb-4.gif');
UPDATE assets SET title='Picture of a kitten', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28a5b_sip.gif');
UPDATE assets SET title='The National Curriuculum in Wales ICT ', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_clwales1.gif');
UPDATE assets SET title='Five fat sausages', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105175_ne0307a2i_pb-3.gif');
UPDATE assets SET title='Writing a letter', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103270_ce0506A2ii_pb-8.gif');
UPDATE assets SET title='Doing your bit', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102468_je0406a2i_pb-3.gif');
UPDATE assets SET title='Rockin\' around the Christmas tree', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105142_ce1206a2i_pb-4.gif');
UPDATE assets SET title='Archaelogical dig', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_pb4.gif');
UPDATE assets SET title='How polluted is the river?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005_pb6.gif');
UPDATE assets SET title='Happy shopper', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_jet0706a1_pb-2.gif');
UPDATE assets SET title='Treasure of Silver Wood & Boys around Town', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_jetA3b_pb-1.gif');
UPDATE assets SET title='Teachers\' notes: The Obstacle Race', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105152_je0407_pb-5.gif');
UPDATE assets SET title='Magical mosaics', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28p44_sip.gif');
UPDATE assets SET title='Shapes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105166_jet0607a1_pb-4.gif');
UPDATE assets SET title='The Obstacle Race: Scorecard', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105152_je0407_pb-8.gif');
UPDATE assets SET title='Northern Ireland Curriculum Links History', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clni.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines Materials', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_jet0706clinksscott_mip.gif');
UPDATE assets SET title='A visit to Brightwater Park', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104598_ce0706A2ii_pb-5.gif');
UPDATE assets SET title='The rascally little bird', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105904_all-worksheets_mip.gif');
UPDATE assets SET title='Will it float or will it sink?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105134_wrkshtpcp_sip-1.gif');
UPDATE assets SET title='The National Curriculum in Wales Tudors', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104713_jet0606clinkswal_mip.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines Tudors', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104713_jet0606clinksscot_mip.gif');
UPDATE assets SET title='Guess what it is!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cet0406a1_pb-8.gif');
UPDATE assets SET title='The Sustainable School Game: Fact sheet', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105150_gamespcp_mip.gif');
UPDATE assets SET title='What\'s in the first aid kit?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101481_ce0306a2iiback_pb-6.gif');
UPDATE assets SET title='Going shopping', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104621_NE08A1_pb-3.gif');
UPDATE assets SET title='Seaside history', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100729_a1_pb-3.gif');
UPDATE assets SET title='The water cycle - answers', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_jet0706onlinepcp_mip.gif');
UPDATE assets SET title='Our children: Education in Chembakolli', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103655_je0706A2ii_pb-7.gif');
UPDATE assets SET title='Kids\' Page plan', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_pb1.gif');
UPDATE assets SET title='Flicker book', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_ce0206_a2ii_pb-8.gif');
UPDATE assets SET title='English National Curriculum Drama', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_complete_mip.gif');
UPDATE assets SET title='Good sports!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101026_lt34cov_sip-6.gif');
UPDATE assets SET title='Finding all possibilities', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104715_all-worksheets_mip-1.gif');
UPDATE assets SET title='Scotland', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102142_lt561145Scot_sip-1.gif');
UPDATE assets SET title='Let\'s go travelling', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105175_ne0307a2ii_pb-8.gif');
UPDATE assets SET title='Teachers\' notes: The Standard of Ur', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105154_je0607a2ii_pb-5.gif');
UPDATE assets SET title='Picture a river', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005_pb1a.gif');
UPDATE assets SET title='Apple seasons', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_ceta10606_pb-6.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clscot2.gif');
UPDATE assets SET title='All change!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102141_lt560944_sip-6.gif');
UPDATE assets SET title='The Painting Lesson', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102137_LT34_sip-13.gif');
UPDATE assets SET title='Glossary: Portraits', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet11ifc_sip.gif');
UPDATE assets SET title='English National Curriculum Australia', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105165_clinkeng_mip-1.gif');
UPDATE assets SET title='Animal cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_ce0607a2ii_pb-5.gif');
UPDATE assets SET title='The National Curriculum in Wales History (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clwales2.gif');
UPDATE assets SET title='Henry VIII\'s six wives', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104713_jet0606a1_pb-1.gif');
UPDATE assets SET title='A day out in Paris: Teachers\' notes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103656_je0806a2i_pb-1.gif');
UPDATE assets SET title='Tom\'s surprise', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_jetA3b_pb-3.gif');
UPDATE assets SET title='The Guru and the rich man', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101431_ce0106a2iiback_pb8.gif');
UPDATE assets SET title='Who lives here?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cet0406ifc_sip.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines Australia', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105165_clinkscot_mip-1.gif');
UPDATE assets SET title='Northern Ireland', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102142_lt561145NI_mip-11.gif');
UPDATE assets SET title='Debate, decide, discuss', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105163_jet0307a1_pb-6.gif');
UPDATE assets SET title='Tudor hovel', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104713_jet0606a1_pb-4.gif');
UPDATE assets SET title='The Loch Ness Monster and Weather Stations', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102467_52-53extra_mip.pdf');
UPDATE assets SET title='Year Planner', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102140_lt560743_sip-16.gif');
UPDATE assets SET title='The Seaside: National Curriculum Wales', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100729_clwal_mip.gif');
UPDATE assets SET title='Ben\'s Boots', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101024_LT120524_sip-13.gif');
UPDATE assets SET title='Money', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103269_ne030A2i_pb-4.gif');
UPDATE assets SET title='Pussy Cat, Pussy Cat Story Page 2', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_28-29extra_mip-3.gif');
UPDATE assets SET title='Rich and poor', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_lt341150_sip-14.gif');
UPDATE assets SET title='Masai warriors', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104620_NE07A1_pb-2.gif');
UPDATE assets SET title='Peacock and Giraffe', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105086_all-worksheets_mip.gif');
UPDATE assets SET title='Glossary - Textiles', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105166_jet0607ifc_sip-1.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines Expressive Arts: Art and Design', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_clscot1.gif');
UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99721_vDigV1_int.exe');
UPDATE assets SET title='March of the candles', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105903_eyab32a2_pb-4.gif');
UPDATE assets SET title='Westville Town\'s community', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104715_jet0806a1_pb-5.gif');
UPDATE assets SET title='English National Curriculum Citizenship', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105163_clinkeng_mip-1.gif');
UPDATE assets SET title='My life', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104162_ce060625_sip.gif');
UPDATE assets SET title='British rivers', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005_pb7.gif');
UPDATE assets SET title='Numbers 6 and 7', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28A3iback_pb-1.gif');
UPDATE assets SET title='My first day', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102137_LT34_sip-12.gif');
UPDATE assets SET title='Near and far', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105141_ce1106a2i_pb-2.gif');
UPDATE assets SET title='The National Curriuculum in Wales Geography cont.', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005clwales_sip-3.gif');
UPDATE assets SET title='Verb tornado', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102137_LT34_sip-04.gif');
UPDATE assets SET title='Pussy Cat, Pussy Cat Story Page 4', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_28-29extra_mip-5.gif');
UPDATE assets SET title='Teachers\' notes: The Indus Valley Civilisation', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105153_je0507_pb-5.gif');
UPDATE assets SET title='Australia\'s stolen generations', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105165_jet0507a1_pb-5.gif');
UPDATE assets SET title='Natural or man-made?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104162_ce0606A2ii_pb-8.gif');
UPDATE assets SET title='Go-Cart Challenge: How to play', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105151_je0307_pb-7.gif');
UPDATE assets SET title='Sort and recycle', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101781_ned0206_a2ii_pb-5.gif');
UPDATE assets SET title='Glossary Islam', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_jet0506ifc_sip.gif');
UPDATE assets SET title='Arabic patterns', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105902_eyab31a2_pb-3.gif');
UPDATE assets SET title='Poets Laureate', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102141_lt560944_sip-16.gif');
UPDATE assets SET title='One-way mazes: Jammed Tractor Maze', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103656_je0806a2ii_pb-7.gif');
UPDATE assets SET title='Superhero dot-to-dot', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104140_ne0406a2ii_pb-8.gif');
UPDATE assets SET title='Northern Ireland Curriculum Links History (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clni2.gif');
UPDATE assets SET title='Go-Cart Challenge: Calculation cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105151_je0307Gamespcp_mip-1.gif');
UPDATE assets SET title='Hanukkah cookies', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101431_ce0106a2iiback_pb7.gif');
UPDATE assets SET title='Tell me why!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_ce05-1_mip40.gif');
UPDATE assets SET title='Tile patterns', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cet0406ibc_sip.gif');
UPDATE assets SET title='Download All', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102134_all pages_mip.pdf');
UPDATE assets SET title='Inside the post office', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103270_ce0506A2ii_pb-5.gif');
UPDATE assets SET title='Year 6: Life cycles activity ideas', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102468_je0406a2ii_pb-6.gif');
UPDATE assets SET title='My healthy living record', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105176_ne0407a2i_pb-3.gif');
UPDATE assets SET title='Animal homes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cet0406a3_pb.gif');
UPDATE assets SET title='Superhero to the rescue', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104140_ne0406a2ii_pb-7.gif');
UPDATE assets SET title='Interview with members of the Long Priory Theme Park Protest Group', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105163_jet0307a3_pb-10.gif');
UPDATE assets SET title='Drippy', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102135_LT120926_sip-10.gif');
UPDATE assets SET title='Growing: Scottish 5-14 National Guidelines', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_clinksscot_mip.gif');
UPDATE assets SET title='Fruit smoothie memory game', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105177_ne0507a2i_pb-3.gif');
UPDATE assets SET title='Sick Reindeers', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102135_LT120926_sip-13.gif');
UPDATE assets SET title='1998 NLS', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT121127_sip-1.gif');
UPDATE assets SET title='Quiz time', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_42-43extra_mip-3.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101431_ce0106a2iback_pb1.gif');
UPDATE assets SET title='Winter wonderland', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105142_ce1206a2i_pb-1.gif');
UPDATE assets SET title='Spend, save and give', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103269_ne030A2i_pb-1.gif');
UPDATE assets SET title='1998 NLS', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_lt341150_sip-1.gif');
UPDATE assets SET title='Butterfly hand puppet', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_xtrabutterf_mip.gif');
UPDATE assets SET title='My place setting', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_pb2.gif');
UPDATE assets SET title='From my mouth going south', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_onlinepcp2.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clscot1.gif');
UPDATE assets SET title='Susanne\'s letter', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104715_jet0806a1_pb-3.gif');
UPDATE assets SET title='Off to the hospital', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105176_ne0407a2ii_pb-7.gif');
UPDATE assets SET title='Jack and the Beanstalk', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_ceta10606_pb-1.gif');
UPDATE assets SET title='Picture of two rabbits', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28a5c_sip.gif');
UPDATE assets SET title='Natural and made objects', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101781_ned0206_a2i_pb-1.gif');
UPDATE assets SET title='Communication', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104622_ne-all-worksheets_pb.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102468_je0406a2ii_pb-7.gif');
UPDATE assets SET title='A child\'s vase', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105162_all-wrkshts_pb.gif');
UPDATE assets SET title='Creatures', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102138_LT340949_sip-16.gif');
UPDATE assets SET title='Treasure map!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105133_ce0307a2i_pb-4.gif');
UPDATE assets SET title='Activity sheet: Bridging the gap', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103653_je0506A2ii_pb-6.gif');
UPDATE assets SET title='On safari! Character cards 2', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105152_je0407_pb-2.gif');
UPDATE assets SET title='What shall we see in the woods today?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105173_ne0107a2ii_pb-7.gif');
UPDATE assets SET title='Sorting animals', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105164_jet0407a1_pb-5.gif');
UPDATE assets SET title='Food for thought', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104598_ce0706A2i_pb-3.gif');
UPDATE assets SET title='Animals in action', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105134_ce0407a2i_pb-4.gif');
UPDATE assets SET title='Jekyll and Hyde', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724-jet12-comp_mip-1.gif');
UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106436_ex-july-littime_int.exe');
UPDATE assets SET title='Download All', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102137_all pages_mip.pdf');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103268_ce0406a2i_pb-2.gif');
UPDATE assets SET title='Africa', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104620_NE07A1_pb-3.gif');
UPDATE assets SET title='My diary...', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jetA3b_pb-2.gif');
UPDATE assets SET title='New Year\'s Nengajo', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105904_eyab33a3i_pb-2.gif');
UPDATE assets SET title='Tell me why!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_all-worksheets_mip.gif');
UPDATE assets SET title='Teachers\' notes: Trojan War factfile', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105150_je0207_pb-4.gif');
UPDATE assets SET title='Top tower', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103656_je0806a2i_pb-3.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104162_ce0606A2ii_pb-6.gif');
UPDATE assets SET title='Year 6: Changing states activity ideas', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103654_je0606A2i_pb-2.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101481_ce0306a2iback_pb-1.gif');
UPDATE assets SET title='Teachers\' notes: The Indus Valley Civilisation', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105153_worksheets_mip.gif');
UPDATE assets SET title='Muslim flags', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_jet0506a1pb-3.gif');
UPDATE assets SET title='The Story of Hansel and Gretel (1)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105086_ce0806pcp29-32_mip-1.gif');
UPDATE assets SET title='Tudor ship', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104713_jet0606a1_pb-6.gif');
UPDATE assets SET title='Our proposal', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105163_jet0307a1_pb-7.gif');
UPDATE assets SET title='Polar bears', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101027_LT560542_sip-4.gif');
UPDATE assets SET title='English National Curriculum ICT', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_cleng.pdf');
UPDATE assets SET title='Message flags', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104622_NE09A1_pb-4.gif');
UPDATE assets SET title='How to build a spreadsheet', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_pb6.gif');
UPDATE assets SET title='Animal homes playing cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cet0406a1_pb-6.gif');
UPDATE assets SET title='Teachers\' notes: Talking points', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105164_jet0407a1_pb-8.gif');
UPDATE assets SET title='Talking about \'Ourselves\'', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101431_ce0106a2iback_pb3.gif');
UPDATE assets SET title='The National Curriculum in Wales Art', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_clwales1.gif');
UPDATE assets SET title='Village map', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_jetA1b_pb-7.gif');
UPDATE assets SET title='Life cycle jigsaw (2)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_ceta10606_pb-8.gif');
UPDATE assets SET title='Postcard and invitation', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104622_NE09A1_pb-5.gif');
UPDATE assets SET title='Diary of a settler', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104713_jet0606ibc_sip.gif');
UPDATE assets SET title='Where is it?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103268_ce0406a2ii_pb-8.gif');
UPDATE assets SET title='Make your own poppy', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105141_ce1106a2ii_pb-7.gif');
UPDATE assets SET title='Let\'s find out about HMS Victory', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101431_CE_0106_14.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103270_ce0506A2i_pb-1.gif');
UPDATE assets SET title='Blank Postcard Activity', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_28-29extra_mip-8.gif');
UPDATE assets SET title='A-Z', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102138_LT340949_sip-7.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines Environmental Studies cont.', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100032_jet1005clscot_sip-2.gif');
UPDATE assets SET title='Complete worksheets', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104713_all worksheets_mip-1.pdf');
UPDATE assets SET title='What\'s all the drama?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_jetifc_sip.gif');
UPDATE assets SET title='Wendell\'s Waste Watch record table', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102470_jetA1b_pb-7.gif');
UPDATE assets SET title='Growing tomatoes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105164_jet0407a3_pb-10.gif');
UPDATE assets SET title='English National Curriculum History', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104713_jet0606clinkseng_mip.gif');
UPDATE assets SET title='The National Curriculum in Wales Science (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_clwales3.gif');
UPDATE assets SET title='Northern Ireland National Curriculum Materials', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_jet0706clinksni_mip.pdf');
UPDATE assets SET title='In the spotlight', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103268_ce0406a2ii_pb-5.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines Islam', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_jet0506clinksscot_mip.gif');
UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=true   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106444_ex-july-littime_int.exe');
UPDATE assets SET title='Mapping stars', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_onlinepcp.gif');
UPDATE assets SET title='Years 3 and 4: Jar of Apricots still life', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103655_je0706A2i_pb-2.gif');
UPDATE assets SET title='English National Curriculum Art and Design', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_cleng1.gif');
UPDATE assets SET title='Beach creature hunt', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100729_cet0206pcp_sip-1.gif');
UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106436_ex-july-littime2_int.exe');
UPDATE assets SET title='Making fairy cakes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105177_ne0507a2i_pb-1.gif');
UPDATE assets SET title='The cat and the parrot cont.', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105903_eyab32a3ii_pb-8.gif');
UPDATE assets SET title='Star constellations', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_pb5.gif');
UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106436_jungle-story-kit_int.exe');
UPDATE assets SET title='Famous Greeks', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105162_jet0207a1_pb-2.gif');
UPDATE assets SET title='The Talbiyah prayer', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_jet0506a1pb-8.gif');
UPDATE assets SET title='Sorting animals template', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105164_jet0407a1_pb-6.gif');
UPDATE assets SET title='Elidor', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102141_lt560944_sip-9.gif');
UPDATE assets SET title='At the seaside', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105132_ce0207a2ii_pb-7.gif');
UPDATE assets SET title='RAF terms and slang', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105151_all-worksheets_mip.gif');
UPDATE assets SET title='Shopping', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104621_NE08A3_pb-10.gif');
UPDATE assets SET title='Family cars: past and present', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jetA1b_pb-6.gif');
UPDATE assets SET title='Proportions of the face', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_pb1.gif');
UPDATE assets SET title='The Wheels on the Bus', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105175_all-wrkshts_pb.gif');
UPDATE assets SET title='Medieval dance', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104312_ne05a2ii_pb-8.gif');
UPDATE assets SET title='Extract from official statements', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105163_jet0307a3_pb-9.gif');
UPDATE assets SET title='Food detective!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_ceta30606_pb-9.gif');
UPDATE assets SET title='Northern Ireland Curriculum Links History (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clni3.gif');
UPDATE assets SET title='Picture of two goldfish', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102001_eyab28a5h_sip.gif');
UPDATE assets SET title='Diary of a Guest Editor', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105142_ce1206p15_sip-1.gif');
UPDATE assets SET title='Rome Interactive', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102139_rome-in-a-day_int.exe');
UPDATE assets SET title='Friendly and Unfriendly Behaviour', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_mrmen02_sip.gif');
UPDATE assets SET title='Starship Cuiser crew badges', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105131_ce0107a2i_pb-2.gif');
UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=true   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%106444_oliver-twist_int.exe');
UPDATE assets SET title='Teachers\' notes: Go-Cart Challenge', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105151_je0307_pb-5.gif');
UPDATE assets SET title='Wish you were here', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105132_ce0207a2ii_pb-6.gif');
UPDATE assets SET title='Poster Back - questions', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105131_ce0107a2ii_pb-7.gif');
UPDATE assets SET title='Holidays', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102137_LT34_sip-06.gif');
UPDATE assets SET title='Bridge designs', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104715_jet0806a1_pb-7.gif');
UPDATE assets SET title='Sort and recycle', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101781_ned0206_a2ii_pb-7.gif');
UPDATE assets SET title='Tasty teabread', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105902_eyab31a2_pb-1.gif');
UPDATE assets SET title='Hoppy and Poppy\'s great adventure - clues 7 & 8', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105134_ce0407a2ii_pb-8.gif');
UPDATE assets SET title='Up in the clouds', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_jet0706a3_pb-9.gif');
UPDATE assets SET title='Superhero play', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104140_ne0406a2i_pb-3.gif');
UPDATE assets SET title='All-in-one cakes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104621_NE08A1_pb-5.gif');
UPDATE assets SET title='Silhouettes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_28-29extra_mip-7.gif');
UPDATE assets SET title='What does each part do?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104162_ce0606A2i_pb-3.gif');
UPDATE assets SET title='Who lives near an oak tree?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105164_jet0407a1_pb-1.gif');
UPDATE assets SET title='Performance Management ', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105153_PerfMan_mip-1.gif');
UPDATE assets SET title='Chaos in the kitchen', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105136_ce0607a2i_pb-1.gif');
UPDATE assets SET title='Synonym Skirmish', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102137_LT34_sip-10.gif');
UPDATE assets SET title='Philip Reeve', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101027_LT560542_sip-13.gif');
UPDATE assets SET title='Doctor Livesey\'s bag of cures', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105135_ce0507a2ii_pb-7.gif');
UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103654_tudorGame_int.gif');
UPDATE assets SET title='Country cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103654_je0606A2ii_pb-7.gif');
UPDATE assets SET title='Material fun', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101781_ned0206_a2i_pb-3.gif');
UPDATE assets SET title='Indus Valley Civilisation seals: The script - a puzzle', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105153_je0507_pb-7.gif');
UPDATE assets SET title='Writing a story', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103656_je0806pcp14_mip-1.gif');
UPDATE assets SET title='Fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103654_je0606A2i_pb-4.gif');
UPDATE assets SET title='Meal deal', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jetA1b_pb-4.gif');
UPDATE assets SET title='Festivals and celebrations', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101431_ce0106a2iiback_pb5.gif');
UPDATE assets SET title='Punch and Judy characters', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103270_ce050628-29extra_sip.gif');
UPDATE assets SET title='Year 5: Keeping healthy activity ideas', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103653_je0506A2i_pb-1.gif');
UPDATE assets SET title='Teachers\' notes: A web of stories', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105150_je0207_pb-2.gif');
UPDATE assets SET title='English National Curriculum History (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_cleng2.gif');
UPDATE assets SET title='Interactive Flash', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%99721_vDig_int.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_clscot4.gif');
UPDATE assets SET title='Frog life cycle', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100733_ceta10606_pb-3.gif');
UPDATE assets SET title='Powerful synonyms', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_onlinepcps1.gif');
UPDATE assets SET title='What\'s the decade?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jetA1b_pb-2.gif');
UPDATE assets SET title='Nature\'s patterns', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105141_ce1106a2i_pb-4.gif');
UPDATE assets SET title='Homes: English National Curriculum, QCA and Foundation Stage links', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cleng_mip.pdf');
UPDATE assets SET title='Medical record', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105176_ne0407a2ii_pb-8.gif');
UPDATE assets SET title='Constructing repeat patterns', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_jet0506a3pb-2.gif');
UPDATE assets SET title='Comparing climate zones', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105165_jet0507a1_pb-3.gif');
UPDATE assets SET title='Textile investigations', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105166_jet0607a1_pb-2.gif');
UPDATE assets SET title='The Wheels on the Bus', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105175_ne0307a2i_pb-1.gif');
UPDATE assets SET title='5-a-side', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104715_jet0806a3_pb-9.gif');
UPDATE assets SET title='Northern Ireland Curriculum Links Human Body (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_clni2.gif');
UPDATE assets SET title='Choosing materials', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_all-worksheets_mip-1.gif');
UPDATE assets SET title='The rascally little bird cont.', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105904_eyab33a3ii_pb-2.gif');
UPDATE assets SET title='Going undercover & Come out, timid alien', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105153_je0507_pb-3.gif');
UPDATE assets SET title='How to make mittens', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104714_jet0706a1_pb-7.gif');
UPDATE assets SET title='English National Curriculum History (continued)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100726_jet0206_cleng4.gif');
UPDATE assets SET title='Where\'s my baby? (sheet 1)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105133_all-worksheets_mip.gif');
UPDATE assets SET title='Under the sea', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100729_a1_pb-1.gif');
UPDATE assets SET title='Woodland homes', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105164_jet0407a1_pb-3.gif');
UPDATE assets SET title='Animal fact cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104620_NE07A1_pb-5.gif');
UPDATE assets SET title='Fate cards', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103654_je0606A2ii_pb-5.gif');
UPDATE assets SET title='Recipe for a Sunbeam School', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105086_ce0806A2ii_pb-7.gif');
UPDATE assets SET title='Treasure Hunt', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_LT121127_sip-16.gif');
UPDATE assets SET title='What rhymes with?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101024_LT120524_sip-16.gif');
UPDATE assets SET title='Sunbeam badges', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105086_ce0806A2ii_pb-6.gif');
UPDATE assets SET title='A mysterious beginning - Take me to your leader', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_jetA1b_pb-1.gif');
UPDATE assets SET title='Relationships in pictures', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100033_jet1105_pb6.gif');
UPDATE assets SET title='Abbreviate!', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102141_lt560944_sip-4.gif');
UPDATE assets SET title='The Big Five', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105152_je0407_pb-3.gif');
UPDATE assets SET title='Portrait of Henry VIII by Hans Holbein', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104713_jet0606a3_pb-1.gif');
UPDATE assets SET title='Weather tree', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104598_ce0706A2ii_pb-8.gif');
UPDATE assets SET title='Feature page template', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100724_jet1205_pb3.gif');
UPDATE assets SET title='Scottish 5-14 National Guidelines', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100725_jet0106_clscot.gif');
UPDATE assets SET title='Glossary: Improving the environment', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102470_jetifc_sip.gif');
UPDATE assets SET title='An Ancient Greek doll', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105162_jet0207a3_pb-9.gif');
UPDATE assets SET title='Word roots', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101026_lt34cov_sip-4.gif');
UPDATE assets SET title='Udala tree', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105902_eyab31a3i_pb-5.gif');
UPDATE assets SET title='What\'s in the supermarket?', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%104598_ce0706A2i_pb-1.gif');
UPDATE assets SET title='Navigate the nest', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105132_ce0207a2i_pb-2.gif');
UPDATE assets SET title='A nail-biting ending - What big teeth you\'ve got', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_jetA1b_pb-5.gif');
UPDATE assets SET title='Year 4: Light and shadows/circuits and switches activity ideas', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102467_je0306a2i_pb-2.gif');
UPDATE assets SET title='English National Curriculum Islam', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_jet0506clinkseng_mip.gif');
UPDATE assets SET title='Shape nets (2)', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100732_cet0406a1_pb-4.gif');
UPDATE assets SET title='Northern Ireland Curriculum links Drama', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_jet0306_clni.gif');
UPDATE assets SET title='Download All', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102136_all pages_mip.pdf');
UPDATE assets SET title='Story trail - answers', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105150_trojanpcp_sip-1.gif');
UPDATE assets SET title='Keep-fit fun for everyone', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105134_ce0407a2i_pb-1.gif');
UPDATE assets SET title='National Curriculum for Northern Ireland - Citizenship', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105163_clinkni_mip-1.gif');
UPDATE assets SET title='Athens and Sparta', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105162_jet0207a1_pb-1.gif');
UPDATE assets SET title='Snake and Zebra', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105086_ce0806A2i_pb-3.gif');
UPDATE assets SET title='Let\'s find out about HMS Victory', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101431_CE_0106_16.gif');
UPDATE assets SET title='The rascally little bird', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105904_eyab33a3ii_pb-1.gif');
UPDATE assets SET title='Muslim communities around the world', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%103743_jet0506a1pb-1.gif');
UPDATE assets SET title='Weather watch', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%105904_eyab33a2_pb-3.gif');
UPDATE assets SET title='Pussy Cat Learning Objectives', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%101480_28-29extra_mip-1.gif');
UPDATE assets SET title='English National Curriculum Drama', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%100727_jet0306_cleng.gif');
UPDATE assets SET title='Let\'s go on a journey', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102470_jetA3b_pb-1.gif');
UPDATE assets SET title='Lady Agatha the wife', description=null, long_description=null, subscriber_only=false   WHERE id IN (SELECT asset_id FROM asset_derivatives WHERE file_pointer like '%102467_je0306