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

Expat Guide to Living in Ojochal

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

11 Tips for Living in Ojochal, Costa Rica

11 Tips for Living in Ojochal, Costa Rica

Ojochal, Costa Rica is an international residential community, not a tourist town. It boasts beautiful beaches, a low crime rate, a thriving expat social scene and more. Steve Linder offers a great overview of the area.

Culture Shock Report

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

Submit a Culture Shock Report

More Living in Ojochal Reports

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

Moving Overseas Report

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

Culture-Shock-in-Montezuma-An Expat Talks about Culture Shock & Living in Montezuma , Costa Rica

An expat talks about what it's like living in Montezuma, Costa Rica. The challenges he found in Montezuma where terrible roads, power outages, the language barrier and the prohibitively high cost of shipping into the country.

An expat talks about what it's like living in Montezuma, Costa Rica. The challenges he found in Montezuma where terrible roads, power outages, the language barrier and the prohibitively high cost of...

Living-in-MontezumaAn Expat Discusses Living in Montezuma, Costa Rica

An expat in Montezuma, Costa Rica talks about learning to live more simply, let go of material things and enjoy the fresh air, sunshine and life. But, you'll also have to adjust to living without Starbucks, driving on very bumpy roads, lots of insects and rainy season.

An expat in Montezuma, Costa Rica talks about learning to live more simply, let go of material things and enjoy the fresh air, sunshine and life. But, you'll also have to adjust to living without Sta...

17-Best-Places-to-Live-in-Costa-Rica17 Best Places to Live in Costa Rica

Costa Rica has a lot to offer expats with its tropical climate, eco-friendly culture, beautiful beaches, welcoming people, good healthcare system and relative safety. Many expats warn newcomers about the high cost of housing and food. In this updated version of the best places to live in Costa Rica we cover many more locations such as Playa Flamingo, Nosara, Lake Arenal, Jaco Beach and Ojochal.

Costa Rica has a lot to offer expats with its tropical climate, eco-friendly culture, beautiful beaches, welcoming people, good healthcare system and relative safety. Many expats warn newcomers about...

Expats-Talk-About-The-Biggest-Challenges-They-Face-Living-in-Latin-AmericaExpats Talk About The Biggest Challenges They Face Living in Latin America

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint: you'll be much happier if you learn the language) and adjust your expectations (realities: the roads are rough, the pace of life is slower and bureaucracy is unavoidable). Despite all of the challenges, the list of what expats like about life in Latin America far exceeds the challenges.

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint:...

10-Expats-Talk-About-What-Its-Like-Living-in-Costa-Rica10 Expats Talk About What It's Like Living in Costa Rica

Expats living in Costa Rica talk about Pura Vida, deciding where to live in Costa Rica, meeting people and more.
Expats living in Costa Rica talk about Pura Vida, deciding where to live in Costa Rica, meeting people and more....

Top-5-Reasons-Expats-Move-to-Central-AmericaTop 5 Reasons Expats Move to Central America

From lower cost of living to affordable healthcare and beachfront living, expats discuss the top reasons they moved to Central America.
From lower cost of living to affordable healthcare and beachfront living, expats discuss the top reasons they moved to Central America....

Costa Rica 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 06-Jul-20 11:15 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.230
Host Name 162.158.78.230


Execution Time

Total Time Avg Time Count Template
259 ms 259 ms 1 /home/www/html/expatguide.cfm
66 ms 66 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
65 ms 65 ms 1 /home/www/html/navcontentbox.cfm
65 ms 65 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navmeta_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 2 ms 2 /home/www/html/rewritearticlefirsttitle.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/eetr/rewriterealtorlink.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 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/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 3 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 3 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 3 /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
264 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 @ 23:15:09.009
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 23:15:09.009
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=1ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 23:15:09.009
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 23:15:09.009
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 33 
getcities (Datasource=expert, Time=2ms, Records=9) in /home/www/html/navmeta_rdesign4.cfm @ 23:15:09.009
	Select *
	From citynetworks
	Where networkID = 33
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 23:15:09.009
	Select *
	From citynetworks
	Where citynetworkid = 4576 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 23:15:09.009
  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=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 23:15:09.009
	Select *
	From Networks
	Where networkID = 33 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 23:15:09.009
	Select *
	From countryphotos
	Where networkID = 33
	and citynetworkid = 4576 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 23:15:09.009
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-04-06"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 23:15:09.009
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-07-06 00:00:00.000"
and logtime < "2020-07-06 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 @ 23:15:09.009
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-06-29"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 23:15:09.009
	SELECT *
	From contentcountcountry
	Where networkid = 33 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 23:15:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-05"
    and fromDate < "2020-07-06"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 23:15:09.009
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 23:15:09.009
	Select *
	From citynetworks 
	Where citynetworkid = 4576 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 23:15:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 33 
 	and articlecityplace.citynetworkid = 4576
    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-06"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 23:15:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Ojochal%') OR (author LIKE '%Ojochal%') OR (hitopic LIKE '%Ojochal%') OR (hidescript LIKE '%Ojochal%')))
	and articlePlacement.networkID = 33 
	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-06"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 23:15:09.009
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Costa Rica' 

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

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=4ms, Records=2) in /home/www/html/navcontentbox.cfm @ 23:15:10.010
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-06"
     
         and rptarticlenetworks.networkid = 33 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 23:15:10.010
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 15
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 23:15:10.010
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 33 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:15:10.010
SELECT  hiimg
FROM rptarticles
where rptarticleID = 15
and hiimg <> ''
getreportarticle (Datasource=reports, Time=1ms, Records=6) in /home/www/html/rewritearticlefirsttitle.cfm @ 23:15:10.010
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 9
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 23:15:10.010
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 20 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:15:10.010
SELECT  hiimg
FROM rptarticles
where rptarticleID = 9
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=33&citynetworkid=4576
REMOTE_ADDR=162.158.78.230
REMOTE_HOST=162.158.78.230
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=31188787
cftoken=96746073
sessionid=IBEXPATEXCHANGE.COM_31188787_96746073
urltoken=CFID=31188787&CFTOKEN=96746073
URL Parameters:
citynetworkid=4576
networkid=33
Debug Rendering Time: 11 ms