[MOD] Dont need to query again just for get article title

Question

$query = "SELECT a.*, b.id as articleid, b.catid as catid, b.sectionid as secid, b.title AS articletitle FROM #__chrono_comments AS a, #__content AS b WHERE a.pageid = b.id AND a.published='1' AND a.verify='1'".$extra." ORDER BY a.datetime ".$params->get( 'order', 'ASC' )." LIMIT 0,".$params->get( 'commentscount', 5 );//get full article link

$page_link = JRoute::_(ContentHelperRoute::getArticleRoute($commentx->articleid, $commentx->catid, $commentx->secid));

//end article linkSo you don't need to take query again just for each article

Forums

[MOD] Dont need to query again just for get article title