function controller_plugin_query($controller)
{
$tables = DB_PLUGINS . ', ' . DB_PLUGINS_LOOKUP;
//set variable value to retrieve plugin_id
$columns = 'DISTINCT(' . DB_PLUGINS_LOOKUP . '.plugin_id)';
$where = DB_PLUGINS_LOOKUP . '.plugin_id=' . DB_PLUGINS . '.plugin_id AND ' . DB_PLUGINS_LOOKUP . '.plugin_type=?';
$field = array($controller);
//build query and return results
$db_results = BuildQuery::all_field_query($tables, $columns, $where, $field);
self::$db_controller_plugins = $db_results;
}