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

Healthcare in Greece > Athens >

An Expat Talks about What is Was Like Having a Baby in Athens, Greece

Submitted by zera

What is the name of the city or town that you are reporting on?

Athens

How recently did you give birth in the country that you are reporting on?

9 months ago

Describe your experience giving birth there. What type of facility did you go to? What (if any) type of pain management did you use? How long did you stay in the hospital? Was it a positive experience? Etc...

For the private sector:

I chose my obstetrician first. He was affiliated with one of the 3 large private maternity clinics in Athens. It is a very large clinic.

Positive points: very clean, plenty of staff on hand 24 hours (even if they are rushed), very modern facilities.

Negative points: very expensive (around 2000 euros for the cheapest room option - 6 mothers sharing a room, not including doctors fee); impersonal; breastfeeding difficult because rooming in is near impossible; staff ill-informed about breastfeeding; Too many visitors and visiting hours are not strictly enforced by staff. I had natural childbirth with epidural. Hospital stay: 4 days. The birth experience was positive thanks to a fantastic UK-trained midwife and obstetrician. My experience with the clinic was very negative.

Expat Health Insurance in Greece

Expats interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

How did you choose your doctor, midwife or other type of medical professional?

I found my midwife by searching online, I found her website www.venusmed.gr and contacted them for an appointment. She works with her husband who is an obstetrician.

I was impressed by their attitude to natural childbirth (c-section is very common in Greece) and by the fact that they had worked in the UK for 10 years.

If you were to have another child in this country, would you do anything differently in terms of preparation and/or the delivery?

I'd like not to have to use the maternity clinic again but my obstetrician is affiliated with them. Otherwise, wouldn't do anything differently.

If a friend of yours living in the same country were expecting, what advice would you give her?

I would give her my doctor and midwife's contact details, would warn her about the prevalence of unnecessary c-sections, give her my book on breastfeeding. Dealing with the maternity clinics requires some know-how but luckily my midwife did this for me (insisted baby was brought to me whenever it cried, etc.), told them I didn't want a systematic enema when admitted for labour, etc. It's very useful to have someone else negotiate this stuff for you, the last thing you want when you're in labour is to have to argue with nurses.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in ParosHealthcare in Paros, Greece

Yes in pharmacy, sometimes no prescription needed. You pay 25% of the cost if a member of EOPPY

Healthcare in ParosHealthcare in Paros, Greece

An expat from the United Kingdom offers her insight into the health care system on the island of Paros in Greece. Information shared includes how it compares to the UK, pharmacies, cost and more.

Healthcare in ParosHealthcare in Paros, Greece

An expat on Paros Island in Greece offers insight about the quality and availability of healthcare on an island in Greece. Expats should be aware that there are no true hospitals on Paros Island.

expat healthcare surveyAnswer Questions about Healthcare in Greece

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

Having-a-Baby-In-GreeceExpats Talk about What it's Like Having a Baby in Greece

Read recent baby reports submitted for Athens and Athens.

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

Talk with Expats in Greece

If you're not involved in our Greece Forum, it's a great place to meet others in your area, get answers to questions about moving to Greece or offer advice to a newcomer.

More about Greece

4-Off-the-Beaten-Track-European-Retirement-Destinations

4 Off-the-Beaten Track European Retirement Destinations

Many Brits retire to Spain, Australia, Canada, and America and these countries have thriving expat communities. Ella Jameson talks about other retirement destinations that are sometimes overlooked.

Many Brits retire to Spain, Australia, Canada, and America and these countries have thriving expat communities. Ella Jameson talks about other retirement destinations that are sometimes overlooked....

Cigna International Health Insurance

Write a Comment about this Expat Report

Sign In to post a comment.
addacomment

Comments about this Report

Mommoy
Apr 5, 2020 01:57

Hi, I was wondering if I could get in touch with you to find out more info on your birthing experience and dr. I think I have the same dr and midwife team as yourself.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

healthcare in ParosHealthcare in Paros, Greece

Yes in pharmacy, sometimes no prescription needed. You pay 25% of the cost if a member of EOPPY -

healthcare in ParosHealthcare in Paros, Greece

An expat from the United Kingdom offers her insight into the health care system on the island of Paros in Greece. Information shared includes how it compares to the UK, pharmacies, cost and more. -

healthcare in ParosHealthcare in Paros, Greece

An expat on Paros Island in Greece offers insight about the quality and availability of healthcare on an island in Greece. Expats should be aware that there are no true hospitals on Paros Island. -

healthcare surveyAnswer Questions about Healthcare in Greece

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

Having-a-Baby-In-GreeceExpats Talk about What it's Like Having a Baby in Greece

Read recent baby reports submitted for Athens and Athens.

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

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /rspnet.cfm
Time Stamp 05-Jul-20 10:56 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.127
Host Name 172.69.63.127


Execution Time

