Just because you don't implicitly use JOIN in your query, doesn't mean you aren't joining tables.

"plugin.id_ref = core.id" is a table join.