meta-stackoverflow-com-questions-405196

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @json nvarchar(max)
set @json = '[65854898,62162017,62523167,59228570,65361297,59095947,65315060,65413862,65991478,59007638,65762402,61735946,58615114,65789638,59268205,58575188,58894386,61376395,65863692,65970625,59335981,61487996,58874102,62855018,15728744,62985091,63346544,64213364,63251448,64732905,65025735,65447155,65439238,64669915,64847355,65144330,65442257,64637832,66052543,63072273,64717056,65449686,58494879,58573682,60279949,61148674,61506613,60727385,60025865,60243668,60620655,60158985,61875699,59125109,60747856,60803363,61701958,58391817,60727100,59977179,60320570,60727399,61979566,60027756,61037561,58494879,58573682,58368152,58379649,58562006,58435030,62252239,64742473,65092978,65540463,62484171,65628683,63000718,63830794,65596761,62367370,64339380,64457355,65450252,64527757,65710773,59344880,59725033,58394208,58466973,59002086,59654666,59215654,60793818,61885692,60328351,59275175,59336987,57474779,58905498,59022847,58366753,62198284,60866274,60938962,58904121,60242637,60772583,61330016,59222323,60289999,61800582,60876676,61540188,65415668,65609066,63972717,62501374,62716387,65541233,64566905,65258718,65146241,65220175,64721083,65141665,65259785,62433037,66035921,58283903,59339449,58921964,58540091,58564214,59469682,60047165,59265285,59400504,59470906,59400504,59470906,59722294,59119577,59471993,59509255,58500757,58476252,59977451,58902241,59041398,61333857,61642205,58540091,60303680,60728463,61156113,60576914,58564214,59469682,61021793,61148923,60817015,61161703,62050129,60803786,63092158,63255217,63954436,64880794,65339098,64597026,64175096,65597702,63752786,63034370,63314617,63587096,63928613,64823528,65635415,58398648,65841018,59307039,59344880,58884680,60120746,60122429,60316761,57673718,58077595,59793893,60065441,62224916,62260139,61442085,61539767,61561336,61045905,60805569,60837040,60862122,66089918,64529051,65522713,62537006,62758549,63448692,63962008,64741415,65297633,62502789,62774662,64078456,64933109,64632584,61960612,61541199,61317603,61346354,60906944,60817015,64791411,59178766,59448283,58475386,58923054,58885104,59803475,58931656,60020668,59493401,58289778,58283389,59093115,60862122,66089918,64529051,65522713,62537006,62758549,63448692,63962008,64741415,65297633,62502789,62774662,64078456,64933109,64632584,61960612,61541199,61317603,61346354,60906944,60817015,64791411,59178766,59448283,58475386,58923054,58885104,59803475,58931656,60020668,59493401,58289778,58283389,59093115,60461043,63892654,30490951,62735590,62360292,64518803,64612589,65719332,64653580,65439912,62621336,63076314,63859396,64948339,59022665,59470361,60675747,60761087,61000980,59439386,60570956,60591824,59721187,60722809,60728463,58340190,58224490,58367693,61272200,61014558,61513946,61917231,65042649,64266637,62496479,63754169,65254409,65266801,65907832,64783352,65051110,62734907,64844917,65801090,59717110,58487506,59125308,59601744,59007113,59504948,59364722,58484158,59721187,60966148,59023711,61507723,61193162,60695430,60306900,60224963,60384513,62004368,60240353,60695430,60306900,60224963,60384513,62004368,63565210,63937874,64518720,63849167,63494164,64418574,62582725,65372358,65754839,63075795,58898873,59087944,58306134,58373687,58901546,59738046,59801809,59973154,10317603,59707411,59957284,58441622,58370508,59471197,58922912,59479958,58957183,59479397,59497234,58241198,60139101,59382479,61182548,61752301,61513036,60514392,60755723,62222494,62246899,60778500,60797368,61301390,61974009,60796516,63075795,59707411,59957284,59087944,58306134,58373687,58901546,59738046,59801809,59973154,10317603,58441622,58898873,58370508,59471197,58922912,59479958,58957183,59479397,59497234,58241198,60139101,59382479,62222494,62201494,62246899,61974009,62120363,61513036,61752301,61301390,61182548,60755723,60778500,60797368,60796516,60514392,65065572,64942124,63952184,64260568,64560175,63748104,65867662,65092965,62627487,58309922,58309922,58565807,58234253,59494441,60819596,60847955,61013165,61142631,61962877,58304123,58875938,59227507,59471227,58310960,59269442,59127553,60177373,61718846,61443352,61328270,60580038,61704637,60478656,60652083,60442069,63673541,65173590,65441681,64194466,63200289,63092862,64140054,64188879,64797178,62759453,64344189,63973091,62412194,65152224,65859181,64837454,65384664,66102500,53882552,58997812,58616312,58956946,58051744,56947577,60781536,66178889,60354239,58441315,60791142,61560364,59648431,59101108,53882552,58250685,59802099,58559895,59383061,58977536,58466326,59459656,60025638,61288984,60460734,60742988,61173972,60652083,61345387,61508126,61738032,61899240,61979566,63273734,63891111,64291243,62715822,62812207,64856862,64992983,65134181,64750816,64804791,65135157,58400487,58389694,58304123,57974686,59158555,58522528,58496972,61982886,62011587,62348315,62107895,60725312,61149119,59602896,61081764,60493591,60580038,60792560,61560702,59348821,59804517,60960931,60423535,61186606,61364299,64857193,58885712,65463621,64756899,64721210,64739069,65160558,63209494,64952274,63431069,62981861,63630903,60549051,61059803,61291089,62184012,58311779,62196850,60491991,61619955,61347730,60268241,60677275,60903129,62177076,58792287,58441866,58419812,58402007,59831343,58616302,58905675,59255543,60854850,60452619,60066576,60450979,61143795,61544136,65841018,65783532,64626112,64233750,65184506,65097912,64918199,65237190,65446558,63314893,65242514,62855089,63440434,62739974,63526858,64720194,65097983,62308804,62075573,62252881,61752474,61740496,61289638,61431296,61044677,61163029,61161034,58786316,59128104,59805048,60240046,60339525,60265730,58453232,58355160,59698333,60341187,58422084,59052629,60016007,60786592,59338804,60132382,60986298,60350840,60693393,60755820,56957919,59237735,60580038,60748113,59902928,59937671,58367170]
'

select concat('site://q/', pwd.id, '| Accepted Answer ', pwd.id) [Link]
from votes v
inner join postswithdeleted pwd on pwd.id = v.postid
inner join OpenJson(@json) sel on (sel.value = pwd.id or sel.value = pwd.parentid)
where votetypeid = 1
and pwd.deletiondate is not null

Enter Parameters

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