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

Ireland Expat Forum

Moving from Canada to Ireland

Post New Topic
Ridgeway
4/11/2019 08:50 EST

We are both 70 and retired. have dual citizenship (Irish and Canadian) and are seriously contemplating moving back to Ireland.
We need a lot of information and wonder if there is one central place we can get this information from or do we just post individual questions here on the forum?
The main information we need concerns, (1) paying taxes on Canadian pensions; (2) transferring money to Ireland; (3) Car insurance for over 70's; (4) getting an Irish driving license; (5) purchasing health insurance when over 70.
If anyone here can help with any of these questions, plus any other information we will be very grateful
Thank you so much.

Post a Reply

00abuse

dbarnwell
4/13/2019 09:33 EST

R:
Don't Do It.

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

Joshuak
4/13/2019 11:07 EST

I second dbarnwell. DO NOT permanently move back to Ireland. There are several reasons, foremost of which is the healthcare system. Ireland has a shortage of facilities and medical personnel. The systems are overloaded. At age 70 you are at an age when heath care may become your most important need, if not today, shortly in the future. Health Insurance is extremely expensive for someone 70+. Second, Ireland is not the country it was 10 , 20, or 30 years ago. I have lived there for about 1 1/2 years just as an "adventure" to use Ireland as a base for exploring Ireland and many other countries in Europe. I have Dual Citizenship and knew what I was getting into as I had visited many, many times. We had no intention of remaining for life in Ireland. Suggest you might do the same. Ireland is a great place to visit. My Grand parents brought their 7 children to the US in 1929 and not one ever went back to stay. Visits, yes, as we still have family in the Bantry bay area. My Mother was the last of the immigrants to pass at age 97. And as to this date, I know of none of the offspring of my mother's family to have moved to Ireland on a permanent basis. One Grandson lived there for a couple of years as his pharma company had him working first in Belgium and then Ireland. One of his children was born with direct Irish citizenship, but no one wanted to stay. They are all back in US now.

Post a Reply

00abuse

texbucki
4/13/2019 12:46 EST

My domestic partner and I are also moving to Ireland within the next couple of years and the intent is very aligned to Joshuak. Establish ordinary residence by hunkering down for the first year and then launching into our extended European retirement/nomad life style. I'm a dual citizen(US Irish) but my better half is US only. As we understand it, we need to demonstrate residence for a yr. to qualify for ordinary residence and an Irish healthcare plan. Since we're from the states, any healthcare plan is cheaper but if there is a better way of establishing ourselves as a resident of the EU and more affordable/better quality healthcare, I sure would be interested in hearing it. We're in our late 50's so our needs may be different than our wonderful neighbors to the north. We wish you luck none the less. Slainte!

Post a Reply

00abuse

DebAckley
4/13/2019 16:42 EST

Hi! I’m a dual too, my husband is not, but we had to bring our long form of our marriage certificate in order for him to stay more than 90 days. Then we had to report to the Garda Every 3 months. Check citizens information.ie. I’m not sure if you are not married if your partner can stay permanently. Best of luck ..IE is wonderful, but we did come back to NY...elderly parents and family. Cheers!

Post a Reply

00abuse

DebAckley
4/13/2019 16:42 EST

Hi! I’m a dual too, my husband is not, but we had to bring our long form of our marriage certificate in order for him to stay more than 90 days. Then we had to report to the Garda Every 3 months. Check citizens information.ie. I’m not sure if you are not married if your partner can stay permanently. Best of luck ..IE is wonderful, but we did come back to NY...elderly parents and family. Cheers!

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

Meachair54
4/13/2019 20:53 EST

Hello Ridgeway
Can’t really give much info on taxes insurance but as for drivers licenses look up on the NDLS website Ireland and Canada have agreements with some of the provinces in Canada where you can exchange divers licenses . I know car insurance is expensive for senior citizens too! Ian a dual citizen also but I live in Kerry 165 days a year., end of April to September so I use my U.S. drivers license and my U.S. health ins and just pay property tax to Ire. The rest of taxes to U.S.. Good Luck on your decision!!

Post a Reply

00abuse

Joshuak
4/13/2019 21:34 EST

