Hi @bsebastian86
In this case, you need to query the wp_post table too. Unfortunately, it needs an advanced query and more related to WordPress and MySQL. In this case, kindly visit WordPress Comunity instead.
Here’s a great thread on how to query multiple tables: http://stackoverflow.com/questions/12475850/how-can-an-sql-query-return-data-from-multiple-tables.
Hope this makes sense 🙂
