Home Japan Forum Japan Guide Moving to Japan Real Estate Healthcare in Japan
Japan
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Expat Guide to Living in Japan

Whether you're already living in Japan or preparing to move to Japan, our Expat Guide to Living in Japan offers articles and reports submitted by expats about expat life in Japan. For answers to specific questions, visit our Japan Forum to talk with expats in Japan.

Moving to Japan

If you're moving to Japan this is a must-read article highlighting tips from expats in Japan. Topics covered include driver's licenses, healthcare in Japan, international schools and more.

Top 10 Tokyo Neighborhoods For Expats

Expats in Tokyo have several neighborhoods worth considering when they move abroad. Individual needs, such as proximity to work, international schools in Tokyo and other factors will help determine the best choice for each expat and expat family.

5 Tips for Living in Tokyo, Japan

Expats in Tokyo enjoy the capital city of Japan, which is a sprawling metropolitan area. Here are some tips to help expats navigate a relocation to one of the biggest economies in the world.

Parenting Style: Far East vs. The West

Author and Blogger Brian O'Sullivan helps expats examine the differences in parenting that exist in Western and Far Eastern cultures. Emotional self-regulation and self-recoginition are a few of the topics he explores.

Expat Healthcare & Health Insurance

Expat Healthcare & Health Insurance in Tokyo

What's the difference between Social Health Insurance and National Health Insurance in Japan? Are there some English-speaking doctors in good hospitals in Tokyo? What's a typical doctor visit like? An expat in Tokyo answers these questions and more.

Culture Shock in Tokyo, Japan

An expat talks about the challenges she's had adjusting to the culture in Japan, where people are much quieter and keep to themselves compared to the US. She explains that even acquaintances keep to themselves and this makes it hard to feel connected.

Culture Shock in Tokyo, Japan

An expat talks about what it's like moving to Tokyo. It took some time adjusting to the crowds and culture, but he's happy now and looking back the culture shock wasn't as bad as he anticipated.

Dream vs Reality of Living in Tokyo , Japan

An expat moved to Japan mentally prepared to face the stages of culture shock and was pleasantly surprised by the warmth of the Japanese culture even in the most crowded places in the city.

More Culture Shock Reports for Japan

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Japan handle it can be very comforting. Below are some of the responses from expats in Japan:
Submit a Culture Shock Report

More Living in Japan Reports

What are people's priorities in Japan - work? family? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Below are some of the responses from expats in Japan:
Submit a Living Overseas Report

More Moving to Japan Reports

What should you take with you when you move to Japan? What should you leave behind? What type of housing and neighborhoods are typical for expats in Japan? Below are some of the responses from expats in Japan:
Submit a Moving Overseas Report

Dream vs. Reality of Living in Japan Reports

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Japan. If you are already living in Japan, share how those "dreams" have been fulfilled, and how they have not. Below are some of the reports from expats in Japan:
Submit a Dream vs. Reality Report

Overseas Retirement Report

Retiring abroad can be a great option for retirees seeking their dream lifestyle at an affordable price. Help other retirees, who are thinking about retiring in Japan by taking our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby in Japan Reports

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Japan? Below are some of the reports from expats in Japan:
Submit a Having a Baby Abroad Report

Working Abroad Report

What's it like to find a job in Japan? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Japan? Help others following in your footsteps by filling out our Working Abroad Report.

Submit a Working Abroad Report
Additional Articles
International Schools in Tokyo, Japan

Tokyo has many international schools and bi-lingual schools for expat students. Here are several of the more popular options.

4 Business Etiquette Tips on Conducting Business in Japan

Newcomers to Japan should consider these 4 tips for conducting business in Japan.

10 Tips for Living in Japan

Did you know that washers and dryers are often placed on the balcony or in the kitchen in Japan? Did you know that trains are the best way to travel in Japan? Expats in Japan share their tips for living in Japan.

Emergency Information for Expats in Japan

Our thoughts and prayers are with those affected by the earthquake and tsunami in Japan. This page provides emergency contact and evacuation information for British, American and Australian expats in Japan.

Tips on Employing Domestic Helpers in Asia

Your feelings about hiring domestic help while living in Asia will range from guilt about having someone ironing your underwear to being deprived of the love and attention of your children. Many Southeast Asian countries show high figures of unemployment and you may not just feel privileged to have maids, but may even feel morally obligated to give work to these people.

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in Japan from our partner, Cigna Global Health.
Get a Quote

Culture-Shock-in-TokyoAn Expat Talks about Culture Shock & Living in Tokyo, Japan

An expat talks about the challenges she's had adjusting to the culture in Japan, where people are much quieter and keep to themselves compared to the US. She explains that even acquaintances keep to themselves and this makes it hard to feel connected.

