Home India Forum India Guide Moving to India Real Estate Healthcare in India
India
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Expat Guide to Living in India

Whether you're already living in India or preparing to move to India, our Expat Guide to Living in India offers articles and reports submitted by expats about expat life in India. For answers to specific questions, visit our India Forum to talk with expats in India.

Healthcare in India

An overview of healthcare in India - the quality of hospitals, prescription medicine in India, vaccinations, finding an English-speaking doctor in India and more.

Moving to India

Moving to India? We've compiled a laundry list of advice from expats living in India about what to bring, apartments, expat life and more. It's must-read guide for anyone researching how to move to India.

7 Expats Talk About What It's Really Like Living in India

Expats in India talk about what it's really like living in India - the amazing food, friendly people, traffic, local markets, beggars, touts and more.

How To Ship A Car To India

Job Webster of A1 Auto Transport offers tips for shipping a car to India.

10 Tips for Living in India

Expats in India advise finding an apartment building or home with a backup generator, hiring a driver and adapting to Indian food.

Expat Health Insurance and Healthcare

Expat Health Insurance and Healthcare in

An expat in India discusses crowded hospitals, the cost of health insurance, prescription medicine availability and more.

Moving to Mumbai, India

One expat shares essential tips for anyone moving to Mumbai. Bring a good mattress and vacuum cleaner, find a reputable moving company and get lots of advice from Indians. For this expat, they were her saving grace.

Moving to New Delhi, India

Do your homework when searching for your home. Is there a generator? Are the air conditioners connected to it? Is the water safe to drink? Check out the neighbors, the guards, mold issues and more.

Culture Shock in Mumbai, India

Moving abroad is challenging, but moving with an illness is an even bigger challenge. An expat talks about her experiences moving to Mumbai. She looks forward to not having to work in India so that she can focus on getting well.

Culture Shock in Mumbai, India

What is it like to move from Canada to Mumbai, India when the wheels of government don't turn the way you would like them to? This Expat Culture-Shock Report provides a window into that experience.

Dream vs Reality of Living in Pune, India

An expat talks about what she expected vs. the reality of living in Pune, India. Her expectations about dirtiness, poverty and the amazing Taj Mahal were met. But, she expected to be lonely, and, that was thankfully far from reality.

More Culture Shock Reports for India

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in India handle it can be very comforting. Below are some of the responses from expats in India:
Submit a Culture Shock Report

More Living in India Reports

What are people's priorities in India - work? family? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Below are some of the responses from expats in India:
Submit a Living Overseas Report

More Moving to India Reports

What should you take with you when you move to India? What should you leave behind? What type of housing and neighborhoods are typical for expats in India? Below are some of the responses from expats in India:
Submit a Moving Overseas Report

Dream vs. Reality of Living in India Reports

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to India. If you are already living in India, share how those "dreams" have been fulfilled, and how they have not. Below are some of the reports from expats in India:
Submit a Dream vs. Reality Report

Overseas Retirement Report

Retiring abroad can be a great option for retirees seeking their dream lifestyle at an affordable price. Help other retirees, who are thinking about retiring in India by taking our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby Abroad Report

How did expats choose their doctors, midwives, hospitals? What is childbirth like in India? Help other expats who are preparing to have a baby in India by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working Abroad Report

What's it like to find a job in India? How difficult was it to obtain a work permit? What types are jobs are typical for expats in India? Help others following in your footsteps by filling out our Working Abroad Report.

Submit a Working Abroad Report
Additional Articles
Moving Back to India – How I Did It

One woman shares her story of returning to her native India from a 15 year life in San Francisco. Would her kids adjust to the new lifestyle? Would it be a good transition for them?

Living in India: So What Do I Care?

Anamika Majumder, the founder of One Billion Literates, explores the values that unify India, a nation increasingly divided by extreme wealth and extreme poverty.

Repatriating to India: Boston Ave to Devarabeesanahalli

Anamika Majumder was a newlywed Indian expat living in Boston who attended graduate school, entered the business world and raised two young children. She and her husband ultimately decided to repatriate to India to raise their children in their home country. She describes their return to Bangalore and how she decided to start a Bangalore based non profit charitable trust called One Billion Literates Foundation.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-GurgaonAn Expat Talks about Culture Shock & Living in Gurgaon, India

A mom who relocated to Gurgaon, India talks about the challenges of living in Gurgaon. She finds that there's a lack out outdoor space to walk and play. Plus, numerous locals on the street have picked up and touched her 4 year old daughter without permission, which has increased her and her daughter's anxiety when out in public. She now finds herself swatting away people on the street.

A mom who relocated to Gurgaon, India talks about the challenges of living in Gurgaon. She finds that there's a lack out outdoor space to walk and play. Plus, numerous locals on the street have pick...

Healthcare-in-IndiaHealthcare in India

An overview of healthcare in India - the quality of hospitals, prescription medicine in India, vaccinations, finding an English-speaking doctor in India and more.

An overview of healthcare in India - the quality of hospitals, prescription medicine in India, vaccinations, finding an English-speaking doctor in India and more....

