001

SET 
    NAMES "utf8" COLLATE "utf8_general_ci"

execution time: 0.000 seconds (30.13%)
affected rows: 0
backtrace
to the top
close all

File	Function	Line
/home/nadac1/public_html/administration/database/Zebra_Database.php	query()	3477
/home/nadac1/public_html/administration/champs/standings-group.php	set_charset()	34

002

SELECT 
    champsRuns.entry_id, 
    sum(score) AS total, 
    champsEntries.callname, 
    champsEntries.handler, 
    champsEntries.group_id, 
    champsEntries.regional_bye 
FROM 
    champsRuns 
    INNER JOIN `champsEntries` ON champsRuns.entry_id = champsEntries.id 
WHERE 
    (champsRuns.round_id < 14) 
GROUP BY 
    entry_id 
ORDER BY 
    champsEntries.group_id ASC, 
    total DESC

execution time: 0.000 seconds (69.87%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	champsEntries	ALL	PRIMARY				1	100.00	Using temporary; Using filesort
1	SIMPLE	champsRuns	ALL					5580	100.00	Using where; Using join buffer (flat, BNL join)

File	Function	Line
/home/nadac1/public_html/administration/champs/standings-group.php	query()	54

001	The "memcache" extension is available on you server - consider using memcache for caching query results. See the documentation for more information. to the top close all

001	$_POST array ( )

001	$_GET array ( )

001	$_SESSION array ( )

001	$_FILES array ( )

001

$_SERVER

array (
  'CONTEXT_DOCUMENT_ROOT' => '/home/nadac1/public_html',
  'CONTEXT_PREFIX' => '',
  'DOCUMENT_ROOT' => '/home/nadac1/public_html',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'HTTP_ACCEPT' => '*/*',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'HTTP_AUTHORIZATION' => '',
  'HTTP_CACHE_CONTROL' => 'max-age=259200',
  'HTTP_CONNECTION' => 'keep-alive',
  'HTTP_HOST' => 'www.nadac.com',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_VIA' => '1.1 squid-proxy-5b5d847c96-vgtzk (squid/6.10)',
  'HTTP_X_FORWARDED_FOR' => '10.2.14.2',
  'PATH' => '/bin:/usr/bin',
  'PHP_INI_SCAN_DIR' => '/opt/cpanel/ea-php73/root/etc:/opt/cpanel/ea-php73/root/etc/php.d:.',
  'QUERY_STRING' => '',
  'REDIRECT_STATUS' => '200',
  'REMOTE_ADDR' => '216.73.216.135',
  'REMOTE_PORT' => '2223',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_SCHEME' => 'http',
  'REQUEST_URI' => '/administration/champs/standings-group.php',
  'SCRIPT_FILENAME' => '/home/nadac1/public_html/administration/champs/standings-group.php',
  'SCRIPT_NAME' => '/administration/champs/standings-group.php',
  'SCRIPT_URI' => 'http://www.nadac.com/administration/champs/standings-group.php',
  'SCRIPT_URL' => '/administration/champs/standings-group.php',
  'SERVER_ADDR' => '67.227.174.58',
  'SERVER_ADMIN' => 'webmaster@nadac.com',
  'SERVER_NAME' => 'www.nadac.com',
  'SERVER_PORT' => '80',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'TZ' => 'America/Detroit',
  'UNIQUE_ID' => 'aKFtWlgIsWe-WISavso-mgAAAQQ',
  'PHP_SELF' => '/administration/champs/standings-group.php',
  'REQUEST_TIME_FLOAT' => 1755409754.241344928741455078125,
  'REQUEST_TIME' => 1755409754,
  'argv' => 
  array (
  ),
  'argc' => 0,
)

Standings By Group