'u.id, u.username, u.title, u.num_posts, u.registered, g.g_id, g.g_user_title',
'FROM' => 'users AS u',
'JOINS' => array(
array(
'LEFT JOIN' => 'groups AS g',
'ON' => 'g.g_id=u.group_id'
)
),
'WHERE' => 'u.id>1',
'ORDER BY' => $pun_page['sort_by'].' '.$pun_page['sort_dir'],
'LIMIT' => $pun_page['start_from'].', 50'
);
if (!empty($where_sql))
$query['WHERE'] .= ' AND '.implode(' AND ', $where_sql);
($hook = get_hook('ul_qr_get_users')) ? eval($hook) : null;
$result = $pun_db->query_build($query) or error(__FILE__, __LINE__);
$pun_page['item_count'] = 0;
if ($pun_db->num_rows($result))
{
?>