Forum Regular slow query - help with identification

[محروم.كوم]

Hi all

The following query keeps appearing in my slow query log every few minutes. I disabled hooks to ensure it is part of the core vbulletin code and still appears.

Code:
# Query_time: 14 Lock_time: 0 Rows_sent: 10 Rows_examined: 7201
SELECT post.postid, post.attach
FROM post AS post

WHERE post.threadid = 28509
AND post.visible = 1
AND post.userid NOT IN (3472,11,4180)

ORDER BY post.dateline
LIMIT 3590, 10;
I looked at those userids and eventually found they are listed in the "global ignore" (user banning options page)
Is this userid lookup intensive? If so, I'll get rid of them and rebuild thread and then forum information.

Secondly, (also with hooks off) I also see things like this query regularly in the slow query log (note the vast lists of attachment ids):
Code:
# Query_time: 11 Lock_time: 0 Rows_sent: 0 Rows_examined: 59882
(
SELECT
a.attachmentid, a.contenttypeid, a.displayorder
FROM attachment AS a
INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN post AS post ON (post.postid = a.contentid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN user AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 1 AND
(
(
a.contentid = 0
AND
a.userid = 0
)
OR
(
thread.forumid IN (0) AND (
thread.forumid IN (0)
OR
thread.postuserid = 0
) AND (
a.state 'moderation'
OR
a.userid = 0
OR
thread.forumid IN (0)
) AND (
(
post.visible = 1
AND
thread.visible = 1
)
OR
(
thread.forumid IN (0)
)
OR
(
thread.forumid IN (0)
AND
post.visible = 2
AND
thread.visible = 2
)
)
)
)
AND a.attachmentid IN (1, 2, 3, 7, 8, 54, 10, 13, 14, 16, 17, 26, 27, 29, 86, 255, 257, 259, 280, 282, 283, 284, 295, 297, 298, 299, 300, 301, 302, 303, 354, 355, 359, 360, 361, 362, 363, 367, 370, 374, 375, 376, 377, 378, 379, 390, 391, 392, 394, 395, 396, 397, 398, 412, 413, 414, 417, 420, 423, 438, 441, 444, 445, 450, 451, 491, 505, 507, 531, 538, 569, 570, 571, 576, 577, 610, 611, 613, 614, 615, 616, 623, 624, 1164, 627, 636, 637, 640, 645, 646, 648, 649, 650, 651, 652, 653, 659, 678, 680, 681, 682, 683, 684, 685, 686, 688, 689, 690, 702, 703, 704, 705, 706, 707, 713, 714, 715, 716, 717, 719, 722, 723, 724, 725, 726, 727, 728, 731, 732, 737, 755, 756, 757, 759, 771, 776, 777, 778, 781, 784, 786, 787, 789, 790, 791, 792, 805, 827, 831, 833, 834, 866, 867, 868, 869, 874, 875, 900, 901, 909, 913, 914, 915, 919, 920, 926, 927, 928, 929, 936, 942, 951, 981, 955, 956, 957, 958, 994, 996, 997, 999, 1004, 1005, 1006, 1008, 1009, 1010, 1011, 1012, 1028, 1045, 1054, 1061, 1065, 1066, 1067, 1068, 1073, 1074, 1077, 1078, 1080, 1098, 1099, 1100, 1105, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1132, 1133, 1168, 1172, 1186, 1187, 1188, 1189, 1190, 1191, 1206, 1210, 1216, 1217, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1277, 1278, 1281, 1351, 1352, 1356, 1357, 1358, 1366, 1370, 1391, 1392, 1393, 1394, 1397, 1399, 1401, 7065, 1402, 7066, 1403, 7067, 1406, 1421, 1422, 1423, 1427, 2869, 1428, 1429, 1431, 1436, 1435, 1439, 1445, 1446, 1447, 1483, 1490, 1516, 1517, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1532, 1534, 1536, 1537, 1553, 1554, 1561, 1590, 1609, 1610, 1611, 1619, 1631, 1651, 1652, 1653, 1654, 1656, 1657, 1658, 1659, 1660, 1661, 1670, 1683, 1695, 1716, 1724, 1725, 1726, 1727, 1729, 1730, 1733, 1741, 1742, 1743, 1747, 1750, 1751, 1752, 1753, 1755, 1757, 1759, 1762, 1763, 1765, 1766, 1783, 1784, 1787, 1788, 1797, 1800, 1801, 1802, 1820, 1821, 1839, 1865, 1866, 1870, 1883, 1901, 1902, 1903, 1909, 1918, 1921, 1939, 1943, 1955, 1957, 1982, 1986, 1988, 2027, 2037, 2038, 2039, 2040, 2048, 2049, 2050, 2051, 2052, 2053, 2054, 2055, 2056, 2057, 2058, 2059, 2064, 2073, 2080, 2081, 2082, 2083, 2139, 2085, 2086, 2087, 2090, 2091, 2093, 2094, 2095, 2105, 2117, 2118, 2119, 2120, 2138, 2142, 2143, 2146, 2150, 2166, 2174, 2175, 2185, 2186, 2188, 2189, 2190, 2249, 2255, 2257, 2258, 2261, 2266, 2267, 2268, 2277, 2281, 2282, 2283, 2284, 2285, 2286, 2287, 2288, 2289, 2290, 2291, 2292, 2293, 2295, 2296, 2298, 2301, 2304, 2321, 2323, 2325, 2326, 2334, 2337, 2338, 2339, 2340, 2341, 2342, 2350, 2351, 2355, 2370, 2385, 2371, 2372, 2373, 2375, 2382, 2383, 2389, 2391, 2398, 2406, 2407, 2412, 2425, 2427, 2428, 2429, 2431, 2432, 2435, 2439, 2440, 2441, 2443, 2445, 2446, 2448, 2449, 2450, 2467, 2468, 2469, 2470, 2479, 2482, 2483, 2511, 2514, 2516, 2545, 2546, 2547, 2548, 2549, 2550, 2551, 2552, 2554, 2555, 2577, 2594, 2596, 2605, 2606, 2607, 2627, 2635, 2636, 2641, 2656, 2658, 2662, 2684, 2685, 2705, 2751, 2761, 2766, 2816, 2817, 2877, 2878, 2881, 2891, 2892, 2949, 2950, 2952, 2963, 2967, 2975, 2976, 2987, 3021, 3062, 3063, 3064, 3065, 3066, 3087, 3088, 3089, 3090, 3091, 3092, 3111, 3120, 3121, 3122, 3123, 3125, 3156, 3157, 3158, 3177, 3179, 3183, 3184, 3230, 3232, 3241, 3246, 3248, 3249, 3250, 3251, 3252, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3274, 3275, 3276, 3303, 3314, 3315, 3342, 3343, 3344, 3345, 3346, 3350, 3351, 3354, 3355, 3358, 3359, 3360, 3391, 3392, 3393, 3394, 3405, 3426, 3433, 3446, 3447, 3453, 3455, 3456, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3465, 3466, 3495, 3535, 3572, 3573, 3574, 3575, 3576, 3577, 3584, 3585, 3595, 3596, 3597, 3598, 3599, 3600, 3601, 3602, 3603, 3604, 3606, 3607, 3608, 3609, 3610, 3613, 3614, 3615, 3617, 3618, 3620, 3623, 3638, 3639, 3651, 3654, 3658, 3659, 3667, 3668, 3725, 3763, 3764, 3765, 3766, 3767, 3777, 3778, 3836, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3856, 3861, 3862, 3863, 3864, 3865, 3866, 3867, 3868, 3869, 3873, 3874, 3875, 3876, 3877, 3883, 3884, 3885, 3886, 3903, 3905, 3906, 3907, 3918, 3921, 3922, 3930, 3931, 3932, 3940, 3954, 3958, 3966, 3967, 3980, 3981, 3982, 3983, 3984, 3985, 3986, 3988, 3995, 4022, 4030, 4032, 4033, 4034, 4036, 4037, 4038, 4040, 4043, 4045, 4053, 4054, 4055, 4066, 4067, 4124, 4125, 4126, 4127, 4128, 4129, 4131, 4134, 4135, 4137, 4165, 4166, 4167, 4168, 4170, 4171, 4175, 4178, 4186, 4190, 4192, 4193, 4197, 4214, 4215, 4218, 4274, 4280, 4290, 4292, 4298, 4301, 4304, 4305, 4321, 4322, 4323, 4328, 4329, 4358, 4372, 4373, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4384, 4385, 4386, 4420, 4426, 4427, 4429, 4436, 4437, 4438, 4440, 12077, 4441, 4442, 4443, 4455, 4457, 4462, 4463, 4464, 4465, 4482, 4483, 4484, 4491, 4498, 4500, 4502, 4503, 4504, 4505, 4506, 4512, 4538, 4539, 4540, 4544, 4545, 4546, 4547, 4548, 4549, 4550, 4551, 4552, 4553, 4554, 4555, 4572, 4573, 4574, 4584, 4585, 4663, 4664, 4665, 4666, 4667, 4672, 4673, 4677, 4678, 4731, 4732, 4733, 4736, 4742, 4743, 4744, 4745, 4746, 4747, 4769, 4770, 4807, 4816, 4817, 4829, 4866, 4867, 4868, 4869, 4870, 11772, 4871, 4873, 4874, 4881, 4883, 4884, 4889, 4890, 4904, 4905, 4906, 4907, 4914, 4916, 4917, 4927, 4918, 4919, 4920, 4921, 4924, 4925, 4980, 4994, 4995, 5021, 5022, 5023, 5038, 5102, 5103, 5115, 5116, 5152, 5153, 5154, 5155, 7565, 7566, 7568, 7569, 5233, 5234, 5256, 5257, 5258, 5263, 5266, 5278, 5279, 5280, 5288, 5289, 5302, 5303, 5304, 5305, 5306, 5307, 5308, 5309, 5310, 5317, 5319, 5320, 5321, 5323, 5325, 5326, 5329, 5352, 5353, 5365, 5366, 5367, 5368, 5369, 5371, 5389, 5414, 5421, 5422, 5427, 5428, 5429, 5435, 5436, 5451, 5459, 5471, 5472, 5476, 5477, 5478, 5502, 5503, 5504, 5505, 5507, 5508, 5509, 5510, 5511, 5512, 5514, 5525, 5531, 5532, 5533, 5571, 5587, 5610, 5611, 5612, 5613, 5614, 5618, 5629, 5647, 5651, 5661, 5662, 5711, 5733, 5823, 5824, 5826, 5827, 5828, 5852, 5853, 5902, 5932, 5934, 5935, 5957, 5995, 6017, 8065, 6018, 8066, 6031, 6043, 6059, 6060, 6061, 6062, 6063, 6064, 6066, 6068, 6069, 6125, 6126, 6127, 6132, 6134, 6135, 6136, 6137, 6138, 6146, 6157, 6158, 6159, 6174, 6175, 6196, 6210, 6213, 6214, 6215, 6216, 6217, 6218, 6238, 6246, 6247, 6248, 6258, 6259, 6278, 6295, 6326, 6327, 6328, 6370, 6371, 6372, 6373, 6374, 6375, 6376, 6390, 6398, 6404, 6415, 6447, 6472, 6560, 6561, 6562, 6563, 6564, 6575, 6583, 6966, 6584, 6967, 6585, 6586, 6968, 6588, 6589, 6602, 6603, 6604, 6607, 6608, 6609, 6612, 6613, 6621, 6622, 6623, 6626, 6627, 6640, 6663, 6732, 6759, 6763, 6764, 6812, 6813, 6814, 6818, 6820, 6821, 6825, 6830, 6839, 6845, 6849, 6853, 6854, 6856, 6858, 6859, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6867, 6891, 6961, 6962, 6963, 6964, 6965, 6971, 6972, 6973, 6975, 6982, 7011, 7031, 7032, 7033, 7035, 7041, 7042, 7043, 7045, 7046, 7047, 7070, 7073, 7083, 7096, 7097, 7098, 7099, 7100, 7147, 7148, 7163, 7176, 7182, 7183, 7197, 7201, 7204, 7205, 7206, 7207, 7208, 7209, 7215, 7220, 7221, 7249, 7254, 7255, 7267, 7281, 7283, 7301, 7330, 7331, 7391, 7439, 7440, 7473, 7498, 7499, 7500, 7501, 7502, 7508, 7509, 7510, 7511, 7512, 7552, 7563, 7564, 7567, 7570, 7583, 7584, 7599, 7600, 7602, 7623, 7624, 7665, 7666, 7667, 7685, 7698, 7699, 7700, 7740, 7763, 7764, 7765, 7766, 7767, 7769, 7773, 7774, 7775, 7776, 7777, 7778, 7779, 7780, 7781, 7782, 7831, 7832, 7833, 11318, 7834, 7892, 7896, 7902, 7904, 7905, 7911, 7912, 7913, 7914, 7918, 7919, 7926, 7929, 7931, 7988, 7989, 7998, 7999, 8025, 8026, 8063, 8064, 8068, 8076, 8088, 8092, 8124, 8133, 8139, 8170, 8216, 8218, 8228, 8229, 8230, 8234, 8235, 8236, 8237, 8238, 8239, 8240, 8241, 8242, 8243, 8244, 8249, 8251, 8252, 8253, 8254, 8255, 8261, 8262, 8263, 8266, 8269, 8274, 8275, 8276, 8277, 8278, 8279, 8290, 8291, 8295, 8297, 8298, 8299, 8300, 8308, 8317, 8318, 8404, 8409, 8424, 8425, 8449, 8462, 8503, 8504, 8505, 8506, 8510, 8511, 8520, 8522, 8524, 8527, 8528, 8532, 8550, 8558, 8562, 8563, 8578, 8605, 8606, 8617, 8689, 8702, 8703, 8704, 8705, 8713, 8714, 8715, 8716, 8717, 8718, 8758, 8759, 8760, 8761, 8762, 8763, 8764, 8774, 8775, 8779, 8780, 8794, 8797, 8798, 8814, 8819, 8820, 8821, 8822, 8823, 8876, 8877, 8878, 8879, 8880, 8881, 8884, 8897, 8898, 8900, 8901, 8902, 8928, 8938, 8949, 8955, 8966, 8994, 9000, 9070, 9072, 9075, 9076, 9093, 9094, 9095, 9096, 9097, 9107, 9108, 9109, 9110, 9111, 9113, 9114, 9115, 9116, 9118, 9119, 9120, 9121, 9122, 9179, 9204, 9256, 9257, 9258, 9268, 9269, 9270, 9271, 9273, 9275, 9276, 9285, 9290, 9319, 9334, 9357, 9385, 9436, 9437, 9438, 9451, 9452, 9453, 9455, 9456, 9459, 9460, 9462, 9467, 9468, 9469, 9555, 9584, 9585, 9586, 9587, 9588, 9590, 9612, 9622, 9651, 9652, 9695, 9696, 9697, 9698, 9750, 9765, 9849, 9850, 9851, 9864, 9881, 9970, 9971, 9991, 9992, 9993, 9994, 9995, 9996, 9997, 9998, 9999, 10000, 10003, 10004, 10007, 10011, 10014, 10015, 10022, 10023, 10024, 10036, 10037, 10038, 10044, 10045, 10055, 10063, 10096, 10097, 10098, 10099, 10100, 10109, 10110, 10112, 10113, 10116, 10135, 10138, 10141, 10142, 10143, 10145, 10161, 10167, 10178, 10179, 10632, 10203, 10228, 10229, 10244, 10245, 10247, 10428, 10429, 10430, 10431, 10478, 10479, 10480, 10481, 10482, 10483, 10484, 10485, 10486, 10487, 10488, 10490, 10491, 10492, 10511, 10581, 10604, 10605, 10606, 10607, 10608, 10609, 10610, 10616, 10633, 10634, 10635, 10662, 10663, 10664, 10665, 10691, 10694, 10695, 10697, 10698, 10699, 10700, 10730, 10731, 10755, 10756, 10757, 10764, 10765, 10781, 10782, 10815, 10816, 10817, 10823, 10825, 10841, 10842, 10855, 10856, 10857, 10858, 10859, 10824, 10893, 10920, 10921, 10922, 10923, 10924, 10926, 10930, 10940, 10942, 10947, 10995, 10996, 11031, 11032, 11033, 11034, 11035, 11036, 11042, 11043, 11044, 11046, 11068, 11069, 11070, 11071, 11072, 11075, 11112, 11168, 11176, 11177, 11178, 11179, 11191, 11192, 11196, 11197, 11198, 11199, 11200, 11201, 11217, 11218, 11221, 11222, 11223, 11225, 11226, 11227, 11237, 11240, 11311, 11314, 11320, 11322, 11323, 11324, 11325, 11333, 11336, 11337, 11338, 11339, 11343, 11344, 11345, 11346, 11352, 11359, 11372, 11373, 11374, 11382, 11383, 11384, 11393, 11401, 11402, 11403, 11455, 11467, 11470, 11471, 11472, 11501, 11502, 11503, 11504, 11505, 11517, 11518, 11519, 11537, 11618, 11619, 11688, 11689, 11690, 11691, 11692, 11696, 11697, 11698, 11699, 11700, 11701, 11702, 11703, 11712, 11722, 11723, 11724, 11727, 11733, 11745, 11746, 11747, 11748, 11762, 11768, 11778, 11779, 11780, 11781, 11782, 11785, 11786, 11800, 11819, 11820, 11835, 11840, 12124, 11862, 11874, 11875, 11876, 11878, 11887, 11908, 11949, 11950, 11970, 11972, 11977, 11978, 11980, 12010, 12011, 12012, 12013, 12015, 12016, 12017, 12018, 12102, 12103, 12109, 12122, 14212, 12123, 12127, 12164, 12165, 12166, 12168, 12169, 12170, 12171, 12172, 12173, 12174, 12175, 12176, 12177, 12178, 12179, 12185, 12193, 12208, 12209, 12210, 12228, 12232, 12233, 12234, 12235, 12236, 12237, 12238, 12239, 12240, 12241, 12242, 12250, 12251, 12252, 12253, 12272, 12273, 12274, 12275, 12276, 12277, 12287, 12296, 12297, 12316, 12317, 12319, 12322, 12323, 12331, 12333, 12334, 12345, 12346, 12389, 12390, 12403, 12432, 12440, 12442, 12447, 12448, 12449, 12450, 12466, 12475, 12493, 12494, 12495, 12496, 12505, 12506, 12507, 12509, 12522, 12523, 12524, 12525, 12534, 12535, 12536, 12537, 12538, 12547, 12553, 12555, 12557, 12558, 12566, 12595, 12596, 12598, 12632, 12633, 12634, 12635, 12637, 12638, 12639, 12640, 12641, 12649, 12651, 12677, 12689, 12709, 12711, 12713, 12714, 12725, 12726, 12727, 12731, 12732, 12733, 12773, 12784, 12803, 12804, 12814, 12815, 12816, 12817, 12819, 12821, 12820, 12824, 12823, 12825, 12827, 12830, 12832, 12833, 12834, 12835, 12841, 12853, 12854, 12855, 12856, 12863, 12902, 12903, 12904, 12905, 12906, 12913, 12915, 12916, 12917, 12918, 12919, 12920, 12921, 12922, 12923, 12932, 12933, 12934, 12935, 12936, 12941, 12942, 12944, 12945, 12946, 12947, 12948, 12959, 12964, 12965, 12966, 12967, 12968, 12969, 12970, 12971, 12978, 12979, 12980, 12981, 13010, 13014, 13018, 13019, 13028, 13029, 13035, 13036, 13037, 13039, 13040, 13044, 13041, 13063, 13067, 13084, 13085, 13095, 13098, 13101, 13103, 13104, 13106, 13109, 13136, 13148, 13163, 13194, 13197, 13198, 13201, 13209, 13210, 13215, 13229, 13230, 13233, 13234, 13235, 13236, 13237, 13238, 13240, 13246, 13247, 13248, 13249, 13252, 13257, 13264, 13267, 13271, 13272, 13274, 13277, 13278, 13279, 13280, 13281, 13282, 13295, 13296, 13297, 13298, 13299, 13333, 13336, 13337, 13338, 13342, 13347, 13348, 13349, 13350, 13351, 13598, 13366, 13371, 13378, 13398, 13431, 13432, 13433, 13434, 13490, 13492, 13493, 13497, 13498, 13500, 13509, 13513, 13514, 13515, 13516, 13517, 13518, 13520, 13521, 13522, 13523, 13524, 13525, 13528, 13532, 13533, 13539, 13564, 13565, 13566, 13583, 13588, 13590, 13591, 13592, 13599, 13602, 13612, 13614, 13615, 13616, 13621, 13622, 13624, 13632, 13633, 13634, 13635, 13636, 13637, 13687, 13688, 13689, 13690, 13691, 13693, 13694, 13695, 13698, 13721, 13722, 13731, 13732, 13733, 13735, 13736, 13737, 13738, 13743, 13758, 13759, 13760, 13768, 13769, 13770, 13772, 13776, 13777, 13778, 13779, 13787, 13788, 13789, 13791, 13790, 13792, 13801, 13802, 13803, 13807, 13809, 13818, 13829, 13847, 13853, 13854, 13861, 13872, 13881, 13882, 13897, 13898, 13899, 13900, 13901, 13902, 13903, 13905, 13906, 13909, 13907, 13910, 13908, 13911, 13912, 13914, 13920, 13921, 13922, 13923, 13924, 13926, 13927, 13935, 13936, 13937, 13938, 13939, 13940, 13941, 13942, 13943, 13944, 13947, 13948, 13949, 13950, 13952, 13953, 13954, 13956, 13957, 13958, 13959, 13960, 13961, 13962, 13963, 13964, 13965, 13967, 13968, 13969, 13970, 13971, 13972, 13973, 13974, 13975, 13976, 13977, 13978, 13979, 13980, 13981, 13982, 13983, 13984, 13985, 13986, 13987, 13991, 13992, 13993, 13994, 13995, 13996, 14003, 14004, 14005, 14006, 14007, 14008, 14009, 14010, 14011, 14012, 14013, 14014, 14015, 14016, 14017, 14018, 14019, 14020, 14022, 14025, 14026, 14034, 14036, 14037, 14038, 14040, 14041, 14042, 14050, 14051, 14052, 14055, 14060, 14061, 14062, 14068, 14069, 14072, 14073, 14076, 14077, 14078, 14079, 14084, 14086, 14090, 14091, 14096, 14097, 14098, 14099, 14102, 14105, 14106, 14107, 14108, 14109, 14110, 14111, 14112, 14113, 14116, 14117, 14118, 14119, 14121, 14123, 14124, 14125, 14126, 14127, 14128, 14137, 14139, 14140, 14141, 14142, 14144, 14145, 14146, 14147, 14160, 14148, 14149, 14158, 14150, 14155, 14151, 14156, 14152, 14157, 14153, 14159, 14161, 14172, 14175, 14177, 14178, 14180, 14191, 14192, 14194, 14195, 14198, 14201, 14202, 14204, 14205, 14208, 14209, 14211, 14213, 14216, 14217, 14218, 14220, 14222, 14223, 14224, 14225, 14229, 14231, 14232, 14244, 14245, 14247, 14248, 14249, 14250, 14254, 14255, 14256, 14257, 14258, 14261, 14265, 14266, 14269, 14270, 14277, 14283, 14295, 14296, 14297, 14298, 14299, 14300, 14301, 14302, 14305, 14306, 14307, 14324, 14332, 14338, 14341, 14342, 14343, 14345, 14346, 14347, 14348, 14351, 14352, 14353, 14354, 14362, 14364, 14387, 14388, 14389, 14390, 14395, 14396, 14397, 14398, 14399, 14400, 14401, 14413, 14414, 14416, 14423, 14425, 14426, 14428, 14435, 14434, 14436, 14440, 14446, 14447, 14450, 14449, 14454, 14464, 14467, 14468, 14469, 14470, 14472, 14473, 14475, 14474, 14476, 14477, 14478, 14479, 14480, 14481, 14482, 14483, 14487, 14488, 14489, 14491, 14490, 14492, 14497, 14498, 14499, 14501, 14502, 14504, 14511, 14514, 14515, 14516, 14517, 14518, 14519, 14520, 14539, 14540, 14545, 14546, 14547, 14549, 14550, 14555, 14556, 14557, 14560, 14561, 14562, 14563, 14564, 14565, 14566, 14568, 14569, 14575, 14576, 14577, 14578, 14579, 14580, 14582, 14583, 14592, 14593, 14595, 14603, 14605, 14606, 14611, 14612, 14613, 14614, 14615, 14616, 14617, 14618, 14619, 14623, 14628, 14624, 14625, 14627, 14629, 14630, 14631, 14632, 14633, 14634, 14647, 14648, 14677, 14679, 14678, 14680, 14682, 14683, 14685, 14686, 14691, 14693, 14692, 14697, 14696, 14699, 14702, 14703, 14704, 14705, 14714, 14715, 14716, 14717, 14718, 14720, 14721, 14722, 14732, 14735, 14736, 14737, 14739, 14738, 14740, 14741, 14742, 14745, 14746, 14750, 14757, 14758, 14759, 14760, 14765, 14766, 14767, 14768, 14770, 14771, 14772, 14773, 14774, 14776, 14777, 14778, 14779, 14780, 14781, 14782, 14783, 14784, 14785, 14789, 14791, 14792, 14793, 14794, 14795, 14798, 14799, 14802, 14803, 14806, 14807, 14808, 14815, 14816, 14817, 14818, 14820, 14821, 14822, 14823, 14824, 14825, 14826, 14833, 14834, 14835, 14837, 14838, 14839, 14840, 14841, 14842, 14845, 14846, 14852, 14853, 14854, 14855, 14856, 14869, 14870, 14871, 14877, 14879, 14886, 14885, 14888, 14889, 14891, 14892, 14893, 14895, 14896, 14897, 14898, 14905, 14906, 14907, 14908, 14911, 14910, 14912, 14913, 14916, 14917, 14918, 14919, 14920, 14921, 14922, 14926, 14927, 14928, 14929, 14930, 14933, 14934, 14935, 14936, 14937, 14938, 14939, 14940, 14941, 14942, 14956, 14960, 14961, 14962, 14963, 14970, 14969, 14971, 14972, 14976, 14977, 14978, 14979, 14989, 14990, 14991, 15007, 15008, 15014, 15015, 15018, 15020, 15021, 15022, 15023, 15024, 15031, 15032, 15033, 15041, 15053, 15055, 15056, 15057, 15058, 15059, 15061, 15060, 15065, 15067, 15075, 15078, 15080, 15079, 15081, 15083, 15087, 15086, 15088, 15090, 15091, 15093, 15094, 15095, 15096, 15103, 15104, 15106, 15108, 15109, 15113, 15112, 15114, 15116, 15117, 15118, 15120, 15119, 15121, 15122, 15123, 15124, 15130, 15131, 15134, 15135, 15137, 15140, 15139, 15142, 15152, 15153, 15162, 15163, 15164, 14200, 15165, 15166, 15167, 15168, 15169, 15170, 15171, 15172, 15173, 15174, 15175, 15176, 15177, 15183, 15184, 15196, 15197, 15199, 15198, 15201, 15202, 15203, 15204, 15205, 15209, 15210, 15211, 15212, 15213, 15214, 15215, 15216, 15219, 15220, 15225, 15226, 15227, 15228, 15229, 15230, 15231, 15237, 15239, 15240, 15241, 15242, 15244, 15245, 15246, 15248, 15249, 15250, 15251, 15252, 15253, 15254, 15255, 15261, 15016, 15263, 15264, 15266, 15267, 15268, 15269, 15270, 15279, 15280, 15282, 15283, 15284, 15287, 15289, 15293, 15295, 15296, 15297, 15298, 15300, 15301, 15302, 15304, 15308, 15309, 15310, 15311, 15312, 15313, 15315, 15316, 15317, 15318, 15321, 15323, 15322, 15324, 15325, 15326, 15329, 15332, 15342, 15343, 15352, 15358, 15359, 15361, 15362, 15363, 15364, 15365, 15366, 15367, 15368, 15382, 15383, 15387, 15388, 15389, 15391, 15392, 15395, 15396, 15397, 15398, 15399, 15400, 15401, 15403, 15404, 15405, 15406, 15417, 15418, 15419, 15420, 15421, 15423, 15425, 15435, 15436, 15437, 15438, 15439, 15440, 15441, 15442, 15450, 15451, 15452, 15467, 15473, 15474, 15476, 15477, 15478, 15479, 15480, 15481, 15482, 15483, 15484, 15487, 15486, 15488, 15490, 15491, 15492, 15493, 15494, 15502, 15503, 15504, 15505, 15507, 15508, 15511, 15510, 15514, 15515, 15516, 15517, 15518, 15526, 15527, 15528, 15529, 15530, 15531, 15532, 15533, 15536, 15545, 15546, 15548, 15549, 15550, 15551, 15553, 15554, 15555, 15559, 15560, 15561, 15564, 15565, 15566, 15567, 15568, 15569, 15570, 15576, 15577, 15578, 15581, 15582, 15583, 15584, 15586, 15587, 15588, 15589, 15591, 15593, 15594, 15595, 15596, 15597, 15598, 15599, 15600, 15602, 15603, 15604, 15605, 15607, 15609, 15610, 15611, 15618, 15621, 15622, 15627, 15626, 15628, 15629, 15630, 15632, 15633, 15634, 15635, 15636, 15638, 15639, 15640, 15642, 15644, 15645, 15646, 15647, 15652, 15653, 15654, 15655, 15660, 15661, 15662, 15663, 15664, 15665, 15666, 15682, 15683, 15684, 15685, 15686, 15687, 15688, 15693, 15694, 15696, 15698, 15699, 15700, 15701, 15702, 15704, 15705, 15706, 15709, 15710, 15711, 15712, 15713, 15721, 15728, 15729, 15730, 15732, 15733, 15734, 15735, 15736, 15738, 15740, 15741, 15742, 15743, 15744, 15746, 15747, 15748, 15749, 15754, 15756, 16699, 16700, 15757, 15758, 15759, 15771, 15772, 15774, 15775, 15777, 15778, 15779, 15780, 15781, 15785, 15786, 15787, 15797, 15798, 15801, 15802, 15803, 15804, 15805, 15806, 15810, 15811, 15812, 15813, 15814, 15815, 15816, 15817, 15818, 15819, 15820, 15821, 15823, 15824, 15825, 15832, 15833, 15834, 15835, 15836, 15837, 15838, 15839, 15842, 15843, 15844, 15845, 15846, 15847, 15849, 15850, 15851, 15852, 15853, 15854, 15855, 15856, 15857, 15858, 15859, 15860, 15866, 15865, 15867, 15869, 15870, 15871, 15875, 15876, 15877, 15879, 15881, 15882, 15883, 15884, 15886, 15887, 15888, 15889, 15903, 15904, 15905, 15906, 15907, 15908, 15910, 15911, 15916, 15917, 15918, 15922, 15923, 15924, 15926, 15927, 15928, 15933, 15934, 15935, 15936, 15937, 15938, 15939, 15941, 15942, 15943, 15944, 15945, 15946, 15947, 15948, 15949, 15950, 15951, 15952, 15953, 15954, 15955, 15956, 15957, 15958, 15959, 15960, 15961, 15962, 15963, 15964, 15965, 15966, 15967, 15969, 15970, 15971, 15972, 15973, 15974, 15975, 15976, 15977, 15978, 15979, 15980, 15981, 15982, 15983, 15984, 15990, 15989, 15997, 16001, 16002, 16003, 16004, 16005, 16006, 16007, 16008, 16011, 16012, 16013, 16014, 16015, 16018, 16019, 16020, 16021, 16022, 16023, 16024, 16025, 16026, 16027, 16028, 16031, 16032, 16033, 16034, 16041, 16042, 16043, 16044, 16045, 16046, 16047, 16053, 16054, 16055, 16056, 16057, 16064, 16065, 16066, 16067, 16070, 16072, 16071, 16080, 16079, 16081, 16082, 16083, 16084, 16086, 16087, 16088, 16089, 16090, 16091, 16092, 16093, 16098, 16099, 16101, 16100, 16102, 16103, 16104, 16105, 16106, 16107, 16108, 16109, 16110, 16111, 16112, 16113, 16114, 16116, 16117, 16121, 16122, 16125, 16126, 16127, 16128, 16130, 16131, 16133, 16134, 16135, 16136, 16139, 16140, 16141, 16142, 16143, 16144, 16146, 16147, 16148, 16149, 16150, 16151, 16154, 16156, 16157, 16158, 16159, 16160, 16161, 16162, 16163, 16164, 16165, 16174, 16175, 16176, 16178, 16179, 16180, 16181, 16182, 16183, 16184, 16185, 16186, 16187, 16188, 16189, 16206, 16207, 16208, 16212, 16213, 16214, 16216, 16217, 16218, 16219, 16220, 16221, 16222, 16223, 16224, 16228, 16229, 16230, 16231, 16232, 16233, 16237, 16238, 16239, 16244, 16245, 16246, 16247, 16248, 16249, 16250, 16251, 16252, 16253, 16254, 16265, 16266, 16267, 16268, 16274, 16275, 16276, 16277, 16278, 16279, 16280, 16283, 16284, 16285, 16286, 16287, 16288, 16289, 16290, 16291, 16292, 16293, 16294, 16295, 16296, 16297, 16298, 16299, 16300, 16301, 16302, 16303, 16304, 16305, 16306, 16307, 16310, 16311, 16312, 16313, 16314, 16315, 16319, 16318, 16320, 16321, 16326, 16325, 16327, 16328, 16338, 16339, 16340, 16341, 16342, 16345, 16346, 16347, 16348, 16355, 16358, 16359, 16361, 16360, 16362, 16363, 16372, 16373, 16374, 16375, 16376, 16377, 16378, 16379, 16380, 16381, 16382, 16390, 16389, 16391, 16392, 16397, 16396, 16398, 16399, 16400, 16404, 16406, 16405, 16407, 16409, 16408, 16410, 16412, 16415, 16414, 16416, 16417, 16419, 16420, 16421, 16422, 16423, 16424, 16428, 16429, 16430, 16431, 16433, 16435, 16436, 16437, 16440, 16441, 16442, 16443, 16444, 16445, 16446, 16447, 16448, 16449, 16450, 16451, 16452, 16453, 16454, 16455, 16460, 16461, 16462, 16463, 16464, 16465, 16466, 16467, 16468, 16469, 16470, 16474, 16475, 16476, 16477, 16478, 16479, 16483, 16484, 16485, 16500, 16499, 16501, 16503, 16502, 16504, 16508, 16507, 16509, 16512, 16516, 16515, 16517, 16518, 16519, 16521, 16520, 16522, 16524, 16523, 16525, 16526, 16527, 16528, 16529, 16530, 16531, 16532, 16533, 16534, 16535, 16536, 16538, 16537, 16539, 16540, 16541, 16542, 16543, 16544, 16545, 16547, 16546, 16548, 16552, 16553, 16554, 16558, 16557, 16559, 16560, 16561, 16562, 16563, 16564, 16566, 16565, 16567, 16568, 16569, 16571, 16573, 16572, 16574, 16575, 16576, 16577, 16579, 16578, 16580, 16581, 16582, 16583, 16584, 16585, 16586, 16587, 16588, 16589, 16590, 16597, 16598, 16599, 16600, 16601, 16602, 16604, 16605, 16621, 16622, 16623, 16624, 16625, 16626, 16627, 16628, 16630, 16631, 16632, 16633, 16634, 16635, 16636, 16637, 16641, 16642, 16643, 16644, 16645, 16646, 16647, 16648, 16649, 16650, 16651, 16652, 16653, 16654, 16655, 16656, 16660, 16661, 16662, 16663, 16664, 16665, 16666, 16667, 16668, 16669, 16670, 16671, 16672, 16673, 16674, 16679, 16680, 16681, 16682, 16683, 16684, 16685, 16686, 16687, 16688, 16689, 16690, 16691, 16692, 16693, 16694, 16696, 16697, 16698, 16701, 16702, 16703, 16704, 16706, 16708, 16710, 16711, 16712, 16713, 16715, 16714, 16716, 16717, 16718, 16719, 16720, 16721, 16722, 16723, 16724, 16725, 16726, 16727, 16728, 16729, 16730, 16731, 16732, 16733, 16734, 16735, 16736, 16737, 16738, 16739, 16741, 16742, 16743, 16744, 16745, 16746, 16747, 16748, 16749, 16750, 16752, 16753, 16754, 16756, 16757, 16758)

) UNION ALL (
SELECT
a.attachmentid, a.contenttypeid, a.displayorder
FROM attachment AS a
INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN cms_node AS node ON (a.contentid = node.nodeid)
LEFT JOIN user AS user ON (user.userid = node.userid)
WHERE
a.contenttypeid = 18 AND
(
(
a.contentid = 0
AND
a.userid = 0
)
OR
(
a.contentid 0
)
)
AND a.attachmentid IN (1, 2, 3, 7, 8, 54, 10, 13, 14, 16, 17, 26, 27, 29, 86, 255, 257, 259, 280, 282, 283, 284, 295, 297, 298, 299, 300, 301, 302, 303, 354, 355, 359, 360, 361, 362, 363, 367, 370, 374, 375, 376, 377, 378, 379, 390, 391, 392, 394, 395, 396, 397, 398, 412, 413, 414, 417, 420, 423, 438, 441, 444, 445, 450, 451, 491, 505, 507, 531, 538, 569, 570, 571, 576, 577, 610, 611, 613, 614, 615, 616, 623, 624, 1164, 627, 636, 637, 640, 645, 646, 648, 649, 650, 651, 652, 653, 659, 678, 680, 681, 682, 683, 684, 685, 686, 688, 689, 690, 702, 703, 704, 705, 706, 707, 713, 714, 715, 716, 717, 719, 722, 723, 724, 725, 726, 727, 728, 731, 732, 737, 755, 756, 757, 759, 771, 776, 777, 778, 781, 784, 786, 787, 789, 790, 791, 792, 805, 827, 831, 833, 834, 866, 867, 868, 869, 874, 875, 900, 901, 909, 913, 914, 915, 919, 920, 926, 927, 928, 929, 936, 942, 951, 981, 955, 956, 957, 958, 994, 996, 997, 999, 1004, 1005, 1006, 1008, 1009, 1010, 1011, 1012, 1028, 1045, 1054, 1061, 1065, 1066, 1067, 1068, 1073, 1074, 1077, 1078, 1080, 1098, 1099, 1100, 1105, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1132, 1133, 1168, 1172, 1186, 1187, 1188, 1189, 1190, 1191, 1206, 1210, 1216, 1217, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1277, 1278, 1281, 1351, 1352, 1356, 1357, 1358, 1366, 1370, 1391, 1392, 1393, 1394, 1397, 1399, 1401, 7065, 1402, 7066, 1403, 7067, 1406, 1421, 1422, 1423, 1427, 2869, 1428, 1429, 1431, 1436, 1435, 1439, 1445, 1446, 1447, 1483, 1490, 1516, 1517, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1532, 1534, 1536, 1537, 1553, 1554, 1561, 1590, 1609, 1610, 1611, 1619, 1631, 1651, 1652, 1653, 1654, 1656, 1657, 1658, 1659, 1660, 1661, 1670, 1683, 1695, 1716, 1724, 1725, 1726, 1727, 1729, 1730, 1733, 1741, 1742, 1743, 1747, 1750, 1751, 1752, 1753, 1755, 1757, 1759, 1762, 1763, 1765, 1766, 1783, 1784, 1787, 1788, 1797, 1800, 1801, 1802, 1820, 1821, 1839, 1865, 1866, 1870, 1883, 1901, 1902, 1903, 1909, 1918, 1921, 1939, 1943, 1955, 1957, 1982, 1986, 1988, 2027, 2037, 2038, 2039, 2040, 2048, 2049, 2050, 2051, 2052, 2053, 2054, 2055, 2056, 2057, 2058, 2059, 2064, 2073, 2080, 2081, 2082, 2083, 2139, 2085, 2086, 2087, 2090, 2091, 2093, 2094, 2095, 2105, 2117, 2118, 2119, 2120, 2138, 2142, 2143, 2146, 2150, 2166, 2174, 2175, 2185, 2186, 2188, 2189, 2190, 2249, 2255, 2257, 2258, 2261, 2266, 2267, 2268, 2277, 2281, 2282, 2283, 2284, 2285, 2286, 2287, 2288, 2289, 2290, 2291, 2292, 2293, 2295, 2296, 2298, 2301, 2304, 2321, 2323, 2325, 2326, 2334, 2337, 2338, 2339, 2340, 2341, 2342, 2350, 2351, 2355, 2370, 2385, 2371, 2372, 2373, 2375, 2382, 2383, 2389, 2391, 2398, 2406, 2407, 2412, 2425, 2427, 2428, 2429, 2431, 2432, 2435, 2439, 2440, 2441, 2443, 2445, 2446, 2448, 2449, 2450, 2467, 2468, 2469, 2470, 2479, 2482, 2483, 2511, 2514, 2516, 2545, 2546, 2547, 2548, 2549, 2550, 2551, 2552, 2554, 2555, 2577, 2594, 2596, 2605, 2606, 2607, 2627, 2635, 2636, 2641, 2656, 2658, 2662, 2684, 2685, 2705, 2751, 2761, 2766, 2816, 2817, 2877, 2878, 2881, 2891, 2892, 2949, 2950, 2952, 2963, 2967, 2975, 2976, 2987, 3021, 3062, 3063, 3064, 3065, 3066, 3087, 3088, 3089, 3090, 3091, 3092, 3111, 3120, 3121, 3122, 3123, 3125, 3156, 3157, 3158, 3177, 3179, 3183, 3184, 3230, 3232, 3241, 3246, 3248, 3249, 3250, 3251, 3252, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3264, 3265, 3266, 3274, 3275, 3276, 3303, 3314, 3315, 3342, 3343, 3344, 3345, 3346, 3350, 3351, 3354, 3355, 3358, 3359, 3360, 3391, 3392, 3393, 3394, 3405, 3426, 3433, 3446, 3447, 3453, 3455, 3456, 3458, 3459, 3460, 3461, 3462, 3463, 3464, 3465, 3466, 3495, 3535, 3572, 3573, 3574, 3575, 3576, 3577, 3584, 3585, 3595, 3596, 3597, 3598, 3599, 3600, 3601, 3602, 3603, 3604, 3606, 3607, 3608, 3609, 3610, 3613, 3614, 3615, 3617, 3618, 3620, 3623, 3638, 3639, 3651, 3654, 3658, 3659, 3667, 3668, 3725, 3763, 3764, 3765, 3766, 3767, 3777, 3778, 3836, 3845, 3846, 3847, 3848, 3849, 3850, 3851, 3852, 3856, 3861, 3862, 3863, 3864, 3865, 3866, 3867, 3868, 3869, 3873, 3874, 3875, 3876, 3877, 3883, 3884, 3885, 3886, 3903, 3905, 3906, 3907, 3918, 3921, 3922, 3930, 3931, 3932, 3940, 3954, 3958, 3966, 3967, 3980, 3981, 3982, 3983, 3984, 3985, 3986, 3988, 3995, 4022, 4030, 4032, 4033, 4034, 4036, 4037, 4038, 4040, 4043, 4045, 4053, 4054, 4055, 4066, 4067, 4124, 4125, 4126, 4127, 4128, 4129, 4131, 4134, 4135, 4137, 4165, 4166, 4167, 4168, 4170, 4171, 4175, 4178, 4186, 4190, 4192, 4193, 4197, 4214, 4215, 4218, 4274, 4280, 4290, 4292, 4298, 4301, 4304, 4305, 4321, 4322, 4323, 4328, 4329, 4358, 4372, 4373, 4374, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4384, 4385, 4386, 4420, 4426, 4427, 4429, 4436, 4437, 4438, 4440, 12077, 4441, 4442, 4443, 4455, 4457, 4462, 4463, 4464, 4465, 4482, 4483, 4484, 4491, 4498, 4500, 4502, 4503, 4504, 4505, 4506, 4512, 4538, 4539, 4540, 4544, 4545, 4546, 4547, 4548, 4549, 4550, 4551, 4552, 4553, 4554, 4555, 4572, 4573, 4574, 4584, 4585, 4663, 4664, 4665, 4666, 4667, 4672, 4673, 4677, 4678, 4731, 4732, 4733, 4736, 4742, 4743, 4744, 4745, 4746, 4747, 4769, 4770, 4807, 4816, 4817, 4829, 4866, 4867, 4868, 4869, 4870, 11772, 4871, 4873, 4874, 4881, 4883, 4884, 4889, 4890, 4904, 4905, 4906, 4907, 4914, 4916, 4917, 4927, 4918, 4919, 4920, 4921, 4924, 4925, 4980, 4994, 4995, 5021, 5022, 5023, 5038, 5102, 5103, 5115, 5116, 5152, 5153, 5154, 5155, 7565, 7566, 7568, 7569, 5233, 5234, 5256, 5257, 5258, 5263, 5266, 5278, 5279, 5280, 5288, 5289, 5302, 5303, 5304, 5305, 5306, 5307, 5308, 5309, 5310, 5317, 5319, 5320, 5321, 5323, 5325, 5326, 5329, 5352, 5353, 5365, 5366, 5367, 5368, 5369, 5371, 5389, 5414, 5421, 5422, 5427, 5428, 5429, 5435, 5436, 5451, 5459, 5471, 5472, 5476, 5477, 5478, 5502, 5503, 5504, 5505, 5507, 5508, 5509, 5510, 5511, 5512, 5514, 5525, 5531, 5532, 5533, 5571, 5587, 5610, 5611, 5612, 5613, 5614, 5618, 5629, 5647, 5651, 5661, 5662, 5711, 5733, 5823, 5824, 5826, 5827, 5828, 5852, 5853, 5902, 5932, 5934, 5935, 5957, 5995, 6017, 8065, 6018, 8066, 6031, 6043, 6059, 6060, 6061, 6062, 6063, 6064, 6066, 6068, 6069, 6125, 6126, 6127, 6132, 6134, 6135, 6136, 6137, 6138, 6146, 6157, 6158, 6159, 6174, 6175, 6196, 6210, 6213, 6214, 6215, 6216, 6217, 6218, 6238, 6246, 6247, 6248, 6258, 6259, 6278, 6295, 6326, 6327, 6328, 6370, 6371, 6372, 6373, 6374, 6375, 6376, 6390, 6398, 6404, 6415, 6447, 6472, 6560, 6561, 6562, 6563, 6564, 6575, 6583, 6966, 6584, 6967, 6585, 6586, 6968, 6588, 6589, 6602, 6603, 6604, 6607, 6608, 6609, 6612, 6613, 6621, 6622, 6623, 6626, 6627, 6640, 6663, 6732, 6759, 6763, 6764, 6812, 6813, 6814, 6818, 6820, 6821, 6825, 6830, 6839, 6845, 6849, 6853, 6854, 6856, 6858, 6859, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6867, 6891, 6961, 6962, 6963, 6964, 6965, 6971, 6972, 6973, 6975, 6982, 7011, 7031, 7032, 7033, 7035, 7041, 7042, 7043, 7045, 7046, 7047, 7070, 7073, 7083, 7096, 7097, 7098, 7099, 7100, 7147, 7148, 7163, 7176, 7182, 7183, 7197, 7201, 7204, 7205, 7206, 7207, 7208, 7209, 7215, 7220, 7221, 7249, 7254, 7255, 7267, 7281, 7283, 7301, 7330, 7331, 7391, 7439, 7440, 7473, 7498, 7499, 7500, 7501, 7502, 7508, 7509, 7510, 7511, 7512, 7552, 7563, 7564, 7567, 7570, 7583, 7584, 7599, 7600, 7602, 7623, 7624, 7665, 7666, 7667, 7685, 7698, 7699, 7700, 7740, 7763, 7764, 7765, 7766, 7767, 7769, 7773, 7774, 7775, 7776, 7777, 7778, 7779, 7780, 7781, 7782, 7831, 7832, 7833, 11318, 7834, 7892, 7896, 7902, 7904, 7905, 7911, 7912, 7913, 7914, 7918, 7919, 7926, 7929, 7931, 7988, 7989, 7998, 7999, 8025, 8026, 8063, 8064, 8068, 8076, 8088, 8092, 8124, 8133, 8139, 8170, 8216, 8218, 8228, 8229, 8230, 8234, 8235, 8236, 8237, 8238, 8239, 8240, 8241, 8242, 8243, 8244, 8249, 8251, 8252, 8253, 8254, 8255, 8261, 8262, 8263, 8266, 8269, 8274, 8275, 8276, 8277, 8278, 8279, 8290, 8291, 8295, 8297, 8298, 8299, 8300, 8308, 8317, 8318, 8404, 8409, 8424, 8425, 8449, 8462, 8503, 8504, 8505, 8506, 8510, 8511, 8520, 8522, 8524, 8527, 8528, 8532, 8550, 8558, 8562, 8563, 8578, 8605, 8606, 8617, 8689, 8702, 8703, 8704, 8705, 8713, 8714, 8715, 8716, 8717, 8718, 8758, 8759, 8760, 8761, 8762, 8763, 8764, 8774, 8775, 8779, 8780, 8794, 8797, 8798, 8814, 8819, 8820, 8821, 8822, 8823, 8876, 8877, 8878, 8879, 8880, 8881, 8884, 8897, 8898, 8900, 8901, 8902, 8928, 8938, 8949, 8955, 8966, 8994, 9000, 9070, 9072, 9075, 9076, 9093, 9094, 9095, 9096, 9097, 9107, 9108, 9109, 9110, 9111, 9113, 9114, 9115, 9116, 9118, 9119, 9120, 9121, 9122, 9179, 9204, 9256, 9257, 9258, 9268, 9269, 9270, 9271, 9273, 9275, 9276, 9285, 9290, 9319, 9334, 9357, 9385, 9436, 9437, 9438, 9451, 9452, 9453, 9455, 9456, 9459, 9460, 9462, 9467, 9468, 9469, 9555, 9584, 9585, 9586, 9587, 9588, 9590, 9612, 9622, 9651, 9652, 9695, 9696, 9697, 9698, 9750, 9765, 9849, 9850, 9851, 9864, 9881, 9970, 9971, 9991, 9992, 9993, 9994, 9995, 9996, 9997, 9998, 9999, 10000, 10003, 10004, 10007, 10011, 10014, 10015, 10022, 10023, 10024, 10036, 10037, 10038, 10044, 10045, 10055, 10063, 10096, 10097, 10098, 10099, 10100, 10109, 10110, 10112, 10113, 10116, 10135, 10138, 10141, 10142, 10143, 10145, 10161, 10167, 10178, 10179, 10632, 10203, 10228, 10229, 10244, 10245, 10247, 10428, 10429, 10430, 10431, 10478, 10479, 10480, 10481, 10482, 10483, 10484, 10485, 10486, 10487, 10488, 10490, 10491, 10492, 10511, 10581, 10604, 10605, 10606, 10607, 10608, 10609, 10610, 10616, 10633, 10634, 10635, 10662, 10663, 10664, 10665, 10691, 10694, 10695, 10697, 10698, 10699, 10700, 10730, 10731, 10755, 10756, 10757, 10764, 10765, 10781, 10782, 10815, 10816, 10817, 10823, 10825, 10841, 10842, 10855, 10856, 10857, 10858, 10859, 10824, 10893, 10920, 10921, 10922, 10923, 10924, 10926, 10930, 10940, 10942, 10947, 10995, 10996, 11031, 11032, 11033, 11034, 11035, 11036, 11042, 11043, 11044, 11046, 11068, 11069, 11070, 11071, 11072, 11075, 11112, 11168, 11176, 11177, 11178, 11179, 11191, 11192, 11196, 11197, 11198, 11199, 11200, 11201, 11217, 11218, 11221, 11222, 11223, 11225, 11226, 11227, 11237, 11240, 11311, 11314, 11320, 11322, 11323, 11324, 11325, 11333, 11336, 11337, 11338, 11339, 11343, 11344, 11345, 11346, 11352, 11359, 11372, 11373, 11374, 11382, 11383, 11384, 11393, 11401, 11402, 11403, 11455, 11467, 11470, 11471, 11472, 11501, 11502, 11503, 11504, 11505, 11517, 11518, 11519, 11537, 11618, 11619, 11688, 11689, 11690, 11691, 11692, 11696, 11697, 11698, 11699, 11700, 11701, 11702, 11703, 11712, 11722, 11723, 11724, 11727, 11733, 11745, 11746, 11747, 11748, 11762, 11768, 11778, 11779, 11780, 11781, 11782, 11785, 11786, 11800, 11819, 11820, 11835, 11840, 12124, 11862, 11874, 11875, 11876, 11878, 11887, 11908, 11949, 11950, 11970, 11972, 11977, 11978, 11980, 12010, 12011, 12012, 12013, 12015, 12016, 12017, 12018, 12102, 12103, 12109, 12122, 14212, 12123, 12127, 12164, 12165, 12166, 12168, 12169, 12170, 12171, 12172, 12173, 12174, 12175, 12176, 12177, 12178, 12179, 12185, 12193, 12208, 12209, 12210, 12228, 12232, 12233, 12234, 12235, 12236, 12237, 12238, 12239, 12240, 12241, 12242, 12250, 12251, 12252, 12253, 12272, 12273, 12274, 12275, 12276, 12277, 12287, 12296, 12297, 12316, 12317, 12319, 12322, 12323, 12331, 12333, 12334, 12345, 12346, 12389, 12390, 12403, 12432, 12440, 12442, 12447, 12448, 12449, 12450, 12466, 12475, 12493, 12494, 12495, 12496, 12505, 12506, 12507, 12509, 12522, 12523, 12524, 12525, 12534, 12535, 12536, 12537, 12538, 12547, 12553, 12555, 12557, 12558, 12566, 12595, 12596, 12598, 12632, 12633, 12634, 12635, 12637, 12638, 12639, 12640, 12641, 12649, 12651, 12677, 12689, 12709, 12711, 12713, 12714, 12725, 12726, 12727, 12731, 12732, 12733, 12773, 12784, 12803, 12804, 12814, 12815, 12816, 12817, 12819, 12821, 12820, 12824, 12823, 12825, 12827, 12830, 12832, 12833, 12834, 12835, 12841, 12853, 12854, 12855, 12856, 12863, 12902, 12903, 12904, 12905, 12906, 12913, 12915, 12916, 12917, 12918, 12919, 12920, 12921, 12922, 12923, 12932, 12933, 12934, 12935, 12936, 12941, 12942, 12944, 12945, 12946, 12947, 12948, 12959, 12964, 12965, 12966, 12967, 12968, 12969, 12970, 12971, 12978, 12979, 12980, 12981, 13010, 13014, 13018, 13019, 13028, 13029, 13035, 13036, 13037, 13039, 13040, 13044, 13041, 13063, 13067, 13084, 13085, 13095, 13098, 13101, 13103, 13104, 13106, 13109, 13136, 13148, 13163, 13194, 13197, 13198, 13201, 13209, 13210, 13215, 13229, 13230, 13233, 13234, 13235, 13236, 13237, 13238, 13240, 13246, 13247, 13248, 13249, 13252, 13257, 13264, 13267, 13271, 13272, 13274, 13277, 13278, 13279, 13280, 13281, 13282, 13295, 13296, 13297, 13298, 13299, 13333, 13336, 13337, 13338, 13342, 13347, 13348, 13349, 13350, 13351, 13598, 13366, 13371, 13378, 13398, 13431, 13432, 13433, 13434, 13490, 13492, 13493, 13497, 13498, 13500, 13509, 13513, 13514, 13515, 13516, 13517, 13518, 13520, 13521, 13522, 13523, 13524, 13525, 13528, 13532, 13533, 13539, 13564, 13565, 13566, 13583, 13588, 13590, 13591, 13592, 13599, 13602, 13612, 13614, 13615, 13616, 13621, 13622, 13624, 13632, 13633, 13634, 13635, 13636, 13637, 13687, 13688, 13689, 13690, 13691, 13693, 13694, 13695, 13698, 13721, 13722, 13731, 13732, 13733, 13735, 13736, 13737, 13738, 13743, 13758, 13759, 13760, 13768, 13769, 13770, 13772, 13776, 13777, 13778, 13779, 13787, 13788, 13789, 13791, 13790, 13792, 13801, 13802, 13803, 13807, 13809, 13818, 13829, 13847, 13853, 13854, 13861, 13872, 13881, 13882, 13897, 13898, 13899, 13900, 13901, 13902, 13903, 13905, 13906, 13909, 13907, 13910, 13908, 13911, 13912, 13914, 13920, 13921, 13922, 13923, 13924, 13926, 13927, 13935, 13936, 13937, 13938, 13939, 13940, 13941, 13942, 13943, 13944, 13947, 13948, 13949, 13950, 13952, 13953, 13954, 13956, 13957, 13958, 13959, 13960, 13961, 13962, 13963, 13964, 13965, 13967, 13968, 13969, 13970, 13971, 13972, 13973, 13974, 13975, 13976, 13977, 13978, 13979, 13980, 13981, 13982, 13983, 13984, 13985, 13986, 13987, 13991, 13992, 13993, 13994, 13995, 13996, 14003, 14004, 14005, 14006, 14007, 14008, 14009, 14010, 14011, 14012, 14013, 14014, 14015, 14016, 14017, 14018, 14019, 14020, 14022, 14025, 14026, 14034, 14036, 14037, 14038, 14040, 14041, 14042, 14050, 14051, 14052, 14055, 14060, 14061, 14062, 14068, 14069, 14072, 14073, 14076, 14077, 14078, 14079, 14084, 14086, 14090, 14091, 14096, 14097, 14098, 14099, 14102, 14105, 14106, 14107, 14108, 14109, 14110, 14111, 14112, 14113, 14116, 14117, 14118, 14119, 14121, 14123, 14124, 14125, 14126, 14127, 14128, 14137, 14139, 14140, 14141, 14142, 14144, 14145, 14146, 14147, 14160, 14148, 14149, 14158, 14150, 14155, 14151, 14156, 14152, 14157, 14153, 14159, 14161, 14172, 14175, 14177, 14178, 14180, 14191, 14192, 14194, 14195, 14198, 14201, 14202, 14204, 14205, 14208, 14209, 14211, 14213, 14216, 14217, 14218, 14220, 14222, 14223, 14224, 14225, 14229, 14231, 14232, 14244, 14245, 14247, 14248, 14249, 14250, 14254, 14255, 14256, 14257, 14258, 14261, 14265, 14266, 14269, 14270, 14277, 14283, 14295, 14296, 14297, 14298, 14299, 14300, 14301, 14302, 14305, 14306, 14307, 14324, 14332, 14338, 14341, 14342, 14343, 14345, 14346, 14347, 14348, 14351, 14352, 14353, 14354, 14362, 14364, 14387, 14388, 14389, 14390, 14395, 14396, 14397, 14398, 14399, 14400, 14401, 14413, 14414, 14416, 14423, 14425, 14426, 14428, 14435, 14434, 14436, 14440, 14446, 14447, 14450, 14449, 14454, 14464, 14467, 14468, 14469, 14470, 14472, 14473, 14475, 14474, 14476, 14477, 14478, 14479, 14480, 14481, 14482, 14483, 14487, 14488, 14489, 14491, 14490, 14492, 14497, 14498, 14499, 14501, 14502, 14504, 14511, 14514, 14515, 14516, 14517, 14518, 14519, 14520, 14539, 14540, 14545, 14546, 14547, 14549, 14550, 14555, 14556, 14557, 14560, 14561, 14562, 14563, 14564, 14565, 14566, 14568, 14569, 14575, 14576, 14577, 14578, 14579, 14580, 14582, 14583, 14592, 14593, 14595, 14603, 14605, 14606, 14611, 14612, 14613, 14614, 14615, 14616, 14617, 14618, 14619, 14623, 14628, 14624, 14625, 14627, 14629, 14630, 14631, 14632, 14633, 14634, 14647, 14648, 14677, 14679, 14678, 14680, 14682, 14683, 14685, 14686, 14691, 14693, 14692, 14697, 14696, 14699, 14702, 14703, 14704, 14705, 14714, 14715, 14716, 14717, 14718, 14720, 14721, 14722, 14732, 14735, 14736, 14737, 14739, 14738, 14740, 14741, 14742, 14745, 14746, 14750, 14757, 14758, 14759, 14760, 14765, 14766, 14767, 14768, 14770, 14771, 14772, 14773, 14774, 14776, 14777, 14778, 14779, 14780, 14781, 14782, 14783, 14784, 14785, 14789, 14791, 14792, 14793, 14794, 14795, 14798, 14799, 14802, 14803, 14806, 14807, 14808, 14815, 14816, 14817, 14818, 14820, 14821, 14822, 14823, 14824, 14825, 14826, 14833, 14834, 14835, 14837, 14838, 14839, 14840, 14841, 14842, 14845, 14846, 14852, 14853, 14854, 14855, 14856, 14869, 14870, 14871, 14877, 14879, 14886, 14885, 14888, 14889, 14891, 14892, 14893, 14895, 14896, 14897, 14898, 14905, 14906, 14907, 14908, 14911, 14910, 14912, 14913, 14916, 14917, 14918, 14919, 14920, 14921, 14922, 14926, 14927, 14928, 14929, 14930, 14933, 14934, 14935, 14936, 14937, 14938, 14939, 14940, 14941, 14942, 14956, 14960, 14961, 14962, 14963, 14970, 14969, 14971, 14972, 14976, 14977, 14978, 14979, 14989, 14990, 14991, 15007, 15008, 15014, 15015, 15018, 15020, 15021, 15022, 15023, 15024, 15031, 15032, 15033, 15041, 15053, 15055, 15056, 15057, 15058, 15059, 15061, 15060, 15065, 15067, 15075, 15078, 15080, 15079, 15081, 15083, 15087, 15086, 15088, 15090, 15091, 15093, 15094, 15095, 15096, 15103, 15104, 15106, 15108, 15109, 15113, 15112, 15114, 15116, 15117, 15118, 15120, 15119, 15121, 15122, 15123, 15124, 15130, 15131, 15134, 15135, 15137, 15140, 15139, 15142, 15152, 15153, 15162, 15163, 15164, 14200, 15165, 15166, 15167, 15168, 15169, 15170, 15171, 15172, 15173, 15174, 15175, 15176, 15177, 15183, 15184, 15196, 15197, 15199, 15198, 15201, 15202, 15203, 15204, 15205, 15209, 15210, 15211, 15212, 15213, 15214, 15215, 15216, 15219, 15220, 15225, 15226, 15227, 15228, 15229, 15230, 15231, 15237, 15239, 15240, 15241, 15242, 15244, 15245, 15246, 15248, 15249, 15250, 15251, 15252, 15253, 15254, 15255, 15261, 15016, 15263, 15264, 15266, 15267, 15268, 15269, 15270, 15279, 15280, 15282, 15283, 15284, 15287, 15289, 15293, 15295, 15296, 15297, 15298, 15300, 15301, 15302, 15304, 15308, 15309, 15310, 15311, 15312, 15313, 15315, 15316, 15317, 15318, 15321, 15323, 15322, 15324, 15325, 15326, 15329, 15332, 15342, 15343, 15352, 15358, 15359, 15361, 15362, 15363, 15364, 15365, 15366, 15367, 15368, 15382, 15383, 15387, 15388, 15389, 15391, 15392, 15395, 15396, 15397, 15398, 15399, 15400, 15401, 15403, 15404, 15405, 15406, 15417, 15418, 15419, 15420, 15421, 15423, 15425, 15435, 15436, 15437, 15438, 15439, 15440, 15441, 15442, 15450, 15451, 15452, 15467, 15473, 15474, 15476, 15477, 15478, 15479, 15480, 15481, 15482, 15483, 15484, 15487, 15486, 15488, 15490, 15491, 15492, 15493, 15494, 15502, 15503, 15504, 15505, 15507, 15508, 15511, 15510, 15514, 15515, 15516, 15517, 15518, 15526, 15527, 15528, 15529, 15530, 15531, 15532, 15533, 15536, 15545, 15546, 15548, 15549, 15550, 15551, 15553, 15554, 15555, 15559, 15560, 15561, 15564, 15565, 15566, 15567, 15568, 15569, 15570, 15576, 15577, 15578, 15581, 15582, 15583, 15584, 15586, 15587, 15588, 15589, 15591, 15593, 15594, 15595, 15596, 15597, 15598, 15599, 15600, 15602, 15603, 15604, 15605, 15607, 15609, 15610, 15611, 15618, 15621, 15622, 15627, 15626, 15628, 15629, 15630, 15632, 15633, 15634, 15635, 15636, 15638, 15639, 15640, 15642, 15644, 15645, 15646, 15647, 15652, 15653, 15654, 15655, 15660, 15661, 15662, 15663, 15664, 15665, 15666, 15682, 15683, 15684, 15685, 15686, 15687, 15688, 15693, 15694, 15696, 15698, 15699, 15700, 15701, 15702, 15704, 15705, 15706, 15709, 15710, 15711, 15712, 15713, 15721, 15728, 15729, 15730, 15732, 15733, 15734, 15735, 15736, 15738, 15740, 15741, 15742, 15743, 15744, 15746, 15747, 15748, 15749, 15754, 15756, 16699, 16700, 15757, 15758, 15759, 15771, 15772, 15774, 15775, 15777, 15778, 15779, 15780, 15781, 15785, 15786, 15787, 15797, 15798, 15801, 15802, 15803, 15804, 15805, 15806, 15810, 15811, 15812, 15813, 15814, 15815, 15816, 15817, 15818, 15819, 15820, 15821, 15823, 15824, 15825, 15832, 15833, 15834, 15835, 15836, 15837, 15838, 15839, 15842, 15843, 15844, 15845, 15846, 15847, 15849, 15850, 15851, 15852, 15853, 15854, 15855, 15856, 15857, 15858, 15859, 15860, 15866, 15865, 15867, 15869, 15870, 15871, 15875, 15876, 15877, 15879, 15881, 15882, 15883, 15884, 15886, 15887, 15888, 15889, 15903, 15904, 15905, 15906, 15907, 15908, 15910, 15911, 15916, 15917, 15918, 15922, 15923, 15924, 15926, 15927, 15928, 15933, 15934, 15935, 15936, 15937, 15938, 15939, 15941, 15942, 15943, 15944, 15945, 15946, 15947, 15948, 15949, 15950, 15951, 15952, 15953, 15954, 15955, 15956, 15957, 15958, 15959, 15960, 15961, 15962, 15963, 15964, 15965, 15966, 15967, 15969, 15970, 15971, 15972, 15973, 15974, 15975, 15976, 15977, 15978, 15979, 15980, 15981, 15982, 15983, 15984, 15990, 15989, 15997, 16001, 16002, 16003, 16004, 16005, 16006, 16007, 16008, 16011, 16012, 16013, 16014, 16015, 16018, 16019, 16020, 16021, 16022, 16023, 16024, 16025, 16026, 16027, 16028, 16031, 16032, 16033, 16034, 16041, 16042, 16043, 16044, 16045, 16046, 16047, 16053, 16054, 16055, 16056, 16057, 16064, 16065, 16066, 16067, 16070, 16072, 16071, 16080, 16079, 16081, 16082, 16083, 16084, 16086, 16087, 16088, 16089, 16090, 16091, 16092, 16093, 16098, 16099, 16101, 16100, 16102, 16103, 16104, 16105, 16106, 16107, 16108, 16109, 16110, 16111, 16112, 16113, 16114, 16116, 16117, 16121, 16122, 16125, 16126, 16127, 16128, 16130, 16131, 16133, 16134, 16135, 16136, 16139, 16140, 16141, 16142, 16143, 16144, 16146, 16147, 16148, 16149, 16150, 16151, 16154, 16156, 16157, 16158, 16159, 16160, 16161, 16162, 16163, 16164, 16165, 16174, 16175, 16176, 16178, 16179, 16180, 16181, 16182, 16183, 16184, 16185, 16186, 16187, 16188, 16189, 16206, 16207, 16208, 16212, 16213, 16214, 16216, 16217, 16218, 16219, 16220, 16221, 16222, 16223, 16224, 16228, 16229, 16230, 16231, 16232, 16233, 16237, 16238, 16239, 16244, 16245, 16246, 16247, 16248, 16249, 16250, 16251, 16252, 16253, 16254, 16265, 16266, 16267, 16268, 16274, 16275, 16276, 16277, 16278, 16279, 16280, 16283, 16284, 16285, 16286, 16287, 16288, 16289, 16290, 16291, 16292, 16293, 16294, 16295, 16296, 16297, 16298, 16299, 16300, 16301, 16302, 16303, 16304, 16305, 16306, 16307, 16310, 16311, 16312, 16313, 16314, 16315, 16319, 16318, 16320, 16321, 16326, 16325, 16327, 16328, 16338, 16339, 16340, 16341, 16342, 16345, 16346, 16347, 16348, 16355, 16358, 16359, 16361, 16360, 16362, 16363, 16372, 16373, 16374, 16375, 16376, 16377, 16378, 16379, 16380, 16381, 16382, 16390, 16389, 16391, 16392, 16397, 16396, 16398, 16399, 16400, 16404, 16406, 16405, 16407, 16409, 16408, 16410, 16412, 16415, 16414, 16416, 16417, 16419, 16420, 16421, 16422, 16423, 16424, 16428, 16429, 16430, 16431, 16433, 16435, 16436, 16437, 16440, 16441, 16442, 16443, 16444, 16445, 16446, 16447, 16448, 16449, 16450, 16451, 16452, 16453, 16454, 16455, 16460, 16461, 16462, 16463, 16464, 16465, 16466, 16467, 16468, 16469, 16470, 16474, 16475, 16476, 16477, 16478, 16479, 16483, 16484, 16485, 16500, 16499, 16501, 16503, 16502, 16504, 16508, 16507, 16509, 16512, 16516, 16515, 16517, 16518, 16519, 16521, 16520, 16522, 16524, 16523, 16525, 16526, 16527, 16528, 16529, 16530, 16531, 16532, 16533, 16534, 16535, 16536, 16538, 16537, 16539, 16540, 16541, 16542, 16543, 16544, 16545, 16547, 16546, 16548, 16552, 16553, 16554, 16558, 16557, 16559, 16560, 16561, 16562, 16563, 16564, 16566, 16565, 16567, 16568, 16569, 16571, 16573, 16572, 16574, 16575, 16576, 16577, 16579, 16578, 16580, 16581, 16582, 16583, 16584, 16585, 16586, 16587, 16588, 16589, 16590, 16597, 16598, 16599, 16600, 16601, 16602, 16604, 16605, 16621, 16622, 16623, 16624, 16625, 16626, 16627, 16628, 16630, 16631, 16632, 16633, 16634, 16635, 16636, 16637, 16641, 16642, 16643, 16644, 16645, 16646, 16647, 16648, 16649, 16650, 16651, 16652, 16653, 16654, 16655, 16656, 16660, 16661, 16662, 16663, 16664, 16665, 16666, 16667, 16668, 16669, 16670, 16671, 16672, 16673, 16674, 16679, 16680, 16681, 16682, 16683, 16684, 16685, 16686, 16687, 16688, 16689, 16690, 16691, 16692, 16693, 16694, 16696, 16697, 16698, 16701, 16702, 16703, 16704, 16706, 16708, 16710, 16711, 16712, 16713, 16715, 16714, 16716, 16717, 16718, 16719, 16720, 16721, 16722, 16723, 16724, 16725, 16726, 16727, 16728, 16729, 16730, 16731, 16732, 16733, 16734, 16735, 16736, 16737, 16738, 16739, 16741, 16742, 16743, 16744, 16745, 16746, 16747, 16748, 16749, 16750, 16752, 16753, 16754, 16756, 16757, 16758)

)
ORDER BY displayorder DESC
LIMIT 0, 25;
Any ideas? __DEFINE_LIKE_SHARE__