I don't know where you are getting the idea you will qualify for Irish healthcare after a residence of one year ? You may not qualify at all. However, to get residency for your domestic partner, I believe you and your domestic partner only need to demonstrate and prove you have been living together for a particular period of time. If you both go to Ireland , you as a Irish citizen, and she as a tourist, get established in a residence with a postal address (Proof of same) then you both can go to a Garda (Police) Immigration inspector. If you can prove your "domestic union", then show her US passport, your Irish passport, and proof of residence, and there may be a test of your financial incomes, she should be able to get a one year Residence card and stamp 4 in her US Passport which allows her to be in Ireland for one year, This one year residency is renewable every year. If you retain this residency in Ireland, after 3 or 5 years your "domestic Partner" will be able to get Irish passport. (Not sure about 3 or 5 years as it was 3 years when my spouse got hers in 2014. Since then someone said it was changed to 5 years.) But depending on your income, and other factors, I would NOT depend on getting a Irish health card. If you are thinking the healthcare in Ireland is better than in US, you may be disappointed. If, and only IF you can get a health card, the problem with care in Ireland is availability. In some areas there are months long waiting lists for standard diagnostic tests. Many of the Irish that can afford it buy insurance. It is my understanding the Irish Government is going to completely change the present healthcare system, but as we all know, speed, is not a priority sometimes in Irish politics. Mind you, the Irish doctors are competent, but there just is not enough of them or facilities needed. Don't forget, any and all citizens of all other EU countries can move to Ireland and demand healthcare if they are low income and get a card. And immigrants the Irish Government took in on compassionate grounds also get healthcare. What you really need in regards to healthcare questions is for "Muddled" who works for the Irish Government to come on and give you some idea what you can expect. He is originally from the US and uses the Irish system. You can also look at Citizensinformation.ie.

Post a Reply

00abuse

texbucki
4/13/2019 22:36 EST

Hi Joshuak. Understand the domestic partner requirements. I also don't think we will qualify for a health card. I think I can apply for private insurance if I can prove I will be living for 1 yr (ie lease of flat) Sure don't believe we have the right answers just sharing the information we've been given to date. I actually applied to the 4 Insurance companies available through whatever websitte.ie and they told me I would be eligible for insurance with my partner for <400/month. In the states this would be 15 to 1800 /month so.....Looking for the safety net not necessarily the side by side comparison. I appreciate the warning though!

Post a Reply

00abuse

texbucki
4/13/2019 22:41 EST

Hah Funny. I was born in the Bronx. spent many years in the Hudson Valley as well. Beautiful country . Brother lives in the Adirondacks. In TX now but 25 yrs. in NY.

Post a Reply

00abuse

texbucki
4/14/2019 10:12 EST

I forgot to mention that when talking with the private insurers in Ireland, they mentioned there was a 5 yr wait period before any pre-exisiting conditions were covered. Hope that helps

Post a Reply

00abuse

DebAckley
4/14/2019 16:48 EST

Just wondering..why?

Post a Reply

00abuse

Joshuak
4/19/2019 17:21 EST

Ridgeway: In case you go in spite of advice. In regards to auto insurance: I Insured a car last in 2015, and I got it through a direct representative of Zurich which home office is in Switzerland. They had /have an office in Dublin. Yes, in general car insurance is hard to get from most Irish insurance brokers. They will ask one crucial question: Do you have a full Irish license ? If you say no, they will tell you they cannot sell you insurance. But when I got mine in 2013, and stayed with the same company through 2015, the main thing they wanted was a statement from my present Insurance company that we have been accident free for 5 years. It turned out my renewal document here in the US at that time had a entry showing how many years I had been accident free. (more than 5 years) I retained my regular coverage for the 2 US cars we had while we were gone as we did return every 6 months or less to satisfy our Medicare Advantage plan. and the cars were in our garage in our Florida home so they still needed insurance coverage. The Zurich Rep knew all this and he quoted me a approximate rate of 400 Euro per year prior to me coming to Ireland to live. Then when I arrived and bought a used car, I had to notify him and he would adjust the rate based on value of what I bought. It ended up at 420 Euro per year and was full coverage. I am not sure if they rate depending on where in Ireland you live or not. Both my Wife and I were included even though she was really hesitant to drive, especially with standard shift using the left hand. I think she drove it maybe 2 or 3 times. I understand a US company also writes in Ireland - Liberty Mutual, home office in Boston. But I would guess the Swiss company would be cheaper.

