Home Mexico Forum Mexico Guide Moving to Mexico Real Estate Healthcare in Mexico

Mexico

Resources

City Guides

Cigna International Health Insurance
Join Sign In
Cigna International Health Insurance

Mexico Travel Warning

Issued by US Department of State

Nov 15, 2018

Exercise increased caution in Mexico due to crime. Some areas have increased risk. Read the entire Travel Advisory.

Violent crime, such as homicide, kidnapping, carjacking, and robbery, is widespread.

The U.S. government has limited ability to provide emergency services to U.S. citizens in many areas of Mexico as travel by U.S. government employees to these areas is prohibited or significantly restricted.

U.S. government employees may not travel between cities after dark, may not hail taxis on the street, and must rely on dispatched vehicles, including from app-based services like Uber, or those from regulated taxi stands. U.S. government employees may not drive from the U.S.-Mexico border to or from the interior parts of Mexico with the exception of daytime travel within Baja California, and between Nogales and Hermosillo on Mexican Federal Highway 15D.

Read the Safety and Security section on the country information page.

Do not travel to:

For detailed information on all states in Mexico, please see below.

If you decide to travel to Mexico:

Aguascalientes state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

There are no restrictions on travel for U.S. government employees.

Baja California state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

Criminal activity and violence, including homicide, remain a primary concern throughout the state. While most of these homicides appeared to be targeted, criminal organization assassinations and turf battles between criminal groups have resulted in violent crime in areas frequented by U.S. citizens. Bystanders have been injured or killed in shooting incidents.

Due to poor cellular service and hazardous road conditions, U.S. government employees may only travel on Highway 2D between Mexicali and Tijuana via “La Rumorosa” during daylight hours.

There are no restrictions on travel for U.S. government employees in Baja California, which includes tourist areas in: Ensenada, Rosarito, and Tijuana.

Baja California Sur state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

Criminal activity and violence, including homicide, remain a primary concern throughout the state. While most homicides appeared to be targeted, criminal organization assassinations and turf battles between criminal groups have resulted in violent crime in areas frequented by U.S. citizens. Bystanders have been injured or killed in shooting incidents. 

There are no restrictions on travel for U.S. government employees in Baja California Sur, which includes tourist areas in: Cabo San Lucas, San Jose del Cabo, and La Paz.

Campeche state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

There are no restrictions on travel for U.S. government employees.

Chiapas state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

There are no restrictions on travel for U.S. government employees in Chiapas state, which includes tourist areas in: Palenque, San Cristobal de las Casas, and Tuxtla Gutierrez.

Chihuahua state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Violent crime and gang activity are widespread. While most homicides appeared to be targeted, criminal organization assassinations and turf battles between criminal groups have resulted in violent crime in areas frequented by U.S. citizens. Bystanders have been injured or killed in shooting incidents. 

Travel for U.S. government employees is limited to the following areas with the noted restrictions:

Visit our website for Travel to High-Risk Areas.

Coahuila state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Violent crime and gang activity are common in parts of Coahuila state.

Travel for U.S. government employees is limited to the following areas with the noted restrictions:

Visit our website for Travel to High-Risk Areas.

Colima state – Level 4: Do Not Travel

Do not travel due to crime.

Violent crime and gang activity are widespread.

Travel for U.S. government employees is limited to the following areas with the noted restrictions:

Visit our website for Travel to High-Risk Areas.

Durango state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Violent crime and gang activity are common in parts of Durango state.

U.S. government employees may not travel to the area west and south of Highway 45 and the city of Gomez Palacio.

There are no additional restrictions on travel for U.S. government employees.

Visit our website for Travel to High-Risk Areas.

Estado de Mexico state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Both violent and non-violent crime is prevalent in the Estado de Mexico. Mexican government statistics indicate criminal incidents in the Estado de Mexico occur at a significantly higher rate than much of the rest of Mexico. Pay particular caution to areas outside of the frequented tourist areas, although petty crime occurs frequently in tourist areas as well.

There are no restrictions on travel for U.S government employees.

Visit our website for Travel to High-Risk Areas.

Guanajuato state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

The majority of gang-related violence occurs in the south of the state, near the border with Michoacán, and is often linked to the widespread theft of petroleum and natural gas from the state oil company and other suppliers.

There are no restrictions on travel for U.S. government employees.

Guerrero state – Level 4: Do Not Travel

Do not travel due to crime.

Armed groups operate independently of the government in many areas of Guerrero. Members of these groups frequently maintain roadblocks and may use violence towards travelers. U.S. government employees may not travel to the entire state of Guerrero, including Acapulco, Zihuatanejo, Ixtapa, and Taxco.

