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 = '162.158.78.194'
and logtime > "2020-02-27"
and param1 = 'aw'
ORDER BY logtime DESC

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

SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-05-21"
and param1 = 'awdyn'
ORDER BY logtime DESC

	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
	and weight = 10
    and toDate > "2020-05-27"
    and fromDate < "2020-05-28"

  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-05-28"
    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-05-28"
     
         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-05-28"
      
         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 = 80407
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 80407 = answerstext.answerid 
ORDER BY topicquestions.order ASC

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

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

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

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
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 = 128279
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 = 128279
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 = 128279
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 = 128279
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 = 80407 

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

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

SELECT *
FROM expertusers
WHERE userid = 128279
and startdate <{ts '2020-05-27 14:47:57'}
and enddate > {ts '2020-05-28 14:47:57'} 

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 = 80293
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 80293 = answerstext.answerid 
ORDER BY topicquestions.order ASC

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

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

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80293'
	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 DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80293 

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

	SELECT *
	FROM markers
	WHERE answerid = '80293'
	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 = 65936
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 65936 = answerstext.answerid 
ORDER BY topicquestions.order ASC

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

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

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

SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 70105
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 = 70105
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 = 70105
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 = 70105
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 = 70105
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 

	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65936 

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

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

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

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

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

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

		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 = 76511 

	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-05-28"
     
         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-05-28"  
    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 = 76137
         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 = 76175
         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=162.158.78.194
REMOTE_HOST=162.158.78.194
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=28591896
cftoken=95104265
sessionid=IBEXPATEXCHANGE.COM_28591896_95104265
urltoken=CFID=28591896&CFTOKEN=95104265