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

India Forum

PM's Friends Profile

Welcome to Expat Exchange's India Forum. This expat forum is the perfect place for expats living in India and people thinking about moving to India. Since 1997, Expat Exchange has been connecting expats in India.

Post New Topic
  Topic Originator Last Post
pinned post pinned post Posting Photos (0) adminee 4/22/2020 2:54 PM
pinned post pinned post Coronavirus Information & Support (No Politics) (0) adminee 3/20/2020 12:49 PM
no new messages Incoming Mail to India From The United States (0) cstarz 5/18/2020 9:19 AM
no new messages Expat Coronavirus Report (0) adminee 3/16/2020 12:11 PM
no new messages Personal Investment in India (0) Daanav 3/7/2020 11:39 AM
no new messages How to avoid relocation scam in India for expats! (0) Dwighthowie 3/5/2020 5:57 AM
no new messages Coronavirus Info (0) adminee 3/2/2020 9:52 AM
Cigna International Health Insurance

no new messages Wilderness Festival at Discovery Village- Nandi Hills (0) Riak 2/3/2020 9:11 AM
no new messages Western Food in Punjab (1) Iluvatar 9/3/2019 11:19 AM
no new messages Taxing of Interest from Savings Accounts and Fixed Deposits (2) deafdrummer 9/2/2019 3:20 AM
no new messages Move to Delhi (possibly?) (3) abekoff 9/1/2019 3:33 PM
no new messages golf apartment on lease in Gurgaon (0) chicoochiklit 7/9/2019 12:15 PM
no new messages Puppies! (0) Sunflowersally 5/1/2019 9:38 AM
no new messages Dressed appropriate? (0) lavendersky 4/3/2019 5:54 PM
no new messages Vodafone problems (0) Pendrive 3/30/2019 7:59 AM
no new messages hill station real estate (4) sitar999 3/19/2019 4:13 AM
no new messages Very Nervous - Move to Pune (11) AP 3/18/2019 6:02 AM
1   2   3   4   5   6   of 49 pages >  >>
1   2   3   4   5   6   of 49 pages
>  >>

A special thanks to our volunteer:

RAJAN in Hyderabad

Want to get involved? Volunteer on the India Network

Expatriate Health Insurance

Get a quote for expat health insurance in India.

International Moving Companies

Moving to India? Get a moving quote.


Mail Forwarding to India

Mail Forwarding to India.


Expat Tax

Expat Tax Preparation, Expat Tax Professionals

Join Today (free)

Join Expat Exchange to meet expats in your area or get advice before your move. It's FREE and takes 1 minute!

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-MumbaiAn Expat Talks about Culture Shock & Living 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.

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 ...

10-Tips-for-Living-in-India10 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.

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

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...

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....

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 /expat/index.cfm
Time Stamp 03-Jun-20 01:18 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.128
Host Name 162.158.78.128


Execution Time

Total Time Avg Time Count Template
277 ms 277 ms 1 /home/www/html/expat/Application.cfm
189 ms 189 ms 1 /home/www/html/expat/topics_rdesign5.cfm
56 ms 56 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
55 ms 55 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
54 ms 54 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
28 ms 28 ms 1 /home/www/html/navcontentbox.cfm
23 ms 23 ms 1 /home/www/html/expat/queries/mysql/qry_GetTopics.cfm
19 ms 19 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
11 ms 11 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/expat/queries/mysql/qry_GetPinnedTopics.cfm
5 ms 5 ms 1 /home/www/html/navtop_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetCategory.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/ibstyle.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetModerators.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_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
279 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 13:18:37.037
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/expat/Application.cfm @ 13:18:37.037
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 13:18:37.037
	Select *
	From Networks
	Where frmid = 227 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 13:18:37.037
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 13:18:37.037
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 54 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 13:18:37.037
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 227 
getcities (Datasource=expert, Time=1ms, Records=7) in /home/www/html/navmetaforums_rdesign5.cfm @ 13:18:37.037
	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/navmetaforums_rdesign5.cfm @ 13:18:37.037
  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=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 13:18:37.037
	Select *
	From Networks
	Where networkID = 54 
getcountryphoto (Datasource=expert, Time=1ms, Records=15) in /home/www/html/navmetaforums_rdesign5.cfm @ 13:18:37.037
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 54
	order by lastsent ASC
