$query =
"SELECT u.name as user, cb.`cb_jackpot`, SUM(tp2.points) AS user_points " .
"FROM #__tc_pools as tp, " .
" #__tc_categories as tc, " .
" #__tc_selections as ts, " .
" #__tc_points tp2, " .
" #__users u " .
"LEFT JOIN `#__comprofiler` AS cb " .
"ON cb.`id` = u.`id` " .
"WHERE tp.id = tc.pool_id " .
"AND tc.id = tp2.category_id " .
"AND tc.id = ts.category_id " .
"AND tc.winner_nomination_id = ts.nomination_id " .
"AND ts.nomination_type = tp2.nomination_type " .
"AND ts.username = u.username " .
"GROUP BY u.name, cb.`cb_jackpot` " .
"ORDER BY SUM(tp2.points) DESC";