Home Philippines Forum Philippines Guide Moving to Philippines Real Estate Healthcare in Philippines
Philippines
Resources
City Guides
JoinSign In

Working in Philippines > Manila >

Expat Advice: Working in Manila, Philippines

What is the name of the city or town that you are reporting on?

Manila

What are the main industries in this city? What types of career opportunities commonly exist? How do most people find new jobs?

call centers, English institutes, esp. in Metro Manila, Baguio, and Cebu. There are tons of opportunities available, depending on your expertise. I can help you find your niche. Most people find jobs or work thru making contacts with friends, relatives, co-workers, or (my preference) just approaching people and introducing yourself as wanting to work or do business.

What type of work do you do and how did you find your job?

consultant (call center training), English tutor, trainer, instructor. plenty of business, just be friendly and make contacts and expand your network abroad

Expats living in Philippines interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA. Get a Quote

Expats living in Philippines interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

How did you obtain your work permit? What advice would you have for others about work permits?

Didn't need work permit since I have dual-citizenship. However, if you want to be an employee, most companies will sponsor you and pay for your work permits, visas, etc. I advise working as an independent contractor in your own consulting business. Work under the radar whenever possible.

Have you taken language and cross-cultural training courses to prepare for your assignment? If so, how have they helped you on the job?

no need to take formal language courses. learn the local lingo (Taglish - Tagalog/English), some important daily phrases and vocabulary and you can get by well. Everyone speaks English even in the remote countryside and provinces. If you can speak English well, you can be King or Queen and earn immediate respect

What advice would you offer others about finding jobs and working abroad?

check with locals, however always keep your financial status (as well as social status) to yourself. If you need help, I'm just a email or chat away! Mabuhay, Aloha, Salud, and Cheers!

email:

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in Philippines from our partner, Cigna Global Health.
Get a Quote

More about Manila

Guide to Living in Manila

Guide to Living in Manila

Expats in Manila have reported many of the same themes since the inception of Expat Exchange. Read some basic facts and tips about this Philippine city (and metro area) on the island of Luzon.

Healthcare in Philippines

Healthcare in Philippines

Expats in the Philippines have a lot to say about the quality of medical care, hospitals, prescription medicine availability and health insurance in the Philippines.

Moving to Valenzuela City

An expat in Valensuela City, Philippines says to do your research and visit various areas before you commit to one location. Look for schools, medical and grocery store locations that are fairly close to where you live.

12 Tips for Living in Manila, Philippines

12 Tips for Living in Manila, Philippines in Manila

An expat talks about living in Manila, Philippines. He explains that mainly move to Manila for the low cost of living, friendly people and warm climate.

Culture Shock in Metro Manila

A Dutch woman who moved to the Philippines 9 years ago. Initially, she worked as a housemother with 19 former street children in her care. She learned Tagalog. For her, the most challenging aspects of living in the Philippines are the heat, traffic and lack of privacy.

Join our Philippines Expat Forum

Visit our Philippines Forum and talk with other expats who can offer you insight and tips about living in Manila, Philippines.

More about Philippines

6-Best-Places-to-Live-in-The-PhilippinesExpat Philippines: 6 Best Places to Live in The Philippines

With its low cost of living, beautiful beaches, bustling cities and hot climate, expats have been flocking to the Philippines for years. Here are six of the best places for expats to live in the Philippines.

9-Healthcare--Health-Insurance-Tips-for-Expats-in-the-Philippines9 Healthcare & Health Insurance Tips for Expats in the Philippines

Expats in the Philippines have a lot to say about the quality of medical care, hospitals, prescription medicine availability and health insurance in the Philippines.

8-Safest-Places-to-Live-in-the-Philippines8 Safest Places to Live in the Philippines

With the rise of terrorism in certain parts of the Philippines, expats in the Philippines helped us compile a list of safe places to live in the Philippines. Here are 8 of the safest expat destinations in the Philippines.

7-Things-to-Know-Before-You-Move-to-the-PhilippinesMoving to the Philippines: 7 Things to Know Before You Move to the Philippines

