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

Living in Mexico Has Made Me a Better Person

By Julia C. Taylor

Summary: You didn't know Mexico was a self-improvement destination? It is.

Living in Mexico - Self Improvement

Living in Mexico Has Made Me a Better Person By Julia Taylor Thanks to living in Mexico I'm much more flexible and less self-centered. I'm so patient, I'm practically eligible for sainthood. I'm more generous and less concerned about my budget. I'm less opinionated... well, at least I'm more respectful about how and when I share my opinions. All around I'm a better person now that I've lived in Mexico for six years.

You didn't know Mexico was a self-improvement destination? It is. Putting your heart into adjusting to Mexico involves taking on certain aspects of Mexican culture as well as more deeply understanding your own culture. This process inevitably produces a more value-centered lifestyle. While each person's experience of adjusting to Mexico is their own, most people end up making conscious decisions about their behaviors and lifestyle rather than just plodding along through life reiterating the status quo and therein lies the self-improvement.

For example, Thanksgiving isn't celebrated in Mexico, so as an (American or Canadian) expat living in Mexico you will have to decide for yourself if (and how) you are going to create your own Thanksgiving celebration. You end up answering important questions about your own beliefs and feelings. What does Thanksgiving really mean to you? Is it the food that makes the day or is it something else? Will you share your tradition with Mexican friends or will you search out other expats who will help make the day more like it is "back home?" Will you just skip the whole thing and read a good book? By answering questions like these about any and all holidays, which are celebrated differently from our home countries, each individual expatriate in Mexico actually has an opportunity to get closer to their own personal values.

A second example from my own personal growth in Mexico comes from examining how people interact with each other. When I first moved to Mexico, I had trouble deviating from my expected plans. If I was arriving home expecting to get online and check my email, I had trouble calmly chatting with neighbors who happened to be out watering their plants. I just wanted to get on with my own activities. I really had trouble when my Mexican husband would invite them to dinner! Suddenly, we'd be rolling out that barbeque, marinating meat, moving the kitchen table outside, and sitting around for hours, all the while I'd have this unmet need to check my email in the back of my mind. Now I'm not so focused on what I want for myself. There have been many times when our Mexican neighbors and friends have dropped whatever they were doing to come help us out or even just chat and make us laugh a little. Now I know that I can do what I want to do later, but that I'll never have another chance to enjoy that tiny moment of interpersonal communication, which is presenting itself to me.

After years of being treated this way by others, now Americans sometimes hurt my feelings. It seems as if they are off in their own little worlds and can't take time out from their daily problems or TV schedules to have some fun with me. Once I was visiting a friend in the U.S. when one of her other friends came to the door. I opened the door and since I knew her too, I expected her to stop and say hello, to at least ask how I was. A Mexican would have stood there in the doorway, shaken my hand or given me a kiss on the cheek, asked how I was, and how long I'd be staying. Then we would have entered the house together to continue the conversation with our mutual friend. That wasn't at all what happened. This person had just had an argument with her spouse and she was so busy replaying this unfortunate conversation over and over in her head that she barely looked at my smiling face and just barged right past me to go spend 30 minutes complaining to my friend. And we Americans wonder where all of our negativity and isolation comes from. After living in Mexico for 6 years I posit that we are creating it ourselves. It took me a while, but now I've learned to "put on my game face" and go out and enjoy whoever is around. Problems will be solved in their own time and they don't need to take over our interactions for an entire day. See? Mexico is good for self-improvement.

When you live or retire in Mexico, I highly recommend that you learn Spanish and make Mexican friends. While every expatriate must have at least one other expat friend who will relate with the ups and downs of culture shock, it would be a mistake to spend the majority of your social energy on foreigners. Having Mexican friends brings out the richness of life in Mexico. In general, Mexicans love to share their customs, foods, and knowledge and can show you some really wonderful new things. Having really close Mexican friends can also be a form of insurance. They will share their knowledge and contacts when it comes to legal and business matters that can be overwhelmingly different from those up north.

When you make the decision to live or retire in Mexico, remember that (as is true for any move to another country and culture) there will be an adjustment period commonly referred to as "culture shock." This culture shock may hit hard at times, but it's a growth process. And, once you have adjusted to Mexico, you are sure to like the new you.

About Mexico: The Trick is Living Here Second Edition

Mexico: The Trick is Living Here is a humorous guide on how to live or retire in Mexico, useful for any extended stay in Mexico. It includes sections on the following:

  • housing and cost of living,
  • transportation including riding buses and driving,
  • eating, drinking, and grocery shopping,
  • staying healthy and health care, as well as finding doctors,
  • working and making a living in Mexico,
  • getting a residence visa,
  • bringing a car,
  • bringing household items,
  • residency issues unique to Canadians,
  • banking,
  • climate and staying comfortable,
  • international communication.
