Expat Guide to Living in Turkey

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

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

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

	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 110 

SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-02-28"
and param1 = 'aw'
ORDER BY logtime DESC

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

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

	SELECT *
	From contentcountcountry
	Where networkid = 110 

	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
    and bannerPlacement.networkid = 110
    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 = 110 
	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-05-29"
    ORDER by articles.articleID desc

SELECT qoid, value 
FROM qoptions 

WHERE value = 'Turkey' 

and qid = 46

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

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

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

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

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

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

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 110 
         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-29"
     
         and rptarticlenetworks.networkid = 110 

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

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

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-29"
      
         and rptarticlenetworks.networkid = 110 

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

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

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

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

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

SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 110
and allreports.networkid = 110
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 = 110
and allreports.networkid = 110
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 = 110
and allreports.networkid = 110
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC

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

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

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

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

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

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

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

	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65961 

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

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

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

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

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

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

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

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

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

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

	Select *
	From Networks
	Where networkID = 110 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-29"
     
         and rptarticlenetworks.networkid = 110 
    ORDER by rptarticles.rptarticleID desc
    

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

    ORDER by articles.articleID desc
    

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

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

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 110 
          and date > '2013-04-01'
		order by date 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=110
REMOTE_ADDR=162.158.78.68
REMOTE_HOST=162.158.78.68
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=28658010
cftoken=79505321
sessionid=IBEXPATEXCHANGE.COM_28658010_79505321
urltoken=CFID=28658010&CFTOKEN=79505321

URL Parameters:
networkID=110