Expat Guide to Living Abroad

  SELECT * FROM genset 
WHERE dbname = "ee"

      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	

	Select *
	From Networks
	where isCity = 'country'
	order by networkname

	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 159 

	Select *
	From citynetworks
	Where networkID = 159
	and status <> 'hold'
	ORDER by city

  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

	Select *
	From Networks
	Where networkID = 159 

SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.177'
and logtime > "2020-05-08"
and param1 = 'aw'
ORDER BY logtime DESC

SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.177'
and logtime > "2020-08-07 00:00:00.000"
and logtime < "2020-08-07 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC

SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.177'
and logtime > "2020-07-31"
and param1 = 'awdyn'
ORDER BY logtime DESC

	SELECT *
	From contentcountcountry, Networks
	where contentcountcountry.networkid = Networks.networkid

	SELECT *
	From contentcountcountry, Networks
	where contentcountcountry.networkid = Networks.networkid

	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
	and weight = 1
    and toDate > "2020-08-06"
    and fromDate < "2020-08-07"

	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
    and toDate > "2020-08-06"
    and fromDate < "2020-08-07"

  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles 
	Where hitopic <> ''
    and hidescript <> ''
    and type = '3'
    and articles.hihp <> 'n'
    and articles.hinet <> 'n'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
        and summary <> ''
    and publishdate < "2020-08-07"
    ORDER by publishdate desc

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and city <> ''
         order by date DESC

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and city <> ''
         
   	 order by city, date DESC
         

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and city <> ''
         
   	 order by city, date DESC
         

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and city <> ''
         order by date DESC

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and city <> ''
         
   	 order by city, date DESC
         

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and city <> ''
         order by date DESC

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and city <> ''
         
   	 order by city, date DESC
         

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-08-07"
     
         and rptarticlenetworks.networkid = 159 

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
		order by date DESC

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
      
         and city <> ''
         
   	 order by city, date DESC
         

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-08-07"
      
         and rptarticlenetworks.networkid = 159 

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
		order by date DESC

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
      
         and city <> ''
	
   	 order by city, date DESC
         

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
   	 order by city, date DESC
         

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
   	 order by city, date DESC
         

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
   	 order by city, date DESC
         

SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC

SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 9 

SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79973
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79973 = answerstext.answerid 
ORDER BY topicquestions.order ASC

SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79973
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79973
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC

	SELECT summary
	FROM answers
	WHERE answers.answerid = '79973'

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79973'
	and qid = 391

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 

SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 11 

	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79973 

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'

	SELECT *
	FROM markers
	WHERE answerid = '79973'
	and lat <> ''
	and lng <> ''

SELECT *
FROM expertusers
WHERE userid = 1
and startdate <{ts '2020-08-06 20:13:18'}
and enddate > {ts '2020-08-07 20:13:18'} 

SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC

SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 15 

SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80719
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80719 = answerstext.answerid 
ORDER BY topicquestions.order ASC

SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 80719
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 80719
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC

	SELECT summary
	FROM answers
	WHERE answers.answerid = '80719'

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80719'
	and qid = 391

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 

	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80719 

	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80719 
	AND answersphoto.qid = '104'
	
	AND answersphoto.photo <> 'none'
	

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '18'

	SELECT *
	FROM markers
	WHERE answerid = '80719'
	and lat <> ''
	and lng <> ''

SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC

SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 7 

SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 65920
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 65920 = answerstext.answerid 
ORDER BY topicquestions.order ASC

SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 65920
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 65920
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC

	SELECT summary
	FROM answers
	WHERE answers.answerid = '65920'

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65920'
	and qid = 391

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 

SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 

	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65920 

	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 65920 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'

	SELECT *
	FROM markers
	WHERE answerid = '65920'
	and lat <> ''
	and lng <> ''

		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 77006 

		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76515 

		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76932 

		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76808 

		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 76539 

		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 76532 

		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76816 

		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 77061 

	Select *
	From Networks
	Where networkID = 159 

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65245
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 48979
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25145
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24101
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10888
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10020
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 4247
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 1759
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 1696
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 22484
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 73431
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65756
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 28484
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 2600
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 27287
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 22586
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10353
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11865
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 13872
				AND answerstext.qid = 82
					

				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11210
				AND answerstext.qid = 82
					

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-08-07"
     
         and rptarticlenetworks.networkid = 159 
    ORDER by rptarticles.rptarticleID desc
    

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles 
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-08-07"  
    ORDER by articles.articleID desc  

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and city <> ''
         and date > '2013-04-01'
         order by date DESC

		Select summary, hiimg 
		FROM answers
         where answerid = 76142
         and summary <> ''

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
          and date > '2013-04-01'
		order by date DESC

		Select summary, hiimg 
		FROM answers
         where answerid = 76181
         and summary <> ''

  SELECT networkname, frmid, networkid, location1, location2, location3, location4, location5, shortname
  FROM mostcountries
  order by networkname

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/expatguide.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/expatguide.cfm
QUERY_STRING=
REMOTE_ADDR=172.69.63.177
REMOTE_HOST=172.69.63.177
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expatguide.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=33382990
cftoken=70899776
sessionid=IBEXPATEXCHANGE.COM_33382990_70899776
urltoken=CFID=33382990&CFTOKEN=70899776