SELECT runs.date, users.name, runs.running, runs.walking
FROM runs JOIN users ON users.id = runs.userid ORDER BY runs.date DESC
LIMIT ? OFFSET ?
| DATE | NAME | RUNNING | WALKING |
|---|---|---|---|
| 2026-07-22 | nowster | 10200 | 0 |
| 2023-04-22 | nowster | 6000 | 0 |
| 2023-04-21 | RunaroundSue | 0 | 11000 |
| 2023-04-20 | nowster | 3220 | 0 |
| 2023-04-19 | nowster | 10000 | 0 |
| 2023-04-18 | IloveParkruns | 19000 | 4000 |
| 2023-04-18 | RandomHiker | 100000 | 100000 |
| 2023-04-18 | nowster | 5000 | 1460 |
| 2023-04-17 | IloveParkruns | 13000 | 3200 |
| 2023-04-17 | RandomHiker | 19000 | 1800 |
| 2023-04-16 | IloveParkruns | 8000 | 3000 |
| 2023-04-16 | RandomHiker | 3000 | 1100 |
| 2023-04-15 | IloveParkruns | 0 | 4200 |
| 2023-04-15 | RandomHiker | 19000 | 3500 |
| 2023-04-15 | RunaroundSue | 5000 | 0 |
| 2023-04-14 | RandomHiker | 6000 | 3000 |
| 2023-04-14 | IloveParkruns | 80000 | 1550 |
| 2023-04-13 | IloveParkruns | 0 | 1300 |
| 2023-04-13 | RandomHiker | 16000 | 2700 |
| 2023-04-12 | IloveParkruns | 7000 | 1000 |
| 2023-04-12 | RandomHiker | 10000 | 2000 |
| 2023-04-11 | IloveParkruns | 0 | 4600 |
| 2023-04-11 | RandomHiker | 1000 | 3400 |
| 2023-04-10 | IloveParkruns | 17000 | 4100 |
| 2023-04-10 | RandomHiker | 19000 | 3300 |