Solo Swims Statistics 2
The statistics on this page are based on solo Channel swims database compiled by Julian Critchlow. If you can provide any additional information or if you notice any errors or omissions, please contact us or Julian by email published on his website.
List of contents
1. Number of solo crossings
2. Average crossing times
3. Fastest crossing times
4. Crossing times %'s and numbers
5. Miscellaneous
SQL Error: SELECT year, AVG(TIME_TO_SEC(`time`)) AS atm FROM cspf2.solo_swims_database WHERE leg<>'Combined' AND time<>'00:00:00' GROUP BY year ORDER BY year ASC, swim_date ASC
MySQLi Error: Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'cspf2.solo_swims_database.swim_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
MySQLi Error: Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'cspf2.solo_swims_database.swim_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Database query error. Please report this query using system bug-reports.
MySQLi Error: Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'cspf2.solo_swims_database.swim_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
/var/www/vhosts/cspf.co.uk/subdomains/website/code/httpdocs/systems/classes/DB_mysqli.php [299]
#0 /var/www/vhosts/cspf.co.uk/subdomains/website/code/httpdocs/systems/classes/DB_mysqli.php(247): DB_mysqli->_query_error('SELECT year, AV...')
#1 /var/www/vhosts/cspf.co.uk/subdomains/website/code/httpdocs/systems/classes/DB_mysqli.php(548): DB_mysqli->_query('SELECT year, AV...', 0.00049209594726562)
#2 /var/www/vhosts/cspf.co.uk/subdomains/website/code/httpdocs/systems/classes/DB.php(129): DB_mysqli->select('year, AVG(TIME_...', 'cspf2.solo_swim...', 'WHERE leg<>'Com...', '', '', '')
#3 /var/www/vhosts/cspf.co.uk/subdomains/website/code/httpdocs/solo-swims-statistics-2.php(95): DB->select('year, AVG(TIME_...', 'cspf2.solo_swim...', 'WHERE leg<>'Com...')
#4 {main}
SELECT year, AVG(TIME_TO_SEC(`time`)) AS atm FROM cspf2.solo_swims_database WHERE leg<>'Combined' AND time<>'00:00:00' GROUP BY year ORDER BY year ASC, swim_date ASC