An expat talks about the challenges she's had adjusting to the culture in Japan, where people are much quieter and keep to themselves compared to the US. She explains that even acquaintances keep to ...

Moving-to-JapanMoving to Japan

If you're moving to Japan this is a must-read article highlighting tips from expats in Japan. Topics covered include driver's licenses, healthcare in Japan, international schools and more.

If you're moving to Japan this is a must-read article highlighting tips from expats in Japan. Topics covered include driver's licenses, healthcare in Japan, international schools and more. ...

Top-10-Tokyo-Neighborhoods-For-ExpatsTop 10 Tokyo Neighborhoods For Expats

Expats in Tokyo have several neighborhoods worth considering when they move abroad. Individual needs, such as proximity to work, international schools in Tokyo and other factors will help determine the best choice for each expat and expat family.

Expats in Tokyo have several neighborhoods worth considering when they move abroad. Individual needs, such as proximity to work, international schools in Tokyo and other factors will help determine t...

Japan 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 /expatguide.cfm
Time Stamp 03-Jun-20 01:45 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.194
Host Name 162.158.78.194


Execution Time

Total Time Avg Time Count Template
355 ms 355 ms 1 /home/www/html/expatguide.cfm
26 ms 26 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
25 ms 25 ms 1 /home/www/html/navcontentbox.cfm
25 ms 25 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
11 ms 11 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/Application.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 0 ms 45 /home/www/html/rewriteqoptionsctry.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 11 /home/www/html/rewritearticle.cfm
0 ms 0 ms 45 /home/www/html/rewritecityname.cfm
0 ms 0 ms 45 /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
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
360 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 01:45:50.050
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 01:45:50.050
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:45:50.050
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:45:50.050
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 61 
getcities (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:45:50.050
	Select *
	From citynetworks
	Where networkID = 61
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:45:50.050
  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
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:45:50.050
	Select *
	From Networks
	Where networkID = 61 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 01:45:50.050
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 61
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:45:50.050
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 61 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:45:50.050
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 01:45:50.050
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-03 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 01:45:50.050
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:45:50.050
	SELECT *
	From contentcountcountry
	Where networkid = 61 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 01:45:50.050
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
    and bannerPlacement.networkid = 61
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 01:45:50.050
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gettaxgeneral (Datasource=expert, Time=6ms, Records=9) in /home/www/html/expatguide.cfm @ 01:45:50.050
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 61 
	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 publishdate < "2020-06-03"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Japan' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 61 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 61 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 61 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 61 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 61 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 61 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=9) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 61 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 61 
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 61 
		order by date DESC
checkmoving (Datasource=expert, Time=6ms, Records=4) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 61 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
      
         and rptarticlenetworks.networkid = 61 
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 61 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 61 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 61 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 61 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=5ms, Records=24) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 61 
   	 order by city, date DESC
         
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 61
and allreports.networkid = 61
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 61
and allreports.networkid = 61
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 61
and allreports.networkid = 61
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 61
and allreports.networkid = 61
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 61
and allreports.networkid = 61
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 61
and allreports.networkid = 61
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 7 
getanswerstext (Datasource=tipripper, Time=5ms, Records=6) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80487
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80487 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 80487
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 80487
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
	SELECT summary
	FROM answers
	WHERE answers.answerid = '80487'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80487'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 224230
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 224230
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 224230
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 224230
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 224230
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80487 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '61'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 01:45:50.050
	SELECT *
	FROM markers
	WHERE answerid = '80487'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 27663 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25354 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76452 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76451 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 682 
getsummary (Datasource=reports, Time=2ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76487 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 01:45:50.050
	Select *
	From Networks
	Where networkID = 61 
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 16095
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 71967
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 3165
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 2910
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 240
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 68943
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 23303
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 23710
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 70859
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 37652
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 37622
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 37396
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25641
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10073
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 1935
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26897
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10968
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10153
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26110
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 283
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 250
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 243
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 237
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 01:45:50.050
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 68886
				AND answerstext.qid = 82
					
checkculturefeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentbox.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 61 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:45:50.050
		Select summary, hiimg 
		FROM answers
         where answerid = 76452
         and summary <> ''
checklivingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 01:45:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 61 
        and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 01:45:50.050
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 61 
	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-06-03"

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 01:45:50.050
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 61 
    ORDER by rptarticles.rptarticleID desc
    


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/expatguide.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/expatguide.cfm
QUERY_STRING=networkID=61
REMOTE_ADDR=162.158.78.194
REMOTE_HOST=162.158.78.194
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expatguide.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=28915331
cftoken=36174102
sessionid=IBEXPATEXCHANGE.COM_28915331_36174102
urltoken=CFID=28915331&CFTOKEN=36174102
URL Parameters:
networkID=61
Debug Rendering Time: 11 ms