[da.bass]

OK, I found one solution, but I'm not sure if it will work in all cases:

Code:

SELECT name as a, data, version FROM content
WHERE name IN (
  SELECT contentname FROM theme
  WHERE name = 'test'
)
AND version = (
  SELECT max(version)
  FROM stylesheets
  WHERE name = a
)