Memory exhausted issue with 3500 links

Hi tooocool,

How many links are you showing on the All Affiliate Links page? (check Screen Options, top right).

If that is too many on any post type it will cause issues. I recommend keeping it under 50 if you’re having memory issues.

Cheers,
Josh

I have just 20 affiliate links displayed per page. Yet, it takes more than 115MB of memory for this page edit.php?post_type=thirstylink

When I check the queries for the page.. I can see this (which could be causing the issue)

SELECT t.*, tt.*, tr.object_id
FROM bti_terms AS t
INNER JOIN bti_term_taxonomy AS tt
ON tt.term_id = t.term_id
INNER JOIN bti_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN (‘thirstylink-category’)
AND tr.object_id IN (3154, 3436, 3395, 3388, 4109, 5263, 3512, 3598, 3606, 3620, 3576, 3197, 4178, 4171, 5202, 4291, 4289, 6040, 6041, 6032, 4032, 5781, 3679, 3699, 4010, 5786, 3698, 3696, 5787, 3691, 3688, 5770, 3682, 4019, 3689, 4022, 5774, 3684, 5777, 3683, 3673, 4028, 5779, 3700, 4008, 5785, 3680, 4021, 3678, 4023, 5775, 3670, 4015, 3701, 5766, 3685, 4014, 5769, 3671, 4017, 5772, 3687, 4020, 5773, 3675, 5778, 3672, 4025, 5776, 3677, 3694, 4009, 3272, 3686, 4034, 5782, 3674, 4030, 5780, 3676, 4035, 5783, 3690, 4016, 5771, 3693, 5767, 3697, 4011, 5764, 5789, 3692, 4012, 5765, 3268, 3269, 3270, 3271, 3695, 4013, 5768, 3681, 4027, 1965, 1983, 1973, 1978, 1982, 1979, 1963, 1966, 1971, 1969, 1974, 1981, 1977, 1967, 1976, 1975, 1968, 1754, 4935, 1753, 2927, 5185, 5186, 5184, 1752, 5188, 1749, 1757, 1758, 2928, 3072, 3165, 3166, 3169, 3170, 3151, 3152, 3153, 5844, 3155, 3156, 3161, 3162, 5846, 3142, 3134, 3141, 5841, 3147, 3148, 5845, 3130, 3143, 3144, 5842, 3149, 3150, 5843, 3145, 3146, 3157, 3158, 5847, 3159, 3160, 3163, 3164, 5848, 3173, 3174, 3167, 3168, 3171, 3172, 623, 625, 617, 3095, 3096, 631, 633, 638, 629, 646, 2267, 5885, 656, 658, 662, 660, 3100, 3101, 3109, 5893, 650, 2276, 2263, 640, 5882, 3097, 2272, 5890, 3102, 3103, 635, 648, 2280, 642, 5899, 3105, 3106, 644, 2283, 654, 652, 5902, 614, 621, 582, 3441, 5521, 3427, 3889, 5500, 3428, 3890, 5501, 5528, 3887, 5499, 3430, 3893, 5503, 3439, 3891, 5504, 3438, 619, 3888, 5502, 3425, 3896, 5507, 3431, 3892, 5505, 3426, 3442, 3900, 5515, 3432, 3895, 5506, 3899, 5513, 3894, 5508, 5525, 3433, 3897, 5509, 3435, 3898, 5511, 3434, 3440, 3901, 5517, 3437, 3902, 5519, 1277, 3858, 3414, 3394, 3878, 3063, 3378, 3876, 5580, 3417, 3863, 5559, 3415, 5558, 3381, 3862, 5556, 3371, 3420, 3861, 5554, 3423, 3868, 3374, 5588, 3391, 3879, 5581, 3112, 3113, 3115, 3118, 3122, 3127, 3123, 3117, 3114, 3094, 5850, 3108, 3126, 3116, 3121, 3129, 3098, 3419, 3884, 3387, 3877, 5579, 3402, 5591, 5574, 3385, 5587, 3409, 3883, 5592, 3400, 3871, 5573, 3404, 3865, 5562, 3392, 3367, 3850, 5439, 3366, 3849, 5438, 3418, 3852, 3403, 3856, 5553, 3424, 3421, 3422, 3401, 3869, 5568, 5577, 5594, 3376, 3406, 3866, 5570, 3386, 5584, 3390, 3379, 3875, 3389, 3384, 5578, 3874, 3380, 5576, 3372, 5585, 5590, 3373, 3881, 5586, 3375, 5582, 3882, 5589, 3377, 3370, 3880, 5583, 3363, 3872, 5572, 3393, 3853, 5415, 5440, 3368, 3857, 5445, 3365, 3851, 5443, 3399, 3369, 3870, 5571, 3364, 3864, 5565, 3398, 3405, 3413, 3855, 5444, 3410, 3859, 5442, 3407, 3408, 3397, 3396, 3860, 882, 4943, 2925, 886, 4945, 5131, 5228, 884, 5128, 5129, 1871, 2945, 6042, 1872, 1886, 3076, 3077, 867, 2325, 5000, 5073, 869, 868, 2333, 5080, 874, 863, 2327, 5076, 861, 2331, 5083, 864, 854, 858, 856, 2329, 5078, 871, 2335, 5082, 1885, 2947, 6025, 1888, 6027, 1887, 6026, 1889, 1884, 2950, 6033, 1883, 2948, 6028, 1893, 2949, 6029, 1880, 6035, 1882, 6038, 1890, 6030, 4099, 4619, 4094, 4096, 4641, 4646, 4065, 4069, 4079, 4632, 4635, 4630, 4064, 4631, 4073, 4633, 4093, 4657, 4090, 4658, 3782, 3783, 4067, 4066, 4071, 4643, 4640, 4639, 4113, 3787, 4645, 4068, 4089, 4081, 4647, 4091, 4655, 4092, 4656, 4074, 4095, 4642, 4087, 4650, 4644, 4080, 4078, 4653, 4651, 4082, 4652, 4085, 4654, 4627, 4103, 4105, 4111, 4620, 4070, 4617, 3784, 4075, 4108, 4106, 4618, 4107, 4648, 3786, 4072, 4616, 4112, 4628, 4101, 4098, 4621, 4100, 4625, 4076, 4629, 4637, 4623, 4102, 4104, 4626, 4114, 3313, 3350, 3328, 3844, 5243, 3060, 3343, 5345, 3831, 3317, 3835, 3348, 3841, 5385, 3345, 3303, 3349, 5260, 5359, 3353, 3813, 3292, 3812, 3300, 3352, 3824, 3331, 5241, 3358, 3794, 5237, 3347, 3792, 5269, 3287, 3816, 3833, 3301, 3818, 5300, 3297, 3335, 3296, 3843, 3299, 5254, 5340, 5258, 3290, 3803, 3808, 3307, 3830, 5366, 3293, 3288, 3838, 5239, 3793, 3359, 3346, 3305, 3315, 5283, 3354, 3822, 3329, 3344, 3351, 5265, 5303, 5294, 3362, 3356, 3825, 3284, 3823, 3330, 3323, 3840, 5353, 3360, 3832, 3302, 3316, 3842, 3295, 3336, 3839, 3361, 3068, 3069, 3795, 3289, 3219, 3220, 5931, 3221, 3222, 5933, 3235, 3236, 5937, 3229, 3230, 5938, 3225, 3226, 5934, 3227, 3228, 5935, 3223, 3224, 5936, 5236, 3325, 3791, 3312, 5245, 3304, 5362, 3294, 5247, 5256, 3285, 3797, 3283, 3806, 5308, 5377, 3286, 3827, 3282, 5332, 3291, 3819, 5249, 5336, 5251, 5275, 3327, 3800, 3829, 3355, 3338, 3801, 3357, 5371, 5389, 5350, 5374, 5387, 3337, 3828, 3298, 3306, 3836, 3324, 3814, 3340, 3309, 3834, 3311, 3326, 3339, 3310, 4394, 4409, 4397, 4851, 4406, 4379, 4852, 4381, 4858, 4407, 4386, 4380, 4855, 4399, 4378, 4857, 4408, 4850, 4398, 4847, 4382, 4388, 4863, 4403, 4404, 4400, 4401, 4860, 4396, 4848, 4391, 4845, 4846, 4395, 4392, 4410, 4411, 4385, 4377, 4849, 4405, 4853, 4393, 4383, 4384, 4861, 4402, 4862, 3073, 3049, 947, 2362, 898, 2387, 928, 2370, 938, 2391, 907, 2432, 931, 950, 901, 2381, 904, 1026, 954, 2351, 915, 2373, 921, 2337, 923, 918, 2339, 893, 2354, 896, 945, 935, 2345, 942, 2343, 912, 2347, 895, 2349, 2341, 925, 910, 537, 2264, 5474, 557, 5469, 553, 2271, 800, 798, 565, 796, 3104, 3099, 5851, 1916, 3062, 2064, 3064, 5983, 2003, 3039, 3051, 2054, 3053, 5976, 2037, 3047, 5971, 1994, 3058, 5980, 2045, 3056, 5979, 2027, 3055, 5978, 2047, 3061, 5982, 2058, 3042, 5967, 2042, 3050, 5972, 2056, 3034, 5963, 2013, 3033, 5962, 1997, 5959, 2052, 3037, 5965, 2019, 3036, 5964, 2039, 5975, 2029, 5973, 2017, 3045, 5969, 2066, 3054, 5977, 2062, 3065, 2060, 2032, 5974, 2007, 3031, 5960, 2050, 3032, 5961, 2009, 3041, 5966, 2035, 3046, 5970, 2015, 3043, 5968, 2000, 5981, 3552, 3915, 5687, 3550, 3907, 5671, 3496, 5675, 3465, 5696, 3517, 3927, 5704, 3471, 3940, 5714, 3522, 5688, 3926, 5703, 3447, 3458, 3910, 5677, 3541, 3468, 3950, 5741, 3464, 3943, 5721, 3479, 3947, 5737, 3485, 3453, 3939, 5711, 3455, 3920, 5691, 3467, 5702, 3448, 3923, 5700, 3450, 5709, 3443, 3948, 5738, 3492, 5694, 3444, 3445, 5681, 3491, 3919, 5690, 5760, 3495, 3921, 5693, 3494, 3918, 5689, 3544, 5674, 3545, 5683, 3482, 3917, 3487, 3911, 5680, 3546, 3912, 5697, 3454, 3511, 3519, 3504, 3908, 5673, 3942, 5718, 3909, 5676, 3483, 5684, 3549, 5672, 3489, 3462, 3916, 3460, 5685, 3477, 3913, 5682, 3528, 5736, 3475, 5716, 3520, 5735, 3490, 5707, 3542, 3446, 3451, 3459, 3493, 3449, 3536, 3501, 5754, 3484, 3955, 5747, 3539, 3958, 5752, 3540, 5755, 3547, 3960, 5757, 3497, 3959, 5753, 3474, 5751, 3548, 5743, 3553, 3521, 5750, 3537, 5719, 3523, 5740, 3481, 5744, 3470, 5742, 3500, 5678, 3463, 3938, 5710, 3538, 5695, 3472, 5713, 3480, 3941, 5717, 3466, 3944, 5722, 3461, 3469, 3956, 5748, 3457, 3951, 5745, 3525, 3922, 5699, 3532, 5698, 3524, 5692, 3914, 3551, 5686, 3518, 5720, 3526, 3945, 3473, 5706, 3533, 3924, 5701, 3543, 3531, 5739, 3527, 3478, 3476, 3949, 3488, 5734, 3508, 3486, 3530, 5708, 3534, 3954, 5746, 3505, 3928, 5705, 3529, 5749, 1573, 5404, 289, 321, 297, 311, 1993, 5405, 370, 2217, 5421, 398, 307, 317, 2011, 5411, 573, 2243, 5427, 574, 400, 2239, 5426, 555, 2233, 5424, 293, 2034, 2031, 5419, 299, 2227, 5423, 303, 362, 2236, 5425, 546, 2041, 382, 1999, 567, 2220, 376, 5422, 313, 2252, 3382, 5431, 550, 323, 2255, 5432, 390, 563, 559, 2248, 366, 5510, 1428, 2546, 1433, 1436, 2542, 1417, 2548, 2540, 4538, 4540, 1429, 1434, 2552, 2534, 1438, 2528, 1440, 2532, 1432, 1437, 1441, 1415, 2544, 1419, 2550, 4531, 4564, 4569, 1431, 1430, 2536, 1439, 2538, 3202, 5920, 5921, 3210, 3204, 5919, 1860, 1834, 2963, 6003, 1854, 2965, 6006, 1862, 1843, 2968, 6008, 1755, 2973, 6012, 1747, 1741, 2974, 6013, 1764, 1831, 2978, 6016, 1738, 2980, 6019, 1815, 1836, 2972, 6011, 1744, 2979, 6017, 2969, 1734, 2976, 6014, 1859, 1876, 2964, 6005, 1849, 1864, 2962, 6002, 1847, 1790, 6004, 1762, 2977, 6015, 1768, 1766, 6009, 1777, 2967, 6007, 1760, 1750, 2971, 6010, 1845, 2956, 5998, 1807, 1891, 2958, 5999, 3209, 1782, 1785, 1820, 3214, 3215, 3206, 3207, 5923, 3208, 5925, 3212, 5922, 3211, 3203, 3213, 3205, 3217, 3218, 5924, 1798, 2959, 1811, 2957, 1827, 1794, 1796, 1874, 6001, 1823, 2960, 6000, 3044, 1513, 1580, 2786, 4955, 5139, 1454, 2828, 4984, 5153, 1460, 1527, 1618, 2874, 5173, 1591, 2870, 5168, 2876, 1455, 1482, 1628, 2868, 4998, 5167, 1632, 5176, 1586, 2854, 1636, 1450, 2872, 4999, 5175, 1452, 1480, 2862, 5170, 1485, 1514, 1538, 2878, 5001, 5177, 1626, 1521, 1457, 1592, 2846, 1537, 2850, 1603, 2858, 5169, 1502, 2842, 4988, 5164, 1617, 2864, 5172, 1489, 2880, 1473, 2834, 5158, 1490, 1645, 2848, 4990, 4991, 5160, 1523, 1458, 1498, 2866, 4996, 5165, 1530, 1467, 1469, 2824, 5149, 1471, 2822, 4981, 5150, 1456, 1462, 2838, 4986, 4987, 5155, 1477, 1598, 1597, 2830, 5154, 1585, 1595, 2826, 4983, 5151, 1509, 2832, 4985, 5157, 1543, 1634, 2836, 5161, 1620, 2860, 5159, 1629, 1639, 2844, 1635, 1642, 2840, 1631, 2852, 1630, 1621, 2798, 1554, 1625, 2790, 1495, 2820, 1627, 2812, 5145, 2816, 1581, 1470, 2792, 5137, 1599, 1644, 2808, 1506, 2788, 5143, 1464, 1616, 2776, 5135, 1602, 2778, 5134, 4951, 1465, 2780, 5136, 4952, 1539, 2784, 1531, 1619, 2804, 4965, 4966, 5144, 1468, 1475, 2818, 5148, 1487, 1596, 2802, 4964, 5146, 1478, 1505, 2814, 1491, 1547, 2796, 4957, 5140, 1484, 2782, 5141, 5180, 1552, 2800, 4959, 5138, 1474, 2810, 5142, 1534, 1641, 2794, 1622, 1624, 4980, 5147, 1623, 1500, 2806, 1407, 1338, 1365, 2650, 1391, 2660, 1403, 2717, 1408, 1411, 2697, 1371, 1422, 1423, 1358, 1359, 1375, 2724, 1414, 1418, 2733, 1366, 1367, 2742, 3279, 1390, 2735, 1341, 1345, 2653, 1328, 2672, 1401, 2685, 1378, 1379, 2682, 1374, 2668, 1393, 1395, 2689, 1342, 1353, 2731, 1376, 2679, 1373, 2691, 1309, 1315, 2628, 1301, 2604, 1425, 1426, 2622, 1350, 2610, 1382, 1424, 1421, 2616, 1355, 1356, 2613, 1385, 2633, 1384, 1398, 1409, 1383, 2729, 1405, 1340, 2702, 1363, 2758, 2739, 2755, 1362, 1380, 2676, 1233, 1267, 1231, 1237, 1402, 2709, 1319, 1321, 2725, 1400, 1404, 2705, 1420, 1410, 1229, 1336, 1399, 1413, 2640, 1343, 1351, 2644, 1357, 1364, 2658, 1245, 1254, 1311, 1324, 1333, 2636, 1372, 2665, 3277, 3278, 1293, 1265, 1326, 2620, 1377, 1396, 2625, 1381, 1394, 1347, 2772, 1368, 1239, 1360, 1370, 2770, 1348, 1352, 1386, 2721, 1296, 1361, 2762, 1273, 1280, 1389, 2753, 1397, 1416, 2766, 1235, 1305, 2746, 1249, 2750, 1369, 2764, 1286, 2774, 1387, 2760, 1388, 1392, 2713, 1323, 2768, 4556, 4552, 4550, 4903, 4554, 4549, 4551, 1302, 2882, 1503, 2885, 1297, 2886, 1528, 1610, 2884, 1511, 2889, 1307, 2883, 1589, 1600, 2897, 3276, 1565, 2894, 1545, 2898, 1558, 2896, 3274, 3275, 1569, 2900, 1497, 2901, 1551, 1518, 2902, 1583, 1593, 2903, 1283, 2905, 1604, 2907, 1612, 2911, 1561, 2906, 1556, 2908, 1493, 2909, 1275, 2912, 1525, 2910, 1606, 2913, 1608, 1614, 2914, 1271, 2920, 1549, 2916, 1571, 2918, 1268, 2917, 1263, 2915, 3273, 1312, 1532, 2890, 1563, 2891, 1317, 2895, 1507, 1541, 2888, 1290, 2919, 1516, 2893, 1535, 3189, 3190, 5989, 735, 2287, 3186, 5993, 740, 2289, 771, 2293, 779, 772, 737, 2291, 774, 3181, 3182, 5991, 3177, 3178, 5992, 786, 2295, 3184, 3185, 5994, 776, 747, 2297, 773, 769, 770, 2307, 3580, 3967, 5600, 3651, 5610, 3554, 3563, 3639, 3566, 3640, 3649, 5598, 3570, 5648, 3643, 5629, 3594, 3983, 5624, 3632, 3975, 5608, 3599, 5618, 3557, 3995, 5652, 3577, 5636, 3593, 5630, 5641, 3571, 3560, 3977, 5611, 3617, 3978, 5612, 3579, 3987, 5633, 3556, 3981, 5617, 3558, 5643, 3635, 3984, 5626, 3597, 5632, 3567, 5646, 3562, 3990, 5637, 3601, 3996, 5654, 3555, 3578, 5604, 3616, 3968, 5601, 3611, 3966, 3645, 5597, 3569, 3971, 5603, 3618, 3974, 5607, 3565, 3642, 5616, 3641, 3979, 5613, 3604, 3976, 5609, 3603, 3980, 5615, 3982, 5623, 3614, 5625, 3175, 3176, 5990, 3183, 3559, 3965, 5596, 3595, 3994, 5650, 3988, 5634, 3627, 3989, 5635, 3615, 3972, 5605, 3650, 5599, 3628, 3573, 3631, 3973, 5606, 3633, 3654, 3969, 5602, 3608, 5614, 3582, 3998, 3575, 5655, 3622, 3634, 3572, 5658, 3602, 790, 763, 736, 2321, 734, 2309, 1920, 4276, 3592, 3986, 5631, 752, 2301, 732, 733, 2299, 783, 2303, 755, 2311, 775, 780, 2313, 791, 743, 2317, 2305, 766, 748, 2315, 749, 3629, 3652, 5620, 3609, 4000, 5659, 3610, 5651, 3619, 3644, 5647, 3605, 5660, 3993, 3613, 5668, 762, 767, 2319, 5321, 789, 2323, 768, 3612, 5667, 3626, 4004, 5669, 3187, 3188, 5996, 3596, 4003, 5663, 5664, 3179, 3180, 5995, 3591, 3991, 5638, 3623, 3997, 5656, 3581, 5666, 3564, 3590, 3589, 3985, 5627, 3561, 5649, 3574, 3992, 5645, 3588, 3607, 3624, 3999, 5657, 3568, 4001, 5661, 3621, 5665, 3638, 4002, 5662, 571, 2219, 5453, 569, 576, 2360, 5473, 723, 2268, 5471, 528, 540, 2259, 781, 2376, 2380, 5482, 544, 702, 2364, 700, 5478, 5477, 760, 704, 712, 718, 2366, 787, 548, 2372, 777, 710, 741, 2226, 5458, 758, 793, 2230, 5459, 2251, 5464, 578, 535, 708, 745, 750, 2256, 5466, 561, 2261, 5468, 526, 756, 5457, 764, 721, 2223, 5454, 715, 738, 2235, 753, 2242, 5460, 784, 532, 542, 2246, 5461, 52, 1781, 1787, 1771, 1775, 2930, 1776, 1772, 1788, 1780, 1779, 1784, 1911, 1222, 986, 1010, 2608, 5859, 1078, 2602, 1083, 2637, 5864, 1155, 3013, 5896, 933, 934, 1019, 2632, 5863, 1132, 5873, 906, 2581, 5856, 941, 2440, 5825, 1111, 2562, 985, 2462, 1000, 2572, 5853, 1100, 980, 2458, 5827, 1020, 5828, 1015, 2577, 5854, 892, 2580, 5855, 878, 889, 2568, 5829, 1017, 1032, 2468, 1141, 2605, 5858, 998, 1125, 2593, 5857, 1025, 1043, 1143, 2612, 5860, 914, 2710, 5884, 930, 1038, 1011, 3016, 5898, 846, 847, 2706, 5883, 903, 3024, 5913, 1106, 5912, 1909, 2954, 5803, 996, 3022, 5910, 2687, 900, 5875, 976, 1009, 839, 837, 838, 841, 840, 842, 843, 2736, 5888, 987, 5881, 1165, 3014, 5897, 850, 2700, 5879, 1086, 1158, 1161, 2693, 5876, 1023, 2664, 5870, 974, 2646, 5866, 1114, 1117, 2642, 5865, 1145, 2696, 5877, 5917, 981, 3027, 1031, 5906, 957, 958, 3017, 5901, 876, 2655, 5868, 944, 2681, 5874, 978, 5916, 920, 3026, 909, 1041, 3018, 851, 2719, 5887, 1007, 3021, 5907, 1022, 2675, 5872, 982, 2669, 5871, 3199, 3200, 5915, 1018, 3025, 999, 1028, 1146, 2741, 5889, 988, 1138, 2715, 5886, 989, 5909, 1037, 1150, 2452, 5826, 1029, 3023, 5911, 5928, 3198, 3191, 3192, 5930, 3193, 3194, 3196, 5927, 5929, 3195, 949, 2438, 5823, 1005, 1103, 5903, 845, 2649, 5867, 1171, 1910, 2744, 5892, 3201, 940, 2410, 1168, 2627, 5862, 2661, 852, 866, 877, 927, 5869, 844, 848, 853, 937, 1006, 1044, 1129, 2618, 5861, 997, 2402, 5810, 1035, 2389, 5805, 991, 993, 994, 2400, 5809, 1003, 1090, 2396, 5807, 873, 2398, 5808, 1021, 2404, 992, 2394, 5806, 984, 2418, 5815, 1024, 2408, 5812, 952, 2406, 5811, 1001, 2412, 5814, 1012, 1122, 1134, 2422, 2428, 5817, 5820, 1095, 2430, 5821, 1004, 2420, 5816, 879, 2414, 917, 2426, 5819, 983, 2416, 888, 2433, 5822, 990, 2424, 5818, 1014, 2446, 71, 62, 65, 73, 5496, 5497, 3763, 3766, 3765, 3764, 3761, 3759, 3760, 1907, 5797, 1908, 5801, 1903, 5802, 1905, 2953, 5800, 1901, 2952, 5799, 1906, 5796, 1900, 5798, 4700, 4252, 4255, 4713, 4690, 4242, 4223, 4135, 4662, 4225, 4673, 4118, 4671, 4136, 4147, 4687, 4141, 4692, 4145, 4694, 4670, 4237, 4577, 4661, 4665, 4219, 4140, 4663, 4222, 4666, 4236, 4676, 4143, 4667, 4226, 4668, 4239, 4669, 4233, 4679, 4229, 4683, 4224, 4693, 4688, 4238, 4234, 4691, 4156, 4714, 4205, 4752, 4139, 4697, 4201, 4695, 4202, 4720, 4203, 4716, 4721, 4193, 4194, 4739, 4736, 4115, 4702, 4155, 4698, 4256, 4719, 4146, 4735, 4176, 4717, 4123, 4710, 4144, 4733, 4199, 4757, 4122, 4704, 4179, 4718, 4723, 4166, 4121, 4715, 4148, 4743, 4163, 4744, 4742, 4137, 4737, 4741, 4157, 4746, 4169, 4748, 4159, 4753, 4162, 4754, 4142, 4747, 4154, 4160, 4750, 4158, 4755, 4200, 4756, 4149, 4745, 4660, 4134, 79, 2072, 5328, 186, 95, 2073, 4830, 5329, 222, 339, 83, 2075, 5330, 107, 219, 120, 91, 4838, 5334, 205, 203, 217, 151, 4905, 5331, 2086, 126, 5347, 425, 77, 2078, 5335, 192, 210, 211, 100, 2081, 5339, 250, 354, 112, 141, 2094, 5354, 275, 2122, 5370, 372, 145, 2090, 5344, 268, 114, 2079, 5338, 285, 135, 2096, 378, 118, 2084, 5341, 358, 406, 116, 207, 2087, 5342, 435, 240, 343, 98, 2089, 5349, 404, 384, 262, 258, 2092, 5351, 429, 413, 89, 2194, 5380, 282, 246, 4915, 4916, 5383, 87, 2118, 4865, 5358, 164, 109, 190, 93, 2182, 5372, 149, 160, 168, 2115, 102, 5356, 139, 172, 254, 5376, 415, 2188, 437, 104, 2191, 5379, 417, 423, 291, 348, 2126, 85, 2180, 5367, 244, 156, 137, 224, 5365, 419, 421, 394, 4867, 4884, 4887, 4889, 5382, 427, 2198, 5381, 431, 4912, 81, 2095, 5357, 215, 213, 176, 350, 2201, 5361, 433, 439, 4908, 4910, 5364, 130, 5369, 388, 233, 2184, 4521, 4518, 4534, 4892, 4527, 4894, 4536, 4893, 4535, 4514, 4525, 4533, 4520, 4511, 4898, 4510, 4897, 4523, 4530, 4528, 4512, 4885, 4513, 4896, 4522, 4524, 4532, 4515, 4891, 4516, 4888, 4529, 4519, 1937, 1947, 3007, 5985, 1935, 1949, 3009, 1945, 1950, 1940, 1942, 3005, 5987, 1931, 3010, 5986, 1943, 1957, 1952, 1938, 1933, 1953, 1961, 3008, 1955, 3006, 1959, 4359, 4809, 4365, 4373, 4367, 4811, 1295, 2576, 1248, 2599, 1282, 2558, 1261, 2554, 1285, 2556, 1258, 2560, 4364, 4376, 4837, 4372, 4826, 4375, 4829, 4371, 4833, 4374, 4366, 4369, 4836, 4352, 4832, 4351, 4828, 4370, 4825, 4354, 4361, 4827, 4358, 4356, 4355, 4810, 1252, 2583, 1247, 2569, 1279, 2587, 1289, 2589, 1255, 1287, 2592, 1242, 2596, 4368, 1291, 2573, 1250, 2585, 1253, 1262, 2563, 1257, 2565, 4413, 4503, 4500, 4877, 4504, 4502, 4499, 4876, 4506, 4875, 4505, 4415, 4880, 4498, 4874, 4509, 4871, 4507, 4872, 4508, 4414, 4870, 4501, 4416, 4868, 1221, 1915, 4272, 2984, 4547, 4545, 346, 2132, 5207, 4749, 4751, 325, 335, 2145, 147, 235, 2143, 4725, 5215, 333, 158, 231, 2160, 5219, 309, 319, 4731, 5218, 162, 264, 2149, 5216, 337, 2166, 519, 287, 331, 2177, 5231, 270, 315, 2168, 5224, 521, 129, 133, 226, 2134, 5213, 4760, 4761, 5211, 327, 329, 2162, 5222, 184, 248, 280, 2170, 5226, 182, 256, 2154, 5220, 260, 2158, 5225, 188, 294, 301, 2175, 5229, 143, 229, 2120, 5204, 266, 305, 2109, 5203, 356, 360, 2137, 5214, 5943, 3245, 3133, 368, 402, 2156, 3237, 5221, 5944, 3244, 5946, 3242, 5948, 5217, 374, 380, 3240, 5947, 2151, 392, 396, 2164, 3241, 5223, 5950, 386, 517, 2172, 3243, 5227, 5951, 166, 242, 2129, 5210, 174, 170, 200, 201, 252, 2091, 5195, 179, 2102, 5196, 5233, 4766, 4768, 4548, 153, 238, 2147, 4727, 3758, 5762, 3753, 3757, 352, 2139, 341, 4541, 4901, 4542, 4900, 4544, 4902, 4537, 4546, 3057, 4321, 4322, 4304, 4798, 4284, 4295, 4297, 4799, 4290, 4793, 4283, 4794, 4330, 4797, 4341, 4298, 4804, 4324, 4340, 4326, 4262, 4775, 4271, 4774, 4273, 4257, 4783, 4269, 4780, 4348, 4264, 4764, 4261, 4767, 4277, 4268, 4776, 4267, 4773, 4275, 4769, 4266, 4772, 4263, 4765, 4329, 4327, 4265, 4779, 4311, 4782, 4280, 4310, 4790, 4305, 4784, 4270, 4777, 4347, 4314, 4778, 4320, 4785, 4343, 4318, 4316, 4802, 4274, 4786, 4285, 4287, 4781, 4792, 4302, 4789, 4288, 4795, 4293, 4282, 4796, 4300, 4800, 4801, 4301, 4803, 4308, 4805, 4313, 4788, 4342, 4791, 4345, 4331, 4306, 4292, 4279, 4787, 3663, 3661, 3662, 5621, 3664, 445, 5314, 2121, 465, 494, 2190, 3963, 5316, 488, 455, 5302, 2097, 486, 463, 2101, 5306, 467, 2110, 5305, 530, 490, 473, 482, 5017, 5018, 5019, 5309, 5020, 5021, 5311, 443, 2106, 5307, 441, 2114, 5312, 524, 459, 461, 477, 475, 2125, 3957, 5315, 484, 492, 5313, 2117, 449, 5318, 447, 2186, 469, 471, 5012, 5013, 5022, 5319, 511, 515, 451, 2200, 5320, 496, 4930, 507, 500, 2208, 5322, 513, 498, 2204, 4932, 5324, 2213, 3248, 5940, 480, 5014, 5325, 5015, 5016, 453, 2195, 5317, 1674, 5267, 1672, 2996, 5268, 1684, 2999, 1670, 1682, 2998, 3003, 1702, 5272, 1699, 1658, 2993, 1691, 5270, 5288, 1679, 2989, 1686, 3000, 5274, 1695, 3001, 5278, 1676, 4937, 5273, 1655, 2992, 1660, 2994, 1653, 2991, 5279, 1677, 2997, 5276, 1649, 1651, 4944, 5284, 1662, 5281, 1688, 1697, 3002, 5280, 1646, 2988, 5282, 2990, 1668, 2995, 5285, 5567, 3712, 5548, 5465, 3745, 5462, 3739, 4038, 3732, 4044, 5534, 3734, 5530, 5536, 3731, 4048, 5532, 3722, 3723, 4046, 5531, 5479, 3730, 4043, 3721, 4045, 3719, 3726, 5546, 4057, 3711, 5538, 5560, 4059, 3709, 5543, 5555, 4058, 3710, 5541, 3714, 3716, 3744, 4039, 5472, 3740, 4041, 5470, 3708, 4040, 3733, 4049, 5475, 3746, 4042, 3729, 3738, 4056, 5533, 5551, 3742, 5467, 3743, 3736, 3737, 3735, 5557, 3727, 5542, 5563, 3728, 3718, 5564, 3717, 5545, 3720, 3741, 5539, 3747, 3713, 3724, 5535, 3074, 3052, 1826, 2940, 5297, 1818, 2939, 1806, 2935, 1813, 2938, 5296, 2936, 1829, 5292, 2941, 5293, 1825, 1809, 1830, 2937, 5298, 1817, 1822, 1810, 1819, 2932, 5291, 1814, 3075, 1873, 1081, 5117, 1180, 1050, 2447, 5088, 1056, 1115, 2463, 4953, 5092, 1068, 2466, 4954, 5090, 1169, 1064, 2436, 5085, 1070, 1191, 1185, 1126, 2441, 5087, 1066, 2450, 5089, 1174, 1076, 1136, 2469, 5094, 2513, 1183, 5120, 1163, 2486, 5100, 1187, 5114, 1084, 2511, 5115, 1153, 1178, 2506, 1123, 2502, 5108, 1062, 2519, 5119, 1098, 2515, 5118, 1156, 2497, 5107, 1033, 2488, 5102, 1039, 1052, 1088, 1148, 2491, 5101, 1058, 2504, 5111, 1112, 2499, 5112, 1120, 1151, 2517, 5122, 1060, 2484, 5099, 1096, 1130, 2508, 5113, 1091, 2523, 5124, 1072, 1074, 2455, 5091, 1107, 1139, 2457, 5093, 1093, 2474, 5095, 1104, 1189, 1046, 1047, 2478, 4956, 5096, 1101, 1166, 1118, 2476, 1176, 2493, 1159, 2482, 5104, 1109, 2480, 5097, 1142, 2495, 5106, 3261, 6034, 6036, 1194, 2521, 5126, 502, 3067, 1853, 5792, 1855, 5794, 1852, 2943, 5791, 1856, 5793, 1857, 1851, 1918, 2986, 1917, 2985)
ORDER BY t.name ASC

