UPDATE assets SET title='Welsh Rarebit Recipe', description='A simple recipe for Welsh Rarebit' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971713' );
 UPDATE assets SET title='Introduction', description='Page 5 of Cookery Fun' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971713' );
 UPDATE assets SET title='Which way out?', description='Activity for the Early Learning Goal \'Move with confidence, imagination and in safety.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965071' );
 UPDATE assets SET title='What comes next?', description='Activities for the Early Learning Goal \'Retell narratives in the correct sequence, drawing on language patterns of stories\'.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965071' );
 UPDATE assets SET title='Tell the story', description='Photocopiable sample activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965071' );
 UPDATE assets SET title='How does it feel?', description='Activities for Early Learning Goal \'Recognise the changes that happen to their bodies when they are active.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971152' );
 UPDATE assets SET title='Memory game', description='Photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971152' );
 UPDATE assets SET title='Traffic jams', description='Activity for the Early Learning Goal \'Show awareness of space, of themselves and of others.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971152' );
 UPDATE assets SET title='The spider\'s web', description='Activity for Early Learning Goals \'Handle tools, objects, construction and malleable materials safely and with increasing control\'.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971152' );
 UPDATE assets SET title='Chinese dragon mask template', description='Photocopiable activity sheet.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965047' );
 UPDATE assets SET title='World Red Cross Day', description='Look at the work of charities.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965047' );
 UPDATE assets SET title='Anti-bullying medicine', description='Learn how to deal with bullying.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965047' );
 UPDATE assets SET title='Remembrance Day', description='Explain why we have Remembrance Day and encourage children to support the Poppy Appeal.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965055' );
 UPDATE assets SET title='Boasting', description='Recognise that it is important to have an honest opinion of ourselves but not &&&&&to boast about things that are not true.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965055' );
 UPDATE assets SET title='Reduce SATs stress', description='Look at some stressreducing strategies for children during their SATs.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965055' );
 UPDATE assets SET title='Sample Page', description='' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964997' );
 UPDATE assets SET title='Making a Great Fire of London frieze', description='Activities for making a frieze displaying work on the Great Fire of London.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964997' );
 UPDATE assets SET title='A picture of Brunel', description='Photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964997' );
 UPDATE assets SET title='A guidebook about Ancient Greece', description='Teachers\' guide looking at assessment strategy.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965004' );
 UPDATE assets SET title='Find out about Ancient Egypt from artefacts', description='Teachers\' notes looking at finding out about the events, people and changes studied from artefacts.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965004' );
 UPDATE assets SET title='Dress a rich or poor Tudor boy', description='Photocopiable activity sheet.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965004' );
 UPDATE assets SET title='Persuasive writing', description='Photocopiable ctivity sheet.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971772' );
 UPDATE assets SET title='Persuasive writing ', description='Teachers\' notes to go with the Persuasive writing activity sheet.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971772' );
 UPDATE assets SET title='Write-A-Rap Rap', description='Poem by Tony Mitten' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971799' );
 UPDATE assets SET title='Writing speech', description='Writing speech activity sheet.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971799' );
 UPDATE assets SET title='Sentences make sense', description='Teachers\' notes explore ambiguities that &&&&&arise from sentence contractions, for example, through signs and headlines.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971799' );
 UPDATE assets SET title='Complex sentences', description='Teachers notes on forming complex sentences.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971799' );
 UPDATE assets SET title='Questions and question marks', description='Teachers\' notes looking at questions and taking turns.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965616' );
 UPDATE assets SET title='Verb tenses', description='Photocopiable activity sheets.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965616' );
 UPDATE assets SET title='Unconvensional vowels', description='Teachers notes exploring the occurrence of certain letter strings.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965624' );
 UPDATE assets SET title='Colourful collective nouns', description='Photocopiable activity sheet.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965624' );
 UPDATE assets SET title='Variety of sentence structure', description='Teachers notes on sentence structure.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965632' );
 UPDATE assets SET title='Active or passive', description='Photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965632' );
 UPDATE assets SET title='Teachers\' notes', description='Number spotter, Outdoor Counting and Number Swap shop.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965195' );
 UPDATE assets SET title='Teachers\' notes', description='Five little ducks, Grabbing ducks' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965195' );
 UPDATE assets SET title='Mrs Odd and Mr Even', description='Teachers notes looking at odd and even numbers.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965195' );
 UPDATE assets SET title='Up and away', description='Teachers notes on counting on Takes and adders' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965209' );
 UPDATE assets SET title='Takes and adders', description='Counting on and back' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965209' );
 UPDATE assets SET title='Teachers\' notes', description='Money Puzzle, Number families' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965209' );
 UPDATE assets SET title='Teachers\' notes', description='Money puzzle, Number families' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965209' );
 UPDATE assets SET title='Learning to talk', description='Photocopiable teachers\' notes.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971640' );
 UPDATE assets SET title='\'My History\' recount', description='Teachers\' notes ' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971640' );
 UPDATE assets SET title='Food mix and match', description='Photocopiable activity sheet.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971659' );
 UPDATE assets SET title='Making a story tape', description='Teachers notes on making a story tape' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971659' );
 UPDATE assets SET title='Modelling writing ', description='Teachers notes on modelling writing.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971659' );
 UPDATE assets SET title='Non-fiction 1', description='Create a supermarket' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971659' );
 UPDATE assets SET title='NLS objectives', description='NLS grid' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971659' );
 UPDATE assets SET title='What happens next?', description='What happens next teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971667' );
 UPDATE assets SET title='A walk in the dark woods', description='A walk in the dark woods: part 1 photocopiable sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971667' );
 UPDATE assets SET title='Dinosaurs (2)', description='Dinosaurs (2) teachers notes.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971675' );
 UPDATE assets SET title='Bird watchers reports', description='Bird watchers reports teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971675' );
 UPDATE assets SET title='Birds', description='Birds photocopiable' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971675' );
 UPDATE assets SET title='How to catch a gingerbread man', description='How to catch a gingerbread man photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971683' );
 UPDATE assets SET title='Persuasive writing', description='Persuasive writing teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971683' );
 UPDATE assets SET title='How to help', description='How to help teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971683' );
 UPDATE assets SET title='A good recount should have:', description='UNIT 5 Note-taking and recount photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971691' );
 UPDATE assets SET title='Plot cards', description='Plot cards teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971691' );
 UPDATE assets SET title='Film review', description='Film review photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971705' );
 UPDATE assets SET title='Emails', description='writing emails teachers notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971705' );
 UPDATE assets SET title='Film review', description='Film review teachers notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971705' );
 UPDATE assets SET title='One, two, buckle my shoe', description='One, two, buckle my shoe photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965128' );
 UPDATE assets SET title='Recognising numerals', description='Recognising numerals teachers notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965128' );
 UPDATE assets SET title='Percy\'s hungry', description='Percy\'s hungry teachers notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965144' );
 UPDATE assets SET title='Assess and review', description='Assess and review sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965144' );
 UPDATE assets SET title='NNS objectives', description='NNS objectives grid' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965144' );
 UPDATE assets SET title='Carpet fitter', description='Carpet fitter teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965187' );
 UPDATE assets SET title='Heavier and lighter', description='Heavier and lighter teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439984661' );
 UPDATE assets SET title='Unit 10 ', description='Teachers\' notes grid' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439984661' );
 UPDATE assets SET title='Heavier and lighter', description='Heavier and lighter teachers notes ' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439984661' );
 UPDATE assets SET title='Find the totals ', description='Find the totals differentiated sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043998467X' );
 UPDATE assets SET title='Termly planning grid', description='Planning grid' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439984688' );
 UPDATE assets SET title='2D and 3D shapes', description='Planning grid' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439984688' );
 UPDATE assets SET title='Teachers\' notes', description='Unit 6 lesson 1 and lesson 2' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439984688' );
 UPDATE assets SET title='The Harvest cornucopia', description='The Harvest cornucopia teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996525X' );
 UPDATE assets SET title='Harvest corucopia platter template', description='Photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996525X' );
 UPDATE assets SET title='Cornucopia pull out', description='Photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996525X' );
 UPDATE assets SET title='In like a lion out like a lamb', description='In like a lion out like a lamb activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965241' );
 UPDATE assets SET title='In like a lion out like a lamb masks', description='In like a lion out like a lamb photocopiable.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965241' );
 UPDATE assets SET title='Spaceman Sid', description='Spaceman Sid teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996556X' );
 UPDATE assets SET title='Spaceman Sid', description='Spaceman Sid teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996556X' );
 UPDATE assets SET title='Mrs Muddle', description='Mrs Muddle teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996556X' );
 UPDATE assets SET title='Mrs Muddle teachers\' notes ', description='Mrs Muddle teachers\' notes ' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996556X' );
 UPDATE assets SET title='Spaceman Sid and Mrs Muddle ', description='Spaceman Sid and Mrs Muddle photocopiable activity sheets.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996556X' );
 UPDATE assets SET title='Finding all the possibilities', description='Finding all the possibilities example page' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965705' );
 UPDATE assets SET title='Mr Ram the mind reader', description='Mr Ram the mind reader teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965705' );
 UPDATE assets SET title='Making it better', description='Making it better activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965454' );
 UPDATE assets SET title='Ourselves ', description='Ourselves teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965454' );
 UPDATE assets SET title='Toys and games', description='Toys and games teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965454' );
 UPDATE assets SET title='Castle scenes', description='Castle scenes photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944880' );
 UPDATE assets SET title='Toys', description='Toys teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944880' );
 UPDATE assets SET title='Example from Toys chapter', description='Example from Toys chapter teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944880' );
 UPDATE assets SET title='It\'s for you', description='It\'s for you photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944899' );
 UPDATE assets SET title='How things work', description='How things work teachers notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944899' );
 UPDATE assets SET title='How things work', description='How things work teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944899' );
 UPDATE assets SET title='Materials', description='Materials teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965470' );
 UPDATE assets SET title='Bubble play', description='Bubble play photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965470' );
 UPDATE assets SET title='Trees', description='Trees photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965470' );
 UPDATE assets SET title='The world around us', description='The world around us teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965470' );
 UPDATE assets SET title='Good luck', description='Mathematical development' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971594' );
 UPDATE assets SET title='Beautiful boats', description='Creative development' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971594' );
 UPDATE assets SET title='Background information and planning', description='Background information and planning teachers notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971594' );
 UPDATE assets SET title='Festival planner', description='Festival planner sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971594' );
 UPDATE assets SET title='The Christmas Story', description='The Christmas story photocopiable sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043997139X' );
 UPDATE assets SET title='Cross-curricular ideas', description='Five little elves, Christmas twister' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043997139X' );
 UPDATE assets SET title='Role-play ideas', description='Santa\'s workshop - teachers notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043997139X' );
 UPDATE assets SET title='Cross-curricular ideas', description='New life and Smooth eggs and bumpy eggs activities' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043997139X' );
 UPDATE assets SET title='Hold your own celebration', description='Bun party teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043997139X' );
 UPDATE assets SET title='The Easter story', description='The Easter story photocopiable sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043997139X' );
 UPDATE assets SET title='Hold your own celebration', description='Divas and light' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971586' );
 UPDATE assets SET title='Divali - Happy New Year', description='Divali - Happy New Year photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971586' );
 UPDATE assets SET title='Hold your own celebration', description='Happy Hanukkah teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971535' );
 UPDATE assets SET title='Example pages', description='Hanukkah rhymes, party invitation plus photocopiable activity sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971535' );
 UPDATE assets SET title='The friendly scarecrow', description='The friendly scarecrow photocopiable activity sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964903' );
 UPDATE assets SET title='Festival planner', description='Festival planner for Festival Fun for the Early Years: Harvest' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964903' );
 UPDATE assets SET title='Harvest planner and rhymes', description='Festival planner, Harvest Rhymes and photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964903' );
 UPDATE assets SET title='Cross-curricular ideas', description='Moon watching teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964911' );
 UPDATE assets SET title='Rhymes', description='Rhymes photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964911' );
 UPDATE assets SET title='Display ideas', description='Eid Mubarak teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964911' );
 UPDATE assets SET title='Eid is here', description='Eid is here photocopiable sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964911' );
 UPDATE assets SET title='Let\'s move', description='The Grand Old Duke of York' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971748' );
 UPDATE assets SET title='The Grand Old Duke of York', description='The Grand Old Duke of York rhyme' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971748' );
 UPDATE assets SET title='The Grand Old Duke of York', description='The Grand Old Duke of York teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971748' );
 UPDATE assets SET title='The Grand Old Duke of York', description='The Grand Old Duke of York finger puppet template' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971748' );
 UPDATE assets SET title='Mary, Mary Quite Contrary', description='Mary, Mary Quite Contrary music' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971721' );
 UPDATE assets SET title='If Your Happy and You Know It', description='_If Your Happy and You Know It_ rhyme.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971721' );
 UPDATE assets SET title='If Your Happy and You Know It', description='If Your Happy and You Know It teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971721' );
 UPDATE assets SET title='If Your Happy and You Know It', description='If Your Happy and You Know It photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971721' );
 UPDATE assets SET title='Mary, Mary Quite Contrary', description='Mary, Mary Quite Contrary Rhyme photocopiable sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971721' );
 UPDATE assets SET title='Mary, Mary Quite Contrary', description='Mary, Mary Quite Contrary teachers\' notea' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971721' );
 UPDATE assets SET title='Mary, Mary Quite Contrary', description='Mary, Mary Quite Contrary photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971721' );
 UPDATE assets SET title='In Mexico', description='In Mexico - teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965365' );
 UPDATE assets SET title='In Mexico - Tortilla recipe', description='In Mexico - Tortilla recipe photocopiable sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965365' );
 UPDATE assets SET title='I Hear Thunder', description='I Hear Thunder music' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964938' );
 UPDATE assets SET title='I Hear Thunder', description='I Hear Thunder rhyme photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964938' );
 UPDATE assets SET title='I Hear Thunder', description='I Hear Thunder teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964938' );
 UPDATE assets SET title='I Hear Thunder', description='I Hear Thunder photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439964938' );
 UPDATE assets SET title='Holiday Time ', description='Holiday Time music' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965357' );
 UPDATE assets SET title='Holiday Time ', description='Holiday Time rhyme' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965357' );
 UPDATE assets SET title='Holiday Time ', description='Holiday Time teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965357' );
 UPDATE assets SET title='Holiday Time ', description='Holiday Time photocopiable sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965357' );
 UPDATE assets SET title='See like a rabbit', description='See like a rabbit photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971810' );
 UPDATE assets SET title='Evolution', description='Evolution photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971810' );
 UPDATE assets SET title='Extinct or endangered', description='Extinct or endangered photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971810' );
 UPDATE assets SET title='Bears beware quiz', description='Bears beware quiz activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971810' );
 UPDATE assets SET title='Sun exclusive', description='Sun exclusive photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965012' );
 UPDATE assets SET title='Crazy constellations', description='Crazy constellations photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965012' );
 UPDATE assets SET title='Greedy grasping gravity', description='Greedy grasping gravity photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965012' );
 UPDATE assets SET title='Solar system wordsearch', description='Solar system wordsearch photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965012' );
 UPDATE assets SET title='Safety first', description='Safety first photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971829' );
 UPDATE assets SET title='Teachers notes', description='Sample teachers notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971829' );
 UPDATE assets SET title='Newton\'s first law', description='Newton\'s first law photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971837' );
 UPDATE assets SET title='Air resistance', description='Air resistance photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971837' );
 UPDATE assets SET title='Juggling', description='Juggling photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971837' );
 UPDATE assets SET title='Wordsearch puzzle', description='Science wordsearch puzzle photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971837' );
 UPDATE assets SET title='Lovely lenses', description='Lovely lenses photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965020' );
 UPDATE assets SET title='Make your own microscope', description='Make your own microscope photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965020' );
 UPDATE assets SET title='House of horrors', description='House of horrors photocopiable activity sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965020' );
 UPDATE assets SET title='Pillow problems', description='Pillow problems photocopiable activity sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965020' );
 UPDATE assets SET title='Savage spiders ', description='Savage spiders photocopiable activity sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971853' );
 UPDATE assets SET title='Busy Bees', description='Busy Bees photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971853' );
 UPDATE assets SET title='Ugly bug parade', description='Ugly bug parade photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971853' );
 UPDATE assets SET title='Maria Merien’s world of brilliant bugs', description='Maria Merien’s world of brilliant bugs photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971853' );
 UPDATE assets SET title='Poisonous plants!', description='Poisonous plants! photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971845' );
 UPDATE assets SET title='Attack of the killer plants!', description='Attack of the killer plants! photocopiable activity sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971845' );
 UPDATE assets SET title='Fantastic foods', description='Fantastic foods photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971845' );
 UPDATE assets SET title='Brutal bug eaters', description='Brutal bug eaters photocopiable activity sheets' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971845' );
 UPDATE assets SET title='Powerful Plants', description='Powerful plants photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971845' );
 UPDATE assets SET title='Sounding it out', description='Sounding it out photcopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971918' );
 UPDATE assets SET title='Blimey, it’s Beethoven!', description='Blimey, it’s Beethoven! photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971918' );
 UPDATE assets SET title='Shattering sounds', description='Shattering sounds photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971918' );
 UPDATE assets SET title='Could you be a sound scientist?', description='Could you be a sound scientist? photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971918' );
 UPDATE assets SET title='Body facts', description='Body facts photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971802' );
 UPDATE assets SET title='Get fit with Frankenstein', description='Get fit with Frankenstein photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971802' );
 UPDATE assets SET title='Alcohol', description='Alcohol photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971802' );
 UPDATE assets SET title='The heart', description='The heart photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971802' );
 UPDATE assets SET title='You food and where it goes', description='You food and where it goes photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971802' );
 UPDATE assets SET title='Lucky dip stories', description='Lucky dip stories teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971756' );
 UPDATE assets SET title='Next in line', description='Next in line teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971756' );
 UPDATE assets SET title='History detectives', description='History detectives teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971756' );
 UPDATE assets SET title='New school - new friends', description='New school - new friends teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996511X' );
 UPDATE assets SET title='In common', description='Teachers\' notes looking at differences and similarities between people.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996511X' );
 UPDATE assets SET title='Choices', description='Teachers\' notes looking at choices people make' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='043996511X' );
 UPDATE assets SET title='Frozen fingers', description='Frozen fingers teachers\' notes' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965187' );
 UPDATE assets SET title='Disaster story', description='Teachers\' notes on storytelling techniques and to understand the effects of severe weather conditions.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965039' );
 UPDATE assets SET title='Rumour chain', description='Teachers\' notes about learning the importance of storytelling in drama;
 to imagine what life was like in the court of Henry VIII.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965039' );
 UPDATE assets SET title='Halloween', description='To understand more about the customs and traditions of Halloween.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944872' );
 UPDATE assets SET title='Purim', description='Teachers\' notes on understanding more about Purim and the story behind the festival.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944872' );
 UPDATE assets SET title='Advent', description='Teachers;
 Notes on how to understand more about what Advent means to Christians and to make an Advent calendar.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944872' );
 UPDATE assets SET title='Palm Sunday', description='Teachers\' notes on learning more about Palm Sunday.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944872' );
 UPDATE assets SET title='Rosh Hashana', description='Teachers\' notes on understanding what the Jewish New Year means and how it is celebrated.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944872' );
 UPDATE assets SET title='Weather warning cards', description='Photocopiable Waether warning cards activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971330' );
 UPDATE assets SET title='Can I play?', description='Teachers\' notes on exploring considering other people’s feelings and to link action &&&&∧ consequences.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971330' );
 UPDATE assets SET title='Story song', description='Teachers\' notes on learning a song and substituting sounds for some of the &&&&&words.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971330' );
 UPDATE assets SET title='Problem puppets', description='Teachers\' notes on making finger puppets and using them in a role-play to encourage appropriate speaking and listening.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971330' );
 UPDATE assets SET title='Guess the sound', description='Guess the sound photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971330' );
 UPDATE assets SET title='What can you do?', description='Teachers\' notes on learning the function of verbs in sentences by collecting and classifying examples of verbs from own knowledge.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971357' );
 UPDATE assets SET title='All together now...', description='All together now... photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971357' );
 UPDATE assets SET title='The subject sack', description='Teachers\' notes on securing the use of simple sentences in their own writing and to write in full sentences.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971357' );
 UPDATE assets SET title='I say...', description='I say.... photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971357' );
 UPDATE assets SET title='Word detectives', description='Teachers\' notes looking at the use awareness of grammar to decipher new or unfamiliar words.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971357' );
 UPDATE assets SET title='Ben\'s diary', description='Teachers\' notes looking at days of the week and do, when, school, help, by, just.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965411' );
 UPDATE assets SET title='At the seaside', description='At the seaside photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965411' );
 UPDATE assets SET title='Jack and the snowman', description='Jack and the snowman photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965411' );
 UPDATE assets SET title='Match the middles', description='Teachers\' notes on distinguishing the correct medial sound in given words and matching these words to a second word with the same medial sound.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971322' );
 UPDATE assets SET title='Match the middles', description='Match the middles photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971322' );
 UPDATE assets SET title='Does your toe know?', description='Teachers\' notes on identifying the correct spelling pattern for the oa sound in a range of words.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971322' );
 UPDATE assets SET title='Drop it', description='Teachers\' notes on practising rules for adding suffixes to common words.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971322' );
 UPDATE assets SET title='Syllable scramble', description='Teachers\' notes on building common words in a given category from syllables.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971322' );
 UPDATE assets SET title='Pick a poem', description='Pick a poem photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971314' );
 UPDATE assets SET title='Pick a poem', description='Teachers\' notes on read or recite with expression, using different voices, including ‘narration’ voice and facial &&&&&expression as and when appropriate.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971314' );
 UPDATE assets SET title='Table buddies', description='Teachers\' notes to go with Misfits photocopiable sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971764' );
 UPDATE assets SET title='Loony limericks', description='Teachers\' notes that go with the Loony Limericks Photocopiable sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971764' );
 UPDATE assets SET title='Balloon bash tournament', description='Teachers\' notes to go with the Balloon bash tournament photocopiable sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971764' );
 UPDATE assets SET title='Dear diary', description='Dear diary photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965810' );
 UPDATE assets SET title='Places', description='Places photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965810' );
 UPDATE assets SET title='Talk about it', description='Talk about it sample page' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965810' );
 UPDATE assets SET title='Shared reading ', description='Shared reading activities' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965810' );
 UPDATE assets SET title='Close clues', description='Close clues photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965497' );
 UPDATE assets SET title='Slice of pie', description='Slice of pie activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965500' );
 UPDATE assets SET title='Telephones', description='Telephones photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965500' );
 UPDATE assets SET title='Number chains', description='Number chains photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965500' );
 UPDATE assets SET title='Shape sorting ', description='Shape sorting photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439965500' );
 UPDATE assets SET title='Stage one activities', description='Stage one activities - Listening' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944961' );
 UPDATE assets SET title='Sample minibook', description='Example pages from minibook' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944961' );
 UPDATE assets SET title='Rhyming pictures', description='Rhyming pictures photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944961' );
 UPDATE assets SET title='Phoneme cards', description='Phoneme cards actvity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944961' );
 UPDATE assets SET title='Consonants and short vowels', description='Consonants and short vowels teachers\' notes.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439944961' );
 UPDATE assets SET title='The Hot Seat game', description='The Hot Seat game activity' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439945135' );
 UPDATE assets SET title='Understanding Evaluation', description='Teachers\' notes on how to find the answer to an evaluation question and back it up with evidence in the text.' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439945135' );
 UPDATE assets SET title='The scarecrow', description='The scarecrow by Walter de la Mare activity' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439945135' );
 UPDATE assets SET title='Playing the game', description='Playing the game activity' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439945135' );
 UPDATE assets SET title='Word web', description='Word web activity' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439945135' );
 UPDATE assets SET title='Map of the British Isles', description='Map of the British Isles photocopiable activity sheet' WHERE id IN (SELECT ap.asset_id FROM assets_products ap LEFT JOIN products p ON ap.product_id = p.id WHERE p.isbn='0439971942' );