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

Expat Guide to Living in Cabo San Lucas

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

Culture Shock in Cabo San Lucas, Mexico

Here's a short expat report about culture shock in Cabo San Lucas, Mexico. It describes some of the more challenging aspects of every day life from the perspective of a woman who had a hard time making it through the process of cultural adjustment.

Living in Cabo San Lucas , Mexico

An expat in Cabo San Lucas, Mexico offers an in-depth view of living in Cabo. Topics covered include clubs and volunteer organizations for expats in Cabo San Lucas, facebook groups, different types of visas and much more.

More Culture Shock Reports for Cabo San Lucas

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

More Living in Cabo San Lucas Reports

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

Moving Overseas Report

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

Culture-Shock-in-MeridaAn Expat Talks about Culture Shock & Living in Merida, Mexico

An expat in Merida, Mexico offers some insight into the challenges of settling in and living there. Some of the topics include driving, what it's like there if you don't speak Spanish, and much more. This expat clearly is an optimist and is determined to make life in Merida with her husband a success!

An expat in Merida, Mexico offers some insight into the challenges of settling in and living there. Some of the topics include driving, what it's like there if you don't speak Spanish, and much more....

Living-in-TijuanaAn Expat Discusses Living in Tijuana, Mexico

An expat in Tijuana, Mexico talks about what it's like living in a border city, locals focus on family, athletic activities and more.

An expat in Tijuana, Mexico talks about what it's like living in a border city, locals focus on family, athletic activities and more. ...

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:...

Living-in-Mexico-CityLiving in Mexico City

Expats talk about the best places to live in Mexico City, living near work to avoid hours of traffic every day, crime in Mexico City, international schools and much more.

Expats talk about the best places to live in Mexico City, living near work to avoid hours of traffic every day, crime in Mexico City, international schools and much more. ...

15-Expats-Talk-About-Life-in-Mexico15 Expats Talk About Life in Mexico

Expats share some insight into what it's like to live in Mexico on a day-to-day basis once you actually make the move and get there.
Expats share some insight into what it's like to live in Mexico on a day-to-day basis once you actually make the move and get there....

Mexico 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 10:19 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
178 ms 178 ms 1 top level /home/www/html/expatguide.cfm
29 ms 29 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
28 ms 28 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 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
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 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 6 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 6 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 6 /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
184 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 @ 22:19:07.007
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 22:19:07.007
      	  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 @ 22:19:07.007
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:19:07.007
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getcities (Datasource=expert, Time=1ms, Records=21) in /home/www/html/navmeta_rdesign4.cfm @ 22:19:07.007
	Select *
	From citynetworks
	Where networkID = 77
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:19:07.007
	Select *
	From citynetworks
	Where citynetworkid = 5149 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:19:07.007
  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, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:19:07.007
	Select *
	From Networks
	Where networkID = 77 
getphoto (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navmeta_rdesign4.cfm @ 22:19:07.007
	Select *
	From countryphotos
	Where networkID = 77
	and citynetworkid = 5149 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:19:07.007
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=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:19:07.007
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=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:19:07.007
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=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:19:07.007
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 22:19:07.007
	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=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 22:19:07.007
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
citystatus (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 22:19:07.007
	Select *
	From citynetworks 
	Where citynetworkid = 5149 
gettaxgeneral (Datasource=expert, Time=3ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:07.007
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 77 
 	and articlecityplace.citynetworkid = 5149
    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 @ 22:19:07.007
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Cabo%') OR (author LIKE '%Cabo%') OR (hitopic LIKE '%Cabo%') OR (hidescript LIKE '%Cabo%')) AND ((title LIKE '%San%') OR (author LIKE '%San%') OR (hitopic LIKE '%San%') OR (hidescript LIKE '%San%')) AND ((title LIKE '%Lucas%') OR (author LIKE '%Lucas%') OR (hitopic LIKE '%Lucas%') OR (hidescript LIKE '%Lucas%')))
	and articlePlacement.networkID = 77 
	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, Cached Query) in /home/www/html/expatguide.cfm @ 22:19:07.007
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Mexico' 

and qid = 46
checkretirefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 77 
         and citynetworkid = 5149 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 77 
         and citynetworkid = 5149 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 77 
         and citynetworkid = 5149 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 77 
         and citynetworkid = 5149 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 77 
         and citynetworkid = 5149 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 77 
         and citynetworkid = 5149 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 77 
         and citynetworkid = 5149 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 5149 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 5149 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 77 
         and citynetworkid = 5149 
		order by date DESC
checkliving (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 22:19:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 5149 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:08.008
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 5149 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:08.008
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 5149 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:08.008
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 5149 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:19:08.008
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 72799 
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=5) in /home/www/html/expatguide.cfm @ 22:19:08.008
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:19:08.008
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
 and allreports.citynetworkid2 =  5149
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 @ 22:19:08.008
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
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 @ 22:19:08.008
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
 and allreports.citynetworkid2 =  5149
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 @ 22:19:08.008
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
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 @ 22:19:08.008
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
 and allreports.citynetworkid2 =  5149
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 @ 22:19:08.008
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 72799 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:19:08.008
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 74415 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 22:19:08.008
	Select *
	From Networks
	Where networkID = 77 
checkculturefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 22:19:08.008
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 77 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:19:08.008
		Select summary, hiimg 
		FROM answers
         where answerid = 74757
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 22:19:08.008
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 77 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:19:08.008
		Select summary, hiimg 
		FROM answers
         where answerid = 75825
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 22:19:08.008
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	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=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:19:08.008
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-06"
     
         and rptarticlenetworks.networkid = 77 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:19:08.008
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 28
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:19:08.008
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getrptarticlephotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:19:08.008
SELECT  hiimg
FROM rptarticles
where rptarticleID = 28
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=77&citynetworkid=5149
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=31186899
cftoken=99454402
sessionid=IBEXPATEXCHANGE.COM_31186899_99454402
urltoken=CFID=31186899&CFTOKEN=99454402
URL Parameters:
citynetworkid=5149
networkid=77
Debug Rendering Time: 12 ms