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

Colombia Expat Forum

Duties and Customs in Colombia

Post New Topic
onthemove44
2/1/2014 19:27 EST

Hello To All,
This is my very first post to the Expat Exchange and I am in dire need of some information. I am planning a move to Medellin in May of this year, or no later than June. I have been reading a lot about the country, culture, banking, visa requirements, etc. I have run into what seems to possibly be a major roadblock however. I have sold all my furniture, appliances (large) art and so forth, so it would be an easier move. My problem however is my wardrobe, (personal clothes and accessories) as I have approx. 10 fairly large boxes weighing right at 100 pounds each. Eighty five to ninety percent is clothing, and I do not want to part with any of it. The remaining ten to fifteen percent is household items, including a $2500.00 coffee machine and a $500.00 blender that I purchased last September, but never unpacked or used them as I knew it would be easier to wait until my move to Colombia to use them. I have been trying for almost a week now to find out how I will be taxed when the shipment arrives and goes through customs. These are all my personal items and nothing is for resale. The rest of the contents are things like sheets, towels, a set of dishware, kitchen utensils, silverware, etc. I have contacted a local international shipping company here on the west coast of the USA, and have been quoted a shipping by ocean freight cost of about $1500.00. My question to any of you who can help is, will the Customs in Colombia tax me on my used clothing, and if so, how do they arrive at any kind of dollar amount? I am coming on a retirement visa, and the shipment, if at all, will come after I have arrived. Please, anyone with knowledge respond.

Warmest Regards,
on themove44

Post a Reply

00abuse

masterita
2/1/2014 21:47 EST

Welcome. Why not just take the packages with you on the plane? Depending on the airline it is likely to be cheaper or equivalent to the shipping quote you received. Here is a tip. When traveling with extra bags and weight via an airline when you usually fly first class your baggage is free or discounted. Baggage handlers will take your packages out to the curb where you can have a truck waiting for you to pick you and your baggage up.

Hope that helps.

Post a Reply

00abuse

expat health insurance from CIGNA

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

Get a Quote

onthemove44
2/1/2014 21:52 EST

Thanks Masterita for your response, but I am not worried about the cargo shipment. I still have to clear customs with all of my belongings. The question is how does the dept. derive at a figure on used clothing?

Thanks,
on the move44

Post a Reply

00abuse

masterita
2/1/2014 23:42 EST

From my simple understanding of it you are allowed to import (with you) upto a certain weight of clothing and anything over will be taxed by weight. The same with shipping untaged clothing. I do not believe it is too costly though.

I am also told that you can contact the Colombian consulate for a tax exempt ment for importing into the country. At least up until this past June as this rule might have changed. There is a limit on how much you can bring in via tax exempted. This works via importing via air cargo, sea freight or bringing it with you.

In my opinion your export shipping company should know all of this, as it is their job. Also customs would likely look at 10, 100 lb boxes of clothing as intent to resell so you would likely be paying a 30% tax on their estimated value.

For the finer details I would suggest checking out http://export.gov/COLOMBIA/doingbusinessincolombia/traderegulationsstandards/index.asp

You should be able to find out more here.

Post a Reply

00abuse

mawdsjeff
2/2/2014 07:52 EST

I have moved here twice, and you cannot predict the final customs charge! The last time, 18 months ago, they unpacked EVERY box, tipped it out and put it back again, sometimes in a different box. They make a fuss about some items, but you CANNOT do anything about it. They charge you millions of PESOS so allow a few thousand dollars for the final price. There are lots of different fees and people involved. You get so fed up with the process that you JUST PAY to get your stuff through. There is a charge after a certain time for every day the shipment is in their warehouse. Also some things DO go missing , so don't pack too many precious things in the same box!. The advice often given is NOT to bring anything in, but if you have things that are precious or sentimental - you cannot put a price to them. Regards Geoff

Post a Reply

00abuse

quiskies
2/2/2014 08:09 EST

Hi Onthemove, you should reconsider bringing so much clothing. For cool weather stuff, keep one jacket for visiting Bogota or higher elevations, two dress up outfits, and sell or donate the rest of your cool weather things. I personally now use two pairs of long pants, two pairs of shorts, and a bunch of T-shirts.
Consider shipping some of your things by courier, which is not taxed (as long as there are no more than 6 of the same, brand new items), for about $2 a pound, plus $35, from the Miami area to any address in Colombia. The box arrives in just a few days with zero hassles.
I have used enviospembroke.com and I also see on the internet www.latincargoexpress.com/english.htm

Post a Reply

00abuse

expat health insurance from CIGNA

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

Get a Quote

thelocogringo
2/2/2014 08:40 EST

Hello 44, I feel your pain. I brought my special coofee machine too. Was almost 60lbs but makes some great coffee! I ended up ordering a second as a back up and shipped it too. I bring in shipments on a regular basis and have found a company that works well. You can give me a call at 305 407-9218 if you want to discuss it.

Martin

Post a Reply

00abuse

thelocogringo
2/2/2014 08:40 EST

