[trackpads]

I am getting these incredibly long queries in the slow query log for mysql. These are related to discussion ender, which I have already removed but are still showing up.

What should I do?

Thanks

-Jason

# Time: 121110 15:03:40
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 116.362738  Lock_time: 0.000086 Rows_sent: 1  Rows_examined: 3393026
SET timestamp=1352577820;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32258
                        AND T.dateline > 315532800 AND T.dateline < 1352577704
                        AND P.dateline > 315532800 AND P.dateline < 1352577704
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;


# Time: 121110 15:05:19
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 89.153733  Lock_time: 0.000073 Rows_sent: 1  Rows_examined: 3393026
SET timestamp=1352577919;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32262
                        AND T.dateline > 315532800 AND T.dateline < 1352577830
                        AND P.dateline > 315532800 AND P.dateline < 1352577830
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;