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

Pre-Boomer Lifestyle on the Mexican Riviera

By Jim Scherrer

Summary: If you're a Baby Boomer and haven't yet lost all of your money in your 401k or IRA, it's not too late; come on down to Puerto Vallarta and join the Pre-Boomers.

Retire in Mexico - Life on the Mexican Riviera

First, let's define Pre-Boomer; obviously it's before Boomer! The Baby Boomer Generation is defined as those born after World War II; generally between the years of 1944 and 1964. Consequently, the oldest of the nearly 80 million US born Baby Boomers are just now turning 65 years old.

The Pre-Boomer Generation is typically defined as those born during the 20 year period prior to the end of WW II or roughly from 1924 to 1944. There were approximately 50 million people born in the US during this time frame. These Pre-Boomers are considered to be of the Silent Generation (a bit of a misnomer!); sometimes referred to as the Luckiest Generation. Lucky because they were born immediately after the Great Depression, were too young to serve in World War II and probably the Korean War, and too old to serve in the Viet Nam War. Since 95% of these Pre-Boomers have already retired, they are also lucky to be reaping the benefits of Social Security and Medicare; benefits that may not be available to many of the younger generations. Unlike the Baby Boomers that have recently lost 25-50% of their life savings prior to retirement due to the current recession and mortgage crisis, the Pre-Boomers are lucky because in all probability, they were able to purchase their retirement residence and have conservatively invested the balance, thus preventing a serious depletion of their retirement savings (and they have fewer years to make their remaining savings last!).

Those lucky folks of the Pre-Boomer Generation witnessed the introduction of television, the development of new plastics and composite materials, high speed air travel, satellite and missile technology, space exploration, major medical breakthroughs, the development of computers and the Internet, cell phones, and microwaves for communications and quick cooking ovens. It seems impossible that future generations will ever see as many revolutionary changes in their lifetime.

Now that we've defined the lucky but not really silent Pre-Boomer Generation, we'll review the lifestyle of those very fortunate ones that have retired on the Mexican Riviera. We'll accomplish that by evaluating the living patterns of those that have retired in Puerto Vallarta, which lies virtually in the center of the Mexican Riviera.

Of the tens of thousands of US and Canadian retirees that call Vallarta home, the majority of them actually reside in Vallarta for only seven or eights months per year, returning to their family and friends back North of the border during the hot and rainy summer months. Many of them also use the summer months for cruising or traveling to new and different places throughout the world.

As an estimate only, approximately 70% of these retirees are from the US and 30% from Canada; however the percentage of Canadians seems to be increasing as the Canadian Dollar strengthens.

One personality trait that these retirees have in common is that they are all somewhat adventurous; otherwise, they wouldn't be living abroad! Being adventurous, they often take the various day tours that are available to area tourists and the cruise boat passengers; day tours that include whale watching, horseback riding, botanical gardens, jungle safaris, dinner boats, and trips to secluded beaches such as Yelapa and Las Animas. When they get a little more adventurous, they take longer trips to the surrounding old mining cities such as San Sebastian and Mascota or south to Barre de Navidad; the number of really neat places to visit in a day are too numerous to cover here.

To satisfy their cultural side, there are a number of different art walks through the myriad of galleries and a handful of theaters for the performing arts. Many special events such as the annual Gourmet Festival are on everyone's calendar during the "high season".

