Debug: Siko Data Investigation
1. Peserta Records for 'Siko'
| ID | Nama | Club | Gender |
|---|
| 17 | siko | independent | Laki-laki |
2. Score Records linked to 'Siko'
No score records found for Siko!
3. Dashboard Query Result (current logic)
| Nama | Total Turnamen | Avg Rank | Juara1 | Juara2 | Juara3 | All Ranks |
|---|
| siko | 5 | 1.0000 | 5 | 0 | 0 | 1,1,1,1,1 |
4. Statistik Query Result (source of truth)
| Peserta ID | Nama | Scoreboard | Rank | Total Participants |
|---|
| 17 | siko | 31 | 1 | 5 |
| 17 | siko | 15 | 1 | 10 |
| 17 | siko | 14 | 1 | 10 |
| 17 | siko | 9 | 1 | 10 |
| 17 | siko | 8 | 1 | 10 |
Juara 1 count from Statistik logic: 5
5. Similar Names Check
- siko
- Faidhan Audisepta djatmiko
6. Raw peserta_id check in score table
| Peserta ID | Nama | Club |
|---|
| 17 | siko | independent |
7. EXACT statistik.php allRankings Query
EXACT statistik.php query returns NO ROWS for Siko!
This means the JOINs to kegiatan/categories/score_boards are FAILING.
8. Check Siko's score records for kegiatan_id/category_id
| Scoreboard ID | Kegiatan ID | Category ID | Kegiatan Exists? | Category Exists? | Scoreboard Exists? |
|---|
| 15 | 11 | 2 | ✓ | ✓ | ✗ NULL |
| 14 | 11 | 2 | ✓ | ✓ | ✗ NULL |
| 9 | 11 | 2 | ✓ | ✓ | ✗ NULL |
| 8 | 11 | 2 | ✓ | ✓ | ✗ NULL |
| 31 | 11 | 2 | ✓ | ✓ | ✗ NULL |