Expats moving to the Philippines join others that have moved there for work or a lower cost of living during retirement. It's critical to understand what the realities of living there are, but those that successfully make the adjustment believe it is a good place to live.

Cigna International Health Insurance

Write a Comment about this Expat Report

Sign In to post a comment.
addacomment
Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in Philippines from our partner, Cigna Global Health.
Get a Quote

Guide to Living in ManilaGuide to Living in Manila

Expats in Manila have reported many of the same themes since the inception of Expat Exchange. Read some basic facts and tips about this Philippine city (and metro area) on the island of Luzon.

Healthcare in PhilippinesHealthcare in Philippines

Expats in the Philippines have a lot to say about the quality of medical care, hospitals, prescription medicine availability and health insurance in the Philippines.

Restaurants in ManilaRestaurants in Manila

Support your favorite restaurants in Manila as they recover from the pandemic. Submit a free listing for them on Expat Exchange to help spread the word about them to the expat community.

Moving to Valenzuela City

An expat in Valensuela City, Philippines says to do your research and visit various areas before you commit to one location. Look for schools, medical and grocery store locations that are fairly close to where you live.

12 Tips for Living in Manila, Philippines12 Tips for Living in Manila, Philippines in Manila

An expat talks about living in Manila, Philippines. He explains that mainly move to Manila for the low cost of living, friendly people and warm climate.

Culture Shock in Metro Manila

A Dutch woman who moved to the Philippines 9 years ago. Initially, she worked as a housemother with 19 former street children in her care. She learned Tagalog. For her, the most challenging aspects of living in the Philippines are the heat, traffic and lack of privacy.

6-Best-Places-to-Live-in-The-PhilippinesExpat Philippines: 6 Best Places to Live in The Philippines

With its low cost of living, beautiful beaches, bustling cities and hot climate, expats have been flocking to the Philippines for years. Here are six of the best places for expats to live in the Philippines.

9-Healthcare--Health-Insurance-Tips-for-Expats-in-the-Philippines9 Healthcare & Health Insurance Tips for Expats in the Philippines

Expats in the Philippines have a lot to say about the quality of medical care, hospitals, prescription medicine availability and health insurance in the Philippines.

Philippines Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /rspnet.cfm
Time Stamp 06-Jun-20 01:28 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.242
Host Name 172.69.62.242


Execution Time

Total Time Avg Time Count Template
123 ms 123 ms 1 top level /home/www/html/rspnet.cfm
48 ms 48 ms 1 /home/www/html/navcontentboxcityrptsmobile.cfm
36 ms 36 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
35 ms 35 ms 1 /home/www/html/navcontentboxcitypc.cfm
35 ms 35 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/commentsnew_rdesign4.cfm
7 ms 7 ms 1 /home/www/html/rspnet_ctygd_readnext.cfm
6 ms 6 ms 1 /home/www/html/breadcrumb_ctygd.cfm
6 ms 6 ms 1 /home/www/html/navtop_ctygd2.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navlikeandmore_rdesign5.cfm
0 ms 0 ms 6 /home/www/html/rewritearticle.cfm
0 ms 0 ms 4 /home/www/html/rewritecityname.cfm
0 ms 0 ms 4 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 4 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
131 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 01:28:21.021
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=4ms, Records=1) in /home/www/html/Application.cfm @ 01:28:21.021
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 01:28:21.021
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 65
AND networkid = 90 
AND 21484 = answerid