Post a Reply

00abuse

Joshuak
4/19/2019 17:38 EST

Texbucki: I case you did not know: If and when your domestic partner gets residency card and stamp 4 in her US passport, and you have a residence with postal address, you both will become eligible for a EU Health Insurance Card good for travel in any EU country. From what little I was told, you must have residence in Ireland to be able to use this card for emergency coverage while travelling. For example, if you gave up residence in Ireland and moved to France, you would have to get whatever they give you in France. As long as you have residence in Ireland you would retain coverage with this card. But it cannot be used in Ireland.

Post a Reply

00abuse

texbucki
4/21/2019 22:46 EST

Joshuak: Thankyou. I did not know. Surely more digging required. I've got a couple of yrs still but I was hoping my private insurance (obtained while living in Ireland) would cover me while traveling the first yr. in Europe. Still not sure whether it will make more sense to maintain a residence or purchase into a global plan once I become more mobile following the 1 yr residency period. Would surely be interested on your take. Thanks again

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Ireland.

International Moving Quotes

Moving to Ireland? Get a moving quote.


Mail Forwarding to Ireland

Mail Forwarding to Ireland.


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 Ireland from our partner, Cigna Global Health.
Get a Quote

Culture-Shock-in-North-TipperaryAn Expat Talks about Culture Shock & Living in North Tipperary, Ireland

An expat in North Tipperary talks about how she is adapting to expat life in Ireland. She appreciates the friendly shopkeepers, but has found that becoming part of the a small town community is a slow process.

An expat in North Tipperary talks about how she is adapting to expat life in Ireland. She appreciates the friendly shopkeepers, but has found that becoming part of the a small town community is a slow...

Living-in-TubbercurryAn Expat Discusses Living in Tubbercurry, Ireland

An expat living in Tubbercurry, Ireland (aka Tobercurry) talks about residency requirements, finding work in or near Tubbercurry, cost of living and more. She and her husband love being retired in Tubbercurry and appreciate how welcoming the locals are to outsiders.

An expat living in Tubbercurry, Ireland (aka Tobercurry) talks about residency requirements, finding work in or near Tubbercurry, cost of living and more. She and her husband love being retired in Tub...

10-Tips-for-Living-in-Ireland10 Tips for Living in Ireland

Expats living in Ireland say that the transition from tourist to expat is not as easy as one would think -- from challenges making friends with the Irish to the rainy, gloomy weather. Expats who make the effort and take their time are rewarded with life-long Irish friends and a love of Ireland.

Expats living in Ireland say that the transition from tourist to expat is not as easy as one would think -- from challenges making friends with the Irish to the rainy, gloomy weather. Expats who make ...

How-an-Expat-Retiree-Fought-to-Stay-in-IrelandHow an Expat Retiree Fought to Stay in Ireland

Expat retirees David and Maura Woods were given 7 days notice to leave Ireland. David shares his story, why they were asked to leave, and how they found a way to stay in the adoptive land they love.

Expat retirees David and Maura Woods were given 7 days notice to leave Ireland. David shares his story, why they were asked to leave, and how they found a way to stay in the adoptive land they love....

5-Tips-for-Tech-Jobs-in-Dublin5 Tips for Tech Jobs in Dublin

Expats in the tech industry in Dublin live in one of the most vibrant tech economies in the world. Ireland's favorable tax policies and other factors have made "Silicon Docks" a magnet for tech firms of all sizes.

Expats in the tech industry in Dublin live in one of the most vibrant tech economies in the world. Ireland's favorable tax policies and other factors have made "Silicon Docks" a magnet for tech firms...

12-Expats-Talk-about-Living-in-Ireland12 Expats Talk about Living in Ireland

Expats in Ireland talk about meeting people, expat life, cultural blunders and more. Some expats find it hard to make real friends and become part of community life.
Expats in Ireland talk about meeting people, expat life, cultural blunders and more. Some expats find it hard to make real friends and become part of community life....

