Raw Combo League Results 10_19_06

See blogmic encounter for the standings

| 387264 | 2006-10-19 17:47:35 | 2006-10-19 18:06:25 | Sleepy Weasel | yes | 0 | 1 | tri | 1 |
| 387264 | 2006-10-19 17:47:35 | 2006-10-19 18:06:25 | Zoot Koomie | yes | 0 | 1 | wil | 0 |
| 387264 | 2006-10-19 17:47:35 | 2006-10-19 18:06:25 | amatecon | yes | 0 | 1 | pac | 0 |
| 387264 | 2006-10-19 17:47:35 | 2006-10-19 18:06:25 | Chavezelron | yes | 0 | 1 | ant | 0 |

| 387265 | 2006-10-19 17:49:27 | 2006-10-19 18:09:18 | Greg | yes | 0 | 1 | pac | 1 |
| 387265 | 2006-10-19 17:49:27 | 2006-10-19 18:09:18 | tmax | yes | 0 | 1 | tri | 0 |
| 387265 | 2006-10-19 17:49:27 | 2006-10-19 18:09:18 | Garvoid | yes | 0 | 1 | ant | 0 |
| 387265 | 2006-10-19 17:49:27 | 2006-10-19 18:09:18 | IOException | yes | 0 | 1 | wil | 0 |

| 387266 | 2006-10-19 17:49:28 | 2006-10-19 18:09:24 | Peter | yes | 0 | 1 | wil | 1 |
| 387266 | 2006-10-19 17:49:28 | 2006-10-19 18:09:24 | Krakit | yes | 0 | 1 | tri | 0 |
| 387266 | 2006-10-19 17:49:28 | 2006-10-19 18:09:24 | AP | yes | 0 | 1 | ant | 0 |
| 387266 | 2006-10-19 17:49:28 | 2006-10-19 18:09:24 | TheDukester | yes | 0 | 1 | pac | 0 |

| 387273 | 2006-10-19 18:18:31 | 2006-10-19 18:28:01 | TheDukester | yes | 0 | 1 | pac | 1 |
| 387273 | 2006-10-19 18:18:31 | 2006-10-19 18:28:01 | Sarry | yes | 0 | 1 | ant | 0 |
| 387273 | 2006-10-19 18:18:31 | 2006-10-19 18:28:01 | no | no | 0 | 5 | TRIBOT | 0 |
| 387273 | 2006-10-19 18:18:31 | 2006-10-19 18:28:01 | tmax | yes | 0 | 1 | wil | 0 |

| 387271 | 2006-10-19 18:16:19 | 2006-10-19 18:32:00 | Krakit | yes | 0 | 1 | ant | 1 |
| 387271 | 2006-10-19 18:16:19 | 2006-10-19 18:32:00 | Garvoid | yes | 0 | 1 | pac | 0 |
| 387271 | 2006-10-19 18:16:19 | 2006-10-19 18:32:00 | Zoot Koomie | yes | 0 | 1 | wil | 0 |
| 387271 | 2006-10-19 18:16:19 | 2006-10-19 18:32:00 | Sleepy Weasel | yes | 0 | 1 | tri | 0 |

| 387270 | 2006-10-19 18:13:48 | 2006-10-19 18:33:35 | IOException | yes | 0 | 1 | ant | 1 |
| 387270 | 2006-10-19 18:13:48 | 2006-10-19 18:33:35 | AP | yes | 0 | 1 | tri | 0 |
| 387270 | 2006-10-19 18:13:48 | 2006-10-19 18:33:35 | Peter | yes | 0 | 1 | pac | 0 |
| 387270 | 2006-10-19 18:13:48 | 2006-10-19 18:33:35 | Chavezelron | yes | 0 | 1 | wil | 0 |

| 387276 | 2006-10-19 18:40:24 | 2006-10-19 18:54:51 | tmax | yes | 0 | 1 | tri | 1 |
| 387276 | 2006-10-19 18:40:24 | 2006-10-19 18:54:51 | Zoot Koomie | yes | 0 | 1 | pac | 0 |
| 387276 | 2006-10-19 18:40:24 | 2006-10-19 18:54:51 | Greg | yes | 0 | 1 | wil | 0 |
| 387276 | 2006-10-19 18:40:24 | 2006-10-19 18:54:51 | Williamson | yes | 0 | 1 | ant | 0 |

| 387275 | 2006-10-19 18:39:05 | 2006-10-19 19:03:59 | Sleepy Weasel | yes | 0 | 1 | wil | 1 |
| 387275 | 2006-10-19 18:39:05 | 2006-10-19 19:03:59 | Garvoid | yes | 0 | 1 | pac | 0 |
| 387275 | 2006-10-19 18:39:05 | 2006-10-19 19:03:59 | Peter | yes | 0 | 1 | ant | 0 |
| 387275 | 2006-10-19 18:39:05 | 2006-10-19 19:03:59 | TheDukester | yes | 0 | 1 | tri | 0 |

| 387278 | 2006-10-19 18:43:23 | 2006-10-19 19:05:51 | IOException | yes | 0 | 1 | tri | 3 |
| 387278 | 2006-10-19 18:43:23 | 2006-10-19 19:05:51 | no | no | 0 | 2 | WILBOT | 3 |
| 387278 | 2006-10-19 18:43:23 | 2006-10-19 19:05:51 | Chavezelron | yes | 0 | 1 | pac | 3 |
| 387278 | 2006-10-19 18:43:23 | 2006-10-19 19:05:51 | Krakit | yes | 0 | 1 | ant | 0 |

