USE plwiki_p;

​

SELECT * from user_properties 

where up_property = 'gender' 

AND up_user IN

(3, 4, 6, 7, 8, 10, 17, 22, 24, 31, 64, 113, 149, 226, 274, 458, 500, 511, 570, 573, 

770, 859, 909, 997, 1091, 1359, 1456, 1984, 2081, 2170, 2895, 3131, 3162, 3265, 3654, 

3684, 4248, 4829, 4912, 5285, 5466, 5505, 5584, 6115, 6200, 6468, 6479, 6688, 6699, 

6748, 6777, 6822, 6834, 6842, 6876, 6931, 6970, 7507, 7513, 7878, 7898, 7927, 7964, 

7966, 8089, 8203, 8496, 8715, 8896, 8961, 9148, 9780, 9839, 10027, 10387, 10491, 10721, 

10732, 10966, 11018, 11143, 11315, 11369, 11691, 11732, 11741, 12626, 12752, 12881, 

13128, 13174, 13592, 13707, 13710, 13721, 13977, 14153, 14689, 14825, 15191, 16028, 

16268, 16271, 16301, 16334, 16457, 16515, 16684, 16748, 16844, 17280, 17612, 17714, 

18418, 18463, 18831, 19529, 19627, 19867, 19873, 19899, 20024, 21058, 21246, 21266, 

21421, 21428, 21450, 21512, 22730, 22861, 22987, 24065, 24355, 24837, 25584, 28432, 

28535, 29531, 29533, 29874, 30588, 32955, 34372, 35772, 35791, 36345, 36630, 39893, 

42573, 44424, 44574, 47024, 48328, 51436, 52288, 52384, 52501, 53699, 54448, 55049, 

56131, 57384, 57957, 58808, 60242, 60639, 60755, 60892, 63683, 66274, 66882, 68885, 

70424, 70825, 72708, 74466, 74503, 77940, 80136, 80249, 82204, 83102, 84848, 89600, 

89912, 97905, 100126, 107033, 107193, 107206, 107289, 108756, 109190, 109455, 115489, 

121254, 122624, 124892, 125486, 125775, 128492, 137604, 139824, 156342, 160850, 174889, 

179096, 179389, 181914, 185362, 187106, 193408, 198721, 200423, 201113, 203550, 203640, 

207712, 212126, 213633, 219980, 239189, 243628, 253565, 256110, 260309, 264979, 266502, 

273783, 298932, 299309, 307798, 327902, 328005, 328943, 331862, 335673, 357169, 368203, 

420501, 432759, 434263, 438997, 467845, 471642, 478968, 484254, 490013, 501569, 510594, 

603848, 607705, 664315, 802669, 802759

)