0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

-- 주어진 번호에 해당하는 질문과 그 답변을 조회
SELECT
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.Body AS QuestionBody,
    q.AnswerCount,
    q.CommentCount,
    q.CreationDate AS QuestionCreationDate,
    q.FavoriteCount,
    q.LastActivityDate AS QuestionLastActivityDate,
    q.LastEditDate AS QuestionLastEditDate,
    q.LastEditorDisplayName AS QuestionLastEditorDisplayName,
    q.LastEditorUserId AS QuestionLastEditorUserId,
    q.OwnerDisplayName AS QuestionOwnerDisplayName,
    q.OwnerUserId AS QuestionOwnerUserId,
    q.Score AS QuestionScore,
    q.Tags AS QuestionTags,
    q.ViewCount AS QuestionViewCount,
    a.Id AS AnswerId,
    a.CreationDate AS AnswerCreationDate,
    a.Score AS AnswerScore,
    a.Body AS AnswerBody
FROM
    Posts q
INNER JOIN
    Posts a ON q.Id = a.ParentId
WHERE
    q.PostTypeId = 1
    AND a.PostTypeId = 2
    AND q.Id IN (27929, 177092, 11083, 29515, 48994, 111121, 178771, 201906, 11204, 29735, 79744, 79770, 
    79816, 149200, 178772, 178780, 225526, 79864, 111179, 149337, 149261, 201934, 202008, 244012, 
    268626, 29745, 49145, 49163, 111206, 29798, 111226, 149353, 49184, 111398, 202556, 49319, 49465, 
    112108, 112086, 149466, 29930, 202575, 202588, 11369, 149551, 244073, 112184, 112191, 178881, 
    202802, 226028, 244300, 259792, 10974, 48415, 79023, 110181, 148135, 148184, 148052, 177287, 
    177351, 177390, 268341, 49498, 79873, 112327, 112376, 29937, 49571, 79910, 79976, 112742, 149721, 
    202891, 244341, 259950, 11391, 30516, 49572, 49647, 80233, 80131, 80359, 80429, 178882, 202902, 
    227026, 80485, 149874, 203105, 227346, 227155, 268821, 268741, 11441, 80510, 149931, 149892, 
    259963, 11623, 49674, 150139, 244742, 268840, 11683, 30701, 30723, 150505, 150270, 80589, 179035, 
    30782, 49771, 49851, 80608, 112892, 244819, 244795, 80622, 113098, 113110, 113046, 150589, 227364, 
    244910, 48431, 110481, 110331, 148362, 177958, 243935, 11795, 31160, 30940, 50993, 51039, 80627, 
    80624, 150687, 179079, 203387, 203403, 203429, 227429, 51105, 51203, 80663, 113296, 150810, 
    150813, 179091, 179183, 179302, 244993, 178170, 201652, 224713, 259535, 79569, 148480, 148666, 
    201653, 224987, 259554, 48587, 79724, 110749, 201763, 2582, 110822, 110851, 149046, 178526, 
    11007, 29014, 29203, 29414, 178710, 243970, 48590, 48735, 48785, 225069, 259584, 21545, 71402, 
    102363, 171582, 195959, 196169, 44231, 103012, 103197, 239914, 9267, 71498, 139895, 139932, 239944, 
    9350, 23477, 23489, 71570, 103346, 140447, 196753, 196871, 239955, 240064, 140485, 140749, 
    140971, 171903, 197989, 257027, 140993, 240392, 257206, 257216, 266170, 44271, 71696, 72046, 
    103447, 220930, 23734, 44419, 44335, 103579, 141275, 171935, 220969, 23754, 44504, 103791, 103937, 
    141291, 171951, 171975, 198598, 240402, 266399, 273646, 266491, 22659, 43861, 43629, 139457, 
    219925, 273534, 273590, 44596, 104193, 172069, 257597, 104202, 141304, 141315, 172131, 221040, 
    266949, 266879, 44703, 44705, 72217, 104256, 172211, 172297, 199179, 240440, 240714, 45184, 72288, 
    172345, 172369, 172319, 240939, 240952, 72337, 72319, 104285, 141321, 172400, 221041, 45372, 
    172660, 221189, 267441, 23770, 72365, 141379, 141478, 172712, 221462, 240997, 267679, 23862, 
    45680, 104470, 173080, 173381, 173459, 104571, 173561, 173609, 199413, 257719, 45758, 141588, 
    141622, 199750, 43926, 171744, 220114, 239542, 104617, 104690, 141824, 141930, 141955, 45838, 
    45948, 72372, 104832, 142084, 199879, 102503, 171898, 171867, 265855, 102790, 139604, 139615, 
    139694, 220186, 220271, 102903, 196588, 103008, 139699, 256985, 22753, 23199, 23294, 220748, 
    239701, 44151, 43981, 43987, 139746, 196598, 239907, 24064, 24096, 104926, 142142, 173726, 
    200093, 273978, 24802, 73017, 221789, 73145, 73053, 105923, 105924, 142939, 221924, 222194, 
    241107, 257816, 267943, 1070, 1138, 1281, 1257, 46112, 73223, 73779, 105977, 143162, 143253, 
    9575, 106153, 173880, 222325, 257818, 9617, 73987, 143276, 174159, 143477, 143531, 174357, 25111, 
    25046, 174563, 25282, 25213, 74068, 74060, 106263, 143540, 174983, 258089, 258196, 9844, 25449, 
    74201, 106269, 143621, 222667, 241425, 241149, 1489, 46164, 46312, 74568, 106337, 106338, 106389, 
    175093, 175161, 175045, 200135, 241467, 241536, 142209, 142224, 173826, 2091, 223262, 242059, 
    242011, 267969, 46391, 106398, 143663, 242736, 143809, 143797, 242762, 46525, 106473, 106974, 
    175344, 223397, 107699, 107944, 106995, 107385, 143911, 46701, 108028, 143914, 143980, 223413, 
    144010, 175363, 46818, 74729, 144063, 223686, 274342, 47064, 144087, 144098, 200205, 242861, 
    9862, 144206, 144268, 175506, 243053, 72432, 104955, 241018, 241060, 75848, 145267, 145313, 
    72640, 105073, 105201, 142228, 72755, 72810, 72823, 72709, 105262, 221585, 241075, 72914, 105289, 
    142437, 142373, 257787, 24113, 142465, 267924, 274295, 9415, 24153, 24130, 45999, 105806, 105416, 
    142581, 173858, 105846, 142701, 142875, 142673, 221732, 9908, 25609, 75983, 76030, 108074, 
    108179, 145467, 145617, 145429, 243200, 258206, 274616, 25752, 26287, 47599, 76224, 243451, 
    76404, 108515, 175703, 224052, 243531, 108739, 175743, 276350, 2304, 26685, 108895, 145914, 
    145890, 175823, 200315, 76445, 76434, 109140, 108971, 146027, 175925, 47646, 76677, 76706, 
    146090, 176018, 47658, 76779, 146145, 176077, 200341, 258965, 26710, 47789, 47816, 47848, 109588, 
    109387, 146202, 176362, 176195, 10140, 10289, 26714, 76842, 76872, 76781, 146251, 176460, 
    200352, 47153, 145670, 2342, 10483, 27885, 27831, 146271, 146281, 176502, 200505, 2517, 146537, 
    176520, 200576, 259007, 10545, 76914, 109618, 146614, 146595, 200774, 259075, 48826, 76957, 
    146964, 146996, 146729, 176539, 200844, 47953, 77039, 77109, 109639, 147016, 176573, 200901, 
    10563, 77307, 109912, 201310, 201226, 10784, 47992, 48158, 77591, 77461, 224441, 10908, 147097, 
    176647, 78926, 109927, 147334, 147315, 201361, 48351, 78940, 147589, 224678, 224663, 259289, 
    9980, 47239, 76137, 223726, 48354, 48362, 78963, 176994, 201505, 243661, 109961, 243811, 145773, 
    47254, 200244, 223942, 258354, 25635, 108248, 175555, 274737, 25684, 175635, 175626, 268210, 
    10071, 76167, 258522, 258545, 2092, 10098, 47263, 108472, 175680, 200267, 258636, 268288, 276131, 
    80789, 80863, 113398, 179378, 179508, 2612, 2722, 51723, 51701, 82117, 115056, 151806, 151966, 
    269701, 31183, 31204, 82280, 115320, 152018, 151998, 204013, 260568, 12298, 31320, 51779, 
    115680, 204296, 204131, 245159, 152046, 152093, 260799, 12449, 31524, 115683, 181218, 245239, 
    245212, 261018, 51788, 115943, 152158, 181443, 12509, 52296, 204344, 245358, 52299, 52326, 
    52486, 82346, 82584, 116081, 229015, 245645, 52497, 52499, 116164, 116192, 31976, 31742, 82799, 
    82604, 204645, 245684, 12133, 51212, 81202, 80917, 80998, 81101, 150911, 203672, 32072, 32012, 
    83029, 152204, 181630, 204654, 245750, 116211, 204674, 204718, 245808, 261119, 12512, 32171, 
    83087, 152285, 152411, 152590, 152606, 245979, 269767, 83127, 152721, 152733, 152633, 181643, 
    181654, 204791, 246058, 12699, 152812, 181663, 116272, 116670, 246194, 2814, 32253, 52506, 
    52640, 52742, 83174, 83180, 152840, 204955, 205240, 261185, 12878, 261245, 269769, 52785, 
    116801, 152915, 153155, 153246, 13279, 116835, 51256, 81355, 150965, 179882, 179796, 260520, 
    12021, 81435, 113446, 180128, 203843, 203917, 269234, 51410, 81815, 114631, 180369, 245108, 
    245062, 12205, 51580, 81824, 151041, 203994, 51630, 82020, 114712, 151082, 180371, 227660, 
    269381, 31168, 114892, 115008, 151161, 180457, 51656, 82083, 151193, 151409, 180975);

fork query

edited oct 22

created oct 22 anonymous