pulling multiple entries from a match of two tables
You should filter using pairs:

WHERE (attribute_entries.title = 'ford' AND attributes.title = 'manufacturer')
      OR
      (attribute_entries.title = 'whatev' AND attributes.title = 'nickname')


Or you can use IN

WHERE attribute_entries.title IN ('ford', 'whatev')
      AND attributes.title IN ('manufacturer', 'nickname')


In case you need both conditions true you can use EXISTS:

WHERE EXISTS(&lt;your first query&gt;)
      AND
      ExISTS(&lt;your second query&gt;)


You can check it :db&lt;>fiddle here