Author: xuefu Date: Mon Oct 27 22:47:06 2014 New Revision: 1634717 URL: http://svn.apache.org/r1634717 Log: HIVE-8415: Vectorized comparison of timestamp and integer needs to treat integer as seconds since epoch (Matt McCline via Jason Dere) merged from trunk r1634636
Modified: hive/branches/spark/ (props changed) hive/branches/spark/hbase-handler/pom.xml (props changed) hive/branches/spark/ql/src/test/queries/clientpositive/vector_distinct_2.q hive/branches/spark/ql/src/test/queries/clientpositive/vector_groupby_3.q hive/branches/spark/ql/src/test/queries/clientpositive/vector_mapjoin_reduce.q hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_16.q hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_short_regress.q hive/branches/spark/ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out hive/branches/spark/ql/src/test/results/clientpositive/tez/vector_groupby_3.q.out hive/branches/spark/ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out hive/branches/spark/ql/src/test/results/clientpositive/tez/vectorization_16.q.out hive/branches/spark/ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out hive/branches/spark/ql/src/test/results/clientpositive/vector_distinct_2.q.out hive/branches/spark/ql/src/test/results/clientpositive/vector_groupby_3.q.out hive/branches/spark/ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out hive/branches/spark/ql/src/test/results/clientpositive/vectorization_16.q.out hive/branches/spark/ql/src/test/results/clientpositive/vectorization_short_regress.q.out Propchange: hive/branches/spark/ ------------------------------------------------------------------------------ Merged /hive/trunk:r1634636 Propchange: hive/branches/spark/hbase-handler/pom.xml ------------------------------------------------------------------------------ Merged /hive/trunk/hbase-handler/pom.xml:r1634636 Modified: hive/branches/spark/ql/src/test/queries/clientpositive/vector_distinct_2.q URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/vector_distinct_2.q?rev=1634717&r1=1634716&r2=1634717&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/queries/clientpositive/vector_distinct_2.q (original) +++ hive/branches/spark/ql/src/test/queries/clientpositive/vector_distinct_2.q Mon Oct 27 22:47:06 2014 @@ -1,5 +1,7 @@ SET hive.vectorized.execution.enabled=true; +-- SORT_QUERY_RESULTS + create table vectortab2k( t tinyint, si smallint, @@ -40,4 +42,4 @@ INSERT INTO TABLE vectortab2korc SELECT explain select distinct s, t from vectortab2korc; -select distinct s, t from vectortab2korc; \ No newline at end of file +select distinct s, t from vectortab2korc; Modified: hive/branches/spark/ql/src/test/queries/clientpositive/vector_groupby_3.q URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/vector_groupby_3.q?rev=1634717&r1=1634716&r2=1634717&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/queries/clientpositive/vector_groupby_3.q (original) +++ hive/branches/spark/ql/src/test/queries/clientpositive/vector_groupby_3.q Mon Oct 27 22:47:06 2014 @@ -1,5 +1,7 @@ SET hive.vectorized.execution.enabled=true; +-- SORT_QUERY_RESULTS + create table vectortab2k( t tinyint, si smallint, @@ -40,4 +42,4 @@ INSERT INTO TABLE vectortab2korc SELECT explain select s, t, max(b) from vectortab2korc group by s, t; -select s, t, max(b) from vectortab2korc group by s, t; \ No newline at end of file +select s, t, max(b) from vectortab2korc group by s, t; Modified: hive/branches/spark/ql/src/test/queries/clientpositive/vector_mapjoin_reduce.q URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/vector_mapjoin_reduce.q?rev=1634717&r1=1634716&r2=1634717&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/queries/clientpositive/vector_mapjoin_reduce.q (original) +++ hive/branches/spark/ql/src/test/queries/clientpositive/vector_mapjoin_reduce.q Mon Oct 27 22:47:06 2014 @@ -1,6 +1,8 @@ SET hive.vectorized.execution.enabled=true; SET hive.auto.convert.join=true; +-- SORT_QUERY_RESULTS + DROP TABLE part; -- data setup Modified: hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_16.q URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_16.q?rev=1634717&r1=1634716&r2=1634717&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_16.q (original) +++ hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_16.q Mon Oct 27 22:47:06 2014 @@ -1,5 +1,7 @@ SET hive.vectorized.execution.enabled=true; +-- SORT_QUERY_RESULTS + EXPLAIN SELECT cstring1, cdouble, Modified: hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_short_regress.q URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_short_regress.q?rev=1634717&r1=1634716&r2=1634717&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_short_regress.q (original) +++ hive/branches/spark/ql/src/test/queries/clientpositive/vectorization_short_regress.q Mon Oct 27 22:47:06 2014 @@ -326,6 +326,7 @@ WHERE (((cstring1 RLIKE 'a.*') AND (cfloat >= cint)) OR ((cint < cbigint) AND (ctinyint > cbigint))) +ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint LIMIT 50; SELECT cint, @@ -361,6 +362,7 @@ WHERE (((cstring1 RLIKE 'a.*') AND (cfloat >= cint)) OR ((cint < cbigint) AND (ctinyint > cbigint))) +ORDER BY cint, cdouble, ctimestamp2, cstring1, cboolean2, ctinyint, cfloat, ctimestamp1, csmallint, cbigint LIMIT 50; -- TargetTypeClasses: Long, String, Double, Bool, Timestamp @@ -400,6 +402,7 @@ WHERE (((197 > ctinyint) OR (cboolean1 < 0) OR ((cstring1 LIKE '%ss') AND (cfloat <= ctinyint))) +ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2 LIMIT 25; SELECT cint, @@ -434,6 +437,7 @@ WHERE (((197 > ctinyint) OR (cboolean1 < 0) OR ((cstring1 LIKE '%ss') AND (cfloat <= ctinyint))) +ORDER BY cint, cbigint, cstring1, cboolean1, cfloat, cdouble, ctimestamp2, csmallint, cstring2, cboolean2 LIMIT 25; -- TargetTypeClasses: String, Bool, Double, Long, Timestamp @@ -728,6 +732,7 @@ WHERE (((ctimestamp1 != 0)) OR ((cboolean1 IS NULL) AND (cfloat < cint)))) GROUP BY ctimestamp1, cstring1 +ORDER BY ctimestamp1, cstring1 LIMIT 50; SELECT ctimestamp1, @@ -782,6 +787,7 @@ WHERE (((ctimestamp1 != 0)) OR ((cboolean1 IS NULL) AND (cfloat < cint)))) GROUP BY ctimestamp1, cstring1 +ORDER BY ctimestamp1, cstring1 LIMIT 50; -- TargetTypeClasses: Double, Long, String, Timestamp, Bool Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out?rev=1634717&r1=1634716&r2=1634717&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out Mon Oct 27 22:47:06 2014 @@ -1,4 +1,6 @@ -PREHOOK: query: create table vectortab2k( +PREHOOK: query: -- SORT_QUERY_RESULTS + +create table vectortab2k( t tinyint, si smallint, i int, @@ -17,7 +19,9 @@ STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@vectortab2k -POSTHOOK: query: create table vectortab2k( +POSTHOOK: query: -- SORT_QUERY_RESULTS + +create table vectortab2k( t tinyint, si smallint, i int, @@ -172,45 +176,49 @@ POSTHOOK: query: select distinct s, t fr POSTHOOK: type: QUERY POSTHOOK: Input: default@vectortab2korc #### A masked pattern was here #### - NULL - -116 - -114 - -113 - -108 - -107 + -10 -104 - -91 - -87 - -86 - -85 - -84 - -83 - -80 - -75 - -72 - -66 - -53 - -46 - -38 - -36 - -33 - -29 - -28 - -25 - -24 - -19 - -16 - -14 + -107 + -108 + -113 + -114 + -116 -12 - -10 - -5 - -4 + -14 + -16 + -19 -2 + -24 + -25 + -28 + -29 + -33 + -36 + -38 + -4 + -46 + -5 + -53 + -66 + -72 + -75 + -80 + -83 + -84 + -85 + -86 + -87 + -91 0 - 4 - 5 - 8 + 102 + 103 + 105 + 109 + 112 + 113 + 114 12 + 123 16 19 22 @@ -219,9 +227,11 @@ POSTHOOK: Input: default@vectortab2korc 29 31 37 + 4 42 46 48 + 5 54 57 59 @@ -229,6 +239,7 @@ POSTHOOK: Input: default@vectortab2korc 62 64 79 + 8 84 87 88 @@ -236,55 +247,52 @@ POSTHOOK: Input: default@vectortab2korc 91 96 97 - 102 - 103 - 105 - 109 - 112 - 113 - 114 - 123 -american history NULL -american history -127 -american history -119 -american history -116 -american history -112 -american history -110 -american history -108 -american history -105 -american history -103 + NULL american history -101 -american history -95 -american history -94 -american history -92 -american history -90 -american history -89 -american history -87 -american history -86 -american history -81 -american history -80 -american history -73 -american history -66 -american history -60 -american history -59 -american history -55 -american history -53 -american history -50 -american history -48 -american history -47 -american history -34 -american history -30 -american history -28 -american history -27 -american history -26 -american history -19 -american history -18 -american history -17 -american history -15 +american history -103 +american history -105 +american history -108 american history -11 +american history -110 +american history -112 +american history -116 +american history -119 +american history -127 +american history -15 +american history -17 +american history -18 +american history -19 +american history -26 +american history -27 +american history -28 +american history -30 +american history -34 +american history -47 +american history -48 +american history -50 +american history -53 +american history -55 +american history -59 +american history -60 +american history -66 +american history -73 +american history -80 +american history -81 +american history -86 +american history -87 +american history -89 american history -9 +american history -90 +american history -92 +american history -94 +american history -95 american history 0 -american history 5 +american history 100 +american history 103 +american history 111 +american history 119 +american history 122 +american history 123 american history 20 american history 22 american history 29 @@ -296,6 +304,7 @@ american history 40 american history 42 american history 46 american history 48 +american history 5 american history 54 american history 56 american history 60 @@ -310,135 +319,135 @@ american history 82 american history 84 american history 89 american history 96 -american history 100 -american history 103 -american history 111 -american history 119 -american history 122 -american history 123 -biology NULL -biology -127 -biology -121 -biology -120 -biology -119 -biology -104 +american history NULL biology -101 -biology -98 -biology -97 -biology -96 -biology -92 -biology -90 -biology -86 -biology -85 -biology -83 -biology -82 -biology -81 -biology -79 -biology -72 -biology -67 -biology -66 -biology -59 -biology -57 -biology -54 -biology -53 -biology -49 -biology -46 -biology -44 -biology -42 -biology -40 -biology -36 -biology -35 -biology -31 -biology -20 -biology -19 -biology -16 +biology -104 +biology -119 +biology -120 +biology -121 +biology -127 biology -13 -biology -7 -biology -6 +biology -16 +biology -19 +biology -20 +biology -31 +biology -35 +biology -36 +biology -40 +biology -42 +biology -44 +biology -46 +biology -49 biology -5 +biology -53 +biology -54 +biology -57 +biology -59 +biology -6 +biology -66 +biology -67 +biology -7 +biology -72 +biology -79 +biology -81 +biology -82 +biology -83 +biology -85 +biology -86 +biology -90 +biology -92 +biology -96 +biology -97 +biology -98 biology 0 +biology 100 +biology 111 +biology 113 +biology 114 +biology 115 +biology 117 +biology 12 +biology 120 +biology 124 +biology 18 biology 2 +biology 27 biology 3 -biology 4 -biology 5 -biology 6 -biology 7 -biology 8 -biology 12 -biology 18 -biology 27 biology 30 biology 34 biology 35 biology 36 +biology 4 biology 41 biology 47 +biology 5 biology 51 biology 52 biology 54 biology 55 biology 57 +biology 6 biology 64 +biology 7 +biology 8 biology 83 biology 86 biology 89 biology 90 biology 91 -biology 100 -biology 111 -biology 113 -biology 114 -biology 115 -biology 117 -biology 120 -biology 124 -chemistry NULL -chemistry -127 -chemistry -125 -chemistry -122 -chemistry -117 -chemistry -115 -chemistry -110 -chemistry -109 -chemistry -108 -chemistry -103 +biology NULL chemistry -101 -chemistry -98 -chemistry -95 -chemistry -91 -chemistry -90 -chemistry -89 -chemistry -81 -chemistry -75 -chemistry -68 -chemistry -61 -chemistry -59 -chemistry -57 -chemistry -56 -chemistry -52 -chemistry -46 -chemistry -44 -chemistry -40 -chemistry -37 -chemistry -33 -chemistry -31 -chemistry -30 -chemistry -26 +chemistry -103 +chemistry -108 +chemistry -109 +chemistry -110 +chemistry -115 +chemistry -117 +chemistry -122 +chemistry -125 +chemistry -127 +chemistry -2 chemistry -23 -chemistry -8 +chemistry -26 chemistry -3 -chemistry -2 -chemistry 3 -chemistry 4 -chemistry 8 +chemistry -30 +chemistry -31 +chemistry -33 +chemistry -37 +chemistry -40 +chemistry -44 +chemistry -46 +chemistry -52 +chemistry -56 +chemistry -57 +chemistry -59 +chemistry -61 +chemistry -68 +chemistry -75 +chemistry -8 +chemistry -81 +chemistry -89 +chemistry -90 +chemistry -91 +chemistry -95 +chemistry -98 +chemistry 102 +chemistry 104 +chemistry 110 +chemistry 113 +chemistry 116 +chemistry 124 +chemistry 126 chemistry 14 chemistry 16 chemistry 19 chemistry 25 chemistry 27 +chemistry 3 chemistry 32 chemistry 37 chemistry 39 +chemistry 4 chemistry 41 chemistry 46 chemistry 51 @@ -448,53 +457,48 @@ chemistry 74 chemistry 75 chemistry 78 chemistry 79 +chemistry 8 chemistry 83 chemistry 88 chemistry 90 chemistry 91 chemistry 96 -chemistry 102 -chemistry 104 -chemistry 110 -chemistry 113 -chemistry 116 -chemistry 124 -chemistry 126 -debate NULL -debate -127 -debate -117 -debate -114 -debate -108 +chemistry NULL debate -106 -debate -98 -debate -96 -debate -95 -debate -88 -debate -87 -debate -86 -debate -85 -debate -82 -debate -72 -debate -70 -debate -69 -debate -67 -debate -57 -debate -52 -debate -50 -debate -47 -debate -46 -debate -41 -debate -35 -debate -32 -debate -29 -debate -28 -debate -27 -debate -26 -debate -24 -debate -15 +debate -108 +debate -114 +debate -117 debate -12 +debate -127 +debate -15 +debate -24 +debate -26 +debate -27 +debate -28 +debate -29 debate -3 -debate 5 +debate -32 +debate -35 +debate -41 +debate -46 +debate -47 +debate -50 +debate -52 +debate -57 +debate -67 +debate -69 +debate -70 +debate -72 +debate -82 +debate -85 +debate -86 +debate -87 +debate -88 +debate -95 +debate -96 +debate -98 +debate 113 +debate 124 debate 17 debate 19 debate 20 @@ -503,6 +507,7 @@ debate 34 debate 36 debate 41 debate 42 +debate 5 debate 52 debate 54 debate 56 @@ -520,49 +525,56 @@ debate 89 debate 90 debate 93 debate 94 -debate 113 -debate 124 -education NULL -education -127 -education -125 -education -113 -education -111 -education -109 -education -105 +debate NULL education -101 -education -98 -education -96 -education -93 -education -92 -education -89 -education -87 -education -86 -education -77 -education -72 -education -69 -education -64 -education -61 -education -55 -education -52 -education -44 -education -43 -education -38 -education -37 -education -36 -education -34 -education -28 -education -24 -education -15 +education -105 +education -109 +education -111 +education -113 +education -125 +education -127 education -13 +education -15 +education -24 +education -28 +education -34 +education -36 +education -37 +education -38 +education -43 +education -44 +education -52 +education -55 +education -61 +education -64 +education -69 +education -72 +education -77 +education -86 +education -87 +education -89 education -9 -education 4 +education -92 +education -93 +education -96 +education -98 +education 102 +education 103 +education 110 +education 111 +education 113 +education 114 +education 116 +education 119 education 12 +education 125 education 17 education 27 education 33 education 34 education 35 education 38 +education 4 education 41 education 45 education 46 @@ -580,50 +592,46 @@ education 82 education 85 education 89 education 95 -education 102 -education 103 -education 110 -education 111 -education 113 -education 114 -education 116 -education 119 -education 125 -forestry NULL -forestry -126 -forestry -118 -forestry -116 -forestry -109 +education NULL +forestry -1 +forestry -10 forestry -105 -forestry -98 -forestry -95 -forestry -94 -forestry -83 -forestry -81 -forestry -80 -forestry -79 -forestry -77 -forestry -74 -forestry -73 -forestry -68 -forestry -58 -forestry -51 -forestry -50 -forestry -49 -forestry -42 -forestry -34 -forestry -23 -forestry -12 +forestry -109 forestry -11 -forestry -10 -forestry -8 +forestry -116 +forestry -118 +forestry -12 +forestry -126 +forestry -23 forestry -3 -forestry -1 +forestry -34 +forestry -42 +forestry -49 +forestry -50 +forestry -51 +forestry -58 +forestry -68 +forestry -73 +forestry -74 +forestry -77 +forestry -79 +forestry -8 +forestry -80 +forestry -81 +forestry -83 +forestry -94 +forestry -95 +forestry -98 forestry 0 -forestry 7 -forestry 8 +forestry 102 +forestry 106 +forestry 107 forestry 11 +forestry 111 +forestry 115 +forestry 117 forestry 12 +forestry 120 forestry 19 forestry 29 forestry 31 @@ -638,59 +646,57 @@ forestry 51 forestry 52 forestry 55 forestry 56 +forestry 7 forestry 71 forestry 78 forestry 79 +forestry 8 forestry 87 forestry 90 forestry 93 forestry 94 forestry 97 -forestry 102 -forestry 106 -forestry 107 -forestry 111 -forestry 115 -forestry 117 -forestry 120 -geology NULL -geology -124 -geology -117 -geology -115 -geology -112 -geology -108 -geology -106 -geology -101 +forestry NULL geology -100 -geology -96 -geology -94 -geology -84 -geology -82 -geology -80 -geology -79 -geology -75 -geology -72 -geology -68 -geology -59 -geology -57 -geology -54 -geology -53 -geology -50 -geology -48 -geology -35 -geology -34 -geology -32 -geology -31 -geology -30 -geology -23 -geology -21 -geology -18 +geology -101 +geology -106 +geology -108 +geology -112 +geology -115 +geology -117 +geology -124 geology -16 +geology -18 +geology -21 +geology -23 +geology -30 +geology -31 +geology -32 +geology -34 +geology -35 +geology -48 +geology -50 +geology -53 +geology -54 +geology -57 +geology -59 +geology -68 +geology -72 +geology -75 +geology -79 +geology -80 +geology -82 +geology -84 +geology -94 +geology -96 geology 1 -geology 4 -geology 5 -geology 6 -geology 9 +geology 100 +geology 101 +geology 102 +geology 116 +geology 121 +geology 124 +geology 127 geology 14 geology 18 geology 21 @@ -701,57 +707,60 @@ geology 31 geology 33 geology 37 geology 38 +geology 4 geology 49 +geology 5 geology 58 +geology 6 geology 72 geology 82 geology 84 geology 86 geology 89 +geology 9 geology 92 geology 93 geology 95 -geology 100 -geology 101 -geology 102 -geology 116 -geology 121 -geology 124 -geology 127 -history NULL -history -125 -history -124 -history -105 -history -104 -history -103 +geology NULL +history -1 history -101 -history -98 -history -91 -history -90 -history -89 -history -79 -history -75 -history -67 -history -61 -history -58 -history -54 -history -42 -history -37 -history -34 -history -26 -history -24 -history -19 -history -18 -history -15 +history -103 +history -104 +history -105 history -12 -history -8 +history -124 +history -125 +history -15 +history -18 +history -19 +history -24 +history -26 +history -34 +history -37 +history -42 history -5 -history -1 +history -54 +history -58 +history -61 +history -67 +history -75 +history -79 +history -8 +history -89 +history -90 +history -91 +history -98 history 1 -history 2 -history 7 +history 100 +history 108 +history 112 +history 113 +history 114 +history 126 +history 127 history 14 history 18 +history 2 history 25 history 50 history 51 @@ -761,6 +770,7 @@ history 58 history 59 history 61 history 62 +history 7 history 71 history 72 history 73 @@ -770,45 +780,43 @@ history 84 history 92 history 95 history 98 -history 100 -history 108 -history 112 -history 113 -history 114 -history 126 -history 127 -industrial engineering NULL -industrial engineering -124 -industrial engineering -110 +history NULL +industrial engineering -1 industrial engineering -101 -industrial engineering -98 -industrial engineering -96 -industrial engineering -87 -industrial engineering -85 -industrial engineering -72 -industrial engineering -68 -industrial engineering -65 -industrial engineering -58 -industrial engineering -57 -industrial engineering -53 -industrial engineering -49 -industrial engineering -47 -industrial engineering -43 -industrial engineering -38 -industrial engineering -35 -industrial engineering -31 -industrial engineering -30 -industrial engineering -28 -industrial engineering -22 industrial engineering -11 -industrial engineering -7 -industrial engineering -6 +industrial engineering -110 +industrial engineering -124 +industrial engineering -22 +industrial engineering -28 +industrial engineering -30 +industrial engineering -31 +industrial engineering -35 +industrial engineering -38 +industrial engineering -43 +industrial engineering -47 +industrial engineering -49 industrial engineering -5 -industrial engineering -1 -industrial engineering 3 -industrial engineering 7 +industrial engineering -53 +industrial engineering -57 +industrial engineering -58 +industrial engineering -6 +industrial engineering -65 +industrial engineering -68 +industrial engineering -7 +industrial engineering -72 +industrial engineering -85 +industrial engineering -87 +industrial engineering -96 +industrial engineering -98 +industrial engineering 102 +industrial engineering 104 +industrial engineering 105 +industrial engineering 106 +industrial engineering 113 +industrial engineering 126 industrial engineering 27 industrial engineering 29 +industrial engineering 3 industrial engineering 32 industrial engineering 33 industrial engineering 36 @@ -818,6 +826,7 @@ industrial engineering 48 industrial engineering 54 industrial engineering 58 industrial engineering 59 +industrial engineering 7 industrial engineering 70 industrial engineering 73 industrial engineering 78 @@ -827,41 +836,42 @@ industrial engineering 95 industrial engineering 96 industrial engineering 98 industrial engineering 99 -industrial engineering 102 -industrial engineering 104 -industrial engineering 105 -industrial engineering 106 -industrial engineering 113 -industrial engineering 126 -joggying NULL -joggying -125 -joggying -121 -joggying -119 -joggying -110 -joggying -101 +industrial engineering NULL +joggying -1 joggying -100 -joggying -80 -joggying -79 -joggying -77 -joggying -76 -joggying -73 -joggying -69 -joggying -64 -joggying -62 -joggying -61 -joggying -57 -joggying -55 -joggying -48 -joggying -47 -joggying -43 -joggying -40 -joggying -30 -joggying -27 -joggying -24 -joggying -15 +joggying -101 +joggying -110 +joggying -119 +joggying -121 +joggying -125 joggying -14 +joggying -15 +joggying -24 +joggying -27 +joggying -30 +joggying -40 +joggying -43 +joggying -47 +joggying -48 +joggying -55 +joggying -57 +joggying -61 +joggying -62 +joggying -64 +joggying -69 +joggying -73 +joggying -76 +joggying -77 +joggying -79 joggying -8 -joggying -1 +joggying -80 +joggying 104 +joggying 105 +joggying 118 +joggying 119 +joggying 121 +joggying 123 +joggying 125 joggying 13 joggying 20 joggying 25 @@ -889,35 +899,37 @@ joggying 93 joggying 94 joggying 97 joggying 99 -joggying 104 -joggying 105 -joggying 118 -joggying 119 -joggying 121 -joggying 123 -joggying 125 -kindergarten NULL -kindergarten -126 -kindergarten -113 +joggying NULL kindergarten -106 -kindergarten -98 -kindergarten -95 -kindergarten -92 -kindergarten -79 -kindergarten -78 -kindergarten -75 -kindergarten -74 -kindergarten -69 -kindergarten -60 -kindergarten -59 -kindergarten -57 -kindergarten -54 -kindergarten -42 -kindergarten -40 -kindergarten -26 +kindergarten -113 +kindergarten -126 kindergarten -18 +kindergarten -26 +kindergarten -40 +kindergarten -42 +kindergarten -54 +kindergarten -57 +kindergarten -59 +kindergarten -60 +kindergarten -69 +kindergarten -74 +kindergarten -75 +kindergarten -78 +kindergarten -79 kindergarten -8 +kindergarten -92 +kindergarten -95 +kindergarten -98 kindergarten 10 +kindergarten 100 +kindergarten 101 +kindergarten 109 +kindergarten 111 +kindergarten 116 +kindergarten 118 +kindergarten 120 +kindergarten 122 +kindergarten 127 kindergarten 16 kindergarten 18 kindergarten 19 @@ -939,62 +951,59 @@ kindergarten 86 kindergarten 90 kindergarten 92 kindergarten 96 -kindergarten 100 -kindergarten 101 -kindergarten 109 -kindergarten 111 -kindergarten 116 -kindergarten 118 -kindergarten 120 -kindergarten 122 -kindergarten 127 -linguistics NULL -linguistics -127 -linguistics -122 -linguistics -113 +kindergarten NULL linguistics -101 -linguistics -90 -linguistics -89 -linguistics -87 -linguistics -86 -linguistics -78 -linguistics -77 -linguistics -73 -linguistics -70 -linguistics -69 -linguistics -68 -linguistics -67 -linguistics -53 -linguistics -52 -linguistics -41 -linguistics -34 -linguistics -28 -linguistics -22 -linguistics -20 -linguistics -17 -linguistics -16 -linguistics -14 -linguistics -13 +linguistics -113 linguistics -12 -linguistics -6 -linguistics -4 +linguistics -122 +linguistics -127 +linguistics -13 +linguistics -14 +linguistics -16 +linguistics -17 linguistics -2 +linguistics -20 +linguistics -22 +linguistics -28 +linguistics -34 +linguistics -4 +linguistics -41 +linguistics -52 +linguistics -53 +linguistics -6 +linguistics -67 +linguistics -68 +linguistics -69 +linguistics -70 +linguistics -73 +linguistics -77 +linguistics -78 +linguistics -86 +linguistics -87 +linguistics -89 +linguistics -90 linguistics 0 linguistics 1 -linguistics 3 -linguistics 6 -linguistics 7 linguistics 10 +linguistics 100 linguistics 11 +linguistics 113 +linguistics 115 +linguistics 123 +linguistics 125 +linguistics 126 linguistics 18 +linguistics 3 linguistics 33 linguistics 37 linguistics 42 linguistics 44 linguistics 50 linguistics 53 +linguistics 6 linguistics 64 linguistics 67 +linguistics 7 linguistics 72 linguistics 73 linguistics 83 @@ -1002,51 +1011,48 @@ linguistics 89 linguistics 93 linguistics 96 linguistics 98 -linguistics 100 -linguistics 113 -linguistics 115 -linguistics 123 -linguistics 125 -linguistics 126 -mathematics NULL -mathematics -127 -mathematics -124 -mathematics -122 -mathematics -120 -mathematics -118 -mathematics -117 -mathematics -103 -mathematics -101 +linguistics NULL mathematics -100 -mathematics -99 -mathematics -98 -mathematics -95 -mathematics -91 -mathematics -88 -mathematics -81 -mathematics -79 -mathematics -77 -mathematics -75 -mathematics -66 -mathematics -57 -mathematics -52 -mathematics -50 -mathematics -49 -mathematics -46 -mathematics -45 -mathematics -40 -mathematics -33 -mathematics -31 -mathematics -21 +mathematics -101 +mathematics -103 +mathematics -117 +mathematics -118 +mathematics -120 +mathematics -122 +mathematics -124 +mathematics -127 mathematics -19 +mathematics -21 +mathematics -31 +mathematics -33 +mathematics -40 +mathematics -45 +mathematics -46 +mathematics -49 +mathematics -50 +mathematics -52 +mathematics -57 +mathematics -66 mathematics -7 +mathematics -75 +mathematics -77 +mathematics -79 +mathematics -81 +mathematics -88 +mathematics -91 +mathematics -95 +mathematics -98 +mathematics -99 mathematics 0 -mathematics 3 -mathematics 6 mathematics 10 +mathematics 102 +mathematics 107 +mathematics 111 +mathematics 114 mathematics 22 mathematics 23 mathematics 25 +mathematics 3 mathematics 32 mathematics 35 mathematics 38 @@ -1059,6 +1065,7 @@ mathematics 55 mathematics 56 mathematics 58 mathematics 59 +mathematics 6 mathematics 62 mathematics 63 mathematics 65 @@ -1069,43 +1076,45 @@ mathematics 82 mathematics 87 mathematics 92 mathematics 98 -mathematics 102 -mathematics 107 -mathematics 111 -mathematics 114 -nap time NULL -nap time -122 -nap time -119 -nap time -115 -nap time -113 -nap time -104 -nap time -102 +mathematics NULL nap time -101 -nap time -91 -nap time -85 -nap time -71 -nap time -61 -nap time -54 -nap time -49 -nap time -45 -nap time -41 -nap time -31 +nap time -102 +nap time -104 +nap time -113 +nap time -115 +nap time -119 +nap time -122 nap time -15 -nap time -6 -nap time -4 nap time -2 +nap time -31 +nap time -4 +nap time -41 +nap time -45 +nap time -49 +nap time -54 +nap time -6 +nap time -61 +nap time -71 +nap time -85 +nap time -91 nap time 0 -nap time 3 -nap time 6 +nap time 103 +nap time 104 +nap time 105 +nap time 107 +nap time 108 +nap time 118 nap time 16 nap time 23 nap time 27 +nap time 3 nap time 31 nap time 35 nap time 42 nap time 51 nap time 52 nap time 56 +nap time 6 nap time 62 nap time 69 nap time 70 @@ -1117,52 +1126,53 @@ nap time 90 nap time 92 nap time 93 nap time 98 -nap time 103 -nap time 104 -nap time 105 -nap time 107 -nap time 108 -nap time 118 -opthamology NULL -opthamology -122 -opthamology -121 -opthamology -118 +nap time NULL opthamology -111 -opthamology -99 -opthamology -97 -opthamology -91 -opthamology -86 -opthamology -82 -opthamology -79 -opthamology -78 -opthamology -77 -opthamology -75 -opthamology -73 -opthamology -63 -opthamology -59 -opthamology -55 -opthamology -49 -opthamology -48 -opthamology -44 -opthamology -35 -opthamology -33 -opthamology -30 -opthamology -28 -opthamology -27 -opthamology -24 -opthamology -22 -opthamology -18 -opthamology -17 +opthamology -118 +opthamology -121 +opthamology -122 opthamology -14 -opthamology -8 +opthamology -17 +opthamology -18 +opthamology -22 +opthamology -24 +opthamology -27 +opthamology -28 +opthamology -30 +opthamology -33 +opthamology -35 +opthamology -44 +opthamology -48 +opthamology -49 opthamology -5 -opthamology 4 -opthamology 5 +opthamology -55 +opthamology -59 +opthamology -63 +opthamology -73 +opthamology -75 +opthamology -77 +opthamology -78 +opthamology -79 +opthamology -8 +opthamology -82 +opthamology -86 +opthamology -91 +opthamology -97 +opthamology -99 +opthamology 100 +opthamology 104 +opthamology 117 +opthamology 120 +opthamology 122 +opthamology 125 +opthamology 127 opthamology 21 opthamology 39 +opthamology 4 opthamology 41 opthamology 48 opthamology 49 +opthamology 5 opthamology 52 opthamology 53 opthamology 55 @@ -1180,46 +1190,44 @@ opthamology 89 opthamology 92 opthamology 96 opthamology 97 -opthamology 100 -opthamology 104 -opthamology 117 -opthamology 120 -opthamology 122 -opthamology 125 -opthamology 127 -philosophy NULL -philosophy -125 -philosophy -121 -philosophy -119 -philosophy -115 -philosophy -110 -philosophy -105 -philosophy -103 +opthamology NULL philosophy -100 -philosophy -99 -philosophy -95 -philosophy -93 -philosophy -92 -philosophy -80 -philosophy -78 -philosophy -77 -philosophy -69 -philosophy -68 -philosophy -61 -philosophy -56 -philosophy -55 -philosophy -53 -philosophy -52 -philosophy -51 -philosophy -50 -philosophy -40 -philosophy -39 -philosophy -27 -philosophy -26 -philosophy -25 -philosophy -17 +philosophy -103 +philosophy -105 philosophy -11 -philosophy 8 +philosophy -110 +philosophy -115 +philosophy -119 +philosophy -121 +philosophy -125 +philosophy -17 +philosophy -25 +philosophy -26 +philosophy -27 +philosophy -39 +philosophy -40 +philosophy -50 +philosophy -51 +philosophy -52 +philosophy -53 +philosophy -55 +philosophy -56 +philosophy -61 +philosophy -68 +philosophy -69 +philosophy -77 +philosophy -78 +philosophy -80 +philosophy -92 +philosophy -93 +philosophy -95 +philosophy -99 +philosophy 104 +philosophy 108 +philosophy 117 +philosophy 118 +philosophy 120 +philosophy 123 philosophy 20 philosophy 21 philosophy 22 @@ -1235,49 +1243,47 @@ philosophy 64 philosophy 67 philosophy 68 philosophy 73 +philosophy 8 philosophy 83 philosophy 96 philosophy 98 -philosophy 104 -philosophy 108 -philosophy 117 -philosophy 118 -philosophy 120 -philosophy 123 -quiet hour NULL -quiet hour -127 -quiet hour -123 -quiet hour -121 -quiet hour -119 -quiet hour -114 -quiet hour -111 -quiet hour -105 +philosophy NULL +quiet hour -1 quiet hour -104 -quiet hour -88 -quiet hour -87 -quiet hour -76 -quiet hour -73 -quiet hour -68 -quiet hour -66 -quiet hour -65 -quiet hour -56 -quiet hour -55 -quiet hour -52 -quiet hour -50 -quiet hour -48 -quiet hour -45 -quiet hour -42 -quiet hour -41 -quiet hour -33 -quiet hour -31 -quiet hour -25 +quiet hour -105 +quiet hour -111 +quiet hour -114 +quiet hour -119 +quiet hour -121 +quiet hour -123 +quiet hour -127 quiet hour -14 +quiet hour -25 +quiet hour -31 +quiet hour -33 +quiet hour -41 +quiet hour -42 +quiet hour -45 +quiet hour -48 +quiet hour -50 +quiet hour -52 +quiet hour -55 +quiet hour -56 +quiet hour -65 +quiet hour -66 +quiet hour -68 +quiet hour -73 +quiet hour -76 quiet hour -8 -quiet hour -1 +quiet hour -87 +quiet hour -88 quiet hour 0 -quiet hour 6 -quiet hour 7 -quiet hour 8 +quiet hour 110 +quiet hour 112 +quiet hour 115 +quiet hour 120 +quiet hour 121 +quiet hour 123 quiet hour 13 quiet hour 21 quiet hour 23 @@ -1288,64 +1294,70 @@ quiet hour 35 quiet hour 38 quiet hour 43 quiet hour 58 +quiet hour 6 quiet hour 60 quiet hour 66 +quiet hour 7 quiet hour 71 quiet hour 74 +quiet hour 8 quiet hour 80 quiet hour 82 quiet hour 84 quiet hour 93 quiet hour 98 -quiet hour 110 -quiet hour 112 -quiet hour 115 -quiet hour 120 -quiet hour 121 -quiet hour 123 -religion NULL -religion -125 -religion -106 +quiet hour NULL religion -104 -religion -94 -religion -93 -religion -81 -religion -78 -religion -77 -religion -76 -religion -71 -religion -70 -religion -69 -religion -64 -religion -62 -religion -60 -religion -56 -religion -44 -religion -42 -religion -41 -religion -38 -religion -35 -religion -32 -religion -29 -religion -28 -religion -26 -religion -24 +religion -106 +religion -125 religion -23 -religion -9 -religion -7 +religion -24 +religion -26 +religion -28 +religion -29 religion -3 +religion -32 +religion -35 +religion -38 +religion -41 +religion -42 +religion -44 +religion -56 +religion -60 +religion -62 +religion -64 +religion -69 +religion -7 +religion -70 +religion -71 +religion -76 +religion -77 +religion -78 +religion -81 +religion -9 +religion -93 +religion -94 religion 0 -religion 2 -religion 4 -religion 5 +religion 102 +religion 103 +religion 106 +religion 107 +religion 110 +religion 115 +religion 120 +religion 123 +religion 124 religion 15 religion 17 +religion 2 religion 29 religion 31 religion 38 +religion 4 religion 44 religion 45 religion 49 +religion 5 religion 52 religion 54 religion 58 @@ -1360,51 +1372,49 @@ religion 92 religion 93 religion 96 religion 97 -religion 102 -religion 103 -religion 106 -religion 107 -religion 110 -religion 115 -religion 120 -religion 123 -religion 124 -study skills NULL -study skills -127 -study skills -126 -study skills -117 -study skills -107 -study skills -106 +religion NULL +study skills -1 study skills -100 -study skills -88 -study skills -86 -study skills -82 -study skills -81 -study skills -76 -study skills -73 -study skills -65 -study skills -52 -study skills -36 -study skills -33 -study skills -27 -study skills -26 -study skills -22 -study skills -17 -study skills -14 +study skills -106 +study skills -107 +study skills -117 +study skills -126 +study skills -127 study skills -13 -study skills -6 -study skills -5 -study skills -4 +study skills -14 +study skills -17 +study skills -22 +study skills -26 +study skills -27 study skills -3 -study skills -1 -study skills 2 -study skills 3 +study skills -33 +study skills -36 +study skills -4 +study skills -5 +study skills -52 +study skills -6 +study skills -65 +study skills -73 +study skills -76 +study skills -81 +study skills -82 +study skills -86 +study skills -88 +study skills 101 +study skills 106 +study skills 107 +study skills 110 +study skills 115 +study skills 119 +study skills 123 study skills 18 +study skills 2 study skills 21 study skills 23 study skills 25 study skills 28 study skills 29 +study skills 3 study skills 30 study skills 35 study skills 39 @@ -1420,48 +1430,45 @@ study skills 63 study skills 66 study skills 68 study skills 72 -study skills 77 -study skills 80 -study skills 83 -study skills 92 -study skills 95 -study skills 96 -study skills 101 -study skills 106 -study skills 107 -study skills 110 -study skills 115 -study skills 119 -study skills 123 -topology NULL -topology -122 -topology -116 -topology -106 -topology -105 +study skills 77 +study skills 80 +study skills 83 +study skills 92 +study skills 95 +study skills 96 +study skills NULL +topology -1 topology -102 -topology -98 -topology -96 -topology -88 -topology -86 -topology -78 -topology -74 -topology -71 -topology -60 -topology -58 -topology -57 -topology -50 -topology -44 -topology -42 -topology -41 -topology -36 -topology -32 -topology -31 -topology -25 +topology -105 +topology -106 +topology -116 +topology -122 topology -21 +topology -25 +topology -31 +topology -32 +topology -36 +topology -41 +topology -42 +topology -44 topology -5 -topology -1 -topology 7 +topology -50 +topology -57 +topology -58 +topology -60 +topology -71 +topology -74 +topology -78 +topology -86 +topology -88 +topology -96 +topology -98 +topology 105 +topology 107 topology 11 +topology 119 +topology 121 +topology 127 topology 13 topology 14 topology 18 @@ -1481,6 +1488,7 @@ topology 61 topology 63 topology 67 topology 69 +topology 7 topology 71 topology 80 topology 81 @@ -1488,45 +1496,44 @@ topology 83 topology 86 topology 87 topology 94 -topology 105 -topology 107 -topology 119 -topology 121 -topology 127 -undecided NULL -undecided -120 -undecided -118 -undecided -117 -undecided -116 -undecided -115 -undecided -114 -undecided -112 -undecided -105 +topology NULL +undecided -10 undecided -104 -undecided -96 -undecided -93 -undecided -90 -undecided -84 -undecided -83 -undecided -78 -undecided -69 -undecided -62 -undecided -53 -undecided -52 -undecided -51 -undecided -43 -undecided -41 -undecided -29 -undecided -28 -undecided -23 -undecided -19 +undecided -105 +undecided -112 +undecided -114 +undecided -115 +undecided -116 +undecided -117 +undecided -118 +undecided -120 undecided -13 -undecided -10 +undecided -19 +undecided -23 +undecided -28 +undecided -29 +undecided -41 +undecided -43 +undecided -51 +undecided -52 +undecided -53 +undecided -62 +undecided -69 +undecided -78 undecided -8 +undecided -83 +undecided -84 +undecided -90 +undecided -93 +undecided -96 undecided 0 undecided 1 -undecided 7 undecided 11 +undecided 111 +undecided 114 +undecided 119 +undecided 123 +undecided 124 undecided 13 undecided 14 undecided 27 @@ -1539,62 +1546,63 @@ undecided 50 undecided 51 undecided 56 undecided 69 +undecided 7 undecided 76 undecided 95 undecided 97 undecided 98 -undecided 111 -undecided 114 -undecided 119 -undecided 123 -undecided 124 -values clariffication NULL -values clariffication -123 -values clariffication -119 -values clariffication -114 -values clariffication -109 -values clariffication -108 -values clariffication -107 -values clariffication -105 +undecided NULL values clariffication -100 -values clariffication -98 -values clariffication -97 -values clariffication -95 -values clariffication -92 -values clariffication -90 -values clariffication -81 -values clariffication -75 -values clariffication -70 -values clariffication -69 -values clariffication -67 -values clariffication -63 -values clariffication -62 -values clariffication -60 -values clariffication -55 -values clariffication -51 -values clariffication -50 -values clariffication -48 -values clariffication -46 -values clariffication -42 -values clariffication -40 -values clariffication -38 -values clariffication -37 -values clariffication -31 +values clariffication -105 +values clariffication -107 +values clariffication -108 +values clariffication -109 +values clariffication -114 +values clariffication -119 +values clariffication -123 values clariffication -28 -values clariffication -8 -values clariffication -6 +values clariffication -31 +values clariffication -37 +values clariffication -38 +values clariffication -40 +values clariffication -42 +values clariffication -46 +values clariffication -48 values clariffication -5 -values clariffication 4 -values clariffication 8 -values clariffication 9 +values clariffication -50 +values clariffication -51 +values clariffication -55 +values clariffication -6 +values clariffication -60 +values clariffication -62 +values clariffication -63 +values clariffication -67 +values clariffication -69 +values clariffication -70 +values clariffication -75 +values clariffication -8 +values clariffication -81 +values clariffication -90 +values clariffication -92 +values clariffication -95 +values clariffication -97 +values clariffication -98 values clariffication 10 +values clariffication 108 +values clariffication 118 values clariffication 12 +values clariffication 120 +values clariffication 122 +values clariffication 124 +values clariffication 126 +values clariffication 127 values clariffication 14 values clariffication 15 values clariffication 21 values clariffication 23 values clariffication 30 values clariffication 32 +values clariffication 4 values clariffication 42 values clariffication 50 values clariffication 53 @@ -1603,55 +1611,56 @@ values clariffication 57 values clariffication 62 values clariffication 70 values clariffication 74 +values clariffication 8 values clariffication 80 values clariffication 85 +values clariffication 9 values clariffication 92 values clariffication 93 values clariffication 96 values clariffication 97 values clariffication 98 -values clariffication 108 -values clariffication 118 -values clariffication 120 -values clariffication 122 -values clariffication 124 -values clariffication 126 -values clariffication 127 -wind surfing NULL -wind surfing -124 -wind surfing -121 -wind surfing -117 -wind surfing -116 -wind surfing -113 -wind surfing -111 -wind surfing -104 +values clariffication NULL wind surfing -102 -wind surfing -99 -wind surfing -98 -wind surfing -96 -wind surfing -83 -wind surfing -80 -wind surfing -78 -wind surfing -71 -wind surfing -65 -wind surfing -60 -wind surfing -57 -wind surfing -56 -wind surfing -42 -wind surfing -39 -wind surfing -38 -wind surfing -34 -wind surfing -31 -wind surfing -30 -wind surfing -21 -wind surfing -18 -wind surfing -14 +wind surfing -104 +wind surfing -111 +wind surfing -113 +wind surfing -116 +wind surfing -117 wind surfing -12 -wind surfing -8 +wind surfing -121 +wind surfing -124 +wind surfing -14 +wind surfing -18 +wind surfing -2 +wind surfing -21 +wind surfing -30 +wind surfing -31 +wind surfing -34 +wind surfing -38 +wind surfing -39 +wind surfing -42 +wind surfing -56 +wind surfing -57 wind surfing -6 -wind surfing -2 -wind surfing 5 +wind surfing -60 +wind surfing -65 +wind surfing -71 +wind surfing -78 +wind surfing -8 +wind surfing -80 +wind surfing -83 +wind surfing -96 +wind surfing -98 +wind surfing -99 +wind surfing 101 +wind surfing 102 +wind surfing 107 +wind surfing 108 wind surfing 11 +wind surfing 111 +wind surfing 112 +wind surfing 121 wind surfing 15 wind surfing 16 wind surfing 20 @@ -1667,6 +1676,7 @@ wind surfing 41 wind surfing 44 wind surfing 45 wind surfing 48 +wind surfing 5 wind surfing 52 wind surfing 53 wind surfing 54 @@ -1684,110 +1694,104 @@ wind surfing 86 wind surfing 88 wind surfing 92 wind surfing 96 -wind surfing 101 -wind surfing 102 -wind surfing 107 -wind surfing 108 -wind surfing 111 -wind surfing 112 -wind surfing 121 -xylophone band NULL -xylophone band -115 -xylophone band -112 -xylophone band -109 -xylophone band -104 +wind surfing NULL +xylophone band -10 xylophone band -101 -xylophone band -98 -xylophone band -96 -xylophone band -94 -xylophone band -91 -xylophone band -78 -xylophone band -75 -xylophone band -72 -xylophone band -70 -xylophone band -68 -xylophone band -59 -xylophone band -46 -xylophone band -27 -xylophone band -26 -xylophone band -23 -xylophone band -15 +xylophone band -104 +xylophone band -109 +xylophone band -112 +xylophone band -115 xylophone band -13 -xylophone band -10 -xylophone band -6 -xylophone band -3 +xylophone band -15 xylophone band -2 +xylophone band -23 +xylophone band -26 +xylophone band -27 +xylophone band -3 +xylophone band -46 +xylophone band -59 +xylophone band -6 +xylophone band -68 +xylophone band -70 +xylophone band -72 +xylophone band -75 +xylophone band -78 +xylophone band -91 +xylophone band -94 +xylophone band -96 +xylophone band -98 xylophone band 0 -xylophone band 3 -xylophone band 6 -xylophone band 7 -xylophone band 9 +xylophone band 107 +xylophone band 108 xylophone band 11 +xylophone band 112 +xylophone band 118 +xylophone band 122 +xylophone band 123 +xylophone band 125 +xylophone band 127 xylophone band 14 xylophone band 17 xylophone band 19 xylophone band 22 xylophone band 23 +xylophone band 3 xylophone band 33 xylophone band 36 xylophone band 38 xylophone band 40 xylophone band 52 +xylophone band 6 xylophone band 60 xylophone band 62 +xylophone band 7 xylophone band 77 xylophone band 79 xylophone band 84 xylophone band 85 xylophone band 88 +xylophone band 9 xylophone band 92 xylophone band 94 -xylophone band 107 -xylophone band 108 -xylophone band 112 -xylophone band 118 -xylophone band 122 -xylophone band 123 -xylophone band 125 -xylophone band 127 -yard duty NULL -yard duty -127 -yard duty -115 -yard duty -114 -yard duty -109 -yard duty -103 -yard duty -102 +xylophone band NULL +yard duty -1 yard duty -100 -yard duty -98 -yard duty -93 -yard duty -91 -yard duty -88 -yard duty -86 -yard duty -85 -yard duty -82 -yard duty -76 -yard duty -62 -yard duty -61 -yard duty -57 -yard duty -53 -yard duty -51 -yard duty -50 -yard duty -49 -yard duty -48 -yard duty -46 -yard duty -45 -yard duty -44 -yard duty -33 -yard duty -28 -yard duty -27 -yard duty -21 -yard duty -19 -yard duty -17 +yard duty -102 +yard duty -103 +yard duty -109 +yard duty -114 +yard duty -115 +yard duty -127 yard duty -15 -yard duty -1 -yard duty 8 -yard duty 9 +yard duty -17 +yard duty -19 +yard duty -21 +yard duty -27 +yard duty -28 +yard duty -33 +yard duty -44 +yard duty -45 +yard duty -46 +yard duty -48 +yard duty -49 +yard duty -50 +yard duty -51 +yard duty -53 +yard duty -57 +yard duty -61 +yard duty -62 +yard duty -76 +yard duty -82 +yard duty -85 +yard duty -86 +yard duty -88 +yard duty -91 +yard duty -93 +yard duty -98 yard duty 10 +yard duty 102 +yard duty 105 +yard duty 110 yard duty 15 yard duty 18 yard duty 22 @@ -1804,50 +1808,50 @@ yard duty 60 yard duty 64 yard duty 65 yard duty 78 +yard duty 8 yard duty 86 +yard duty 9 yard duty 90 -yard duty 102 -yard duty 105 -yard duty 110 -zync studies NULL -zync studies -127 -zync studies -117 -zync studies -116 -zync studies -111 -zync studies -105 -zync studies -103 +yard duty NULL zync studies -102 -zync studies -94 -zync studies -90 -zync studies -83 -zync studies -79 -zync studies -78 -zync studies -68 -zync studies -61 -zync studies -58 -zync studies -57 -zync studies -54 -zync studies -52 -zync studies -50 -zync studies -45 -zync studies -40 -zync studies -39 -zync studies -38 -zync studies -37 -zync studies -36 -zync studies -35 -zync studies -34 -zync studies -33 -zync studies -32 -zync studies -27 -zync studies -26 -zync studies -21 -zync studies -20 +zync studies -103 +zync studies -105 +zync studies -111 +zync studies -116 +zync studies -117 zync studies -12 +zync studies -127 +zync studies -20 +zync studies -21 +zync studies -26 +zync studies -27 +zync studies -32 +zync studies -33 +zync studies -34 +zync studies -35 +zync studies -36 +zync studies -37 +zync studies -38 +zync studies -39 +zync studies -40 +zync studies -45 +zync studies -50 +zync studies -52 +zync studies -54 +zync studies -57 +zync studies -58 +zync studies -61 +zync studies -68 +zync studies -78 +zync studies -79 +zync studies -83 +zync studies -90 +zync studies -94 zync studies 1 -zync studies 7 -zync studies 9 +zync studies 100 zync studies 11 +zync studies 116 +zync studies 120 zync studies 15 zync studies 19 zync studies 31 @@ -1855,12 +1859,12 @@ zync studies 37 zync studies 48 zync studies 59 zync studies 63 +zync studies 7 zync studies 70 zync studies 87 +zync studies 9 zync studies 90 zync studies 91 zync studies 98 zync studies 99 -zync studies 100 -zync studies 116 -zync studies 120 +zync studies NULL