Home Scotland Forum Scotland Guide Moving to Scotland Real Estate Healthcare in Scotland
Scotland
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Scotland Jobs

Our international job listings are a great place for expats to search for overseas jobs and for international employers to promote job openings to our expat audience. Job listings are currently FREE!

Post a Job (free) View All Jobs

Part-time, seasonal representative for American Tour Company Job in Inverness, Scotland

Wanted: part-time staff person for seasonal (April to October), semi-independent American tour groups to Inverness, Scotland.

More Info & Contact Owner

German Customer Service Administrator Job in Motherwell, Scotland

Are you fluent in German? Explore the fantastic opportunity with Honeywell and join us as a Customer Service Administrator in our office in Motherwell.

More Info & Contact Owner

The Real Estate Update

Weekly updates (1-2 issues per week) with real estate listings in popular expat destinations worldwide.

Subscribe Now

Cigna Expat Health InsuranceExpatriate Health Insurance

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

10-Tips-for-Living-in-Scotland10 Tips for Living in Scotland

Expat in Scotland love traditional Scottish culture, beautiful landscapes and they experiences both combine to make possible. Be aware of the high cost of living, but if you come prepared you will always want to come back to this very special place.

Expat in Scotland love traditional Scottish culture, beautiful landscapes and they experiences both combine to make possible. Be aware of the high cost of living, but if you come prepared you will al...

9-Things-to-Know-Before-Moving-to-Scotland9 Things to Know Before Moving to Scotland

Here are 9 things to know before moving to Scotland from expats who have already moved there. Their advice covers topics such as the NHS, expat health insurance, village vs. city life, the high cost of living in Scotland, visas and much more.

Here are 9 things to know before moving to Scotland from expats who have already moved there. Their advice covers topics such as the NHS, expat health insurance, village vs. city life, the high cost...

Scotland 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 /jobsnet.cfm
Time Stamp 08-Jul-20 06:46 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.108
Host Name 162.158.78.108


Execution Time

Total Time Avg Time Count Template
107 ms 107 ms 1 top level /home/www/html/jobsnet.cfm
25 ms 25 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/navcontentbox.cfm
23 ms 23 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
9 ms 9 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/navleader_rdesign5.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/leftnav_rdesign5.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.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/navclassifiedsnews_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjobspagingbottom.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.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
4 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
115 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=1ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 18:46:00.000
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 18:46:00.000
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getjobscountries (Datasource=expert, Time=11ms, Records=76) in /home/www/html/jobsnet.cfm @ 18:46:00.000
SELECT allreports.networkname, allreports.networkid, shortname
FROM allreports, Networks
WHERE (rid = 68)
AND "2020-07-08" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getanswers (Datasource=expert, Time=5ms, Records=2) in /home/www/html/jobsnet.cfm @ 18:46:00.000
SELECT *
FROM allreports
WHERE (rid = 68)
AND "2020-07-08" < enddate
and networkid = 151 
order by city ASC, answerid DESC
getcount (Datasource=expert, Time=5ms, Records=2) in /home/www/html/jobsnet.cfm @ 18:46:00.000
SELECT answerid
FROM allreports
WHERE (rid = 68)
AND "2020-07-08" < enddate
and networkid = 151 
order by city ASC, answerid DESC
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:46:00.000
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 18:46:00.000
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 151 
getcities (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 18:46:00.000
	Select *
	From citynetworks
	Where networkID = 151
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:46:00.000
  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=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:46:00.000
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-04-08"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 18:46:00.000
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-07-08 00:00:00.000"
and logtime < "2020-07-08 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 @ 18:46:00.000
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-07-01"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:46:00.000
	SELECT *
	From contentcountcountry
	Where networkid = 151 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 18:46:00.000
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-07"
    and fromDate < "2020-07-08"
    and bannerPlacement.networkid = 151
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 18:46:00.000
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
getlocation (Datasource=reports, Time=6ms, Records=1) in /home/www/html/jobsnet.cfm @ 18:46:00.000
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '73926'
AND answerstext.qid = 154
AND answersmc.qid = 244
AND answersmc.answerid = '73926'
AND answersmc.qoid = qoptions.qoid
getheading (Datasource=reports, Time=6ms, Records=1) in /home/www/html/jobsnet.cfm @ 18:46:00.000
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '73926'
	AND answerstext.qid = 108
getcompany (Datasource=reports, Time=6ms, Records=1) in /home/www/html/jobsnet.cfm @ 18:46:00.000
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '73926'
	AND answerstext.qid = 143
getbrief (Datasource=reports, Time=6ms, Records=1) in /home/www/html/jobsnet.cfm @ 18:46:00.000
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '73926'
	AND answerstext.qid = 112
getlocation (Datasource=reports, Time=6ms, Records=1) in /home/www/html/jobsnet.cfm @ 18:46:00.000
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '74595'
AND answerstext.qid = 154
AND answersmc.qid = 244
AND answersmc.answerid = '74595'
AND answersmc.qoid = qoptions.qoid
getheading (Datasource=reports, Time=6ms, Records=1) in /home/www/html/jobsnet.cfm @ 18:46:00.000
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '74595'
	AND answerstext.qid = 108
getcompany (Datasource=reports, Time=7ms, Records=1) in /home/www/html/jobsnet.cfm @ 18:46:00.000
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '74595'
	AND answerstext.qid = 143
getbrief (Datasource=reports, Time=6ms, Records=1) in /home/www/html/jobsnet.cfm @ 18:46:00.000
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '74595'
	AND answerstext.qid = 112
checkculturefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:46:00.000
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 151 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:46:00.000
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 151 
        and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 18:46:00.000
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 151 
	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-08"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:46:00.000
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-08"
     
         and rptarticlenetworks.networkid = 151 
    ORDER by rptarticles.rptarticleID asc   
    


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/jobsnet.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/jobsnet.cfm
QUERY_STRING=networkid=151
REMOTE_ADDR=162.158.78.108
REMOTE_HOST=162.158.78.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/jobsnet.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=31533399
cftoken=70643707
sessionid=IBEXPATEXCHANGE.COM_31533399_70643707
urltoken=CFID=31533399&CFTOKEN=70643707
URL Parameters:
networkid=151
Debug Rendering Time: 9 ms