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

Expat Guide to Living in San Juan del Sur

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

Culture Shock Report

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

Submit a Culture Shock Report

More Living in San Juan del Sur Reports

What are people's priorities in San Juan del Sur - 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 San Juan del Sur:
Submit a Living Overseas Report

More Moving to San Juan del Sur Reports

What should you take with you when you move to San Juan del Sur? What should you leave behind? What type of housing and neighborhoods are typical for expats in San Juan del Sur? Below are some of the responses from expats in San Juan del Sur:
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 San Juan del Sur with the school selection process. If you have expat children who attend school in San Juan del Sur, 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 San Juan del Sur. If you are already living in San Juan del Sur, 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 San Juan del Sur 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 San Juan del Sur? Help other expats who are preparing to have a baby in San Juan del Sur 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 San Juan del Sur? How difficult was it to obtain a work permit? What types are jobs are typical for expats in San Juan del Sur? 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 Nicaragua from our partner, Cigna Global Health.
Get a Quote

Culture-Shock-in-ManaguaAn Expat Talks about Culture Shock & Living in Managua, Nicaragua

An expat who recently moved to Managua, Nicaragua was initially overwhelmed by the country's extreme poverty. But, the loving, caring Nicas have had the greatest impact on her.

An expat who recently moved to Managua, Nicaragua was initially overwhelmed by the country's extreme poverty. But, the loving, caring Nicas have had the greatest impact on her. ...

Living-in-Playa-MiramarAn Expat Discusses Living in Playa Miramar, Nicaragua

An expat in Nicaragua talks about life in the small fishing village of Playa Miramar. The village has 5 surf camps and about 1000 locals. If you're considering a move to Playa Miramar, you may want to start a business or non profit that gives back to the community.

An expat in Nicaragua talks about life in the small fishing village of Playa Miramar. The village has 5 surf camps and about 1000 locals. If you're considering a move to Playa Miramar, you may want ...

10-Tips-for-Living-in-Nicaragua10 Tips for Living in Nicaragua

Did you know that lots of homes in Nicaragua don't have hot water? Did you know that it's very easy to meet other expats in Nicaragua? Expats share their tips for living in Nicaragua.

Did you know that lots of homes in Nicaragua don't have hot water? Did you know that it's very easy to meet other expats in Nicaragua? Expats share their tips for living in Nicaragua. ...

5-Great-Places-to-Retire-in-Central-America5 Great Places to Retire in Central America

Central America is an increasingly popular retirement destination. Retirees love it's proximity to the United States, lower cost of living, beautiful cities, amazing beaches, healthy lifestyle and friendly people.

Central America is an increasingly popular retirement destination. Retirees love it's proximity to the United States, lower cost of living, beautiful cities, amazing beaches, healthy lifestyle and fr...

5-Best-Places-to-Retire-in-Nicaragua5 Best Places to Retire in Nicaragua

Expats discuss the best places to retire in Nicaragua. From upscale communities on the Emerald Coast to the beautiful city of Granada, Nicaragua is no longer just a haven for surfers.

Expats discuss the best places to retire in Nicaragua. From upscale communities on the Emerald Coast to the beautiful city of Granada, Nicaragua is no longer just a haven for surfers....

12-Expats-Talk-About-Living-in-Nicaragua12 Expats Talk About Living in Nicaragua

Expats in Nicaragua talks about living in Nicaragua - the high numbers of retirees, the kind and welcoming Nicas, the challenges they face learning the language and more.
Expats in Nicaragua talks about living in Nicaragua - the high numbers of retirees, the kind and welcoming Nicas, the challenges they face learning the language and more....

Nicaragua 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 30-May-20 08:28 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.242
Host Name 172.69.62.242


Execution Time

