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); }