Visit our website for Travel to High-Risk Areas.

Hidalgo state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

There are no restrictions on travel for U.S. government employees.

Jalisco state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Violent crime and gang activity are common in parts of Jalisco state. In metropolitan Guadalajara, turf battles between criminal groups are taking place in areas frequented by U.S. citizens. Shooting incidents between criminal groups have injured or killed innocent bystanders.

U.S. government employees may not travel to:

There are no restrictions on travel for U.S government employees to: Guadalajara Metropolitan Area, Riviera Nayarit (including Puerto Vallarta), Chapala, and Ajijic.

Visit our website for Travel to High-Risk Areas.

Mexico City – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

Both violent and non-violent crime is prevalent in Mexico City. Mexican government statistics indicate criminal incidents in the capital city occur at a significantly higher rate than much of the rest of Mexico. Pay particular caution to areas outside of the frequented tourist areas, although petty crime occurs frequently in tourist areas as well. Neighborhoods such as Tepito and Guerrero warrant additional vigilance, especially at night.

There are no restrictions on travel for U.S. government employees.

Michoacán state – Level 4: Do Not Travel

Do not travel due to crime.

Travel for U.S. government employees is limited to the following areas with the noted restrictions:

Visit our website for Travel to High-Risk Areas.

Morelos state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Violent crime and gang activity are common in parts of Morelos state.

There are no restrictions on travel for U.S. government employees.

Visit our website for Travel to High-Risk Areas.

Nayarit state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Violent crime and gang activity are common in parts of Nayarit state. U.S. government employees may not travel to:

There are no restrictions on travel for U.S government employees to: Riviera Nayarit (including Nuevo Vallarta and Bahia de Banderas) and Santa Maria del Oro.

Visit our website for Travel to High-Risk Areas.

Nuevo Leon state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Violent crime and gang activity are common in parts of Nuevo Leon state.

U.S. government employees in Monterrey must stay within the San Pedro Garza Garcia municipality, south of the Santa Catarina River, between 1:00 a.m. and 6:00 a.m., except for direct travel to and from the airport.

There are no additional restrictions on travel for U.S. government employees.

Visit our website for Travel to High-Risk Areas.

Oaxaca state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

U.S. government employees may not travel to:

There are no restrictions on travel for U.S. government employees to other parts of Oaxaca state, which include tourist areas in: Oaxaca City, Monte Alban, Puerto Escondido, and Huatulco.

Puebla state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

Gang-related violence is often linked to the widespread theft of petroleum and natural gas from the state oil company and other suppliers.

There are no restrictions on travel for U.S. government employees.

Queretaro state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

There are no restrictions on travel for U.S. government employees.

Quintana Roo state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

Criminal activity and violence, including homicide, remain a primary concern throughout the state. While most of these homicides appeared to be targeted, criminal organization assassinations and turf battles between criminal groups have resulted in violent crime in areas frequented by U.S. citizens. Bystanders have been injured or killed in shooting incidents.

There are no restrictions on travel for U.S. government employees in Quintana Roo state, which include tourist areas in: Cancun, Cozumel, Playa del Carmen, Tulum, and the Riviera Maya.

San Luis Potosi state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Violent crime and gang activity are common in parts of San Luis Potosi state.

There are no restrictions on travel for U.S. government employees.

Visit our website for Travel to High-Risk Areas.

Sinaloa state – Level 4: Do Not Travel

Do not travel due to crime.

Violent crime is widespread. Criminal organizations are based and operating in Sinaloa state.

Travel for U.S. government employees is limited to the following areas with the noted restrictions:

Visit our website for Travel to High-Risk Areas.

Sonora state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Sonora is a key location used by the international drug trade and human trafficking networks. However, northern Sonora experiences much lower levels of crime than cities closer to Sinaloa and other parts of Mexico.

U.S. government employees may not travel to:

In addition, U.S. government employees may not use taxi services in Nogales.

U.S. government employees may travel between the Nogales border crossing points of DeConcini and Mariposa in Nogales to and from the Hermosillo Consulate during the day only on Highway 15D. U.S. government employees may stop in the towns of Santa Ana and Imuris and at restaurant/restroom facilities located along the highway.

U.S. government employees may travel to Puerto Peñasco via the Lukeville/Sonoyta crossing during daylight hours on Federal Highway 8, or by using Federal Highway 15 south from Nogales and east via Federal Highway 2 and State Highway 37 through Caborca during daylight hours. U.S. government employees may also travel directly from the nearest U.S. Ports of Entry to San Luis Rio Colorado, Cananea, and Agua Prieta, but may not go beyond the city limits.

Visit our website for Travel to High-Risk Areas.

