Ris

	FOR($e=0;$e<=$rows-1;$e++)
	{
	$sql = "SELECT * FROM cms_comments WHERE target = 'anec' AND target_id = ".$quests[$e]['id'].";";
	$result = $inDB->query($sql) ;
	$rows2 = $inDB->num_rows($result);
	$quests[$e]['comments_vote']=$rows2;
	}

$sql = "SELECT  q.*, c.title cat_title, c.id cid, u.login, u.nickname, r.item_id rid, m.id comm
				FROM cms_anec_quests q
				LEFT JOIN cms_faq_cats c ON c.id = q.category_id
				LEFT JOIN cms_comments m ON  m.target_id = q.id AND m.target = 'faq'
				LEFT JOIN cms_ratings r ON r.item_id = q.id AND r.target = 'quest' AND r.user_id = {$inUser->id}
				LEFT JOIN cms_users u ON u.id = q.user_id WHERE q.published = 1
				ORDER BY q.pubdate DESC
				LIMIT 15";

$sql = "SELECT  q.*, c.title cat_title, c.id cid, u.login, u.nickname, r.item_id rid, COUNT(m.id) comm
				FROM cms_anec_quests q
				LEFT JOIN cms_faq_cats c ON c.id = q.category_id
				LEFT JOIN cms_comments m ON  m.target_id = q.id AND m.target = 'faq'
				LEFT JOIN cms_ratings r ON r.item_id = q.id AND r.target = 'quest' AND r.user_id = {$inUser->id}
				LEFT JOIN cms_users u ON u.id = q.user_id WHERE q.published = 1
				ORDER BY q.pubdate DESC
				LIMIT 15";

$sql = "SELECT q.*, c.title cat_title, c.id cid, u.login, u.nickname, COUNT(m.target_id) comm
FROM cms_faq_quests q
LEFT JOIN cms_faq_cats c ON c.id = q.category_id
LEFT JOIN cms_users u ON u.id = q.user_id
LEFT JOIN cms_comments m  ON m.target_id = q.id
WHERE q.published = 1
GROUP BY m.target_id
ORDER BY q.pubdate DESC
LIMIT ".(($page-1)*$perpage).", $perpage";

Unknown column 'i.votedate' in 'where clause'
 
SELECT COUNT(i.id) as count
FROM cms_con_anec i
JOIN cms_rating_log as r ON r.target_id = i.id
WHERE (i.votedate >= DATE_SUB(NOW(), INTERVAL 1 DAY)) AND (i.votedate < DATE_SUB(NOW(), INTERVAL 2 DAY)) AND (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_pub = '1')