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

Panama: Expat Legal Services

Expat Legal Services in Panama- Expat Divorce Panama, Expat Real Estate Matters, Immigration Law and more.

Interested in being included in this section. Contact us to discuss partnership opportunities.

16-Expats-Talk-About-Moving-to-Panama16 Expats Talk About Moving to Panama

Expats living in Panama talk about making the big move to Panama, what they wish they had brought (and left behind), visas, culture shock, cost of living and more. It's a must read for anyone thinking about moving to Panama.
Expats living in Panama talk about making the big move to Panama, what they wish they had brought (and left behind), visas, culture shock, cost of living and more. It's a must read for anyone thinking...

Expat-Panama10 Tips for Living in Panama

Did you know it's hot in Panama City all year round? Did you know that it's hard to get a work visa in Panama? Did you know that Panama has great incentives for foreign retirees?

Did you know it's hot in Panama City all year round? Did you know that it's hard to get a work visa in Panama? Did you know that Panama has great incentives for foreign retirees? ...

Retiring-Abroad5 Great Places to Retire in Central America

Central America is an increasingly popular retirement destination. Retirees love it's proximity to the United States, lower cost of living, beautiful cities, amazing beaches, healthy lifestyle and friendly people.

Central America is an increasingly popular retirement destination. Retirees love it's proximity to the United States, lower cost of living, beautiful cities, amazing beaches, healthy lifestyle and fr...

Expat-Panama7 Best Places to Live in Panama

Panama is a great place to live or retire with easy residency laws, warm people and lots of expats. Whether you want to live by the beach in Bocas del Toro or need to live in Panama City for work and schools, there are many places to explore. We highlight 5 great places to live in Panama.

Panama is a great place to live or retire with easy residency laws, warm people and lots of expats. Whether you want to live by the beach in Bocas del Toro or need to live in Panama City for work and...

Retirement-In-Nueva-GorgonaAn Expat Shares What it's Like Retiring in Nueva Gorgona, Panama

An expat retired in Nueva Gorgona, Panama wrote an extensive report about her experiences there. Everything from cost of living, housing, safety, how it feels to retire abroad, transportation and more are covered. A definite must read for anyone considering retiring in Panama!

An expat retired in Nueva Gorgona, Panama wrote an extensive report about her experiences there. Everything from cost of living, housing, safety, how it feels to retire abroad, transportation and mor...

Moving-To-Nueva-Gorgona-An Expat Talks about Moving to Nueva Gorgona , Panama

An expat talks about moving to Nueva Gorgona and advises newcomers to rent before buying so that you can move if you don't end up liking the neighborhood. We couldn't agree more with this advice!

An expat talks about moving to Nueva Gorgona and advises newcomers to rent before buying so that you can move if you don't end up liking the neighborhood. We couldn't agree more with this advice! ...

Panama 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 /rgall.cfm
Time Stamp 03-Jul-20 11:40 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.37
Host Name 172.69.63.37


Execution Time

Total Time Avg Time Count Template
63 ms 63 ms 1 top level /home/www/html/rgall.cfm
31 ms 31 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
30 ms 30 ms 1 /home/www/html/navcontentbox.cfm
30 ms 30 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/navleader_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms 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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
69 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 @ 23:40:31.031
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 23:40:31.031
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getcatname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgall.cfm @ 23:40:31.031
	Select *
	From Categories
	Where categoryid = 89 
getbidders (Datasource=expert, Time=5ms, Records=0) in /home/www/html/rgall.cfm @ 23:40:31.031
Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl
    From Resources, resourcePlacement, resourceCats
    WHERE 89 = 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 > {ts '2020-07-02 23:40:31'}
    and fromdate <{ts '2020-07-03 23:40:31'}
	AND resourcePlacement.networkID = '159'
	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 @ 23:40:31.031
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 23:40:31.031
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 87 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmeta_rdesign4.cfm @ 23:40:31.031
	Select *
	From citynetworks
	Where networkID = 87
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 23:40:31.031
  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 @ 23:40:31.031
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-04-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 23:40:31.031
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-07-03 00:00:00.000"
and logtime < "2020-07-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 @ 23:40:31.031
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-06-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 23:40:31.031
	SELECT *
	From contentcountcountry
	Where networkid = 87 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 23:40:31.031
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-02"
    and fromDate < "2020-07-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 23:40:31.031
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getaffiliates (Datasource=expert, Time=4ms, Records=0) in /home/www/html/rgall.cfm @ 23:40:31.031
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.contactname, Resources.email, Resources.phone, Resources.fax, Resources.street, Resources.city, Resources.state_prov, Resources.zip, Resources.country, Resources.longdescription, Resources.photo, Resources.site, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl
    From Resources, resourceCats
    WHERE 89 = resourceCats.categoryID 
	and resourceCats.resourceID = Resources.resourceID 
	and Resources.type = 'affiliate'
    and Resources.bid <> 'yes'
    and todate > {ts '2020-07-02 23:40:31'}
    and fromdate <{ts '2020-07-03 23:40:31'}
	Order by Resources.resourcename
getcatname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgall.cfm @ 23:40:31.031
	Select *
	From Categories
	Where categoryid = 89 
UpdateImpressions (Datasource=expert, Time=2ms, Records=1) in /home/www/html/rgall.cfm @ 23:40:31.031
  UPDATE Categories
  SET rgnetimpressions = rgnetimpressions + 1
  Where categoryid = 89 
getlistings (Datasource=expert, Time=3ms, Records=0) in /home/www/html/rgall.cfm @ 23:40:31.031
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl, resourceCats.categoryorder
    From Resources, resourcePlacement, resourceCats
    WHERE 89 = 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 <> 'bonusonly'
    and Resources.bid <> 'yes'
    and todate > {ts '2020-07-02 23:40:31'}
    and fromdate <{ts '2020-07-03 23:40:31'}
	AND (87 = resourcePlacement.networkID OR resourcePlacement.networkID = '159')
	AND resourcePlacement.resourceID = Resources.resourceID
    
	Order by Resources.resourcename
	
gettaxgeneral (Datasource=expert, Time=8ms, Records=15) in /home/www/html/rgall.cfm @ 23:40:31.031
	Select *
	From articles, articlePlacement
	Where type = 3
   	and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
   	and articlePlacement.networkid = 87
   	and articles.articleid = articlePlacement.articleid
    and publishdate <{ts '2020-07-03 23:40:31'}
    ORDER by publishdate desc 
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:40:31.031
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-03"
     
         and rptarticlenetworks.networkid = 87 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 23:40:31.031
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 2
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 23:40:31.031
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 87 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:40:31.031
SELECT  hiimg
FROM rptarticles
where rptarticleID = 2
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 23:40:31.031
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 87 
	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-07-03"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentbox.cfm @ 23:40:31.031
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 87 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:40:31.031
		Select summary, hiimg 
		FROM answers
         where answerid = 74233
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 23:40:31.031
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 87 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:40:31.031
		Select summary, hiimg 
		FROM answers
         where answerid = 76174
         and summary <> ''


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/rgall.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/rgall.cfm
QUERY_STRING=categoryID=89&networkID=87
REMOTE_ADDR=172.69.63.37
REMOTE_HOST=172.69.63.37
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rgall.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=30987110
cftoken=46635249
sessionid=IBEXPATEXCHANGE.COM_30987110_46635249
urltoken=CFID=30987110&CFTOKEN=46635249
URL Parameters:
categoryID=89
networkID=87
Debug Rendering Time: 11 ms