SELECT DISTINCT t1.tag , (SELECT COUNT(*) 
		       FROM tags t2 
		       WHERE t2.tag = t1.tag
		       GROUP BY t2.tag) AS "Questions",
		       (SELECT COUNT(*)
			FROM questions q1, tags t2
			WHERE t2.tag = t1.tag AND q1.qid = t2.qid AND
			      (SELECT SUM(approve)
			       FROM  answers a1
			       WHERE a1.qid = q1.qid
			       GROUP BY a1.qid) > 0) AS "Questions With Answers",
			(SELECT COUNT(*)
			FROM questions q1, tags t2
			WHERE t2.tag = t1.tag AND q1.qid = t2.qid AND
			      (SELECT SUM(approve)
			       FROM  answers a1
			       WHERE a1.qid = q1.qid
			       GROUP BY a1.qid) = 0) AS "Questions Without Answers",
			(SELECT COUNT(*)
			 FROM tags t2
			 WHERE t2.qid = t1.qid AND t1.tag != t2.tag) AS "Connected Tags"
FROM tags t1