mysql> SELECT @r := @r+1 , z.* FROM( SELECT fam_id, count(*) AS famcount FROM family GROUP BY fam_id ORDER BY famcount DESC )z, (SELECT @r:=0)y; +------------+--------+----------+ | @r := @r+1 | fam_id | famcount | +------------+--------+----------+ | 1 | 7072 | 3 | | 2 | 101 | 3 | | 3 | 70433 | 3 | | 4 | 7045 | 2 | | 5 | 7022 | 2 | | 6 | 70721 | 2 | | 7 | 3043 | 2 | | 8 | 70512 | 2 | | 9 | 25 | 2 | | 10 | 7043 | 2 | | 11 | 11 | 1 | | 12 | 104 | 1 | | 13 | 208 | 1 | | 14 | 607 | 1 | | 15 | 705 | 1 | | 16 | 4044 | 1 | | 17 | 40431 | 1 | | 18 | 40452 | 1 | | 19 | 1012 | 1 | | 20 | 3044 | 1 | | 21 | 2091 | 1 | | 22 | 309 | 1 | | 23 | 2081 | 1 | | 24 | 3081 | 1 | | 25 | 308 | 1 | | 26 | 6011 | 1 | | 27 | 602 | 1 | | 28 | 608 | 1 | | 29 | 6 | 1 | | 30 | 10 | 1 | | 31 | 3045 | 1 | | 32 | 209 | 1 | | 33 | 7071 | 1 | | 34 | 70a | 1 | | 35 | 7033 | 1 | | 36 | 7044 | 1 | | 37 | 40511 | 1 | | 38 | 4 | 1 | | 39 | 206 | 1 | | 40 | 40322 | 1 | | 41 | 40312 | 1 | | 42 | 403112 | 1 | | 43 | 403132 | 1 | | 44 | 24 | 1 | | 45 | 63 | 1 | | 46 | 30048 | 1 | | 47 | 70741 | 1 | | 48 | 26 | 1 | | 49 | 57 | 1 | | 50 | 70a1 | 1 | | 51 | 7026 | 1 | | 52 | 70221 | 1 | | 53 | 7091 | 1 | | 54 | 7095 | 1 | | 55 | 7099 | 1 | | 56 | 709d | 1 | | 57 | 17 | 1 | | 58 | 2013 | 1 | | 59 | 20121 | 1 | | 60 | 70344 | 1 | | 61 | 704231 | 1 | | 62 | 6082 | 1 | | 63 | 23 | 1 | | 64 | 45 | 1 | | 65 | 41 | 1 | | 66 | 105 | 1 | | 67 | 14 | 1 | | 68 | 702 | 1 | | 69 | 709 | 1 | | 70 | 40421 | 1 | | 71 | 404312 | 1 | | 72 | 40453 | 1 | | 73 | 102 | 1 | | 74 | 1043 | 1 | | 75 | 2092 | 1 | | 76 | 3092 | 1 | | 77 | 20811 | 1 | | 78 | 3091 | 1 | | 79 | 403 | 1 | | 80 | 6013 | 1 | | 81 | 708 | 1 | | 82 | 605 | 1 | | 83 | 2 | 1 | | 84 | 7 | 1 | | 85 | 1 | 1 | | 86 | 207 | 1 | | 87 | 3071 | 1 | | 88 | 7051 | 1 | | 89 | 7031 | 1 | | 90 | 7041 | 1 | | 91 | 601 | 1 | | 92 | 40451 | 1 | | 93 | 28 | 1 | | 94 | 2051 | 1 | | 95 | 40321 | 1 | | 96 | 40313 | 1 | | 97 | 403113 | 1 | | 98 | 403141 | 1 | | 99 | 60 | 1 | | 100 | 30 | 1 | | 101 | 70731 | 1 | | 102 | 70742 | 1 | | 103 | 52 | 1 | | 104 | 58 | 1 | | 105 | 70a11 | 1 | | 106 | 203 | 1 | | 107 | 70231 | 1 | | 108 | 7092 | 1 | | 109 | 7096 | 1 | | 110 | 709a | 1 | | 111 | 4032 | 1 | | 112 | 282 | 1 | | 113 | 2011 | 1 | | 114 | 20122 | 1 | | 115 | 70343 | 1 | | 116 | 20 | 1 | | 117 | 42 | 1 | | 118 | 46 | 1 | | 119 | 103 | 1 | | 120 | 15 | 1 | | 121 | 304 | 1 | | 122 | 703 | 1 | | 123 | 12 | 1 | | 124 | 40422 | 1 | | 125 | 404314 | 1 | | 126 | 405 | 1 | | 127 | 1022 | 1 | | 128 | 1044 | 1 | | 129 | 1011 | 1 | | 130 | 30441 | 1 | | 131 | 20812 | 1 | | 132 | 404 | 1 | | 133 | 706 | 1 | | 134 | 7081 | 1 | | 135 | 606 | 1 | | 136 | 3 | 1 | | 137 | 8 | 1 | | 138 | 3041 | 1 | | 139 | 2083 | 1 | | 140 | 7085 | 1 | | 141 | 7025 | 1 | | 142 | 7032 | 1 | | 143 | 70421 | 1 | | 144 | 70811 | 1 | | 145 | 404221 | 1 | | 146 | 20821 | 1 | | 147 | 201 | 1 | | 148 | 40323 | 1 | | 149 | 40314 | 1 | | 150 | 403114 | 1 | | 151 | 29 | 1 | | 152 | 61 | 1 | | 153 | 7073 | 1 | | 154 | 7061 | 1 | | 155 | 48 | 1 | | 156 | 2071 | 1 | | 157 | 7021 | 1 | | 158 | 60321 | 1 | | 159 | 70232 | 1 | | 160 | 7093 | 1 | | 161 | 7097 | 1 | | 162 | 709b | 1 | | 163 | 7086 | 1 | | 164 | 7034 | 1 | | 165 | 2012 | 1 | | 166 | 20511 | 1 | | 167 | 70831 | 1 | | 168 | 59 | 1 | | 169 | 21 | 1 | | 170 | 43 | 1 | | 171 | 47 | 1 | | 172 | 13 | 1 | | 173 | 202 | 1 | | 174 | 307 | 1 | | 175 | 704 | 1 | | 176 | 4042 | 1 | | 177 | 40423 | 1 | | 178 | 4045 | 1 | | 179 | 4051 | 1 | | 180 | 1041 | 1 | | 181 | 205 | 1 | | 182 | 3072 | 1 | | 183 | 1021 | 1 | | 184 | 3073 | 1 | | 185 | 20813 | 1 | | 186 | 4043 | 1 | | 187 | 707 | 1 | | 188 | 7082 | 1 | | 189 | 6061 | 1 | | 190 | 5 | 1 | | 191 | 9 | 1 | | 192 | 3042 | 1 | | 193 | 7083 | 1 | | 194 | 7074 | 1 | | 195 | 70511 | 1 | | 196 | 7028 | 1 | | 197 | 7042 | 1 | | 198 | 40512 | 1 | | 199 | 4031 | 1 | | 200 | 2082 | 1 | | 201 | 31 | 1 | | 202 | 40311 | 1 | | 203 | 403111 | 1 | | 204 | 403121 | 1 | | 205 | 27 | 1 | | 206 | 62 | 1 | | 207 | 3005 | 1 | | 208 | 70732 | 1 | | 209 | 70611 | 1 | | 210 | 56 | 1 | | 211 | 603 | 1 | | 212 | 7023 | 1 | | 213 | 6032 | 1 | | 214 | 70233 | 1 | | 215 | 7094 | 1 | | 216 | 7098 | 1 | | 217 | 709c | 1 | | 218 | 16 | 1 | | 219 | 70423 | 1 | | 220 | 2014 | 1 | | 221 | 20921 | 1 | | 222 | 70342 | 1 | | 223 | 70432 | 1 | | 224 | 22 | 1 | | 225 | 44 | 1 | | 226 | 40 | 1 | +------------+--------+----------+ 226 rows in set (0.06 sec) mysql> SELECT @r := @r+1 , -> z.* -> FROM( -> SELECT ind_id, -> count(*) AS fmcount -> FROM fam_member -> GROUP BY ind_id -> ORDER BY fmcount DESC -> )z, -> (SELECT @r:=0)y; +------------+-----------+---------+ | @r := @r+1 | ind_id | fmcount | +------------+-----------+---------+ | 1 | 44-1 | 2 | | 2 | 45-1 | 2 | | 3 | 30-1 | 2 | | 4 | 12-7 | 2 | | 5 | 70732-1 | 2 | | 6 | 709a-01 | 2 | | 7 | 201-4 | 1 | | 8 | 70512-01 | 1 | | 9 | 203b-2 | 1 | | 10 | 308-01 | 1 | | 11 | 608-1 | 1 | | 12 | 705-1 | 1 | | 13 | 1041-1 | 1 | | 14 | 2092-1 | 1 | | 15 | 4051-2 | 1 | | 16 | 7072-3 | 1 | | 17 | 7085-01 | 1 | | 18 | 40313-1 | 1 | | 19 | 22-9 | 1 | | 20 | 45-3 | 1 | | 21 | 4-5 | 1 | | 22 | 8-6 | 1 | | 23 | 15-1 | 1 | | 24 | 4043-1 | 1 | | 25 | 101-02 | 1 | | 26 | 206-6 | 1 | | 27 | 403114-01 | 1 | | 28 | 7043-01 | 1 | | 29 | 2071-01 | 1 | | 30 | 7026-01 | 1 | | 31 | 70231-1 | 1 | | 32 | 28-5 | 1 | | 33 | 20511-1 | 1 | | 34 | 307-2 | 1 | | 35 | 606-01 | 1 | | 36 | 706-01 | 1 | | 37 | 709-d | 1 | | 38 | 2092-01 | 1 | | 39 | 3091-01 | 1 | | 40 | 7034-5 | 1 | | 41 | 7081-2 | 1 | | 42 | 40321-2 | 1 | | 43 | 22-2 | 1 | | 44 | 44-4 | 1 | | 45 | 3-7 | 1 | | 46 | 16-1 | 1 | | 47 | 13-1 | 1 | | 48 | 40422-2 | 1 | | 49 | 40453-1 | 1 | | 50 | 205-2 | 1 | | 51 | 40323-01 | 1 | | 52 | 60-2 | 1 | | 53 | 15-7 | 1 | | 54 | 7023-01 | 1 | | 55 | 7033-01 | 1 | | 56 | 20122-1 | 1 | | 57 | 70831-01 | 1 | | 58 | 605-01 | 1 | | 59 | 703-4 | 1 | | 60 | 709-c | 1 | | 61 | 2083-1 | 1 | | 62 | 3045-1 | 1 | | 63 | 6011-6 | 1 | | 64 | 7051-3 | 1 | | 65 | 70811-6 | 1 | | 66 | 20-4 | 1 | | 67 | 2-9 | 1 | | 68 | 7-4 | 1 | | 69 | 11-5 | 1 | | 70 | 4042-2 | 1 | | 71 | 4045-3 | 1 | | 72 | 104-4 | 1 | | 73 | 40311-2 | 1 | | 74 | 60-1 | 1 | | 75 | 70732-2 | 1 | | 76 | 203b-01 | 1 | | 77 | 203-5 | 1 | | 78 | 709b-01 | 1 | | 79 | 2011-1 | 1 | | 80 | 70233-01 | 1 | | 81 | 602-1 | 1 | | 82 | 702-7 | 1 | | 83 | 708-6 | 1 | | 84 | 2081-1 | 1 | | 85 | 3044-3 | 1 | | 86 | 6013-4 | 1 | | 87 | 7043-2 | 1 | | 88 | 70511-4 | 1 | | 89 | 6082-3 | 1 | | 90 | 29-3 | 1 | | 91 | 70433-3 | 1 | | 92 | 2-3 | 1 | | 93 | 6-5 | 1 | | 94 | 10-1 | 1 | | 95 | 404-1 | 1 | | 96 | 404314-1 | 1 | | 97 | 103-1 | 1 | | 98 | 209-2 | 1 | | 99 | 403121-1 | 1 | | 100 | 70742-1 | 1 | | 101 | 70a11-1 | 1 | | 102 | 203-3 | 1 | | 103 | 7094-01 | 1 | | 104 | 2013-01 | 1 | | 105 | 704231-1 | 1 | | 106 | 403-01 | 1 | | 107 | 608-6 | 1 | | 108 | 707-4 | 1 | | 109 | 1022-1 | 1 | | 110 | 3041-2 | 1 | | 111 | 4032-2 | 1 | | 112 | 7081-01 | 1 | | 113 | 20821-1 | 1 | | 114 | 70432-01 | 1 | | 115 | 25-3 | 1 | | 116 | 45-7 | 1 | | 117 | 1-1 | 1 | | 118 | 5-3 | 1 | | 119 | 9-2 | 1 | | 120 | 403-2 | 1 | | 121 | 40431-3 | 1 | | 122 | 102-1 | 1 | | 123 | 207-2 | 1 | | 124 | 403112-2 | 1 | | 125 | 7072-01 | 1 | | 126 | 603-2 | 1 | | 127 | 7028-1 | 1 | | 128 | 201-1 | 1 | | 129 | 3042-01 | 1 | | 130 | 70423-1 | 1 | | 131 | 309-01 | 1 | | 132 | 607-2 | 1 | | 133 | 707-01 | 1 | | 134 | 1012-1 | 1 | | 135 | 2051-2 | 1 | | 136 | 6011-01 | 1 | | 137 | 7041-01 | 1 | | 138 | 7083-01 | 1 | | 139 | 40323-2 | 1 | | 140 | 22-6 | 1 | | 141 | 44-8 | 1 | | 142 | 4-2 | 1 | | 143 | 8-3 | 1 | | 144 | 14-1 | 1 | | 145 | 40423-1 | 1 | | 146 | 405-01 | 1 | | 147 | 206-3 | 1 | | 148 | 40311-1 | 1 | | 149 | 7045-02 | 1 | | 150 | 70611-3 | 1 | | 151 | 7025-1 | 1 | | 152 | 28-2 | 1 | | 153 | 20122-5 | 1 | | 154 | 304-01 | 1 | | 155 | 605-3 | 1 | | 156 | 704-3 | 1 | | 157 | 709-6 | 1 | | 158 | 2091-1 | 1 | | 159 | 3073-3 | 1 | | 160 | 6061-3 | 1 | | 161 | 20813-01 | 1 | | 162 | 40314-1 | 1 | | 163 | 21-2 | 1 | | 164 | 44-b | 1 | | 165 | 3-4 | 1 | | 166 | 7-9 | 1 | | 167 | 12-3 | 1 | | 168 | 40421-2 | 1 | | 169 | 40452-2 | 1 | | 170 | 202-1 | 1 | | 171 | 403132-01 | 1 | | 172 | 61-3 | 1 | | 173 | 15-4 | 1 | | 174 | 7022-4 | 1 | | 175 | 7061-02 | 1 | | 176 | 70421-01 | 1 | | 177 | 2012-2 | 1 | | 178 | 70343-01 | 1 | | 179 | 602-5 | 1 | | 180 | 702-8 | 1 | | 181 | 709-b | 1 | | 182 | 2082-2 | 1 | | 183 | 3073-01 | 1 | | 184 | 6011-3 | 1 | | 185 | 7051-01 | 1 | | 186 | 70811-3 | 1 | | 187 | 20-1 | 1 | | 188 | 41-1 | 1 | | 189 | 12-6 | 1 | | 190 | 2-69 | 1 | | 191 | 7-1 | 1 | | 192 | 11-2 | 1 | | 193 | 404-5 | 1 | | 194 | 4045-01 | 1 | | 195 | 104-01 | 1 | | 196 | 304-4 | 1 | | 197 | 63-1 | 1 | | 198 | 7073-2 | 1 | | 199 | 203-01 | 1 | | 200 | 203-4 | 1 | | 201 | 7098-01 | 1 | | 202 | 2014-1 | 1 | | 203 | 70232-01 | 1 | | 204 | 601-2 | 1 | | 205 | 702-4 | 1 | | 206 | 708-2 | 1 | | 207 | 1043-2 | 1 | | 208 | 3043-2 | 1 | | 209 | 6013-1 | 1 | | 210 | 7042-2 | 1 | | 211 | 70511-1 | 1 | | 212 | 6082-01 | 1 | | 213 | 18-1 | 1 | | 214 | 70721-01 | 1 | | 215 | 1-5 | 1 | | 216 | 6-2 | 1 | | 217 | 9-6 | 1 | | 218 | 4032-3 | 1 | | 219 | 404312-2 | 1 | | 220 | 103-03 | 1 | | 221 | 208-3 | 1 | | 222 | 403113-1 | 1 | | 223 | 70741-3 | 1 | | 224 | 70a1-01 | 1 | | 225 | 203-7 | 1 | | 226 | 7091-01 | 1 | | 227 | 30441-2 | 1 | | 228 | 203b-3 | 1 | | 229 | 8-7 | 1 | | 230 | 608-2 | 1 | | 231 | 704-2 | 1 | | 232 | 1041-01 | 1 | | 233 | 2092-2 | 1 | | 234 | 4051-3 | 1 | | 235 | 7072-1 | 1 | | 236 | 20811-1 | 1 | | 237 | 70731-1 | 1 | | 238 | 23-1 | 1 | | 239 | 45-4 | 1 | | 240 | 5-1 | 1 | | 241 | 9-01 | 1 | | 242 | 15-2 | 1 | | 243 | 40431-01 | 1 | | 244 | 101-1 | 1 | | 245 | 206-7 | 1 | | 246 | 40312-1 | 1 | | 247 | 7043-5 | 1 | | 248 | 2071-2 | 1 | | 249 | 7026-1 | 1 | | 250 | 3041-01 | 1 | | 251 | 28-6 | 1 | | 252 | 20511-2 | 1 | | 253 | 307-3 | 1 | | 254 | 606-1 | 1 | | 255 | 706-1 | 1 | | 256 | 1011-01 | 1 | | 257 | 1044-01 | 1 | | 258 | 3092-01 | 1 | | 259 | 7042-01 | 1 | | 260 | 7082-01 | 1 | | 261 | 40322-1 | 1 | | 262 | 22-3 | 1 | | 263 | 44-5 | 1 | | 264 | 3-8 | 1 | | 265 | 17-1 | 1 | | 266 | 13-2 | 1 | | 267 | 40422-3 | 1 | | 268 | 40453-2 | 1 | | 269 | 205-3 | 1 | | 270 | 40311-01 | 1 | | 271 | 60-3 | 1 | | 272 | 70611-01 | 1 | | 273 | 7023-1 | 1 | | 274 | 7034-01 | 1 | | 275 | 20122-2 | 1 | | 276 | 7022-01 | 1 | | 277 | 605-4 | 1 | | 278 | 703-1 | 1 | | 279 | 709-2 | 1 | | 280 | 2083-2 | 1 | | 281 | 3045-01 | 1 | | 282 | 6061-01 | 1 | | 283 | 20811-01 | 1 | | 284 | 70811-01 | 1 | | 285 | 20-5 | 1 | | 286 | 3-1 | 1 | | 287 | 7-5 | 1 | | 288 | 24-1 | 1 | | 289 | 4042-3 | 1 | | 290 | 40451-1 | 1 | | 291 | 104-5 | 1 | | 292 | 40311-3 | 1 | | 293 | 30-3 | 1 | | 294 | 70732-02 | 1 | | 295 | 7022-1 | 1 | | 296 | 6032-01 | 1 | | 297 | 709c-01 | 1 | | 298 | 2011-2 | 1 | | 299 | 3043-02 | 1 | | 300 | 602-2 | 1 | | 301 | 702-1 | 1 | | 302 | 709-01 | 1 | | 303 | 2081-2 | 1 | | 304 | 3071-1 | 1 | | 305 | 6013-5 | 1 | | 306 | 7043-3 | 1 | | 307 | 40322-01 | 1 | | 308 | 6082-4 | 1 | | 309 | 29-4 | 1 | | 310 | 601-3 | 1 | | 311 | 2-4 | 1 | | 312 | 6-6 | 1 | | 313 | 10-2 | 1 | | 314 | 404-2 | 1 | | 315 | 404314-2 | 1 | | 316 | 103-2 | 1 | | 317 | 304-1 | 1 | | 318 | 403141-1 | 1 | | 319 | 7073-01 | 1 | | 320 | 70a11-2 | 1 | | 321 | 203-e | 1 | | 322 | 7095-01 | 1 | | 323 | 2013-02 | 1 | | 324 | 70741-2 | 1 | | 325 | 404-01 | 1 | | 326 | 608-7 | 1 | | 327 | 708-01 | 1 | | 328 | 1021-01 | 1 | | 329 | 3042-1 | 1 | | 330 | 4031-2 | 1 | | 331 | 7074-01 | 1 | | 332 | 40511-1 | 1 | | 333 | 70432-1 | 1 | | 334 | 25-4 | 1 | | 335 | 45-8 | 1 | | 336 | 1-2 | 1 | | 337 | 5-5 | 1 | | 338 | 9-3 | 1 | | 339 | 403-1 | 1 | | 340 | 40431-4 | 1 | | 341 | 102-2 | 1 | | 342 | 208-01 | 1 | | 343 | 403112-3 | 1 | | 344 | 7072-02 | 1 | | 345 | 70a-1 | 1 | | 346 | 7028-2 | 1 | | 347 | 201-2 | 1 | | 348 | 2071-1 | 1 | | 349 | 70423-2 | 1 | | 350 | 309-1 | 1 | | 351 | 607-3 | 1 | | 352 | 707-2 | 1 | | 353 | 1012-2 | 1 | | 354 | 2051-3 | 1 | | 355 | 4051-01 | 1 | | 356 | 7072-03 | 1 | | 357 | 7083-1 | 1 | | 358 | 40323-3 | 1 | | 359 | 22-7 | 1 | | 360 | 44-9 | 1 | | 361 | 4-3 | 1 | | 362 | 8-4 | 1 | | 363 | 40423-2 | 1 | | 364 | 405-1 | 1 | | 365 | 206-4 | 1 | | 366 | 403112-01 | 1 | | 367 | 7044-01 | 1 | | 368 | 7061-1 | 1 | | 369 | 7025-2 | 1 | | 370 | 28-3 | 1 | | 371 | 203-f | 1 | | 372 | 307-01 | 1 | | 373 | 605-5 | 1 | | 374 | 704-4 | 1 | | 375 | 709-9 | 1 | | 376 | 2091-2 | 1 | | 377 | 3081-01 | 1 | | 378 | 7034-3 | 1 | | 379 | 20813-1 | 1 | | 380 | 40314-2 | 1 | | 381 | 21-3 | 1 | | 382 | 44-2 | 1 | | 383 | 3-5 | 1 | | 384 | 7-8 | 1 | | 385 | 26-1 | 1 | | 386 | 40422-01 | 1 | | 387 | 40452-3 | 1 | | 388 | 205-01 | 1 | | 389 | 403141-01 | 1 | | 390 | 61-4 | 1 | | 391 | 15-5 | 1 | | 392 | 70221-01 | 1 | | 393 | 7061-01 | 1 | | 394 | 7031-01 | 1 | | 395 | 20121-1 | 1 | | 396 | 70343-2 | 1 | | 397 | 602-6 | 1 | | 398 | 703-01 | 1 | | 399 | 709-5 | 1 | | 400 | 2082-3 | 1 | | 401 | 3073-1 | 1 | | 402 | 6011-4 | 1 | | 403 | 7051-1 | 1 | | 404 | 70811-4 | 1 | | 405 | 20-2 | 1 | | 406 | 42-1 | 1 | | 407 | 2-7 | 1 | | 408 | 7-2 | 1 | | 409 | 11-3 | 1 | | 410 | 4042-01 | 1 | | 411 | 4045-1 | 1 | | 412 | 104-2 | 1 | | 413 | 304-5 | 1 | | 414 | 62-1 | 1 | | 415 | 203-6 | 1 | | 416 | 203-c | 1 | | 417 | 7099-01 | 1 | | 418 | 2014-2 | 1 | | 419 | 70232-1 | 1 | | 420 | 601-4 | 1 | | 421 | 702-2 | 1 | | 422 | 708-4 | 1 | | 423 | 1044-1 | 1 | | 424 | 3044-1 | 1 | | 425 | 6013-2 | 1 | | 426 | 7042-3 | 1 | | 427 | 70511-2 | 1 | | 428 | 6082-1 | 1 | | 429 | 19-1 | 1 | | 430 | 70433-1 | 1 | | 431 | 2-1 | 1 | | 432 | 6-3 | 1 | | 433 | 10-01 | 1 | | 434 | 4031-1 | 1 | | 435 | 404312-3 | 1 | | 436 | 103-04 | 1 | | 437 | 209-01 | 1 | | 438 | 403114-1 | 1 | | 439 | 70742-01 | 1 | | 440 | 70a1-1 | 1 | | 441 | 203-1 | 1 | | 442 | 7092-01 | 1 | | 443 | 7031-1 | 1 | | 444 | 203b-4 | 1 | | 445 | 8-8 | 1 | | 446 | 608-4 | 1 | | 447 | 704-01 | 1 | | 448 | 1043-01 | 1 | | 449 | 2092-3 | 1 | | 450 | 3091-1 | 1 | | 451 | 7072-4 | 1 | | 452 | 20811-2 | 1 | | 453 | 70511-01 | 1 | | 454 | 25-1 | 1 | | 455 | 45-5 | 1 | | 456 | 5-2 | 1 | | 457 | 9-02 | 1 | | 458 | 57-1 | 1 | | 459 | 40431-1 | 1 | | 460 | 101-2 | 1 | | 461 | 206-8 | 1 | | 462 | 403132-1 | 1 | | 463 | 7041-1 | 1 | | 464 | 603-01 | 1 | | 465 | 7026-2 | 1 | | 466 | 207-01 | 1 | | 467 | 282-01 | 1 | | 468 | 20511-3 | 1 | | 469 | 308-1 | 1 | | 470 | 606-2 | 1 | | 471 | 706-2 | 1 | | 472 | 1011-1 | 1 | | 473 | 2051-01 | 1 | | 474 | 3092-1 | 1 | | 475 | 7042-1 | 1 | | 476 | 30441-01 | 1 | | 477 | 40322-2 | 1 | | 478 | 22-4 | 1 | | 479 | 44-6 | 1 | | 480 | 3-9 | 1 | | 481 | 8-1 | 1 | | 482 | 13-3 | 1 | | 483 | 404221-1 | 1 | | 484 | 40453-3 | 1 | | 485 | 206-1 | 1 | | 486 | 40312-01 | 1 | | 487 | 7045-1 | 1 | | 488 | 70611-1 | 1 | | 489 | 7023-2 | 1 | | 490 | 4031-01 | 1 | | 491 | 20122-3 | 1 | | 492 | 7022-02 | 1 | | 493 | 605-1 | 1 | | 494 | 703-2 | 1 | | 495 | 709-3 | 1 | | 496 | 2083-3 | 1 | | 497 | 3072-2 | 1 | | 498 | 6061-1 | 1 | | 499 | 20812-01 | 1 | | 500 | 40313-01 | 1 | | 501 | 20-6 | 1 | | 502 | 58-1 | 1 | | 503 | 3-2 | 1 | | 504 | 7-6 | 1 | | 505 | 12-2 | 1 | | 506 | 40421-01 | 1 | | 507 | 40452-01 | 1 | | 508 | 105-01 | 1 | | 509 | 40311-4 | 1 | | 510 | 30-2 | 1 | | 511 | 70732-3 | 1 | | 512 | 7022-2 | 1 | | 513 | 6032-1 | 1 | | 514 | 709c-02 | 1 | | 515 | 2012-01 | 1 | | 516 | 70344-01 | 1 | | 517 | 602-3 | 1 | | 518 | 702-5 | 1 | | 519 | 709-1 | 1 | | 520 | 2081-3 | 1 | | 521 | 3072-01 | 1 | | 522 | 6011-1 | 1 | | 523 | 7043-1 | 1 | | 524 | 70811-1 | 1 | | 525 | 59-1 | 1 | | 526 | 29-5 | 1 | | 527 | 12-4 | 1 | | 528 | 2-5 | 1 | | 529 | 6-7 | 1 | | 530 | 10-3 | 1 | | 531 | 404-3 | 1 | | 532 | 4044-01 | 1 | | 533 | 104-1 | 1 | | 534 | 304-2 | 1 | | 535 | 403141-2 | 1 | | 536 | 7073-1 | 1 | | 537 | 70a11-01 | 1 | | 538 | 203-a | 1 | | 539 | 7096-01 | 1 | | 540 | 2013-1 | 1 | | 541 | 7034-1 | 1 | | 542 | 601-01 | 1 | | 543 | 608-3 | 1 | | 544 | 708-1 | 1 | | 545 | 1021-2 | 1 | | 546 | 3042-2 | 1 | | 547 | 4031-3 | 1 | | 548 | 7074-1 | 1 | | 549 | 40511-2 | 1 | | 550 | 70432-2 | 1 | | 551 | 25-5 | 1 | | 552 | 3045-2 | 1 | | 553 | 1-3 | 1 | | 554 | 607-01 | 1 | | 555 | 9-4 | 1 | | 556 | 4032-01 | 1 | | 557 | 404312-01 | 1 | | 558 | 102-3 | 1 | | 559 | 208-1 | 1 | | 560 | 403111-1 | 1 | | 561 | 70741-01 | 1 | | 562 | 70a-2 | 1 | | 563 | 203-9 | 1 | | 564 | 201-3 | 1 | | 565 | 3071-01 | 1 | | 566 | 70423-3 | 1 | | 567 | 309-2 | 1 | | 568 | 608-01 | 1 | | 569 | 705-01 | 1 | | 570 | 1021-1 | 1 | | 571 | 2082-02 | 1 | | 572 | 4051-1 | 1 | | 573 | 7072-2 | 1 | | 574 | 7083-2 | 1 | | 575 | 40323-1 | 1 | | 576 | 22-8 | 1 | | 577 | 45-2 | 1 | | 578 | 4-4 | 1 | | 579 | 8-5 | 1 | | 580 | 31-1 | 1 | | 581 | 40423-3 | 1 | | 582 | 101-01 | 1 | | 583 | 206-5 | 1 | | 584 | 403113-01 | 1 | | 585 | 7044-1 | 1 | | 586 | 7071-01 | 1 | | 587 | 7025-01 | 1 | | 588 | 28-4 | 1 | | 589 | 20511-01 | 1 | | 590 | 307-1 | 1 | | 591 | 605-6 | 1 | | 592 | 704-5 | 1 | | 593 | 709-8 | 1 | | 594 | 2091-3 | 1 | | 595 | 3081-1 | 1 | | 596 | 7034-4 | 1 | | 597 | 7081-1 | 1 | | 598 | 40321-1 | 1 | | 599 | 22-1 | 1 | | 600 | 44-3 | 1 | | 601 | 3-6 | 1 | | 602 | 7-a | 1 | | 603 | 27-1 | 1 | | 604 | 40422-1 | 1 | | 605 | 40453-01 | 1 | | 606 | 205-1 | 1 | | 607 | 40321-01 | 1 | | 608 | 61-5 | 1 | | 609 | 15-6 | 1 | | 610 | 7021-01 | 1 | | 611 | 70231-01 | 1 | | 612 | 7032-01 | 1 | | 613 | 20121-2 | 1 | | 614 | 70343-1 | 1 | | 615 | 602-7 | 1 | | 616 | 703-3 | 1 | | 617 | 709-7 | 1 | | 618 | 2083-01 | 1 | | 619 | 3043-01 | 1 | | 620 | 6011-5 | 1 | | 621 | 7051-2 | 1 | | 622 | 70811-5 | 1 | | 623 | 20-3 | 1 | | 624 | 43-1 | 1 | | 625 | 2-8 | 1 | | 626 | 7-3 | 1 | | 627 | 11-4 | 1 | | 628 | 4042-1 | 1 | | 629 | 4045-2 | 1 | | 630 | 104-3 | 1 | | 631 | 403111-01 | 1 | | 632 | 61-1 | 1 | | 633 | 70732-01 | 1 | | 634 | 203b-1 | 1 | | 635 | 203-d | 1 | | 636 | 2011-01 | 1 | | 637 | 70232-2 | 1 | | 638 | 602-01 | 1 | | 639 | 702-6 | 1 | | 640 | 708-5 | 1 | | 641 | 2081-01 | 1 | | 642 | 3044-2 | 1 | | 643 | 6013-3 | 1 | | 644 | 7043-02 | 1 | | 645 | 70511-3 | 1 | | 646 | 6082-2 | 1 | | 647 | 29-2 | 1 | | 648 | 70433-2 | 1 | | 649 | 2-2 | 1 | | 650 | 6-4 | 1 | | 651 | 10-02 | 1 | | 652 | 4031-4 | 1 | | 653 | 404314-01 | 1 | | 654 | 103-05 | 1 | | 655 | 209-1 | 1 | | 656 | 403114-2 | 1 | | 657 | 70742-2 | 1 | | 658 | 70a1-2 | 1 | | 659 | 203-8 | 1 | | 660 | 7093-01 | 1 | | 661 | 70423-01 | 1 | | 662 | 704231-01 | 1 | | 663 | 8-9 | 1 | | 664 | 608-5 | 1 | | 665 | 707-3 | 1 | | 666 | 1022-01 | 1 | | 667 | 3041-1 | 1 | | 668 | 3092-2 | 1 | | 669 | 7072-5 | 1 | | 670 | 20812-2 | 1 | | 671 | 7099-1 | 1 | | 672 | 25-2 | 1 | | 673 | 45-6 | 1 | | 674 | 5-4 | 1 | | 675 | 9-1 | 1 | | 676 | 28-1 | 1 | | 677 | 40431-2 | 1 | | 678 | 102-01 | 1 | | 679 | 207-1 | 1 | | 680 | 403112-1 | 1 | | 681 | 707-1 | 1 | | 682 | 603-1 | 1 | | 683 | 7028-01 | 1 | | 684 | 201-01 | 1 | | 685 | 2082-01 | 1 | | 686 | 20921-01 | 1 | | 687 | 308-2 | 1 | | 688 | 607-1 | 1 | | 689 | 706-3 | 1 | | 690 | 1012-01 | 1 | | 691 | 2051-1 | 1 | | 692 | 4043-01 | 1 | | 693 | 6011-7 | 1 | | 694 | 30441-1 | 1 | | 695 | 40322-3 | 1 | | 696 | 22-5 | 1 | | 697 | 44-7 | 1 | | 698 | 4-1 | 1 | | 699 | 8-2 | 1 | | 700 | 13-4 | 1 | | 701 | 40423-01 | 1 | | 702 | 40453-4 | 1 | | 703 | 206-2 | 1 | | 704 | 40314-01 | 1 | | 705 | 7045-01 | 1 | | 706 | 70611-2 | 1 | | 707 | 7023-3 | 1 | | 708 | 7086-01 | 1 | | 709 | 20122-4 | 1 | | 710 | 70721-02 | 1 | | 711 | 605-2 | 1 | | 712 | 704-1 | 1 | | 713 | 709-4 | 1 | | 714 | 2091-01 | 1 | | 715 | 3073-2 | 1 | | 716 | 6061-2 | 1 | | 717 | 20812-1 | 1 | | 718 | 40313-2 | 1 | | 719 | 21-1 | 1 | | 720 | 44-a | 1 | | 721 | 3-3 | 1 | | 722 | 7-7 | 1 | | 723 | 12-1 | 1 | | 724 | 40421-1 | 1 | | 725 | 40452-1 | 1 | | 726 | 202-01 | 1 | | 727 | 403121-01 | 1 | | 728 | 61-2 | 1 | | 729 | 15-3 | 1 | | 730 | 7022-3 | 1 | | 731 | 60321-01 | 1 | | 732 | 709d-01 | 1 | | 733 | 2012-1 | 1 | | 734 | 70342-1 | 1 | | 735 | 602-4 | 1 | | 736 | 702-3 | 1 | | 737 | 709-a | 1 | | 738 | 2082-1 | 1 | | 739 | 3072-1 | 1 | | 740 | 6011-2 | 1 | | 741 | 7043-4 | 1 | | 742 | 70811-2 | 1 | | 743 | 24-2 | 1 | | 744 | 40-1 | 1 | | 745 | 12-5 | 1 | | 746 | 2-6 | 1 | | 747 | 6-8 | 1 | | 748 | 11-1 | 1 | | 749 | 404-4 | 1 | | 750 | 4044-1 | 1 | | 751 | 3044-01 | 1 | | 752 | 304-3 | 1 | | 753 | 14-01 | 1 | | 754 | 70731-01 | 1 | | 755 | 70a-01 | 1 | | 756 | 203-b | 1 | | 757 | 7097-01 | 1 | | 758 | 2014-01 | 1 | | 759 | 7034-2 | 1 | | 760 | 601-1 | 1 | | 761 | 702-01 | 1 | | 762 | 708-3 | 1 | | 763 | 1043-1 | 1 | | 764 | 3043-1 | 1 | | 765 | 6013-01 | 1 | | 766 | 7074-2 | 1 | | 767 | 40512-1 | 1 | | 768 | 70432-3 | 1 | | 769 | 25-6 | 1 | | 770 | 20921-1 | 1 | | 771 | 1-4 | 1 | | 772 | 6-1 | 1 | | 773 | 9-5 | 1 | | 774 | 4032-1 | 1 | | 775 | 404312-1 | 1 | | 776 | 103-01 | 1 | | 777 | 208-2 | 1 | | 778 | 403111-2 | 1 | | 779 | 70741-1 | 1 | | 780 | 70a-3 | 1 | | 781 | 203-2 | 1 | +------------+-----------+---------+ 781 rows in set (0.07 sec) mysql> \t