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

France Expat Forum

Medical Insurance - additional questions

Post New Topic
TraciD
9/23/2016 17:16 EST

Hi Expat Exchange,

I am a new member to this exchange, so apologies in advance, if I am repeating an earlier question/topic.

We are Brits, currently living in Canada (British-Canadians); and we are currently looking in to the possibility of moving to France (for many reasons). We no longer want to live in Canada.

Medical insurance is obviously a must; I have been told that if you have a previously-noted medical ailment, this will not be covered by any medical insurance - this seems a bit strange to me - does anyone have any feedback, experiences, or, advice regarding this?

On another note, I have been told that if you have a home in the UK, then you don't have to pay medical insurance in France - this won't apply to us, unfortunately (and this may change for others, if indeed true, once, and if, Brexit becomes reality).

Any feedback would be greatly appreciated.

Thanks :)

Traci

Post a Reply

00abuse

RubyTooz
9/26/2016 05:38 EST

Hi Traci,

Every legal resident of France must have health insurance. As British citizens, you will not need to request a long-stay visa to live in France (as the UK is still part of the EU for now), so won't have to show health coverage for the visa. If you are coming to work in France, you will join the public health system through your employment. If you are coming to retire, you will be able to request to join the system after three months of regular and stable residency. The French public health scheme is not free - you will have to pay contributions (premiums) just like every employee in the system does, whether via deductions from your paycheck or via a quarterly bill if you are inactive. What is important to you is that there are no age limits or exemptions for pre-existing conditions in the French public health system. Only private insurers refuse pre-existing ailments.

I don't think the information you received is correct about property in the UK exempting you from contributions for French public health insurance. The only way your EU citizenship covers your health costs is if: you've paid enough into the system (NHS in your case), and you've either reached state retirement age, started receiving a state pension, or are working on secondment in France.

Hope this helps,
Dennelle
www.renestance.com

Post a Reply

00abuse

expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Get a Quote

OldPro
9/26/2016 11:09 EST

It is always best to stick to ONE set of questions at a time. In this case, what applies to you as a Canadian citizen and then separately, what applies to a UK citizen.

Re pre-existing conditions, that applies when you need to have coverage during the time period between your Canadian provincial coverage and the start of your French state coverage. There's a gap in coverage which you can ONLY cover with private insurance. You may find it strange that pre-existing conditions may not be covered by private insurance, I would find it strange if they were.

A UK citizen who is resident (don't have to own property) in the UK and then decides to move to France comes under the EU laws and as such would have coverage continue seamlessly. But that is NOT your situation. You are not presently covered by the NHS. You could presumably go through a process of getting NHS coverage by staying in the UK and then moving to France. You would be covered IMMEDIATELY though if you moved to the UK first and so could avoid the gap in coverage and the need for private coverage. But that may not be a very practical solution.

So I would suggest that the SIMPLEST long term solution is to accept that you need private coverage between ending your provincial coverage in Canada and starting French state coverage after you have been resident long enough to apply.

That brings you back to how do you get private coverage for the pre-existing condition. It MAY be possible depending on what the pre-existing condition is and it may not. You also need to be looking for expat insurance, not travel insurance, they are not one and the same thing.
https://www.cignaglobal.com/difference-between-travel-international-health-insurance

I also think you need to give serious thought to what impact Brexit may have on your status in France if you are moving there as an EU national without a visa based on your UK citizenship. Depending on how long you have been resident in France when the actual exit date of the UK from the EU occurs, it could effect your status in France. No one can tell you what the effect will be. If you enter France as a Canadian on a visa and then apply for Residency as a non-EU national and are granted it, Brexit will have NO effect on your status.

You should contact some expat insurers regarding the pre-existing condition and see what they say re coverage. Basically, if there is likely to be major costs associated with the condition during the period of coverage, it may be hard to get insurance and you may need to consider having to pay for any treatment required. If the pre-existing condition while being chronic is not likely to need treatment, you may get coverage or it may not be covered but if no treatment is likely to be needed, you may be comfortable with taking that chance of having to pay for treatment yourself.

For example, if you have chronic bronchitis. It might not be covered but it also isn't likely to need any treatment in the near future. If you use an inhaler, well the cost isn't going to break the bank if you have to pay for it yourself.

On the other hand, if someone is on kidney dialysis twice a week, the cost is significant, coverage by private insurance unlikely to be found and so it could be a major factor in being able to afford to make the move.

Post a Reply

00abuse

frabound
9/26/2016 13:03 EST

I am following with interest and just learned something completely new re the quarterly payments into the system, so thank you! How much is the payment, or how is it calculated (single retiree)? Thank you again.

Post a Reply

00abuse

TraciD
10/13/2016 11:15 EST

Hi Dennelle,

Thank you so very much for your post, and all of the fabulous information.

We have tried to contact your website for further information, but notice that we need a Username and Password to gain access.

I have printed off the information, for future reference.

Is there any chance that you might be able to PM me with a username and password, so that we can possibly use your services closer to the time, of our move, for insurance and information in the future? Thank you. If not, no worries.

We are visiting France in May for a stay and to travel around; a fact-finding trip.

Thank you again Dennelle :)

