Get zone id from name:
MariaDB [eq2emu]> select id from zones where name='stormhold';
Result: id is 15
Get all spawn names, spawn location ids and spawn ids from a zone (in this case zone_id 1).
select sp.name, slp.spawn_location_id, sle.spawn_id from spawn_location_placement as slp inner join spawn_location_entry as sle on sle.spawn_location_id = slp.spawn_location_id and slp.zone_id=1 inner join spawn as sp on sle.spawn_id = sp.id;
Result:
| name | spawn_location_id | spawn_id |
| a counter | 1585600 | 10014 |
| a gazebo | 1585601 | 10015 |
etc..