Total Time Avg Time Count Template
99 ms 99 ms 1 top level /home/www/html/rspnet.cfm
45 ms 45 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
18 ms 18 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
18 ms 18 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
18 ms 18 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
11 ms 11 ms 1 /home/www/html/navtop_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/commentsnew_rdesign4.cfm
5 ms 5 ms 1 /home/www/html/rspnet_ctrygd_readnext.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navmpu_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navbottomad_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 3 /home/www/html/eetr/rewritetipheading.cfm
1 ms 1 ms 1 /home/www/html/rewritearticle.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 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navlikeandmore_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereportscountry.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
104 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 22:56:23.023
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 22:56:23.023
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 22:56:23.023
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 88
AND networkid = 47 
AND 22902 = answerid

GROUP BY answerid
ORDER by city
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:56:23.023
	Select *
	From allreports, citynetworks 
	Where allreports.answerid = 22902
	and allreports.citynetworkid = citynetworks.citynetworkid
getquestions (Datasource=reports, Time=5ms, Records=6) in /home/www/html/rspnet.cfm @ 22:56:23.023
SELECT DISTINCT questions.qid, answers.answerid, questions.question, responsequestions.qid, answerstext.qid, answerstext.answer as answer, answerstext.reviewed, answerstext.score, answers.rid, answers.reviewed, responses.intro, responses.responsename, responsequestions.listorder, answers.userid, answers.date
FROM responsequestions, questions, answers, responses, answerstext
WHERE answerstext.qid = questions.qid

AND 22902 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 22902 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:56:23.023
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 22902 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:56:23.023
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:56:23.023
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 47 
getcities (Datasource=expert, Time=0ms, Records=2) in /home/www/html/navmeta_rdesign4.cfm @ 22:56:23.023
	Select *
	From citynetworks
	Where networkID = 47
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:56:23.023
  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
GetMessages (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:56:23.023
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 22902 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
getalternatesummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:56:23.023
				SELECT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 22902
				AND answerstext.qid = 304 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:56:23.023
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-04-05"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:56:23.023
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
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=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:56:23.023
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-06-28"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:56:23.023
	SELECT *
	From contentcountcountry
	Where networkid = 47 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 22:56:23.023
	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=3ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 22:56:23.023
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getarticlesection (Datasource=expert, Time=0ms, Records=193) in /home/www/html/breadcrumb.cfm @ 22:56:23.023
SELECT *
FROM articleCategories
 
WHERE section = 9
checkcitynetwork (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb.cfm @ 22:56:23.023
		Select *
		FROM allreports, citynetworks
         where answerid = 22902
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
user (Datasource=forum, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:56:23.023
  SELECT *
  FROM users
  WHERE userid = 30222 
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:56:23.023
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 22902 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:56:23.023
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:56:23.023
	Select *
	From Networks
	Where networkid = 47 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:56:23.023
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:56:23.023
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 47
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-04"
and headerparagraphstart < "2020-07-05"
and headerparagraphstatus = 'live'

and headerparagraphweight = 'high'
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 47 
	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 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=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 47 
		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.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-05"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=10ms, Records=3) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 47 
and answers.answerid = allreports.answerid
and answers.reviewed = 'y'

    ORDER by allreports.answerid asc   
    
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76842 
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76842 
	AND answerstext.qid = 409
	
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76842 
	AND answerstext.qid = 410
	
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76842 
	AND answerstext.qid = 412
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76842 
getphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 47
	and fbimg <> ''
	
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 76842 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '47'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78631 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78631 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 78631 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '47'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79575 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79575 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79575 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '47'
checkbabyfeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 47 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:56:23.023
		Select summary, hiimg 
		FROM answers
         where answerid = 19301
         and summary <> ''
gettaxgeneral3 (Datasource=expert, Time=4ms, Records=1) in /home/www/html/rspnet_ctrygd_readnext.cfm @ 22:56:23.023
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 47 
	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 publishdate < "2020-07-05"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 22:56:23.023
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-04"
    and fromDate < "2020-07-05"
    and bannerPlacement.networkid = 47
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 22:56:23.023
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 22:56:23.023
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-07-04 22:56:23'}
    and fromDate <{ts '2020-07-05 22:56:23'}
    and weight > 7
    and bannerPlacement.networkid = 47
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:56:23.023
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-07-04 22:56:23'}
    and fromDate <{ts '2020-07-05 22:56:23'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:56:23.023
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 22:56:23.023
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 22902 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 22:56:23.023
  SELECT *
  FROM users
  WHERE userid = 226775 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76842 
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76842 
	AND answerstext.qid = 409
	
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76842 
	AND answerstext.qid = 410
	
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76842 
	AND answerstext.qid = 412
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76842 
getphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 47
	and fbimg <> ''
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 7 
getphotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 76842 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '47'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78631 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78631 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79575 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79575 
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:56:23.023
		Select summary, hiimg 
		FROM answers
         where answerid = 19301
         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/rspnet.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/rspnet.cfm
QUERY_STRING=rid=88&answerid=22902&networkid=47&start=22902
REMOTE_ADDR=172.69.63.127
REMOTE_HOST=172.69.63.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnet.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=31123119
cftoken=83519732
sessionid=IBEXPATEXCHANGE.COM_31123119_83519732
urltoken=CFID=31123119&CFTOKEN=83519732
URL Parameters:
answerid=22902
networkid=47
rid=88
start=22902
Debug Rendering Time: 11 ms