Home United States Forum United States Guide Moving to United States Real Estate Healthcare in United States
United States
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Expat Guide to Living in Saipan

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

The Truth About Saipan

With its year-round tropical weather, world class shore diving and rich cultural diversity, Saipan is a destination worth discovering.

Expat Healthcare & Health Insurance

Expat Healthcare & Health Insurance in Saipan

An expat in Saipan talks about the limited access to quality healthcare in Saipan. Most people travel to Guam or the Philippines for medical issues and care, because the only hospital in Saipan is a mess. She would advise those with serious medical issues to avoid moving to Saipan.

Living in Saipan, United States

An expat in Saipan advises newcomers to expect to feel isolated, bring enough money for plane tickets for an emergency, learn to snorkel, bring a camera and enjoy the lovely people and beautiful Saipan.

Culture Shock Report

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Saipan handle it can be very comforting. Help others preparing to move to Saipan by filling out our Culture Shock Report.

Submit a Culture Shock Report

More Living in Saipan Reports

What are people's priorities in Saipan - work? family? socializing? 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 Saipan:
Submit a Living Overseas Report

Moving Overseas Report

What should you take with you when you move to Saipan? What should you leave behind? What type of housing and neighborhoods are typical for expats in Saipan? Help others moving to Saipan by filling out our Moving Overseas Report.

Submit a Moving Overseas Report

International School Report

Parents are invited to answer questions about the schools that their kids attend (Pre-K through High School) in hopes of helping others moving to Saipan with the school selection process. If you have expat children who attend school in Saipan, take a few minutes to submit a School Review.

Submit an International School Review

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Saipan. If you are already living in Saipan, share how those "dreams" have been fulfilled, and how they have not by filling out our Dream vs. Reality Report.

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 Saipan by filling out our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby Abroad Report

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Saipan? Help other expats who are preparing to have a baby in Saipan by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working Abroad Report

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

Submit a Working Abroad Report
Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-Northern-VirginiaAn Expat Talks about Culture Shock & Living in Northern Virginia, US

Be as open and as friendly as you can be. You may find friends that are a different age or nationality from those you had at home. Treat yourself to the odd magazine or candy from your home country and skype.

Be as open and as friendly as you can be. You may find friends that are a different age or nationality from those you had at home. Treat yourself to the odd magazine or candy from your home country an...

Living-in-SaipanAn Expat Discusses Living in Saipan, United States

An expat in Saipan advises newcomers to expect to feel isolated, bring enough money for plane tickets for an emergency, learn to snorkel, bring a camera and enjoy the lovely people and beautiful Saipan.

An expat in Saipan advises newcomers to expect to feel isolated, bring enough money for plane tickets for an emergency, learn to snorkel, bring a camera and enjoy the lovely people and beautiful Saipa...

Health-Care-in-New-York-CityHealth Care in New York City

New York City is widely regarded as one of the best places in the world for specialized health care. Here are some important medical resources for expats living in New York City.

New York City is widely regarded as one of the best places in the world for specialized health care. Here are some important medical resources for expats living in New York City....

Healthcare-in-BostonHealthcare in Boston

Expats in Boston have access to excellent healthcare and hospitals attached to the best medical schools in the world. As with other parts of the U.S., it's imperative to know your coverage before you access any kind of care or purchase prescription medication.

Expats in Boston have access to excellent healthcare and hospitals attached to the best medical schools in the world. As with other parts of the U.S., it's imperative to know your coverage before you...

United States 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 11-Jul-20 04:31 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.79.9
Host Name 162.158.79.9


Execution Time