Tabasco state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

There are no travel restrictions on travel for U.S. government employees.

Tamaulipas state – Level 4: Do Not Travel

Do not travel due to crime.

Violent crime, such as murder, armed robbery, carjacking, kidnapping, extortion, and sexual assault, is common. Gang activity, including gun battles and blockades, is widespread. Armed criminal groups target public and private passenger buses as well as private automobiles traveling through Tamaulipas, often taking passengers hostage and demanding ransom payments. Federal and state security forces have limited capability to respond to violence in many parts of the state.

U.S. government employees may only travel within a limited radius between the U.S. Consulates in Nuevo Laredo and Matamoros and their respective U.S. Ports of Entry. U.S. government employees may not travel between cities in Tamaulipas using interior Mexican highways and they must observe a curfew between midnight and 6:00 a.m. in the cities of Matamoros and Nuevo Laredo.

Visit our website for Travel to High-Risk Areas.

Tlaxcala state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

There are no travel restrictions on travel for U.S. government employees.

Veracruz state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

There are no restrictions on travel for U.S. government employees.

Yucatan state – Level 2: Exercise Increased Caution

Exercise increased caution due to crime.

There are no restrictions on travel for U.S. government employees in Yucatan state, which includes tourist areas in: Chichen Itza, Merida, Uxmal, and Valladolid.

Zacatecas state – Level 3: Reconsider Travel

Reconsider travel due to crime.

Violent crime and gang activity are common in parts of Zacatecas state.

There are no restrictions on travel for U.S. government employees.

Visit our website for Travel to High-Risk Areas.

Mexico 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 /trv_rd.cfm
Time Stamp 03-Jun-20 04:14 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.69
Host Name 173.245.54.69


Execution Time

Total Time Avg Time Count Template
82 ms 82 ms 1 top level /home/www/html/trv_rd.cfm
40 ms 40 ms 1 /home/www/html/navsidesbottom_rdesign4.cfm
39 ms 39 ms 1 /home/www/html/navtop_rdesign4.cfm
38 ms 38 ms 1 /home/www/html/navpropertybox_interim_main_new.cfm
38 ms 38 ms 1 /home/www/html/navrightmidcolumn_rdesign4.cfm
11 ms 11 ms 1 /home/www/html/leftnav_rdesign4.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navtower_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/bottommobilenav_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/boolsearch.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign4.cfm
0 ms 0 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 6 /home/www/html/rewritearticle.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
88 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 @ 16:14:06.006
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 16:14:06.006
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/trv_rd.cfm @ 16:14:06.006
	Select *
	From articles
	Where articleID = 5150 
UpdateImpressions (Datasource=expert, Time=2ms, Records=1) in /home/www/html/trv_rd.cfm @ 16:14:06.006
  UPDATE articles
  SET impressions = impressions + 1
	Where articleID = 5150 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 16:14:06.006
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 16:14:06.006
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getcities (Datasource=expert, Time=1ms, Records=21) in /home/www/html/navmeta_rdesign4.cfm @ 16:14:06.006
	Select *
	From citynetworks
	Where networkID = 77
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 16:14:06.006
  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
