Queries JOINen (Opgelost)

SELECT COUNT( T.topic_ID ) as topicCount, COUNT( F.reactie_ID ) as reactieCount
FROM forumTopics as T
INNER JOIN forumFora as F ON ( T.topic_ForumID = F.forum_ID ) 
INNER JOIN forumReacties as R ON ( T.topic_ForumID = R.reactie_TopicID ) 
WHERE T.topic_ForumID = $var 

SELECT COUNT( T.topic_ID ) as topicCount, COUNT( F.reactie_ID ) as reactieCount
FROM forumTopics as T
INNER JOIN forumFora as F ON ( T.topic_ForumID = F.forum_ID ) 
INNER JOIN forumReacties as R ON ( T.topic_ForumID = R.reactie_TopicID ) 
WHERE T.topic_ForumID = $var

SELECT COUNT( T.topic_ID ) as topicCount, COUNT( R.reactie_ID ) as reactieCount 
FROM forumTopics as T
INNER JOIN forumFora as F ON ( T.topic_ForumID = F.forum_ID ) 
INNER JOIN forumReacties as R ON ( T.topic_ForumID = R.reactie_TopicID ) 
WHERE T.topic_ForumID = $var

SELECT COUNT( T.topic_ID ) AS topicCount, COUNT( R.reactie_ID ) AS reactieCount 
FROM forumTopics AS T
INNER JOIN forumFora AS F ON ( T.topic_ForumID = F.forum_ID ) 
INNER JOIN forumReacties AS R ON ( T.topic_ForumID = R.reactie_TopicID ) 
WHERE T.topic_ForumID = $var

select count(T.topic_ID), count(R.reactie_ID)
from ForumFora F
	inner join forumTopics T T.topic_ForumID = F.forum_ID
	inner join forumReacties R r.reactie_TopiicID = T.topic_ID
where F.forum_ID = var

SELECT count(T.topic_ID), count(R.reactie_ID)
FROM ForumFora F
	INNER JOIN forumTopics T T.topic_ForumID = F.forum_ID
	INNER JOIN forumReacties R r.reactie_TopiicID = T.topic_ID
WHERE F.forum_ID = var

SELECT count(T.topic_ID), count(R.reactie_ID)
FROM forumFora F	
INNER JOIN forumTopics T ON ( T.topic_ForumID = F.forum_ID )
INNER JOIN forumReacties R ON ( R.reactie_TopicID = T.topic_ID )
WHERE F.forum_ID = $var

SELECT count(T.topic_ID), count(R.reactie_ID)
FROM forumFora F	
INNER JOIN forumTopics T ON ( T.topic_ForumID = F.forum_ID )
INNER JOIN forumReacties R ON ( R.reactie_TopicID = T.topic_ID )
WHERE F.forum_ID = $var

SELECT count(T.topic_ID), count(R.reactie_ID)
FROM forumFora F    
INNER JOIN forumTopics T 
INNER JOIN forumReacties R 
ON ( T.topic_ForumID = F.forum_ID  AND R.reactie_TopicID = T.topic_ID) 
WHERE F.forum_ID = $var

SELECT count(T.topic_ID), count(R.reactie_ID)
FROM forumFora F    
INNER JOIN forumTopics T 
INNER JOIN forumReacties R 
ON ( T.topic_ForumID = F.forum_ID  AND R.reactie_TopicID = T.topic_ID) 
WHERE F.forum_ID = $var

SELECT count(T.topic_ID), count(R.reactie_ID)
FROM forumTopics T
	INNER JOIN forumFora F ON ( F.forum_ID = T.topic_ForumID )
	INNER JOIN forumReacties R ON ( R.reactie_TopicID = T.topic_ID )
WHERE T.topic_ForumID = $var

SELECT count(T.topic_ID), count(R.reactie_ID)
FROM forumTopics T
	INNER JOIN forumFora F ON ( F.forum_ID = T.topic_ForumID )
	INNER JOIN forumReacties R ON ( R.reactie_TopicID = T.topic_ID )
WHERE T.topic_ForumID = $var