Re: Optimize subquery, replace IN() with JOIN

[Peter Brawley]

Yikes, who in the world wrote that unnecessarily baroque query?

SELECT a.id, a.title, a.alias 
FROM content             AS a
JOIN category_content_se AS b ON a.id = b.content_id
WHERE a.id=11430 AND a.content_typ = 'actual' 
ORDER BY a.date_add DESC LIMIT 10 ;

If this doesn't return the desired results, please post Show Create table for the two tables plus enough Insert statements for them to demonstrate the problem.