Hello 44, I feel your pain. I brought my special coofee machine too. Was almost 60lbs but makes some great coffee! I ended up ordering a second as a back up and shipped it too. I bring in shipments on a regular basis and have found a company that works well. You can give me a call at 305 407-9218 if you want to discuss it.

Martin

Post a Reply

00abuse

brson
2/2/2014 09:59 EST

First, use a reputable freight forwarder, like Via al Éxito (described in another post). Dutiies across the board are 30% of "declared value" except for tablets and computers which enter Colombia duty free. We've had little trouble declaring items (particularly used clothes and the like) at nominal values. The freight forwarder ought to help and even managed to get things shipped in that are ostensibly unallowed (like seeds). We've had little trouble except for electronics in one case, which customs insisted bore a higher value than declared. We merely paid it and had done. Glad to learn we weren't the only ones bringing in our heavy coffee machines! With just modest use after we arrived, it pooped out forcing us to import another type. Good Luck--Priscilla

Post a Reply

00abuse

spank12
2/2/2014 10:06 EST

Let me ask? Anyone else had a problem with exito site. my computer kept telling me they had viruses and other issues. I am still thinking about using them. They only about a hour drive from my place in the states.

Post a Reply

00abuse

Patricio
2/2/2014 14:45 EST

Where are you spank12? I am in Cocoa Beach, one hour from via al Exito on 436 in Orlando. My experience wth them has been fine.

Post a Reply

00abuse

Exbury
2/5/2014 20:38 EST

Hi,
My wife and I moved to Bogota in December and did the following which may be of use;

1 - Worked out the shipping value per Kg (from UK it was around £3/kg). Weighed that into account as a lot of stuff is about the same in price here, some like baby stuff seems to be far more expensive but when adding the £3/kg it can work out leaving or selling stuff there. So furniture and heavy stuff was left.
2 - Added an extra bag on the place, and went with a generous Airline especially with unlimited handluggage, the little more was far worth the extra kgs in the hand luggage.....heavy work though.
3 - Decided to ship ourselves, via airfreight. The container shipping delivery was over £2000 UKP just from the port to Bogota.
4 - Shipping ourselves was fine as this allowed us to control the whole process, however you need to follow the customs receiving in the appropriate place. Bogota was ok, but it helped my wife being Colombian.
5 - I believe the limit import tax-free was around $1500 but we were slightly under this so not charged.
6 - Interestingly we were told by the DIAN inspector that you can import up to $1500 tax free PERSONAL items only EVERY 6 months. Note, certain restrictions and a max of 3 of any item. I dont have more information on this but maybe something to consider.
7 - As one poster said, you dont need that much clothing here, even in Bogota I use shorts and t-shirts a lot, Medellin is even warmer. We also left clothing and stuff not urgent with family, so when we go back to visit it will be with empty bags....literally and come back with full.
Good luck.

Post a Reply

00abuse

jfriedo
2/6/2014 20:21 EST

I am also very interested in this topic as I plan to move to Medellin in the fall. My circumstances are a little different as I will be retiring from the U.S. Foreign Service and the government will ship my things, however, I will need to pay the import duties and customs. So where exactly does one get the information on exemptions, what the importing rates on, etc. I have a lot of things I've collected around the world like paintings, carvings, trunks and things I can't get rid of. Any advice is so welcome!! Thanks, Jeannie

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Colombia.

International Moving Quotes

Moving to Colombia? Get a moving quote.


Mail Forwarding to Colombia

Mail Forwarding to Colombia.


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

8-Expats-Share-What-Its-Like-Living-in-Colombia8 Expats Share What It's Like Living in Colombia

Expats in Colombia talk about what it's really like living there - deciding where to live, the pros and cons and more.
Expats in Colombia talk about what it's really like living there - deciding where to live, the pros and cons and more....

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:...

Living-in-ColombiaHealthcare in Colombia

Our guide to healthcare in Colombia covers public and private healthcare in Colombia, hospitals, vaccinations, prescription medications and more.

Our guide to healthcare in Colombia covers public and private healthcare in Colombia, hospitals, vaccinations, prescription medications and more. ...

Retirement-In-CaliAn Expat Shares What it's Like Retiring in Cali, Colombia

An American woman talks about moving to Cali, Colombia to retire with her Colombian husband. She describes how the low cost of living in Colombia has given her a new lease on life. They are traveling throughout Colombia, living in a beautiful new penthouse apartment and enjoying retirement in Colombia.

An American woman talks about moving to Cali, Colombia to retire with her Colombian husband. She describes how the low cost of living in Colombia has given her a new lease on life. They are traveling ...

Moving-To-CartagoAn Expat Talks about Moving to Cartago, Colombia

An expat in Cartago, Colombia has found a little bit of heaven living in Colombia. He appreciates the much lower cost of living and admits he lives like a king in Colombia for $2,000 a month. He advises others moving to Colombia to bring only the necessities and buy furniture there.

An expat in Cartago, Colombia has found a little bit of heaven living in Colombia. He appreciates the much lower cost of living and admits he lives like a king in Colombia for $2,000 a month. He adv...

