$query = "SELECT DISTINCT a.*, a.images, cc.alias AS catalias, " . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,' . ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug ' . $ordcomments . "\n FROM #__content AS a" . "\n LEFT JOIN #__content_frontpage AS f ON f.content_id = a.id" . "\n INNER JOIN #__categories AS cc ON cc.id = a.catid" . "\n INNER JOIN #__sections AS s ON s.id = a.sectionid" . "\n LEFT JOIN #__content_rating AS r ON r.content_id = a.id" . $flexidateordering . $fishjoin . $reljoin . $joinfront . "\n WHERE ( a.state = 1 AND a.sectionid > 0 )" . "\n AND ( a.publish_up = '{$nullDate}' OR a.publish_up <= '{$now}' )" . "\n AND ( a.publish_down = '{$nullDate}' OR a.publish_down >= '{$now}' )" . $condition_avenir . ($access ? "\n AND a.access <= {$my->gid} AND cc.access <= {$my->gid} AND s.access <= {$my->gid}" : '') . ($catid || $catid === '0' ? "\n AND ( " : '') . ($catid ? "( a.catid IN ( {$catid} ) )" : '') . ($catid && $catid === '0' ? " OR " : '') . ($catid === '0' ? "( a.catid = '0' )" : '') . ($catid || $catid === '0' ? " )" : '') . ($excatid || $excatid === '0' ? "\n AND ( " : '') . ($excatid ? "\n ( a.catid NOT IN ( {$excatid} ) )" : '') . ($excatid && $excatid === '0' ? " OR " : '') . ($excatid === '0' ? "( a.catid != 0 )" : '') . ($excatid || $excatid === '0' ? " )" : '') . ($secid ? "\n AND ( a.sectionid IN ( {$secid} ) )" : '') . ($show_front == '0' ? ' AND f.content_id IS NULL' : '') . "\n AND s.published = 1" . "\n AND cc.published = 1" . $fishlimit . $limitauth . ($recent ? "\n AND DATEDIFF(" . $db->Quote($now) . ", a.created) < " . $recent : '') . $relnorepeat . $relatedcond . "\n ORDER BY {$ordering}";
}
$db->setQuery($query, 0, $count);
$rows = $db->loadObjectList();
if (empty($rows)) {
if ($params->get('related') == 0 && $params->get('flexirelated') == 0) {
if ($params->get('uselangfile') == 1) {
echo JText::_('F_NOTHINGTOSHOW');
} else {
echo $nothingtoshow;
}
}
} else {
//Reduce queries used by getItemid for Content Items
$bs = JApplication::getBlogSectionCount();
$bc = JApplication::getBlogCategoryCount();
$gbs = JApplication::getGlobalBlogSectionCount();
//FLEXIcontent Watermark
if ($flexiwatermark == 0) {
$flexipath = 'components/com_flexicontent/uploads/';
} elseif ($flexiwatermark == 1) {
$flexipath = 'images/stories/flexicontent/s_';
} elseif ($flexiwatermark == 2) {
$flexipath = 'images/stories/flexicontent/m_';
} elseif ($flexiwatermark == 3) {
$flexipath = 'images/stories/flexicontent/l_';
} elseif ($flexiwatermark == 4) {
$flexipath = $params->get('FLEXIcustom');
}
//Profile Link preparation
if ($profilesystem != 0) {
