public function names_for_table($table)
{
$table = $this->app->database_manager->escape_string($table);
$table1 = $this->app->database_manager->assoc_table_name($table);
$table = $this->table;
$q = false;
$results = false;
$q = "SELECT *, count(id) AS qty FROM {$table} WHERE type IS NOT NULL AND rel_type='{$table1}' AND name!='' GROUP BY name, type ORDER BY qty DESC LIMIT 100";
$crc = crc32($q);
$cache_id = __FUNCTION__ . '_' . $crc;
$results = $this->app->database_manager->query($q, $cache_id, 'custom_fields/global');
if (is_array($results)) {
return $results;
}
}