SQL Limit con Join

[jurena]

Quieres decir los últimos 4 works o te da igual.
Si son los últimos, prueba esto: no lo he probado.

SELECT works.*, images.*
FROM works
INNER JOIN (SELECT works.id idw FROM works GROUP BY works.id ORDER BY works.id LIMIT 4)T1 ON t1.idw = works.id INNER JOIN images
ON works.wName=images.wName
ORDER BY works.id DESC, images.0rder ASC