Line 160:    				left join tripnote_country_v tc on tc.country_id = c.id
Line 161:    				left join tripnote t on tc.tripnote_id = t.id and t.status = ".TripnoteStatus::Published."
Line 162:    				where t.id is not null
Line 163:    				group by r.id
Line 164:    				order by r.name";
Line 165:    			$this->mixRegionArray = Data::GetArray($strQuery);
Line 166:    		}
Line 167:    		return $this->mixRegionArray;
Line 168:    	}
Line 169:    
Line 170:    	protected function lnkChooseCountry_Create() {

select r.id, ifnull(rt.value, r.name) as name
				from region r
				left join region_translation rt on rt.region_id = r.id and rt.language_id = 1
				inner join country c on c.region_id = r.id
				left join tripnote_country_v tc on tc.country_id = c.id
				left join tripnote t on tc.tripnote_id = t.id and t.status = 2
				where t.id is not null
				group by r.id
				order by r.name

#0 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/Data.class.php(23): QMySqli5Database->Query('select r.id, if...')
#1 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/Data.class.php(40): Data::Query('select r.id, if...')
#2 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/common/MenuTopPanel.class.php(165): Data::GetArray('select r.id, if...')
#3 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/common/MenuTopPanel.class.php(218): MenuTopPanel->GetRegionArray()
#4 /www/apache/domains/www.reisiveeb.ee/htdocs/app/public/common/MenuTopPanel.class.php(112): MenuTopPanel->GetRegionTipBoxHtml()
#5 /www/apache/domains/www.reisiveeb.ee/htdocs/index.php(58): MenuTopPanel->Initialize()
#6 /www/apache/domains/www.reisiveeb.ee/htdocs/app/common/ReisiveebForm.class.php(31): ReisiveebPublicForm->PreRender()
#7 /www/apache/domains/www.reisiveeb.ee/htdocs/lib/includes/qcodo/_core/qform/QFormBase.class.php(276): ReisiveebForm->Form_Create()
#8 /www/apache/domains/www.reisiveeb.ee/htdocs/index.php(70): QFormBase::Run('ReisiveebPublic...', '/www/apache/dom...')
#9 {main}

  _COOKIE
array (
)
  _FILES
array (
)
  _GET
array (
)
  _POST
array (
)
  _SERVER
array (
  'HOME' => '/www/apache/domains/www.reisiveeb.ee/./htdocs',
  'USER' => 'vhost8683f0',
  'SCRIPT_NAME' => '/index.php',
  'REQUEST_URI' => '/',
  'QUERY_STRING' => '',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/2.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REMOTE_PORT' => '4685',
  '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' => 'https',
  'DOCUMENT_ROOT' => '/www/apache/domains/www.reisiveeb.ee/htdocs',
  'REMOTE_ADDR' => '18.191.160.52',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '185.7.252.111',
  'SERVER_NAME' => 'reisiveeb.ee',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_SIGNATURE' => '',
  'LD_LIBRARY_PATH' => '/usr/local/lib:/usr/local/lib',
  'PATH' => '/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin',
  'HTTP_HOST' => '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' => '*/*',
  'H2_STREAM_TAG' => '92603-192-5',
  'H2_STREAM_ID' => '5',
  'H2_PUSHED_ON' => '',
  'H2_PUSHED' => '',
  'H2_PUSH' => 'off',
  'H2PUSH' => 'off',
  'HTTP2' => 'on',
  'SSL_TLS_SNI' => 'reisiveeb.ee',
  'HTTPS' => 'on',
  'protossl' => 's',
  'SCRIPT_URI' => 'https://reisiveeb.ee/',
  'SCRIPT_URL' => '/',
  'UNIQUE_ID' => 'Z-9aMIh04Y_xC0uJXeNbxgAAHAw',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1743739440.6004679203033447265625,
  'REQUEST_TIME' => 1743739440,
  'argv' => 
  array (
  ),
  'argc' => 0,
)