Query from WordPress

I need to get data from a WordPress database and to get the name of the image I have to cross two tables. The query should be like this

but does not accept a text and therefore interprets it is undefined

Schermata 2019-02-12 alle 18.57.13.png764×103 22.5 KB

It’s possible to solve this?

Thank you