Mapping dictionary value to list

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

SELECT 
    Id,
    Body,
    CreationDate
FROM 
    Posts 
WHERE
ID in (33078554,
 18449360,
 10124751,
 8671280,
 42193712,
 29710357,
 14509192,
 9089043,
 17547507,
 50041661,
 1798796,
 5655708,
 2052111,
 7085512,
 4950155,
 34617451,
 2036772,
 11939207,
 328851,
 739882,
 4230000,
 327483,
 21572914,
 1958417,
 1031199,
 6507431,
 3252528,
 2134539,
 1044854,
 18931315,
 26515595,
 13130574,
 19838976,
 21674331,
 3296499,
 9495262,
 10024646,
 2597104,
 11486148,
 7934547,
 644821,
 2745018,
 4710142,
 3750632,
 1185634,
 13065426,
 6589814,
 3221475,
 7642434,
 16138015,
 36628586,
 20420934,
 8568233,
 16017811,
 39144498,
 6709693,
 49949814,
 54962869,
 29818519,
 15456158,
 19883015,
 32156515,
 2755849,
 7631929,
 18807079,
 4560804,
 29947844,
 14374181,
 6490560,
 3820506,
 1682567,
 2347388,
 11600628,
 6793872,
 3867718,
 30241688,
 33331732,
 1813117,
 49184578,
 44706935,
 5527630,
 37018085,
 34210969,
 29715501,
 3953233,
 2245161,
 24654183,
 11290092,
 5828123,
 58695905,
 19620498,
 4544630,
 2916374,
 4747397,
 16380326,
 8550912,
 3354313,
 7369247,
 59131184,
 16686292,
 4418741,
 3289430,
 20637970,
 10084517,
 8546245,
 1811095,
 5506511,
 25105541,
 12097929,
 7745562,
 48140225,
 49000803,
 60848,
 11358411,
 9728243,
 11726633,
 1072649,
 2974022,
 30280856,
 21598872,
 2621674,
 42034,
 3977310,
 3313590,
 7296716,
 4440516,
 2320945,
 16910330,
 3901144,
 6229671,
 261655,
 32000934,
 875074,
 8634700,
 772922,
 2213334,
 5737224,
 30818694,
 8519599,
 15743125,
 13400876,
 13636640,
 8500374,
 9751554,
 12920214,
 43206541,
 3666237,
 11068986,
 1957396,
 3738381,
 28841735,
 14667578,
 937000,
 5617159,
 6191672,
 10759099,
 52390125,
 34308337,
 41063744,
 40230749,
 2196956,
 407734,
 11399026,
 20577840,
 9305751,
 1060090,
 1550134,
 323750,
 12894795,
 3352862,
 15081516,
 5772148,
 9027862,
 37164127,
 29063868,
 14532875,
 10498132,
 23252370,
 36533553,
 20968823,
 29216889,
 27073596,
 2425272,
 9317025,
 3523048,
 25148611,
 9806963,
 3369640,
 21514631,
 21510140,
 4019639,
 24017363,
 1975250,
 13626524,
 17217225,
 8929005,
 22949232,
 47452513,
 1233546,
 14797046,
 1762484,
 9285086,
 4726949,
 1531402,
 1280667,
 2449077,
 2035423,
 16326853,
 1409295,
 29747224,
 37606159,
 11740814,
 58927718,
 15647690,
 19555472,
 638048,
 9390126,
 62793544,
 8297723,
 19022868,
 15526883,
 7293978,
 1045344,
 4131864,
 10564801,
 15715912,
 11125212,
 5134893,
 1855558,
 10461531,
 628192,
 30902558,
 263457,
 10067013,
 2388302,
 16686788,
 8106900,
 10840901,
 7876272,
 9139897,
 35719560,
 10480806,
 3210832,
 5010536,
 3232953,
 7633274,
 5262406,
 3405715,
 19454970,
 41221874,
 20592808,
 35253971,
 58740839,
 12213430,
 6560354,
 11902665,
 5103329,
 14323045,
 62864163,
 10735282,
 8628123,
 18634650,
 2749796,
 5119709,
 17497067,
 3416401,
 1600591,
 25854380,
 9289614,
 19502378,
 5805892,
 2785954,
 33327602,
 14422409,
 24872745,
 6791198,
 1392396,
 5824382,
 15181867,
 21444338,
 25054003,
 13052857,
 27715692,
 5314241,
 1593564,
 5986860,
 3209233,
 7026131,
 54109167,
 9858096,
 19736058,
 6130211,
 11498441,
 7255383,
 31087111,
 4291236,
 5908420,
 13303100,
 16099694,
 24271961,
 44574485,
 17671875,
 1015592,
 4752294,
 2094658,
 2672936,
 8403681,
 4326553,
 35619544,
 4446380,
 13687924,
 2170900,
 12117080,
 17106819,
 21662532,
 869778,
 5453979,
 12477823,
 24746712,
 11328940,
 10806866,
 19993795,
 6332691,
 11632905,
 22496657,
 9028036,
 4021154,
 11174745,
 6405208,
 10035752,
 9990177,
 54459155,
 6517953,
 1815316,
 27654671,
 1235618,
 19415614,
 22614980,
 7489219,
 10139866,
 16003408,
 23048129,
 51961712,
 12080552,
 925100,
 1711756,
 9761396,
 37639363,
 10004850,
 19300174,
 12354515,
 3419147,
 39644638,
 6083531,
 7944054,
 20816600,
 10043963,
 17944235,
 18454570,
 4838504,
 1911273,
 6304808,
 10364391,
 11089655,
 4761041,
 5333898,
 15189245,
 54474299,
 47832762,
 10664856,
 2460087,
 1436444,
 18084476,
 16367848,
 1495510,
 3752618,
 8951020,
 8641008,
 3726338,
 3222251,
 36877715,
 7522533,
 1091756,
 21962763,
 9504638,
 18851325,
 1198512,
 20356401,
 45114985,
 17793364,
 2582911,
 526125,
 22464900,
 5444394,
 396421,
 34370599,
 1983,
 6456718,
 21682804,
 2361945,
 10617045,
 11247439,
 17331126,
 6688223,
 19482730,
 6340351,
 299704,
 27802270,
 3443607,
 738467,
 20672238,
 546479,
 3415072,
 2186656,
 11194110,
 3325343,
 2947872,
 21351275,
 22054698,
 4300738,
 11692613,
 10399614,
 173290,
 54095279,
 1442782,
 1162592,
 901892,
 5316720,
 19560044,
 1401933,
 8312829,
 21270320,
 1549509,
 30964577,
 45971743,
 58378549,
 5453026,
 8731231,
 21222506,
 3498275,
 26190160,
 57453407,
 6405512,
 24180879,
 32490721,
 23868093,
 2597166,
 19767891,
 10613131,
 10810926,
 7053652,
 41698247,
 13312043,
 872973,
 14779686,
 11318977,
 55723664,
 12281469,
 13063691,
 19862116,
 23525603,
 11677860,
 19030179,
 4348232,
 18090672,
 3733992,
 34224896,
 10123853,
 4187564,
 29348345,
 6492096,
 26783326,
 10091957,
 12988351,
 19211828,
 25004347,
 35262673,
 6913084,
 1319214,
 40307139,
 31484585,
 43821195,
 25200763,
 37845872,
 26514179,
 2662140,
 5462047,
 2218238,
 16513573,
 58309803,
 42874825,
 6605279,
 1032281,
 47464211,
 17149561,
 8060751,
 22161717,
 5226572,
 33797126,
 14783947,
 3673337,
 1573548,
 33137741,
 4095319,
 4527454,
 2626059,
 6764909,
 7313157,
 37895568,
 30622809,
 12846054,
 5851753,
 15124833,
 11157043,
 4143698,
 19121722,
 1534939,
 16632124,
 6009589,
 8122627,
 38265839,
 14529523,
 11492656,
 56135864,
 11747254,
 89178,
 327534,
 20920956,
 13675942,
 863935,
 13070461,
 10610158,
 2285874,
 33686747,
 22800028,
 26151669,
 10823610,
 7809698,
 1663995,
 1156087,
 32127908,
 3720740,
 12749622,
 9642087,
 33709331,
 23038756,
 6757192,
 18989362,
 10239668,
 51950193,
 10162679,
 16384109,
 15269161,
 7340019,
 643823,
 10018679,
 1835787,
 16789776,
 44633798,
 28156687,
 7081448,
 54223703,
 5399190,
 3954530,
 55140208,
 6645357,
 35180377,
 35557693,
 47045220,
 1257413,
 4907263,
 3067529,
 6634708,
 13462365,
 2609518,
 17218139,
 29974455,
 2401447,
 2231663,
 4992739,
 42334197,
 63472161,
 8494514,
 19727088,
 1080026,
 19629682,
 15751979,
 15062844,
 16418415,
 53513,
 1602934,
 1712227,
 3061,
 493819,
 627435,
 9573244,
 931092,
 209840,
 3940128,
 626759,
 8369219,
 11520492,
 2793324,
 1323410,
 1207406,
 3702675,
 5618878,
 988228,
 715417,
 251464,
 1896918,
 4990718,
 3845423,
 11041405,
 432842,
 8023306,
 7368789,
 4843158,
 492387,
 855759,
 10712002,
 1305532,
 44778,
 1894269,
 2294493,
 8009882,
 15478127,
 3420122,
 538346,
 3097866,
 1653970,
 11011756,
 577234,
 8424942,
 3559559,
 2504411,
 59825,
 3323001,
 10695139,
 1535596,
 4481724,
 23177439,
 1038824,
 7983820,
 1228299,
 6294179,
 4319825,
 1388818,
 1157106,
 4211209,
 18265935,
 9572490,
 1400608,
 16228248,
 8930915,
 1276764,
 5595425,
 3295938,
 9868653,
 713794,
 327311,
 3489071,
 3590165,
 633127,
 497765,
 473099,
 172439,
 1380860,
 431866,
 106896,
 1801668,
 4915920,
 3162271,
 4130027,
 2150108,
 2241891,
 2960772,
 1306631,
 3653298,
 3428536,
 2464959,
 12572362,
 983699,
 6531482,
 25231989,
 18351951,
 2553354,
 242485,
 960733,
 36117583,
 16296643,
 2853683,
 5389507,
 30362391,
 10666163,
 2493920,
 21583758,
 3346230,
 8899905,
 13840379,
 803616,
 850795,
 1876191,
 4932438,
 2611892,
 1679384,
 6095717,
 19859282,
 126524,
 2050637,
 4576115,
 6486450,
 8177079,
 10116518,
 7271482,
 16579085,
 4929251,
 2124190,
 930995,
 20196159,
 20461847,
 3371269,
 5188792,
 4901815,
 18425225,
 33072570,
 6190331,
 12791501,
 9138112,
 5319922,
 12142133,
 7558908,
 26660654,
 128573,
 6027558,
 604802,
 8900166,
 15768757,
 1403674,
 3395138,
 17429123,
 1518522,
 5969806,
 4945548,
 847936,
 364621,
 12813633,
 369898,
 1623039,
 6103825,
 11178061,
 5254445,
 15046242,
 9427163,
 11092511,
 5036700,
 3136689,
 3136059,
 6822725,
 1424005,
 658763,
 1798465,
 3783530,
 1316887,
 1249388,
 120926,
 817087,
 3869487,
 15263597,
 2864842,
 599953,
 1680528,
 41125909,
 14692690,
 2492087,
 26924836,
 5387208,
 1450897,
 2556108,
 2174124,
 7872838,
 1919044,
 32085675,
 12646326,
 2451821,
 19473185,
 2514961,
 16348815,
 8995611,
 9987483,
 21388541,
 16522111,
 5309978,
 10631473,
 14029245,
 11303225,
 5473014,
 6586310,
 3694371,
 10373247,
 17353213,
 11458239,
 18648626,
 900392,
 3221891,
 12723751,
 9792664,
 8609153,
 3271478,
 3897499,
 6031584,
 20840803,
 12851791,
 7992559,
 10756427,
 2414667,
 5446964,
 8389639,
 1319338,
 5404665,
 12118695,
 11806559,
 4393268,
 2400840,
 1342601,
 284043,
 9989334,
 1725517,
 13779526,
 2736144,
 4014621,
 6522446,
 3308102,
 5447494,
 783897,
 4798654,
 11414894,
 42611593,
 7971618,
 1481488,
 8081545,
 30147165,
 2238355,
 1748641,
 78799,
 11902458,
 7361253,
 6568007,
 3173154,
 17511270,
 5629023,
 2568673,
 6943182,
 3431676,
 497885,
 7351744,
 4045161,
 19641579,
 11367902,
 8266529,
 15672151,
 1031851,
 3179106,
 5445970,
 7030831,
 2152898,
 42315072,
 15837729,
 1990802,
 8222855,
 44315961,
 9437726,
 4109552,
 2799064,
 13145368,
 2191890,
 2681243,
 7271385,
 4800811,
 6148619,
 14560863,
 8848294,
 4654414,
 7692324,
 1607612,
 4630465,
 11509721,
 3754620,
 35166633,
 21448225,
 6777485,
 10775894,
 21732123,
 4518641,
 3829742,
 7946798,
 4732827,
 2390827,
 8169001,
 475871,
 55684960,
 5244810,
 201461,
 1739913,
 22511792,
 14305941,
 6022764,
 5944708,
 2765892,
 45053461,
 7539115,
 2236906,
 9090079,
 4913397,
 9072844,
 6900955,
 17299581,
 18159911,
 8672754,
 1938614,
 1038160,
 3873361,
 3972872,
 5387299,
 10665591,
 36459969,
 2315520,
 5924879,
 2311510,
 11380413,
 6584871,
 8951255,
 8420143,
 10632839,
 1927544,
 752373,
 5628084,
 9271712,
 1731971,
 43491287,
 6569528,
 13884177,
 3953371,
 3668964,
 28845284,
 215581,
 4022827,
 3215168,
 14849293,
 2601047,
 3787908,
 19476816,
 36674083,
 5558418,
 914233,
 6631128,
 21611559,
 1619514,
 4842956,
 5369723,
 3663450,
 7587457,
 9056833,
 5415,
 3840843,
 3174392,
 25082410,
 2104305,
 10543303,
 1969240,
 1534504,
 5182573,
 10319147,
 20639180,
 3877623,
 24204087,
 18533620,
 14785495,
 44352,
 479343,
 544919,
 1465662,
 5811463,
 13712229,
 17634177,
 23286254,
 36640673,
 38806202,
 427453,
 497426,
 1016814,
 1165352,
 1167398,
 1285911,
 2541401,
 3229419,
 6828722,
 8929284,
 14320909,
 3026813)

union all

select Id, Body, CreationDate 
from  PostsWithDeleted
where Id = 3026813

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results