0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

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 (
        122, 126, 147, 197, 553, 577, 1070, 1138, 1257, 1281, 
        1489, 2091, 2092, 2304, 2342, 2517, 2582, 2612, 2722, 
        2814, 3026, 3133, 3392, 3611, 3949, 3958, 4209, 4217, 
        4250, 4530, 4594, 4767, 4811, 4863, 4944, 5043, 5067, 
        5082, 5129, 5309, 5551, 5718, 5869, 6062, 6259, 6609, 
        6620, 6756, 6785, 6919, 6991, 7024, 7580, 7610, 7641, 
        8028, 8086, 8761, 8861, 8865, 9018, 9267, 9350, 9415, 
        9575, 9617, 9844, 9862, 9908, 9980, 10071, 10098, 
        10140, 10289, 10483, 10545, 10563, 10784, 10908, 
        10974, 11007, 11083, 11204, 11369, 11391, 11441, 
        11623, 11683, 11795, 12021, 12133, 12205, 12298, 
        12449, 12509, 12512, 12699, 12878, 13279, 13304, 
        13353, 13534, 13772, 13776, 13955, 13994, 14142, 
        14184, 14215, 14317, 14334, 14613, 14698, 14725, 
        14824, 14906, 15058, 15214, 15335, 15446, 15462, 
        15553, 15595, 15621, 15662, 15738, 15743, 15953, 
        16158, 16175, 16344, 16371, 16473, 16723, 16801, 
        16939, 16965, 16996, 17067, 17073, 17192, 17234, 
        17268, 17316, 17318, 17505, 17517, 17561, 17642, 
        18043, 18154, 18234, 18294, 18509, 18608, 18663, 
        18677, 18682, 18744, 18752, 18799, 18819, 19459, 
        19867, 19928, 20103, 20461, 20465, 20707, 20874, 
        20928, 20939, 21278, 21297, 21301, 21523, 21545, 
        22659, 22753, 23199, 23294, 23477, 23489, 23734, 
        23754, 23770, 23862, 24064, 24096, 24113, 24130, 
        24153, 24802, 25046, 25111, 25213, 25282, 25449, 
        25609, 25635, 25684, 25752, 26287, 26685, 26710, 
        26714, 27831, 27885, 27929, 29014, 29203, 29414, 
        29515, 29735, 29745, 29798, 29930, 29937, 30516, 
        30701, 30723, 30782, 30940, 31160, 31168, 31183, 
        31204, 31320, 31524, 31742, 31976, 32012, 32072, 
        32171, 32253, 32262, 32303, 32321, 32334, 32353, 
        32413, 32532, 32784, 32838, 32915, 33212, 33260, 
        33312, 33523, 33637, 33722, 33741, 33885, 33900, 
        34136, 34162, 34329, 34498, 34606, 34619, 34655, 
        34718, 34782, 34805, 34913, 34952, 35030, 35050, 
        35235, 35275, 35396, 35495, 35515, 35517, 35712, 
        35803, 35883, 35898, 36070, 36272, 36645, 36774, 
        36873, 36966, 37015, 37121, 37334, 37486, 37577, 
        37654, 37749, 37786, 37893, 38059, 38156, 38192, 
        38406, 38509, 38655, 38715, 38874, 38899, 38930, 
        38942, 39017, 39027, 39092, 39284, 39310, 39386, 
        39394, 39468, 39530, 39785, 39801, 39823, 39833, 
        39915, 40127, 40129, 40182, 40203, 40269, 40371, 
        40597, 40654, 40811, 40832, 40848, 41018, 41064, 
        41139, 41147, 41160, 41411, 41702, 41708, 42199, 
        42369, 42470, 42550, 42583, 42712, 42917, 43095, 
        43224, 43234, 43294, 43544, 43546, 43585, 43629, 
        43861, 43926, 43981, 43987, 44151, 44231, 44271, 
        44335, 44419, 44504, 44596, 44703, 44705, 45184, 
        45372, 45680, 45758, 45838, 45948, 45999, 46112, 
        46164, 46312, 46391, 46525, 46701, 46818, 47064, 
        47153, 47239, 47254, 47263, 47599, 47646, 47658, 
        47789, 47816, 47848, 47953, 47992, 48158, 48351, 
        48354, 48362, 48415, 48431, 48587, 48590, 48735, 
        48785, 48826, 48994, 49145, 49163, 49184, 49319, 
        49465, 49498, 49571, 49572, 49647, 49674, 49771, 
        49851, 50993, 51039, 51105, 51203, 51212, 51256, 
        51410, 51580, 51630, 51656, 51701, 51723, 51779, 
        51788, 52296, 52299, 52326, 52486, 52497, 52499, 
        52506, 52640, 52742, 52785, 52804, 53573, 53752, 
        53847, 53924, 54227, 54234, 54672, 54693, 54732, 
        54734, 55200, 55208, 55236, 55441, 55548, 55627, 
        55673, 55823, 55835, 55921, 56010, 56012, 56089, 
        56120, 56174, 56253, 56263, 56271, 56278, 56357, 
        56359, 56572, 56850, 56944, 57037, 57131, 57216, 
        57453, 57498, 57527, 57579, 57701, 57734, 57817, 
        57904, 57935, 57943, 57969, 58094, 58141, 58167, 
        58419, 58488, 58611, 58612, 58719, 58777, 59052, 
        59274, 59454, 60642, 60734, 60783, 60961, 61121, 
        61237, 61606, 61949, 61991, 62056, 62170, 62198, 
        62230, 62322, 62481, 62548, 62564, 63343, 63503, 
        63687, 63815, 63881, 63946, 63991, 64304, 64478, 
        64529, 64628, 64722, 64791, 65320, 65361, 65419, 
        65459, 65461, 65731, 65941, 66003, 66033, 66100, 
        66166, 66318, 66490, 66568, 66688, 66901, 66910, 
        67100, 67171, 67360, 67372, 67700, 67744, 67952, 
        67972, 68142, 68158, 68171, 68208, 68243, 68641, 
        68663, 68701, 69455, 70471, 70735, 70797, 71372, 
        71402, 71498, 71570, 71696, 72046, 72217, 72288, 
        72319, 72337, 72365, 72372, 72432, 72640, 72709, 
        72755, 72810, 72823, 72914, 73017, 73053, 73145, 
        73223, 73779, 73987, 74060, 74068, 74201, 74568, 
        74729, 75848, 75983, 76030, 76137, 76167, 76224, 
        76404, 76434, 76445, 76677, 76706, 76779, 76781, 
        76842, 76872, 76914, 76957, 77039, 77109, 77307, 
        77461, 77591, 78926, 78940, 78963, 79023, 79569, 
        79724, 79744, 79770, 79816, 79864, 79873, 79910, 
        79976, 80131, 80233, 80359, 80429, 80485, 80510, 
        80589, 80608, 80622, 80624, 80627, 80663, 80789, 
        80863, 80917, 80998, 81101, 81202, 81355, 81435, 
        81815, 81824, 82020, 82083, 82117, 82280, 82346, 
        82584, 82604, 82799, 83029, 83087, 83127, 83174, 
        83180, 83231, 83893, 84006, 84217, 84245, 84361, 
        84530, 84605, 85241, 85251, 85497, 85626, 85914, 
        86060, 86182, 86349, 86466, 86634, 86821, 86893, 
        86908, 86953, 86955, 86978, 87261, 87278, 87387, 
        87400, 87542, 87553, 87571, 88583, 88673, 88951, 
        89105, 89341, 89349, 89351, 89397, 89398, 89500, 
        89505, 89570, 89897, 89916, 90040, 90115, 90247, 
        90362, 90563, 90699, 90738, 90914, 91134, 91376, 
        91697, 91737, 91788, 91836, 92137, 92191, 92243, 
        92464, 92465, 92494, 93029, 93273, 93458, 93587, 
        93631, 93727, 93765, 93836, 93854, 93896, 93902, 
        94133, 94232, 94274, 94419, 94633, 94711, 94756, 
        94760, 94815, 95364, 95402, 95670, 95729, 95771, 
        95856, 95891, 95982, 96237, 96553, 96789, 96838, 
        96881, 96999, 97077, 97209, 97276, 97305, 97649, 
        97671, 97768, 97798, 97890, 98247, 100156, 100348, 
        100405, 100586, 100662, 100808, 100977, 101163, 
        101235, 101439, 101494, 101500, 101514, 101529, 
        101603, 101801, 101921, 101991, 102105, 102352, 
        102363, 102503, 102790, 102903, 103008, 103012, 
        103197, 103346, 103447, 103579, 103791, 103937, 
        104193, 104202, 104256, 104285, 104470, 104571, 
        104617, 104690, 104832, 104926, 104955, 105073, 
        105201, 105262, 105289, 105416, 105806, 105846, 
        105923, 105924, 105977, 106153, 106263, 106269, 
        106337, 106338, 106389, 106398, 106473, 106974, 
        106995, 107385, 107699, 107944, 108028, 108074, 
        108179, 108248, 108472, 108515, 108739, 108895, 
        108971, 109140, 109387, 109588, 109618, 109639, 
        109912, 109927, 109961, 110181, 110331, 110481, 
        110575, 110749, 110822, 110851, 111121, 111179, 
        111206, 111226, 111398, 112086, 112108, 112184, 
        112191, 112327, 112376, 112742, 112892, 113046, 
        113098, 113110, 113296, 113398, 113446, 114631, 
        114712, 114892, 115008, 115056, 115320, 115680, 
        115683, 115943, 116081, 116164, 116192, 116211, 
        116272, 116670, 116801, 116835, 117325, 117986, 
        118332, 118564, 118597, 118985, 119032, 119056, 
        119101, 119132, 119370, 119510, 119517, 119594, 
        119727, 119854, 120063, 120366, 120420, 120528, 
        120540, 120615, 120876, 120952, 121204, 121355, 
        121371, 121379, 121702, 121751, 121762, 122270, 
        122584, 122730, 122826, 122834, 122839, 122859, 
        123112, 123212, 123243, 123423, 123435, 123441, 
        123590, 123686, 123687, 123781, 123833, 123963, 
        124172, 124405, 124486, 124513, 124912, 126361, 
        126580, 126831, 126847, 126848, 126960, 127261, 
        127344, 127655, 127802, 127920, 128320, 128412, 
        128772, 128782, 129026, 129035, 129061, 129121, 
        129137, 129218, 129327, 129445, 129475, 129560, 
        129598, 129690, 129732, 129783, 129846, 129855, 
        129864, 130012, 130039, 130352, 130415, 130428, 
        130468, 130497, 130604, 130793, 130955, 130969, 
        130985, 130991, 130997, 131074, 131085, 131092, 
        131553, 131632, 131650, 131747, 132933, 132958, 
        133111, 133200, 133305, 133345, 133398, 133670, 
        133698, 133947, 134158, 134404, 134491, 134522, 
        134670, 134684, 134783, 134853, 134870, 134873, 
        135020, 135077, 135082, 135146, 135540, 135581, 
        135858, 135963, 136038, 136045, 136122, 136467, 
        136566, 136589, 136627, 136863, 136914, 137015, 
        137071, 137201, 137227, 137251, 137529, 137639, 
        137876, 137971, 138011, 138110, 138168, 138174, 
        138305, 138385, 138507, 138844, 138864, 138869, 
        139043, 139232, 139388, 139457, 139604, 139615, 
        139694, 139699, 139746, 139895, 139932, 140447, 
        140485, 140749, 140971, 140993, 141275, 141291, 
        141304, 141315, 141321, 141379, 141478, 141588, 
        141622, 141824, 141930, 141955, 142084, 142142, 
        142209, 142224, 142228, 142373, 142437, 142465, 
        142581, 142673, 142701, 142875, 142939, 143162, 
        143253, 143276, 143477, 143531, 143540, 143621, 
        143663, 143797, 143809, 143911, 143914, 143980, 
        144010, 144063, 144087, 144098, 144206, 144268, 
        145267, 145313, 145429, 145467, 145617, 145670, 
        145773, 145890, 145914, 146027, 146090, 146145, 
        146202, 146251, 146271, 146281, 146537, 146595, 
        146614, 146729, 146964, 146996, 147016, 147097, 
        147315, 147334, 147589, 148052, 148135, 148184, 
        148362, 148480, 148666, 149046, 149200, 149261, 
        149337, 149353, 149466, 149551, 149721, 149874, 
        149892, 149931, 150139, 150270, 150505, 150589, 
        150687, 150810, 150813, 150911, 150965, 151041, 
        151082, 151161, 151193, 151409, 151806, 151966, 
        151998, 152018, 152046, 152093, 152158, 152204, 
        152285, 152411, 152590, 152606, 152633, 152721, 
        152733, 152812, 152840, 152915, 153155, 153246, 
        153274, 153383, 153466, 153854, 154104, 154396, 
        154433, 154457, 154591, 154816, 154917, 154919, 
        155560, 155561, 155583, 155792, 157260, 157341, 
        157741, 157742, 157850, 158066, 158277, 158399, 
        158559, 158780, 158865, 158920, 159379, 159761, 
        159823, 159907, 159961, 160136, 160434, 160466, 
        160469, 160899, 160950, 161199, 161666, 161719, 
        161807, 161987, 162240, 162551, 162693, 162979, 
        163052, 163167, 163207, 163230, 163385, 163467, 
        163547, 163590, 163630, 164702, 164724, 164864, 
        164885, 165101, 165131, 165381, 165670, 165684, 
        165748, 165778, 165873, 165885, 166010, 166286, 
        166321, 166379, 166635, 166785, 167087, 167216, 
        167242, 167399, 167880, 167946, 168067, 168181, 
        168233, 168244, 168327, 168507, 168993, 169302, 
        169360, 169522, 169594, 169756, 169858, 169859, 
        169990, 170237, 170307, 170378, 170454, 170546, 
        170619, 170650, 171196, 171430, 171569, 171582, 
        171744, 171867, 171898, 171903, 171935, 171951, 
        171975, 172069, 172131, 172211, 172297, 172319, 
        172345, 172369, 172400, 172660, 172712, 173080, 
        173381, 173459, 173561, 173609, 173726, 173826, 
        173858, 173880, 174159, 174357, 174563, 174983, 
        175045, 175093, 175161, 175344, 175363, 175506, 
        175555, 175626, 175635, 175680, 175703, 175743, 
        175823, 175925, 176018, 176077, 176195, 176362, 
        176460, 176502, 176520, 176539, 176573, 176647, 
        176994, 177092, 177287, 177351, 177390, 177958, 
        178170, 178526, 178710, 178771, 178772, 178780, 
        178881, 178882, 179035, 179079, 179091, 179183, 
        179302, 179378, 179508, 179796, 179882, 180128, 
        180369, 180371, 180457, 180975, 181218, 181443, 
        181630, 181643, 181654, 181663, 181834, 181922, 
        181960, 182048, 182193, 182293, 182409, 182602, 
        182738, 182899, 183052, 183083, 183192, 183263, 
        183402, 183453, 183607, 183618, 183746, 183767, 
        183955, 183959, 183962, 184119, 184416, 184464, 
        184717, 184969, 184975, 185220, 185269, 185628, 
        185814, 185889, 185903, 186173, 186189, 186264, 
        186345, 186503, 186513, 186756, 186804, 186972, 
        186999, 187160, 187249, 187386, 187602, 187817, 
        188124, 188157, 188368, 188454, 188647, 189002, 
        189057, 189076, 189147, 189172, 189213, 189252, 
        189293, 189310, 189376, 189413, 189527, 189588, 
        189766, 189866, 189958, 189971, 190017, 190219, 
        190282, 190354, 190380, 190437, 190611, 190676, 
        191067, 191116, 191124, 191174, 191194, 191487, 
        191494, 191617, 191758, 191794, 191827, 191841, 
        191938, 192065, 192170, 192173, 192214, 192286, 
        192333, 192368, 192552, 192716, 192722, 192830, 
        192967, 193002, 193135, 193363, 193391, 193682, 
        193689, 193779, 194069, 194253, 194597, 194711, 
        194777, 194814, 194877, 195175, 195387, 195607, 
        195610, 195662, 195959, 196169, 196588, 196598, 
        196753, 196871, 197989, 198598, 199179, 199413, 
        199750, 199879, 200093, 200135, 200205, 200244, 
        200267, 200315, 200341, 200352, 200505, 200576, 
        200774, 200844, 200901, 201226, 201310, 201361, 
        201505, 201652, 201653, 201763, 201906, 201934, 
        202008, 202556, 202575, 202588, 202802, 202891, 
        202902, 203105, 203387, 203403, 203429, 203672, 
        203843, 203917, 203994, 204013, 204131, 204296, 
        204344, 204645, 204654, 204674, 204718, 204791, 
        204955, 205240, 205264, 205310, 205354, 205568, 
        205574, 205978, 206028, 206078, 206081, 206186, 
        206195, 206702, 206705, 206731, 207105, 207267, 
        207408, 207460, 207470, 207642, 207741, 209143, 
        209479, 209491, 209690, 209817, 209857, 209936, 
        209948, 210038, 210186, 210320, 210673, 210868, 
        210902, 211242, 211286, 211350, 211552, 211947, 
        212040, 212247, 212315, 212473, 212506, 212527, 
        212574, 212859, 212873, 212905, 212930, 213033, 
        213146, 213472, 213581, 213624, 213625, 213748, 
        213875, 214304, 214351, 214387, 214415, 214441, 
        214480, 214593, 214640, 214741, 215034, 215063, 
        215322, 215467, 215569, 215736, 215875, 216045, 
        216217, 216426, 216595, 216756, 216764, 217886, 
        217894, 218046, 218510, 218517, 218538, 218614, 
        218632, 218713, 218792, 218994, 219009, 219121, 
        219128, 219293, 219658, 219714, 219925, 220114, 
        220186, 220271, 220748, 220930, 220969, 221040, 
        221041, 221189, 221462, 221585, 221732, 221789, 
        221924, 222194, 222325, 222667, 223262, 223397, 
        223413, 223686, 223726, 223942, 224052, 224441, 
        224663, 224678, 224713, 224987, 225069, 225526, 
        226028, 227026, 227155, 227346, 227364, 227429, 
        227660, 229015, 229022, 229238, 229282, 229581, 
        229602, 229714, 229954, 230083, 230129, 230211, 
        230256, 230389, 230611, 230660, 230743, 230745, 
        230773, 230878, 230935, 230968, 230979, 230998, 
        231142, 231154, 231178, 231438, 231489, 231504, 
        231587, 231804, 231958, 232478, 232528, 232593, 
        232700, 232739, 232831, 232867, 232909, 232961, 
        232995, 233052, 233111, 233127, 233267, 233285, 
        233302, 233328, 233652, 233770, 233810, 233849, 
        233859, 233972, 234115, 234148, 234159, 234539, 
        234600, 234608, 234812, 235122, 235213, 235316, 
        235318, 235394, 236574, 236598, 236603, 236703, 
        236712, 236923, 237048, 237153, 237210, 237434, 
        237479, 237517, 237580, 237730, 237870, 238021, 
        238214, 238237, 238275, 238464, 238589, 238602, 
        238646, 238855, 238991, 239146, 239307, 239347, 
        239382, 239427, 239447, 239466, 239542, 239701, 
        239907, 239914, 239944, 239955, 240064, 240392, 
        240402, 240440, 240714, 240939, 240952, 240997, 
        241018, 241060, 241075, 241107, 241149, 241425, 
        241467, 241536, 242011, 242059, 242736, 242762, 
        242861, 243053, 243200, 243451, 243531, 243661, 
        243811, 243935, 243970, 244012, 244073, 244300, 
        244341, 244742, 244795, 244819, 244910, 244993, 
        245062, 245108, 245159, 245212, 245239, 245358, 
        245645, 245684, 245750, 245808, 245979, 246058, 
        246194, 246201, 246536, 247762, 248006, 248013, 
        248113, 248222, 248240, 248256, 248393, 248524, 
        248562, 248804, 248842, 249112, 249140, 249552, 
        249851, 250021, 251047, 251603, 251745, 252237, 
        252333, 252464, 252584, 252701, 253851, 253909, 
        253984, 254172, 254234, 254341, 254356, 254407, 
        254447, 254472, 254560, 255160, 255384, 255890, 
        256066, 256073, 256106, 256285, 256541, 256798, 
        256985, 257027, 257206, 257216, 257597, 257719, 
        257787, 257816, 257818, 258089, 258196, 258206, 
        258354, 258522, 258545, 258636, 258965, 259007, 
        259075, 259289, 259535, 259554, 259584, 259792, 
        259950, 259963, 260520, 260568, 260799, 261018, 
        261119, 261185, 261245, 261267, 261471, 261491, 
        261514, 261727, 262200, 262236, 262263, 262425, 
        262522, 262546, 262605, 262625, 262677, 262996, 
        263098, 263300, 263582, 263694, 263727, 263876, 
        263902, 263909, 263974, 264094, 264121, 264126, 
        264169, 264223, 264341, 264369, 264377, 264405, 
        264474, 265115, 265143, 265147, 265158, 265255, 
        265493, 265619, 265622, 265701, 265714, 265814, 
        265855, 266170, 266399, 266491, 266879, 266949, 
        267441, 267679, 267924, 267943, 267969, 268210, 
        268288, 268341, 268626, 268741, 268821, 268840, 
        269234, 269381, 269701, 269767, 269769, 269879, 
        269904, 269970, 269987, 270073, 270490, 270631, 
        270742, 270833, 270861, 270887, 271354, 271386, 
        271451, 271700, 271895, 271921, 271994, 272139, 
        272343, 272349, 272448, 272449, 272679, 272915, 
        273018, 273364, 273439, 273534, 273590, 273646, 
        273978, 274295, 274342, 274616, 274737, 276131, 
        276350
    );

fork query

edited oct 24

created oct 18 anonymous