equal
deleted
inserted
replaced
2525 . " $gid_col\n" |
2525 . " $gid_col\n" |
2526 . " FROM " . table_prefix . "users AS u\n" |
2526 . " FROM " . table_prefix . "users AS u\n" |
2527 . " LEFT JOIN " . table_prefix . "groups AS g\n" |
2527 . " LEFT JOIN " . table_prefix . "groups AS g\n" |
2528 . " ON ( g.group_id = u.user_group )\n" |
2528 . " ON ( g.group_id = u.user_group )\n" |
2529 . " LEFT JOIN " . table_prefix . "group_members AS m\n" |
2529 . " LEFT JOIN " . table_prefix . "group_members AS m\n" |
2530 . " ON ( u.user_id = m.user_id )\n" |
2530 . " ON ( u.user_id = m.user_id AND m.pending < 1 )\n" |
2531 . " LEFT JOIN " . table_prefix . "ranks AS ru\n" |
2531 . " LEFT JOIN " . table_prefix . "ranks AS ru\n" |
2532 . " ON ( u.user_rank = ru.rank_id )\n" |
2532 . " ON ( u.user_rank = ru.rank_id )\n" |
2533 . " LEFT JOIN " . table_prefix . "ranks AS rg\n" |
2533 . " LEFT JOIN " . table_prefix . "ranks AS rg\n" |
2534 . " ON ( g.group_rank = rg.rank_id )\n" |
2534 . " ON ( g.group_rank = rg.rank_id )\n" |
2535 . " LEFT JOIN " . table_prefix . "ranks AS rl\n" |
2535 . " LEFT JOIN " . table_prefix . "ranks AS rl\n" |