Kazakhstan
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Kazakhstan Forum

PM's Friends Profile

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

Post New Topic
  Topic Originator Last Post
pinned post pinned post Introduce Yourself (0) adminee 10/16/2020 11:22 AM
no new messages Expat Coronavirus Report (0) adminee 3/16/2020 12:11 PM
no new messages Property to rent (0) Flyingscotsman 6/6/2019 6:12 AM
no new messages Considering relocation (0) Flyingscotsman 6/5/2019 6:22 AM
no new messages Almaty Hash House Resurrection - AYH3 (1) JuliaDownwardDog 8/12/2018 7:48 AM
no new messages International schools (0) Beaver24 7/9/2018 10:21 PM
Cigna International Health Insurance

no new messages Thanksgiving Gatherings in Your Region of Kazakhstan (0) adminee 11/14/2017 12:32 PM
no new messages Employment opportunities for partners (2) garirvine 9/13/2017 6:48 AM
no new messages Expat Medical service in Almaty (0) DTemirbek 6/29/2017 11:31 AM
no new messages Work Permit (0) choudhmh 5/10/2017 10:29 AM
no new messages Work Permit (0) choudhmh 5/10/2017 10:29 AM
no new messages Any good gyms/health clubs in Aktau (0) johannvdeventer 4/8/2017 12:34 PM
no new messages Opportunities for personal trainers (0) johannvdeventer 4/8/2017 12:34 PM
no new messages Expat Doctor in Aktau (0) chubby32 2/26/2017 8:15 AM
no new messages Job:English Language Teacher in Atyrau (0) damird 11/23/2016 5:00 PM
no new messages are you an native speaking English teacher in Almaty? (11) bafeet 11/10/2016 6:47 AM
1   2   3   4   5   6   of 15 pages >  >>
1   2   3   4   5   6   of 15 pages
>  >>
Expatriate Health Insurance

Get a quote for expat health insurance in Kazakhstan.

International Moving Quotes

Moving to Kazakhstan? Get a moving quote.


Mail Forwarding to Kazakhstan

Mail Forwarding to Kazakhstan.


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 Kazakhstan from our partner, Cigna Global Health.
Get a Quote

Culture-Shock-in-AlmatyAn Expat Talks about Culture Shock & Living in Almaty, Kazakhstan

A teacher from South Africa decided to move to Almaty after experiencing significant culture shock while living in Semipalatinsk. He share why he enjoys life in Almaty.

A teacher from South Africa decided to move to Almaty after experiencing significant culture shock while living in Semipalatinsk. He share why he enjoys life in Almaty....

Kazakhstan 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 31-Oct-20 12:18 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.62.223
Host Name 162.158.62.223


Execution Time

Total Time Avg Time Count Template
116 ms 116 ms 1 /home/www/html/expat/Application.cfm
49 ms 49 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
48 ms 48 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
47 ms 47 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/expat/topics_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
21 ms 21 ms 1 /home/www/html/navcontentbox.cfm
12 ms 12 ms 1 /home/www/html/navtop_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/navleader_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/expat/queries/mysql/qry_GetTopics.cfm
6 ms 6 ms 1 /home/www/html/expat/queries/mysql/qry_GetPinnedTopics.cfm
5 ms 5 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.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_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.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 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
117 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 @ 00:18:22.022
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=10ms, Records=1) in /home/www/html/expat/Application.cfm @ 00:18:22.022
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 00:18:22.022
	Select *
	From Networks
	Where frmid = 238 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 00:18:22.022
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 00:18:22.022
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 63 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 00:18:22.022
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 238 
getcities (Datasource=expert, Time=1ms, Records=3) in /home/www/html/navmetaforums_rdesign5.cfm @ 00:18:22.022
	Select *
	From citynetworks
	Where networkID = 63
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 00:18:22.022
  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/navmetaforums_rdesign5.cfm @ 00:18:22.022
	Select *
	From Networks
	Where networkID = 63 