AND THIS TOO

SELECT post_id, meta_key, meta_value
FROM bti_postmeta
WHERE post_id IN (3154,3436,3395,3388,4109,5263,3512,3598,3606,3620,3576,3197,4178,4171,5202,4291,4289,6040,6041,6032,4032,5781,3679,3699,4010,5786,3698,3696,5787,3691,3688,5770,3682,4019,3689,4022,5774,3684,5777,3683,3673,4028,5779,3700,4008,5785,3680,4021,3678,4023,5775,3670,4015,3701,5766,3685,4014,5769,3671,4017,5772,3687,4020,5773,3675,5778,3672,4025,5776,3677,3694,4009,3272,3686,4034,5782,3674,4030,5780,3676,4035,5783,3690,4016,5771,3693,5767,3697,4011,5764,5789,3692,4012,5765,3268,3269,3270,3271,3695,4013,5768,3681,4027,1965,1983,1973,1978,1982,1979,1963,1966,1971,1969,1974,1981,1977,1967,1976,1975,1968,1754,4935,1753,2927,5185,5186,5184,1752,5188,1749,1757,1758,2928,3072,3165,3166,3169,3170,3151,3152,3153,5844,3155,3156,3161,3162,5846,3142,3134,3141,5841,3147,3148,5845,3130,3143,3144,5842,3149,3150,5843,3145,3146,3157,3158,5847,3159,3160,3163,3164,5848,3173,3174,3167,3168,3171,3172,623,625,617,3095,3096,631,633,638,629,646,2267,5885,656,658,662,660,3100,3101,3109,5893,650,2276,2263,640,5882,3097,2272,5890,3102,3103,635,648,2280,642,5899,3105,3106,644,2283,654,652,5902,614,621,582,3441,5521,3427,3889,5500,3428,3890,5501,5528,3887,5499,3430,3893,5503,3439,3891,5504,3438,619,3888,5502,3425,3896,5507,3431,3892,5505,3426,3442,3900,5515,3432,3895,5506,3899,5513,3894,5508,5525,3433,3897,5509,3435,3898,5511,3434,3440,3901,5517,3437,3902,5519,1277,3858,3414,3394,3878,3063,3378,3876,5580,3417,3863,5559,3415,5558,3381,3862,5556,3371,3420,3861,5554,3423,3868,3374,5588,3391,3879,5581,3112,3113,3115,3118,3122,3127,3123,3117,3114,3094,5850,3108,3126,3116,3121,3129,3098,3419,3884,3387,3877,5579,3402,5591,5574,3385,5587,3409,3883,5592,3400,3871,5573,3404,3865,5562,3392,3367,3850,5439,3366,3849,5438,3418,3852,3403,3856,5553,3424,3421,3422,3401,3869,5568,5577,5594,3376,3406,3866,5570,3386,5584,3390,3379,3875,3389,3384,5578,3874,3380,5576,3372,5585,5590,3373,3881,5586,3375,5582,3882,5589,3377,3370,3880,5583,3363,3872,5572,3393,3853,5415,5440,3368,3857,5445,3365,3851,5443,3399,3369,3870,5571,3364,3864,5565,3398,3405,3413,3855,5444,3410,3859,5442,3407,3408,3397,3396,3860,882,4943,2925,886,4945,5131,5228,884,5128,5129,1871,2945,6042,1872,1886,3076,3077,867,2325,5000,5073,869,868,2333,5080,874,863,2327,5076,861,2331,5083,864,854,858,856,2329,5078,871,2335,5082,1885,2947,6025,1888,6027,1887,6026,1889,1884,2950,6033,1883,2948,6028,1893,2949,6029,1880,6035,1882,6038,1890,6030,4099,4619,4094,4096,4641,4646,4065,4069,4079,4632,4635,4630,4064,4631,4073,4633,4093,4657,4090,4658,3782,3783,4067,4066,4071,4643,4640,4639,4113,3787,4645,4068,4089,4081,4647,4091,4655,4092,4656,4074,4095,4642,4087,4650,4644,4080,4078,4653,4651,4082,4652,4085,4654,4627,4103,4105,4111,4620,4070,4617,3784,4075,4108,4106,4618,4107,4648,3786,4072,4616,4112,4628,4101,4098,4621,4100,4625,4076,4629,4637,4623,4102,4104,4626,4114,3313,3350,3328,3844,5243,3060,3343,5345,3831,3317,3835,3348,3841,5385,3345,3303,3349,5260,5359,3353,3813,3292,3812,3300,3352,3824,3331,5241,3358,3794,5237,3347,3792,5269,3287,3816,3833,3301,3818,5300,3297,3335,3296,3843,3299,5254,5340,5258,3290,3803,3808,3307,3830,5366,3293,3288,3838,5239,3793,3359,3346,3305,3315,5283,3354,3822,3329,3344,3351,5265,5303,5294,3362,3356,3825,3284,3823,3330,3323,3840,5353,3360,3832,3302,3316,3842,3295,3336,3839,3361,3068,3069,3795,3289,3219,3220,5931,3221,3222,5933,3235,3236,5937,3229,3230,5938,3225,3226,5934,3227,3228,5935,3223,3224,5936,5236,3325,3791,3312,5245,3304,5362,3294,5247,5256,3285,3797,3283,3806,5308,5377,3286,3827,3282,5332,3291,3819,5249,5336,5251,5275,3327,3800,3829,3355,3338,3801,3357,5371,5389,5350,5374,5387,3337,3828,3298,3306,3836,3324,3814,3340,3309,3834,3311,3326,3339,3310,4394,4409,4397,4851,4406,4379,4852,4381,4858,4407,4386,4380,4855,4399,4378,4857,4408,4850,4398,4847,4382,4388,4863,4403,4404,4400,4401,4860,4396,4848,4391,4845,4846,4395,4392,4410,4411,4385,4377,4849,4405,4853,4393,4383,4384,4861,4402,4862,3073,3049,947,2362,898,2387,928,2370,938,2391,907,2432,931,950,901,2381,904,1026,954,2351,915,2373,921,2337,923,918,2339,893,2354,896,945,935,2345,942,2343,912,2347,895,2349,2341,925,910,537,2264,5474,557,5469,553,2271,800,798,565,796,3104,3099,5851,1916,3062,2064,3064,5983,2003,3039,3051,2054,3053,5976,2037,3047,5971,1994,3058,5980,2045,3056,5979,2027,3055,5978,2047,3061,5982,2058,3042,5967,2042,3050,5972,2056,3034,5963,2013,3033,5962,1997,5959,2052,3037,5965,2019,3036,5964,2039,5975,2029,5973,2017,3045,5969,2066,3054,5977,2062,3065,2060,2032,5974,2007,3031,5960,2050,3032,5961,2009,3041,5966,2035,3046,5970,2015,3043,5968,2000,5981,3552,3915,5687,3550,3907,5671,3496,5675,3465,5696,3517,3927,5704,3471,3940,5714,3522,5688,3926,5703,3447,3458,3910,5677,3541,3468,3950,5741,3464,3943,5721,3479,3947,5737,3485,3453,3939,5711,3455,3920,5691,3467,5702,3448,3923,5700,3450,5709,3443,3948,5738,3492,5694,3444,3445,5681,3491,3919,5690,5760,3495,3921,5693,3494,3918,5689,3544,5674,3545,5683,3482,3917,3487,3911,5680,3546,3912,5697,3454,3511,3519,3504,3908,5673,3942,5718,3909,5676,3483,5684,3549,5672,3489,3462,3916,3460,5685,3477,3913,5682,3528,5736,3475,5716,3520,5735,3490,5707,3542,3446,3451,3459,3493,3449,3536,3501,5754,3484,3955,5747,3539,3958,5752,3540,5755,3547,3960,5757,3497,3959,5753,3474,5751,3548,5743,3553,3521,5750,3537,5719,3523,5740,3481,5744,3470,5742,3500,5678,3463,3938,5710,3538,5695,3472,5713,3480,3941,5717,3466,3944,5722,3461,3469,3956,5748,3457,3951,5745,3525,3922,5699,3532,5698,3524,5692,3914,3551,5686,3518,5720,3526,3945,3473,5706,3533,3924,5701,3543,3531,5739,3527,3478,3476,3949,3488,5734,3508,3486,3530,5708,3534,3954,5746,3505,3928,5705,3529,5749,1573,5404,289,321,297,311,1993,5405,370,2217,5421,398,307,317,2011,5411,573,2243,5427,574,400,2239,5426,555,2233,5424,293,2034,2031,5419,299,2227,5423,303,362,2236,5425,546,2041,382,1999,567,2220,376,5422,313,2252,3382,5431,550,323,2255,5432,390,563,559,2248,366,5510,1428,2546,1433,1436,2542,1417,2548,2540,4538,4540,1429,1434,2552,2534,1438,2528,1440,2532,1432,1437,1441,1415,2544,1419,2550,4531,4564,4569,1431,1430,2536,1439,2538,3202,5920,5921,3210,3204,5919,1860,1834,2963,6003,1854,2965,6006,1862,1843,2968,6008,1755,2973,6012,1747,1741,2974,6013,1764,1831,2978,6016,1738,2980,6019,1815,1836,2972,6011,1744,2979,6017,2969,1734,2976,6014,1859,1876,2964,6005,1849,1864,2962,6002,1847,1790,6004,1762,2977,6015,1768,1766,6009,1777,2967,6007,1760,1750,2971,6010,1845,2956,5998,1807,1891,2958,5999,3209,1782,1785,1820,3214,3215,3206,3207,5923,3208,5925,3212,5922,3211,3203,3213,3205,3217,3218,5924,1798,2959,1811,2957,1827,1794,1796,1874,6001,1823,2960,6000,3044,1513,1580,2786,4955,5139,1454,2828,4984,5153,1460,1527,1618,2874,5173,1591,2870,5168,2876,1455,1482,1628,2868,4998,5167,1632,5176,1586,2854,1636,1450,2872,4999,5175,1452,1480,2862,5170,1485,1514,1538,2878,5001,5177,1626,1521,1457,1592,2846,1537,2850,1603,2858,5169,1502,2842,4988,5164,1617,2864,5172,1489,2880,1473,2834,5158,1490,1645,2848,4990,4991,5160,1523,1458,1498,2866,4996,5165,1530,1467,1469,2824,5149,1471,2822,4981,5150,1456,1462,2838,4986,4987,5155,1477,1598,1597,2830,5154,1585,1595,2826,4983,5151,1509,2832,4985,5157,1543,1634,2836,5161,1620,2860,5159,1629,1639,2844,1635,1642,2840,1631,2852,1630,1621,2798,1554,1625,2790,1495,2820,1627,2812,5145,2816,1581,1470,2792,5137,1599,1644,2808,1506,2788,5143,1464,1616,2776,5135,1602,2778,5134,4951,1465,2780,5136,4952,1539,2784,1531,1619,2804,4965,4966,5144,1468,1475,2818,5148,1487,1596,2802,4964,5146,1478,1505,2814,1491,1547,2796,4957,5140,1484,2782,5141,5180,1552,2800,4959,5138,1474,2810,5142,1534,1641,2794,1622,1624,4980,5147,1623,1500,2806,1407,1338,1365,2650,1391,2660,1403,2717,1408,1411,2697,1371,1422,1423,1358,1359,1375,2724,1414,1418,2733,1366,1367,2742,3279,1390,2735,1341,1345,2653,1328,2672,1401,2685,1378,1379,2682,1374,2668,1393,1395,2689,1342,1353,2731,1376,2679,1373,2691,1309,1315,2628,1301,2604,1425,1426,2622,1350,2610,1382,1424,1421,2616,1355,1356,2613,1385,2633,1384,1398,1409,1383,2729,1405,1340,2702,1363,2758,2739,2755,1362,1380,2676,1233,1267,1231,1237,1402,2709,1319,1321,2725,1400,1404,2705,1420,1410,1229,1336,1399,1413,2640,1343,1351,2644,1357,1364,2658,1245,1254,1311,1324,1333,2636,1372,2665,3277,3278,1293,1265,1326,2620,1377,1396,2625,1381,1394,1347,2772,1368,1239,1360,1370,2770,1348,1352,1386,2721,1296,1361,2762,1273,1280,1389,2753,1397,1416,2766,1235,1305,2746,1249,2750,1369,2764,1286,2774,1387,2760,1388,1392,2713,1323,2768,4556,4552,4550,4903,4554,4549,4551,1302,2882,1503,2885,1297,2886,1528,1610,2884,1511,2889,1307,2883,1589,1600,2897,3276,1565,2894,1545,2898,1558,2896,3274,3275,1569,2900,1497,2901,1551,1518,2902,1583,1593,2903,1283,2905,1604,2907,1612,2911,1561,2906,1556,2908,1493,2909,1275,2912,1525,2910,1606,2913,1608,1614,2914,1271,2920,1549,2916,1571,2918,1268,2917,1263,2915,3273,1312,1532,2890,1563,2891,1317,2895,1507,1541,2888,1290,2919,1516,2893,1535,3189,3190,5989,735,2287,3186,5993,740,2289,771,2293,779,772,737,2291,774,3181,3182,5991,3177,3178,5992,786,2295,3184,3185,5994,776,747,2297,773,769,770,2307,3580,3967,5600,3651,5610,3554,3563,3639,3566,3640,3649,5598,3570,5648,3643,5629,3594,3983,5624,3632,3975,5608,3599,5618,3557,3995,5652,3577,5636,3593,5630,5641,3571,3560,3977,5611,3617,3978,5612,3579,3987,5633,3556,3981,5617,3558,5643,3635,3984,5626,3597,5632,3567,5646,3562,3990,5637,3601,3996,5654,3555,3578,5604,3616,3968,5601,3611,3966,3645,5597,3569,3971,5603,3618,3974,5607,3565,3642,5616,3641,3979,5613,3604,3976,5609,3603,3980,5615,3982,5623,3614,5625,3175,3176,5990,3183,3559,3965,5596,3595,3994,5650,3988,5634,3627,3989,5635,3615,3972,5605,3650,5599,3628,3573,3631,3973,5606,3633,3654,3969,5602,3608,5614,3582,3998,3575,5655,3622,3634,3572,5658,3602,790,763,736,2321,734,2309,1920,4276,3592,3986,5631,752,2301,732,733,2299,783,2303,755,2311,775,780,2313,791,743,2317,2305,766,748,2315,749,3629,3652,5620,3609,4000,5659,3610,5651,3619,3644,5647,3605,5660,3993,3613,5668,762,767,2319,5321,789,2323,768,3612,5667,3626,4004,5669,3187,3188,5996,3596,4003,5663,5664,3179,3180,5995,3591,3991,5638,3623,3997,5656,3581,5666,3564,3590,3589,3985,5627,3561,5649,3574,3992,5645,3588,3607,3624,3999,5657,3568,4001,5661,3621,5665,3638,4002,5662,571,2219,5453,569,576,2360,5473,723,2268,5471,528,540,2259,781,2376,2380,5482,544,702,2364,700,5478,5477,760,704,712,718,2366,787,548,2372,777,710,741,2226,5458,758,793,2230,5459,2251,5464,578,535,708,745,750,2256,5466,561,2261,5468,526,756,5457,764,721,2223,5454,715,738,2235,753,2242,5460,784,532,542,2246,5461,52,1781,1787,1771,1775,2930,1776,1772,1788,1780,1779,1784,1911,1222,986,1010,2608,5859,1078,2602,1083,2637,5864,1155,3013,5896,933,934,1019,2632,5863,1132,5873,906,2581,5856,941,2440,5825,1111,2562,985,2462,1000,2572,5853,1100,980,2458,5827,1020,5828,1015,2577,5854,892,2580,5855,878,889,2568,5829,1017,1032,2468,1141,2605,5858,998,1125,2593,5857,1025,1043,1143,2612,5860,914,2710,5884,930,1038,1011,3016,5898,846,847,2706,5883,903,3024,5913,1106,5912,1909,2954,5803,996,3022,5910,2687,900,5875,976,1009,839,837,838,841,840,842,843,2736,5888,987,5881,1165,3014,5897,850,2700,5879,1086,1158,1161,2693,5876,1023,2664,5870,974,2646,5866,1114,1117,2642,5865,1145,2696,5877,5917,981,3027,1031,5906,957,958,3017,5901,876,2655,5868,944,2681,5874,978,5916,920,3026,909,1041,3018,851,2719,5887,1007,3021,5907,1022,2675,5872,982,2669,5871,3199,3200,5915,1018,3025,999,1028,1146,2741,5889,988,1138,2715,5886,989,5909,1037,1150,2452,5826,1029,3023,5911,5928,3198,3191,3192,5930,3193,3194,3196,5927,5929,3195,949,2438,5823,1005,1103,5903,845,2649,5867,1171,1910,2744,5892,3201,940,2410,1168,2627,5862,2661,852,866,877,927,5869,844,848,853,937,1006,1044,1129,2618,5861,997,2402,5810,1035,2389,5805,991,993,994,2400,5809,1003,1090,2396,5807,873,2398,5808,1021,2404,992,2394,5806,984,2418,5815,1024,2408,5812,952,2406,5811,1001,2412,5814,1012,1122,1134,2422,2428,5817,5820,1095,2430,5821,1004,2420,5816,879,2414,917,2426,5819,983,2416,888,2433,5822,990,2424,5818,1014,2446,71,62,65,73,5496,5497,3763,3766,3765,3764,3761,3759,3760,1907,5797,1908,5801,1903,5802,1905,2953,5800,1901,2952,5799,1906,5796,1900,5798,4700,4252,4255,4713,4690,4242,4223,4135,4662,4225,4673,4118,4671,4136,4147,4687,4141,4692,4145,4694,4670,4237,4577,4661,4665,4219,4140,4663,4222,4666,4236,4676,4143,4667,4226,4668,4239,4669,4233,4679,4229,4683,4224,4693,4688,4238,4234,4691,4156,4714,4205,4752,4139,4697,4201,4695,4202,4720,4203,4716,4721,4193,4194,4739,4736,4115,4702,4155,4698,4256,4719,4146,4735,4176,4717,4123,4710,4144,4733,4199,4757,4122,4704,4179,4718,4723,4166,4121,4715,4148,4743,4163,4744,4742,4137,4737,4741,4157,4746,4169,4748,4159,4753,4162,4754,4142,4747,4154,4160,4750,4158,4755,4200,4756,4149,4745,4660,4134,79,2072,5328,186,95,2073,4830,5329,222,339,83,2075,5330,107,219,120,91,4838,5334,205,203,217,151,4905,5331,2086,126,5347,425,77,2078,5335,192,210,211,100,2081,5339,250,354,112,141,2094,5354,275,2122,5370,372,145,2090,5344,268,114,2079,5338,285,135,2096,378,118,2084,5341,358,406,116,207,2087,5342,435,240,343,98,2089,5349,404,384,262,258,2092,5351,429,413,89,2194,5380,282,246,4915,4916,5383,87,2118,4865,5358,164,109,190,93,2182,5372,149,160,168,2115,102,5356,139,172,254,5376,415,2188,437,104,2191,5379,417,423,291,348,2126,85,2180,5367,244,156,137,224,5365,419,421,394,4867,4884,4887,4889,5382,427,2198,5381,431,4912,81,2095,5357,215,213,176,350,2201,5361,433,439,4908,4910,5364,130,5369,388,233,2184,4521,4518,4534,4892,4527,4894,4536,4893,4535,4514,4525,4533,4520,4511,4898,4510,4897,4523,4530,4528,4512,4885,4513,4896,4522,4524,4532,4515,4891,4516,4888,4529,4519,1937,1947,3007,5985,1935,1949,3009,1945,1950,1940,1942,3005,5987,1931,3010,5986,1943,1957,1952,1938,1933,1953,1961,3008,1955,3006,1959,4359,4809,4365,4373,4367,4811,1295,2576,1248,2599,1282,2558,1261,2554,1285,2556,1258,2560,4364,4376,4837,4372,4826,4375,4829,4371,4833,4374,4366,4369,4836,4352,4832,4351,4828,4370,4825,4354,4361,4827,4358,4356,4355,4810,1252,2583,1247,2569,1279,2587,1289,2589,1255,1287,2592,1242,2596,4368,1291,2573,1250,2585,1253,1262,2563,1257,2565,4413,4503,4500,4877,4504,4502,4499,4876,4506,4875,4505,4415,4880,4498,4874,4509,4871,4507,4872,4508,4414,4870,4501,4416,4868,1221,1915,4272,2984,4547,4545,346,2132,5207,4749,4751,325,335,2145,147,235,2143,4725,5215,333,158,231,2160,5219,309,319,4731,5218,162,264,2149,5216,337,2166,519,287,331,2177,5231,270,315,2168,5224,521,129,133,226,2134,5213,4760,4761,5211,327,329,2162,5222,184,248,280,2170,5226,182,256,2154,5220,260,2158,5225,188,294,301,2175,5229,143,229,2120,5204,266,305,2109,5203,356,360,2137,5214,5943,3245,3133,368,402,2156,3237,5221,5944,3244,5946,3242,5948,5217,374,380,3240,5947,2151,392,396,2164,3241,5223,5950,386,517,2172,3243,5227,5951,166,242,2129,5210,174,170,200,201,252,2091,5195,179,2102,5196,5233,4766,4768,4548,153,238,2147,4727,3758,5762,3753,3757,352,2139,341,4541,4901,4542,4900,4544,4902,4537,4546,3057,4321,4322,4304,4798,4284,4295,4297,4799,4290,4793,4283,4794,4330,4797,4341,4298,4804,4324,4340,4326,4262,4775,4271,4774,4273,4257,4783,4269,4780,4348,4264,4764,4261,4767,4277,4268,4776,4267,4773,4275,4769,4266,4772,4263,4765,4329,4327,4265,4779,4311,4782,4280,4310,4790,4305,4784,4270,4777,4347,4314,4778,4320,4785,4343,4318,4316,4802,4274,4786,4285,4287,4781,4792,4302,4789,4288,4795,4293,4282,4796,4300,4800,4801,4301,4803,4308,4805,4313,4788,4342,4791,4345,4331,4306,4292,4279,4787,3663,3661,3662,5621,3664,445,5314,2121,465,494,2190,3963,5316,488,455,5302,2097,486,463,2101,5306,467,2110,5305,530,490,473,482,5017,5018,5019,5309,5020,5021,5311,443,2106,5307,441,2114,5312,524,459,461,477,475,2125,3957,5315,484,492,5313,2117,449,5318,447,2186,469,471,5012,5013,5022,5319,511,515,451,2200,5320,496,4930,507,500,2208,5322,513,498,2204,4932,5324,2213,3248,5940,480,5014,5325,5015,5016,453,2195,5317,1674,5267,1672,2996,5268,1684,2999,1670,1682,2998,3003,1702,5272,1699,1658,2993,1691,5270,5288,1679,2989,1686,3000,5274,1695,3001,5278,1676,4937,5273,1655,2992,1660,2994,1653,2991,5279,1677,2997,5276,1649,1651,4944,5284,1662,5281,1688,1697,3002,5280,1646,2988,5282,2990,1668,2995,5285,5567,3712,5548,5465,3745,5462,3739,4038,3732,4044,5534,3734,5530,5536,3731,4048,5532,3722,3723,4046,5531,5479,3730,4043,3721,4045,3719,3726,5546,4057,3711,5538,5560,4059,3709,5543,5555,4058,3710,5541,3714,3716,3744,4039,5472,3740,4041,5470,3708,4040,3733,4049,5475,3746,4042,3729,3738,4056,5533,5551,3742,5467,3743,3736,3737,3735,5557,3727,5542,5563,3728,3718,5564,3717,5545,3720,3741,5539,3747,3713,3724,5535,3074,3052,1826,2940,5297,1818,2939,1806,2935,1813,2938,5296,2936,1829,5292,2941,5293,1825,1809,1830,2937,5298,1817,1822,1810,1819,2932,5291,1814,3075,1873,1081,5117,1180,1050,2447,5088,1056,1115,2463,4953,5092,1068,2466,4954,5090,1169,1064,2436,5085,1070,1191,1185,1126,2441,5087,1066,2450,5089,1174,1076,1136,2469,5094,2513,1183,5120,1163,2486,5100,1187,5114,1084,2511,5115,1153,1178,2506,1123,2502,5108,1062,2519,5119,1098,2515,5118,1156,2497,5107,1033,2488,5102,1039,1052,1088,1148,2491,5101,1058,2504,5111,1112,2499,5112,1120,1151,2517,5122,1060,2484,5099,1096,1130,2508,5113,1091,2523,5124,1072,1074,2455,5091,1107,1139,2457,5093,1093,2474,5095,1104,1189,1046,1047,2478,4956,5096,1101,1166,1118,2476,1176,2493,1159,2482,5104,1109,2480,5097,1142,2495,5106,3261,6034,6036,1194,2521,5126,502,3067,1853,5792,1855,5794,1852,2943,5791,1856,5793,1857,1851,1918,2986,1917,2985)
ORDER BY meta_id ASC

