private function _getJsonPlugins()
{
$sql = 'SELECT ' . "IF(p.`extras` = '', 'core', p.`extras`) `value`, " . "IF(p.`extras` = '', 'Core', g.`title`) `title` " . 'FROM `:prefix:pages` p ' . 'LEFT JOIN `:prefixextras` g ON (g.`name` = p.`extras`) ' . 'GROUP BY p.`extras`';
$sql = iaDb::printf($sql, array('prefix' => $this->_iaDb->prefix, 'pages' => iaPage::getTable()));
return array('data' => $this->_iaDb->getAll($sql));
}
