Expat Health Insurance & Healthcare Guide

  SELECT * FROM genset 
WHERE dbname = "ee"

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

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories
	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 < "{d '2020-05-28'}"
    and articleCategories.articleID = articles.articleID
    and articleCategories.section = 9
    ORDER by publishdate desc

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

SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
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 = '173.245.54.141'
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 = 865 

SELECT *
FROM natadoptions 
WHERE 'hibox' = tag

	Select *
	From Networks
	Where networkid = 159 

SELECT *
FROM natadoptions 
WHERE natadtypeid = 4 

SELECT resourceid, natboxglobal as adcode, natboxweight, natadid
FROM natads 
WHERE natboxtype = 4
and natboxend > "2020-05-27"
and natboxstart < "2020-05-28"
and natboxstatus = 'live'

and natboxweight = 'high'

	SELECT *
	From contentcountcountry

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 130 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 363 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 13 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 364 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 14 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 365 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 15 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 366 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 2 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 16 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 17 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 18 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 369 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 19 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 370 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 371 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 4 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 20 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 21 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 22 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 372 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 23 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 24 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 25 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 373 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 26 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 27 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 211 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 374 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 28 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 30 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 31 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 32 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 375 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 33 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 376 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 35 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 36 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 37 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 377 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 38 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 39 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 40 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 41 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 42 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 378 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 43 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 44 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 45 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 380 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 46 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 3 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 379 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 47 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 381 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 49 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 50 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 51 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 7 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 52 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 53 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 54 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 55 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 56 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 57 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 58 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 59 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 60 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 61 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 62 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 63 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 64 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 65 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 66 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 382 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 67 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 68 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 69 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 70 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 383 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 384 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 385 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 71 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 72 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 73 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 386 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 150 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 74 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 75 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 387 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 76 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 77 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 78 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 79 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 80 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 388 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 81 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 132 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 82 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 83 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 84 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 295 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 389 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 85 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 210 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 86 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 87 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 390 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 157 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 89 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 90 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 91 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 92 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 94 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 95 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 96 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 391 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 392 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 97 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 151 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 393 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 394 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 6 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 98 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 398 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 99 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 395 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 100 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 101 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 102 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 396 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 103 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 104 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 105 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 106 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 107 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 108 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 109 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 110 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 111 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 112 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 113 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 1 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 114 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 129 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 115 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 116 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 118 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 119 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 121 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 122 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 397 

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where Networks.networkid = contentcountcountry.networkID
	and Networks.networkid = 123 

SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and answers.answerid = allreports.answerid
and answers.summary <> ''
and allreports.topicid = 7
and allreports.networkid <> 159
and allreports.networkid <> 129
order by allreports.answerid DESC

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80716 

  SELECT *
  FROM users
  WHERE userid = 2 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80716 

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

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80710 

  SELECT *
  FROM users
  WHERE userid = 2 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80710 

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

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80519 

  SELECT *
  FROM users
  WHERE userid = 215485 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80519 

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

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80487 

  SELECT *
  FROM users
  WHERE userid = 224230 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80487 

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

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80459 

  SELECT *
  FROM users
  WHERE userid = 215485 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80459 

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

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80388 

  SELECT *
  FROM users
  WHERE userid = 45154 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80388 

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

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80327 

  SELECT *
  FROM users
  WHERE userid = 45154 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80327 

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

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80280 

  SELECT *
  FROM users
  WHERE userid = 220064 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80280 

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

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80240 

  SELECT *
  FROM users
  WHERE userid = 215485 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80240 

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

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

	SELECT DISTINCT summary, fbimg as photo
	FROM answers 
	WHERE answers.answerid = 80167 

  SELECT *
  FROM users
  WHERE userid = 217235 

SELECT DISTINCT summary, fbimg
FROM answers 
WHERE answers.answerid = 80167 

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

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

SELECT networkname as ctry, city, networkid, rid, answerid, networkname, userid
FROM allreports
WHERE rid = 88
GROUP BY answerid
ORDER BY answerid desc

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 76029 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 76029
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 76029 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 387
	and hiimg <> ''
	

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 76027 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 76027
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 76027 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 370
	and hiimg <> ''
	

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 75931 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 75931
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 75931 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 90
	and hiimg <> ''
	

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 75930 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 75930
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 75930 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 58
	and hiimg <> ''
	

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 75925 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 75925
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 75925 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 16
	and hiimg <> ''
	

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 75754 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 75754
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 75754 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 90
	and hiimg <> ''
	

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 75753 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 75753
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 75753 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 112
	and hiimg <> ''
	

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 72420 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 72420
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 72420 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 90
	and hiimg <> ''
	

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 72418 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 72418
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 72418 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 32
	and hiimg <> ''
	

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 71714 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 71714
AND answerstext.qid = 304

SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 71714 

	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 61
	and hiimg <> ''
	

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
    and articleCategories.section = '9'
    and articleCategories.articleID = articles.articleID
    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 *
	From contentcountcountry
	Where networkid = 77

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

    ORDER by allreports.answerid asc   
    

SELECT *
FROM topics
WHERE topicid = 7 

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65919 

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65919 

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65919 

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

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65920 

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65920 
	AND answerstext.qid = 409
	

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65920 

	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 77
	and fbimg <> ''
	

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65920 

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

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65921 

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65921 

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65921 

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

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65922 

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65922 
	AND answerstext.qid = 409
	

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65922 

	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 55
	and fbimg <> ''
	

	SELECT DISTINCT promophoto70 as photo 
	FROM topics
	WHERE topicid = 7 

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65922 

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

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65923 

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65923 
	AND answerstext.qid = 409
	

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65923 

	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 45
	and fbimg <> ''
	

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65923 

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

	SELECT *
	From contentcountcountry
	Where networkid = 77

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65919 

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65919 

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65920 

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65920 
	AND answerstext.qid = 409
	

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65920 

	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 77
	and fbimg <> ''
	

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

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65920 

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

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65921 

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65921 

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65922 

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65922 
	AND answerstext.qid = 409
	

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65922 

	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 55
	and fbimg <> ''
	

	SELECT DISTINCT promophoto70 as photo 
	FROM topics
	WHERE topicid = 7 

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

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65922 

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

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65923 

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65923 
	AND answerstext.qid = 409
	

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65923 

	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 45
	and fbimg <> ''
	

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

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65923 

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

  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/expat-healthcare-guide.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/expat-healthcare-guide.cfm
QUERY_STRING=
REMOTE_ADDR=173.245.54.141
REMOTE_HOST=173.245.54.141
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat-healthcare-guide.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=28573084
cftoken=94614706
sessionid=IBEXPATEXCHANGE.COM_28573084_94614706
urltoken=CFID=28573084&CFTOKEN=94614706