Optimize subquery, replace IN() with JOIN

[Miron jajtic]

Hello,

I have sql query with two in() subqueries, they are returning correct 10 sorted results, but complete query it's terrible slow, over 5 minutes waiting.

SELECT id, title, alias
FROM content
WHERE published = '1'
AND typ = 'actual'
AND id
IN (
SELECT content_id
FROM category_content_se
WHERE category_id
IN (
SELECT category_id
FROM category_content_se
WHERE content_id = '11430'
)
AND content_typ = 'actual'
)
ORDER BY date_add DESC
LIMIT 10


Can someone please help me how to write same query using JOINs ?

Server is MySQLv5.6