Housing and cost of living are dealt with in a completely unique way that helps the reader visualize what their lifestyle might be like once they are in Mexico. This section shows Mexico as it is so that the reader can decide for him/herself if Mexico might be a comfortable place for them to live. Key cultural information lets the reader have an insider's view of how it feels to live in Mexico and provides important tips on how to get along and understand people. This is information that takes most people years of experience to discover by trial and error and is one of the best and most unique aspects of Mexico: The Trick is Living Here. A chatty style with funny anecdotes helps the reader relate to the descriptions and feel comfortable living or traveling in Mexico the way Mexicans do, all the while making the reader laugh about the challenges. The book is full of pointers for the reader's successful transition to Mexico.

About the Author

AS Mexico: The Trick is Living HereJulia C. Taylor has lived and worked in Mexico since 2002. She had a desire to share the inevitable culture shock involved in adjusting to a new society and authored, Mexico: The Trick is Living Here, a guide book for anyone who wants to work, live, or retire in Mexico. Her writing has been extolled by various experts on Mexico as honest, funny, useful, and pithy.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Join our Mexico Expat Forum

Visit our Mexico Forum and talk with other expats who can offer you insight and tips about living in , Mexico.

More about Mexico

5-Best-Places-to-Live-in-Mexico

Expat Mexico: 5 Best Places to Live in Mexico

Mexico's lower cost of living, beautiful weather and warm, welcoming culture are a big draw for people looking to live abroad. However, Mexico's ever changing security situation impacts where expats choose to move. Here are 5 of the best places to live in Mexico based upon recent expat reviews.

Mexico's lower cost of living, beautiful weather and warm, welcoming culture are a big draw for people looking to live abroad. However, Mexico's ever changing security situation impacts where expats ...

10-Best-Places-to-Teach-Abroad

10 Best Places to Teach Abroad

Anne Keeling highlights the 10 most popular cities for teaching overseas. From Dubai to Bangkok, Doha to Shanghai.

Anne Keeling highlights the 10 most popular cities for teaching overseas. From Dubai to Bangkok, Doha to Shanghai. ...

9-Best-Places-to-Live-on-Mexicos-Pacific-Coast

9 Best Places to Live on Mexico's Pacific Coast

We've compiled a list of the 9 best places to live on the Pacific Coast of Mexico based upon expats' recommendations and security information from the US State Department. From Ensenada in Baja Norte all the way down to Puerto Escondido, these cities and towns boast beautiful beaches, warm weather and more.

We've compiled a list of the 9 best places to live on the Pacific Coast of Mexico based upon expats' recommendations and security information from the US State Department. From Ensenada in Baja Norte...

9-Important-Tips-about-Healthcare-for-Expats-in-Mexico

9 Important Tips about Healthcare for Expats in Mexico

Expats living in Mexico discuss health insurance and quality of medical care in Mexico.

Expats living in Mexico discuss health insurance and quality of medical care in Mexico....

10-Tips-for-Living-in-Lake-Chapala,-Mexico

10 Tips for Living in Lake Chapala, Mexico

Lake Chapala is one of Mexico's most popular expat destinations - especially among retirees. Expats love Lake Chapala's near perfect climate, beautiful lakeside homes, low cost of living and thriving expat community. Sadly, Lake Chapala is not immune to Mexico's drug cartel related violence, which those thinking of moving to Lake Chapala should take into consideration.

Lake Chapala is one of Mexico's most popular expat destinations - especially among retirees. Expats love Lake Chapala's near perfect climate, beautiful lakeside homes, low cost of living and thriving...

5-Tips-for-Living-in-Manzanillo,-Mexico

5 Tips for Living in Manzanillo, Mexico

Expats in Manzanillo enjoy wonderful winter weather and very hot summers as they engage in all kinds of outdoor activities... All right by the beautiful scenery of the Pacific Ocean.

Expats in Manzanillo enjoy wonderful winter weather and very hot summers as they engage in all kinds of outdoor activities... All right by the beautiful scenery of the Pacific Ocean....

Best-Places-to-Live-in-Riviera-Maya,-Mexico-

5 Best Places to Live in Riviera Maya, Mexico

Riviera Maya is a gorgeous stretch of Caribbean coastline in the Mexican state of Quintana Roo. We highlight expats' 5 favorite places to live in Riviera Maya.

Riviera Maya is a gorgeous stretch of Caribbean coastline in the Mexican state of Quintana Roo. We highlight expats' 5 favorite places to live in Riviera Maya....

5-Tips-for-Living-in-San-Miguel-de-Allende,-Mexico

5 Tips for Living in San Miguel de Allende, Mexico

Expats in San Miguel de Allende love the city's art scene, spring-like weather, beautiful architecture and thriving expat community. Expats share tips for living in San Miguel de Allende.

Expats in San Miguel de Allende love the city's art scene, spring-like weather, beautiful architecture and thriving expat community. Expats share tips for living in San Miguel de Allende. ...

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

First Published: Mar 08, 2008

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

Expat-Life-in-MexicoBook Review: "Mexico: The Trick is Living Here"

