Kako si znao da je tabela resources
Malo sam prepravio, to je to, svaka čast.
PHP kôd:
SELECT r.id
FROM resources r
LEFT JOIN resource_attributes a_6 ON r.id = a_6.resource_id AND a_6.attribute_id = 6
LEFT JOIN resource_attributes a_8 ON r.id = a_8.resource_id AND a_8.attribute_id = 8
WHERE
a_6.attribute_value LIKE 'La%'
AND a_8.attribute_value LIKE 'Ho%'