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

Medicare for Expats: Boomers May Soon Overcome Top Objection to Retirement in Mexico

By Jim Scherrer

Summary: Will Medicare be available to retirees in Mexico in the not-to-distant future? Puerto Vallarta expat, Jim Scherrer, discusses this hot topic.

Mexico  - Healthcare

As retirees and 12 year residents of Puerto Vallarta, Mexico, it's quite easy to extol the benefits of living in Mexico. Of course, not every part of Mexico is the same (as is true in the US or Canada); however, we can certainly vouch for Puerto Vallarta. With its beautiful climate and landscape of the Sierra Madres cascading down into Banderas Bay, its kind and friendly local citizenry, its proximity to the US and Canada, and its lower cost of living, what's there not to like in this wonderland south of the border?

English, as a second language, is widely spoken throughout the city, the safety of expats is of highest priority for the authorities with the rate of violent crime at a fraction of that back home, corruption significantly reduced, poverty virtually eradicated, and the cleanliness of this city make it a favorite resort destination for millions of visitors from throughout the world. All of the Big box stores such as Sam's Club, Costco, Wal-Mart, Builders Square, Office Depot, nine beautiful signature golf courses, world class deep sea fishing, high speed internet, satellite TV, VOIP telephone service, etc. are all available in this beautiful city in the center of the Mexican Riviera. The face of Vallarta has been dramatically altered during the past decade with well maintained city parks, esplanades, a new malecon walkway along the beach, new water treatment facilities and miles of new water distribution lines, new or upgraded power distribution system throughout the city, new downtown above ground and underground parking garages, a new University of Guadalajara branch, a new Convention Center, the tripling in size of the Maritime Terminal, the quadrupling in size of the International Airport, and the addition of four new hospitals with modern and sophisticated diagnostic and surgical equipment, staffed with highly trained and experienced English speaking doctors.

Now that we've established the fact that Vallarta is a fine place to live or retire, let's take a closer look at the last item above related to medical care.

With high quality medical care readily available in Vallarta, the cost of it, even though at a fraction of the cost in the US, can be a deciding factor when considering Mexico as a retirement location. Assuming that most retirees have reached or are fast approaching their 65th birthday, the availability, quality, and cost of medical care are of high importance. The quality of medical care in Vallarta is generally equal to or better than that received in the US and the cost varies from one third to one half of that in the States (speaking from experience and with authority!).

Having high quality medical care available in Mexico is one thing but paying for it is another since US provided Medicare for seniors fails to cross the border at this time. Various supplements to Medicare cover seniors traveling abroad for a limited period of time (for example, supplement F covers the holder for the first 60 days of international travel), however, they are inadequate for full time residents living abroad.

Although Mexican Social Security (IMSS) is available to expats, most under the age of 65 have their own private international health insurance which is somewhat costly as discussed in numerous articles and covered on websites such as MedToGo. For many years, we have used IHI/BUPA and can state emphatically; their coverage and service is absolutely great for expats living in Mexico and traveling worldwide.

Now, let's assume you've reached the age of 65 and are considering Mexico as your retirement destination. It's very difficult to abandon your free Medicare that you've contributed to for a lifetime, the cost of private insurance is almost prohibitive, and you can't afford to take the risk of being uninsured. This is the main dilemma for seniors considering retirement abroad. Even so, there are more than five million (some reports indicate six million) Americans living abroad, of which more than a million reside in Mexico per the Association of Americans Resident Overseas (AARO). In fact, there are more US expats living abroad than reside in 24 of the states in the US as reported by Republicans Abroad!

Well, perhaps we're on the verge of overcoming this top objection to retiring in Mexico! The US government has been approached by numerous expat groups such as the Puerto Vallarta based chapter of Democrats Abroad and the bipartisan group of American Citizens Abroad with the intent of promoting the advancement of Medicare for expats living abroad.

Before Congress can enact such a law change, they must conduct demonstration projects in order to determine the feasibility and cost effectiveness of such law changes. The Americans for Medicare in Mexico, A.C. (AMMAC) have put forth a tremendous effort in promoting this benefit to eligible retirees and have encouraged many members of Congress to initiate such a demonstration project. They argue that not only have these eligible Medicare recipients paid into the fund over a lifetime, but the cost to the US taxpayers will be significantly reduced because rather than returning to the US for expensive and long term medical care, the majority of these expats will merely elect to have their medical care provided near their foreign residence at a fraction of the cost.

