Take the 2020 Expat Exchange Survey

Expat Finance

Expat tax and finance are all daunting issues for new expats.

Expert Tax Tips

When living abroad, make sure you know you're not 'invisible' to the taxman!
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

The Foreign Account Tax Compliance Act (FATCA) has allowed governments to crack down on people trying to avoid their tax liability. Governments around the world are working together to make sure you're paying the taxes you're supposed to. Most financial institutions are reporting financial data to their governments, who are turning information over the IRS. It's best to not avoid your taxes - simply ... Continue Reading

Be aware of the intricacies of renouncing your US citizenship.
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

While renouncing citizenship has become a popular thing to do, you should know it doesn't automatically help you avoid US taxes. In order to renounce, you must prove that you've been compliant on the last five years of US taxes. Also, depending on your income and net worth, you may be subject to an 'exit tax' when you renounce. ... Continue Reading

Hold on to your IRS records for at least six years.
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

The audit time period recently changed from three years to six years, so it's important to keep accurate records and documentation during this time frame. ... Continue Reading

Do your research to know if you're required to file a state tax return.
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

If you have any ties to the state, like mortgage payments on property, a state driver's license, voter registration, etc., you may be responsible for filing state taxes until and unless you can prove residency in another state. This varies by state, so be sure to review your state's tax guidelines. ... Continue Reading

Be sure to keep track of the FBAR filing deadline to avoid penalties.
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

Currently, the FBAR is due June 30, 2016 for the 2015 filing year with no filing extensions. Beginning next year, the deadline is moving to the same day as Tax Day - April 15th - and you'll have the same filing extension options as you do for your tax return. You'll receive an automatic two-month extension if you're living overseas on April 15th, and may request an extension up until October 15th.... Continue Reading

See if you qualify for the Foreign Earned Income Exclusion by passing a residency test.
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

There are two types. The first is the Physical Presence Test, which requires that you are physically present in a foreign country for 330 of any 365-day period. The second is the Bona Fide Residence Test, which requires you to have lived overseas for at least one calendar year and have no immediate intention of moving back to the US.... Continue Reading

Know the ins and outs of taxation related to your Social Security benefits.
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

You must report your Social Security benefits as income on your expat tax return. Generally, if you have other income, your benefits will be taxed. If they are, only 85% of your benefits can be considered taxable income.... Continue Reading

Continue to receive your Social Security benefits when retiring abroad.
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

If you're considering retiring abroad, you'll be able to collect your Social Security benefits in just about any country in which you choose to live. There are just a few countries where you cannot receive your benefits - but you can always collect all monies owed to you when moving to a country that allows US Social Security payments.... Continue Reading

Catch up on your tax returns and FBAR forms without penalties.
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

If you didn't realize you needed to file your expat taxes or FBAR forms, the IRS has an amnesty program you may use to catch up on your filing. The Streamlined Filing Procedures allows you to become compliant with no late filing or FBAR penalties. Simply file the past three years of tax returns and last six years of FBAR forms. ... Continue Reading

Know the US tax filing deadlines and file an extension if needed.
by Expert Tax Advisor David McKeegan, Greenback Expat Tax Services

If you're living outside the US on Tax Day (April 15th), you have until June 15th to file your expat taxes. It's important to note, though, if you owe taxes, the amount owed is still due by April 15th. Any taxes owed will accrue interest until you make the payment. ... Continue Reading

Expat Tax & Overseas Tax

Expat tax is one of the most important aspects of managing one's finances after a move abroad. Do not neglect offshore tax issues or wait until the last minute to explore the financial implications of international living. The articles below will help you start your research into expat taxes.

Expat Taxes -- Top Tax Updates Expats Should Know for 2017

It's time for U.S. expats to explore what they'll need to file properly for the 2016 tax year. David McKeegan of Greenback Expat Tax Services offers tax bracket information and others facts you need to know.

Expat Tax -- What Every U.S. Expat Needs to Know about Taxes

Cody Moore discusses FATCA and other reporting requirements for US expats including FINCEN Form 114, Form 8938, Form 5471 and Form 8865.

Expat Taxes -- June Is a Big Month for Expats - Here's Why!

Expat tax expert David McKeegan explains why June is such an important month for U.S. expats. From expat tax returns to FBAR, find out why you can't let the sixth month of the year sneak up on you!

Expat Finance & Offshore Investment

Expat finance requires proper research while living overseas. Expats are often exposed to offshore investment opportunities not available at home. The articles in this section provides basic overseas finance information to consider while living abroad.

Expat Tax -- What Every U.S. Expat Needs to Know about Taxes

Cody Moore discusses FATCA and other reporting requirements for US expats including FINCEN Form 114, Form 8938, Form 5471 and Form 8865.

Are You Financially Ready to Live Abroad? -- 7 Financial Tips To Help You Live A Global Lifestyle