GROUP BY answerid
ORDER by city
citystatus (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 01:28:21.021
	Select *
	From allreports, citynetworks 
	Where allreports.answerid = 21484
	and allreports.citynetworkid = citynetworks.citynetworkid
getquestions (Datasource=reports, Time=6ms, Records=6) in /home/www/html/rspnet.cfm @ 01:28:21.021
SELECT DISTINCT questions.qid, answers.answerid, questions.question, responsequestions.qid, answerstext.qid, answerstext.answer as answer, answerstext.reviewed, answerstext.score, answers.rid, answers.reviewed, responses.intro, responses.responsename, responsequestions.listorder, answers.userid, answers.date
FROM responsequestions, questions, answers, responses, answerstext
WHERE answerstext.qid = questions.qid

AND 21484 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 21484 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 01:28:21.021
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 21484 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:28:21.021
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:28:21.021
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 90 
getcities (Datasource=expert, Time=0ms, Records=6, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:28:21.021
	Select *
	From citynetworks
	Where networkID = 90
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:28:21.021
  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
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 01:28:21.021
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 21484 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
getalternatesummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:28:21.021
				SELECT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 21484
				AND answerstext.qid = 107 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 01:28:21.021
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.242'
and logtime > "2020-03-07"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 01:28:21.021
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.242'
and logtime > "2020-06-06 00:00:00.000"
and logtime < "2020-06-06 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 01:28:21.021
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.242'
and logtime > "2020-05-30"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 01:28:21.021
	SELECT *
	From contentcountcountry
	Where networkid = 90 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 01:28:21.021
	SELECT *
	From contentcountcity
	Where citynetworkid = 4205 
getarticlesection (Datasource=expert, Time=0ms, Records=48) in /home/www/html/breadcrumb_ctygd.cfm @ 01:28:21.021
SELECT *
FROM articleCategories
 
WHERE section = 8
checkcitynetwork (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 01:28:21.021
		Select *
		FROM allreports, citynetworks
         where answerid = 21484
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
getworkingintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/breadcrumb_ctygd.cfm @ 01:28:21.021
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 90 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
      and keycity = 0
    and cityintro = 'n'
   and articleCategories.section = '8'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-06"

    ORDER by articles.articleID asc   
    
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 01:28:21.021
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 21484 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:28:21.021
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:28:21.021
	Select *
	From Networks
	Where networkid = 90 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:28:21.021
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:28:21.021
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 90
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-06-05"
and natsentencestart < "2020-06-06"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high' or natsentenceweight = 'low')
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 4205
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-06" 
    ORDER by articles.articleID desc  
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4205
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 90 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         and networkid = 90 
         and allreports.answerid <> 21484 
          and citynetworkid = 4205
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 60827 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 3307 
gethealthcare (Datasource=tipripper, Time=12ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 90
and allreports.networkid = 90
 and allreports.citynetworkid2 =  4205
and allreports.topicid = 11
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
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 
getanswerstext (Datasource=tipripper, Time=6ms, Records=12) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
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 = 79620
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 79620 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79620'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79620'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79620 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 21484         
         and networkid = 90
          and citynetworkid = 4205
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73517 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 01:28:21.021
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26041 
gettaxgeneral (Datasource=expert, Time=6ms, Records=4) in /home/www/html/rspnet_ctygd_readnext.cfm @ 01:28:21.021
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 90 
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and publishdate < "2020-06-06"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 01:28:21.021
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-05"
    and fromDate < "2020-06-06"
    and bannerPlacement.networkid = 90
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 01:28:21.021
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 809 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 01:28:21.021
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-06-05 01:28:21'}
    and fromDate <{ts '2020-06-06 01:28:21'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 01:28:21.021
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 01:28:21.021
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 21484 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
getguidesummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4205
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 90 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
        
         and allreports.answerid <> 21484         
         and networkid = 90
          and citynetworkid = 4205
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 60827 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 3307 
gethealthcare (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 90
and allreports.networkid = 90
 and allreports.citynetworkid2 =  4205
and allreports.topicid = 11
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
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 
getanswerstext (Datasource=tipripper, Time=5ms, Records=12) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
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 = 79620
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 79620 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79620'
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79620'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 79620 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
checkculturefeature (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 21484         
         and networkid = 90
          and citynetworkid = 4205
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73517 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 01:28:21.021
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26041 


Scope Variables

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/rspnet.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/rspnet.cfm
QUERY_STRING=rid=65&answerid=21484&networkid=90&start=21484
REMOTE_ADDR=172.69.62.242
REMOTE_HOST=172.69.62.242
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnet.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=29078976
cftoken=44013030
sessionid=IBEXPATEXCHANGE.COM_29078976_44013030
urltoken=CFID=29078976&CFTOKEN=44013030
URL Parameters:
answerid=21484
networkid=90
rid=65
start=21484
Debug Rendering Time: 11 ms