Skip to content

Instantly share code, notes, and snippets.

@Ashoat

Ashoat/code_versions.log Secret

Created July 16, 2023 01:41
Show Gist options
  • Save Ashoat/53b57ca1eb81fe9db8550960fda5f1a8 to your computer and use it in GitHub Desktop.
Save Ashoat/53b57ca1eb81fe9db8550960fda5f1a8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
code_versions.log
MariaDB [comm]> SELECT COUNT(id), platform, JSON_EXTRACT(versions, '$.codeVersion') AS code_version FROM cookies GROUP BY JSON_EXTRACT(versions, '$.codeVersion'), platform;
+-----------+----------+--------------+
| COUNT(id) | platform | code_version |
+-----------+----------+--------------+
| 3025 | NULL | NULL |
| 2120 | web | NULL |
| 3 | macos | 10 |
| 30 | web | 10 |
| 2 | windows | 10 |
| 1 | ios | 128 |
| 2 | ios | 131 |
| 2 | android | 159 |
| 1 | ios | 159 |
| 2 | ios | 193 |
| 3 | web | 2 |
| 1 | android | 207 |
| 2 | android | 217 |
| 1 | ios | 218 |
| 6 | android | 223 |
| 11 | ios | 223 |
| 1 | android | 224 |
| 2 | ios | 224 |
| 5 | android | 225 |
| 17 | ios | 225 |
| 9 | android | 226 |
| 1 | ios | 226 |
| 34 | android | 227 |
| 56 | ios | 227 |
| 4 | android | 228 |
| 2 | ios | 228 |
| 4 | android | 229 |
| 1 | ios | 229 |
| 13 | android | 230 |
| 10 | ios | 230 |
| 1 | ios | 232 |
| 2 | macos | 3 |
| 3 | web | 3 |
| 1 | windows | 3 |
| 1 | macos | 4 |
| 1 | macos | 5 |
| 14 | web | 5 |
| 1 | windows | 5 |
| 11 | web | 6 |
| 5 | web | 7 |
| 1 | macos | 8 |
| 10 | web | 8 |
| 1 | macos | 9 |
| 11 | web | 9 |
+-----------+----------+--------------+
44 rows in set (0.032 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment