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

Healthcare in Mexico > Mexico Healthcare & Health Insurance FAQ > What is Seguro Popular?

What is Seguro Popular?

By Betsy Burlingame

Last updated on: Dec 08, 2018

Summary: What is Seguro Popular? How is it different than IMSS? Are expats eligible to enroll in Seguro Popular? Are pre-existing conditions covered?

Seguro Popular is not typically recommended as the primary healthcare option for foreigners living in Mexico, but some older expats who cannot get adequate coverage under IMSS due to pre-existing conditions, enroll in Seguro Popular and pay out-of-pocket for private care as needed. One expat explained this basic level of healthcare in Mexico, "Seguro Publico is generally free, or almost free, depending upon your family situation, home, etc., and is for those without any other insurance coverage. Neither are really insurance, but are socialized medical care programs for legal residents of Mexico; citizens and those with residence visas. Quality of care can vary widely from one area to another and waits can be very long; often requiring arrival at 6:30 AM and waiting much of the day, only to be referred to the next day, or another location or provider. Appointment times can take several weeks; even months."

" Seguro Popular has its own hospitals with different levels of care available. Some are good, some are not. No, you do not get to choose the hospital and get reimbursement. These are public hospitals and are a far cry from the excellent private hospitals you will find in places like Guadalajara, etc," explained one expat.

"Seguro Popular doesn't eliminate on the basis of pre-existing conditions (nor age). (With IMSS there are delays in coverage.) SP has no exclusions like that. They will interview you for financial information (basic questions like whether you rent or own, have a refrigerator or whether your floors are tile or dirt, etc.) but by USA and Canadian standards, the annual payment will be very modest. Also, there are equally modest charges for some surgeries or treatments. Where it may fall short for some people is that the coverage is not comprehensive. Covered treatments and medications are based on an extensive and growing menu design to provide the most needed treatments for the most people. But there are sometimes conditions that fall outside of their menu (dialysis for example). People often tell me that it covered everything for them. But if you are the exception, I think you need to know that there is a small the one thing you need isn't on the menu," explained one expat.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Moving-to-MexicoHealthcare 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 ...

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

Hospitals in Mexico CityHospitals in Mexico City

Knowing which hospital you would go to should a medical emergency arise while living in Mexico is important. This information is provided (but not endorsed) by expats and the US Embassy in Mexico.

mexico Healthcare FAQMexico Healthcare FAQ

Answers to some of the most commonly asked questions about healthcare and health insurance for expats in Mexico.

mexico Healthcare InfoMexico Healthcare Info

Additional information about healthcare and health insurance for foreigners in Mexico.

expat healthcare surveyAnswer Questions about Healthcare in Mexico

Help others moving to Mexico by answering a set of questions about health insurance, public healthcare in Mexico, prescription medicine, quality of medical care and emergency services.

Having-a-Baby-In-SaltilloHaving a Baby in Saltillo, Mexico

An expat mom in Mexico talks about her experiences finding a doctor, at the hospital, during childbirth and more.

If you're an expat parent who had a baby abroad, write a report about your childbirth experiences to help other expecting expat parents.

About the Author

Betsy Burlingame Betsy Burlingame is the Founder of Expat Exchange. She launched Expat Exchange in 1997 as her Master's thesis project at NYU. Some of Betsy's more popular articles include 6 Best Places to Live in Costa Rica, 12 Things to Know Before Moving to The Dominican Republic and 7 Tips for Obtaining Residence in Italy. Betsy loves to travel and spend time with her family. Connect with Betsy on LinkedIn.

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

Updated On: Dec 08, 2018

First Published: Dec 08, 2018

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare-in-MexicoHealthcare 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 ...

9-Important-Tips-about-Healthcare-for-Expats-in-Mexico9 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....

Hospitals in Mexico CityHospitals in Mexico City

Knowing which hospital you would go to should a medical emergency arise while living in Mexico is important. This information is provided (but not endorsed) by expats and the US Embassy in Mexico.

mexico healthcare faqMexico Healthcare FAQ

Answers to some of the most commonly asked questions about healthcare and health insurance for expats in Mexico.

mexico healthcare infoMexico Healthcare Info

Additional information about healthcare and health insurance for foreigners in Mexico.

healthcare surveyAnswer Questions about Healthcare in Mexico

Help others moving to Mexico by answering a set of questions about health insurance, public healthcare in Mexico, prescription medicine, quality of medical care and emergency services.

