These do not run on my mysql just as a FYI the rest do
SELECT t1.B_Number, t1.B_Main, t1.B_Replies, COUNT( * ) AS ThreadTotal
FROM w3t_Posts AS t1
JOIN w3t_Posts AS t2 ON t1.B_Number = t2.B_Main
GROUP BY t2.B_Main
HAVING ThreadTotal != (t1.B_Replies + 1 )
SELECT Bo_Keyword, Bo_Total, COUNT( * ) AS ActualPosts
FROM w3t_Boards
JOIN w3t_Posts ON B_Board = Bo_Keyword
GROUP BY Bo_Keyword
HAVING Bo_Total != ActualPosts
SELECT Bo_Keyword, Bo_Threads, COUNT(*) AS ActualThreads FROM
w3t_Boards JOIN w3t_Posts ON B_Board = Bo_Keyword WHERE
B_Number = B_Main GROUP BY Bo_Keyword HAVING
ActualThreads != Bo_Threads
