Code:
+-----+--------+----------+----------+----------+----------+----------+---------
+
| id | doorid | zone | pos_y | pos_x | pos_z | lockpick | keyitem
|
+-----+--------+----------+----------+----------+----------+----------+---------
+
| 136 | 5 | befallen | -630.708 | -179.908 | -69.971 | 50 | 20363
|
| 131 | 10 | befallen | -267.937 | -83.4136 | -13.9934 | 11 | 20361
|
| 124 | 17 | befallen | -561.758 | 53.7047 | -41.9822 | 25 | 20362
|
+-----+--------+----------+----------+----------+----------+----------+---------
+
3 rows in set (0.00 sec)
I was able to manage. Just had to type the whole query in by hand in the command line rather than in the Query Browser GUI like I'm used to, heh. If there's a quicker/easier way, please tell me =)