Need some help with SQL queries for a dynamic directory

Hey,

I’ve built out the dynamic directory part of one of our projects - but i’m struggling with a high performance SQL query to display various data on each page. Time is a bit of an issue for me right now, hence the job instead of having enough time to learn!

NodeJS project. MySql 8.

Strong preference is that this is done in the standard Wappler workflows, and perhaps if we tackle the most complex one or two - I can then do the rest. If it can’t be done in standard workflows, then custom SQL.

Please send me a DM if you can help.

Thanks!