text: 
  
   CREATE VIEW community.Post_Train as SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%caché%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%microsoft windows server%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%deployment%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%node.js%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%.net%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%oauth2%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%monitoring%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%code snippet%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%article%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%high availability%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%github%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%eclipse%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%perforce%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%containerization%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%other%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%languages%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%xml%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%global summit 2016%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%callout%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%mirroring%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%ai%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%business rules%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%sharding%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%compatibility%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%document data model (nosql)%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%vue.js%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%big data experience%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%angular2%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%best practices%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%dashboards%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%alerts%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%video%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%big data%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%java%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%machine learning%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%debugging%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%compiler%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%architect%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%gcp%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%zen%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%databases%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%ecp%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%json%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%dtl%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%rest api%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%vscode%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%ui development%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%global masters%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%cloud%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%atelier 1.1 beta%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%failover%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%global summit%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%events%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%error handling%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%developer community%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%roles%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%analytics%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%git%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%management portal%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%intersystems data platform blog%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%backup%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%angular%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%azure%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%platforms%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%analyzer%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%online learning%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%hl7%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%c++%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%html%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%aws%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%apple macos%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%change management%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%cubes%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%global summit 2017%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%ldap%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%contest%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%global summit 2018%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%authorization%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%ensemble%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%testing%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%system administration%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%security%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%sql%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%red hat enterprise linux (rhel)%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%javascript%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%mapping%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%ssl%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%intersystems iris experience%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%tips & tricks%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%business operation%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%api%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%iris analytics (deepsee)%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%developer community faq%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%odbc%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%key value%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%dc feedback%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%tutorial%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%authentication%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%studio%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%atelier 1.2 beta%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%unstructured data%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%healthshare%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%soap%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%continuous delivery%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%intersystems business solutions and architectures%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%microservices%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%atelier 1.2%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%business process (bpl)%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%intersystems iris%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%performance%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%release%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%users%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%interoperability%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%open source%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%webinar%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%ftp%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%ifind%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%business service%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%journaling%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%mdx%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%beginner%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%tools%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%svn%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%documentation%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%iknow%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%python%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%jdbc%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%devops%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%mercurial%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%microsoft windows%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%iot%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%data import and export%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%suse linux%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%intersystems iris for health%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%graph%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%development environment%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%objectscript%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%visualization%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%atelier%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%worldwide response center (wrc)%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%globals%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%uima%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%distributed data management%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%continuous integration%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%frontend%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%docker%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%terminal%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%coding guidelines%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%issue tracking%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%field tests%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%namespace%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%csp%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%relational tables%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%indexing%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%java experience%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%data model%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%localization%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%application server%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%encryption%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%csv%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%intersystems official%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%react%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%open exchange%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%object data model%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%listings%'  union  SELECT top 20 id, Name, Tags, Text, PostType FROM Community.Post Where lang = 'en' and tags like '%oracle enterprise linux%'
  
  
  
  
  CREATE MODEL has_sql_tag PREDICTING (sql) FROM community.view_train
  TRAIN MODEL has_sql_tag FROM community.view_train
  
  
  SELECT xtest.ID, PREDICT(has_sql_tag) As Predicted, ytest.sql FROM community.xtest as xtest
  inner join
  community.ytest as ytest
  on ytest.id = xtest.id
  
  
   SELECT
   	c0, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52, c53, c54, c55, c56, c57, c58, c59, c60, c61, c62, c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103, c104, c105, c106, c107, c108, c109, c110, c111, c112, c113, c114, c115, c116, c117, c118, c119, c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156, c157, c158, c159, c160, c161, c162, c163, c164, c165, c166, c167, c168, c169, c170, c171, c172, c173, c174, c175, c176, c177, c178, c179, c180, c181, c182, c183, c184, c185, c186, c187, c188, c189, c190, c191, c192, c193, c194, c195, c196, c197, c198, c199, c200, c201, c202, c203, c204, c205, c206, c207, c208, c209, c210, c211, c212, c213, c214, c215, c216, c217, c218, c219, c220, c221, c222, c223, c224, c225, c226, c227, c228, c229, c230, c231, c232, c233, c234, c235, c236, c237, c238, c239, c240, c241, c242, c243, c244, c245, c246, c247, c248, c249, c250, c251, c252, c253, c254, c255, c256, c257, c258, c259, c260, c261, c262, c263, c264, c265, c266, c267, c268, c269, c270, c271, c272, c273, c274, c275, c276, c277, c278, c279, c280, c281, c282, c283, c284, c285, c286, c287, c288, c289, c290, c291, c292, c293, c294, c295, c296, c297, c298, c299, c300, c301, c302, c303, c304, c305, c306, c307, c308, c309, c310, c311, c312, c313, c314, c315, c316, c317, c318, c319, c320, c321, c322, c323, c324, c325, c326, c327, c328, c329, c330, c331, c332, c333, c334, c335, c336, c337, c338, c339, c340, c341, c342, c343, c344, c345, c346, c347, c348, c349, c350, c351, c352, c353, c354, c355, c356, c357, c358, c359, c360, c361, c362, c363, c364, c365, c366, c367, c368, c369, c370, c371, c372, c373, c374, c375, c376, c377, c378, c379, c380, c381, c382, c383, c384, c385, c386, c387, c388, c389, c390, c391, c392, c393, c394, c395, c396, c397, c398, c399, c400, c401, c402, c403, c404, c405, c406, c407, c408, c409, c410, c411, c412, c413, c414, c415, c416, c417, c418, c419, c420, c421, c422, c423, c424, c425, c426, c427, c428, c429, c430, c431, c432, c433, c434, c435, c436, c437, c438, c439, c440, c441, c442, c443, c444, c445, c446, c447, c448, c449, c450, c451, c452, c453, c454, c455, c456, c457, c458, c459, c460, c461, c462, c463, c464, c465, c466, c467, c468, c469, c470, c471, c472, c473, c474, c475, c476, c477, c478, c479, c480, c481, c482, c483, c484, c485, c486, c487, c488, c489, c490, c491, c492, c493, c494, c495, c496, c497, c498, c499, c500, c501, c502, c503, c504, c505, c506, c507, c508, c509, c510, c511, c512, c513, c514, c515, c516, c517, c518, c519, c520, c521, c522, c523, c524, c525, c526, c527, c528, c529, c530, c531, c532, c533, c534, c535, c536, c537, c538, c539, c540, c541, c542, c543, c544, c545, c546, c547, c548, c549, c550, c551, c552, c553, c554, c555, c556, c557, c558, c559, c560, c561, c562, c563, c564, c565, c566, c567, c568, c569, c570, c571, c572, c573, c574, c575, c576, c577, c578, c579, c580, c581, c582, c583, c584, c585, c586, c587, c588, c589, c590, c591, c592, c593, c594, c595, c596, c597, c598, c599, c600, c601, c602, c603, c604, c605, c606, c607, c608, c609, c610, c611, c612, c613, c614, c615, c616, c617, c618, c619, c620, c621, c622, c623, c624, c625, c626, c627, c628, c629, c630, c631, c632, c633, c634, c635, c636, c637, c638, c639, c640, c641, c642, c643, c644, c645, c646, c647, c648, c649, c650, c651, c652, c653, c654, c655, c656, c657, c658, c659, c660, c661, c662, c663, c664, c665, c666, c667, c668, c669, c670, c671, c672, c673, c674, c675, c676, c677, c678, c679, c680, c681, c682, c683, c684, c685, c686, c687, c688, c689, c690, c691, c692, c693, c694, c695, c696, c697, c698, c699, c700, c701, c702, c703, c704, c705, c706, c707, c708, c709, c710, c711, c712, c713, c714, c715, c716, c717, c718, c719, c720, c721, c722, c723, c724, c725, c726, c727, c728, c729, c730, c731, c732, c733, c734, c735, c736, c737, c738, c739, c740, c741, c742, c743, c744, c745, c746, c747, c748, c749, c750, c751, c752, c753, c754, c755, c756, c757, c758, c759, c760, c761, c762, c763, c764, c765, c766, c767, c768, c769, c770, c771, c772, c773, c774, c775, c776, c777, c778, c779, c780, c781, c782, c783, c784, c785, c786, c787, c788, c789, c790, c791, c792, c793, c794, c795, c796, c797, c798, c799, c800, c801, c802, c803, c804, c805, c806, c807, c808, c809, c810, c811, c812, c813, c814, c815, c816, c817, c818, c819, c820, c821, c822, c823, c824, c825, c826, c827, c828, c829, c830, c831, c832, c833, c834, c835, c836, c837, c838, c839, c840, c841, c842, c843, c844, c845, c846, c847, c848, c849, c850, c851, c852, c853, c854, c855, c856, c857, c858, c859, c860, c861, c862, c863, c864, c865, c866, c867, c868, c869, c870, c871, c872, c873, c874, c875, c876, c877, c878, c879, c880, c881, c882, c883, c884, c885, c886, c887, c888, c889, c890, c891, c892, c893, c894, c895, c896, c897, c898, c899,
  languages, microsoft_windows, ui_development, atelier_1_1, application_server, atelier_1_0_beta, zen, beginner, globals, business_operation, other, objectscript_package_manager, analytics, caretdev, architect, dtl, business_service, csp, field_tests, unstructured_data, testing, c__, developer_community, management_portal, json, message_search, podcast, data_model, business_rules, intersystems_iris, kubernetes, video, database_transaction_processing, intersystems_iris_for_health, "authorization", george_james_software, authentication, rest_api, ssl, documentation, _net, job_opportunity, oauth2, continuous_integration, sharding, hl7, developer_community_faq, ecp, healthshare, frontend, big_data, devops, big_data_experience, listings, microsoft_windows_server, apple_macos, aws, svn, global_summit_2016, ifind, java_experience, terminal, ftp, issue_tracking, indexing, ldap, atelier_1_2, atelier_1_3, ai, java, platforms, key_value, global_summit_2019, users, intersystems_partner, object_data_model, perforce, certification, jdbc, encryption, red_hat_enterprise_linux__rhel_, release, openvms, compatibility, dc_feedback, docker, performance, gcp, uima, api, business_process__bpl_, ensemble, open_exchange, error_handling, trakcare, intersystems_iris_experience, odbc, analyzer, tutorial, iot, enterprise_message_bank, monitoring, oracle_enterprise_linux, intersystems_official, open_source, coding_guidelines, global_summit, cloud_experience, visualization, mirroring, containerization, security, mdx, node_js, change_management, iris_analytics__deepsee_, intersystems_data_platform_blog, continuous_delivery, multivalue_basic, job_wanted, javascript, azure, "multi-model", soap, mercurial, code_snippet, contest, intersystems_api_manager__iam_, relational_tables, journaling, callout, compiler, atelier_1_1_beta, alerts, worldwide_response_center__wrc_, cloud, cubes, microservices, databases, vscode, webinar, suse_linux, ubuntu, eclipse, digest, roles, css, online_learning, backup, centos, html, mapping, best_practices, angular2, failover, vue_js, objectscript, atelier_1_0, framework, _net_experience, graph, distributed_data_management, atelier_1_2_beta, cache_, interoperability, namespace, atelier, machine_learning, global_summit_2018, dashboards, tips___tricks, fhir, global_summit_2017, development_environment, localization, tools, events, iknow, react, angular, high_availability, deployment, github, document_data_model__nosql_, debugging, global_masters, system_administration, git, studio, python, xml, meetup, sql
  	FROM community.xtrain as xtrain
   	inner join
   	community.ytrain as ytrain
   	on
   	ytrain.id = xtrain.id
  
  
  
   SELECT c0, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52, c53, c54, c55, c56, c57, c58, c59, c60, c61, c62, c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103, c104, c105, c106, c107, c108, c109, c110, c111, c112, c113, c114, c115, c116, c117, c118, c119, c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156, c157, c158, c159, c160, c161, c162, c163, c164, c165, c166, c167, c168, c169, c170, c171, c172, c173, c174, c175, c176, c177, c178, c179, c180, c181, c182, c183, c184, c185, c186, c187, c188, c189, c190, c191, c192, c193, c194, c195, c196, c197, c198, c199, c200, c201, c202, c203, c204, c205, c206, c207, c208, c209, c210, c211, c212, c213, c214, c215, c216, c217, c218, c219, c220, c221, c222, c223, c224, c225, c226, c227, c228, c229, c230, c231, c232, c233, c234, c235, c236, c237, c238, c239, c240, c241, c242, c243, c244, c245, c246, c247, c248, c249, c250, c251, c252, c253, c254, c255, c256, c257, c258, c259, c260, c261, c262, c263, c264, c265, c266, c267, c268, c269, c270, c271, c272, c273, c274, c275, c276, c277, c278, c279, c280, c281, c282, c283, c284, c285, c286, c287, c288, c289, c290, c291, c292, c293, c294, c295, c296, c297, c298, c299, c300, c301, c302, c303, c304, c305, c306, c307, c308, c309, c310, c311, c312, c313, c314, c315, c316, c317, c318, c319, c320, c321, c322, c323, c324, c325, c326, c327, c328, c329, c330, c331, c332, c333, c334, c335, c336, c337, c338, c339, c340, c341, c342, c343, c344, c345, c346, c347, c348, c349, c350, c351, c352, c353, c354, c355, c356, c357, c358, c359, c360, c361, c362, c363, c364, c365, c366, c367, c368, c369, c370, c371, c372, c373, c374, c375, c376, c377, c378, c379, c380, c381, c382, c383, c384, c385, c386, c387, c388, c389, c390, c391, c392, c393, c394, c395, c396, c397, c398, c399, c400, c401, c402, c403, c404, c405, c406, c407, c408, c409, c410, c411, c412, c413, c414, c415, c416, c417, c418, c419, c420, c421, c422, c423, c424, c425, c426, c427, c428, c429, c430, c431, c432, c433, c434, c435, c436, c437, c438, c439, c440, c441, c442, c443, c444, c445, c446, c447, c448, c449, c450, c451, c452, c453, c454, c455, c456, c457, c458, c459, c460, c461, c462, c463, c464, c465, c466, c467, c468, c469, c470, c471, c472, c473, c474, c475, c476, c477, c478, c479, c480, c481, c482, c483, c484, c485, c486, c487, c488, c489, c490, c491, c492, c493, c494, c495, c496, c497, c498, c499, c500, c501, c502, c503, c504, c505, c506, c507, c508, c509, c510, c511, c512, c513, c514, c515, c516, c517, c518, c519, c520, c521, c522, c523, c524, c525, c526, c527, c528, c529, c530, c531, c532, c533, c534, c535, c536, c537, c538, c539, c540, c541, c542, c543, c544, c545, c546, c547, c548, c549, c550, c551, c552, c553, c554, c555, c556, c557, c558, c559, c560, c561, c562, c563, c564, c565, c566, c567, c568, c569, c570, c571, c572, c573, c574, c575, c576, c577, c578, c579, c580, c581, c582, c583, c584, c585, c586, c587, c588, c589, c590, c591, c592, c593, c594, c595, c596, c597, c598, c599, c600, c601, c602, c603, c604, c605, c606, c607, c608, c609, c610, c611, c612, c613, c614, c615, c616, c617, c618, c619, c620, c621, c622, c623, c624, c625, c626, c627, c628, c629, c630, c631, c632, c633, c634, c635, c636, c637, c638, c639, c640, c641, c642, c643, c644, c645, c646, c647, c648, c649, c650, c651, c652, c653, c654, c655, c656, c657, c658, c659, c660, c661, c662, c663, c664, c665, c666, c667, c668, c669, c670, c671, c672, c673, c674, c675, c676, c677, c678, c679, c680, c681, c682, c683, c684, c685, c686, c687, c688, c689, c690, c691, c692, c693, c694, c695, c696, c697, c698, c699, c700, c701, c702, c703, c704, c705, c706, c707, c708, c709, c710, c711, c712, c713, c714, c715, c716, c717, c718, c719, c720, c721, c722, c723, c724, c725, c726, c727, c728, c729, c730, c731, c732, c733, c734, c735, c736, c737, c738, c739, c740, c741, c742, c743, c744, c745, c746, c747, c748, c749, c750, c751, c752, c753, c754, c755, c756, c757, c758, c759, c760, c761, c762, c763, c764, c765, c766, c767, c768, c769, c770, c771, c772, c773, c774, c775, c776, c777, c778, c779, c780, c781, c782, c783, c784, c785, c786, c787, c788, c789, c790, c791, c792, c793, c794, c795, c796, c797, c798, c799, c800, c801, c802, c803, c804, c805, c806, c807, c808, c809, c810, c811, c812, c813, c814, c815, c816, c817, c818, c819, c820, c821, c822, c823, c824, c825, c826, c827, c828, c829, c830, c831, c832, c833, c834, c835, c836, c837, c838, c839, c840, c841, c842, c843, c844, c845, c846, c847, c848, c849, c850, c851, c852, c853, c854, c855, c856, c857, c858, c859, c860, c861, c862, c863, c864, c865, c866, c867, c868, c869, c870, c871, c872, c873, c874, c875, c876, c877, c878, c879, c880, c881, c882, c883, c884, c885, c886, c887, c888, c889, c890, c891, c892, c893, c894, c895, c896, c897, c898, c899, languages, microsoft_windows, ui_development, atelier_1_1, application_server, atelier_1_0_beta, zen, beginner, globals, business_operation, other, objectscript_package_manager, analytics, caretdev, architect, dtl, business_service, csp, field_tests, unstructured_data, testing, c__, developer_community, management_portal, json, message_search, podcast, data_model, business_rules, intersystems_iris, kubernetes, video, database_transaction_processing, intersystems_iris_for_health, "authorization", george_james_software, authentication, rest_api, ssl, documentation, _net, job_opportunity, oauth2, continuous_integration, sharding, hl7, developer_community_faq, ecp, healthshare, frontend, big_data, devops, big_data_experience, listings, microsoft_windows_server, apple_macos, aws, svn, global_summit_2016, ifind, java_experience, terminal, ftp, issue_tracking, indexing, ldap, atelier_1_2, atelier_1_3, ai, java, platforms, key_value, global_summit_2019, users, intersystems_partner, object_data_model, perforce, certification, jdbc, encryption, red_hat_enterprise_linux__rhel_, release, openvms, compatibility, dc_feedback, docker, performance, gcp, uima, api, business_process__bpl_, ensemble, open_exchange, error_handling, trakcare, intersystems_iris_experience, odbc, analyzer, tutorial, iot, enterprise_message_bank, monitoring, oracle_enterprise_linux, intersystems_official, open_source, coding_guidelines, global_summit, cloud_experience, visualization, mirroring, containerization, security, mdx, node_js, change_management, iris_analytics__deepsee_, intersystems_data_platform_blog, continuous_delivery, multivalue_basic, job_wanted, javascript, azure, "multi-model", soap, mercurial, code_snippet, contest, intersystems_api_manager__iam_, relational_tables, journaling, callout, compiler, atelier_1_1_beta, alerts, worldwide_response_center__wrc_, cloud, cubes, microservices, databases, vscode, webinar, suse_linux, ubuntu, eclipse, digest, roles, css, online_learning, backup, centos, html, mapping, best_practices, angular2, failover, vue_js, objectscript, atelier_1_0, framework, _net_experience, graph, distributed_data_management, atelier_1_2_beta, cache_, interoperability, namespace, atelier, machine_learning, global_summit_2018, dashboards, tips___tricks, fhir, global_summit_2017, development_environment, localization, tools, events, iknow, react, angular, high_availability, deployment, github, document_data_model__nosql_, debugging, global_masters, system_administration, git, studio, python, xml, meetup, sql FROM community.xtest as xtest inner join community.ytest as ytest on ytest.id = xtest.id
  
  
  
  SELECT ID, c0, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, c52, c53, c54, c55, c56, c57, c58, c59, c60, c61, c62, c63, c64, c65, c66, c67, c68, c69, c70, c71, c72, c73, c74, c75, c76, c77, c78, c79, c80, c81, c82, c83, c84, c85, c86, c87, c88, c89, c90, c91, c92, c93, c94, c95, c96, c97, c98, c99, c100, c101, c102, c103, c104, c105, c106, c107, c108, c109, c110, c111, c112, c113, c114, c115, c116, c117, c118, c119, c120, c121, c122, c123, c124, c125, c126, c127, c128, c129, c130, c131, c132, c133, c134, c135, c136, c137, c138, c139, c140, c141, c142, c143, c144, c145, c146, c147, c148, c149, c150, c151, c152, c153, c154, c155, c156, c157, c158, c159, c160, c161, c162, c163, c164, c165, c166, c167, c168, c169, c170, c171, c172, c173, c174, c175, c176, c177, c178, c179, c180, c181, c182, c183, c184, c185, c186, c187, c188, c189, c190, c191, c192, c193, c194, c195, c196, c197, c198, c199, c200, c201, c202, c203, c204, c205, c206, c207, c208, c209, c210, c211, c212, c213, c214, c215, c216, c217, c218, c219, c220, c221, c222, c223, c224, c225, c226, c227, c228, c229, c230, c231, c232, c233, c234, c235, c236, c237, c238, c239, c240, c241, c242, c243, c244, c245, c246, c247, c248, c249, c250, c251, c252, c253, c254, c255, c256, c257, c258, c259, c260, c261, c262, c263, c264, c265, c266, c267, c268, c269, c270, c271, c272, c273, c274, c275, c276, c277, c278, c279, c280, c281, c282, c283, c284, c285, c286, c287, c288, c289, c290, c291, c292, c293, c294, c295, c296, c297, c298, c299, c300, c301, c302, c303, c304, c305, c306, c307, c308, c309, c310, c311, c312, c313, c314, c315, c316, c317, c318, c319, c320, c321, c322, c323, c324, c325, c326, c327, c328, c329, c330, c331, c332, c333, c334, c335, c336, c337, c338, c339, c340, c341, c342, c343, c344, c345, c346, c347, c348, c349, c350, c351, c352, c353, c354, c355, c356, c357, c358, c359, c360, c361, c362, c363, c364, c365, c366, c367, c368, c369, c370, c371, c372, c373, c374, c375, c376, c377, c378, c379, c380, c381, c382, c383, c384, c385, c386, c387, c388, c389, c390, c391, c392, c393, c394, c395, c396, c397, c398, c399, c400, c401, c402, c403, c404, c405, c406, c407, c408, c409, c410, c411, c412, c413, c414, c415, c416, c417, c418, c419, c420, c421, c422, c423, c424, c425, c426, c427, c428, c429, c430, c431, c432, c433, c434, c435, c436, c437, c438, c439, c440, c441, c442, c443, c444, c445, c446, c447, c448, c449, c450, c451, c452, c453, c454, c455, c456, c457, c458, c459, c460, c461, c462, c463, c464, c465, c466, c467, c468, c469, c470, c471, c472, c473, c474, c475, c476, c477, c478, c479, c480, c481, c482, c483, c484, c485, c486, c487, c488, c489, c490, c491, c492, c493, c494, c495, c496, c497, c498, c499, c500, c501, c502, c503, c504, c505, c506, c507, c508, c509, c510, c511, c512, c513, c514, c515, c516, c517, c518, c519, c520, c521, c522, c523, c524, c525, c526, c527, c528, c529, c530, c531, c532, c533, c534, c535, c536, c537, c538, c539, c540, c541, c542, c543, c544, c545, c546, c547, c548, c549, c550, c551, c552, c553, c554, c555, c556, c557, c558, c559, c560, c561, c562, c563, c564, c565, c566, c567, c568, c569, c570, c571, c572, c573, c574, c575, c576, c577, c578, c579, c580, c581, c582, c583, c584, c585, c586, c587, c588, c589, c590, c591, c592, c593, c594, c595, c596, c597, c598, c599, c600, c601, c602, c603, c604, c605, c606, c607, c608, c609, c610, c611, c612, c613, c614, c615, c616, c617, c618, c619, c620, c621, c622, c623, c624, c625, c626, c627, c628, c629, c630, c631, c632, c633, c634, c635, c636, c637, c638, c639, c640, c641, c642, c643, c644, c645, c646, c647, c648, c649, c650, c651, c652, c653, c654, c655, c656, c657, c658, c659, c660, c661, c662, c663, c664, c665, c666, c667, c668, c669, c670, c671, c672, c673, c674, c675, c676, c677, c678, c679, c680, c681, c682, c683, c684, c685, c686, c687, c688, c689, c690, c691, c692, c693, c694, c695, c696, c697, c698, c699, c700, c701, c702, c703, c704, c705, c706, c707, c708, c709, c710, c711, c712, c713, c714, c715, c716, c717, c718, c719, c720, c721, c722, c723, c724, c725, c726, c727, c728, c729, c730, c731, c732, c733, c734, c735, c736, c737, c738, c739, c740, c741, c742, c743, c744, c745, c746, c747, c748, c749, c750, c751, c752, c753, c754, c755, c756, c757, c758, c759, c760, c761, c762, c763, c764, c765, c766, c767, c768, c769, c770, c771, c772, c773, c774, c775, c776, c777, c778, c779, c780, c781, c782, c783, c784, c785, c786, c787, c788, c789, c790, c791, c792, c793, c794, c795, c796, c797, c798, c799, c800, c801, c802, c803, c804, c805, c806, c807, c808, c809, c810, c811, c812, c813, c814, c815, c816, c817, c818, c819, c820, c821, c822, c823, c824, c825, c826, c827, c828, c829, c830, c831, c832, c833, c834, c835, c836, c837, c838, c839, c840, c841, c842, c843, c844, c845, c846, c847, c848, c849, c850, c851, c852, c853, c854, c855, c856, c857, c858, c859, c860, c861, c862, c863, c864, c865, c866, c867, c868, c869, c870, c871, c872, c873, c874, c875, c876, c877, c878, c879, c880, c881, c882, c883, c884, c885, c886, c887, c888, c889, c890, c891, c892, c893, c894, c895, c896, c897, c898, c899FROM community.xtest