Expat Guide to Living in Uruguay

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

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

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

	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 115 

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

SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
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 = '173.245.54.151'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC

	SELECT *
	From contentcountcountry
	Where networkid = 115 

	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"

	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"

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

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

and qid = 46

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

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

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

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

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

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

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 115 
         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 = 115 

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

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 115 
   	 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 = 115 

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

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

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

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

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

	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 33
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID

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

SELECT  hpimg
FROM rptarticles
where rptarticleID = 33
and hpimg <> ''

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

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

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

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

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

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

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

SELECT *
FROM expertusers
WHERE userid = 45154
and startdate <{ts '2020-06-02 03:18:06'}
and enddate > {ts '2020-06-03 03:18:06'} 

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

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

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

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

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

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

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

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

	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 78009 

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

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

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

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

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

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

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

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

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

	Select *
	From Networks
	Where networkID = 115 

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

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

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

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

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

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

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

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

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

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

	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 33
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID

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

SELECT  hiimg
FROM rptarticles
where rptarticleID = 33
and hiimg <> ''

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=115
REMOTE_ADDR=173.245.54.151
REMOTE_HOST=173.245.54.151
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=28918009
cftoken=15329382
sessionid=IBEXPATEXCHANGE.COM_28918009_15329382
urltoken=CFID=28918009&CFTOKEN=15329382

URL Parameters:
networkID=115