Home Ukraine Forum Ukraine Guide Ukraine Resources Real Estate Healthcare in Ukraine
Ukraine
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Ukraine: Expat Blogs & Websites

Submit Your Blog to our Directory (it's free)

Culture-Shock-in-Mogilev-PodilskyiAn Expat Talks about Culture Shock & Living in Mogilev-Podilskyi, Ukraine

An American living in Mogilev-Podilskyi, Ukraine appreciates the friendly Ukranians and how they hang out with one another. One of the biggest shocks he has experienced is how the US government treats him as an expat.

An American living in Mogilev-Podilskyi, Ukraine appreciates the friendly Ukranians and how they hang out with one another. One of the biggest shocks he has experienced is how the US government treat...

Living-in-KievAn Expat Discusses Living in Kiev, Ukraine

One expat describes his expat life in Kiev, Ukraine. From endless corruption to terrible winters, this expat is not enjoying life in Kiev.

One expat describes his expat life in Kiev, Ukraine. From endless corruption to terrible winters, this expat is not enjoying life in Kiev....

10-Tips-for-Living-in-Ukraine10 Tips for Living in Ukraine

Many expats move to Ukraine for its low cost of living. Expats living in Ukraine appreciate that most Ukrainians are salt-of-the-earth, hardworking people. Corruption and bribery are a way of life and expats share their experiences paying bribes.

Many expats move to Ukraine for its low cost of living. Expats living in Ukraine appreciate that most Ukrainians are salt-of-the-earth, hardworking people. Corruption and bribery are a way of lif...

Ukraine Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /rgblogscountry.cfm
Time Stamp 13-Jul-20 09:42 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.217
Host Name 173.245.54.217


Execution Time

Total Time Avg Time Count Template
63 ms 63 ms 1 top level /home/www/html/rgblogscountry.cfm
12 ms 12 ms 1 /home/www/html/navtop_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/Application.cfm
7 ms 7 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navcontentbox.cfm
4 ms 4 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
74 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=1ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 21:42:51.051
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=8ms, Records=1) in /home/www/html/Application.cfm @ 21:42:51.051
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getcatname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rgblogscountry.cfm @ 21:42:51.051
	Select *
	From Categories
	Where categoryid = 84 
getNets (Datasource=expert, Time=2ms, Records=153) in /home/www/html/rgblogscountry.cfm @ 21:42:51.051
		Select DISTINCT Networks.networkname, Networks.id, Networks.networkid as nets,  Networks.networktype, Networks.isCity
		From Networks
		WHERE isCity <> "hold"
		AND networktype <> 2
		AND networktype <> 3
		AND networktype <> 4
		AND networktype <> 5
		AND networkname <> 'national'
		AND networkname <> 'Global Listing'
		AND (isCity = 'Country') 
    	ORDER by isCity, networkname	
getpremium (Datasource=expert, Time=20ms, Records=0) in /home/www/html/rgblogscountry.cfm @ 21:42:51.051
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.description, Resources.homepage
    From Resources, resourcePlacement, resourceCats
    WHERE resourceCats.resourceID = Resources.resourceID 
    
    AND ((resourceCats.categoryID = 84) or (resourceCats.categoryID = 85))
    
	AND ((Resources.type = 'premium') or (Resources.type = 'supaff'))
    and todate > {ts '2020-07-12 21:42:51'}
    and fromdate <{ts '2020-07-13 21:42:51'}
	AND resourcePlacement.networkID = '159'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
getaffiliates (Datasource=expert, Time=14ms, Records=0) in /home/www/html/rgblogscountry.cfm @ 21:42:51.051
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.description, Resources.homepage
    From Resources, resourcePlacement, resourceCats
    WHERE resourceCats.resourceID = Resources.resourceID 
    
    AND ((resourceCats.categoryID = 84) or (resourceCats.categoryID = 85))
    
	and Resources.type  ='affiliate'
	AND resourcePlacement.networkID = '159'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
getfreecountry (Datasource=expert, Time=6ms, Records=0) in /home/www/html/rgblogscountry.cfm @ 21:42:51.051
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.description, Resources.homepage
    From Resources, resourcePlacement, resourceCats
    WHERE resourceCats.resourceID = Resources.resourceID 
    
    AND ((resourceCats.categoryID = 84) or (resourceCats.categoryID = 85))
    
	AND resourceCats.resourceID = Resources.resourceID 
	and Resources.type  ='free'
	and Resources.paid <> 'd' 
	AND resourcePlacement.networkID = '114'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
UpdateImpressions (Datasource=expert, Time=2ms, Records=1) in /home/www/html/rgblogscountry.cfm @ 21:42:51.051
  UPDATE Categories
  SET rgallimpressions = rgallimpressions + 1
  Where categoryid = 84 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:51.051
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:51.051
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 114 
getcities (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:51.051
	Select *
	From citynetworks
	Where networkID = 114
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:51.051
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:42:51.051
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-04-13"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 21:42:51.051
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-07-13 00:00:00.000"
and logtime < "2020-07-13 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 21:42:51.051
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-07-06"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:42:51.051
	SELECT *
	From contentcountcountry
	Where networkid = 114 
gettopbanner (Datasource=expert, Time=3ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 21:42:51.051
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-07-12"
    and fromDate < "2020-07-13"
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 21:42:51.051
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-07-12"
    and fromDate < "2020-07-13"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 21:42:51.051
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
checkculturefeature (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 114 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select summary, hiimg 
		FROM answers
         where answerid = 70518
         and summary <> ''
checklivingfeature (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 114 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select summary, hiimg 
		FROM answers
         where answerid = 43140
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 114 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-13"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=0ms, Records=0, Cached Query) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-13"
     
         and rptarticlenetworks.networkid = 114 
    ORDER by rptarticles.rptarticleID asc   
    


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/rgblogscountry.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/rgblogscountry.cfm
QUERY_STRING=categoryid=84&networkid=114
REMOTE_ADDR=173.245.54.217
REMOTE_HOST=173.245.54.217
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rgblogscountry.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=31846876
cftoken=20106974
sessionid=IBEXPATEXCHANGE.COM_31846876_20106974
urltoken=CFID=31846876&CFTOKEN=20106974
URL Parameters:
categoryid=84
networkid=114
Debug Rendering Time: 13 ms