Also attached a screenshot of queries for you to check.. It would be great if you could help me

https://s13.postimg.org/c3pltwtnb/screenshot.jpg

Thanks

Did you get a chance to look into this? Waiting ??

Hi tooocool,

Apologies, I’ve been away for a few days.

This appears to be a WordPress query which would be common to all CPT list screens. I can’t do a lot to help with the performance of this as it’s core code.

One thing you could try is removing the categories from the list under Screen Options. I’m unsure if this will remove it from the query, but it’s certainly worth a try!

Cheers,
Josh

I removed all the options under ‘Screen Options’ and even reduced the ‘Affiliate links’ to 10. It isn’t making any difference. Memory usage is still 110MB. I deactivated all other plugins, memory drops to 103MB, which is still on the higher side.

What I find strange is, I have thousands of posts, but the memory usage is around 39MB of the page which lists the posts. Affiliate I have around 3500, and it goes to 110MB.

If I add more affiliate links, the memory usage is constantly increasing.

Are you absolutely sure there is nothing you can do with the code?

Adding this to my Theme Functions helped me tremendously.. Dropped my memory usage from 110MB down to 91MB.

add_filter( 'posts_results', 'cache_meta_data', 9999, 2 );
function cache_meta_data( $posts, $object ) {
    $posts_to_cache = array();
    // this usually makes only sense when we have a bunch of posts
    if ( empty( $posts ) || is_wp_error( $posts ) || is_single() || is_page() || count( $posts ) < 3 )
        return $posts;

    foreach( $posts as $post ) {
        if ( isset( $post->ID ) && isset( $post->post_type ) ) {
            $posts_to_cache[$post->ID] = 1;
        }
    }

    if ( empty( $posts_to_cache ) )
        return $posts;

    update_meta_cache( 'post', array_keys( $posts_to_cache ) );
    unset( $posts_to_cache );

    return $posts;
}

Hi tooocool,

What are you using for detecting your memory usage? Query Monitor?

I just loaded up 1500+ links into a vanilla install and it takes about 45-50mb.

This is within expected I think based on the performance I see with things like WooCommerce products.

2000+ links was about 52mb

3500+ links brings it up to around 60-80mb for me…

I agree that the query is inefficient, but I guess thats what happens when you introduce taxonomies into the equation. The extra table joins throw a spanner in the works.

Personally I would have thought removing the taxonomy from the screen options would remove the need to have it in the query but it seems that isn’t taken into consideration.

Based on these performance figures I believe other post types would scale up similarly so I’m not sure there’s much we can do here.

You’re welcome to raise a core WP ticket to see if something can be done but from a plugin’s perspective I don’t have a lot of control over this query. Hope you understand.

Other things you can do in the meantime might be to ensure you’re on the latest PHP and MySQL versions and see if that makes a difference.

Cheers,
Josh