Aokromes
By: a guest | Mar 18th, 2010 | Syntax:
None | Size: 2.30 KB | Hits: 40 | Expires: Never
mysql> select entry, mindmg, dmg_multiplier from creature_template where mindmg > 1000 and dmg_multiplier >1 order by mindmg;
+-------+--------+----------------+
| entry | mindmg | dmg_multiplier |
+-------+--------+----------------+
| 18486 | 1042 | 7.5 |
| 18485 | 1042 | 7.5 |
| 21263 | 1060 | 7.5 |
| 23223 | 1060 | 7.5 |
| 25372 | 1400 | 7.5 |
| 25595 | 1700 | 7.5 |
| 22946 | 1788 | 7.5 |
| 22496 | 1788 | 4.6 |
| 10162 | 1902 | 3.5 |
| 23370 | 2120 | 4.6 |
| 23146 | 2126 | 4.6 |
| 25033 | 2200 | 4.6 |
| 20555 | 2605 | 4.6 |
| 23232 | 2781 | 7.5 |
| 22199 | 2865 | 4.6 |
| 25593 | 3545 | 7.5 |
| 21246 | 3576 | 7.5 |
| 25507 | 4250 | 7.5 |
| 25599 | 4500 | 7.5 |
| 17943 | 4611 | 7.5 |
| 17934 | 4611 | 7.5 |
| 18502 | 4611 | 7.5 |
| 17932 | 4611 | 7.5 |
| 17931 | 4611 | 7.5 |
| 17937 | 4611 | 7.5 |
| 17933 | 4611 | 7.5 |
| 17920 | 4611 | 7.5 |
| 17921 | 4611 | 7.5 |
| 17919 | 4611 | 7.5 |
| 25591 | 4700 | 7.5 |
| 21227 | 4768 | 7.5 |
| 22939 | 4854 | 7.5 |
| 23139 | 6347 | 4.6 |
| 23235 | 6474 | 7.5 |
| 21231 | 6623 | 7.5 |
| 21218 | 6805 | 7.5 |
| 21301 | 6888 | 7.5 |
| 23236 | 6957 | 7.5 |
| 22965 | 7014 | 7.5 |
| 25486 | 7350 | 7.5 |
| 21221 | 7418 | 7.5 |
| 21863 | 7816 | 7.5 |
| 25592 | 7900 | 7.5 |
| 23172 | 8091 | 7.5 |
| 21251 | 8093 | 7.5 |
| 22954 | 8093 | 7.5 |
| 23196 | 8093 | 7.5 |
| 22953 | 9273 | 7.5 |
| 21232 | 9273 | 7.5 |
| 22962 | 9712 | 7.5 |
| 23239 | 10597 | 7.5 |
| 23222 | 10597 | 7.5 |
+-------+--------+----------------+
52 rows in set (0.02 sec)
mysql> select entry, mindmg, dmg_multiplier from creature_template where mindmg > 1000 and dmg_multiplier >1 order by mindmg;