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 (9551498, 9525270, 9497867, 9496201, 9478169, 9478096, 9474311, 9474307, 9473475, 9472895, 9470673, 9470670, 9470666, 9470665, 9470661, 9469363, 9468806, 9467133, 9467131, 9467130, 9465512, 9465511, 9465138, 9464386, 9464185, 9463219, 9463037, 9462287, 9461728, 9461112, 9460849, 9460847, 9460844, 9460842, 9459807, 9459798, 9459769, 9458829, 9457261, 9457258, 9455995, 9455700, 9455696, 9454855, 9454854, 9454852, 9454851, 9453736, 9453664, 9452144, 9452143, 9451953, 9451074, 9450157, 9449248, 9449212, 9449208, 9448814, 9448234, 9447941, 9447939, 9447758, 9447694, 9447691, 9447499, 9447427, 9447426, 9447183, 9447180, 9446810, 9446809, 9446807, 9446804, 9445552, 9445547, 9445543, 9444200, 9444195, 9442186, 9441859, 9437097, 9437095, 9436408, 9436401, 9435894, 9435889, 9435046, 9432753, 9432746, 9429745, 9428240, 9425735, 9423908, 9423626, 9422695, 9413714, 9412695, 9412112, 9410371, 9409457, 9409364, 9406950, 9406280, 9405940, 9405782, 9405781, 9405236, 9404106, 9399887, 9399644, 9399423, 9397609, 9397332, 9396924, 9396435, 9395158, 9394952, 9393842, 9391824, 9391822, 9390156, 9387291, 9387188, 9385922, 9385738, 9384517, 9381850, 9379752, 9378689, 9377277, 9376987, 9376832, 9376319, 9376307, 9375668, 9374748, 9372499, 9372498, 9372345, 9371356, 9371355, 9371352, 9370728, 9369578, 9368911, 9368018, 9366699, 9365630, 9365512, 9363733, 9363093, 9361297, 9361070, 9360709, 9357035, 9355775, 9351750, 9348090, 9347277, 9347275, 9345567, 9340392, 9340389, 9338405, 9338249, 9338182, 9337589, 9336946, 9335326, 9334843, 9333874, 9332832, 9332544, 9332307, 9331782, 9330689, 9330122, 9329982, 9329968, 9329948, 9327822, 9327821, 9324530, 9323356, 9323354, 9323339, 9319796, 9319795, 9319789, 9318064, 9314949, 9314792, 9314674, 9313332, 9311590, 9311589, 9311587, 9309392, 9308706, 9307693, 9303939, 9302389, 9300849, 9300715, 9300324, 9299833, 9299505, 9299299, 9298508, 9297006, 9295408, 9294366, 9294327, 9294200, 9290769, 9290767, 9290558, 9290274, 9288832, 9285230, 9283124, 9281542, 9281501, 9280558, 9279021, 9278197, 9277980, 9277324, 9275792, 9273748, 9273540, 9271903, 9270977, 9269616, 9268789, 9267587, 9266818, 9263775, 9263190, 9260922, 9259551, 9259017, 9258432, 9258192, 9257818, 9257427, 9256674, 9254690, 9254315, 9254217, 9249384, 9248495, 9248047, 9247746, 9246677, 9246675, 9245558, 9243798, 9243795, 9241057, 9240777, 9239812, 9237481, 9235432, 9234702, 9234329, 9228623, 9227973, 9226586, 9224396, 9221755, 9221063, 9219260, 9217974, 9217973, 9213771, 9210037, 9208598, 9207768, 9206768, 9205123, 9204803, 9203226, 9201774, 9198537, 9198082, 9194618, 9194458, 9194422, 9194421, 9193538, 9190045, 9189127, 9189059, 9188943, 9188626, 9187418, 9184562, 9184554, 9183787, 9183227, 9182042, 9179721, 9177722, 9177164, 9177163, 9177162, 9177128, 9176921, 9176534, 9174758, 9174619, 9173678, 9173286, 9173166, 9172712, 9171067, 9169711, 9168095, 9167317, 9165303, 9164764, 9161808, 9161556, 9160956, 9160836, 9160689, 9160561, 9159312, 9155257, 9155256, 9154242, 9154233, 9150220, 9149939, 9149802, 9148023, 9147933, 9147284, 9144975, 9143029, 9142456, 9136462, 9135729, 9135723, 9135100, 9134912, 9134421, 9133820, 9132134, 9131182, 9130548, 9127914, 9127890, 9123166, 9123032, 9122966, 9122596, 9122464, 9121253, 9121252, 9120201, 9117472, 9116609, 9116389, 9116087, 9115953, 9115952, 9115256, 9115179, 9114520, 9112857, 9112430, 9112061, 9111830, 9111782, 9109927, 9109922, 9109602, 9108737, 9108387, 9108337, 9108223, 9108222, 9108042, 9107343, 9107140, 9106548, 9106438, 9105109, 9103154, 9101895, 9101888, 9101545, 9100863, 9100299, 9098677, 9098510, 9097792, 9096298, 9095608, 9095569, 9095412, 9094465, 9094319, 9093762, 9093434, 9093284, 9093108, 9093061, 9093050, 9092777, 9091723, 9091680, 9091634, 9090934, 9090928, 9090711, 9090236, 9090234, 9090224, 9088944, 9088942, 9087883, 9087530, 9086784, 9086724, 9085868, 9085314, 9084252, 9083814, 9083775, 9083489, 9083152, 9082712, 9082529, 9082256, 9081426, 9081420, 9081346, 9080726, 9080333, 9080331, 9080329, 9079488, 9079481, 9078815, 9077320, 9077147, 9077134, 9076823, 9076800, 9076778, 9076198, 9076066, 9075968, 9075653, 9075136, 9074900, 9074438, 9074420, 9073844, 9073536, 9073430, 9072893, 9072718, 9072661, 9072570, 9072444, 9070480, 9069340, 9069008, 9068494, 9068011, 9067552, 9067317, 9067102, 9066786, 9066658, 9066263, 9066218, 9065631, 9065449, 9065360, 9065138, 9064586, 9063826, 9063715, 9063366, 9063126, 9062743, 9062538, 9062526, 9061997, 9061876, 9061210, 9061146, 9060623, 9060576, 9059976, 9059749, 9059147, 9058325, 9058090, 9058035, 9057581, 9057520, 9056513, 9055966, 9055937, 9055835, 9055761, 9055350, 9053918, 9053319, 9053312, 9052924, 9052831, 9052784, 9052314, 9052172, 9052145, 9051505, 9050990, 9050663, 9050548, 9050535, 9049842, 9049678, 9049081, 9048919, 9048918, 9048661, 9048480, 9047994, 9047816, 9046800, 9045331, 9044878, 9044788, 9044711, 9044472, 9044470, 9043709, 9043707, 9043430, 9040907, 9039907, 9039046, 9038970, 9038924, 9038071, 9037803, 9037168, 9037162, 9034577, 9034129, 9033572, 9033568, 9032573, 9032284, 9031357, 9031276, 9031227, 9030500, 9027330, 9027187, 9026119, 9026118, 9026117, 9026112, 9025878, 9023424, 9023036, 9021882, 9020335, 9020107, 9019209, 9017914, 9017337, 9017069, 9016747, 9016742, 9016436, 9016073, 9016069, 9015084, 9014891, 9013069, 9013001, 9012062, 9012061, 9011819, 9011751, 9011652, 9011595, 9010678, 9010500, 9009164, 9008490, 9008343, 9007712, 9006400, 9005591, 9005132, 9005072, 9005069, 9004939, 9004923, 9002978, 9002596, 9001855, 9000552, 9000215, 8999653, 8999652, 8999095, 8999077, 8998906, 8998822, 8997889, 8997577, 8996774, 8996410, 8996239, 8995963, 8995899, 8995896, 8995784, 8994457, 8992851, 8992832, 8992783, 8991861, 8991854, 8991438, 8990483, 8990040, 8988117, 8988036, 8988033, 8987395, 8987376, 8987374, 8986551, 8986550, 8986495, 8984672, 8984428, 8984345, 8983907, 8983080, 8983054, 8982881, 8980847, 8980189, 8979927, 8978886, 8978048, 8977719, 8977465, 8977436, 8976648, 8976300, 8975882, 8975010, 8974948, 8974372, 8973704, 8973685, 8972942, 8971718, 8971717, 8970736, 8970289, 8970064, 8969246, 8968712, 8968241, 8967562, 8967200, 8965993, 8965795, 8965465, 8965085, 8964838, 8963499, 8962807, 8962219, 8962020, 8961588, 8961491, 8961316, 8961120, 8960644, 8959962, 8957936, 8957413, 8957276, 8957274, 8957273, 8956841, 8956723, 8955310, 8955285, 8954984, 8954478, 8952666, 8952215, 8952098, 8950626, 8949701, 8948094, 8947626, 8947179, 8946558, 8942452, 8942383, 8940673, 8940021, 8938698, 8938538, 8938037, 8938033, 8938029, 8933889, 8933573, 8932824, 8932272, 8932271, 8930636, 8930321, 8928396, 8927376, 8927369, 8926845, 8926613, 8926458, 8924719, 8923969, 8922962, 8922450, 8922278, 8922277, 8922251, 8920855, 8920669, 8916690, 8916645, 8915377, 8914491, 8914270, 8914093, 8913968, 8913789, 8913640, 8913049, 8912962, 8911443, 8911440, 8911053, 8911006, 8910977, 8910772, 8909765, 8909684, 8909305, 8908330, 8907968, 8907458, 8905603, 8905454, 8905371, 8905293, 8904247, 8903295, 8903294, 8902552, 8902551, 8902550, 8902388, 8902245, 8901186, 8901095, 8900753, 8900542, 8900500, 8900058, 8900009, 8899868, 8899845, 8899843, 8899807, 8899284, 8898629, 8897279, 8897108, 8896850, 8895422, 8895330, 8894881, 8894662, 8894649, 8894646, 8894103, 8893749, 8893197, 8893168, 8892310, 8892086, 8892038, 8891953, 8891592, 8891473, 8891466, 8891463, 8891458, 8891330, 8891179, 8891174, 8891164, 8890498, 8889990, 8889987, 8889981, 8889662, 8889603, 8889601, 8889598, 8888940, 8888912, 8888911, 8888489, 8888169, 8887955, 8887952, 8887749, 8886721, 8886472, 8886470, 8886468, 8886467, 8886465, 8886464, 8885846, 8885725, 8885717, 8885678, 8885382, 8885018, 8884853, 8884852, 8884850, 8884848, 8884847, 8884708, 8884122, 8884104, 8882819, 8882816, 8882813, 8882777, 8882767, 8882761, 8882751, 8882312, 8882176, 8882050, 8881641, 8881634, 8881243, 8881061, 8880899, 8880874, 8880872, 8880871, 8880867, 8880866, 8880773, 8880772, 8880771, 8880770, 8880573, 8880567, 8880552, 8880409, 8879924, 8879871, 8879858, 8879330, 8879163, 8879160, 8879158, 8879156, 8879154, 8879126, 8879073, 8879066, 8879061, 8878875, 8878416, 8877452, 8877451, 8877450, 8877035, 8876373, 8876370, 8876367, 8876365, 8876357, 8876272, 8876184, 8875912, 8875906, 8875897, 8875786, 8875516, 8875250, 8875248, 8875158, 8875154, 8875092, 8874711, 8874708, 8874487, 8873597, 8873386, 8873252, 8873164, 8873157, 8872832, 8872819, 8872817, 8872810, 8872753, 8872628, 8872620, 8872618, 8872615, 8872612, 8872027, 8871614, 8871611, 8871608, 8871606, 8871590, 8871587, 8871581, 8871541, 8871537, 8871520, 8871501, 8871202, 8871143, 8870821, 8870418, 8870412, 8870411, 8870409, 8870406, 8870382, 8870379, 8870308, 8870302, 8870280, 8870268, 8870237, 8870221, 8869869, 8869828, 8869824, 8869777, 8869404, 8869398, 8869391, 8869295, 8869245, 8869000, 8868985, 8868881, 8868866, 8868830, 8868680, 8868512, 8868511, 8868508, 8868503, 8868501, 8868209, 8868201, 8868199, 8868189, 8867905, 8867773, 8867550, 8867434, 8867429, 8867426, 8867381, 8867379, 8867377, 8867376, 8867374, 8867272, 8866969, 8866867, 8866770, 8866598, 8866425, 8866423, 8866422, 8866210, 8866165, 8866156, 8866107, 8866065, 8865930, 8865929, 8865928, 8865927, 8865926, 8865821, 8865762, 8865757, 8865754, 8865752, 8865172, 8865105, 8865103, 8865099, 8865095, 8865092, 8864755, 8864749, 8864746, 8864742, 8864740, 8864707, 8864706, 8864552, 8864503, 8864457, 8864285, 8863982, 8863977, 8863976, 8863974, 8863972, 8863962, 8863961, 8863865, 8863864, 8863863, 8863695, 8862958, 8862954, 8862952, 8862948, 8862945, 8862815, 8862800, 8862767, 8862765, 8862759, 8862755, 8862124, 8862090, 8862089, 8862007, 8862001, 8862000, 8861995, 8861993, 8861909, 8861900, 8861894, 8861887, 8861333, 8861235, 8860788, 8860736, 8860714, 8860680, 8860549, 8860545, 8860538, 8860358, 8860060, 8860056, 8860053, 8860052, 8860050, 8859940, 8859869, 8859867, 8859861, 8859849, 8859777, 8859694, 8859690, 8859639, 8859564, 8859478, 8859298, 8859291, 8859229, 8859189, 8858797, 8858444, 8858356, 8858353, 8858351, 8858350, 8858348, 8858322, 8858173, 8858171, 8858169, 8858163, 8857767, 8857763, 8857748, 8857589, 8857312, 8857046, 8856968, 8856460, 8856458, 8856457, 8856456, 8856455, 8856326, 8856302, 8856202, 8856145, 8856142, 8855992, 8855942, 8855919, 8855631, 8855410, 8855407, 8855405, 8855403, 8855401, 8855092, 8855060, 8855019, 8855014, 8854802, 8854739, 8854737, 8854349, 8854325, 8854273, 8854095, 8853745, 8853465, 8853462, 8853460, 8853458, 8853457, 8853456, 8853436, 8853431, 8853406, 8853260, 8853227, 8853199, 8852586, 8852545, 8852534, 8851915, 8851783, 8851781, 8851780, 8851779, 8851778, 8851694, 8851611, 8851530, 8851448, 8851083, 8850965, 8850964, 8850398, 8850023, 8849988, 8849735, 8849734, 8849732, 8849730, 8849726, 8849724, 8849491, 8849366, 8849297, 8849261, 8849054, 8848900, 8848671, 8848484, 8848482, 8848478, 8848476, 8848474, 8848378, 8848360, 8847822, 8847660, 8847659, 8847656, 8847655, 8847653, 8847643, 8847481, 8847469, 8847468, 8847405, 8847350, 8847325, 8847315, 8847308, 8847291, 8847289, 8846796, 8846708, 8846665, 8846467, 8846465, 8846359, 8846247, 8845958, 8845904, 8845789, 8845782, 8845772, 8845719, 8845718, 8845688, 8845682, 8845680, 8845552, 8845429, 8845394, 8845175, 8845174, 8844981, 8844978, 8844977, 8844975, 8844971, 8844614, 8844607, 8844598, 8844531, 8844530, 8844528, 8844076, 8844075, 8844074, 8844072, 8844069, 8844064, 8844045, 8844029, 8844028, 8843942, 8843905, 8843580, 8843574, 8843566, 8843135, 8842921, 8842859, 8842854, 8842737, 8842726, 8842718, 8842573, 8842416, 8842401, 8842325, 8841817, 8841615, 8841613, 8841612, 8841609, 8841607, 8841496, 8841491, 8841488, 8841433, 8841175, 8840444, 8840218, 8840007, 8840000, 8839993, 8839989, 8839816, 8839571, 8839566, 8839564, 8839563, 8839561, 8839483, 8839479, 8839476, 8839470, 8839452, 8839158, 8839059, 8838692, 8838691, 8838683, 8838673, 8837916, 8837911, 8837910, 8837909, 8837907, 8837836, 8837639, 8837638, 8837432, 8837426, 8837420, 8837416, 8837313, 8836622, 8836619, 8836593, 8836588, 8836256, 8836205, 8836130, 8836108, 8836042, 8836038, 8835767, 8835627, 8835625, 8835606, 8835584, 8835583, 8835582, 8835579, 8835576, 8835568, 8835483, 8835474, 8835444, 8835439, 8834951, 8834796, 8834560, 8834350, 8834229, 8834204, 8834197, 8834072, 8834071, 8833964, 8833633, 8833631, 8833630, 8833629, 8833628, 8833269, 8833262, 8833157, 8833115, 8833106, 8833104, 8832903, 8832761, 8832754, 8832385, 8832245, 8832105, 8832075, 8832016, 8831799, 8831721, 8831654, 8831612, 8831609, 8831608, 8831607, 8831605, 8831542, 8831310, 8831309, 8831167, 8830875, 8830871, 8830652, 8830527, 8830520, 8830516, 8830295, 8830120, 8830119, 8829745, 8829744, 8829684, 8829678, 8829670, 8829659, 8828677, 8828676, 8828675, 8828673, 8828669, 8828497, 8828494, 8828487, 8828484, 8828116, 8827998, 8827474, 8827467, 8827465, 8827096, 8827094, 8827092, 8827091, 8827090, 8826977, 8826923, 8826912, 8826910, 8826755, 8826741, 8826715, 8826538, 8826472, 8826467, 8826453, 8826448, 8825993, 8825990, 8825988, 8825986, 8825984, 8825970, 8825967, 8825966, 8825964, 8825960, 8825816, 8825600, 8825595, 8825461, 8825423, 8825250, 8825242, 8825230, 8825106, 8824793, 8824720, 8824711, 8824710, 8824709, 8824573, 8824540, 8824467, 8824403, 8824178, 8824168, 8824055, 8823642, 8823641, 8823639, 8823315, 8823107, 8823097, 8822910, 8822814, 8822810, 8822807, 8822805, 8822803, 8822616, 8822610, 8822608, 8822599, 8822455, 8822385, 8821995, 8821977, 8821819, 8821743, 8821517, 8821516, 8821514, 8821511, 8821493, 8821153, 8820760, 8820617, 8820430, 8820428, 8820425, 8820419, 8819911, 8819799, 8819789, 8819762, 8819741, 8819539, 8819537, 8819058, 8819054, 8819052, 8819048, 8819047, 8818975, 8818743, 8818734, 8818724, 8818718, 8818622, 8818085, 8818053, 8818022, 8817976, 8817945, 8817370, 8817336, 8817321, 8816938, 8816920, 8816865, 8816846, 8816774, 8816771, 8816668, 8816653, 8816645, 8816135, 8815479, 8815421, 8815415, 8815412, 8815130, 8815128, 8815113, 8815103, 8815091, 8815089, 8815071, 8815067, 8814859, 8814745, 8814695, 8814685, 8814674, 8814654, 8814584, 8814206, 8813630, 8813608, 8813243, 8813204, 8813179, 8813175, 8812926, 8812823, 8812819, 8812670, 8812665, 8812658, 8812656, 8812602, 8812526, 8811948, 8811941, 8811938, 8811929, 8811743, 8811738, 8811377, 8811376, 8810876, 8810836, 8810806, 8810493, 8810491, 8810483, 8810480, 8810478, 8810099, 8809837, 8809683, 8809652, 8809648, 8809594, 8809356, 8809311, 8809305, 8809303, 8809299, 8809216, 8809178, 8808997, 8808957, 8808949, 8808828, 8808745, 8808684, 8808682, 8808674, 8808669, 8808661, 8808574, 8808554, 8808292, 8808291, 8808211, 8807846, 8807817, 8807742, 8807710, 8807702, 8807699, 8807692, 8807630, 8807383, 8807349, 8807213, 8807208, 8807194, 8807191, 8806011, 8806007, 8806006, 8806002, 8805918, 8805869, 8805861, 8805852, 8805820, 8805682, 8805659, 8805222, 8805217, 8805171, 8805168, 8805166, 8805131, 8804931, 8804849, 8804784, 8804217, 8804091, 8803891, 8803762, 8803761, 8803747, 8802963, 8802962, 8802961, 8802958, 8802777, 8802727, 8802719, 8802544, 8802542, 8802540, 8802538, 8802536, 8802498, 8802211, 8802144, 8801965, 8801953, 8801946, 8801942, 8801939, 8801936, 8801887, 8801571, 8801166, 8801134, 8800966, 8800889, 8800866, 8800862, 8800846, 8800843, 8800202, 8800173, 8800087, 8800051, 8799728, 8799152, 8798960, 8798940, 8798934, 8798914, 8798843, 8798841, 8798839, 8798836, 8798833, 8798804, 8798803, 8798802, 8798770, 8798611, 8797707, 8797598, 8797513, 8797431, 8797301, 8797092, 8797084, 8797083, 8797080, 8797077, 8796949, 8796934, 8796931, 8796926, 8796920, 8796918, 8796692, 8796291, 8796238, 8796042, 8795797, 8795796, 8795794, 8795793, 8795537, 8795534, 8795530, 8795528, 8795522, 8795520, 8795471, 8795321, 8795081, 8795073, 8795043, 8794951, 8794546, 8794501, 8794499, 8794498, 8794497, 8794174, 8794090, 8793740, 8793322, 8793316, 8793313, 8793306, 8793116, 8792915, 8792910, 8792890, 8792826, 8792825, 8792821, 8792514, 8792457, 8792262, 8792123, 8792059, 8792034, 8791994, 8791980, 8791264, 8790846, 8790843, 8790721, 8790709, 8790579, 8790509, 8790371, 8790368, 8790366, 8789609, 8789419, 8788786, 8788413, 8788192, 8788013, 8788000, 8787947, 8787893, 8787821, 8787818, 8787815, 8787810, 8787609, 8787579, 8787572, 8787570, 8787567, 8787516, 8787493, 8787492, 8786741, 8786617, 8786613, 8786609, 8786606, 8785171, 8784720, 8784713, 8784638, 8784618, 8784617, 8784616, 8784614, 8784611, 8783310, 8782903, 8781570, 8780939, 8780612, 8779875, 8779596, 8779569, 8779509, 8779283, 8778759, 8778675, 8778590, 8778588, 8778587, 8778251, 8778250, 8778248, 8778247, 8778071, 8777932, 8777867, 8777595, 8777534, 8777502, 8777462, 8777453, 8777410, 8777125, 8777075, 8777063, 8777062, 8777059, 8777057, 8775848, 8775824, 8775581, 8775275, 8775145, 8774925, 8774759, 8774756, 8774754, 8774750, 8774331, 8774186, 8774008, 8773923, 8773921, 8773917, 8773915, 8773790, 8773329, 8773328, 8773269, 8773268, 8773266, 8773265, 8773264, 8773196, 8773193, 8773110, 8773068, 8773051, 8772888, 8772833, 8772829, 8772827, 8772826, 8772824, 8772647, 8772646, 8772645, 8772644, 8772411, 8772219, 8772125, 8771690, 8771683, 8771679, 8771678, 8771534, 8771313, 8770676, 8770576, 8770573, 8770571, 8770566, 8770562, 8770323, 8769945, 8769889, 8769784, 8769689, 8769687, 8769686, 8769680, 8769672, 8769319, 8769222, 8768908, 8768853, 8768676, 8768655, 8768568, 8768566, 8768563, 8768559, 8768063, 8767835, 8767734, 8767606, 8767557, 8767505, 8767291, 8767290, 8767289, 8767286, 8767281, 8766980, 8766668, 8766667, 8766665, 8766663, 8766431, 8766428, 8766426, 8766423, 8766422, 8766369, 8766311, 8766275, 8766227, 8765973, 8765963, 8765902, 8765782, 8765650, 8765461, 8765410, 8765409, 8765407, 8765404, 8765403, 8765301, 8765148, 8764965, 8764922, 8764921, 8764920, 8764919, 8764783, 8764569, 8764567, 8764561, 8764559, 8764523, 8764242, 8764203, 8763928, 8763925, 8763877, 8763561, 8763559, 8763557, 8763555, 8763290, 8763130, 8763125, 8763121, 8763119, 8763115, 8762965, 8762922, 8762539, 8762484, 8762296, 8762128, 8762126, 8762125, 8762120, 8762118, 8761703, 8761429, 8760985, 8760983, 8760977, 8760975, 8760733, 8760731, 8760728, 8760727, 8760603, 8760560, 8759811, 8759808, 8759806, 8759801, 8759765, 8759518, 8759488, 8759431, 8759416, 8759341, 8759086, 8759009, 8759004, 8759002, 8759001, 8758558, 8758501, 8758499, 8758497, 8758489, 8757827, 8757805, 8757469, 8757466, 8757465, 8757463, 8757183, 8757095, 8757092, 8757042, 8757041, 8757036, 8756897, 8756894, 8756889, 8756783, 8756373, 8756372, 8756370, 8756368, 8756282, 8756180, 8756009, 8756005, 8756003, 8755998, 8755404, 8755402, 8755364, 8755359, 8755127, 8755123, 8755116, 8754739, 8753880, 8753879, 8753877, 8753874, 8753627, 8753625, 8753620, 8753224, 8753206, 8753031, 8752765, 8752763, 8752759, 8752755, 8752460, 8752456, 8752455, 8752454, 8751766, 8751721, 8751719, 8751718, 8751717, 8751715, 8751602, 8751340, 8751143, 8751141, 8751069, 8751027, 8751022, 8751021, 8751019, 8750897, 8750895, 8750893, 8750892, 8750886, 8750742, 8750184, 8750183, 8750181, 8750180, 8750000, 8749984, 8749979, 8749973, 8749651, 8749540, 8749318, 8748957, 8748922, 8748920, 8748916, 8748910, 8748822, 8748817, 8748812, 8748807, 8748492, 8748378, 8748255, 8748254, 8748238, 8747911, 8747901, 8747896, 8747893, 8747795, 8747792, 8747787, 8747784, 8747348, 8747299, 8747296, 8746894, 8746890, 8746886, 8746885, 8746756, 8746755, 8746753, 8746750, 8746749, 8746423, 8746020, 8745839, 8745837, 8745835, 8745831, 8745829, 8745821, 8745563, 8745376, 8745335, 8745334, 8745333, 8745330, 8745169, 8745163, 8745127, 8745125, 8744635, 8744595, 8744592, 8744591, 8744590, 8744580, 8744443, 8744439, 8744438, 8744435, 8743724, 8743717, 8743715, 8743713, 8743711, 8743188, 8742444, 8742361, 8742360, 8742355, 8742353, 8742229, 8742226, 8742224, 8742222, 8742221, 8741699, 8741696, 8741695, 8741693, 8741678, 8741672, 8741661, 8741545, 8741544, 8741542, 8741541, 8741056, 8740885, 8740610, 8740609, 8740608, 8740606, 8740605, 8740602, 8740201, 8739730, 8739729, 8739727, 8739725, 8739255, 8739254, 8739252, 8739248, 8739246, 8739233, 8739231, 8739230, 8739229, 8739228, 8738851, 8738850, 8738849, 8738847, 8738707, 8738705, 8738704, 8738699, 8738698, 8738578, 8738388, 8738385, 8738318, 8738317, 8738316, 8738314, 8738313, 8738256, 8737823, 8737822, 8737821, 8737817, 8737814, 8737530, 8737488, 8737487, 8737486, 8737317, 8737103, 8736954, 8736697, 8736674, 8736650, 8736304, 8736303, 8736302, 8736300, 8736298, 8736249, 8736243, 8736217, 8736171, 8736165, 8736141, 8736134, 8736133, 8736132, 8736131, 8736065, 8735946, 8735945, 8735944, 8735943, 8735942, 8735897, 8735817, 8735710, 8735708, 8735707, 8735706, 8735681, 8735680, 8735679, 8735662, 8735660, 8735549, 8735363, 8735325, 8735324, 8735323, 8735322, 8735318, 8735315, 8735313, 8735312, 8735311, 8734791, 8734789, 8734787, 8734786, 8734696, 8734692, 8734690, 8734687, 8734683, 8734504, 8734502, 8734493, 8734371, 8734283, 8734281, 8734278, 8734276, 8734272, 8734271, 8734113, 8734109, 8734108, 8734106, 8734103, 8733961, 8733617, 8733615, 8733614, 8733613, 8733432, 8733431, 8733413, 8733409, 8733407, 8733401, 8733395, 8733392, 8733104, 8733101, 8733100, 8733099, 8732966, 8732941, 8732722, 8732721, 8732718, 8732715, 8732714, 8732639, 8732624, 8732249, 8732246, 8732244, 8732243, 8732229, 8732228, 8732227, 8732226, 8732224, 8732221, 8732174, 8732162, 8732161, 8731764, 8731749, 8731458, 8731269, 8731190, 8731186, 8731183, 8731180, 8731178, 8731163, 8731154, 8731151, 8731148, 8730899, 8730851, 8730735, 8730361, 8730305, 8730303, 8730299, 8730296, 8730057, 8730056, 8730055, 8730054, 8729541, 8729537, 8729311, 8729307, 8729305, 8729301, 8729292, 8729031, 8729030, 8729028, 8729027, 8729026, 8728311, 8728083, 8728081, 8728080, 8728079, 8728076, 8728075, 8727812, 8727497, 8727492, 8727489, 8727488, 8727485, 8727458, 8727457, 8727455, 8727449, 8726841, 8726838, 8726834, 8726830, 8726829, 8726810, 8726777, 8726729, 8726726, 8726722, 8726717, 8726715, 8726133, 8725839, 8725571, 8725568, 8725567, 8725564, 8725493, 8725241, 8725209, 8725124, 8725066, 8724951, 8724818, 8724817, 8724815, 8724800, 8724789, 8724786, 8724702, 8724327, 8724290, 8724042, 8724040, 8724039, 8724038, 8724036, 8723966, 8723961, 8723958, 8723948, 8723944, 8723940, 8723336, 8723199, 8723197, 8722832, 8722830, 8722565, 8722564, 8722563, 8722551, 8722543, 8722532, 8722230, 8722227, 8722141, 8721648, 8721622, 8721563, 8721560, 8721557, 8721547, 8721536, 8720773, 8720720, 8720719, 8720718, 8720715, 8720682, 8720672, 8720671, 8720665, 8720662, 8720658, 8720652, 8720611, 8720387, 8720285, 8720278, 8720052, 8719781, 8719780, 8719778, 8719776, 8719619, 8719612, 8719597, 8719591, 8719388, 8719364, 8718950, 8718949, 8718947, 8718942, 8718601, 8718581, 8718578, 8718574, 8718316, 8718119, 8718050, 8717848, 8717821, 8717817, 8717812, 8717784, 8717776, 8717577, 8717576, 8717485, 8717482, 8717479, 8717475, 8717270, 8717268, 8717267, 8717266, 8717262, 8717229, 8717133, 8717035, 8716440, 8716438, 8716433, 8716430, 8716408, 8716375, 8716366, 8716112, 8716110, 8716105, 8716100, 8715795, 8715325, 8715245, 8715161, 8715159, 8715149, 8714934, 8714932, 8714931, 8714930, 8714747, 8714515, 8714379, 8714364, 8714326, 8714207, 8714205, 8714200, 8714198, 8714183, 8714181, 8714178, 8714177, 8713646, 8713400, 8713090, 8713089, 8713004, 8712121, 8711586, 8711460, 8711154, 8711069, 8710749, 8709897, 8709798, 8709636, 8709599, 8709526, 8709422, 8709385, 8709384, 8708471, 8707724, 8707299, 8707109, 8706144, 8706125, 8705697, 8705630, 8705629, 8705628, 8705390, 8705342, 8704046, 8703972, 8703627, 8702079, 8702020, 8701802, 8701673, 8701641, 8701128, 8700969, 8700015, 8699701, 8699417, 8698761, 8698750, 8698501, 8698209, 8698136, 8698012, 8698003, 8697075, 8696621, 8695981, 8695959, 8695779, 8695507, 8695155, 8695138, 8695009, 8694031, 8693110, 8692207, 8691935, 8691922, 8691778, 8691074, 8690841, 8690835, 8690586, 8690388, 8689937, 8689814, 8689285, 8688693, 8688506, 8688116, 8688089, 8687567, 8687135, 8686934, 8686835, 8686833, 8686775, 8686508, 8686225, 8684794, 8684377, 8683285, 8682534, 8682520, 8682010, 8681972, 8681783, 8681671, 8681625, 8681303, 8681299, 8680958, 8680855, 8680553, 8680527, 8680215, 8679996, 8679919, 8679551, 8678596, 8677905, 8677857, 8677673, 8676855, 8676537, 8676466, 8676407, 8676275, 8675840, 8675799, 8674874, 8674566, 8674481, 8674134, 8673718, 8672926, 8671861, 8671824, 8671601, 8671383, 8669256, 8668168, 8667959, 8667872, 8667499, 8666624, 8664533, 8664530, 8664001, 8663830, 8663824, 8661325, 8659920, 8659403, 8659124, 8658762, 8657608, 8657536, 8657396, 8656892, 8656813, 8656242, 8654771, 8653317, 8652793, 8652143, 8651903, 8651747, 8650785, 8650580, 8650255, 8650250, 8650125, 8649461, 8648830, 8648253, 8648228, 8648138, 8648110, 8647147, 8646658, 8645700, 8645538, 8645502, 8643764, 8641973, 8640385, 8640221, 8639416, 8639366, 8638509, 8638089, 8637894, 8637737, 8637346, 8637297, 8636984, 8636752, 8635064, 8634407, 8634239, 8633446, 8633374, 8633370, 8632322, 8632201, 8632164, 8630391, 8630213, 8629633, 8629310, 8629114, 8629041, 8628299, 8627853, 8627104, 8625624, 8625555, 8624682, 8623928, 8622157, 8620923, 8620412, 8619264, 8617488, 8617099, 8616924, 8616492, 8616370, 8615518, 8614744, 8614610, 8614595, 8613980, 8613839, 8613026, 8612924, 8612040, 8611962, 8611796, 8611430, 8610118, 8609542, 8609344, 8609155, 8609103, 8609102, 8608667, 8608230, 8608156, 8607801, 8607369, 8606839, 8606408, 8606333, 8605209, 8604472, 8604191, 8603146, 8602302, 8601714, 8601651, 8601429, 8600949, 8600827, 8600721, 8600618, 8600350, 8600343, 8599745, 8598683, 8597633, 8597476, 8596287, 8595001, 8591355, 8589557, 8588870, 8588389, 8587528, 8587518, 8586787, 8586756, 8586665, 8586585, 8586271, 8584657, 8584386, 8583477, 8580267, 8580205, 8578982, 8578767, 8578413, 8576561, 8576263, 8575125, 8574875, 8574625, 8574228, 8573870, 8572769, 8572547, 8571429, 8569207, 8568137, 8568015, 8567629, 8567386, 8567246, 8566974, 8566972, 8565688, 8565438, 8564218, 8564171, 8564170, 8564169, 8564168, 8563866, 8563132, 8563024, 8562312, 8562201, 8561899, 8561779, 8561676, 8561652, 8560947, 8560239, 8559316, 8559160, 8557658, 8557621, 8557137, 8556781, 8556342, 8554898, 8554810, 8554659, 8553941, 8553543, 8553007, 8551835, 8551329, 8550870, 8549077, 8547824, 8547561, 8546647, 8546646, 8546454, 8546341, 8545619, 8545305, 8544855, 8543976, 8543456, 8542314, 8542310, 8540835, 8540342, 8539933, 8539625, 8539277, 8538492, 8537722, 8536856, 8536671, 8536670, 8536591, 8535593, 8534089, 8534009, 8533907, 8533440, 8532933, 8532644, 8532283, 8531025, 8530581, 8530066, 8529418, 8529417, 8526131, 8525135, 8523269, 8520271, 8520205, 8520142, 8515412, 8514132, 8513132, 8513103, 8511730, 8506015, 8504518, 8502346, 8501881, 8500498, 8487740, 8485030, 8475960, 8469644, 8454153, 8446088, 8435058, 8423593, 8422854, 8391274, 8380489, 8371474, 8370800, 8365647, 8362658, 8288213, 7364122, 5437886)
Run Time: 0.078073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2985 | |
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 | | | | | 2985 | |
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",22],["thread",9525270],["thread",9496201],["thread",9478169],["thread",9436408],["thread",9436401],["thread",9435046],["thread",9405236],["thread",9399644],["thread",9385922],["thread",9379752],["thread",9372499],["thread",9366699],["thread",9361297],["thread",9360709],["thread",9330122],["thread",9323356],["thread",9323339],["thread",9314949],["thread",9314674],["thread",9300715],["thread",9294327],["thread",9294200],["thread",9281542],["thread",9281501],["thread",9263775],["thread",9259551],["thread",9258192],["thread",9256674],["thread",9240777],["thread",9219260],["thread",9217974],["thread",9207768],["thread",9203226],["thread",9194422],["thread",9190045],["thread",9189127],["thread",9184554],["thread",9182042],["thread",9177164],["thread",9173678],["thread",9173286],["thread",9168095],["thread",9159312],["thread",9150220],["thread",9148023],["thread",9142456],["thread",9135723],["thread",9130548],["thread",9122464],["thread",9117472],["thread",9112430],["thread",9109927],["thread",9109922],["thread",9106438],["thread",9101895],["thread",9093434],["thread",9092777],["thread",9091680],["thread",9090224],["thread",9088942],["thread",9087883],["thread",9083775],["thread",9083489],["thread",9076778],["thread",9075968],["thread",9074438],["thread",9074420],["thread",9073536],["thread",9068494],["thread",9067317],["thread",9066786],["thread",9066263],["thread",9063826],["thread",9063126],["thread",9062526],["thread",9061997],["thread",9061146],["thread",9058090],["thread",9057581],["thread",9055966],["thread",9052784],["thread",9052145],["thread",9050990],["thread",9050535],["thread",9043707],["thread",9043430],["thread",9037803],["thread",9032573],["thread",9031276],["thread",9027187],["thread",9023036],["thread",9020107],["thread",9016436],["thread",9010500],["thread",9009164],["thread",9006400],["thread",9005132],["thread",9004939],["thread",8999653],["thread",8996239],["thread",8995899],["thread",8992851],["thread",8984428],["thread",8975010],["thread",8974372],["thread",8973685],["thread",8969246],["thread",8965993],["thread",8965465],["thread",8962807],["thread",8961588],["thread",8960644],["thread",8957413],["thread",8952666],["thread",8952098],["thread",8950626],["thread",8948094],["thread",8947179],["thread",8946558],["thread",8942383],["thread",8938538],["thread",8933889],["thread",8932824],["thread",8930636],["thread",8926845],["thread",8926458],["thread",8922450],["thread",8922278],["thread",8922251],["thread",8913968],["thread",8912962],["thread",8911053],["thread",8909305],["thread",8907458],["thread",8905371],["thread",8902552],["thread",8901095],["thread",8900753],["thread",8900058],["thread",8899843],["thread",8899284],["thread",8897279],["thread",8896850],["thread",8894881],["thread",8887749],["thread",8886721],["thread",8885725],["thread",8885717],["thread",8885678],["thread",8882176],["thread",8879924],["thread",8878875],["thread",8877035],["thread",8876272],["thread",8874711],["thread",8872027],["thread",8869869],["thread",8869777],["thread",8868985],["thread",8867272],["thread",8864707],["thread",8862090],["thread",8860680],["thread",8859849],["thread",8859777],["thread",8859690],["thread",8855992],["thread",8855919],["thread",8854737],["thread",8854273],["thread",8853227],["thread",8851915],["thread",8849988],["thread",8849297],["thread",8845782],["thread",8845175],["thread",8843942],["thread",8842573],["thread",8841433],["thread",8840218],["thread",8839816],["thread",8839452],["thread",8837639],["thread",8836108],["thread",8836042],["thread",8835474],["thread",8834951],["thread",8834560],["thread",8833964],["thread",8832761],["thread",8832075],["thread",8831654],["thread",8830295],["thread",8830120],["thread",8827998],["thread",8826448],["thread",8825816],["thread",8825461],["thread",8821153],["thread",8818622],["thread",8817370],["thread",8814695],["thread",8813630],["thread",8810806],["thread",8809683],["thread",8809216],["thread",8808997],["thread",8808291],["thread",8808211],["thread",8804849],["thread",8804784],["thread",8802211],["thread",8801965],["thread",8801166],["thread",8797598],["thread",8797513],["thread",8797301],["thread",8796291],["thread",8795321],["thread",8794090],["thread",8793322],["thread",8793316],["thread",8792826],["thread",8792262],["thread",8791264],["thread",8789609],["thread",8788192],["thread",8784638],["thread",8784611],["thread",8780939],["thread",8778071],["thread",8777932],["thread",8777867],["thread",8777595],["thread",8775848],["thread",8775145],["thread",8774925],["thread",8774186],["thread",8774008],["thread",8773329],["thread",8773266],["thread",8773068],["thread",8773051],["thread",8772647],["thread",8772411],["thread",8772219],["thread",8771534],["thread",8769319],["thread",8768908],["thread",8768853],["thread",8768655],["thread",8768063],["thread",8766980],["thread",8766311],["thread",8766275],["thread",8765963],["thread",8765782],["thread",8765301],["thread",8763877],["thread",8762965],["thread",8761703],["thread",8759488],["thread",8757805],["thread",8756783],["thread",8753031],["thread",8751340],["thread",8751143],["thread",8751141],["thread",8750742],["thread",8748238],["thread",8746423],["thread",8740602],["thread",8738578],["thread",8738385],["thread",8737530],["thread",8736954],["thread",8736674],["thread",8736065],["thread",8735897],["thread",8735363],["thread",8734493],["thread",8733432],["thread",8731269],["thread",8730899],["thread",8730851],["thread",8730361],["thread",8729305],["thread",8726133],["thread",8723199],["thread",8722227],["thread",8721648],["thread",8720682],["thread",8720285],["thread",8719388],["thread",8717268],["thread",8713090],["thread",8712121],["thread",8709636],["thread",8707109],["thread",8705630],["thread",8703627],["thread",8702020],["thread",8701802],["thread",8701673],["thread",8701128],["thread",8700015],["thread",8699701],["thread",8699417],["thread",8698761],["thread",8698501],["thread",8698136],["thread",8695779],["thread",8695138],["thread",8694031],["thread",8692207],["thread",8691935],["thread",8690586],["thread",8689285],["thread",8688089],["thread",8687567],["thread",8687135],["thread",8686934],["thread",8686775],["thread",8682534],["thread",8682520],["thread",8681972],["thread",8681783],["thread",8680958],["thread",8679996],["thread",8676537],["thread",8676275],["thread",8675840],["thread",8675799],["thread",8674566],["thread",8672926],["thread",8667959],["thread",8666624],["thread",8664533],["thread",8664001],["thread",8663830],["thread",8658762],["thread",8657608],["thread",8657536],["thread",8657396],["thread",8656813],["thread",8656242],["thread",8652793],["thread",8652143],["thread",8651903],["thread",8651747],["thread",8650785],["thread",8650580],["thread",8650255],["thread",8650250],["thread",8650125],["thread",8648830],["thread",8648253],["thread",8648138],["thread",8648110],["thread",8646658],["thread",8645502],["thread",8641973],["thread",8640385],["thread",8640221],["thread",8638509],["thread",8637894],["thread",8637737],["thread",8637346],["thread",8637297],["thread",8634407],["thread",8633446],["thread",8633370],["thread",8632201],["thread",8630391],["thread",8629041],["thread",8628299],["thread",8627853],["thread",8625624],["thread",8620923],["thread",8617488],["thread",8613980],["thread",8613026],["thread",8611430],["thread",8609542],["thread",8609155],["thread",8609103],["thread",8607801],["thread",8607369],["thread",8606408],["thread",8604472],["thread",8604191],["thread",8603146],["thread",8602302],["thread",8601651],["thread",8601429],["thread",8600949],["thread",8600721],["thread",8600618],["thread",8600350],["thread",8600343],["thread",8599745],["thread",8598683],["thread",8597633],["thread",8595001],["thread",8589557],["thread",8588870],["thread",8588389],["thread",8587528],["thread",8586787],["thread",8586756],["thread",8586665],["thread",8586585],["thread",8586271],["thread",8584657],["thread",8578982],["thread",8578413],["thread",8574625],["thread",8573870],["thread",8572547],["thread",8571429],["thread",8568137],["thread",8567629],["thread",8567386],["thread",8567246],["thread",8564171],["thread",8563866],["thread",8563132],["thread",8563024],["thread",8561779],["thread",8561652],["thread",8560239],["thread",8557658],["thread",8557621],["thread",8557137],["thread",8556781],["thread",8556342],["thread",8554810],["thread",8554659],["thread",8553543],["thread",8553007],["thread",8551835],["thread",8550870],["thread",8549077],["thread",8547824],["thread",8547561],["thread",8546454],["thread",8545619],["thread",8545305],["thread",8543976],["thread",8540342],["thread",8539277],["thread",8538492],["thread",8537722],["thread",8536856],["thread",8536591],["thread",8534089],["thread",8533907],["thread",8533440],["thread",8532644],["thread",8530066],["thread",8526131],["thread",8523269],["thread",8520271],["thread",8520205],["thread",8520142],["thread",8515412],["thread",8514132],["thread",8513132],["thread",8513103],["thread",8511730],["thread",8504518],["thread",8502346],["thread",8501881],["thread",8500498],["thread",8485030],["thread",8475960],["thread",8469644],["thread",8454153],["thread",8446088],["thread",8435058],["thread",8422854],["thread",8391274],["thread",8380489],["thread",8370800],["thread",8365647],["thread",8362658],["thread",8288213],["thread",7364122],["thread",5437886]], 490, tinhte_xentag_tag, , {"tags":["samsung galaxy s7 edge"]}, date, 0, , [], 0, 1656289876, 91d72c5fa0a6dce38dc2300ff6a6e95f
Run Time: 0.001039