Here is my MySQL query..it takes a lot of time to execute and show results. the results is the content of a set of 24000 articles.
SELECT Content FROM AQUA_MASTER WHERE Article_ID IN (SELECT Article_ID FROM AQUA_TAGGING WHERE Tag_ID=1736);
why is that? can somebody tell me how i can solve this problem?