Warm regards,

Traci

Post a Reply

00abuse

TraciD
10/13/2016 11:27 EST

Hi Old Pro,

Thank you for all of the great information that you provided.

There's so much to respond to, that, I am just going to say, that I agree with some of what you say, and you have given me lots to think about, so, thank you.

Yes, we could come and live in the UK again, prior to moving to France, and it's something that we are going to think about (we still have family in the UK); but, it's more likely that we will possibly move straight to France (once Brexit is all sorted-out, and, hopefully been placed in the garbage!) and we will have to buy the private insurance; it makes sense (albeit I am worried about a pre-existing health condition).

There is a lot to think about, and a lot to look in to. We have two to three years yet.

It was not easy moving to Canada from the UK, and I think that it will be even more difficult planning and moving to France - but hey, it makes life interesting!

Thanks again for your informative and interesting response.

Warm regards,

Traci

Post a Reply

00abuse

expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Get a Quote

RubyTooz
10/27/2016 12:17 EST

Hi TraciD,
Apologies about the website! It was down for a few days while we were abroad and couldn't fix it...you should have no problem now.
Feel free to send me a direct email if you like

Best regards,
Dennelle
www.renestance.com

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in France.

International Moving Quotes

Moving to France? Get a moving quote.


Mail Forwarding to France

Mail Forwarding to France.


Expat Tax

Expat Tax Preparation, Expat Tax Professionals

Join Today (free)

Join Expat Exchange to meet expats in your area or get advice before your move. It's FREE and takes 1 minute!

Cigna Expat Health InsuranceExpatriate Health Insurance

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

12-Expats-Talks-About-What-Its-Like-Moving-to-France12 Expats Talks About What It's Like Moving to France

Expats in France discuss the challenges and adventures of moving to France. From the high cost of living in France to what to bring when you move (and what to leave behind).
Expats in France discuss the challenges and adventures of moving to France. From the high cost of living in France to what to bring when you move (and what to leave behind). ...

EducationFinding the Right International School in France

Choosing an international school in France can be a difficult decision. This article provides an overview of some popular international schools in Paris and other areas of France.

Choosing an international school in France can be a difficult decision. This article provides an overview of some popular international schools in Paris and other areas of France....

Expat-France10 Tips for Living in France

Expats offer tips on health insurance, renting in Paris, culture shock, meeting people and more.

Expats offer tips on health insurance, renting in Paris, culture shock, meeting people and more....

Retiring-Abroad5 Great Places to Retire in Western Europe

We asked expats about great places to retire in Western Europe. While many Western European countries have prohibitively high living costs, there are a few areas that fit the retirement bill. These are some of the recommendations!

We asked expats about great places to retire in Western Europe. While many Western European countries have prohibitively high living costs, there are a few areas that fit the retirement bill. These ...

Retirement-In-Aude-and-Herault-DepartmentsAn Expat Shares What it's Like Retiring in Aude and Herault Departments, France

A couple from the UK who retired in France enjoy the cultural activities of nearby Carcassonne and Narbonne, being close to the coast and the beautiful vineyards that surround them. They confess to be having a tougher learning French than if they were younger, but know they will persevere.

A couple from the UK who retired in France enjoy the cultural activities of nearby Carcassonne and Narbonne, being close to the coast and the beautiful vineyards that surround them. They confess to...

France 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 /expat/index.cfm
Time Stamp 02-Jun-20 02:08 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.141
Host Name 173.245.54.141


Execution Time