checklog (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign4.cfm @ 16:14:06.006
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.69'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-03 23:59:59.999"
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:14:06.006
	SELECT *
	From contentcountcountry
	Where networkid = 77 
getmovingintro (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:14:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '1'
    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-03"

    ORDER by articles.articleID asc   
    
gettentips (Datasource=expert, Time=7ms, Records=2) in /home/www/html/navtop_rdesign4.cfm @ 16:14:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%10%') OR (author LIKE '%10%') OR (hitopic LIKE '%10%') OR (hidescript LIKE '%10%')) AND ((title LIKE '%Tips%') OR (author LIKE '%Tips%') OR (hitopic LIKE '%Tips%') OR (hidescript LIKE '%Tips%')) AND ((title LIKE '%for%') OR (author LIKE '%for%') OR (hitopic LIKE '%for%') OR (hidescript LIKE '%for%')) AND ((title LIKE '%Living%') OR (author LIKE '%Living%') OR (hitopic LIKE '%Living%') OR (hidescript LIKE '%Living%')) AND ((title LIKE '%in%') OR (author LIKE '%in%') OR (hitopic LIKE '%in%') OR (hidescript LIKE '%in%')) AND ((title LIKE '%Mexico%') OR (author LIKE '%Mexico%') OR (hitopic LIKE '%Mexico%') OR (hidescript LIKE '%Mexico%')))
	and articlePlacement.networkID = 77 
	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 summary <> ''
    and publishdate < "2020-06-03"
    ORDER by articles.articleID asc
gethealthintro (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:14:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '9'
    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   
    
getmovingintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navtop_rdesign4.cfm @ 16:14:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '1'
    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-03"

    ORDER by articles.articleID asc   
    
gettentips (Datasource=expert, Time=5ms, Records=2) in /home/www/html/leftnav_rdesign4.cfm @ 16:14:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%10%') OR (author LIKE '%10%') OR (hitopic LIKE '%10%') OR (hidescript LIKE '%10%')) AND ((title LIKE '%Tips%') OR (author LIKE '%Tips%') OR (hitopic LIKE '%Tips%') OR (hidescript LIKE '%Tips%')) AND ((title LIKE '%for%') OR (author LIKE '%for%') OR (hitopic LIKE '%for%') OR (hidescript LIKE '%for%')) AND ((title LIKE '%Living%') OR (author LIKE '%Living%') OR (hitopic LIKE '%Living%') OR (hidescript LIKE '%Living%')) AND ((title LIKE '%in%') OR (author LIKE '%in%') OR (hitopic LIKE '%in%') OR (hidescript LIKE '%in%')) AND ((title LIKE '%Mexico%') OR (author LIKE '%Mexico%') OR (hitopic LIKE '%Mexico%') OR (hidescript LIKE '%Mexico%')))
	and articlePlacement.networkID = 77 
	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 summary <> ''
    and publishdate < "2020-06-03"
    ORDER by articles.articleID desc
checkhealthintro (Datasource=expert, Time=0ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 16:14:06.006
	Select hcsectionintro
	From contentcountcountry
	where networkid = 77 
	and hcsectionintro <> 0
contentcount (Datasource=expert, Time=1ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 16:14:06.006
	Select *
	From contentcountcountry
	where networkid = 77 
gethealthintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/leftnav_rdesign4.cfm @ 16:14:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '9'
    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   
    
gettower (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navtower_rdesign4.cfm @ 16:14:06.006
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eesubtower"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navtower_rdesign4.cfm @ 16:14:06.006
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 864 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign4.cfm @ 16:14:06.006
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign4.cfm @ 16:14:06.006
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign4.cfm @ 16:14:06.006
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getpropertyslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:14:06.006
SELECT *
FROM topics
WHERE topicid = 6
getclass (Datasource=tipripper, Time=23ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:14:06.006
	SELECT DISTINCT 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 = 77
	AND "2020-06-03" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
getprice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:14:06.006
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80508'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:14:06.006
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80508'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:14:06.006
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80508'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:14:06.006
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:14:06.006
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80508'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:14:06.006
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80508'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:14:06.006
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80508'
AND answersmc.qoid = qoptions.qoid
gettentips (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/bottommobilenav_rdesign4.cfm @ 16:14:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%10%') OR (author LIKE '%10%') OR (hitopic LIKE '%10%') OR (hidescript LIKE '%10%')) AND ((title LIKE '%Tips%') OR (author LIKE '%Tips%') OR (hitopic LIKE '%Tips%') OR (hidescript LIKE '%Tips%')) AND ((title LIKE '%for%') OR (author LIKE '%for%') OR (hitopic LIKE '%for%') OR (hidescript LIKE '%for%')) AND ((title LIKE '%Living%') OR (author LIKE '%Living%') OR (hitopic LIKE '%Living%') OR (hidescript LIKE '%Living%')) AND ((title LIKE '%in%') OR (author LIKE '%in%') OR (hitopic LIKE '%in%') OR (hidescript LIKE '%in%')) AND ((title LIKE '%Mexico%') OR (author LIKE '%Mexico%') OR (hitopic LIKE '%Mexico%') OR (hidescript LIKE '%Mexico%')))
	and articlePlacement.networkID = 77 
	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 summary <> ''
    and publishdate < "2020-06-03"
    ORDER by articles.articleID asc
checkhealthintro (Datasource=expert, Time=0ms, Records=1) in /home/www/html/bottommobilenav_rdesign4.cfm @ 16:14:06.006
	Select hcsectionintro
	From contentcountcountry
	where networkid = 77 
	and hcsectionintro <> 0
gethealthintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/bottommobilenav_rdesign4.cfm @ 16:14:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '9'
    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   
    


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/trv_rd.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/trv_rd.cfm
QUERY_STRING=articleid=5150&networkid=77
REMOTE_ADDR=173.245.54.69
REMOTE_HOST=173.245.54.69
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/trv_rd.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=28948536
cftoken=20650660
sessionid=IBEXPATEXCHANGE.COM_28948536_20650660
urltoken=CFID=28948536&CFTOKEN=20650660
URL Parameters:
articleid=5150
networkid=77
Debug Rendering Time: 9 ms