Total Time Avg Time Count Template
172 ms 172 ms 1 top level /home/www/html/expatguide.cfm
27 ms 27 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navcontentbox.cfm
26 ms 26 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 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/rewritearticlefirsttitle.cfm
1 ms 0 ms 4 /home/www/html/rewritereport.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/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.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 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 4 /home/www/html/rewriteqoptionsctry.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
180 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 @ 20:28:19.019
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=5ms, Records=1) in /home/www/html/Application.cfm @ 20:28:19.019
      	  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 @ 20:28:19.019
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 20:28:19.019
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 
getcities (Datasource=expert, Time=1ms, Records=4) in /home/www/html/navmeta_rdesign4.cfm @ 20:28:19.019
	Select *
	From citynetworks
	Where networkID = 295
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 20:28:19.019
	Select *
	From citynetworks
	Where citynetworkid = 4194 
GetForums (Datasource=forum, Time=1ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 20:28:19.019
  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 @ 20:28:19.019
	Select *
	From Networks
	Where networkID = 295 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 20:28:19.019
	Select *
	From countryphotos
	Where networkID = 295
	and citynetworkid = 4194 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:28:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.242'
and logtime > "2020-02-29"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 20:28:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.242'
and logtime > "2020-05-30 00:00:00.000"
and logtime < "2020-05-30 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 @ 20:28:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.242'
and logtime > "2020-05-23"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:28:19.019
	SELECT *
	From contentcountcountry
	Where networkid = 295 
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 20:28:19.019
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
    and bannerPlacement.networkid = 295
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 20:28:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
	Select *
	From citynetworks 
	Where citynetworkid = 4194 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 295 
 	and articlecityplace.citynetworkid = 4194
    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-05-30"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%San%') OR (author LIKE '%San%') OR (hitopic LIKE '%San%') OR (hidescript LIKE '%San%')) AND ((title LIKE '%Juan%') OR (author LIKE '%Juan%') OR (hitopic LIKE '%Juan%') OR (hidescript LIKE '%Juan%')) AND ((title LIKE '%del%') OR (author LIKE '%del%') OR (hitopic LIKE '%del%') OR (hidescript LIKE '%del%')) AND ((title LIKE '%Sur%') OR (author LIKE '%Sur%') OR (hitopic LIKE '%Sur%') OR (hidescript LIKE '%Sur%')))
	and articlePlacement.networkID = 295 
	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-05-30"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Nicaragua' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 295 
         and citynetworkid = 4194 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 295 
         and citynetworkid = 4194 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 295 
         and citynetworkid = 4194 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 295 
         and citynetworkid = 4194 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 295 
         and citynetworkid = 4194 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 295 
         and citynetworkid = 4194 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 295 
         and citynetworkid = 4194 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 295 
         and citynetworkid = 4194 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 295 
         and citynetworkid = 4194 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 295 
         and citynetworkid = 4194 
		order by date DESC
checkliving (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 295 
         and citynetworkid = 4194 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 295 
         and citynetworkid = 4194 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 295 
         and citynetworkid = 4194 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 295 
         and citynetworkid = 4194 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 1489 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 1488 
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 20:28:19.019
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
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 @ 20:28:19.019
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
 and allreports.citynetworkid2 =  4194
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
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 @ 20:28:19.019
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
 and allreports.citynetworkid2 =  4194
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 @ 20:28:19.019
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 20:28:19.019
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
 and allreports.citynetworkid2 =  4194
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 1488 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:28:19.019
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 1489 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 20:28:19.019
	Select *
	From Networks
	Where networkID = 295 
checkculturefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 295 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:28:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 46451
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:28:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 295 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:28:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 75911
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 20:28:19.019
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 295 
	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-05-30"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:28:19.019
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
     
         and rptarticlenetworks.networkid = 295 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 20:28:19.019
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 16
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 20:28:19.019
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:28:19.019
SELECT  hiimg
FROM rptarticles
where rptarticleID = 16
and hiimg <> ''


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=295&citynetworkid=4194
REMOTE_ADDR=172.69.62.242
REMOTE_HOST=172.69.62.242
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=28723442
cftoken=19012888
sessionid=IBEXPATEXCHANGE.COM_28723442_19012888
urltoken=CFID=28723442&CFTOKEN=19012888
URL Parameters:
citynetworkid=4194
networkid=295
Debug Rendering Time: 10 ms