| 387285 | 2006-10-19 19:13:23 | 2006-10-19 19:27:44 | IOException | yes | 0 | 1 | pac | 1 |
| 387285 | 2006-10-19 19:13:23 | 2006-10-19 19:27:44 | Zoot Koomie | yes | 0 | 1 | wil | 0 |
| 387285 | 2006-10-19 19:13:23 | 2006-10-19 19:27:44 | TheDukester | yes | 0 | 1 | tri | 0 |
| 387285 | 2006-10-19 19:13:23 | 2006-10-19 19:27:44 | Chavezelron | yes | 0 | 1 | ant | 0 |

| 387284 | 2006-10-19 19:10:09 | 2006-10-19 19:40:29 | Williamson | yes | 0 | 1 | tri | 1 |
| 387284 | 2006-10-19 19:10:09 | 2006-10-19 19:40:29 | Mesmer69 | yes | 0 | 1 | ant | 0 |
| 387284 | 2006-10-19 19:10:09 | 2006-10-19 19:40:29 | no | no | 0 | 5 | WILBOT | 0 |
| 387284 | 2006-10-19 19:10:09 | 2006-10-19 19:40:29 | Peter | yes | 0 | 1 | pac | 0 |

| 387287 | 2006-10-19 19:15:44 | 2006-10-19 19:53:39 | AP | yes | 0 | 1 | tri | 1 |
| 387287 | 2006-10-19 19:15:44 | 2006-10-19 19:53:39 | Krakit | yes | 0 | 1 | wil | 0 |
| 387287 | 2006-10-19 19:15:44 | 2006-10-19 19:53:39 | no | no | 0 | 5 | PACBOT | 0 |
| 387287 | 2006-10-19 19:15:44 | 2006-10-19 19:53:39 | Sleepy Weasel | yes | 0 | 1 | ant | 0 |

| 387300 | 2006-10-19 19:53:40 | 2006-10-19 20:05:01 | no | no | 0 | 5 | TRIBOT | 1 |
| 387300 | 2006-10-19 19:53:40 | 2006-10-19 20:05:01 | Mesmer69 | yes | 0 | 1 | pac | 0 |
| 387300 | 2006-10-19 19:53:40 | 2006-10-19 20:05:01 | tmax | yes | 0 | 1 | ant | 0 |
| 387300 | 2006-10-19 19:53:40 | 2006-10-19 20:05:01 | Williamson | yes | 0 | 1 | wil | 0 |

| 387304 | 2006-10-19 20:10:33 | 2006-10-19 20:25:48 | Williamson | yes | 0 | 1 | pac | 1 |
| 387304 | 2006-10-19 20:10:33 | 2006-10-19 20:25:48 | IOException | yes | 0 | 1 | wil | 0 |
| 387304 | 2006-10-19 20:10:33 | 2006-10-19 20:25:48 | Mesmer69 | yes | 0 | 1 | ant | 0 |
| 387304 | 2006-10-19 20:10:33 | 2006-10-19 20:25:48 | Sleepy Weasel | yes | 0 | 1 | tri | 0 |

| 387307 | 2006-10-19 20:30:33 | 2006-10-19 20:51:26 | Sleepy Weasel | yes | 0 | 1 | pac | 1 |
| 387307 | 2006-10-19 20:30:33 | 2006-10-19 20:51:26 | Williamson | yes | 0 | 1 | ant | 0 |
| 387307 | 2006-10-19 20:30:33 | 2006-10-19 20:51:26 | TheDukester | yes | 0 | 1 | wil | 0 |
| 387307 | 2006-10-19 20:30:33 | 2006-10-19 20:51:26 | IOException | yes | 0 | 1 | tri | 0 |

Advertisements
Explore posts in the same categories: League

2 Comments on “Raw Combo League Results 10_19_06”

  1. Sleepy Weasel Says:

    So what do those columns mean?

  2. pgocosmic Says:

    game session ID || start time || end time || player name || is member? || is guest? | is bot? || alien || win ||

    select a.gses_id as ‘game id’, a.gses_start_datetime as ‘start’, a.gses_end_datetime as ‘end’, if(b.gsd_player_id = 1, ‘no’, c.player_name) as ‘player’, if(d.member_id > 1 and d.member_is_approved = 1, ‘yes’, ‘no’) as ‘active’, b.gsd_guest_number as ‘guest’, b.gsd_bot_id as ‘bot’, if(b.gsd_bot_id != 1, concat(ucase(b.gsd_alien_code),’BOT’), b.gsd_alien_code) as ‘alien’, b.gsd_win_code as ‘win code’from game_session a left join game_session_detail b on a.gses_id = b.gsd_gses_id left join player c on b.gsd_player_id = c.player_id left join member d on b.gsd_player_id = d.member_player_id where to_days(gses_end_datetime) = to_days(current_timestamp) – 1 and hour(gses_start_datetime) between 17 and 20 and hour(gses_end_datetime) between 17 and 22 order by gses_end_datetime asc, b.gsd_win_code desc;


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: