How to display pagetitle of parent in TV Mysql?

Question

MySQL

Created TV, where the multiple list. In possible values, I wrote a sample like this:

@SELECT CONCAT(pagetitle,' ','(',parent,')'), id FROM modx_site_content WHERE template=3 and isfolder=0 and published=1 and deleted=0

Everything is working. But for convenience, I want to display instead of parent (parent id) - just a number, the pagetitle of the parent. That is, the pagetitle of parent. Now the title of the resource and the id of the parent are displayed in parentheses. Is it possible to do this and how? Thank you!

Answer 1

Finally discover pdoTools. If you bring all this out at the front, then it is done elementarily. If in the admin panel, then just look at the code and do it by analogy.