Da, se poate şi aşa:

SELECT * FROM productsTest p
WHERE p.genre IN (SELECT t.value FROM test t WHERE t.cod='genre')
AND p.publisher IN (SELECT t.value FROM test t WHERE t.cod='publisher')

Răzvan