Proponents of the law change such as Professor David C. Warner of the Lyndon B. Johnson School of Public Affairs at the University of Texas have written books and papers on the subject of "Getting What You Paid For: Extending Medicare to Eligible Beneficiaries in Mexico" and the newly appointed US Ambassador to Mexico, Carlos Pascual, has been following the current efforts to establish a demonstration project for the initiation of Medicare in Mexico as a pilot program. In fact, Ambassador Pascual recently accompanied President Obama to a North American Summit in Guadalajara where one of the topics covered was Medicare in Mexico as reported by the Guadalajara Reporter.

In summarizing, we are anticipating the availability of Medicare for eligible retirees residing in Mexico in the not too distant future. Once this obstacle to retiring abroad has been eliminated, not only will millions of baby boomers in search for a less expensive and better quality of life be heading south of the border, but so too will millions of retiring Mexican Americans desiring to return to their homeland. Combined with all of the other obvious benefits of living in Paradise, free and high quality medical care for boomers will just be the icing on the cake!


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

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

Comments about this Article

guest
Oct 13, 2010 07:48

Hi Jim, I'm an English person wanting to move to Mexico and open a small beauty salon; can you tell me what I would need to do on order to get working papers there? Is it easier to get these in PV, La Paz or Cabo? Thank you! Jan Hanigan

First Published: Sep 19, 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. ...

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 02:42 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.249
Host Name 172.69.63.249


Execution Time

Total Time Avg Time Count Template
65 ms 65 ms 1 top level /home/www/html/lib_rd.cfm
28 ms 28 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navcontentbox.cfm
14 ms 14 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
10 ms 10 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/navtop_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/Application.cfm
6 ms 6 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/navleader_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/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/constants.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 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 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
73 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:42:19.019
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=5ms, Records=1) in /home/www/html/Application.cfm @ 02:42:19.019
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 02:42:19.019
	Select *
	From articles
	Where articleID = 3441
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 02:42:19.019
	Select *
	From sponcers
	Where sponcerID = 319 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 02:42:19.019
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 3441 
	and articles.articleID = 3441 
	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:42:19.019
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 3441
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 3441
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:42:19.019
	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:42:19.019
	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:42:19.019
	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:42:19.019
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
commentcount (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 02:42:19.019
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 3441 
  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:42:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.249'
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:42:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.249'
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=1) in /home/www/html/navtop_rdesign5.cfm @ 02:42:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.249'
and logtime > "2020-06-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 02:42:19.019
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 02:42:19.019
	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=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 02:42:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 02:42:19.019
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3441 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 02:42:19.019
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 3441 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 02:42:19.019
SELECT tag
FROM natadoptions 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 02:42:19.019
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3441 
gettaxgeneral3 (Datasource=expert, Time=6ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 02:42:19.019
	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 <> 3441
    and publishdate < "2020-07-04"
    and publishdate > "2014-01-01"

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

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 02:42:19.019
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 02:42:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight = 10 
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 02:42:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 02:42:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-03 02:42:19'}
    and fromDate <{ts '2020-07-04 02:42:19'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 02:42:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 02:42:19.019
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 3441 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 02:42:19.019
  SELECT *
  FROM users
  WHERE userid = 2 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 02:42:19.019
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3441 
checkculturefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 02:42:19.019
		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 @ 02:42:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 74757
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 02:42:19.019
		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:42:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 75825
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 02:42:19.019
	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 @ 02:42:19.019
		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=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 02:42:19.019
	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:42:19.019
	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:42:19.019
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=3441&networkid=77
REMOTE_ADDR=172.69.63.249
REMOTE_HOST=172.69.63.249
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=30996872
cftoken=27247186
sessionid=IBEXPATEXCHANGE.COM_30996872_27247186
urltoken=CFID=30996872&CFTOKEN=27247186
URL Parameters:
articleID=3441
networkid=77
Debug Rendering Time: 11 ms