Colombia 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 09-Jul-20 10:45 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.79.9
Host Name 162.158.79.9


Execution Time

Total Time Avg Time Count Template
155 ms 155 ms 1 /home/www/html/expat/Application.cfm
75 ms 75 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
75 ms 75 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
74 ms 74 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
42 ms 42 ms 1 /home/www/html/expat/messages_rdesign5.cfm
42 ms 42 ms 1 /home/www/html/navcontentbox.cfm
30 ms 30 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
29 ms 29 ms 1 /home/www/html/expat/message_rdesign5.cfm
18 ms 18 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
12 ms 1 ms 13 /home/www/html/navvote_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
7 ms 4 ms 2 /home/www/html/nativerotationtop_tester13.cfm
6 ms 6 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 0 ms 13 /home/www/html/expat/common/formatmsg.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/ibstyle.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
1 ms 1 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 2 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
156 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 @ 10:45:01.001
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/expat/Application.cfm @ 10:45:01.001
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 10:45:01.001
	Select *
	From Networks
	Where frmid = 190 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 32 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 190 
getcities (Datasource=expert, Time=1ms, Records=5) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
	Select *
	From citynetworks
	Where networkID = 32
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
	Select *
	From Networks
	Where networkID = 32 
GetTopicTitle (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
  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 = 190 
  AND t.tpcid = 3382098 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=5ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
  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 = 3382098
  and  t.tpcid = 3382098
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=39) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 32
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=5ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
  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 = 3382098
  and  t.tpcid = 3382098
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=39, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 10:45:01.001
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 32
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 10:45:01.001
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-04-09"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 10:45:01.001
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-09 00:00:00.000"
and logtime < "2020-07-09 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 @ 10:45:01.001
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-02"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 10:45:01.001
	SELECT *
	From contentcountcountry
	Where networkid = 32 
gettopbanner (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 10:45:01.001
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-08"
    and fromDate < "2020-07-09"
    and bannerPlacement.networkid = '32'
    and bannerPlacement.bannerid = banners.bannerid
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 10:45:01.001
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight = 10 
    and toDate > "2020-07-08"
    and fromDate < "2020-07-09"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 10:45:01.001
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=1ms, Records=1) in /home/www/html/expat/Application.cfm @ 10:45:01.001
  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 = 190 
  AND tpcid = 3382098 
  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 @ 10:45:01.001
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 190
  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 @ 10:45:01.001
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 10:45:01.001
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=5ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 10:45:01.001
  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 = 3382098
  AND m.userid = u.userid
  AND topics.tpcid = 3382098
  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=12) in /home/www/html/expat/messages_rdesign5.cfm @ 10:45:01.001
  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 = 3382098
  AND m.userid = u.userid
  AND topics.tpcid = 3382098
    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=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217819
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217819
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 10:45:01.001
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 10:45:01.001
	Select *
	From Networks
	Where networkid = 32 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 10:45:01.001
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 10:45:01.001
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 32
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-07-08"
and natforumstart < "2020-07-09"
and natforumstatus = 'live'

and natforumweight = 'high'
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217820
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217820
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217833
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217833
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217869
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217869
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217872
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217872
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=1ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 10:45:01.001
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 10:45:01.001
	Select *
	From Networks
	Where networkid = 32 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 10:45:01.001
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 10:45:01.001
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 32
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-07-08"
and natforumstart < "2020-07-09"
and natforumstatus = 'live'

and natforumweight = 'high'
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 10:45:01.001
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 46 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217874
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217874
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217875
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217875
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217883
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217883
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217886
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217886
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217935
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 217935
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 218482
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 218482
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 218677
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 10:45:01.001
SELECT vote
FROM votes
WHERE voteid = 218677
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=32ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 10:45:01.001
	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 = 32
	AND "2020-07-09" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=7ms, Records=1) in /home/www/html/navcontentbox.cfm @ 10:45:01.001
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-09"
     
         and rptarticlenetworks.networkid = 32 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 10:45:01.001
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 5
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 10:45:01.001
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 32 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 10:45:01.001
SELECT  hiimg
FROM rptarticles
where rptarticleID = 5
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=8ms, Records=2) in /home/www/html/navcontentbox.cfm @ 10:45:01.001
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 32 
	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-09"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=10ms, Records=3) in /home/www/html/navcontentbox.cfm @ 10:45:01.001
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 32 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 10:45:01.001
		Select summary, hiimg 
		FROM answers
         where answerid = 73240
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=10ms, Records=1) in /home/www/html/navcontentbox.cfm @ 10:45:01.001
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 32 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 10:45:01.001
		Select summary, hiimg 
		FROM answers
         where answerid = 74815
         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/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=190&tpcid=3382098
REMOTE_ADDR=162.158.79.9
REMOTE_HOST=162.158.79.9
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=31569747
cftoken=92465660
sessionid=IBEXPATEXCHANGE.COM_31569747_92465660
urltoken=CFID=31569747&CFTOKEN=92465660
URL Parameters:
frmid=190
tpcid=3382098
Debug Rendering Time: 13 ms