Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language
DECLARE @NumPosts INT = ##NumPosts?100## CREATE TABLE #LanguageTags ( TagName NVARCHAR(256) COLLATE SQL_Latin1_General_CP1_CS_AS ); INSERT INTO #LanguageTags (TagName) VALUES ('<.htaccess>'), ('<abap>'), ('<actionscript>'), ('<actionscript-3>'), ('<ada>'), ('<agda>'), ('<alloy>'), ('<ansible>'), ('<apl>'), ('<applescript>'), ('<arduino>'), ('<arnoldc>'), ('<asm.js>'), ('<assembly>'), ('<autohotkey>'), ('<autoit>'), ('<awk>'), ('<bash>'), ('<basic>'), ('<basic-lang>'), ('<batch>'), ('<befunge>'), ('<brainfuck>'), ('<c>'), ('<c#>'), ('<c++>'), ('<c++-cli>'), ('<cfml>'), ('<chuck>'), ('<clojure>'), ('<clojurescript>'), ('<cmake>'), ('<cobol>'), ('<coffeescript>'), ('<common-lisp>'), ('<coq>'), ('<cql>'), ('<crystal>'), ('<csh>'), ('<css>'), ('<css3>'), ('<cucumber>'), ('<cython>'), ('<d>'), ('<dart>'), ('<delphi>'), ('<delphi-xe>'), ('<dockerfile>'), ('<dogescript>'), ('<dot>'), ('<dot-lang>'), ('<dxl>'), ('<ebuild>'), ('<ecmascript-6>'), ('<elisp>'), ('<elixir>'), ('<elm>'), ('<erlang>'), ('<excel>'), ('<f#>'), ('<factor>'), ('<factor-lang>'), ('<filemaker>'), ('<fish>'), ('<fish-lang>'), ('<flex>'), ('<forth>'), ('<fortran>'), ('<freezeflame>'), ('<function-block-diagram>'), ('<gamemaker>'), ('<gdscript>'), ('<glsl>'), ('<gml>'), ('<go>'), ('<google-apps-script>'), ('<gradle>'), ('<groovy>'), ('<haml>'), ('<haskell>'), ('<haxe>'), ('<hdl>'), ('<hlsl>'), ('<html>'), ('<html5>'), ('<hy>'), ('<ibm-rpg>'), ('<idris>'), ('<interactive-data-language>'), ('<io>'), ('<io-lang>'), ('<j>'), ('<java>'), ('<javascript>'), ('<json>'), ('<jsx>'), ('<julia>'), ('<jython>'), ('<kotlin>'), ('<ksh>'), ('<lc-3>'), ('<less-css>'), ('<lex>'), ('<lilypond>'), ('<lisp>'), ('<logo>'), ('<logo-lang>'), ('<lolcode>'), ('<lua>'), ('<m4>'), ('<make>'), ('<makefile>'), ('<markdown>'), ('<matlab>'), ('<maxscript>'), ('<mongodb-query>'), ('<netlogo>'), ('<nginx>'), ('<nim>'), ('<nusmv>'), ('<object-pascal>'), ('<objective-c>'), ('<objective-c++>'), ('<ocaml>'), ('<octave>'), ('<pari-gp>'), ('<pascal>'), ('<pascal-script>'), ('<pawn>'), ('<perl>'), ('<perl6>'), ('<php>'), ('<php5>'), ('<plpgsql>'), ('<postscript>'), ('<powershell>'), ('<processing>'), ('<processing.js>'), ('<progress-4gl>'), ('<prolog>'), ('<purescript>'), ('<pyth>'), ('<python>'), ('<qasm>'), ('<qml>'), ('<r>'), ('<racket>'), ('<raku>'), ('<razor>'), ('<red>'), ('<red-lang>'), ('<rc>'), ('<rebol>'), ('<rebol2>'), ('<red-lang>'), ('<regex>'), ('<robotframework>'), ('<rpython>'), ('<ruby>'), ('<rust>'), ('<salesforce-apex>'), ('<sas>'), ('<sass>'), ('<scala>'), ('<scheme>'), ('<scratch>'), ('<scss>'), ('<sh>'), ('<shell>'), ('<siebel-escript>'), ('<simulink>'), ('<sinatra>'), ('<smalltalk>'), ('<sml>'), ('<snobol4>'), ('<solidity>'), ('<sputnik>'), ('<sql>'), ('<structured-text>'), ('<svg>'), ('<swift>'), ('<tcl>'), ('<tcsh>'), ('<tex>'), ('<ti-basic>'), ('<typescript>'), ('<unrealscript>'), ('<vb.net>'), ('<vb6>'), ('<vba>'), ('<vbscript>'), ('<verilog>'), ('<vhdl>'), ('<vimscript>'), ('<visual-foxpro>'), ('<whitespace>'), ('<whitespace-lang>'), ('<wolfram-mathematica>'), ('<wren>'), ('<xaml>'), ('<xml>'), ('<xslt>'), ('<yacc>'), ('<yaml>'), ('<zsh>'); SELECT DISTINCT TOP (@NumPosts) p.Id AS [Post Link] , p.Tags , p.CreationDate AS [Created] FROM Posts AS p LEFT JOIN #LanguageTags AS lt ON p.Tags LIKE '%' + lt.TagName + '%' WHERE p.ClosedDate IS NULL AND lt.TagName IS NULL AND p.PostTypeId = 1