Whatever your reasons for wanting to live overseas and enjoy a global lifestyle, one thing you can still count on, is that you will have to manage your finances. Lisa R. Mitchell discusses financial tips for expats.

Managing Currency Risk -- Practical Guide to Building a Globally Diversified, Multi-currency Investment Portfolio

David Kuenzi explains how to properly incorporate currency considerations into a sound, long-term investment strategy is much easier than commonly understood.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-TokyoAn Expat Talks about Culture Shock & Living in Tokyo, Japan

An expat talks about what it's like moving to Tokyo. It took some time adjusting to the crowds and culture, but he's happy now and looking back the culture shock wasn't as bad as he anticipated.

An expat talks about what it's like moving to Tokyo. It took some time adjusting to the crowds and culture, but he's happy now and looking back the culture shock wasn't as bad as he anticipated....

Living-in-TaguigAn Expat Discusses Living in Taguig, Philippines

An British expat talks about spending winters in Taguig, Philippines with his Filipina wife of 25 years. He does miss chatting with other English speakers and hopes to find some expat clubs in Bonifacio Global City.

An British expat talks about spending winters in Taguig, Philippines with his Filipina wife of 25 years. He does miss chatting with other English speakers and hopes to find some expat clubs in Bonifa...

Now-is-the-Time-To-Dream-of-Living-AbroadNow is the Time To Dream of Living Abroad

People all over the world dream of being an expat. Living in another country is an experience unlike any other, and now is definitely the time to explore what it would mean to take the plunge.

People all over the world dream of being an expat. Living in another country is an experience unlike any other, and now is definitely the time to explore what it would mean to take the plunge....

Expats-Talk-About-The-Biggest-Challenges-They-Face-Living-in-Latin-AmericaExpats Talk About The Biggest Challenges They Face Living in Latin America

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint: you'll be much happier if you learn the language) and adjust your expectations (realities: the roads are rough, the pace of life is slower and bureaucracy is unavoidable). Despite all of the challenges, the list of what expats like about life in Latin America far exceeds the challenges.

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint:...

Costa-Rica-vs-PanamaCost of Living: Costa Rica vs. Panama

People considering a move to Central America often narrow down their list to Panama and Costa Rica. Expats talk about the cost of living in Panama and Costa Rica - housing costs, gas, car, electric, internet, groceries, budgets for various lifestyles and more.

People considering a move to Central America often narrow down their list to Panama and Costa Rica. Expats talk about the cost of living in Panama and Costa Rica - housing costs, gas, car, electric, ...

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /offshorebanking.cfm
Time Stamp 03-Jun-20 02:48 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.69
Host Name 173.245.54.69


Execution Time

Total Time Avg Time Count Template
1251 ms 1251 ms 1 /home/www/html/offshorebanking.cfm
7 ms 7 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navcontentbox.cfm
4 ms 4 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 0 ms 10 /home/www/html/eetr/navconstants.cfm
1 ms 0 ms 10 /home/www/html/eetr/rewriteexpertname.cfm
1 ms 0 ms 40 /home/www/html/eetr/rewritetipheading.cfm
1 ms 1 ms 2 /home/www/html/navinjection.cfm
1 ms 1 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 2 /home/www/html/rewritecityname.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/constants.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 9 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
43 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1298 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 02:48:38.038
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 02:48:38.038
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
gettaxgeneral (Datasource=expert, Time=6ms, Records=3) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 358
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.general = 'y'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and publishdate < "{d '2020-06-03'}"
    ORDER by articles.articleID desc
getbankinggeneral (Datasource=expert, Time=6ms, Records=3) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 357 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.general = 'y'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and publishdate < "2020-06-03"
    ORDER by articles.articleID desc
getfinancegeneral (Datasource=expert, Time=6ms, Records=3) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 356 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.hihp <> 'n'
    and articles.hinet <> 'n'
    and articles.general = 'y'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and publishdate <  "2020-06-03"
    ORDER by articles.articleID desc
getlistingstax (Datasource=expert, Time=0ms, Records=2) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.homepage, Resources.directlink, Resources.includelink
    From Resources, resourcePlacement, resourceCats
    WHERE 8 = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	AND Resources.type <> 'hold'
	AND Resources.type <> 'guide'
	and Resources.type  <> 'local'
	and Resources.type  <> 'free'
	and Resources.type  <> 'affiliate'
	and Resources.type  <> 'locaff'
	and Resources.type <> 'bonusonly'
   and Resources.bid <> 'yes'
    and todate >  "2020-06-02"
    and fromdate <  "2020-06-03"
	AND resourcePlacement.networkID = '358'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