Moving-to-IndiaMoving to India

Moving to India? We've compiled a laundry list of advice from expats living in India about what to bring, apartments, expat life and more. It's must-read guide for anyone researching how to move to India.

Moving to India? We've compiled a laundry list of advice from expats living in India about what to bring, apartments, expat life and more. It's must-read guide for anyone researching how to move t...

7-Expats-Talk-About-What-Its-Really-Like-Living-in-India7 Expats Talk About What It's Really Like Living in India

Expats in India talk about what it's really like living in India - the amazing food, friendly people, traffic, local markets, beggars, touts and more.
Expats in India talk about what it's really like living in India - the amazing food, friendly people, traffic, local markets, beggars, touts and more....

India 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 /expatguide.cfm
Time Stamp 30-May-20 10:01 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.127
Host Name 172.69.63.127


Execution Time

Total Time Avg Time Count Template
319 ms 319 ms 1 /home/www/html/expatguide.cfm
24 ms 24 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/navcontentbox.cfm
23 ms 23 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 1 ms 2 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 0 ms 47 /home/www/html/rewriteqoptionsctry.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 1 /home/www/html/constants.cfm
0 ms 0 ms 1 /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/navjoin_rdesign5.cfm
0 ms 0 ms 9 /home/www/html/rewritearticle.cfm
0 ms 0 ms 47 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 47 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
324 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 @ 22:01:42.042
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 22:01:42.042
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:01:42.042
	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 @ 22:01:42.042
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 54 
getcities (Datasource=expert, Time=0ms, Records=7, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:01:42.042
	Select *
	From citynetworks
	Where networkID = 54
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:01:42.042
  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
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:01:42.042
	Select *
	From Networks
	Where networkID = 54 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 22:01:42.042
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 54
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:01:42.042
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 54 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:01:42.042
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-02-29"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:01:42.042
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-05-30 00:00:00.000"
and logtime < "2020-05-30 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_rdesign5.cfm @ 22:01:42.042
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-05-23"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:01:42.042
	SELECT *
	From contentcountcountry
	Where networkid = 54 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 22:01:42.042
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 22:01:42.042
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gettaxgeneral (Datasource=expert, Time=5ms, Records=7) in /home/www/html/expatguide.cfm @ 22:01:42.042
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 54 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and publishdate < "2020-05-30"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT qoid, value 
FROM qoptions 

WHERE value = 'India' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 54 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 54 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 54 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 54 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 54 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 54 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=8) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 54 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
     
         and rptarticlenetworks.networkid = 54 
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 54 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=6) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 54 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
      
         and rptarticlenetworks.networkid = 54 
checklivingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 54 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 54 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 54 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 54 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=6ms, Records=23) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 54 
   	 order by city, date DESC
         
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:01:42.042
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 36
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:01:42.042
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 54 
getlivingphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT  hpimg
FROM rptarticles
where rptarticleID = 36
and hpimg <> ''
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 54
and allreports.networkid = 54
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 54
and allreports.networkid = 54
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 54
and allreports.networkid = 54
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 54
and allreports.networkid = 54
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=2) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 54
and allreports.networkid = 54
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=2) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 54
and allreports.networkid = 54
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
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 
getanswerstext (Datasource=tipripper, Time=4ms, Records=5) in /home/www/html/expatguide.cfm @ 22:01:42.042
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 = 77211
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 77211 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 77211
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 77211
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
	SELECT summary
	FROM answers
	WHERE answers.answerid = '77211'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '77211'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 127101
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 127101
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 127101
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 127101
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 127101
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 77211 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '54'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 22:01:42.042
	SELECT *
	FROM markers
	WHERE answerid = '77211'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75416 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 28544 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75415 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 71406 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 21823 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 13813 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75689 
getname (Datasource=expert, Time=1ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 22:01:42.042
	Select *
	From Networks
	Where networkID = 54 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11865
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 73848
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 67379
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 67361
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 66227
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 27365
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26431
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25346
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25323
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 23700
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 23146
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 21524
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 14054
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 13867
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11367
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 28324
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 28656
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10842
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24576
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 28146
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 46273
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11961
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 22:01:42.042
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 73774
				AND answerstext.qid = 82
					
checkculturefeature (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 54 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:01:42.042
		Select summary, hiimg 
		FROM answers
         where answerid = 70240
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 22:01:42.042
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 54 
        and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 22:01:42.042
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 54 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=4ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:01:42.042
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
     
         and rptarticlenetworks.networkid = 54 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:01:42.042
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 36
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:01:42.042
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 54 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:01:42.042
SELECT  hiimg
FROM rptarticles
where rptarticleID = 36
and hiimg <> ''


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/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=54
REMOTE_ADDR=172.69.63.127
REMOTE_HOST=172.69.63.127
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=28727148
cftoken=97141651
sessionid=IBEXPATEXCHANGE.COM_28727148_97141651
urltoken=CFID=28727148&CFTOKEN=97141651
URL Parameters:
networkID=54
Debug Rendering Time: 13 ms