function getFeedItems($searchType, $searchKeyword, $searchExtraValue, $page, $pageCount, $viewDelete = false, $owner = 0, $customQuery = '') {
global $db, $database;
$sQuery = FeedItem::getFeedItemsQuery($searchType, $searchKeyword, $searchExtraValue,$viewDelete,$owner) . $customQuery;
// for customQuery
if(strpos($customQuery,'f.') !== false && strpos($sQuery, 'Feeds f') === false ) {
$sQuery = ' LEFT JOIN '.$database['prefix'].'Feeds f ON (f.id = i.feed) ' . $sQuery;
}
$pageStart = ($page-1) * $pageCount; // 처음페이지 번호
$sQuery = ' LEFT JOIN '.$database['prefix'].'CategoryRelations c ON (c.item = i.id) ' . $sQuery;
$feedList = $db->queryAll('SELECT i.id, i.feed, i.author, i.permalink, i.title, i.description, i.tags, i.written, i.click, i.thumbnailId, i.visibility, i.feedVisibility, i.boomUp, i.boomDown, c.category AS category, i.focus FROM '.$database['prefix'].'FeedItems i '.$sQuery.' GROUP BY i.id ORDER BY i.written DESC LIMIT '.$pageStart.','.$pageCount);
$feedItemCount = FeedItem::getFeedItemCount($sQuery);
return array($feedList, $feedItemCount);
}