getcountryphoto (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmetaforums_rdesign5.cfm @ 00:18:22.022
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 63
	order by lastsent ASC
GetTopics (Datasource=forum, Time=3ms, Records=233) in /home/www/html/navmetaforums_rdesign5.cfm @ 00:18:22.022
  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 = 238
  AND t.isapproved = 1
  GROUP by t.tpcid
   ORDER BY tpcupdate DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 00:18:22.022
SELECT *
FROM tracking
WHERE ipaddress = '162.158.62.223'
and logtime > "2020-08-01"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 00:18:22.022
SELECT *
FROM tracking
WHERE ipaddress = '162.158.62.223'
and logtime > "2020-10-31 00:00:00.000"
and logtime < "2020-10-31 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 @ 00:18:22.022
SELECT *
FROM tracking
WHERE ipaddress = '162.158.62.223'
and logtime > "2020-10-24"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 00:18:22.022
	SELECT *
	From contentcountcountry
	Where networkid = 63 
gettopbanner (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 00:18:22.022
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-10-30"
    and fromDate < "2020-10-31"
UpdatePageViews (Datasource=expert, Time=8ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 00:18:22.022
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
GetNavigator (Datasource=forum, Time=2ms, Records=262) in /home/www/html/expat/Application.cfm @ 00:18:22.022
  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 = 238 
  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 @ 00:18:22.022
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 238
  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 @ 00:18:22.022
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 00:18:22.022
  SELECT * FROM designset
  WHERE designsetid = 11 
GetForumleaders (Datasource=forum, Time=0ms, Records=0) in /home/www/html/expat/topics_rdesign5.cfm @ 00:18:22.022
  SELECT u.userid, u.username, u.userdbname
  FROM users u, forumleaders fl, userprofiles
  WHERE u.userid = fl.userid
  AND fl.frmid = 238
  and u.userid = userprofiles.userid
  AND u.userdbname = "ee"
  ORDER BY u.username
getcritical (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expat/topics_rdesign5.cfm @ 00:18:22.022
	Select *
	From articles, articlePlacement
	Where articlePlacement.networkID = 63 
    AND articlePlacement.articleID = articles.articleID 
    and articles.hinet = 'c'
    and articles.general = 'no'
    and articles.hitopic <> ''
    and articles.hidescript <> ''
    and publishdate <{ts '2020-10-31 00:18:22'}
    ORDER by aDate desc
GetTopics (Datasource=forum, Time=7ms, Records=217) in /home/www/html/expat/queries/mysql/qry_GetTopics.cfm @ 00:18:22.022
  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 = 238
  AND t.isapproved = 1
  AND t.tpcid = m.tpcid
  and m.msgparent = 0
  and m.isdeleted = 0
  and t.pinned <> 1
  AND t.userid = users.userid 
  GROUP by t.tpcid
  ORDER BY tpcupdate DESC 
GetPinnedTopics (Datasource=forum, Time=6ms, Records=1) in /home/www/html/expat/queries/mysql/qry_GetPinnedTopics.cfm @ 00:18:22.022
  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 = 238
  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-10-31" or pinneduntil = '')
  AND t.userid = users.userid 
  GROUP by t.tpcid
  ORDER BY tpcupdate DESC 
gethpbox (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 00:18:22.022
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-10-30 00:18:22'}
    and fromDate <{ts '2020-10-31 00:18:22'}
    and weight > 7
    and bannerPlacement.networkid = 63
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 00:18:22.022
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-10-30 00:18:22'}
    and fromDate <{ts '2020-10-31 00:18:22'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 00:18:22.022
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
getclasscheck (Datasource=tipripper, Time=26ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 00:18:22.022
	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 = 63
	AND "2020-10-31" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 00:18:22.022
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 63 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 00:18:22.022
		Select summary, hiimg 
		FROM answers
         where answerid = 70471
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 00:18:22.022
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 63 
        and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 00:18:22.022
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 63 
	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-10-31"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 00:18:22.022
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-10-31"
     
         and rptarticlenetworks.networkid = 63 
    ORDER by rptarticles.rptarticleID asc   
    


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=238
REMOTE_ADDR=162.158.62.223
REMOTE_HOST=162.158.62.223
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=39529542
cftoken=61983471
sessionid=IBEXPATEXCHANGE.COM_39529542_61983471
urltoken=CFID=39529542&CFTOKEN=61983471
URL Parameters:
frmid=238
Debug Rendering Time: 14 ms