As they are accustomed to back home, they typically shop at Sam's Club, Wal-Mart, Costco, Home Depot, Office Max or Office Depot, etc., where most everything in the way of foods and other products is available. The main difference is that there's never any hesitance in stopping a North American (they're easily recognized!) stranger in the isle and striking up a conversation in PV, whereas back in the US you might be considered a bit nosey or forward when doing this!

These active Pre-Boomers in PV play golf, tennis and deep sea fish, belong to clubs and associations with friends of similar interests, and are very much involved in charities. They are very active socially and can be seen out and about town every evening in all the fabulous restaurants.

Medical care is the least of their concerns with the four beautiful, new, and modern hospitals in Vallarta. These facilities have all of the latest in equipment and are staffed with highly qualified and experienced English speaking doctors. Spas, health clubs, Yoga studios and home service masseurs are frequently used by these pampered retirees.

Many of these immigrants have learned to speak some Spanish even though one can easily survive in Puerto Vallarta with little knowledge of the language since the economy is based on tourism and therefore most of the local citizens have some degree of English fluency.

The majority of these retirees live in condominiums with full time security however a small percentage of them live in hillside villas within gated communities. It's fair to say that wherever they live, they have breathtaking views of Banderas Bay and they enjoy a perfect climate from November through May when the average daily temperature is 73°F with virtually no rain. They drive their US or Canadian plated cars without ever having to change plates. Also, no annual automobile taxes are ever paid and property taxes are only 0.12% of appraised value.

If you're a Baby Boomer and haven't yet lost all of your money in your 401k or IRA, it's not too late; come on down to Puerto Vallarta and join the Pre-Boomers. The luckiest of the Luckiest Generation are truly living "La Dolce Vita" or the sweet life in this part of the Mexican Riviera!

About the Author

Jim Scherrer, PVREBA, has owned property in Puerto Vallarta, Mexico for 25 years and resided there for the past eleven years. The mission of his series of 50 articles pertaining to retirement in Puerto Vallarta is to reveal the recent changes that have occurred in Vallarta while dispelling the misconceptions about living conditions in Mexico. For the full series of articles regarding travel to and retirement in Vallarta as well as pertinent Puerto Vallarta links, please visit us at PVREBA.com.

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

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

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

Tax-Guide-for-Americans-in-Mexico

Tax Guide for Americans in Mexico

This tax guide for Americans living in Mexico is an important read. Do you need to file a tax return in Mexico? Plus, an overview of Mexico's tax system, income tax rates, Mexico resident qualifications and more.

This tax guide for Americans living in Mexico is an important read. Do you need to file a tax return in Mexico? Plus, an overview of Mexico's tax system, income tax rates, Mexico resident qualificati...

Is-Mexico-City-Safe

Is Mexico City Safe?

Is Mexico City Safe? What are the safest neighborhoods in Mexico City? Expats answer these questions and offer tips (based upon first-hand experience) for avoiding being the victim of a crime.

Is Mexico City Safe? What are the safest neighborhoods in Mexico City? Expats answer these questions and offer tips (based upon first-hand experience) for avoiding being the victim of a crime. ...

8-Best-Places-to-Live-in-Mexico

8 Best Places to Live in Mexico

Expats from the United States and Canada often choose to move to Mexico or retire there. Here are some of the locations that they recommend most to others considering living in Mexico.

Expats from the United States and Canada often choose to move to Mexico or retire there. Here are some of the locations that they recommend most to others considering living in Mexico....

Healthcare-in-Mexico

Healthcare in Mexico

If you're moving to Mexico or an expat living in Mexico, understanding the Mexican healthcare system is essential. We offer an overview of the public and private healthcare systems in Mexico, health insurance for expats in Mexico, hospitals and prescription drugs.

If you're moving to Mexico or an expat living in Mexico, understanding the Mexican healthcare system is essential. We offer an overview of the public and private healthcare systems in Mexico, health ...

Living-in-Mexico-City

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

Is-Mexico-City-Safe

Is Mexico City Safe?

Is Mexico City Safe? What are the safest neighborhoods in Mexico City? Expats answer these questions and offer tips (based upon first-hand experience) for avoiding being the victim of a crime.

Is Mexico City Safe? What are the safest neighborhoods in Mexico City? Expats answer these questions and offer tips (based upon first-hand experience) for avoiding being the victim of a crime. ...

International-Schools-in-Mexico-City

International Schools in Mexico City

If you're moving to Mexico City with kids, international schools are probably a top priority. Here's a list of some of the most well-known international schools and bilingual schools in Mexico City.

If you're moving to Mexico City with kids, international schools are probably a top priority. Here's a list of some of the most well-known international schools and bilingual schools in Mexico City. ...

7-Best-Neighborhoods-in-Mexico-City

7 Best Neighborhoods in Mexico City

Mexico City's neighborhoods are as varied as its wonderful people. Find out what expat consider the 7 best neighborhoods in Mexico City.

Mexico City's neighborhoods are as varied as its wonderful people. Find out what expat consider the 7 best neighborhoods in Mexico City. ...

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: Jun 30, 2009

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


Execution Time

Total Time Avg Time Count Template
73 ms 73 ms 1 top level /home/www/html/lib_rd.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
16 ms 16 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
13 ms 13 ms 1 /home/www/html/navtop_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/Application.cfm
7 ms 7 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/navjoin_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 12 /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 2 /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
82 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 @ 02:39:50.050
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=6ms, Records=1) in /home/www/html/Application.cfm @ 02:39:51.051
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 02:39:51.051
	Select *
	From articles
	Where articleID = 3384
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 02:39:51.051
	Select *
	From sponcers
	Where sponcerID = 319 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 02:39:51.051
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 3384 
	and articles.articleID = 3384 
	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 @ 02:39:51.051
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 3384
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 3384
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:39:51.051
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:39:51.051
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getcities (Datasource=expert, Time=0ms, Records=21, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:39:51.051
	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 @ 02:39:51.051
  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 @ 02:39:51.051
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 3384 
  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 @ 02:39:51.051
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-04-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:39:51.051
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
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=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:39:51.051
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
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 @ 02:39:51.051
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 02:39:51.051
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 02:39:51.051
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 02:39:51.051
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 02:39:51.051
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3384 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 02:39:51.051
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 3384 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=1ms, Records=48) in /home/www/html/lib_rd.cfm @ 02:39:51.051
SELECT tag
FROM natadoptions 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 02:39:51.051
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3384 
gettaxgeneral3 (Datasource=expert, Time=8ms, Records=5) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 02:39:51.051
	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 <> 3384
    and publishdate < "2020-07-04"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettaxgeneral4 (Datasource=expert, Time=6ms, Records=5) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 02:39:51.051
	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 <> 3384
    and publishdate < "2020-07-04"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 02:39:51.051
	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'
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 02:39:51.051
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 02:39:51.051
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-07-03 02:39:51'}
    and fromDate <{ts '2020-07-04 02:39:51'}
    and weight > 7
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 02:39:51.051
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-07-03 02:39:51'}
    and fromDate <{ts '2020-07-04 02:39:51'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 02:39:51.051
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 02:39:51.051
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 3384 
  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 @ 02:39:51.051
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3384 
checkculturefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 02:39:51.051
		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=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:39:51.051
		Select summary, hiimg 
		FROM answers
         where answerid = 74757
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 02:39:51.051
		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 @ 02:39:51.051
		Select summary, hiimg 
		FROM answers
         where answerid = 75825
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=2) in /home/www/html/navcontentbox.cfm @ 02:39:51.051
	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 desc
    
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:39:51.051
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-04"
     
         and rptarticlenetworks.networkid = 77 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 02:39:51.051
	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 @ 02:39:51.051
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:39:51.051
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=3384&networkid=77
REMOTE_ADDR=162.158.78.108
REMOTE_HOST=162.158.78.108
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=30996803
cftoken=49636704
sessionid=IBEXPATEXCHANGE.COM_30996803_49636704
urltoken=CFID=30996803&CFTOKEN=49636704
URL Parameters:
articleID=3384
networkid=77
Debug Rendering Time: 11 ms