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

Spain Expat Forum

Setting up utilities non EU

Post New Topic
epilot
10/26/2016 13:11 EST

Can any one provide information on setting up utilities once you have arrived. Looking at moving to Valencia in summer of 2017 and need to know how hard it will be to connect to electrical, phone, tv services. Thanks for all information
Ed

Post a Reply

00abuse

anlgza
10/26/2016 14:58 EST

The listing agent for our rental helped us set up utilities. You give them your bank information and they will contact the utilities and set up automatic withdrawals. However the accounts remained in the name of the landlord. We have one little inconvenience in that our electric bill is in the landlord's deceased father's name and there is not enough information to set up automatic payments. You may be lucky enough to have tv and wi fi service already set up as part of your rent. If not you will have to set up your own internet/cable/phone installation and service, which is generally much cheaper than in the U.S. Movistar and Vodafone are the largest providers and have storefronts everywhere. The tricky part comes if you want fiberoptic sevice for faster internet. Ask your landlord if it is already installed in your building and who is the provider. Any company should be able to use the building's existing fiberoptic but they may tell you that THEY don't have it in your building yet will "in a couple of months." We went with Movistar first and waited for fiberoptic to be installed but switched to Vodafone because we got tired of the repeated delays.

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

epilot
10/26/2016 15:13 EST

Thanks a bunch for the info. As a US citizen, hoping to have the nonlucrative visa, will there be a lot of bureaucratic hoops to jump thru to get set up with the various utilites

Post a Reply

00abuse

cwells67
10/31/2016 02:23 EST

Hi, epilot, I think you will find that setting up utilities is a pretty simple process, but you MUST have a bank account in Spain to do it as well as an NIE (if you need more info on this, please ask!). When I was in Valencia, the two places that I rented required me to give them my bank account number for utilities, which were kept in the landlord's name(s). Utilities were typically pulled directly out of your bank account... which is why you need the account.

As noted by anlgza, this is not a bad thing but one caution: make sure you check the POTENCIA for your power service. This is the overall KW amount of possible power assigned to your apartment, and while it is normally not a big deal, you pay higher per KW/hr for a higher potencia. You may not know the amount until your first utility bill, which is every other month. I found this out the hard way, when my first bill was 300EUR because my potencia was set for what was probably a restaurant. It took some time to resolve that, but once it was done, my power bill went down to 90EUR for two months.

Another component is the TV/Internet/Phone/cellphone. I used Movistar, and for ~100EUR/mo I got TV with a whole bunch of channels (which I rarely watched), fiber internet (good point from anlgza on this!), a home phone, and cellphone service with 3Gb of data usage. Here in the States, I am paying the same amount for just one cellphone service and none of the other services. This will also come automatically out of your bank account. One thing I really liked about Movistar is that they have a team of customer service reps who speak English, and not all of the companies do. While I can hold my own in a phone conversation in Spanish, it was much easier when I transferred my services from one apartment to another, and was able to keep my fiber service in my new location (which was, incidentally, in a very old building off of C/de Jesús)!

Please continue to ask questions if you need more information.

Kind regards, Christopher

Post a Reply

00abuse

epilot
11/1/2016 11:56 EST

Thanks, CWWells67 for the great info, especially the potencia was enlightening. How long does it take to obtain the NIE and then the bank account followed by the utilities hookup. Trying to determine how long I will have to stay in hotel until is done. Epilot

Post a Reply

00abuse

cwells67
11/1/2016 14:11 EST

Check your visa nonlucrativo paperwork carefully. You should get an NIE number with that paperwork before you even enter Spain. With that, you can open a bank account immediately, and you will be on your way to getting an apartment. For me, with friends helping, it took me two weeks to go from a hotel room to my own apartment. Most likely, the utilities will be on, just switched to your name, which is a pretty regular occurrence and handled by the rental agent (inmobiliaria). Good luck!

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

epilot
11/2/2016 09:59 EST

Thanks Anlgza, you information is direct and to the point and will help a lot when we make the move to Valencia

Post a Reply

00abuse

DCJessica
7/8/2017 16:18 EST

Thanks to everyone who shared information on this post. We're moving to Valencia next week, and it was very helpful!

Have you made the move epilot? If you need a place to stay at while you line things up, we stayed at the Valencia Arthouse bed and breakfast while we were house-hunting and it was lovely. Good luck!

Post a Reply

00abuse

nc25
8/26/2019 03:50 EST

Hi, If you live in Spain and want to get your electric at a better price with a better service…. Get in touch!!!

http://www.evergreen-electrica.com

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Spain.

International Moving Companies

Moving to Spain? Get a moving quote.


Mail Forwarding to Spain

Mail Forwarding to Spain.


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

Culture-Shock-in-ValenciaAn Expat Talks about Culture Shock & Living in Valencia, Spain

An expat who studied anthropology has adjusted to life in Valencia and talks about his approach to avoiding culture shock.

An expat who studied anthropology has adjusted to life in Valencia and talks about his approach to avoiding culture shock....

Living-in-ValenciaAn Expat Discusses Living in Valencia, Spain

An expat in Valencia talks about enjoying the Mediterranean lifestyle. You'll need to learn Castellano and a little Valenciano.

An expat in Valencia talks about enjoying the Mediterranean lifestyle. You'll need to learn Castellano and a little Valenciano. ...

10-Tips-for-Living-in-SpainExpat Spain: 10 Tips for Living in Spain

With it's warm culture, thriving cities and beautiful countryside, expats agree that Spain has it all. Expats share their tips and experiences living in Spain.

