SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE thread.thread_id IN (9685197, 9683298, 9682400, 9680674, 9679516, 9679431, 9677251, 9676502, 9674937, 9674400, 9673681, 9673284, 9672846, 9672830, 9672679, 9672636, 9672611, 9672092, 9671783, 9671782, 9671440, 9670088, 9668776, 9668424, 9668045, 9667094, 9666813, 9666801, 9666614, 9666279, 9665369, 9664474, 9664022, 9663771, 9663408, 9663395, 9661632, 9661631, 9660554, 9658117, 9658115, 9658113, 9658111, 9658110, 9658108, 9658107, 9658105, 9658098, 9657886, 9657815, 9657814, 9657812, 9657811, 9656847, 9656410, 9656409, 9656406, 9656325, 9656324, 9656323, 9656175, 9656174, 9656173, 9655543, 9655539, 9655443, 9655411, 9654753, 9654704, 9653046, 9653036, 9653032, 9653031, 9653022, 9653010, 9653009, 9652820, 9652347, 9652337, 9652335, 9650969, 9646492, 9645154, 9643402, 9643193, 9642426, 9636554, 9632654, 9629412, 9626525, 9626524, 9626523, 9625936, 9625329, 9624930, 9624929, 9623668, 9621817, 9619724, 9617197, 9616380, 9614837, 9613517, 9613516, 9613515, 9611390, 9608459, 9608130, 9605740, 9605279, 9605278, 9601725, 9601723, 9595271, 9593319, 9593183, 9592505, 9589970, 9589968, 9587958, 9587954, 9587953, 9587952, 9587786, 9587686, 9587683, 9587681, 9586462, 9583255, 9583092, 9582382, 9581492, 9581161, 9580640, 9580533, 9580457, 9580456, 9580240, 9580231, 9579556, 9579397, 9579314, 9574139, 9573791, 9573508, 9572607, 9571204, 9569544, 9568151, 9568149, 9567902, 9567516, 9565728, 9562580, 9562338, 9562084, 9559443, 9558637, 9558635, 9557165, 9557078, 9557074, 9554677, 9554250, 9553880, 9551524, 9551511, 9551510, 9548934, 9548009, 9545264, 9542333, 9542157, 9541695, 9541634, 9540921, 9540358, 9534869, 9534868, 9531375, 9531297, 9530710, 9529791, 9529780, 9529774, 9529005, 9527629, 9525989, 9525986, 9525984, 9525981, 9525978, 9525368, 9525118, 9524926, 9524923, 9522459, 9521414, 9521412, 9521365, 9520489, 9519212, 9519192, 9518223, 9516684, 9516551, 9516339, 9516336, 9515044, 9515031, 9513227, 9512902, 9510946, 9510945, 9510068, 9508567, 9508566, 9508564, 9508107, 9508106, 9505468, 9505467, 9505465, 9504847, 9503817, 9503263, 9503256, 9503246, 9503241, 9503232, 9503217, 9503215, 9503213, 9503205, 9503138, 9502252, 9502248, 9501791, 9501786, 9501784, 9501782, 9501777, 9501775, 9500664, 9500379, 9500372, 9499653, 9497625, 9497572, 9496705, 9495541, 9494936, 9494633, 9494632, 9494631, 9493272, 9493271, 9492945, 9491912, 9490490, 9488859, 9487130, 9486779, 9485714, 9483766, 9481279, 9480532, 9480530, 9479912, 9479911, 9479327, 9478628, 9478286, 9478284, 9477904, 9477875, 9475843, 9474100, 9473850, 9472536, 9471741, 9471563, 9471536, 9470845, 9470778, 9470682, 9469971, 9468808, 9467796, 9467535, 9467534, 9467418, 9467316, 9467273, 9466951, 9466549, 9465571, 9465134, 9464695, 9464460, 9463997, 9463630, 9463095, 9462689, 9462377, 9462286, 9462133, 9461859, 9461236, 9458382, 9458380, 9458065, 9458061, 9458050, 9458049, 9455472, 9455471, 9454253, 9453859, 9453854, 9453343, 9452872, 9452193, 9452165, 9451904, 9450931, 9450734, 9450733, 9450223, 9449965, 9449962, 9449556, 9449555, 9447627, 9446114, 9444292, 9442801, 9442463, 9440157, 9440152, 9440151, 9440043, 9439733, 9439510, 9437369, 9435696, 9434367, 9432191, 9427084, 9420212, 9417967, 9416419, 9416018, 9415268, 9414817, 9413516, 9412026, 9409437, 9406999, 9406974, 9406036, 9404096, 9403779, 9403778, 9400479, 9399954, 9398037, 9395435, 9395074, 9394005, 9394000, 9393993, 9393990, 9393989, 9393821, 9393812, 9392157, 9390474, 9389927, 9389926, 9387019, 9385090, 9385071, 9384702, 9384408, 9384280, 9384277, 9383264, 9383259, 9382267, 9381232, 9381231, 9381080, 9380922, 9380539, 9380192, 9380106, 9379836, 9379564, 9378981, 9378979, 9377120, 9376866, 9373631, 9373024, 9372708, 9371598, 9371404, 9370278, 9368254, 9368179, 9368058, 9367447, 9367079, 9366147, 9363326, 9362876, 9362875, 9362871, 9361327, 9361326, 9361165, 9360870, 9359316, 9358704, 9356519, 9354731, 9354730, 9353906, 9351795, 9351794, 9351708, 9350769, 9349617, 9349616, 9348571, 9348462, 9346546, 9345334, 9345268, 9344838, 9344837, 9343833, 9343086, 9343085, 9343052, 9343051, 9341985, 9341876, 9341873, 9341865, 9341851, 9341713, 9340512, 9340509, 9340508, 9340506, 9340134, 9340133, 9339827, 9339676, 9339583, 9339580, 9338112, 9337334, 9337094, 9337054, 9334416, 9333870, 9331912, 9330897, 9330896, 9330265, 9325373, 9325371, 9325369, 9325367, 9323667, 9317423, 9315046, 9315043, 9315042, 9314139, 9310749, 9310748, 9307442, 9306807, 9305271, 9304858, 9304857, 9301501, 9297682, 9296278, 9295840, 9295815, 9295814, 9295812, 9289805, 9287044, 9282885, 9280002, 9278935, 9278934, 9278932, 9278928, 9278926, 9278925, 9278922, 9278920, 9278823, 9277593, 9277041, 9277029, 9277025, 9277018, 9277012, 9277009, 9275465, 9273037, 9271840, 9268291, 9263298, 9258623, 9258514, 9257271, 9257253, 9254339, 9253580, 9253499, 9252187, 9250670, 9248143, 9245378, 9245196, 9242596, 9241716, 9241150, 9239919, 9239666, 9236612, 9236325, 9235638, 9235029, 9233235, 9232333, 9232094, 9231529, 9231528, 9230334, 9230328, 9230325, 9229947, 9228790, 9227166, 9227095, 9226783, 9225690, 9225660, 9225357, 9224339, 9216959, 9212492, 9212491, 9212490, 9212488, 9212486, 9212484, 9212480, 9212249, 9212144, 9211474, 9208872, 9208870, 9208519, 9205366, 9203879, 9203500, 9200898, 9198914, 9198637, 9197969, 9197740, 9195455, 9188891, 9188886, 9186195, 9186174, 9186141, 9183817, 9180895, 9180894, 9175372, 9172700, 9170529, 9169805, 9169269, 9164142, 9163526, 9163208, 9162372, 9162371, 9161420, 9161388, 9161387, 9161278, 9160732, 9160730, 9159964, 9159251, 9159030, 9158878, 9155492, 9154191, 9153392, 9153389, 9153388, 9152889, 9151865, 9149264, 9145962, 9145639, 9145306, 9141350, 9140447, 9139043, 9137804, 9136802, 9136778, 9136760, 9136741, 9136729, 9132077, 9132075, 9128485, 9125080, 9121002, 9121001, 9121000, 9120394, 9120393, 9116948, 9116825, 9113860, 9110787, 9110786, 9105378, 9104329, 9101454, 9100981, 9100979, 9097118, 9096580, 9096575, 9096567, 9092123, 9092122, 9091730, 9089148, 9087900, 9084474, 9083681, 9081277, 9081276, 9081275, 9081274, 9081273, 9081272, 9080266, 9077896, 9075669, 9075668, 9075036, 9072673, 9068247, 9067673, 9067047, 9065120, 9061746, 9060591, 9059844, 9059804, 9056653, 9056651, 9054199, 9051750, 9050071, 9049606, 9046763, 9046750, 9045152, 9039509, 9038943, 9037961, 9037939, 9036788, 9034953, 9034861, 9033093, 9032765, 9032711, 9031959, 9030494, 9030493, 9030491, 9030486, 9030482, 9030480, 9030468, 9030466, 9030463, 9030458, 9030456, 9030453, 9030362, 9030360, 9030105, 9030104, 9029581, 9029537, 9028375, 9023619, 9023060, 9018942, 9015221, 9012496, 9009749, 9009062, 9004742, 8997307, 8996711, 8996553, 8995013, 8992082, 8991729, 8990911, 8990910, 8989714, 8989713, 8989095, 8988803, 8988802, 8988572, 8988270, 8988195, 8987881, 8986682, 8979291, 8977617, 8977616, 8976957, 8975531, 8969256, 8968105, 8968028, 8967337, 8962899, 8962898, 8962707, 8960691, 8960690, 8960418, 8960236, 8960210, 8959193, 8958575, 8958186, 8958100, 8956251, 8955455, 8953236, 8953226, 8953188, 8953186, 8953184, 8953182, 8953179, 8952568, 8950871, 8949649, 8949152, 8949062, 8948464, 8941431, 8939938, 8939660, 8938710, 8938424, 8938095, 8936227, 8936226, 8935893, 8933343, 8932039, 8931309, 8931308, 8930034, 8929289, 8929288, 8929199, 8929091, 8928632, 8927198, 8926974, 8926470, 8926424, 8926039, 8925085, 8924731, 8924241, 8923384, 8922611, 8922608, 8922509, 8922508, 8922466, 8918680, 8918636, 8917632, 8917597, 8917596, 8917438, 8916887, 8916883, 8915474, 8915473, 8913382, 8913365, 8913364, 8912061, 8910512, 8909720, 8909719, 8909717, 8909536, 8908460, 8906136, 8905759, 8905758, 8904765, 8904277, 8904276, 8903483, 8903481, 8902545, 8902542, 8902541, 8900557, 8899328, 8898970, 8897865, 8897581, 8895595, 8895367, 8894727, 8894725, 8894666, 8892826, 8890555, 8890053, 8889679, 8888629, 8888586, 8887024, 8886615, 8885728, 8885301, 8883144, 8883142, 8883141, 8883140, 8883066, 8883065, 8881997, 8881945, 8881944, 8876707, 8876705, 8876704, 8876702, 8874653, 8873494, 8873493, 8871734, 8871072, 8870361, 8869357, 8869331, 8868564, 8867882, 8867655, 8867633, 8867525, 8867201, 8866053, 8865660, 8864727, 8861399, 8861308, 8861306, 8861250, 8860455, 8860336, 8859773, 8859590, 8859511, 8857164, 8855902, 8855822, 8855348, 8854775, 8853884, 8853022, 8852998, 8852251, 8851321, 8849815, 8849814, 8849354, 8849289, 8848126, 8847159, 8847158, 8845258, 8844914, 8844751, 8844459, 8843957, 8842949, 8841699, 8841694, 8839659, 8839285, 8839228, 8839011, 8839010, 8839009, 8839008, 8837534, 8837167, 8836770, 8835902, 8831768, 8831267, 8827529, 8826249, 8826248, 8825777, 8825509, 8825386, 8824382, 8824380, 8822712, 8820586, 8820492, 8820427, 8818669, 8817232, 8816002, 8814829, 8813863, 8813765, 8813429, 8810138, 8809590, 8809083, 8808727, 8806324, 8805348, 8805347, 8802241, 8801925, 8800082, 8799644, 8799610, 8798035, 8797581, 8795922, 8794504, 8793671, 8793429, 8792311, 8792284, 8792062, 8792061, 8788511, 8786817, 8786815, 8783538, 8783537, 8783374, 8782678, 8782489, 8782036, 8781821, 8781790, 8780872, 8780745, 8780197, 8780164, 8779777, 8779768, 8779228, 8779143, 8778798, 8777750, 8774898, 8774237, 8771512, 8770708, 8770161, 8770030, 8769911, 8769448, 8769380, 8769320, 8768478, 8767908, 8767567, 8767566, 8765577, 8765574, 8764346, 8764225, 8762878, 8762509, 8760922, 8760915, 8760912, 8760169, 8760167, 8758346, 8757585, 8756993, 8756561, 8756547, 8755888, 8753142, 8750248, 8750246, 8750245, 8748384, 8748383, 8745247, 8745178, 8743940, 8742100, 8740858, 8740210, 8740209, 8739773, 8738662, 8735310, 8734410, 8734328, 8733103, 8732384, 8731890, 8731806, 8731411, 8731224, 8731122, 8730952, 8730506, 8730502, 8730332, 8729981, 8729124, 8728314, 8727974, 8727617, 8726453, 8726404, 8725594, 8725342, 8725341, 8725337, 8725027, 8724845, 8724839, 8723986, 8723262, 8722572, 8721980, 8721976, 8721295, 8719194, 8719054, 8718569, 8717889, 8717011, 8716144, 8714755, 8714752, 8714532, 8714472, 8713693, 8713335, 8713125, 8710876, 8710823, 8709744, 8709446, 8709089, 8708118, 8707887, 8707390, 8706901, 8706891, 8706130, 8705277, 8704687, 8703963, 8703624, 8703623, 8702518, 8701898, 8699914, 8699569, 8699522, 8698951, 8698132, 8695389, 8695388, 8694089, 8694008, 8693375, 8691698, 8691474, 8688280, 8688202, 8687645, 8686666, 8686025, 8684558, 8683542, 8683055, 8682526, 8682173, 8681638, 8681144, 8680593, 8680108, 8679904, 8679328, 8678875, 8678798, 8678296, 8677019, 8677005, 8675628, 8674868, 8673602, 8673478, 8673299, 8672779, 8671987, 8671885, 8671242, 8670653, 8665398, 8664152, 8662539, 8661384, 8660739, 8660736, 8660732, 8660506, 8660458, 8660192, 8659517, 8659515, 8658134, 8656799, 8655950, 8655947, 8655670, 8655179, 8654335, 8653883, 8652832, 8652323, 8651667, 8651549, 8651197, 8650849, 8650488, 8650425, 8649025, 8648361, 8648359, 8647307, 8647256, 8646984, 8645643, 8644366, 8643516, 8642992, 8641763, 8640580, 8639287, 8639286, 8639285, 8639278, 8639225, 8638822, 8637547, 8637534, 8634770, 8632593, 8632562, 8631506, 8631270, 8629684, 8628396, 8628395, 8628394, 8627867, 8627860, 8627060, 8625885, 8624922, 8624175, 8624133, 8623225, 8623188, 8623148, 8621535, 8619933, 8619876, 8619747, 8613897, 8613056, 8611653, 8610353, 8608762, 8608478, 8608292, 8606641, 8606222, 8600751, 8599681, 8598719, 8598169, 8597684, 8594602, 8594260, 8593546, 8593260, 8592511, 8591957, 8588301, 8587792, 8586984, 8585931, 8585857, 8584493, 8583973, 8581588, 8580774, 8579531, 8578354, 8576412, 8575516, 8575356, 8574893, 8574620, 8573705, 8573035, 8572529, 8572426, 8571955, 8571761, 8571710, 8571293, 8570136, 8570133, 8569707, 8568861, 8568349, 8567112, 8566087, 8565364, 8565220, 8564821, 8564341, 8563672, 8563154, 8562980, 8562753, 8562751, 8562422, 8560366, 8559179, 8559178, 8557871, 8557598, 8557501, 8555386, 8554630, 8553742, 8553630, 8552101, 8552098, 8551744, 8551206, 8550706, 8550704, 8550703, 8550059, 8546545, 8545072, 8544545, 8544544, 8542212, 8541196, 8540105, 8539393, 8539116, 8538795, 8538794, 8538619, 8537835, 8537647, 8537616, 8536776, 8536523, 8535278, 8534843, 8533792, 8532972, 8532461, 8530929, 8530928, 8528762, 8528761, 8528635, 8528455, 8528360, 8527610, 8527306, 8526661, 8525354, 8525353, 8521144, 8520655, 8520526, 8518739, 8518485, 8517824, 8517751, 8516618, 8515487, 8515282, 8515019, 8514697, 8513405, 8513136, 8512964, 8512504, 8512433, 8511701, 8510713, 8510611, 8510403, 8509749, 8509431, 8508715, 8508345, 8506840, 8506459, 8505665, 8505653, 8504692, 8503430, 8502387, 8499664, 8499663, 8499134, 8498037, 8497269, 8496796, 8496529, 8496282, 8496170, 8495977, 8495967, 8494606, 8493559, 8492978, 8492950, 8492359, 8488770, 8488427, 8488040, 8486001, 8485967, 8485625, 8485617, 8485604, 8484847, 8483988, 8480612, 8478865, 8478132, 8477632, 8476909, 8476377, 8475794, 8473528, 8472963, 8472593, 8472210, 8471974, 8471010, 8470271, 8469883, 8467127, 8466833, 8466564, 8466064, 8465965, 8465959, 8465952, 8465246, 8462891, 8461519, 8461056, 8461024, 8458677, 8458259, 8458095, 8456889, 8456250, 8454959, 8454725, 8453878, 8451945, 8449085, 8448217, 8447556, 8447127, 8446927, 8446626, 8446451, 8445492, 8444279, 8444276, 8443646, 8443520, 8442708, 8442684, 8442071, 8441509, 8440881, 8440640, 8440420, 8440305, 8437037, 8436688, 8436528, 8436139, 8436080, 8433886, 8432883, 8431952, 8430896, 8430410, 8429863, 8429568, 8429205, 8429125, 8428802, 8428475, 8426727, 8425976, 8425442, 8424857, 8423179, 8423173, 8423075, 8422537, 8422476, 8422177, 8420889, 8417557, 8417434, 8415436, 8414964, 8414066, 8412281, 8411880, 8411811, 8411123, 8410849, 8408056, 8406004, 8404723, 8401960, 8401953, 8400828, 8399429, 8398786, 8398710, 8398396, 8398275, 8398273, 8398271, 8398269, 8398268, 8398263, 8398262, 8398258, 8397855, 8395028, 8394704, 8394477, 8394023, 8392623, 8389370, 8388097, 8387672, 8386936, 8386879, 8385766, 8383546, 8383542, 8382432, 8381064, 8380861, 8378937, 8378839, 8377269, 8376756, 8374915, 8374000, 8373976, 8373893, 8373243, 8373150, 8371402, 8370844, 8370734, 8370673, 8370650, 8369737, 8369538, 8368897, 8367226, 8366521, 8366116, 8365580, 8364461, 8364128, 8362801, 8360907, 8359901, 8359165, 8358041, 8358020, 8357853, 8356380, 8356369, 8356011, 8354968, 8354594, 8353768, 8353747, 8353316, 8352852, 8351521, 8351054, 8350320, 8349838, 8347951, 8347112, 8346753, 8344861, 8341521, 8341483, 8339978, 8339942, 8339463, 8339348, 8338673, 8338100, 8337780, 8336432, 8335714, 8335646, 8334634, 8334590, 8334389, 8333622, 8332926, 8332704, 8332693, 8332692, 8332024, 8331301, 8330648, 8330162, 8329910, 8329754, 8329424, 8329298, 8328619, 8328466, 8327912, 8327062, 8327047, 8326592, 8326104, 8325828, 8325369, 8324835, 8323118, 8322912, 8322699, 8322171, 8321798, 8320946, 8320464, 8320041, 8319642, 8318716, 8318195, 8318140, 8318136, 8318124, 8317879, 8317653, 8315497, 8315277, 8314926, 8314800, 8314669, 8314038, 8313959, 8313898, 8312248, 8311989, 8311059, 8310961, 8309521, 8309520, 8309260, 8309115, 8309059, 8307333, 8307318, 8307307, 8307164, 8307120, 8306791, 8305647, 8303398, 8303048, 8302319, 8301919, 8301908, 8301795, 8300404, 8298969, 8298917, 8298265, 8297921, 8297330, 8297209, 8296659, 8296174, 8295903, 8295227, 8294022, 8293759, 8293702, 8293701, 8293652, 8293353, 8292692, 8292472, 8292065, 8291729, 8291696, 8291180, 8289697, 8289381, 8288019, 8287939, 8287568, 8287447, 8287157, 8286483, 8286198, 8285953, 8285856, 8285853, 8285847, 8285789, 8285696, 8285691, 8285470, 8285036, 8284443, 8284430, 8284314, 8284009, 8283051, 8282604, 8282387, 8282208, 8281268, 8281245, 8280365, 8280050, 8280035, 8279668, 8279614, 8279504, 8279352, 8278400, 8278399, 8278121, 8276946, 8276753, 8276312, 8276094, 8274689, 8274450, 8273933, 8273587, 8273523, 8273490, 8273103, 8272936, 8272693, 8269895, 8269827, 8269680, 8268954, 8268637, 8268503, 8268288, 8267571, 8266966, 8266575, 8265281, 8265173, 8265172, 8265171, 8265169, 8265148, 8264732, 8264551, 8264450, 8263759, 8263743, 8263736, 8263019, 8262652, 8262637, 8262584, 8262443, 8262361, 8262275, 8259255, 8258913, 8258393, 8258165, 8258153, 8258152, 8258151, 8258150, 8257658, 8256817, 8256671, 8256565, 8256263, 8253284, 8252685, 8251936, 8251684, 8251251, 8250461, 8250000, 8249600, 8249302, 8247474, 8246274, 8246270, 8245831, 8245815, 8245814, 8245321, 8245320, 8245282, 8243961, 8243814, 8243801, 8243217, 8242647, 8241252, 8240111, 8240039, 8240038, 8238758, 8238269, 8237810, 8237629, 8237246, 8236490, 8236075, 8236050, 8235604, 8235603, 8235573, 8235275, 8235273, 8235155, 8235153, 8234705, 8234354, 8234010, 8233684, 8232933, 8232661, 8232074, 8231608, 8231607, 8230561, 8230097, 8229181, 8228299, 8228235, 8228106, 8227794, 8227500, 8226630, 8225252, 8224876, 8223764, 8223763, 8223545, 8222902, 8222852, 8222716, 8220888, 8219147, 8218882, 8218805, 8218765, 8218754, 8218748, 8218730, 8218067, 8216513, 8216229, 8216071, 8215742, 8215117, 8214667, 8214027, 8213070, 8213055, 8213041, 8212675, 8211864, 8211106, 8210049, 8209410, 8205602, 8205513, 8205483, 8205437, 8204522, 8202978, 8202706, 8202330, 8202148, 8202147, 8200451, 8199981, 8198680, 8198029, 8197796, 8196574, 8195628, 8195301, 8195162, 8194315, 8194282, 8194255, 8194044, 8193926, 8192349, 8191960, 8190521, 8189821, 8189580, 8188432, 8188120, 8187717, 8186833, 8186278, 8185957, 8185807, 8185236, 8184451, 8184298, 8184214, 8183559, 8182183, 8181741, 8181551, 8180267, 8179462, 8179399, 8179398, 8178563, 8177999, 8177878, 8177734, 8176699, 8176328, 8176193, 8176115, 8174911, 8173881, 8173809, 8173433, 8173305, 8172869, 8171400, 8171399, 8170565, 8170564, 8170563, 8170240, 8169754, 8169311, 8169310, 8168793, 8168026, 8167869, 8165717, 8164297, 8163239, 8162543, 8162002, 8161524, 8161516, 8160549, 8160541, 8160538, 8160483, 8160482, 8160481, 8160480, 8160479, 8160198, 8160057, 8159966, 8157313, 8156642, 8156099, 8156088, 8153389, 8123562, 8123561, 8122347, 8119157, 8119156, 8117816, 8115714, 8102598, 8072270, 8072233, 8071599, 8069626, 8067457, 8017996, 8006264, 7808783, 7538488, 7524520, 6974044, 6596083, 802799)
Run Time: 0.047046
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | <subquery2> | ALL | distinct_key | | | | 1987 | |
| PRIMARY | thread | eq_ref | PRIMARY | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
| PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
| PRIMARY | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
| PRIMARY | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
| PRIMARY | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.thread.node_id | 1 | Using where |
| MATERIALIZED | <derived3> | ALL | | | | | 1987 | |
| DERIVED | | | | | | | | No tables used |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["tinhte_xentag_forum",62],["thread",9685197],["thread",9683298],["thread",9682400],["thread",9679431],["thread",9677251],["thread",9676502],["thread",9674937],["thread",9674400],["thread",9673681],["thread",9673284],["thread",9672846],["thread",9672830],["thread",9672679],["thread",9672636],["thread",9672611],["thread",9672092],["thread",9671783],["thread",9671440],["thread",9670088],["thread",9668776],["thread",9668424],["thread",9668045],["thread",9667094],["thread",9666813],["thread",9666614],["thread",9666279],["thread",9665369],["thread",9664474],["thread",9664022],["thread",9663771],["thread",9663408],["thread",9663395],["thread",9661632],["thread",9661631],["thread",9660554],["thread",9658115],["thread",9658113],["thread",9658111],["thread",9658110],["thread",9658108],["thread",9658107],["thread",9658105],["thread",9658098],["thread",9657815],["thread",9657814],["thread",9657812],["thread",9657811],["thread",9656847],["thread",9656410],["thread",9656409],["thread",9656406],["thread",9656325],["thread",9656324],["thread",9656323],["thread",9656175],["thread",9656174],["thread",9656173],["thread",9655543],["thread",9655539],["thread",9655443],["thread",9655411],["thread",9654753],["thread",9654704],["thread",9653046],["thread",9653032],["thread",9653022],["thread",9653010],["thread",9652347],["thread",9652337],["thread",9652335],["thread",9650969],["thread",9643193],["thread",9642426],["thread",9636554],["thread",9626525],["thread",9624930],["thread",9623668],["thread",9621817],["thread",9619724],["thread",9617197],["thread",9616380],["thread",9613517],["thread",9611390],["thread",9608459],["thread",9608130],["thread",9605740],["thread",9593183],["thread",9592505],["thread",9587958],["thread",9587681],["thread",9586462],["thread",9583255],["thread",9581492],["thread",9581161],["thread",9580533],["thread",9580231],["thread",9579314],["thread",9573791],["thread",9573508],["thread",9572607],["thread",9571204],["thread",9568151],["thread",9568149],["thread",9567902],["thread",9567516],["thread",9565728],["thread",9562580],["thread",9562338],["thread",9562084],["thread",9559443],["thread",9558637],["thread",9557165],["thread",9554677],["thread",9554250],["thread",9551524],["thread",9548934],["thread",9545264],["thread",9542157],["thread",9541695],["thread",9540921],["thread",9534869],["thread",9531375],["thread",9529791],["thread",9529005],["thread",9525984],["thread",9524926],["thread",9519212],["thread",9518223],["thread",9515044],["thread",9510068],["thread",9503263],["thread",9503256],["thread",9503246],["thread",9503241],["thread",9503232],["thread",9503217],["thread",9503215],["thread",9503213],["thread",9503205],["thread",9501786],["thread",9497572],["thread",9495541],["thread",9494633],["thread",9493272],["thread",9490490],["thread",9487130],["thread",9486779],["thread",9485714],["thread",9483766],["thread",9481279],["thread",9480532],["thread",9480530],["thread",9478286],["thread",9478284],["thread",9477904],["thread",9475843],["thread",9474100],["thread",9472536],["thread",9471741],["thread",9471563],["thread",9470845],["thread",9470682],["thread",9469971],["thread",9468808],["thread",9467796],["thread",9467535],["thread",9467418],["thread",9467316],["thread",9467273],["thread",9466951],["thread",9466549],["thread",9465571],["thread",9465134],["thread",9464695],["thread",9464460],["thread",9463997],["thread",9462377],["thread",9462133],["thread",9458065],["thread",9458061],["thread",9458050],["thread",9458049],["thread",9455472],["thread",9454253],["thread",9450931],["thread",9432191],["thread",9416419],["thread",9416018],["thread",9415268],["thread",9414817],["thread",9412026],["thread",9404096],["thread",9399954],["thread",9398037],["thread",9395435],["thread",9394005],["thread",9394000],["thread",9393993],["thread",9393990],["thread",9390474],["thread",9387019],["thread",9385090],["thread",9385071],["thread",9384702],["thread",9384280],["thread",9383264],["thread",9383259],["thread",9379836],["thread",9376866],["thread",9372708],["thread",9371404],["thread",9370278],["thread",9368254],["thread",9367447],["thread",9366147],["thread",9363326],["thread",9361327],["thread",9356519],["thread",9354731],["thread",9351708],["thread",9348462],["thread",9345268],["thread",9344838],["thread",9343833],["thread",9343086],["thread",9341865],["thread",9338112],["thread",9337054],["thread",9333870],["thread",9331912],["thread",9315046],["thread",9307442],["thread",9301501],["thread",9282885],["thread",9278935],["thread",9278934],["thread",9278932],["thread",9278928],["thread",9278926],["thread",9278925],["thread",9278922],["thread",9278920],["thread",9278823],["thread",9277041],["thread",9277029],["thread",9277025],["thread",9277018],["thread",9277012],["thread",9277009],["thread",9275465],["thread",9273037],["thread",9268291],["thread",9253580],["thread",9253499],["thread",9248143],["thread",9245378],["thread",9241150],["thread",9239666],["thread",9233235],["thread",9232333],["thread",9231529],["thread",9230334],["thread",9230328],["thread",9230325],["thread",9229947],["thread",9225690],["thread",9212492],["thread",9212491],["thread",9212490],["thread",9212488],["thread",9212486],["thread",9212484],["thread",9212480],["thread",9212249],["thread",9208519],["thread",9205366],["thread",9203879],["thread",9203500],["thread",9200898],["thread",9195455],["thread",9188886],["thread",9186195],["thread",9186174],["thread",9186141],["thread",9180895],["thread",9170529],["thread",9164142],["thread",9163208],["thread",9160732],["thread",9159964],["thread",9159251],["thread",9159030],["thread",9155492],["thread",9152889],["thread",9145639],["thread",9145306],["thread",9136802],["thread",9136778],["thread",9132077],["thread",9128485],["thread",9120394],["thread",9116948],["thread",9113860],["thread",9100981],["thread",9091730],["thread",9087900],["thread",9077896],["thread",9059844],["thread",9054199],["thread",9050071],["thread",9045152],["thread",9037939],["thread",9034953],["thread",9034861],["thread",9032765],["thread",9032711],["thread",9030105],["thread",9029581],["thread",8996711],["thread",8995013],["thread",8991729],["thread",8989714],["thread",8988572],["thread",8988270],["thread",8958186],["thread",8958100],["thread",8952568],["thread",8941431],["thread",8938424],["thread",8938095],["thread",8936227],["thread",8935893],["thread",8933343],["thread",8932039],["thread",8931309],["thread",8928632],["thread",8924731],["thread",8923384],["thread",8922509],["thread",8922466],["thread",8918636],["thread",8917597],["thread",8916887],["thread",8916883],["thread",8913382],["thread",8913365],["thread",8912061],["thread",8910512],["thread",8909720],["thread",8909536],["thread",8904277],["thread",8903483],["thread",8899328],["thread",8898970],["thread",8895595],["thread",8894727],["thread",8892826],["thread",8890053],["thread",8889679],["thread",8883144],["thread",8881997],["thread",8870361],["thread",8869357],["thread",8869331],["thread",8867633],["thread",8866053],["thread",8864727],["thread",8861250],["thread",8859511],["thread",8857164],["thread",8855822],["thread",8853884],["thread",8853022],["thread",8849815],["thread",8849289],["thread",8848126],["thread",8845258],["thread",8844459],["thread",8843957],["thread",8839659],["thread",8839285],["thread",8831768],["thread",8827529],["thread",8826249],["thread",8825777],["thread",8820492],["thread",8816002],["thread",8814829],["thread",8809083],["thread",8808727],["thread",8806324],["thread",8799610],["thread",8793671],["thread",8792062],["thread",8788511],["thread",8783538],["thread",8783374],["thread",8782678],["thread",8782489],["thread",8782036],["thread",8781821],["thread",8780197],["thread",8779777],["thread",8779768],["thread",8779228],["thread",8779143],["thread",8777750],["thread",8774898],["thread",8770030],["thread",8767567],["thread",8764225],["thread",8762878],["thread",8760912],["thread",8756561],["thread",8756547],["thread",8743940],["thread",8742100],["thread",8739773],["thread",8731890],["thread",8730952],["thread",8729124],["thread",8727617],["thread",8726453],["thread",8722572],["thread",8719194],["thread",8718569],["thread",8717889],["thread",8714755],["thread",8713693],["thread",8713335],["thread",8708118],["thread",8706901],["thread",8706130],["thread",8705277],["thread",8704687],["thread",8703624],["thread",8702518],["thread",8699914],["thread",8699569],["thread",8698132],["thread",8694008],["thread",8693375],["thread",8691698],["thread",8688202],["thread",8683542],["thread",8682173],["thread",8681638],["thread",8681144],["thread",8680593],["thread",8679904],["thread",8678875],["thread",8678798],["thread",8678296],["thread",8674868],["thread",8673602],["thread",8673299],["thread",8671885],["thread",8671242],["thread",8670653],["thread",8665398],["thread",8664152],["thread",8661384],["thread",8660192],["thread",8658134],["thread",8655950],["thread",8655179],["thread",8654335],["thread",8653883],["thread",8652832],["thread",8652323],["thread",8651667],["thread",8651549],["thread",8650849],["thread",8650488],["thread",8649025],["thread",8647307],["thread",8645643],["thread",8644366],["thread",8643516],["thread",8641763],["thread",8639287],["thread",8638822],["thread",8637547],["thread",8637534],["thread",8632593],["thread",8631270],["thread",8629684],["thread",8628396],["thread",8627860],["thread",8627060],["thread",8625885],["thread",8624922],["thread",8623188],["thread",8623148],["thread",8621535],["thread",8619933],["thread",8619876],["thread",8613897],["thread",8613056],["thread",8608762],["thread",8608478],["thread",8608292],["thread",8606641],["thread",8606222],["thread",8598719],["thread",8598169],["thread",8594602],["thread",8594260],["thread",8592511],["thread",8591957],["thread",8584493],["thread",8581588],["thread",8580774],["thread",8579531],["thread",8576412],["thread",8575516],["thread",8575356],["thread",8573705],["thread",8573035],["thread",8572529],["thread",8572426],["thread",8571955],["thread",8571761],["thread",8569707],["thread",8568861],["thread",8568349],["thread",8567112],["thread",8566087],["thread",8565364],["thread",8565220],["thread",8564341],["thread",8563672],["thread",8562753],["thread",8562422],["thread",8560366],["thread",8557871],["thread",8557598],["thread",8555386],["thread",8553742],["thread",8553630],["thread",8552101],["thread",8551744],["thread",8551206],["thread",8550706],["thread",8550059],["thread",8546545],["thread",8545072],["thread",8544545],["thread",8542212],["thread",8541196],["thread",8539116],["thread",8538795],["thread",8538619],["thread",8537835],["thread",8537616],["thread",8536776],["thread",8535278],["thread",8534843],["thread",8532972],["thread",8532461],["thread",8530929],["thread",8528762],["thread",8528455],["thread",8527610],["thread",8526661],["thread",8521144],["thread",8520655],["thread",8518739],["thread",8518485],["thread",8517824],["thread",8517751],["thread",8516618],["thread",8515282],["thread",8515019],["thread",8514697],["thread",8513405],["thread",8512964],["thread",8512504],["thread",8512433],["thread",8511701],["thread",8510611],["thread",8510403],["thread",8509749],["thread",8509431],["thread",8508715],["thread",8508345],["thread",8506840],["thread",8506459],["thread",8505665],["thread",8505653],["thread",8504692],["thread",8503430],["thread",8498037],["thread",8497269],["thread",8496796],["thread",8496529],["thread",8496282],["thread",8496170],["thread",8495977],["thread",8495967],["thread",8494606],["thread",8492978],["thread",8492359],["thread",8488770],["thread",8488427],["thread",8486001],["thread",8485967],["thread",8485625],["thread",8485617],["thread",8485604],["thread",8484847],["thread",8483988],["thread",8480612],["thread",8478865],["thread",8478132],["thread",8477632],["thread",8476909],["thread",8476377],["thread",8475794],["thread",8473528],["thread",8472963],["thread",8472593],["thread",8471974],["thread",8471010],["thread",8469883],["thread",8466564],["thread",8461519],["thread",8461056],["thread",8461024],["thread",8458677],["thread",8456250],["thread",8454959],["thread",8454725],["thread",8453878],["thread",8449085],["thread",8446927],["thread",8446451],["thread",8445492],["thread",8444279],["thread",8444276],["thread",8443646],["thread",8443520],["thread",8442708],["thread",8442071],["thread",8441509],["thread",8440881],["thread",8440640],["thread",8440305],["thread",8437037],["thread",8436528],["thread",8433886],["thread",8432883],["thread",8431952],["thread",8430896],["thread",8429568],["thread",8429205],["thread",8428802],["thread",8428475],["thread",8426727],["thread",8425976],["thread",8425442],["thread",8423179],["thread",8423173],["thread",8423075],["thread",8422537],["thread",8422476],["thread",8422177],["thread",8420889],["thread",8414964],["thread",8412281],["thread",8411880],["thread",8411811],["thread",8411123],["thread",8408056],["thread",8406004],["thread",8404723],["thread",8401960],["thread",8401953],["thread",8400828],["thread",8399429],["thread",8398786],["thread",8398710],["thread",8398396],["thread",8397855],["thread",8395028],["thread",8394477],["thread",8394023],["thread",8392623],["thread",8389370],["thread",8388097],["thread",8387672],["thread",8386936],["thread",8386879],["thread",8385766],["thread",8383546],["thread",8383542],["thread",8382432],["thread",8381064],["thread",8380861],["thread",8378937],["thread",8378839],["thread",8377269],["thread",8376756],["thread",8374915],["thread",8374000],["thread",8373976],["thread",8373893],["thread",8373243],["thread",8373150],["thread",8371402],["thread",8370844],["thread",8370734],["thread",8370673],["thread",8369737],["thread",8369538],["thread",8368897],["thread",8367226],["thread",8366521],["thread",8366116],["thread",8365580],["thread",8364461],["thread",8364128],["thread",8362801],["thread",8360907],["thread",8359165],["thread",8358041],["thread",8358020],["thread",8356380],["thread",8356369],["thread",8356011],["thread",8354968],["thread",8353768],["thread",8353747],["thread",8352852],["thread",8351521],["thread",8351054],["thread",8349838],["thread",8347951],["thread",8347112],["thread",8346753],["thread",8344861],["thread",8341521],["thread",8341483],["thread",8339463],["thread",8339348],["thread",8338673],["thread",8338100],["thread",8337780],["thread",8336432],["thread",8335714],["thread",8335646],["thread",8334634],["thread",8334590],["thread",8333622],["thread",8332704],["thread",8331301],["thread",8330648],["thread",8330162],["thread",8329910],["thread",8329754],["thread",8329424],["thread",8328619],["thread",8328466],["thread",8327912],["thread",8327062],["thread",8327047],["thread",8326592],["thread",8326104],["thread",8325828],["thread",8325369],["thread",8324835],["thread",8323118],["thread",8322912],["thread",8322699],["thread",8322171],["thread",8321798],["thread",8320946],["thread",8320464],["thread",8320041],["thread",8319642],["thread",8318716],["thread",8318195],["thread",8318140],["thread",8318124],["thread",8317879],["thread",8315497],["thread",8315277],["thread",8314926],["thread",8314800],["thread",8314669],["thread",8314038],["thread",8313959],["thread",8313898],["thread",8312248],["thread",8311989],["thread",8311059],["thread",8310961],["thread",8309521],["thread",8309260],["thread",8309115],["thread",8309059],["thread",8307333],["thread",8307318],["thread",8307307],["thread",8307164],["thread",8307120],["thread",8306791],["thread",8305647],["thread",8303398],["thread",8303048],["thread",8302319],["thread",8301919],["thread",8301908],["thread",8301795],["thread",8300404],["thread",8298969],["thread",8298917],["thread",8298265],["thread",8297921],["thread",8297330],["thread",8297209],["thread",8296659],["thread",8296174],["thread",8295903],["thread",8295227],["thread",8294022],["thread",8293759],["thread",8293652],["thread",8293353],["thread",8292692],["thread",8292472],["thread",8292065],["thread",8291729],["thread",8291180],["thread",8289697],["thread",8289381],["thread",8287939],["thread",8287568],["thread",8287447],["thread",8287157],["thread",8286483],["thread",8286198],["thread",8285953],["thread",8285856],["thread",8285847],["thread",8285789],["thread",8285696],["thread",8285470],["thread",8285036],["thread",8284443],["thread",8284430],["thread",8284314],["thread",8283051],["thread",8282208],["thread",8281268],["thread",8281245],["thread",8280365],["thread",8280050],["thread",8280035],["thread",8279668],["thread",8279614],["thread",8279504],["thread",8279352],["thread",8278400],["thread",8278121],["thread",8276946],["thread",8276753],["thread",8276094],["thread",8274689],["thread",8274450],["thread",8273933],["thread",8273587],["thread",8273523],["thread",8273490],["thread",8272936],["thread",8272693],["thread",8269827],["thread",8269680],["thread",8268954],["thread",8268637],["thread",8268503],["thread",8268288],["thread",8267571],["thread",8266966],["thread",8266575],["thread",8265173],["thread",8265148],["thread",8264732],["thread",8264551],["thread",8264450],["thread",8263759],["thread",8263743],["thread",8263736],["thread",8263019],["thread",8262652],["thread",8262637],["thread",8262584],["thread",8262443],["thread",8262361],["thread",8262275],["thread",8259255],["thread",8258913],["thread",8258393],["thread",8258165],["thread",8258153],["thread",8257658],["thread",8256817],["thread",8256671],["thread",8256565],["thread",8256263],["thread",8253284],["thread",8252685],["thread",8251684],["thread",8251251],["thread",8250461],["thread",8250000],["thread",8249600],["thread",8249302],["thread",8247474],["thread",8246274],["thread",8246270],["thread",8245831],["thread",8245815],["thread",8245321],["thread",8243961],["thread",8243814],["thread",8243801],["thread",8243217],["thread",8242647],["thread",8241252],["thread",8240111],["thread",8240039],["thread",8238758],["thread",8238269],["thread",8237810],["thread",8237629],["thread",8237246],["thread",8236490],["thread",8236075],["thread",8236050],["thread",8235604],["thread",8235573],["thread",8235275],["thread",8235155],["thread",8234705],["thread",8234354],["thread",8233684],["thread",8232933],["thread",8232661],["thread",8232074],["thread",8231608],["thread",8230561],["thread",8230097],["thread",8229181],["thread",8228235],["thread",8228106],["thread",8227794],["thread",8227500],["thread",8226630],["thread",8225252],["thread",8224876],["thread",8223545],["thread",8222902],["thread",8222852],["thread",8222716],["thread",8220888],["thread",8219147],["thread",8218882],["thread",8218805],["thread",8218765],["thread",8218754],["thread",8218748],["thread",8216513],["thread",8216229],["thread",8216071],["thread",8215117],["thread",8214667],["thread",8214027],["thread",8213070],["thread",8213055],["thread",8213041],["thread",8212675],["thread",8211864],["thread",8211106],["thread",8210049],["thread",8209410],["thread",8205602],["thread",8205513],["thread",8205483],["thread",8205437],["thread",8204522],["thread",8202978],["thread",8202148],["thread",8200451],["thread",8199981],["thread",8198680],["thread",8198029],["thread",8197796],["thread",8196574],["thread",8195301],["thread",8195162],["thread",8194315],["thread",8194282],["thread",8194255],["thread",8194044],["thread",8192349],["thread",8191960],["thread",8190521],["thread",8188432],["thread",8188120],["thread",8187717],["thread",8186833],["thread",8186278],["thread",8185807],["thread",8185236],["thread",8184451],["thread",8184298],["thread",8184214],["thread",8183559],["thread",8182183],["thread",8181551],["thread",8180267],["thread",8179462],["thread",8179399],["thread",8178563],["thread",8177999],["thread",8177878],["thread",8177734],["thread",8176699],["thread",8176328],["thread",8176193],["thread",8176115],["thread",8174911],["thread",8173881],["thread",8173809],["thread",8173433],["thread",8173305],["thread",8172869],["thread",8170240],["thread",8169754],["thread",8168793],["thread",8168026],["thread",8167869],["thread",8165717],["thread",8164297],["thread",8163239],["thread",8162543],["thread",8162002],["thread",8160549],["thread",8160198],["thread",8160057],["thread",8157313],["thread",8156642],["thread",8156099],["thread",8156088],["thread",8153389],["thread",8123562],["thread",8122347],["thread",8119157],["thread",8117816],["thread",8115714],["thread",8102598],["thread",8072270],["thread",8072233],["thread",8071599],["thread",8069626],["thread",8067457],["thread",8017996],["thread",8006264],["thread",7808783],["thread",7538488],["thread",7524520],["thread",6974044],["thread",6596083],["thread",802799]], 1076, tinhte_xentag_tag, , {"tags":["tivi"]}, date, 0, , [], 0, 1656553158, eb79348abe72eb5c2f377f6e382da227
Run Time: 0.001119