rendered paste bodymysql> select * from character_spell where guid=27819;
+-------+-------+------+--------+
| guid | spell | slot | active |
+-------+-------+------+--------+
| 27819 | 81 | 1 | 1 |
| 27819 | 126 | 145 | 1 |
| 27819 | 132 | 169 | 1 |
| 27819 | 172 | 38 | 1 |
| 27819 | 203 | 2 | 1 |
| 27819 | 204 | 3 | 1 |
| 27819 | 227 | 321 | 1 |
| 27819 | 348 | 36 | 1 |
| 27819 | 522 | 4 | 1 |
| 27819 | 669 | 5 | 1 |
| 27819 | 686 | 6 | 1 |
| 27819 | 687 | 7 | 1 |
| 27819 | 688 | 35 | 1 |
| 27819 | 689 | 83 | 1 |
| 27819 | 691 | 179 | 1 |
| 27819 | 693 | 86 | 0 |
| 27819 | 695 | 37 | 1 |
| 27819 | 696 | 40 | 1 |
| 27819 | 697 | 58 | 1 |
| 27819 | 698 | 170 | 1 |
| 27819 | 699 | 125 | 1 |
| 27819 | 702 | 49 | 1 |
| 27819 | 704 | 82 | 1 |
| 27819 | 705 | 48 | 1 |
| 27819 | 706 | 93 | 1 |
| 27819 | 707 | 41 | 1 |
| 27819 | 709 | 161 | 1 |
| 27819 | 710 | 168 | 1 |
| 27819 | 712 | 101 | 1 |
| 27819 | 755 | 85 | 0 |
| 27819 | 980 | 51 | 1 |
| 27819 | 1014 | 74 | 1 |
| 27819 | 1086 | 151 | 1 |
| 27819 | 1088 | 97 | 1 |
| 27819 | 1094 | 95 | 1 |
| 27819 | 1098 | 166 | 1 |
| 27819 | 1106 | 137 | 1 |
| 27819 | 1108 | 54 | 1 |
| 27819 | 1120 | 53 | 1 |
| 27819 | 1180 | 8 | 1 |
| 27819 | 1454 | 50 | 0 |
| 27819 | 1455 | 84 | 0 |
| 27819 | 1456 | 139 | 0 |
| 27819 | 1490 | 162 | 1 |
| 27819 | 1714 | 141 | 1 |
| 27819 | 1949 | 172 | 1 |
| 27819 | 2362 | 235 | 1 |
| 27819 | 2382 | 9 | 1 |
| 27819 | 2387 | 44 | 1 |
| 27819 | 2389 | 63 | 1 |
| 27819 | 2393 | 46 | 1 |
| 27819 | 2479 | 10 | 1 |
| 27819 | 2941 | 152 | 1 |
| 27819 | 2963 | 45 | 1 |
| 27819 | 2964 | 108 | 1 |
| 27819 | 3050 | 11 | 1 |
| 27819 | 3273 | 116 | 1 |
| 27819 | 3275 | 117 | 1 |
| 27819 | 3365 | 12 | 1 |
| 27819 | 3698 | 144 | 0 |
| 27819 | 3699 | 167 | 0 |
| 27819 | 3700 | 254 | 0 |
| 27819 | 3757 | 110 | 1 |
| 27819 | 3758 | 122 | 1 |
| 27819 | 3813 | 213 | 1 |
| 27819 | 3839 | 205 | 1 |
| 27819 | 3842 | 134 | 1 |
| 27819 | 3843 | 197 | 1 |
| 27819 | 3845 | 109 | 1 |
| 27819 | 3849 | 191 | 1 |
| 27819 | 3850 | 133 | 1 |
| 27819 | 3851 | 206 | 1 |
| 27819 | 3852 | 215 | 1 |
| 27819 | 3855 | 211 | 1 |
| 27819 | 3856 | 207 | 1 |
| 27819 | 3859 | 214 | 1 |
| 27819 | 3861 | 275 | 1 |
| 27819 | 3863 | 250 | 1 |
| 27819 | 3865 | 277 | 1 |
| 27819 | 3868 | 209 | 1 |
| 27819 | 3870 | 303 | 1 |
| 27819 | 3871 | 223 | 1 |
| 27819 | 3908 | 43 | 0 |
| 27819 | 3909 | 78 | 0 |
| 27819 | 3910 | 210 | 0 |
| 27819 | 5009 | 13 | 1 |
| 27819 | 5019 | 14 | 1 |
| 27819 | 5138 | 127 | 1 |
| 27819 | 5484 | 244 | 1 |
| 27819 | 5500 | 123 | 1 |
| 27819 | 5676 | 87 | 1 |
| 27819 | 5697 | 69 | 1 |
| 27819 | 5699 | 185 | 1 |
| 27819 | 5740 | 96 | 1 |
| 27819 | 5782 | 52 | 0 |
| 27819 | 5784 | 230 | 1 |
| 27819 | 6201 | 56 | 1 |
| 27819 | 6202 | 94 | 1 |
| 27819 | 6205 | 140 | 1 |
| 27819 | 6213 | 164 | 1 |
| 27819 | 6217 | 142 | 1 |
| 27819 | 6219 | 187 | 1 |
| 27819 | 6222 | 68 | 1 |
| 27819 | 6223 | 126 | 1 |
| 27819 | 6226 | 186 | 1 |
| 27819 | 6229 | 165 | 1 |
| 27819 | 6233 | 15 | 1 |
| 27819 | 6246 | 16 | 1 |
| 27819 | 6247 | 17 | 1 |
| 27819 | 6353 | 289 | 1 |
| 27819 | 6366 | 138 | 1 |
| 27819 | 6477 | 18 | 1 |
| 27819 | 6478 | 19 | 1 |
| 27819 | 6603 | 20 | 1 |
| 27819 | 6690 | 217 | 1 |
| 27819 | 6693 | 249 | 1 |
| 27819 | 6695 | 267 | 1 |
| 27819 | 7266 | 21 | 1 |
| 27819 | 7267 | 22 | 1 |
| 27819 | 7355 | 23 | 1 |
| 27819 | 7411 | 59 | 0 |
| 27819 | 7412 | 105 | 0 |
| 27819 | 7413 | 265 | 0 |
| 27819 | 7418 | 60 | 1 |
| 27819 | 7421 | 61 | 1 |
| 27819 | 7443 | 106 | 1 |
| 27819 | 7454 | 107 | 1 |
| 27819 | 7629 | 70 | 1 |
| 27819 | 7641 | 204 | 1 |
| 27819 | 7646 | 163 | 1 |
| 27819 | 7648 | 184 | 1 |
| 27819 | 7651 | 243 | 1 |
| 27819 | 7658 | 143 | 1 |
| 27819 | 7766 | 114 | 1 |
| 27819 | 7776 | 136 | 1 |
| 27819 | 7779 | 135 | 1 |
| 27819 | 7786 | 115 | 1 |
| 27819 | 7795 | 262 | 1 |
| 27819 | 7892 | 228 | 1 |
| 27819 | 8288 | 124 | 1 |
| 27819 | 8289 | 232 | 1 |
| 27819 | 8386 | 24 | 1 |
| 27819 | 8758 | 216 | 1 |
| 27819 | 8760 | 212 | 1 |
| 27819 | 8762 | 222 | 1 |
| 27819 | 8770 | 298 | 1 |
| 27819 | 8780 | 281 | 1 |
| 27819 | 8782 | 251 | 1 |
| 27819 | 8791 | 276 | 1 |
| 27819 | 8793 | 278 | 1 |
| 27819 | 8795 | 279 | 1 |
| 27819 | 8797 | 280 | 1 |
| 27819 | 9078 | 25 | 1 |
| 27819 | 9125 | 26 | 1 |
| 27819 | 11659 | 261 | 1 |
| 27819 | 11660 | 304 | 1 |
| 27819 | 11665 | 229 | 1 |
| 27819 | 11667 | 297 | 1 |
| 27819 | 11671 | 259 | 1 |
| 27819 | 11675 | 305 | 1 |
| 27819 | 11677 | 286 | 1 |
| 27819 | 11687 | 242 | 0 |
| 27819 | 11688 | 284 | 1 |
| 27819 | 11693 | 294 | 0 |
| 27819 | 11694 | 306 | 1 |
| 27819 | 11699 | 287 | 1 |
| 27819 | 11703 | 260 | 1 |
| 27819 | 11711 | 233 | 1 |
| 27819 | 11712 | 285 | 1 |
| 27819 | 11729 | 272 | 1 |
| 27819 | 11733 | 241 | 1 |
| 27819 | 11734 | 296 | 1 |
| 27819 | 12045 | 47 | 1 |
| 27819 | 12047 | 208 | 1 |
| 27819 | 12049 | 308 | 1 |
| 27819 | 12053 | 309 | 1 |
| 27819 | 12059 | 323 | 1 |
| 27819 | 12060 | 312 | 1 |
| 27819 | 12065 | 310 | 1 |
| 27819 | 12066 | 311 | 1 |
| 27819 | 12180 | 322 | 1 |
| 27819 | 13262 | 62 | 1 |
| 27819 | 13378 | 157 | 1 |
| 27819 | 13419 | 153 | 1 |
| 27819 | 13421 | 221 | 1 |
| 27819 | 13485 | 253 | 1 |
| 27819 | 13501 | 252 | 1 |
| 27819 | 13503 | 301 | 1 |
| 27819 | 13522 | 264 | 1 |
| 27819 | 13607 | 300 | 1 |
| 27819 | 13622 | 266 | 1 |
| 27819 | 13626 | 263 | 1 |
| 27819 | 13628 | 326 | 1 |
| 27819 | 13637 | 318 | 1 |
| 27819 | 13642 | 314 | 1 |
| 27819 | 13648 | 317 | 1 |
| 27819 | 13659 | 315 | 1 |
| 27819 | 13661 | 316 | 1 |
| 27819 | 13663 | 319 | 1 |
| 27819 | 13687 | 333 | 1 |
| 27819 | 13695 | 332 | 1 |
| 27819 | 13698 | 336 | 1 |
| 27819 | 13700 | 331 | 1 |
| 27819 | 13702 | 330 | 1 |
| 27819 | 13746 | 329 | 1 |
| 27819 | 13794 | 328 | 1 |
| 27819 | 13817 | 335 | 1 |
| 27819 | 13841 | 334 | 1 |
| 27819 | 13920 | 327 | 1 |
| 27819 | 14810 | 320 | 1 |
| 27819 | 17787 | 337 | 1 |
| 27819 | 17792 | 131 | 1 |
| 27819 | 17803 | 57 | 1 |
| 27819 | 17805 | 240 | 1 |
| 27819 | 17814 | 88 | 1 |
| 27819 | 17877 | 195 | 1 |
| 27819 | 17919 | 171 | 1 |
| 27819 | 17920 | 245 | 1 |
| 27819 | 17951 | 246 | 1 |
| 27819 | 18095 | 293 | 1 |
| 27819 | 18178 | 227 | 1 |
| 27819 | 18183 | 282 | 1 |
| 27819 | 18219 | 302 | 1 |
| 27819 | 18372 | 178 | 1 |
| 27819 | 18693 | 91 | 1 |
| 27819 | 18696 | 158 | 1 |
| 27819 | 18829 | 201 | 1 |
| 27819 | 18867 | 202 | 1 |
| 27819 | 18868 | 203 | 1 |
| 27819 | 18869 | 234 | 1 |
| 27819 | 18870 | 288 | 1 |
| 27819 | 20573 | 27 | 1 |
| 27819 | 20574 | 28 | 1 |
| 27819 | 20575 | 29 | 1 |
| 27819 | 20752 | 160 | 0 |
| 27819 | 20755 | 273 | 0 |
| 27819 | 20756 | 295 | 1 |
| 27819 | 21651 | 30 | 1 |
| 27819 | 21652 | 31 | 1 |
| 27819 | 22027 | 32 | 1 |
| 27819 | 22810 | 33 | 1 |
| 27819 | 32383 | 271 | 1 |
| 27819 | 33388 | 231 | 1 |
| 27819 | 33702 | 34 | 1 |
+-------+-------+------+--------+
244 rows in set (0.00 sec)