Julia Taylor's book is packed with practical advice and cultural insight and is a must have for expats and anyone preparing to make the move to Mexico.

Julia Taylor's book is packed with practical advice and cultural insight and is a must have for expats and anyone preparing to make t...

Where-are-the-Safest-Places-to-Live-in-MexicoCrime in Mexico: Where are the Safest Places to Live in Mexico?

Where are the safest places to live in Mexico? The most unsafe areas are well-covered in today's news headlines, but those considering a move to other cities or towns in Mexico should carefully research their possible destinations, talk with other expats and visit before they move. This article highlights members' recent discussions and comments about crime and safety in popular expat locales and some off-the-beaten path destinations. If you live in Mexico, we encourage you to submit an update on your city or town.

Where are the safest places to live in Mexico? The most unsafe areas are well-covered in today's news headlines, but those considering a move to other cities or towns in Mexico should carefully resea...

10-Tips-for-Living-in-Mexico10 Tips for Living in Mexico

Is it safe to live in Mexico? What should I bring with me to Mexico? How can I find a home? Expats offer advice on these and other topics.

Is it safe to live in Mexico? What should I bring with me to Mexico? How can I find a home? Expats offer advice on these and other topics....

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 /lib_rd.cfm
Time Stamp 04-Jul-20 12:54 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.110
Host Name 162.158.78.110


Execution Time

Total Time Avg Time Count Template
75 ms 75 ms 1 top level /home/www/html/lib_rd.cfm
29 ms 29 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
17 ms 17 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
14 ms 14 ms 1 /home/www/html/commentsnew_rdesign4.cfm
9 ms 9 ms 1 /home/www/html/navbottomad_rdesign5.cfm
9 ms 9 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
4 ms 4 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 2 /home/www/html/rewritereport.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/constants.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 11 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /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
80 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 @ 00:54:34.034
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 00:54:34.034
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 00:54:34.034
	Select *
	From articles
	Where articleID = 2970
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 00:54:34.034
	Select *
	From sponcers
	Where sponcerID = 254 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 00:54:34.034
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 2970 
	and articles.articleID = 2970 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd.cfm @ 00:54:34.034
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 2970
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 2970
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=1ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 00:54:34.034
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 00:54:34.034
	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 @ 00:54:34.034
	Select *
	From citynetworks
	Where networkID = 77
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 00:54:34.034
  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
commentcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 00:54:34.034
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 2970 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 00:54:34.034
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.110'
and logtime > "2020-04-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 00:54:34.034
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.110'
and logtime > "2020-07-04 00:00:00.000"
and logtime < "2020-07-04 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 00:54:34.034
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.110'
and logtime > "2020-06-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 00:54:34.034
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 00:54:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 00:54:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=1ms, Records=0) in /home/www/html/breadcrumb.cfm @ 00:54:34.034
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 2970 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 00:54:34.034
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 2970 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 00:54:34.034
SELECT tag
FROM natadoptions 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 00:54:34.034
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 2970 
gettaxgeneral3 (Datasource=expert, Time=7ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 00:54:34.034
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 2970
    and publishdate < "2020-07-04"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettaxgeneral4 (Datasource=expert, Time=8ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 00:54:34.034
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articlecityplace
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
		and articlecityplace.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.articleID <> 2970
    and publishdate < "2020-07-04"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=3ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 00:54:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
        and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=3ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 00:54:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 00:54:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 00:54:34.034
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-07-03 00:54:34'}
    and fromDate <{ts '2020-07-04 00:54:34'}
    and weight < 7
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
  
gethpbox (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 00:54:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight < 7
    and toDate > {ts '2020-07-03 00:54:34'}
    and fromDate <{ts '2020-07-04 00:54:34'}
    and banners.type <> 'swf'
    
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 00:54:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
    and toDate > {ts '2020-07-03 00:54:34'}
    and fromDate <{ts '2020-07-04 00:54:34'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 00:54:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 00:54:34.034
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 2970 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 00:54:34.034
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 2970 
checkculturefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 00:54:34.034
		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 @ 00:54:34.034
		Select summary, hiimg 
		FROM answers
         where answerid = 74757
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 00:54:34.034
		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 @ 00:54:34.034
		Select summary, hiimg 
		FROM answers
         where answerid = 75825
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 00:54:34.034
	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-04"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=4ms, Records=1) in /home/www/html/navcontentbox.cfm @ 00:54:34.034
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-04"
     
         and rptarticlenetworks.networkid = 77 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 00:54:34.034
	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 @ 00:54:34.034
	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 @ 00:54:34.034
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/lib_rd.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/lib_rd.cfm
QUERY_STRING=articleID=2970&networkid=77
REMOTE_ADDR=162.158.78.110
REMOTE_HOST=162.158.78.110
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib_rd.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=30992102
cftoken=29603848
sessionid=IBEXPATEXCHANGE.COM_30992102_29603848
urltoken=CFID=30992102&CFTOKEN=29603848
URL Parameters:
articleID=2970
networkid=77
Debug Rendering Time: 12 ms