DROP TABLE IF EXISTS APPPoints;

CREATE TABLE `APPPoints` (
  `RowID` int(11) NOT NULL AUTO_INCREMENT,
  `Strand` text NOT NULL,
  `Level` int(11) NOT NULL,
  `Descriptor` mediumtext NOT NULL,
  PRIMARY KEY (`RowID`)
) ENGINE=MyISAM AUTO_INCREMENT=161 DEFAULT CHARSET=latin1;

INSERT INTO APPPoints VALUES("1","AF1","4","Using scientific ideas when describing <U>simple</U> phenomena"),
("2","AF1","5","Use <U>abstract ideas/models</U> when describing processes or phenomena"),
("3","AF1","6","Use abstract ideas/models <U>or multiple factors</U> when describing processes or phenomena"),
("4","AF1","7","Make explicit <U>connections</U> between abstract ideas/models when explaining phenomena"),
("5","AF2","4","Describe some simple positive and negative consequences of scientific and technological developments"),
("6","AF2","4","Recognise applications of specific scientific ideas"),
("7","AF2","4","Identify aspects of science used within particular jobs or roles"),
("8","AF2","5","Describe different viewpoints a range of people may have about scientific or technological developments"),
("9","AF2","5","Indicate how scientific or technological developments may affect different groups of people in different ways"),
("10","AF2","5","Identify ethical or moral issues linked to scientific or technological developments"),
("11","AF2","5","Link applications of science or technology to their underpinning scientific ideas"),
("12","AF2","6","Describe how different decisions on the uses of scientific and technological developments may be made in different economic, social or cultural contexts"),
("13","AF2","6","Explain how societies are affected by particular scientific applications or ideas"),
("14","AF2","6","Describe how particular scientific or technological developments have provided evidence to help scientists pose and answer further questions"),
("15","AF2","6","Describe how aspects of science are applied in particular jobs or roles"),
("16","AF2","7","Suggest ways in which scientific and technological developments may be influenced"),
("17","AF2","7","Explain how scientific discoveries can change worldviews"),
("18","AF2","7","Suggest economic, ethical/moral, social or cultural arguments for and against scientific or technological developments"),
("19","AF2","7","Explain how creative thinking in science and technology generates ideas for future research and development"),
("20","AF3","4","Present simple data in more than one way, inc. tables and bar charts"),
("21","AF3","5","<U>Select</U> appropriate ways of presenting data <B>(independently)</B>"),
("22","AF3","6","Choose forms to present <U>qualitative</U> data appropriate to the data"),
("23","AF3","6","Choose forms to present <U>quantitative</U> data appropriate to the data"),
("24","AF3","7","Effectively represent abstract ideas using appropriate <U>symbols</U> in presenting explanations"),
("25","AF3","7","Effectively represent abstract ideas using appropriate <U>flow diagrams</U> in presenting explanations"),
("26","AF3","7","Effectively represent abstract ideas using appropriate <U>scatter graphs</U> in presenting explanations"),
("27","AF3","7","Effectively represent abstract ideas using appropriate <U>bar charts</U> in presenting explanations"),
("28","AF3","7","Effectively represent abstract ideas using appropriate <U>pie charts</U> in presenting explanations"),
("29","AF4a","4","Identify possible risks"),
("30","AF4a","5","Make, and act on, suggestions to control obvious risks"),
("31","AF4a","6","<U>Independently</U> recognise a range of familiar risks and take action to control them"),
("32","AF4a","7","Recognise the need for risk assessment and consult appropriate sources of information (e.g. HAZCARDS)"),
("33","AF4b","4","Make sets of observations or measurements, "),
("34","AF4b","5","Repeat sets of observations where <U>necessary</U>"),
("35","AF4b","6","Collect data using appropriate ranges, numbers and values for measurements"),
("36","AF4b","7","Explain how to take account of error in order to collect reliable data"),
("37","AF4c","4","Decide when it is appropriate to carry out <U>fair tests</U>"),
("38","AF4c","5","Recognise significant variables, selecting the most suitable to investigate"),
("39","AF4c","6","Identifying types of variables e.g.<B>independent</B> and <B>dependent</B> (& control, categoric, continuous)"),
("40","AF4c","7","Identify key variables in complex contexts, explaining why some cannot readily be controlled and planning appropriate approaches to investigations to account for this."),
("41","AF5a","4","Draw straight forward conclusions from data presented in various formats"),
("42","AF5a","5","Draw valid conclusions that use more than one piece of supporting evidence - line graphs"),
("43","AF5a","5","Draw valid conclusions that use more than one piece of supporting evidence - numerical data"),
("44","AF5a","6","Select and manipulate data and use them to contribute to conclusions"),
("45","AF5a","7","Identify <U>quantitative</U> relationships between variables, using them to inform conclusions and make further predictions
\n"),
("47","AF5b","5","Recognising inconsistencies in data."),
("48","AF5b","5","Provide straightforward explanations for differences in repeated observations."),
("49","AF5b","6","Make valid comments on quality of data - reliability"),
("50","AF5b","6","Make valid comments on quality of data - precision"),
("51","AF5b","6","Make valid comments on quality of data - validity"),
("52","AF5b","6","Make valid comments on quality of data - accuracy"),
("53","AF5b","7","Assess the strength of evidence, deciding whether it is sufficient to support conclusions"),
("54","AF5c","4","Suggest improvements to methods, giving reason"),
("55","AF5c","5","Evaluate effectiveness of methods, <U>making practical suggestions</U> for improvements."),
("56","AF5c","6","<U>Suggest reasons</U> for any limitations or inconsistencies in evidence collected."),
("57","AF5c","7","Explain ways of modifying working methods to <U>improve reliability</U>"),
("46","AF5b","4",""),
("157","AF4b","4","identifying the ranges and intervals used"),
("158","AF4a","3","Recognise obvious risks when prompted"),
("159","AF4d","3","Select equipment or information sources <U>from those provided</U> to address a question or idea under investigation"),
("160","AF4d","4","Select appropriate equipment or information sources to address a question or idea under investigation");



DROP TABLE IF EXISTS APPStrands;

CREATE TABLE `APPStrands` (
  `Code` text NOT NULL,
  `Title` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO APPStrands VALUES("AF1","Thinking scientifically"),
("AF2","Understanding the applications and implications of science"),
("AF3","Communicating and collaborating in science"),
("AF4a","Using investigative approaches - Risk Assesement"),
("AF4b","Using investigative approaches - Range & Reliability"),
("AF4c","Using investigative approaches - Variables"),
("AF5a","Working with evidence - Conclusions"),
("AF5b","Working with evidence - Evaluating (data/evidence)"),
("AF5c","Working with evidence - Evaluating (methods)"),
("AF4d","Using investigative approaches - Equipment");



DROP TABLE IF EXISTS BespokeTests;

CREATE TABLE `BespokeTests` (
  `RowID` int(11) NOT NULL AUTO_INCREMENT,
  `TestName` text COLLATE utf8_unicode_ci NOT NULL,
  `QuestionID` int(11) NOT NULL,
  `CorrectAnswer` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`RowID`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO BespokeTests VALUES("1","Yr7DecemberLandmark","5730","A"),
("2","Yr7DecemberLandmark","5731","C"),
("3","Yr7DecemberLandmark","5732","C"),
("4","Yr7DecemberLandmark","5741","B"),
("5","Yr7DecemberLandmark","5727","A"),
("6","Yr7DecemberLandmark","5728","C"),
("7","Yr7DecemberLandmark","5729","A"),
("8","Yr7DecemberLandmark","5742","C"),
("9","Yr7DecemberLandmark","312","C"),
("10","Yr7DecemberLandmark","5734","B"),
("11","Yr7DecemberLandmark","969","A"),
("12","Yr7DecemberLandmark","6","D"),
("13","Yr7DecemberLandmark","818","A"),
("14","Yr7DecemberLandmark","820","A"),
("15","Yr7DecemberLandmark","995","B"),
("16","Yr7DecemberLandmark","994","D"),
("17","Yr7DecemberLandmark","993","C"),
("18","Yr7DecemberLandmark","996","C"),
("19","Yr7DecemberLandmark","5","A"),
("20","Yr7DecemberLandmark","202","B"),
("21","Yr7DecemberLandmark","40","A"),
("22","Yr7DecemberLandmark","186","B"),
("23","Yr7DecemberLandmark","941","A"),
("24","Yr7DecemberLandmark","939","D"),
("25","Yr7DecemberLandmark","226","D"),
("26","Yr7DecemberLandmark","230","C"),
("27","Yr7DecemberLandmark","228","B"),
("28","Yr7DecemberLandmark","322","B"),
("29","Yr7DecemberLandmark","234","C"),
("30","Yr7DecemberLandmark","331","D"),
("31","Yr7DecemberLandmark","102","C"),
("32","Yr7DecemberLandmark","198","D"),
("33","Yr7DecemberLandmark","171","A"),
("34","Yr7DecemberLandmark","185","C"),
("35","Yr7DecemberLandmark","93","D"),
("36","Yr7DecemberLandmark","184","A"),
("37","Yr7DecemberLandmark","175","B"),
("38","Yr7DecemberLandmark","178","D"),
("39","Yr7DecemberLandmark","174","C"),
("40","Yr7DecemberLandmark","5737","B"),
("41","Yr7DecemberLandmark","905","D"),
("42","Yr7DecemberLandmark","906","A"),
("43","Yr7DecemberLandmark","907","B"),
("44","Yr7DecemberLandmark","908","D"),
("45","Yr7DecemberLandmark","5740","D");



DROP TABLE IF EXISTS BrainTraining;

CREATE TABLE `BrainTraining` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Title` tinytext NOT NULL,
  `Description` text,
  `PictureURL` tinytext NOT NULL,
  `URL` tinytext NOT NULL,
  `Type` tinytext NOT NULL,
  `Verified` tinyint(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

INSERT INTO BrainTraining VALUES("1","GridWorks","<P>Place the nine colored tokens on the 3x3 game grid in a pattern that matches the clues given in each GridWorks challenge.  
\n
\n<P>Use the easy level to learn the puzzle and the hard level to test your brain.
\n","http://www.puzzles.com/projects/GridWorks/LogicPuzzles031-032/GW_031-032_button75.gif","http://www.puzzles.com/projects/AllGridWorks.html","Logic","1"),
("2","Strimko","<P>Strimko is a logic grid & numbers puzzle. All challenges are solvable with a pure logic, and no special knowledge is required.
\n
\n<P>It is based on a well-known idea of Latin squares described by a famous Swiss mathematician and physicist Leonhard Euler (1707-1783) in the 18th century. In a Latin Square each row and each column contain only occurance of of a number.","http://www.strimko.com/play/images/strimko006_button110.gif","http://www.strimko.com/all.htm","Logic","1"),
("3","Set Daily Puzzle","<P>The object of the game is to identify six \'Sets\' of three cards from 12 cards laid out on the table.","http://www.MrCorfe.com/images/Set.gif","http://www.setgame.com/set/puzzle_frame.htm","Logic","1"),
("4","Brainteasers and Puzzles","A collection of mainly Science educational games.","http://www.mrcorfe.com/images/Brainteaser.jpg","http://puzzling.caret.cam.ac.uk/index.php?section=home&style=1","Collection","1"),
("9","","Submitted by: ","","http://www.gorillafund.org/gorilla_fun/gorilla_puzzles.php","","0"),
("13","","Submitted by: 250879JC","","http://www.brainmetrix.com/","","0"),
("10","","Submitted by: 270497RS","","http://www.hellam.net/maths2000/frogs.html","","0"),
("11","","Submitted by: 250597LP","","http://www.brainbashers.com/stereo.asp","","0"),
("12","","Submitted by: 250879JC","","http://www.brainmetrix.com/","","0"),
("14","","Submitted by: 280497NB","","www.agame.com","","0"),
("15","","Submitted by: 260397SN","","www.gamesforthebrain.com","","0"),
("17","","Submitted by: ","","http://www.microgames.info/game_info.php?products_id=205","","0"),
("18","","Submitted by: 181296EB","","http://www.sheppardsoftware.com/braingames/memory2/memory2.htm","","0"),
("19","","Submitted by: ","","www.surfnetkids/games/Science_Games/","","0"),
("34","","Submitted by: ","","http://www.fi.edu/fellows/payton/rocks/quiz/index.html","","0"),
("21","","Submitted by: 250297BM","","http://www.mygame.com/game/3dlogic","","0"),
("22","","Submitted by: 230197AR","","Dan Ball","","0"),
("23","","Submitted by: 220397SB","","http://www.wildgames.com/mlp/brainpower/index.htm?mc=gl55_puzzle&gclid=CJasyaDG_5cCFQocQgody2jiDA&_uid_=fc2b8f9c-7715-4690-9b8f-3f063edef560&_uda_=","","0"),
("24","","Submitted by: 250297BM","","http://www.optillusions.com/","","0"),
("25","","Submitted by: 250297BM","","http://www.nekogames.jp/mt/2007/09/2.html","","0"),
("26","","Submitted by: 250297BM","","http://www.guimp.com/pacman_flash.html","","0"),
("27","","Submitted by: 020497AG","","Games.co.uk Sudoku 2 ","","0"),
("28","","Submitted by: ","","http://www.miniclip.com/games/cube-buster/en/","","0"),
("29","","Submitted by: 081196CB","","http://www.brainbashers.com/gameloader/loader.asp?game=166&width=963&height=316","","0"),
("30","","Submitted by: ","","www.fitbrains.com/games/","","0"),
("35","","Submitted by: 230197AR","","http://www.bbc.co.uk/schools/ks3bitesize/game/elemental/index.shtml","","0"),
("32","","Submitted by: 290197CC","","http://www.oyunlar1.com/online.php?flash=5036","","0"),
("33","","Submitted by: ","","bmx games","","0"),
("36","","Submitted by: 301294RW","","http://www.edheads.org/","","0"),
("37","","Submitted by: ","","http://www.gamesforthebrain.com/game/rotate2/","","0"),
("38","","Submitted by: ","","http://www.gamesforthebrain.com/game/rotate2/","","0"),
("39","","Submitted by: ","","http://www.echalk.co.uk/amusements/OpticalIllusions/BreathingShape/BreathingShape.html","","0"),
("40","","Submitted by: 031194OW","","http://www.iqtest.com/","","0"),
("41","","Submitted by: ","","http://www.echalk.co.uk/amusements/OpticalIllusions/jumbledWords/jumbledWords.html","","0"),
("42","","Submitted by: 031194OW","","http://dan-ball.jp/en/javagame/dust/","","0"),
("43","","Submitted by: ","","http://www.echalk.co.uk/amusements/OpticalIllusions/ColourText/colourText.html","","0"),
("44","","Submitted by: ","","http://www.echalk.co.uk/amusements/OpticalIllusions/pinwheel/pinwheel.html","","0"),
("45","","Submitted by: ","","http://www.echalk.co.uk/amusements/OpticalIllusions/pinwheel/pinwheel.html","","0"),
("46","","Submitted by: ","","http://www.echalk.co.uk/amusements/OpticalIllusions/motionBlindness/motionBlindness.html","","0"),
("47","","Submitted by: ","","http://www.echalk.co.uk/amusements/OpticalIllusions/motionBlindness/motionBlindness.html","","0"),
("48","","Submitted by: ","","http://www.echalk.co.uk/amusements/OpticalIllusions/motionBlindness/motionBlindness.html","","0"),
("49","","Submitted by: ","","http://www.echalk.co.uk/amusements/OpticalIllusions/motionBlindness/motionBlindness.html","","0"),
("50","","Submitted by: ","","roller coaster game","","0"),
("51","","Submitted by: 111294NB","","http://firecade.com/games/2953/worlds-hardest-game-2.html","","0"),
("52","","Submitted by: ","","ranger dan","","0"),
("53","","Submitted by: ","","Range Dan","","0"),
("54","","Submitted by: ","","ranger dan","","0");



DROP TABLE IF EXISTS ClassLists;

CREATE TABLE `ClassLists` (
  `RowID` int(11) NOT NULL AUTO_INCREMENT,
  `Class` text NOT NULL,
  `UPN` text NOT NULL,
  `AdminNumber` int(5) NOT NULL,
  `MTG` text NOT NULL,
  `Seat` int(11) NOT NULL,
  PRIMARY KEY (`RowID`)
) ENGINE=MyISAM AUTO_INCREMENT=1260 DEFAULT CHARSET=latin1;

INSERT INTO ClassLists VALUES("2","10BX4/Sc","P850201803035","13325","","0"),
("3","10BX4/Sc","R850339503009","13326","","0"),
("4","10BX4/Sc","A852241903011","13336","","0"),
("5","10BX4/Sc","T850201803037","13343","","0"),
("6","10BX4/Sc","D850207103028","13375","","0"),
("7","10BX4/Sc","F850207103039","13394","","0"),
("8","10BX4/Sc","G850201803009","13399","","0"),
("9","10BX4/Sc","P852275402034","13411","","0"),
("10","10BX4/Sc","W850207102090","13417","","0"),
("11","10BX4/Sc","U850207103049","13421","","0"),
("12","10BX4/Sc","N850201803073","13446","","0"),
("13","10BX4/Sc","Q850201803055","13447","","0"),
("14","10BX4/Sc","R850201803017","13459","","0"),
("15","10BX4/Sc","E850207103077","13487","","0"),
("16","10BX4/Sc","J850201803022","13501","","0"),
("17","10BX4/Sc","Q850206303068","13539","","0"),
("18","10BX4/Sc","B850304003010","13542","","0"),
("19","10BX4/Sc","E850201803027","13565","","0"),
("20","10BX4/Sc","H868220203017","13572","","0"),
("21","10BY1/Sc","U850201803030","13313","","0"),
("22","10BY1/Sc","L850201803033","13319","","0"),
("23","10BY1/Sc","G850201803038","13344","","0"),
("24","10BY1/Sc","T850339503002","13348","","0"),
("25","10BY1/Sc","Z850201803043","13369","","0"),
("26","10BY1/Sc","N850201803044","13372","","0"),
("27","10BY1/Sc","C850207103037","13391","","0"),
("28","10BY1/Sc","X850304003015","13393","","0"),
("29","10BY1/Sc","V850339502012","13424","","0"),
("30","10BY1/Sc","N850339503007","13454","","0"),
("31","10BY1/Sc","J850207103072","13474","","0"),
("32","10BY1/Sc","H850201803060","13476","","0"),
("33","10BY1/Sc","W850202303009","13493","","0"),
("34","10BY1/Sc","M850304003007","13498","","0"),
("35","10BY1/Sc","L850207103083","13505","","0"),
("36","10BY1/Sc","Y850775101045","13519","","0"),
("37","10BY1/Sc","Q850366303054","13522","","0"),
("38","10BY1/Sc","K850207103092","13530","","0"),
("39","10BY1/Sc","J850201803078","13547","","0"),
("40","10X1/Sc","P802233203006","13327","","0"),
("41","10X1/Sc","U850416110003","13335","","0"),
("42","10X1/Sc","X850201803003","13347","","0"),
("43","10X1/Sc","Q850207103018","13352","","0"),
("44","10X1/Sc","P850207103027","13371","","0"),
("45","10X1/Sc","W850207103033","13386","","0"),
("46","10X1/Sc","V850201803048","13407","","0"),
("47","10X1/Sc","A850318403048","13415","","0"),
("48","10X1/Sc","P850276303014","13416","","0"),
("49","10X1/Sc","P850207103056","13435","","0"),
("50","10X1/Sc","K850207103063","13455","","0"),
("51","10X1/Sc","R852246103056","13467","","0"),
("52","10X1/Sc","V850207103069","13470","","0"),
("53","10X1/Sc","Z850318403030","13478","","0"),
("54","10X1/Sc","M850207103074","13479","","0"),
("55","10X1/Sc","L850201803062","13486","","0"),
("56","10X1/Sc","D850201803065","13496","","0"),
("57","10X1/Sc","F850201803076","13535","","0"),
("58","10X1/Sc","V850201803077","13537","","0"),
("59","10X1/Sc","Q921201603033","13540","","0"),
("60","10X1/Sc","H850207103104","13555","","0"),
("61","10X1/Sc","Q850416112003","14136","","0"),
("62","10X1/Sc","U850201803028","13571","","0"),
("63","10X1/Sc","Z850207103116","13577","","0"),
("64","10X1/Sc","N850207103117","13578","","0"),
("65","10X1/Sc","R835224103106","13588","","0"),
("66","10X2/Sc","C850304003001","13312","","0"),
("67","10X2/Sc","M850207103016","13350","","0"),
("68","10X2/Sc","L850207103025","13364","","0"),
("69","10X2/Sc","T850207103029","13378","","0"),
("70","10X2/Sc","T850207103031","13381","","0"),
("71","10X2/Sc","T850201803008","13382","","0"),
("72","10X2/Sc","N850261303008","13401","","0"),
("73","10X2/Sc","V850207103042","13402","","0"),
("74","10X2/Sc","Y850201803052","13418","","0"),
("75","10X2/Sc","E850207103050","13422","","0"),
("76","10X2/Sc","R852245503016","13428","","0"),
("77","10X2/Sc","T850207103058","14156","","0"),
("78","10X2/Sc","Q850222405058","13450","","0"),
("79","10X2/Sc","C850201803016","13456","","0"),
("80","10X2/Sc","E873209102068","13466","","0"),
("81","10X2/Sc","Q850207103076","13485","","0"),
("82","10X2/Sc","K850201803013","13490","","0"),
("83","10X2/Sc","W850201803041","13491","","0"),
("84","10X2/Sc","U850237303059","13533","","0"),
("85","10X2/Sc","F850207103097","13545","","0"),
("86","10X2/Sc","J850201803080","13551","","0"),
("87","10X2/Sc","Q850201803026","13562","","0"),
("88","10X3/Sc","U850206203060","13320","","0"),
("89","10X3/Sc","E850304003012","13324","","0"),
("90","10X3/Sc","C852244103020","13362","","0"),
("91","10X3/Sc","L850206203063","13365","","0"),
("92","10X3/Sc","N850301403010","13368","","0"),
("93","10X3/Sc","Z850339503006","13389","","0"),
("94","10X3/Sc","P850206303021","13601","","0"),
("95","10X3/Sc","D850206203037","13425","","0"),
("96","10X3/Sc","B852241503037","13442","","0"),
("97","10X3/Sc","D850206207043","13448","","0"),
("98","10X3/Sc","G850207103061","13451","","0"),
("99","10X3/Sc","E850201803056","13452","","0"),
("100","10X3/Sc","Y850304003006","13477","","0"),
("101","10X3/Sc","B850207103075","13484","","0"),
("102","10X3/Sc","D850207103086","13511","","0"),
("103","10X3/Sc","X850416110005","13518","","0"),
("104","10X3/Sc","G850207103090","13526","","0"),
("105","10X3/Sc","P312205502033","13531","","0"),
("106","10X3/Sc","F852241903082","13543","","0"),
("107","10X3/Sc","R850207103096","13544","","0"),
("108","10X3/Sc","X850207103105","13558","","0"),
("109","10X3/Sc","A850207103107","13559","","0"),
("110","10X3/Sc","T850207103112","13566","","0"),
("111","10X3/Sc","E850207103102","13553","","0"),
("112","10X5/Sc","U357206902015","13342","","0"),
("113","10X5/Sc","P852246103016","13345","","0"),
("114","10X5/Sc","H850304003014","13351","","0"),
("115","10X5/Sc","F850304003003","13358","","0"),
("116","10X5/Sc","L850304003016","13396","","0"),
("117","10X5/Sc","L850238703003","13403","","0"),
("118","10X5/Sc","B850207103046","13412","","0"),
("119","10X5/Sc","Q850207103047","13413","","0"),
("120","10X5/Sc","L850207103054","13431","","0"),
("121","10X5/Sc","M850201803053","13436","","0"),
("122","10X5/Sc","Y852243603026","13437","","0"),
("123","10X5/Sc","J850304003005","13439","","0"),
("124","10X5/Sc","X306200203002","13894","","0"),
("125","10X5/Sc","U850201803057","13457","","0"),
("126","10X5/Sc","X850201803059","13461","","0"),
("127","10X5/Sc","U919341903005","13867","","0"),
("128","10X5/Sc","F850201803018","13473","","0"),
("129","10X5/Sc","X850201803061","13483","","0"),
("130","10X5/Sc","U850207103080","13499","","0"),
("131","10X5/Sc","X850207103082","13502","","0"),
("132","10X5/Sc","G850207103088","13520","","0"),
("133","10X5/Sc","W850207103089","13521","","0"),
("134","10X5/Sc","W850207103091","13527","","0"),
("135","10X5/Sc","B850201803025","13534","","0"),
("136","10X5/Sc","V850226307001","13541","","0"),
("137","10X5/Sc","Y850201803081","13556","","0"),
("138","10X5/Sc","C850207103118","13580","","0"),
("139","10X5/Sc","H315350602058","13603","","0"),
("140","10X5/Sc","U850207103103","13554","","0"),
("141","10X6/Sc","C850339503010","13329","","0"),
("142","10X6/Sc","C850207103008","13334","","0"),
("143","10X6/Sc","E850207103019","13354","","0"),
("144","10X6/Sc","X850207103024","13361","","0"),
("145","10X6/Sc","W850339503004","13373","","0"),
("146","10X6/Sc","C850201803045","13374","","0"),
("147","10X6/Sc","D850207103030","13380","","0"),
("148","10X6/Sc","Z820301601118","13384","","0"),
("149","10X6/Sc","L852246003029","13508","","0"),
("150","10X6/Sc","T850201803010","13409","","0"),
("151","10X6/Sc","E850201903039","13440","","0"),
("152","10X6/Sc","B850201803054","13444","","0"),
("153","10X6/Sc","Z850207103064","13463","","0"),
("154","10X6/Sc","K908223203015","13464","","0"),
("155","10X6/Sc","U850207103078","13488","","0"),
("156","10X6/Sc","H850207103081","13500","","0"),
("157","10X6/Sc","W850201803068","13509","","0"),
("158","10X6/Sc","E852242603056","13516","","0"),
("159","10X6/Sc","N850207103094","13536","","0"),
("160","10X6/Sc","M850201803082","13557","","0"),
("161","10X6/Sc","D850207103109","13561","","0"),
("162","10X6/Sc","Q850201803084","13573","","0"),
("163","10X7/Sc","D850207103001","13314","","0"),
("164","10X7/Sc","C850207103010","13338","","0"),
("165","10X7/Sc","V850207103013","13341","","0"),
("166","10X7/Sc","Y850207103015","13349","","0"),
("167","10X7/Sc","D852242603065","13360","","0"),
("168","10X7/Sc","B850416111001","13866","","0"),
("169","10X7/Sc","K850201803042","13366","","0"),
("170","10X7/Sc","Y352200802001","13376","","0"),
("171","10X7/Sc","H850416110004","13387","","0"),
("172","10X7/Sc","W888356403013","14152","","0"),
("173","10X7/Sc","Y850207103044","13406","","0"),
("174","10X7/Sc","V850201803050","13410","","0"),
("175","10X7/Sc","R852320103031","13432","","0"),
("176","10X7/Sc","D850207103057","13438","","0"),
("177","10X7/Sc","G850207103059","13443","","0"),
("178","10X7/Sc","V850201803019","13480","","0"),
("179","10X7/Sc","P850201803006","13481","","0"),
("180","10X7/Sc","P850207103085","13510","","0"),
("181","10X7/Sc","G850301403033","13523","","0"),
("182","10X7/Sc","R850201803075","13528","","0"),
("183","10X7/Sc","Y850318403037","13552","","0"),
("184","10X7/Sc","A850207103084","13506","","0"),
("185","10Y2/Sc","F850207103068","13469","","0"),
("186","10Y2/Sc","G850207103003","13317","","0"),
("187","10Y2/Sc","H670202602025","13586","","0"),
("188","10Y2/Sc","E850207103021","13357","","0"),
("189","10Y2/Sc","A850201803034","13322","","0"),
("190","10Y2/Sc","U850201803001","13328","","0"),
("191","10Y2/Sc","N850207103007","13331","","0"),
("192","10Y2/Sc","A332204803004","13332","","0"),
("193","10Y2/Sc","L850201803004","13353","","0"),
("194","10Y2/Sc","G850201803040","13356","","0"),
("195","10Y2/Sc","U850207103022","13359","","0"),
("196","10Y2/Sc","R850203303019","13423","","0"),
("197","10Y2/Sc","Z850201803014","13426","","0"),
("198","10Y2/Sc","J850276303001","13449","","0"),
("199","10Y2/Sc","V850201803021","13492","","0"),
("200","10Y2/Sc","Z850201803072","13529","","0"),
("201","10Y2/Sc","G850222403041","13517","","0"),
("202","10Y2/Sc","C850201803074","13525","","0"),
("203","10Y2/Sc","Q850207103101","13550","","0"),
("204","10Y2/Sc","B850201803083","13568","","0"),
("205","10Y2/Sc","W850207103114","13569","","0"),
("206","10Y2/Sc","E850201803085","13579","","0"),
("207","10Y3/Sc","R852246203012","13379","","0"),
("208","10Y3/Sc","T850207103002","13316","","0"),
("209","10Y3/Sc","U850304003013","13337","","0"),
("210","10Y3/Sc","W850201803039","13346","","0"),
("211","10Y3/Sc","V850304003004","13377","","0"),
("212","10Y3/Sc","Z850207103035","13390","","0"),
("213","10Y3/Sc","V850775101072","13392","","0"),
("214","10Y3/Sc","R850207103040","13395","","0"),
("215","10Y3/Sc","J850207103043","13405","","0"),
("216","10Y3/Sc","J850201803051","13414","","0"),
("217","10Y3/Sc","Z850222303059","13886","","0"),
("218","10Y3/Sc","Z850207105120","13429","","0"),
("219","10Y3/Sc","F850207103070","13471","","0"),
("220","10Y3/Sc","Y850201803023","13503","","0"),
("221","10Y3/Sc","T850201803066","13504","","0"),
("222","10Y3/Sc","T908262102003","13515","","0"),
("223","10Y3/Sc","D850207103111","13564","","0"),
("224","10Y3/Sc","K931355503010","13575","","0"),
("225","10Y4/Sc","H850201803031","13315","","0"),
("226","10Y4/Sc","K850207103034","13388","","0"),
("227","10Y4/Sc","T850301403003","13318","","0"),
("228","10Y4/Sc","K850207103005","13323","","0"),
("229","10Y4/Sc","R850304003002","13339","","0"),
("230","10Y4/Sc","A850207103026","13367","","0"),
("231","10Y4/Sc","G850207103032","13385","","0"),
("232","10Y4/Sc","P933204803029","13398","","0"),
("233","10Y4/Sc","J850201803049","13408","","0"),
("234","10Y4/Sc","E850207103048","13420","","0"),
("235","10Y4/Sc","K850238203006","13434","","0"),
("236","10Y4/Sc","N850207103065","13465","","0"),
("237","10Y4/Sc","X850341903011","13468","","0"),
("238","10Y4/Sc","E850206203028","13475","","0"),
("239","10Y4/Sc","R850206103035","14158","","0"),
("240","10Y4/Sc","A846211403020","13482","","0"),
("241","10Y4/Sc","A850201803063","13489","","0"),
("242","10Y4/Sc","P850201803064","13494","","0"),
("243","10Y4/Sc","K850201803069","13512","","0"),
("244","10Y4/Sc","Z850207103093","13532","","0"),
("245","10Y4/Sc","B850207103100","13549","","0"),
("246","10Y4/Sc","G850207103113","13567","","0"),
("247","10Y4/Sc","H850201803029","13581","","0"),
("248","10Y5/Sc","W850207103004","13321","","0"),
("249","10Y5/Sc","H850201803002","13333","","0"),
("250","10Y5/Sc","A850201803005","13370","","0"),
("251","10Y5/Sc","F850207103041","13397","","0"),
("252","10Y5/Sc","H850231203026","13419","","0"),
("253","10Y5/Sc","H850207103052","13427","","0"),
("254","10Y5/Sc","X850207103053","13430","","0"),
("255","10Y5/Sc","A850207103055","13433","","0"),
("256","10Y5/Sc","T850207103060","13445","","0"),
("257","10Y5/Sc","W850207103062","13453","","0"),
("258","10Y5/Sc","G850307903032","13458","","0"),
("259","10Y5/Sc","H850201803058","13460","","0"),
("260","10Y5/Sc","H850207103079","13497","","0"),
("261","10Y5/Sc","G850201803067","13507","","0"),
("262","10Y5/Sc","W850201803070","13513","","0"),
("263","10Y5/Sc","K850201803071","13514","","0"),
("264","10Y5/Sc","U850302002114","13869","","0"),
("265","10Y5/Sc","C850207103095","13538","","0"),
("266","10Y5/Sc","V850207103098","13546","","0"),
("267","10Y5/Sc","P850207103108","13560","","