Having-a-Baby-In-SaltilloHaving a Baby in Saltillo, Mexico

An expat mom in Mexico talks about her experiences finding a doctor, at the hospital, during childbirth and more.

If you're an expat parent who had a baby abroad, write a report about your childbirth experiences to help other expecting expat parents.

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


Execution Time

Total Time Avg Time Count Template
97 ms 97 ms 1 top level /home/www/html/lib_rd.cfm
41 ms 41 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
20 ms 20 ms 1 /home/www/html/navtop_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
11 ms 11 ms 1 /home/www/html/navleader_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
7 ms 7 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navmeta_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/Application.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 0 ms 16 /home/www/html/rewritearticle.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 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.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 6 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
102 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 @ 18:37:12.012
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 18:37:12.012
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 18:37:12.012
	Select *
	From articles
	Where articleID = 5162
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 18:37:12.012
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 18:37:12.012
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5162 
	and articles.articleID = 5162 
	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 @ 18:37:12.012
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5162
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5162
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:37:12.012
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 18:37:12.012
	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 @ 18:37:12.012
	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 @ 18:37:12.012
  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 @ 18:37:12.012
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5162 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
getrandomphoto (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 18:37:12.012
	Select twimg as guidephoto, hpimg
	From countryphotos
	Where networkID = 77
	and guidephoto = 'yes'
	and twimg <> ''
getrandomphoto (Datasource=expert, Time=0ms, Records=33) in /home/www/html/navmeta_rdesign4.cfm @ 18:37:12.012
	Select twimg as guidephoto, hpimg
	From countryphotos
	Where networkID = 77
		and twimg <> ''
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:37:12.012
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-04-05"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 18:37:12.012
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-07-05 00:00:00.000"
and logtime < "2020-07-05 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 18:37:12.012
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-06-28"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:37:12.012
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 18:37:12.012
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-04"
    and fromDate < "2020-07-05"
UpdatePageViews (Datasource=expert, Time=10ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 18:37:12.012
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb.cfm @ 18:37:12.012
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5162 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 18:37:12.012
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5162 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 18:37:12.012
SELECT tag
FROM natadoptions 
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
   and articleCategories.section = '9'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '5162'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-05"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
		and (((title LIKE '%hospital%') OR (hitopic LIKE '%hospital%') OR (hidescript LIKE '%hospital%')))
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '22'
   and articleCategories.section = '9'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '5162'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-05"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=9ms, Records=3) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 77 
and answers.answerid = allreports.answerid
and answers.reviewed = 'y'

    ORDER by allreports.answerid desc
    
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80459 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80459 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 80459 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80240 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80240 
getphotos (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 80240 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79260 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79260 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79260 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80459 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80459 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 80459 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80240 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80240 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 80240 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79260 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79260 
getphotos (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79260 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
checkbabyfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 77 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 18:37:12.012
		Select summary, hiimg 
		FROM answers
         where answerid = 24915
         and summary <> ''
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 18:37:12.012
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5162 
gettaxgeneral3 (Datasource=expert, Time=6ms, Records=5) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 18:37:12.012
	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 <> 5162
    and publishdate < "2020-07-05"
    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 @ 18:37:12.012
	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 <> 5162
    and publishdate < "2020-07-05"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 18:37:12.012
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-04"
    and fromDate < "2020-07-05"
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 18:37:12.012
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight = 10 
    and toDate > "2020-07-04"
    and fromDate < "2020-07-05"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 18:37:12.012
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 18:37:12.012
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-04 18:37:12'}
    and fromDate <{ts '2020-07-05 18:37:12'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 18:37:12.012
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 18:37:12.012
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5162 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 18:37:12.012
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5162 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80459 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80459 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80240 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80240 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79260 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79260 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80459 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80459 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80240 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80240 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79260 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79260 
checkbabyfeature (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 77 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 18:37:12.012
		Select summary, hiimg 
		FROM answers
         where answerid = 24915
         and summary <> ''


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=5162&networkid=77
REMOTE_ADDR=172.69.63.37
REMOTE_HOST=172.69.63.37
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=31111239
cftoken=22392207
sessionid=IBEXPATEXCHANGE.COM_31111239_22392207
urltoken=CFID=31111239&CFTOKEN=22392207
URL Parameters:
articleID=5162
networkid=77
Debug Rendering Time: 11 ms