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

Costa Rica Expat Forum

Residency Assistance

Post New Topic
TexCRbound
8/17/2018 10:26 EST

I am wanting to move to CR to retire in the next year. I have a limited income and would like to know if it is necessary to use an agency or attorney to apply for residency? I checked into one agency and the cost was $2800.00 per person. Is the application process to difficult to do for ones self? or is there any less expensive options?

Post a Reply

00abuse

Kohl
8/17/2018 10:49 EST

Most of the cost you stated are government fees, which you will have to pay regardless.

It is absolutely worth paying a representative to act on your behalf.

Fees:
https://outlierlegal.com/services/immigration/legal-fees-government-fees-and-expenses/

Post a Reply

20abuse

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

TexCRbound
8/17/2018 10:59 EST

Thank you Kohl,
That is exactly the type of information I need.

Post a Reply

00abuse

GillPhelan
8/17/2018 11:17 EST

I could not disagree more---the protocol has gotten so easy today that anyone can go get the NEWEST regulations and rules and if you have any bilingual help--certainly no lawyers needed--you can JUST DO WHAT IS WRITTEN JUST AS WRITTEN. Without exception most problems encountered with residency is traceable right back to crappy lawyers. Of course their are good ones but the process has gotten so easy I find it ridiculous that people anticipating a move to Costa Rica are being seen as not being able to follow very explicit directions. People on this forum really like to complicate the most simple matters.

Gill Phelan
www.gvecr.com

Post a Reply

00abuse

jim42
8/17/2018 11:35 EST

Try Mexico where cost of living is cheaper. I resided in CR many years ago,( for 3 1/2 yrs) and never felt comfortable and would not even visit that place. Been to MX 12 times and loved it. Felt very comfortable and no problems.

Post a Reply

00abuse

GillPhelan
8/17/2018 11:52 EST

Yep those mex cartel guys are a real barrel of laughs!

Post a Reply

10abuse

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

TexCRbound
8/17/2018 12:27 EST

Thank you for your response. I would like to avoid using an attorney if possible. I can definitely follow instructions, but I have had trouble finding the step by step process. Any suggestions on where to find it?

Post a Reply

00abuse

Blueridgeboy1
8/17/2018 14:49 EST

If you look over to the left, you will see a series of topics of interest to Expats. The bottom one, "Visas and Immigration" will lead you to the info you seek.

Post a Reply

00abuse

jim42
8/17/2018 15:35 EST

GilPhelan........keep watching TV and reading newspapers in the states. State Dept figures are roughly 1 million people from States live there both full time and snowbirds. Over 9 million tourists from States per year Enjoy your life in CR (remember to check 6 every hour)

Post a Reply

00abuse

ILuvCR
8/17/2018 15:37 EST

OK gil, mister "it's so easy",

the man heard who and wrote " I can definitely follow instructions, but I have had trouble finding the step by step process. Any suggestions on where to find it? "

Let's see what ya got?

Post a Reply

00abuse

GillPhelan
8/17/2018 15:37 EST

To make sure it is the latest and greatest go right into Migration and they will hand you a copy of what needs to be done.

Post a Reply

00abuse

ILuvCR
8/17/2018 15:46 EST

hey jim42,

it is the "Costa Rica Expat Forum" why not move on?


Pura Vida!

Post a Reply

00abuse

GillPhelan
8/17/2018 16:18 EST

Funny thing about FACTS---your opinion doesn't effect them. So the FACT that the cartels chop off heads at an ever increasing rate and now are nice enough to include high traffic tourist destinations make the comment about it being a safer/better place than Costa Rica ridiculous. My trips to Cancun, Cozumel, Tulum and Del Carmen stopped years ago and I am not going back. I may however go back to Isle Mujeres. Glad your optics keep the truth foggy but my own experience and the FACTS of how dangerous Mexico is now will not be swayed by your opinion. Costa Rica and my lovely Tico family is my choice any day of the week.

Post a Reply

00abuse

GillPhelan
8/17/2018 16:51 EST

Well if walking into migration and getting handed the latest and greatest rules and regs (which I have personally done on several occasions) is too hard for some people the logistics of moving to CR would surely be impossible.