With it's warm culture, thriving cities and beautiful countryside, expats agree that Spain has it all. Expats share their tips and experiences living in Spain....

5-Tips-for-Living-in-Barcelona5 Tips for Living in Barcelona

Barcelona is the capital of Catalonia, a region where some citizens are fighting for their independence from Spain. Barcelona is a beautiful city that's rich in history and architecture with a thriving nightlife scene.

Barcelona is the capital of Catalonia, a region where some citizens are fighting for their independence from Spain. Barcelona is a beautiful city that's rich in history and architecture with a thrivi...

International-Schools-in-BarcelonaInternational Schools in Barcelona, Spain

Families moving to Barcelona have a number of great schools to consider. There are several American and British schools plus foreign children are allowed to attend public school. In this article we highlight several of the more popular English schools and expats' advice with regard to public vs. private English schools.

Families moving to Barcelona have a number of great schools to consider. There are several American and British schools plus foreign children are allowed to attend public school. In this article we ...

12-Expats-Talk-About-What-Its-Like-Moving-to-Spain12 Expats Talk About What It's Like Moving to Spain

Expats in Spain share their experiences moving to Spain. From what to bring to learning Spanish, culture shock to finding a flat.
Expats in Spain share their experiences moving to Spain. From what to bring to learning Spanish, culture shock to finding a flat. ...

Spain 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 04-Jul-20 07:56 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.169
Host Name 172.69.63.169


Execution Time

Total Time Avg Time Count Template
110 ms 110 ms 1 /home/www/html/expat/Application.cfm
54 ms 54 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
54 ms 54 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
54 ms 54 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
26 ms 26 ms 1 /home/www/html/expat/messages_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
15 ms 15 ms 1 /home/www/html/expat/message_rdesign5.cfm
15 ms 15 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 1 ms 9 /home/www/html/navvote_rdesign5.cfm
5 ms 3 ms 2 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetCategory.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 9 /home/www/html/expat/common/formatmsg.cfm
0 ms 0 ms 1 /home/www/html/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/ibstyle.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 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
111 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=1ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 07:56:45.045
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/expat/Application.cfm @ 07:56:45.045
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 07:56:45.045
	Select *
	From Networks
	Where frmid = 296 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 296 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
	Select *
	From citynetworks
	Where networkID = 101
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
	Select *
	From Networks
	Where networkID = 101 
GetTopicTitle (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
  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 = 296 
  AND t.tpcid = 3416305 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
  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 = 3416305
  and  t.tpcid = 3416305
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=36) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 101
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
  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 = 3416305
  and  t.tpcid = 3416305
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=36, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 07:56:45.045
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 101
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 07:56:45.045
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.169'
and logtime > "2020-04-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 07:56:45.045
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.169'
and logtime > "2020-07-04 00:00:00.000"
and logtime < "2020-07-04 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 07:56:45.045
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.169'
and logtime > "2020-06-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 07:56:45.045
	SELECT *
	From contentcountcountry
	Where networkid = 101 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 07:56:45.045
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 07:56:45.045
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
GetNavigator (Datasource=forum, Time=1ms, Records=1) in /home/www/html/expat/Application.cfm @ 07:56:45.045
  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 = 296 
  AND tpcid = 3416305 
  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 @ 07:56:45.045
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 296
  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 @ 07:56:45.045
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 07:56:45.045
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=4ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 07:56:45.045
  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 = 3416305
  AND m.userid = u.userid
  AND topics.tpcid = 3416305
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
  AND m.isapproved = 1
  AND m.msgparent = 0
  AND m.isdeleted <> 1
GetMessages (Datasource=forum, Time=5ms, Records=8) in /home/www/html/expat/messages_rdesign5.cfm @ 07:56:45.045
  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 = 3416305
  AND m.userid = u.userid
  AND topics.tpcid = 3416305
    AND m.isdeleted <> 1
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
     AND m.msgparent <> 0
  AND m.isapproved = 1
   
    ORDER BY m.msgid ASC 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 388964
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 388964
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 07:56:45.045
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:56:45.045
	Select *
	From Networks
	Where networkid = 101 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:56:45.045
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:56:45.045
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-07-03"
and natforumstart < "2020-07-04"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high')
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 388970
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 388970
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 389594
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 389594
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 389958
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 389958
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 389992
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 389992
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=1ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 07:56:45.045
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:56:45.045
	Select *
	From Networks
	Where networkid = 101 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:56:45.045
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:56:45.045
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-07-03"
and natforumstart < "2020-07-04"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:56:45.045
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 @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 390105
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 390105
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 436638
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 436638
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 540923
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 07:56:45.045
SELECT vote
FROM votes
WHERE voteid = 540923
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=25ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 07:56:45.045
	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 = 101
	AND "2020-07-04" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkculturefeature (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 07:56:45.045
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 101 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:56:45.045
		Select summary, hiimg 
		FROM answers
         where answerid = 76932
         and summary <> ''
checklivingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:56:45.045
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 101 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:56:45.045
		Select summary, hiimg 
		FROM answers
         where answerid = 75819
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 07:56:45.045
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	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-04"

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


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/expat/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/expat/index.cfm
QUERY_STRING=frmid=296&tpcid=3416305
REMOTE_ADDR=172.69.63.169
REMOTE_HOST=172.69.63.169
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=31008333
cftoken=26488489
sessionid=IBEXPATEXCHANGE.COM_31008333_26488489
urltoken=CFID=31008333&CFTOKEN=26488489
URL Parameters:
frmid=296
tpcid=3416305
Debug Rendering Time: 12 ms