Total Time Avg Time Count Template
229 ms 229 ms 1 top level /home/www/html/expatguide.cfm
26 ms 26 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
24 ms 24 ms 1 /home/www/html/navcontentbox.cfm
24 ms 24 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/navtop_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/Application.cfm
5 ms 5 ms 1 /home/www/html/navmeta_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.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/eetr/rewritetipheading.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 4 /home/www/html/rewritecityname.cfm
0 ms 0 ms 4 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 4 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
238 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 @ 16:31:15.015
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=5ms, Records=1) in /home/www/html/Application.cfm @ 16:31:15.015
      	  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 @ 16:31:15.015
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 16:31:15.015
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 129 
getcities (Datasource=expert, Time=2ms, Records=19) in /home/www/html/navmeta_rdesign4.cfm @ 16:31:15.015
	Select *
	From citynetworks
	Where networkID = 129
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 16:31:15.015
	Select *
	From citynetworks
	Where citynetworkid = 6004 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 16:31:15.015
  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 @ 16:31:15.015
	Select *
	From Networks
	Where networkID = 129 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 16:31:15.015
	Select *
	From countryphotos
	Where networkID = 129
	and citynetworkid = 6004 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 16:31:15.015
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-04-11"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 16:31:15.015
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-11 00:00:00.000"
and logtime < "2020-07-11 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 @ 16:31:15.015
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-04"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 16:31:15.015
	SELECT *
	From contentcountcountry
	Where networkid = 129 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 16:31:15.015
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-10"
    and fromDate < "2020-07-11"
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 16:31:15.015
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:15.015
	Select *
	From citynetworks 
	Where citynetworkid = 6004 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:15.015
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 129 
 	and articlecityplace.citynetworkid = 6004
    AND articlecityplace.articleID = articles.articleID
	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 summary <> ''
    and publishdate < "2020-07-11"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Saipan%') OR (author LIKE '%Saipan%') OR (hitopic LIKE '%Saipan%') OR (hidescript LIKE '%Saipan%')))
	and articlePlacement.networkID = 129 
	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 summary <> ''
    and author <> 'Expat Exchange Member'
   and author <> 'ExpatExchange Member'
      and author <> 'ExpatExchange.com Member'
    and publishdate < "2020-07-11"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT qoid, value 
FROM qoptions 

WHERE value = 'US' 

and qid = 46
checkretirefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 129 
         and citynetworkid = 6004 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 129 
         and citynetworkid = 6004 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 129 
         and citynetworkid = 6004 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 129 
         and citynetworkid = 6004 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 129 
         and citynetworkid = 6004 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 129 
         and citynetworkid = 6004 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 129 
         and citynetworkid = 6004 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 129 
         and citynetworkid = 6004 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 129 
         and citynetworkid = 6004 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 129 
         and citynetworkid = 6004 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 129 
         and citynetworkid = 6004 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 129 
         and citynetworkid = 6004 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 129 
         and citynetworkid = 6004 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 129 
         and citynetworkid = 6004 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74124 
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=7) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 129
and allreports.networkid = 129
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 129
and allreports.networkid = 129
 and allreports.citynetworkid2 =  6004
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 129
and allreports.networkid = 129
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 129
and allreports.networkid = 129
 and allreports.citynetworkid2 =  6004
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=14ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 129
and allreports.networkid = 129
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 129
and allreports.networkid = 129
 and allreports.citynetworkid2 =  6004
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 @ 16:31:16.016
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=4ms, Records=5) in /home/www/html/expatguide.cfm @ 16:31:16.016
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 = 79205
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 79205 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79205
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79205
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79205'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79205'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 176704
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 176704
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 176704
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 176704
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 176704
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79205 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '129'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 16:31:16.016
	SELECT *
	FROM markers
	WHERE answerid = '79205'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:31:16.016
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 74124 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 16:31:16.016
	Select *
	From Networks
	Where networkID = 129 
checkculturefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 129 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 16:31:16.016
		Select summary, hiimg 
		FROM answers
         where answerid = 44140
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 16:31:16.016
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 129 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 16:31:16.016
		Select summary, hiimg 
		FROM answers
         where answerid = 74124
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 16:31:16.016
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 129 
	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-11"

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 16:31:16.016
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-11"
     
         and rptarticlenetworks.networkid = 129 
    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=129&citynetworkid=6004
REMOTE_ADDR=162.158.79.9
REMOTE_HOST=162.158.79.9
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=31706194
cftoken=22215569
sessionid=IBEXPATEXCHANGE.COM_31706194_22215569
urltoken=CFID=31706194&CFTOKEN=22215569
URL Parameters:
citynetworkid=6004
networkid=129
Debug Rendering Time: 11 ms