JComments Latest в режиме Последние прокомментированные материалы (не только com_content) - Предложения и пожелания

$query = "(SELECT c.id AS id, c.title AS title, c.sectionid, 'com_content' as grp"
			. ((JCOMMENTS_JVERSION == '1.5')? ', CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug' : '')
			. ((JCOMMENTS_JVERSION == '1.5')? ', CASE WHEN CHAR_LENGTH(ct.alias) THEN CONCAT_WS(":", ct.id, ct.alias) ELSE ct.id END as catslug' : '')
			. "\n, COUNT(cc.id) AS comments, MAX(cc.date) AS commentdate"
			. "\n FROM #__content AS c"
			. "\n LEFT JOIN #__jcomments AS cc ON c.id = cc.object_id"
			. "\n LEFT JOIN #__categories AS ct ON ct.id = c.catid"
			. "\n WHERE c.state = 1"
			. "\n   AND c.access <= '$my->gid'"
			. "\n   AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '$now')"
			. "\n   AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '$now')"
			. "\n   AND cc.published = 1"
			. "\n   AND (cc.object_group = 'com_content')"
			. ((!$catid && $sectionid)? "\n   AND (c.sectionid IN ($sectionid) )" : '')
			. (count($exclude_sections)? "\n AND (c.sectionid NOT IN (".implode(',', $exclude_sections).") )" : '')
			. ($catid ? "\n   AND (c.catid IN ($catid) )" : '')
			. (count($exclude_catids)? "\n AND (c.catid NOT IN (".implode(',', $exclude_catids).") )" : '')
			. "\n GROUP BY c.id, c.title, c.sectionid"
			. ((JCOMMENTS_JVERSION == '1.5')? ", slug, catslug" : '')
			. "\n ORDER BY commentdate DESC"
			. "\n LIMIT " . intval( $params->get( 'count' ) ).")"
			. "\n UNION"
			. "\n (SELECT c.id AS id, c.title AS title, '99999999' AS sectionid, 'com_apoll' as grp"
			. ((JCOMMENTS_JVERSION == '1.5')? ', CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug' : '')
			. ((JCOMMENTS_JVERSION == '1.5')? ', CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug' : '')
			. "\n, COUNT(cc.id) AS comments, MAX(cc.date) AS commentdate"
			. "\n FROM #__apoll_polls AS c"
			. "\n LEFT JOIN #__jcomments AS cc ON c.id = cc.object_id"
			. "\n WHERE c.published = 1"
			. "\n   AND cc.published = 1"
			. "\n   AND (cc.object_group = 'com_apoll')"
			. "\n GROUP BY c.id, c.title"
			. ((JCOMMENTS_JVERSION == '1.5')? ", slug, catslug" : '')
			. "\n ORDER BY commentdate DESC"
			. "\n LIMIT " . intval( $params->get( 'count' ) ).")"
			. "\n ORDER BY commentdate DESC"
			. "\n LIMIT " . intval( $params->get( 'count' ) )
			;

. "\n UNION"

. "\n ORDER BY commentdate DESC"
			. "\n LIMIT " . intval( $params->get( 'count' ) )

if ($row->object_group = 'com_apoll') {
			  require_once (JPATH_ROOT.DS.'components'.DS.'com_apoll'.DS.'helpers'.DS.'route.php');
			  $link = JRoute::_( 'index.php?option=com_apoll&view=apoll&id='.$row->slug.$itemid);

if ($row->grp == 'com_apoll') {
			  $link = JRoute::_( 'index.php?option=com_apoll&view=apoll&id='.$row->slug.$itemid); 
			  } else {
				require_once (JPATH_ROOT.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php');
				$link = JRoute::_(ContentHelperRoute::getArticleRoute($row->slug, $row->catslug, $row->sectionid)). '#comments';
				}

index.php?option=com_apoll&view=apoll&id='.$row->slug.$itemid

index.php?option=com_apoll&view=apoll&id='.$row->slug.$itemid