Line 53:    		left join tripnote tn on tn.id = tc.tripnote_id
Line 54:    		where tn.status = ".TripnoteStatus::Published."
Line 55:    		and c.region_id = ".((int)$intRegionId)."
Line 56:    		group by c.id
Line 57:    		order by c.name asc";
Line 58:    		$objResult = Data::Query($strQuery);
Line 59:    		if ($objResult) {
Line 60:    			while ($mixRow = $objResult->FetchArray()) {
Line 61:    				$dto = new CountryDto();
Line 62:    				$dto->strName = $mixRow['name'];
Line 63:    				$dto->intId = $mixRow['id'];

select
		c.*, ifnull(ct.value, c.name) as name,
		count(distinct tn.id) as tripnote_count
		from country c
		left join country_translation ct on ct.country_id = c.id and ct.language_id = 1
		left join tripnote_country_v tc on tc.country_id = c.id
		left join tripnote tn on tn.id = tc.tripnote_id
		where tn.status = 2
		and c.region_id = 2
		group by c.id
		order by c.name asc

#0 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/Data.class.php(23): QMySqli5Database->Query('select\n\t\tc.*, i...')
#1 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/region/RegionUtil.class.php(58): Data::Query('select\n\t\tc.*, i...')
#2 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/region/RegionUtil.class.php(21): RegionUtil::GetCountryDtoArrayByRegionId('2')
#3 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/region/RegionPanel.class.php(25): RegionUtil::GetRegionDtoById('2')
#4 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/ReisiveebForm.class.php(78): RegionPanel->Initialize()
#5 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/ReisiveebForm.class.php(30): ReisiveebForm->PageOperation()
#6 /www/apache/domains/www.reisiveeb.ee/htdocs/lib/includes/qcodo/_core/qform/QFormBase.class.php(276): ReisiveebForm->Form_Create()
#7 /www/apache/domains/www.reisiveeb.ee/htdocs/index.php(70): QFormBase::Run('ReisiveebPublic...', '/www/apache/dom...')
#8 {main}

  _COOKIE
array (
)
  _FILES
array (
)
  _GET
array (
)
  _POST
array (
)
  _SERVER
array (
  'HOME' => '/www/apache/domains/www.reisiveeb.ee/./htdocs',
  'USER' => 'vhost8683f0',
  'PATH_TRANSLATED' => '/www/apache/domains/www.reisiveeb.ee/htdocs/regioon/Aafrika/2',
  'PATH_INFO' => '/regioon/Aafrika/2',
  'SCRIPT_NAME' => '/index.php',
  'REQUEST_URI' => '/index.php/regioon/Aafrika/2',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REMOTE_PORT' => '27474',
  'SCRIPT_FILENAME' => '/www/apache/domains/www.reisiveeb.ee/htdocs/index.php',
  'SERVER_ADMIN' => 'abi@elkdata.com',
  'CONTEXT_DOCUMENT_ROOT' => '/www/apache/domains/www.reisiveeb.ee/htdocs',
  'CONTEXT_PREFIX' => '',
  'REQUEST_SCHEME' => 'http',
  'DOCUMENT_ROOT' => '/www/apache/domains/www.reisiveeb.ee/htdocs',
  'REMOTE_ADDR' => '3.148.241.210',
  'SERVER_PORT' => '80',
  'SERVER_ADDR' => '185.7.252.111',
  'SERVER_NAME' => 'www.reisiveeb.ee',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_SIGNATURE' => '',
  'LD_LIBRARY_PATH' => '/usr/local/lib',
  'PATH' => '/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin',
  'HTTP_HOST' => 'www.reisiveeb.ee',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_ACCEPT' => '*/*',
  'protossl' => '',
  'SCRIPT_URI' => 'http://www.reisiveeb.ee/index.php/regioon/Aafrika/2',
  'SCRIPT_URL' => '/index.php/regioon/Aafrika/2',
  'UNIQUE_ID' => 'aB2xjWWGFF6rqOIqDj7seQAAAyw',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/index.php/regioon/Aafrika/2',
  'REQUEST_TIME_FLOAT' => 1746776461.979712009429931640625,
  'REQUEST_TIME' => 1746776461,
  'argv' => 
  array (
  ),
  'argc' => 0,
)