View difference between Paste ID: a0qaVS9z and 2pqQKnAj
SHOW: | | - or go back to the newest paste.
1
mysql> SELECT entry, name FROM `creature_template` WHERE `ScriptName` LIKE '%boss_four_horsemen%' LIMIT 0,1000;
2
+-------+-----------------+
3
| entry | name            |
4
+-------+-----------------+
5
| 16063 | Sir Zeliek      |
6
| 16064 | Thane Korth'azz |
7
| 16065 | Lady Blaumeux   |
8
| 30549 | Baron Rivendare |
9
+-------+-----------------+
10
4 rows in set
11
12-
mysql> select guid, id from creature where id in (select entry from creature_template WHERE `ScriptName` LIKE '%boss_four_horsemen%');
12+
13-
+--------+-------+
13+
14-
| guid   | id    |
14+
15-
+--------+-------+
15+
16-
| 130961 | 16064 |
16+
17-
| 130962 | 16065 |
17+
18-
| 130963 | 30549 |
18+
19-
| 130964 | 16063 |
19+
20-
+--------+-------+
20+
21
4 rows in set
22
23
mysql> select guid, id, position_x, position_y, position_z, orientation from creature where id in (select entry from creature_template WHERE `ScriptName` LIKE '%boss_four_horsemen%');
24
+--------+-------+------------+------------+------------+-------------+
25
| guid   | id    | position_x | position_y | position_z | orientation |
26
+--------+-------+------------+------------+------------+-------------+
27
| 130961 | 16064 |     2520.5 |   -2955.38 |    245.635 |     5.58505 |
28
| 130962 | 16065 |    2517.62 |   -2959.38 |    245.636 |     5.72468 |
29
| 130963 | 30549 |    2524.32 |   -2951.28 |    245.633 |     5.42797 |
30
| 130964 | 16063 |    2528.79 |   -2948.58 |    245.633 |      5.2709 |
31
+--------+-------+------------+------------+------------+-------------+
32
4 rows in set