Total Time Avg Time Count Template
129 ms 129 ms 1 /home/www/html/expat/Application.cfm
64 ms 64 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
64 ms 64 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
63 ms 63 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
36 ms 36 ms 1 /home/www/html/navcontentbox.cfm
24 ms 24 ms 1 /home/www/html/expat/messages_rdesign5.cfm
24 ms 24 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/expat/message_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 1 ms 7 /home/www/html/navvote_rdesign5.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 0 ms 7 /home/www/html/expat/common/formatmsg.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/ibstyle.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.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/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
129 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 02:08:15.015
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=11ms, Records=1) in /home/www/html/expat/Application.cfm @ 02:08:15.015
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 02:08:15.015
	Select *
	From Networks
	Where frmid = 211 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 45 
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 211 
getcities (Datasource=expert, Time=0ms, Records=13, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
	Select *
	From citynetworks
	Where networkID = 45
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
  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
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
	Select *
	From Networks
	Where networkID = 45 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
  SELECT f.frmid as frmid, frmname, t.tpcname, m.msgtext, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, t.tpcnamenew, t.summary, t.keywords, m.msgid
  FROM forums f, topics t, messages m  
  WHERE f.frmid = 211 
  AND t.tpcid = 3415423 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3415423
  and  t.tpcid = 3415423
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=27) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 45
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, t.tpcupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3415423
  and  t.tpcid = 3415423
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=27, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:08:15.015
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 45
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 02:08:15.015
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-03-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:08:15.015
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-06-02 00:00:00.000"
and logtime < "2020-06-02 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:08:15.015
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-05-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 02:08:15.015
	SELECT *
	From contentcountcountry
	Where networkid = 45 
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 02:08:15.015
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-01"
    and fromDate < "2020-06-02"
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 02:08:15.015
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 02:08:15.015
  SELECT catid, allowattach, isreviewed, isprivate, f.frmid as frmid, frmname, frmdesc, frmorder, frmpass, frmnotice, isapproved, f.isclosed as frmclosed, tpcname, tpcid, t.isclosed as tpcclosed, ispoll, isreviewed
  FROM forums f, topics t  
  WHERE f.frmid = 211 
  AND tpcid = 3415423 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=1ms, Records=0) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 02:08:15.015
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 211
  AND u.userdbname = "ee"
  ORDER BY u.username
GetCategory (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 02:08:15.015
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 02:08:15.015
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=5ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 02:08:15.015
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, topics.tpcname, forums.frmname, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3415423
  AND m.userid = u.userid
  AND topics.tpcid = 3415423
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
  AND m.isapproved = 1
  AND m.msgparent = 0
  AND m.isdeleted <> 1
GetMessages (Datasource=forum, Time=5ms, Records=6) in /home/www/html/expat/messages_rdesign5.cfm @ 02:08:15.015
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3415423
  AND m.userid = u.userid
  AND topics.tpcid = 3415423
    AND m.isdeleted <> 1
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
     AND m.msgparent <> 0
  AND m.isapproved = 1
   
    ORDER BY m.msgid ASC 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 383498
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 383498
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 02:08:15.015
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 02:08:15.015
	Select *
	From Networks
	Where networkid = 45 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 02:08:15.015
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 02:08:15.015
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 45
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-06-01"
and natforumstart < "2020-06-02"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high')
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 383558
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 383558
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 383592
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 383592
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 386528
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 386528
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 386531
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 386531
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 02:08:15.015
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 02:08:15.015
	Select *
	From Networks
	Where networkid = 45 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 02:08:15.015
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 02:08:15.015
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 45
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-06-01"
and natforumstart < "2020-06-02"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high' or natforumweight = 'low')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 02:08:15.015
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 1 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 389066
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 02:08:15.015
SELECT vote
FROM votes
WHERE voteid = 389066
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=25ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 02:08:15.015
	SELECT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 45
	AND "2020-06-02" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=7ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:08:15.015
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-02"
     
         and rptarticlenetworks.networkid = 45 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 02:08:15.015
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 3
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 02:08:15.015
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 45 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:08:15.015
SELECT  hiimg
FROM rptarticles
where rptarticleID = 3
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 02:08:15.015
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 45 
	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-06-02"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:08:15.015
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 45 
         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:08:15.015
		Select summary, hiimg 
		FROM answers
         where answerid = 65345
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=9ms, Records=0) in /home/www/html/navcontentbox.cfm @ 02:08:15.015
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 45 
          and date > '2013-04-01'
		order by date DESC


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/expat/index.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/expat/index.cfm
QUERY_STRING=frmid=211&tpcid=3415423
REMOTE_ADDR=173.245.54.141
REMOTE_HOST=173.245.54.141
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
MS=flat
Session Variables:
cfid=28855001
cftoken=60241996
sessionid=IBEXPATEXCHANGE.COM_28855001_60241996
urltoken=CFID=28855001&CFTOKEN=60241996
URL Parameters:
frmid=211
tpcid=3415423
Debug Rendering Time: 11 ms