getlistingsfinance (Datasource=expert, Time=1ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.homepage, Resources.directlink, Resources.includelink
    From Resources, resourcePlacement, resourceCats
    WHERE 7 = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	AND Resources.type <> 'hold'
	AND Resources.type <> 'guide'
	and Resources.type  <> 'local'
	and Resources.type  <> 'free'
	and Resources.type  <> 'affiliate'
	and Resources.type  <> 'locaff'
	and Resources.type <> 'bonusonly'
   and Resources.bid <> 'yes'
    and todate >  "2020-06-02"
    and fromdate <  "2020-06-03"
	AND resourcePlacement.networkID = '356'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:48:38.038
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:48:38.038
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 159 
getcities (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:48:38.038
	Select *
	From citynetworks
	Where networkID = 159
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:48:38.038
  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
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 02:48:38.038
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.69'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:48:38.038
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.69'
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=1) in /home/www/html/navtop_rdesign5.cfm @ 02:48:38.038
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.69'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
gettopbanner (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 02:48:38.038
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
	and weight = 5
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 02:48:38.038
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 02:48:38.038
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 874 
GetClassifieds (Datasource=tipripper, Time=27ms, Records=10) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
SELECT *
FROM allreports, Networks, expertusers
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 5
and expertusers.userid = allreports.userid
and expertusers.experttype = 'tax'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5 
user (Datasource=forum, Time=1ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78360 
gettipphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 78360
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
gettipphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:38.038
	SELECT DISTINCT hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78360 
getauthor (Datasource=forum, Time=110ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
user (Datasource=forum, Time=0ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78305 
gettipphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 78305
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
gettipphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78305 
getauthor (Datasource=forum, Time=109ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
user (Datasource=forum, Time=0ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78256 
gettipphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 78256
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
gettipphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78256 
getauthor (Datasource=forum, Time=110ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
user (Datasource=forum, Time=0ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78193 
gettipphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 78193
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
gettipphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78193 
getauthor (Datasource=forum, Time=111ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
user (Datasource=forum, Time=0ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78124 
gettipphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 78124
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
gettipphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78124 
getauthor (Datasource=forum, Time=111ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
user (Datasource=forum, Time=0ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78098 
gettipphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 78098
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
gettipphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78098 
getauthor (Datasource=forum, Time=110ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
user (Datasource=forum, Time=0ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78045 
gettipphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 78045
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
gettipphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78045 
getauthor (Datasource=forum, Time=109ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
user (Datasource=forum, Time=1ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77976 
gettipphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 77976
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
gettipphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT hiimg as photo
	FROM answers 
	WHERE answers.answerid = 77976 
getauthor (Datasource=forum, Time=109ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
user (Datasource=forum, Time=1ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77928 
gettipphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 77928
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
gettipphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:39.039
	SELECT DISTINCT hiimg as photo
	FROM answers 
	WHERE answers.answerid = 77928 
getauthor (Datasource=forum, Time=109ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
user (Datasource=forum, Time=0ms, Records=0) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
  SELECT *
  FROM users
  WHERE userid = 79702 
  and expertuser = 'n'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77833 
gettipphoto (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 77833
	AND answersphoto.qid = '118'
	AND answersphoto.photo <> 'none'
	
getauthor (Datasource=forum, Time=112ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT userphoto, tipcount, username, userprofiles.aboutme, users.expertuser, users.expertname, users.expertfirstname, expertconame, expertcourl, users.userid, expertintro, expertname, expertconame, expertcourl, expertcotel, expertcoemail, expertcourlshow, expertuser, expertbrief
FROM users, userprofiles
WHERE users.userid = 79702
and userprofiles.userid = 79702 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 5
getphotos (Datasource=forum, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT DISTINCT userphoto
FROM users
WHERE userid = 79702 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/offshorebanking.cfm @ 02:48:40.040
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '159'
checkculturefeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 02:48:40.040
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:48:40.040
		Select summary, hiimg 
		FROM answers
         where answerid = 76451
         and summary <> ''
checklivingfeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 02:48:40.040
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:48:40.040
		Select summary, hiimg 
		FROM answers
         where answerid = 76398
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navcontentbox.cfm @ 02:48:40.040
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles 
	Where hitopic <> ''
	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 desc   
checkrptarticles (Datasource=reports, Time=0ms, Records=0, Cached Query) in /home/www/html/navcontentbox.cfm @ 02:48:40.040
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 159 
    ORDER by rptarticles.rptarticleID asc   
    
GetCountryList (Datasource=expert, Time=0ms, Records=96, Cached Query) in /home/www/html/navsidesbottom_rdesign5.cfm @ 02:48:40.040
  SELECT networkname, frmid, networkid, location1, location2, location3, location4, location5, shortname
  FROM mostcountries
  order by networkname


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/offshorebanking.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/offshorebanking.cfm
QUERY_STRING=
REMOTE_ADDR=173.245.54.69
REMOTE_HOST=173.245.54.69
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/offshorebanking.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=28917168
cftoken=73860790
sessionid=IBEXPATEXCHANGE.COM_28917168_73860790
urltoken=CFID=28917168&CFTOKEN=73860790
Debug Rendering Time: 10 ms