Expat Guide to Living in Japan

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

	Select *
	From citynetworks
	Where networkID = 61
	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 = 61 

	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 61
	and guidephoto = 'yes'
	and twimg <> ''

	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 61 

SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC

SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-03 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-27"
and param1 = 'awdyn'
ORDER BY logtime DESC

	SELECT *
	From contentcountcountry
	Where networkid = 61 

	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
    and bannerPlacement.networkid = 61
    and bannerPlacement.bannerid = banners.bannerid

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

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 61 
	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 publishdate < "2020-06-03"
    ORDER by articles.articleID desc

SELECT qoid, value 
FROM qoptions 

WHERE value = 'Japan' 

and qid = 46

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

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

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

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

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

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

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

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 61 

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

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

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
      
         and rptarticlenetworks.networkid = 61 

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 61
and allreports.networkid = 61
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 = 80487
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 80487 = answerstext.answerid 
ORDER BY topicquestions.order ASC

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

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

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

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

	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80487 

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

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

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

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

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

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

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

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

	Select *
	From Networks
	Where networkID = 61 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 61 
	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-06-03"

    ORDER by articles.articleID desc
    

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 61 
    ORDER by rptarticles.rptarticleID desc
    

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=networkID=61
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=28915331
cftoken=36174102
sessionid=IBEXPATEXCHANGE.COM_28915331_36174102
urltoken=CFID=28915331&CFTOKEN=36174102

URL Parameters:
networkID=61