Ireland 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 03-Jun-20 12:30 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.143
Host Name 172.69.63.143


Execution Time

Total Time Avg Time Count Template
127 ms 127 ms 1 /home/www/html/expat/Application.cfm
54 ms 54 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
53 ms 53 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
53 ms 53 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
35 ms 35 ms 1 /home/www/html/expat/messages_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
24 ms 24 ms 1 /home/www/html/expat/message_rdesign5.cfm
22 ms 22 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
11 ms 1 ms 15 /home/www/html/navvote_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/navtop_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 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 0 ms 15 /home/www/html/expat/common/formatmsg.cfm
1 ms 1 ms 1 /home/www/html/expat/ibstyle.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetModerators.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/constants.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_DesignSet.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 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/navjoin_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.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  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
127 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 @ 12:30:12.012
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=11ms, Records=1) in /home/www/html/expat/Application.cfm @ 12:30:12.012
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 12:30:12.012
	Select *
	From Networks
	Where frmid = 229 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 56 
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 229 
getcities (Datasource=expert, Time=1ms, Records=6) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
	Select *
	From citynetworks
	Where networkID = 56
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30: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
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
	Select *
	From Networks
	Where networkID = 56 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
  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 = 229 
  AND t.tpcid = 3436781 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=5ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
  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 = 3436781
  and  t.tpcid = 3436781
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=20) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 56
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=3ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
  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 = 3436781
  and  t.tpcid = 3436781
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=20, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:30:12.012
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 56
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:30:12.012
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 12:30:12.012
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-03 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 @ 12:30:12.012
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:30:12.012
	SELECT *
	From contentcountcountry
	Where networkid = 56 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 12:30:12.012
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:30:12.012
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 12:30:12.012
  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 = 229 
  AND tpcid = 3436781 
  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 @ 12:30:12.012
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 229
  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 @ 12:30:12.012
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 12:30:12.012
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=5ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 12:30:12.012
  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 = 3436781
  AND m.userid = u.userid
  AND topics.tpcid = 3436781
  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=14) in /home/www/html/expat/messages_rdesign5.cfm @ 12:30:12.012
  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 = 3436781
  AND m.userid = u.userid
  AND topics.tpcid = 3436781
    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 @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523734
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523734
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 12:30:12.012
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:30:12.012
	Select *
	From Networks
	Where networkid = 56 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:30:12.012
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:30:12.012
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 56
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-06-02"
and natforumstart < "2020-06-03"
and natforumstatus = 'live'

and natforumweight = 'high'
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523762
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523762
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523773
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523773
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523794
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523794
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523795
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523795
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 12:30:12.012
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:30:12.012
	Select *
	From Networks
	Where networkid = 56 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:30:12.012
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:30:12.012
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 56
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-06-02"
and natforumstart < "2020-06-03"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:30:12.012
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 1 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523829
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523829
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523832
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523832
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523837
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523837
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523838
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523838
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523860
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523860
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523883
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 523883
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 524478
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 524478
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 524483
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 524483
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 524794
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:30:12.012
SELECT vote
FROM votes
WHERE voteid = 524794
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=24ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 12:30:12.012
	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 = 56
	AND "2020-06-03" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkculturefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 12:30:12.012
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 56 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:30:12.012
		Select summary, hiimg 
		FROM answers
         where answerid = 73511
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 12:30:12.012
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 56 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:30:12.012
		Select summary, hiimg 
		FROM answers
         where answerid = 74598
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 12:30:12.012
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 56 
	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-03"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=4ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:30:12.012
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 56 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 12:30:12.012
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 29
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 12:30:12.012
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 56 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:30:12.012
SELECT  hiimg
FROM rptarticles
where rptarticleID = 29
and hiimg <> ''


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/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=229&tpcid=3436781
REMOTE_ADDR=172.69.63.143
REMOTE_HOST=172.69.63.143
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=28937718
cftoken=88398655
sessionid=IBEXPATEXCHANGE.COM_28937718_88398655
urltoken=CFID=28937718&CFTOKEN=88398655
URL Parameters:
frmid=229
tpcid=3436781
Debug Rendering Time: 51 ms