Post a Reply

00abuse

lindyluvsCR
8/17/2018 16:57 EST

TexCRbound - We got ours for $3600 both of us or $1800 each. I also know of newbees that have been charged that same price recently and everything went very smooth.

Post a Reply

00abuse

scalnew
8/17/2018 19:02 EST

I've just gone through the process on my own behalf because my lawyer wanted to charge too much and he kept making mistakes. I did everything myself for a lot less money. The big expenditure is paying the initial fee which if you're applying outside of Costa Rica is only about $50 but if you're applying inside Costa Rica it's $200, I think is what I paid. It's time consuming either way. There's no fast way. But it's just a question of submitting some documents i.e. birth certificate properly certified, background check properly certified (apostille), proof that your income is at $1000/month, etc. You'll have to resign yourself to making a few trips to the immigration offices and wait in line for an hour or two. There are seats to sit in and since you are 65 or over you have a legal right to go to the head of the line without waiting. It's exactly what your lawyer would have to do but you'd have to pay him at least $1000. If you do it yourself it's a lot cheaper. If you don't speak Spanish you'd probably need a translator to go with you however. Just paying a Tico 10,000colones ($20) would be a reasonable rate. Or you could pay someone $40 and just have them do it for you for the day. You don't need a lawyer.
Here's the rundown at this link:
https://costaricalaw.com/costa-rica-legal-topics/immigration-and-residency/residency-general-information-and-summary/
Here's the Spanish version for your translator:
http://www.tramites.go.cr/catalogotramites/MantCatalogo.aspx?id=1511&t=4&i=300&d=129

Post a Reply

00abuse

Kohl
8/17/2018 19:39 EST

