} elseif ($fc == 0) { $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