Here is a start...
Code:
mysql> SELECT id,name,nimbuseffect from spells_new WHERE nimbuseffect > 0 ORDER BY nimbuseffect ASC;
+-------+----------------------------------+--------------+
| id | name | nimbuseffect |
+-------+----------------------------------+--------------+
| 16546 | Minor Explosion | 1 |
| 17422 | Mutabeetle Bilesquirt | 1 |
| 39298 | Temporarily Blinded | 2 |
| 13953 | Consuming Flames | 5 |
| 8441 | Wrath of Tunare | 6 |
| 17605 | Dimensional Purge | 10 |
| 17837 | Thunderous Clap | 13 |
| 17839 | Primordial Secretion | 26 |
| 39046 | Belching Potion | 28 |
| 39019 | Belching Potion | 28 |
| 37897 | Burning Passion | 28 |
| 39009 | Burning! | 38 |
| 7991 | Zeixshi`Kar's Freezing Strike | 41 |
| 8104 | Zeixshi`Kar's Freezing Strike | 41 |
| 7993 | Zeixshi`Kar's Freezing Strike | 41 |
| 7992 | Zeixshi`Kar's Freezing Strike | 41 |
| 17875 | Brittle Bones | 94 |
| 37880 | Sneaky as a Gnome | 95 |
| 39024 | Drum Beat: Fervor | 156 |
| 39008 | Crazy Juice | 168 |
| 17419 | Unstable Potions Explosion | 200 |
| 6901 | Fire of Solusek Ro | 204 |
| 39025 | Drum Beat: Emboldened | 220 |
| 39004 | Bubbled | 220 |
| 17555 | Portal Distortion | 225 |
| 17836 | Shield of Shards | 226 |
| 39018 | Honey-Finder Potion | 230 |
| 9326 | Frost Melt | 257 |
| 9327 | Avalanche's Terror | 257 |
| 8140 | Blast of Flame | 316 |
| 17657 | Corrosive Webbing | 368 |
| 6128 | Gelidran Aura | 368 |
| 6127 | Pyrilen Aura | 369 |
| 24033 | Bottle of Adventure III | 413 |
| 22467 | Bottle of Shared Adventure I | 413 |
| 21030 | Bottle of Adventure III | 413 |
| 21029 | Bottle of Adventure II | 413 |
| 13390 | Blessing of the Devoted | 413 |
| 24048 | Bottle of Shared Adventure III | 413 |
| 24046 | Bottle of Shared Adventure III | 413 |
| 24045 | Bottle of Shared Adventure II | 413 |
| 24044 | Bottle of Shared Adventure I | 413 |
| 24032 | Bottle of Adventure II | 413 |
| 24031 | Bottle of Adventure I | 413 |
| 22468 | Bottle of Shared Adventure II | 413 |
| 22469 | Bottle of Shared Adventure III | 413 |
| 46253 | Bottle of Adventure IV | 413 |
| 21028 | Bottle of Adventure I | 413 |
| 13088 | Potion of Adventure I | 413 |
| 12918 | Potion of Adventure | 413 |
| 24047 | Bottle of Adventure III | 413 |
| 12332 | Bottle of Hastened Adventure I | 413 |
| 12333 | Bottle of Hastened Adventure II | 413 |
| 12334 | Bottle of Hastened Adventure III | 413 |
| 13089 | Potion of Adventure II | 413 |
| 13093 | Potion of Adventure III | 413 |
| 6880 | Lesson of the Devoted | 413 |
| 6881 | Infusion of the Faithful | 414 |
| 12519 | Fierce Eye | 415 |
| 12748 | Glyph of Courage | 415 |
| 24198 | Draught of the Craftsman | 415 |
| 6886 | Intensity of the Resolute | 415 |
| 39307 | Double Faction Potion | 439 |
| 39306 | Locked Faction Potion | 442 |
| 42645 | Endless Decay | 446 |
| 12932 | Nimbus of the Plaguebringer | 446 |
| 12933 | Nimbus of the Burning Prince | 447 |
| 32801 | Molten Anathema Fire | 447 |
| 12934 | Nimbus of the Storm Lord | 448 |
| 12909 | Nimbus of the Lover | 450 |
| 12908 | Nimbus of the Faceless | 451 |
| 32816 | Cloud of Ill Fortune | 452 |
| 12906 | Nimbus of the Rain Keeper | 452 |
| 16908 | April Showers | 452 |
| 12907 | Nimbus of Growth | 453 |
| 12876 | Nimbus of the Wisp | 454 |
| 12877 | Nimbus of the Tranquil | 455 |
| 12878 | Nimbus of the Jester | 456 |
| 12879 | Nimbus of the Air Queen | 457 |
| 12880 | Nimbus of the Ocean Lord | 458 |
| 17025 | Nimbus of Temporal Rifting | 458 |
| 13375 | Nimbus of the Crystal Gelidran | 459 |
| 13377 | Nimbus of the Molten Pyrilen | 460 |
| 13376 | Nimbus of the Frozen Gelidran | 461 |
| 13378 | Nimbus of the Burning Pyrilen | 462 |
| 13379 | Nimbus of the Riftseeker | 463 |
| 20145 | Nimbus of Discordant Energy | 464 |
| 20146 | Nimbus of Discordant Chains | 465 |
| 20147 | Nimbus of Discordant Spines | 466 |
| 20148 | Nimbus of Mata Muram | 467 |
| 20149 | Nimbus of Discordant Souls | 468 |
| 21056 | Hands of Burning Steam | 469 |
| 20161 | Nimbus of the Rumbling Earth | 470 |
| 20162 | Nimbus of the Howling Wind | 471 |
| 20163 | Nimbus of the Void | 472 |
| 20164 | Nimbus of Burning Steps | 473 |
| 20165 | Nimbus of Rushing Water | 474 |
| 21367 | Lucky Feet | 475 |
| 21368 | Reeyore's Dismay | 476 |
| 17184 | April Showers | 476 |
| 17183 | April Showers | 476 |
| 21369 | Frozen Vengeance of the Gelidran | 477 |
| 21370 | Daws' Curse | 478 |
| 20179 | New Year Confetti | 502 |
| 21851 | Bristlebane Confetti | 502 |
| 21506 | Bristlebane Confetti | 502 |
| 21852 | Tunare Confetti | 503 |
| 21507 | Tunare Confetti | 503 |
| 21384 | Nimbus of the Inquisition | 509 |
| 21385 | Nimbus of the Truth Bearer | 510 |
| 21387 | Nimbus of Daylight | 511 |
| 21388 | Nimbus of Midnight | 512 |
| 21386 | Nimbus of the Dead | 513 |
| 21636 | Nimbus of the Army of Light | 514 |
| 21637 | Nimbus of the Obliteration Army | 515 |
| 21638 | Nimbus of the Cloudwalker | 516 |
| 21926 | Nimbus of Crystal Growth | 517 |
| 21927 | Nimbus of Dirty Hands | 518 |
| 21928 | Nimbus of Gears | 519 |
| 21929 | Nimbus of Gears | 520 |
| 16454 | Test BardSongDistance | 521 |
| 21941 | Path of Skulls Nimbus | 545 |
| 21952 | Nimbus of Blood | 546 |
| 21953 | Nimbus of Stone Hands | 547 |
| 21954 | Nimbus of Bats | 548 |
| 20742 | Nimbus of Jack | 550 |
| 20743 | Nimbus of Candles | 551 |
| 16853 | Nimbus of Lava | 566 |
| 23018 | Bladestorm Nimbus | 567 |
| 22471 | Tread of the Mountain Walker | 568 |
| 22472 | Forge Master's Sparks | 569 |
| 23017 | Nimbus of Runes | 570 |
| 23019 | Nimbus of the Gambler | 571 |
| 23020 | Nimbus of Dust Storm | 572 |
| 9885 | Share the Pain Nimbus | 574 |
| 16912 | Sign of the Broken Heart | 574 |
| 16913 | Crown of Icicles | 576 |
| 16906 | Path of Tunare | 578 |
| 16907 | Nimbus of the Green Thumb | 579 |
| 16895 | Evidence of the Party | 580 |
| 16896 | Nimbus of the Dazed | 581 |
| 16897 | Nimbus of the Confused | 582 |
| 23297 | Pluck Worm | 583 |
| 16894 | Prank of the Fool | 583 |
| 17182 | Nimbus of the Fool | 583 |
| 23298 | Spinefist Nimbus | 585 |
| 23299 | Crown of Roses Nimbus | 586 |
| 24052 | Nimbus of Fire and Ice | 607 |
| 24053 | Crown of Lightning | 608 |
| 24054 | Path of Decay | 609 |
| 24055 | Crystalline Shield Nimbus | 610 |
| 24061 | Lunar Nimbus | 611 |
| 24062 | Tailor's Nimbus | 612 |
| 24188 | Nimbus of the Ocean | 613 |
| 24187 | Nimbus of the Tempest | 614 |
| 20997 | Dreamcatcher Nimbus | 633 |
| 20998 | Nightmare Nimbus | 634 |
| 17385 | Fog Machine | 638 |
| 12162 | Shield of Scrolls | 640 |
| 17852 | Path of Fire Nimbus | 641 |
| 38432 | Sticky Tendrils | 642 |
| 17851 | Death and Decay Nimbus | 642 |
| 23487 | Crown of Feathers | 643 |
| 27376 | Nimbus of Frost | 644 |
| 27377 | Party Popper Nimbus | 645 |
| 27373 | Mistletoe | 648 |
| 27374 | Nimbus of Holly | 649 |
| 27375 | Fruitcake Nimbus | 650 |
| 15893 | Crocus Nimbus | 651 |
| 9695 | Rose Petal Nimbus | 652 |
| 9884 | Share the Love Nimbus | 653 |
| 9848 | Crown of Fire Nimbus | 654 |
| 9849 | Path of Ice Nimbus | 655 |
| 11597 | Butterfly Nimbus | 656 |
| 11997 | Cherry Blossom Nimbus | 659 |
| 27859 | Fae Spirit Nimbus | 661 |
| 19795 | Swarm of Bees | 663 |
| 15917 | Fireworks Nimbus | 665 |
| 12343 | Arachnophobia Nimbus | 666 |
| 12403 | Solstice Nimbus | 667 |
| 32901 | Nimbus of the Two | 671 |
+-------+----------------------------------+--------------+
181 rows in set