scalnew, your expenses are not finished yet, though ...so expect to have to pay out some more 8-(

Check out the Govt. fees ( not including lawyer fees):

https://outlierlegal.com/services/immigration/legal-fees-government-fees-and-expenses/


Good luck!

Post a Reply

00abuse

GillPhelan
8/17/2018 20:35 EST

Yep--that's about it and to pay lawyers thousands is certainly a choice you can make.

Post a Reply

00abuse

NothingButNet
8/18/2018 00:01 EST

TexCRbound, how is your Spanish? I got my residency without a lawyer and had no problem. Spanish language skills would definitely help you understand and work through the bureaucracy. The CR Migracion website has instructions to get you started. Be patient and good luck.

Post a Reply

00abuse

TexCRbound
8/18/2018 01:15 EST

unfortunately, i speak very little spanish. I am trying to learn now.

Post a Reply

00abuse

TexCRbound
8/18/2018 01:15 EST

unfortunately, i speak very little spanish. I am trying to learn now.

Post a Reply

00abuse

TexCRbound
8/18/2018 01:16 EST

Thank everyone for your input! You all have been a great help. I hope to be meeting some of you in the future.

Post a Reply

00abuse

TexCRbound
8/18/2018 01:16 EST

Thank everyone for your input! You all have been a great help. I hope to be meeting some of you in the future.

Post a Reply

00abuse

Roseanna
8/18/2018 08:15 EST

My husband and I have now lived her 3 years and still speak poor to little Spanish. Locals tell us all the time... "dia y dia ... day by day. Aprendo mi dia y dia
I learn day by day. And I probably spelle Learn (aprendo) wrong as I is E and E is A.... ha ha ha. And x is S and Green roof is Verdi (what ever the word for roof is)...or cold water is aqua Friea which to me is water cold not cold water...

Post a Reply

00abuse

scalnew
8/19/2018 16:00 EST

Sorry to hear that, Kohl. :-(

Post a Reply

00abuse

horsenut2000
8/19/2018 16:02 EST

I've been reading the responses on this topic and finding them very helpful. Just have one question. If someone starts the application process from the U.S., and say it gets approved in a year (or whenever), does anyone know the requirements at that point of having to move to CR? Is there a time limit there?

Post a Reply

00abuse

Kohl
8/19/2018 16:52 EST

Not, to actually move, but you will have to be here to finalize the process. This means signing up for CAJA, the healthcare system and apply for your cedula, for which you will have to have so set an appointment.

Post a Reply

00abuse

horsenut2000
8/19/2018 16:54 EST

Ok. Just curious from the time a person is eligible at that point before they have to make that final appointment. I'm sure they would tell you but a lot of things can happen in a years time.

Post a Reply

00abuse

Kohl
8/19/2018 18:29 EST

Not sure what you're getting at?

Post a Reply

00abuse

horsenut2000
8/19/2018 18:55 EST

Ok, so say I start the application process today. Fast forward 1 year and I am at the point where they are ready for me to make my appointment to finalize the application. Maybe I have some family commitments that mean I won't be able to go down for 6 months. How long will they keep it open before closing the file and requiring you to start the process all over again?

Post a Reply

00abuse

Kohl
8/19/2018 19:07 EST

I think it is 3 months, but you would have to check that.

Note that most lawyers require all the funds up front...as many applicants change their minds, and you won't get a refund.

Visit a few time before starting the process.

Sorry to say, that I don't think the type of business you mention that you re presently involved in, is something that would 'go down well' here.

Post a Reply

00abuse

horsenut2000
8/19/2018 19:17 EST

From what I've read on here, if you can follow instructions, there is no reason to use a lawyer.

Post a Reply

00abuse

lindyluvsCR
8/19/2018 22:06 EST

I need to jump in with my thoughts or even questions. We do have our residency, and I got the documents together that were needed, and I did all of them correctly. Takes being detailed and thorough. But we did use a lawyer, and he did a good job and stuck fully to his quote.

But without him, if I had to do it today and did not know Spanish, nor the area, I would today have a problem finding Immigration and where to get fingerprints. But there were umpteen buildings there, and trying to find the right line to get in and remembering which building. And then it was noisy, and even though at that point in time the lawyer was not with us,`they would holler the instructions and it was a miracle we could even understand our name as mis-pronounced it so much barely could recognize.

Years ago, I read that you could hire a runner that would guide you through to process there. Even though I speak Spanish well, to me, I wouldn't be able to find the fingerprint building or right line at Immigration. That is the problem I would have.

I also read once, that if you don't have a lawyer or a 'runner' or whatever he was called, they kind of play their ignoring games or head games that they can at times do, and make it take a whole lot longer and difficult.

Post a Reply

00abuse

horsenut2000
8/19/2018 22:09 EST

Thank you for thoughts. I have no issues hiring someone at the point of making an in-person visit to assist with those things, but I think I can fill out the paperwork.

Post a Reply

00abuse

PombinhaCoco7
8/20/2018 04:54 EST

Kohl,
Just a few things:
Yes, there are many "hidden" expenses that you are not told in the beginning, such as the deportation fees.
Anyway, after I got all my documents notarized, authenticated by the Global Affairs (former Foreign Affairs) and authenticated by the Embassy of Costa Rica, I felt very tempted to go to San Jose myself to file it with Immigration.
The reason why I didn't it was because someone told me at the time that if you do it yourself many times when you call them in order to know how things are going, that they (the Immigration) would tell you that they couldn't find your process.
Not sure if this was true but that's what I heard., that they prefer to work with a lawyer.
One of my neighbors took so long to gather all the documents after the lawyer opened her a file with Immigration that they froze her process.
Then she had to pay much more to the lawyer.
In case some of you here don't know, the interview is in Spanish. They will separate the wife from the husband (different rooms at the same time) but they are not trying to trick you. They ask simple questions.
We had to go to a second interview in Liberia where they took our fingerprints again and one more photo.
Actually I found the last part of the process more complicated.

Post a Reply

00abuse

lindyluvsCR
8/20/2018 06:35 EST

Horsenut - As I remember, there is no paperwork to fill out - just presenting needed documents.

Post a Reply

00abuse

GillPhelan
8/20/2018 08:41 EST

That is the typical lawyer scenario and one they love---either you or they take so long to do the work you basically have to start over and of course keep paying their fees! It would be their job to make sure they keep you moving and get things in on time but why would they do that?? I go back to my initial feeling about this whole subject--you are moving to another country and handling all those things so this residency thing is all part of it and nothing to be afraid of handling yourself.

Gill Phelan
www.gvecr.com

Post a Reply

11abuse

lindyluvsCR
8/20/2018 17:14 EST

Gill - We never had a problem with our lawyer. He kept to his quote. I never called him ONE time to bug him. Had cedula in 9 months.

Have friends who are using someone now, with same price as we had 3-1/2 yrs ago. She helps with each step, and are reportedly getting in less time than we did, and received their Expedientes in 3-4 days.

She made everything as easy as possible. She specializes in getting residencies and does most on-line until the end when she goes with them personally.

Post a Reply

00abuse

GillPhelan
8/20/2018 17:18 EST

Even a blind squirrel finds a nut once in a while! LOL Not that you are a blind squirrel but you did get lucky. I have been reading (and paying for) this forum for over 10 years I think---and if you look back over time just about every single problem with the paperwork always relates back to a lawyer--just one of those facts of life I guess.

Gill Phelan

Post a Reply

00abuse

PombinhaCoco7
8/20/2018 19:16 EST

There are many good lawyers out there and some not so good.
In fact the Immigration lawyer we used helped to write the new Immigration laws of Costa Rica.
Now something funny: I have given her email adress to so many people and mentioned her in this forum and never made a penny out of it.
Suddenly I actually got an email saying that because I referred her to a certain guy in Canada who is applying for residency with her I'm entitled to a commission.
No wonder a while ago someone here was "fighting" over who had suggested a certain lawyer first.
It was about my lawyer.
To me it's weird because I already referred her so many times.
Those who live in other areas of Costa Rica have more choices but here she seems to be the best.
A Canadian lady here paid 600.00 to another lawyer and she ended up hiring mine.On the other hand I know a New Yorker who hired a lawyer in Liberia and he was very happy with
him.

Post a Reply

00abuse

NothingButNet
8/21/2018 13:35 EST

I have property-related and corporation experience with over a dozen attorneys in CR and have found that more than half of them are sheisters or incompetent. We did not lose a great deal of money with the bad ones because we recognized real quick what they were doing and walked away before it was too late.

Good article on this topic in the paper this morning (pasted below). Interesting comments to the article at the bottom.

https://news.co.cr/costa-rican-lawyer-found-guilty-of-embezzlement-of-41-million-usd-which-was-the-product-of-the-inheritance-of-a-german-citizen/75363/

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Costa Rica.

International Moving Quotes

Moving to Costa Rica? Get a moving quote.


Mail Forwarding to Costa Rica

Mail Forwarding to Costa Rica.


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

Culture-Shock-in-Mal-PaisAn Expat Talks about Culture Shock & Living in Mal Pais, Costa Rica

An expat in Mal Pais, Costa Rica provides a detailed culture shock report that offers a great example of someone who has learned to roll with the punches that come with expat life in a somewhat remote location. Covers everything from mosquitoes, to finding products from the local grocer, to getting your laptop repaired. And don't for get about the fruit bats and monkey poop!

An expat in Mal Pais, Costa Rica provides a detailed culture shock report that offers a great example of someone who has learned to roll with the punches that come with expat life in a somewhat remote...

Living-in-MatapaloAn Expat Discusses Living in Matapalo, Costa Rica

An expat in Matapalo, Costa Rica talks about living in this laid back beach town on the southern Pacific coast of Costa Rica. He advises other newcomers to be prepared to blend in and slow down.

An expat in Matapalo, Costa Rica talks about living in this laid back beach town on the southern Pacific coast of Costa Rica. He advises other newcomers to be prepared to blend in and slow down. ...

10-Tips-for-Living-in-Costa-Rica10 Tips for Living in Costa Rica

Should you wear jeans and a t-shirt in San Jose? Did you know that one place may have twice the rain and be windy compared to another place 10km away? Read our 10 Tips for Living in Costa Rica for insights from expats who have been there and done that.

Should you wear jeans and a t-shirt in San Jose? Did you know that one place may have twice the rain and be windy compared to another place 10km away? Read our 10 Tips for Living in Costa Rica for i...

Best-Places-to-Live-in-Costa-Rica7 Best Places to Live in Costa Rica

Costa Rica is a relatively safe, eco-friendly, expat-friendly destination with gorgeous beaches and friendly locals. Many expats say that housing and food prices in Costa Rica are high. We've gathered information submitted by expats about Tamarindo, Dominical, Ojochal, Atenas, Escazu, Grecia and others popular towns.

Costa Rica is a relatively safe, eco-friendly, expat-friendly destination with gorgeous beaches and friendly locals. Many expats say that housing and food prices in Costa Rica are high. We've gathere...

5-Tips-For-Living-in-San-Jose,-Costa-Rica5 Tips For Living in San Jose, Costa Rica

The majority of expats in San Jose, actually choose to live not in the city, but outside of it. There are great options in the surrounding area, including places that are closer to the coast than San Jose.

The majority of expats in San Jose, actually choose to live not in the city, but outside of it. There are great options in the surrounding area, including places that are closer to the coast than San...

Top-5-Reasons-Expats-Move-to-Central-AmericaTop 5 Reasons Expats Move to Central America

From lower cost of living to affordable healthcare and beachfront living, expats discuss the top reasons they moved to Central America.
From lower cost of living to affordable healthcare and beachfront living, expats discuss the top reasons they moved to Central America....

10-Expats-Talk-About-What-Its-Like-Living-in-Costa-Rica10 Expats Talk About What It's Like Living in Costa Rica

Expats living in Costa Rica talk about Pura Vida, deciding where to live in Costa Rica, meeting people and more.
Expats living in Costa Rica talk about Pura Vida, deciding where to live in Costa Rica, meeting people and more....

Costa Rica 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 27-May-20 08:26 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.145
Host Name 173.245.54.145


Execution Time

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

and (natforumweight = 'medium' or natforumweight = 'high')
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491132
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491132
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491136
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491136
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491137
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491137
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491138
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491138
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 20:26:24.024
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 20:26:24.024
	Select *
	From Networks
	Where networkid = 33 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 20:26:24.024
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 20:26:24.024
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-26"
and natforumstart < "2020-05-27"
and natforumstatus = 'live'

and natforumweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 20:26:24.024
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 @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491143
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491143
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491172
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491172
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491190
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491190
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491191
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491191
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491192
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491192
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491193
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491193
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491201
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491201
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491202
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491202
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491205
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491205
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491220
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491220
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491223
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491223
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491236
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491236
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491257
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491257
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491264
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491264
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491265
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491265
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491266
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491266
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491267
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491267
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491294
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491294
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491474
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491474
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491475
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491475
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491478
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491478
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491479
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491479
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491495
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491495
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491498
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491498
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491500
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491500
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491502
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491502
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491520
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491520
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491522
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491522
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491540
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491540
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491545
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491545
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=2) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491560
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491560
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491637
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491637
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491638
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491638
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491648
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491648
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491761
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 20:26:24.024
SELECT vote
FROM votes
WHERE voteid = 491761
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=21ms, Records=6) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 20:26:24.024
	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 = 33
	AND "2020-05-27" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkculturefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 20:26:24.024
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 33 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:26:24.024
		Select summary, hiimg 
		FROM answers
         where answerid = 74288
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 20:26:24.024
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 33 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:26:24.024
		Select summary, hiimg 
		FROM answers
         where answerid = 74617
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 20:26:24.024
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 33 
	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-05-27"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 20:26:24.024
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-27"
     
         and rptarticlenetworks.networkid = 33 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=6, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 20:26:24.024
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 9
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 20:26:24.024
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 20 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:26:24.024
SELECT  hiimg
FROM rptarticles
where rptarticleID = 9
and hiimg <> ''
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 20:26:24.024
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 15
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 20:26:24.024
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 33 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:26:24.024
SELECT  hiimg
FROM rptarticles
where rptarticleID = 15
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=194&tpcid=3432616
REMOTE_ADDR=173.245.54.145
REMOTE_HOST=173.245.54.145
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=28546208
cftoken=28006421
sessionid=IBEXPATEXCHANGE.COM_28546208_28006421
urltoken=CFID=28546208&CFTOKEN=28006421
URL Parameters:
frmid=194
tpcid=3432616
Debug Rendering Time: 12 ms