GetTopics (Datasource=forum, Time=7ms, Records=757) in /home/www/html/navmetaforums_rdesign5.cfm @ 13:18:37.037
  SELECT t.tpcid, t.frmid, t.userid, tpcupdate, t.msgcount-1 as replycount, tpcname, ispoll, t.isclosed, t.isapproved, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid 
  FROM topics t  
  WHERE t.frmid = 227
  AND t.isapproved = 1
  GROUP by t.tpcid
   ORDER BY tpcupdate DESC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:18:37.037
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:18:37.037
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-03 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:18:37.037
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:18:37.037
	SELECT *
	From contentcountcountry
	Where networkid = 54 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 13:18:37.037
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 13:18:37.037
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
GetNavigator (Datasource=forum, Time=7ms, Records=962) in /home/www/html/expat/Application.cfm @ 13:18:37.037
  SELECT catid, allowattach, isreviewed, isprivate, f.frmid as frmid, frmname, frmdesc, frmorder, frmpass, frmnotice, isapproved, f.isclosed as frmclosed, tpcname, tpcid, t.isclosed as tpcclosed, ispoll, isreviewed
  FROM forums f, topics t  
  WHERE f.frmid = 227 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=0ms, Records=0) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 13:18:37.037
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 227
  AND u.userdbname = "ee"
  ORDER BY u.username
GetCategory (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 13:18:37.037
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 13:18:37.037
  SELECT * FROM designset
  WHERE designsetid = 11 
GetForumleaders (Datasource=forum, Time=128ms, Records=1) in /home/www/html/expat/topics_rdesign5.cfm @ 13:18:37.037
  SELECT u.userid, u.username, u.userdbname
  FROM users u, forumleaders fl, userprofiles
  WHERE u.userid = fl.userid
  AND fl.frmid = 227
  and u.userid = userprofiles.userid
  AND u.userdbname = "ee"
  ORDER BY u.username
getcritical (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expat/topics_rdesign5.cfm @ 13:18:37.037
	Select *
	From articles, articlePlacement
	Where articlePlacement.networkID = 54 
    AND articlePlacement.articleID = articles.articleID 
    and articles.hinet = 'c'
    and articles.general = 'no'
    and articles.hitopic <> ''
    and articles.hidescript <> ''
    and publishdate <{ts '2020-06-03 13:18:37'}
    ORDER by aDate desc
GetTopics (Datasource=forum, Time=23ms, Records=723) in /home/www/html/expat/queries/mysql/qry_GetTopics.cfm @ 13:18:37.037
  SELECT t.tpcid, t.frmid, t.userid, tpcupdate, t.msgcount-1 as replycount, tpcname, ispoll, t.isclosed, t.isapproved, users.userid, users.username, users.userdbname, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, m.msgdate
  FROM users, topics t, messages m
  WHERE t.frmid = 227
  AND t.isapproved = 1
  AND t.tpcid = m.tpcid
  and m.msgparent = 0
  and m.isdeleted = 0
  AND t.userid = users.userid 
  and t.pinned = 0
  GROUP by t.tpcid
  ORDER BY tpcupdate DESC 
GetPinnedTopics (Datasource=forum, Time=7ms, Records=2) in /home/www/html/expat/queries/mysql/qry_GetPinnedTopics.cfm @ 13:18:37.037
  SELECT t.tpcid, t.frmid, t.userid, tpcupdate, t.msgcount-1 as replycount, tpcname, ispoll, t.isclosed, t.isapproved, users.userid, users.username, users.userdbname, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, m.msgdate, t.pinned, t.pinneduntil
  FROM users, topics t, messages m
  WHERE t.frmid = 227
  AND "ee" = "ee"
  AND t.isapproved = 1
  AND t.tpcid = m.tpcid
  and m.msgparent = 0
  and m.isdeleted <> 1
  and t.pinned = 1
  and (pinneduntil > "2020-06-03" or pinneduntil = '')
  AND t.userid = users.userid 
  GROUP by t.tpcid
  ORDER BY tpcupdate DESC 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 13:18:37.037
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-06-02 13:18:37'}
    and fromDate <{ts '2020-06-03 13:18:37'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 13:18:37.037
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetLeaderCity (Datasource=forum, Time=18ms, Records=1) in /home/www/html/expat/topics_rdesign5.cfm @ 13:18:37.037
  SELECT lotown as city
  FROM userlocales
  WHERE userid = 24635
  and lostatus = 'current'
getclasscheck (Datasource=tipripper, Time=25ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 13:18:37.037
	SELECT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 54
	AND "2020-06-03" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkculturefeature (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 13:18:37.037
		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 @ 13:18:37.037
		Select summary, hiimg 
		FROM answers
         where answerid = 75415
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 13:18:37.037
		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=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 13:18:37.037
	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-06-03"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:18:37.037
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 54 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 13:18:37.037
	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 @ 13:18:37.037
	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 @ 13:18:37.037
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/expat/index.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/index.cfm
QUERY_STRING=frmid=227
REMOTE_ADDR=162.158.78.128
REMOTE_HOST=162.158.78.128
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
MS=flat
Session Variables:
cfid=28940393
cftoken=79868237
sessionid=IBEXPATEXCHANGE.COM_28940393_79868237
urltoken=CFID=28940393&CFTOKEN=79868237
URL Parameters:
frmid=227
Debug Rendering Time: 11 ms