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 Alert

Issued by US Department of State

Aug 20, 2009

The Department of State has issued this Travel Alert to update security information for U.S. citizens traveling to and living in Mexico. It supersedes the Travel Alert for Mexico dated February 20, 2009, and expires on February 20, 2010.

While millions of U.S. citizens safely visit Mexico each year (including tens of thousands who cross the land border every day for study, tourism or business), violence in the country has increased. It is imperative that travelers understand the risks of travel to Mexico, how best to avoid dangerous situations, and who to contact if one becomes a crime victim. Common-sense precautions such as visiting only legitimate business and tourist areas during daylight hours, and avoiding areas where prostitution and drug dealing might occur, can help ensure that travel to Mexico is safe and enjoyable.

Recent violent attacks have caused the U.S. Embassy to urge U.S. citizens to delay unnecessary travel to parts of Michoacán and Chihuahua (see details below) and advise U.S. citizens residing or traveling in those areas to exercise extreme caution. Drug cartels and associated criminal elements have retaliated violently against individuals who speak out against them or whom they otherwise view to be a threat to their organization, regardless of the individuals’ citizenship. These attacks include the abduction and murder of two resident U.S. citizens in Chihuahua in July, 2009.

Violence Along the U.S. - Mexico Border

Mexican drug cartels are engaged in violent conflict - both among themselves and with Mexican security services - for control of narcotics trafficking routes along the U.S.-Mexico border. In order to combat violence, the government of Mexico has deployed military troops in various parts of the country. U.S. citizens should cooperate fully with official checkpoints when traveling on Mexican highways.

Some recent Mexican army and police confrontations with drug cartels have resembled small-unit combat, with cartels employing automatic weapons and grenades. Large firefights have taken place in towns and cities across Mexico, but occur mostly in northern Mexico, including Tijuana, Chihuahua City, Monterrey and Ciudad Juarez. During some of these incidents, U.S. citizens have been trapped and temporarily prevented from leaving the area. The U.S. Mission in Mexico currently restricts non-essential travel within the state of Durango, the northwest quadrant of Chihuahua and an area southeast of Ciudad Juarez, and all parts of the state of Coahuila south of Mexican Highways 25 and 22 and the Alamos River for US Government employees assigned to Mexico. This restriction was implemented in light of the recent increase in assaults, murders, and kidnappings in those three states. The situation in northern Mexico remains fluid; the location and timing of future armed engagements cannot be predicted.

A number of areas along the border are experiencing rapid growth in the rates of many types of crime. Robberies, homicides, petty thefts, and carjackings have all increased over the last year across Mexico generally, with notable spikes in Tijuana and northern Baja California. Ciudad Juarez, Tijuana and Nogales are among the cities which have experienced public shootouts during daylight hours in shopping centers and other public venues. Criminals have followed and harassed U.S. citizens traveling in their vehicles in border areas including Nuevo Laredo, Matamoros, and Tijuana.

The situation in the state of Chihuahua including Ciudad Juarez is of special concern. The U.S. Consulate General recommends that American citizens defer non-essential travel to the Guadalupe Bravo area southeast of Ciudad Juarez and to the northwest quarter of the state of Chihuahua including the city of Nuevo Casas Grandes and surrounding communities. From the United States, these areas are often reached through the Columbus, NM and Fabens and Fort Hancock, TX ports-of-entry. In both areas, American citizens have been victims of drug related violence.

Mexican authorities report that more than 1,000 people have been killed in Ciudad Juarez in the first six-months of 2009. Additionally, this city of 1.6 million people experienced more than 17,000 car thefts and 1,650 carjackings in 2008. U.S. citizens should pay close attention to their surroundings while traveling in Ciudad Juarez, avoid isolated locations during late night and early morning hours, and remain alert to news reports. Visa and other service seekers visiting the Consulate are encouraged to make arrangements to pay for those services using a non-cash method.

U.S. citizens are urged to be alert to safety and security concerns when visiting the border region. Criminals are armed with a wide array of sophisticated weapons. In some cases, assailants have worn full or partial police or military uniforms and have used vehicles that resemble police vehicles. While most crime victims are Mexican citizens, the uncertain security situation poses serious risks for U.S. citizens as well. U.S. citizen victims of crime in Mexico are urged to contact the consular section of the nearest U.S. consulate or Embassy for advice and assistance. Contact information is provided at the end of this message.

Crime and Violence Throughout Mexico

Although the greatest increase in violence has occurred on the Mexican side of the U.S. border, U.S. citizens traveling throughout Mexico should exercise caution in unfamiliar areas and be aware of their surroundings at all times. Bystanders have been injured or killed in violent attacks in cities across the country, demonstrating the heightened risk of violence in public places. In recent years, dozens of U.S. citizens living in Mexico have been kidnapped and most of their cases remain unsolved. U.S. citizens who believe they are being targeted for kidnapping or other crimes should notify Mexican officials, the U.S. Embassy in Mexico City, or the nearest American Consulate as soon as possible. Any U.S. visitor who suspects they are a target should consider returning to the United States immediately.

U.S. citizens should make every attempt to travel on main roads during daylight hours, particularly the toll ("cuota") roads, which generally are more secure. When warranted, the U.S. Embassy and consulates advise their employees as well as private U.S. citizens to avoid certain areas, abstain from driving on certain roads because of dangerous conditions or criminal activity, or recommend driving during daylight hours only. When this happens, the Embassy or the affected consulate will alert the local U.S. citizen Warden network and post the information on their respective websites, indicating the nature of the concern and the expected time period for which the restriction will remain in place.

U.S. citizen visitors are encouraged to stay in the well-known tourist areas. Travelers should leave their itinerary with a friend or family member not traveling with them, avoid traveling alone, and check with their cellular provider prior to departure to confirm that their cell phone is capable of roaming on GSM or 3G international networks. Do not display expensive-looking jewelry, large amounts of money, or other valuable items.

Demonstrations and Large Public Gatherings

Demonstrations occur frequently throughout Mexico and usually are peaceful. However, even demonstrations intended to be peaceful can turn confrontational and escalate to violence unexpectedly. Violent demonstrations have resulted in deaths, including that of an American citizen in Oaxaca in 2006. In 2008, a Mexican Independence Day celebration was the target of a violent attack. During demonstrations or law enforcement operations, U.S. citizens are advised to remain in their homes or hotels, avoid large crowds, and avoid the downtown and surrounding areas. Since the timing and routes of scheduled marches and demonstrations are always subject to change, U.S. citizens should monitor local media sources for new developments and exercise extreme caution while within the vicinity of protests.

The Mexican Constitution prohibits political activities by foreigners, and such actions may result in detention and/or deportation. U.S. citizens are therefore advised to avoid participating in demonstrations or other activities that might be deemed political by Mexican authorities. As is always the case in any large gathering, U.S. citizens should remain alert to their surroundings.

Further Information

For more detailed information on staying safe in Mexico, please see the Mexico Country Specific Information. Information on security and travel to popular tourist destinations is also provided in the publication: "Spring Break in Mexico- Know Before You Go!!"

For the latest security information, U.S. citizens traveling abroad should regularly monitor the Department's internet web site at http://travel.state.gov/ where the current Worldwide Caution, Travel Warnings, and Travel Alerts can be found. Up-to-date information on security can also be obtained by calling 1-888-407-4747 toll free in the United States and Canada, or, for callers from Mexico, a regular toll line at 001-202-501-4444. These numbers are available from 8:00 a.m. to 8:00 p.m. Eastern Time, Monday through Friday (except U.S. federal holidays). American citizens traveling or residing overseas are encouraged to register with the appropriate U.S. Embassy or Consulate on the State Department's travel registration website at https://travelregistration.state.gov/.

For any emergencies involving U.S. citizens in Mexico, please contact the U.S. Embassy or the closest U.S. Consulate. The U.S. Embassy is located in Mexico City at Paseo de la Reforma 305, Colonia Cuauhtemoc, telephone from the United States: 011-52-55-5080-2000; telephone within Mexico City: 5080-2000; telephone long distance within Mexico 01-55-5080-2000. You may also contact the Embassy by e-mail at: The Embassy's internet address is http://www.usembassy-mexico.gov/.

Consulates:

Ciudad Juarez: Paseo de la Victoria 3650, tel. (52)(656) 227-3000. http://ciudadjuarez.usconsulate.gov/.

Guadalajara: Progreso 175, telephone (52)(333) 268-2100. http://guadalajara.usconsulate.gov/.

Hermosillo: Avenida Monterrey 141, telephone (52)(662) 289-3500. http://hermosillo.usconsulate.gov/.

Matamoros: Avenida Primera 2002, telephone (52)(868) 812-4402. http://matamoros.usconsulate.gov/.

Merida: Calle 60 no. 338-K x 29 y 31, Col. Alcala Martin, Merida, Yucatan, Mexico 97050, telephone (52)(999) 942-5700 or 202-250-3711 (U.S. number). http://merida.usconsulate.gov/.

Monterrey: Avenida Constitucion 411 Poniente, telephone (52)(818) 047-3100. http://monterrey.usconsulate.gov/.

Nogales: Calle San Jose, Nogales, Sonora, telephone (52)(631) 311-8150. http://nogales.usconsulate.gov/.

Nuevo Laredo: Calle Allende 3330, col. Jardin, telephone (52)(867) 714-0512. http://nuevolaredo.usconsulate.gov/.

Tijuana: Tapachula 96, telephone (52)(664) 622-7400. http://tijuana.usconsulate.gov/service.html.

Consular Agencies:

Acapulco: Hotel Continental Emporio, Costera Miguel Aleman 121 - local 14, telephone (52)(744) 484-0300 or (52)(744) 469-0556.

Cabo San Lucas: Blvd. Marina local c-4, Plaza Nautica, col. Centro, telephone (52)(624) 143-3566.

Cancún: Plaza Caracol two, second level, no. 320-323, Boulevard Kukulcan, km. 8.5, Zona Hotelera, telephone (52)(998) 883-0272 or, from the U.S., 202-640-2511.

Ciudad Acuña: Closed until further notice.

Cozumel: Plaza Villa Mar en el Centro, Plaza Principal, (Parque Juárez between Melgar and 5th ave.) 2nd floor, locales #8 and 9, telephone (52)(987) 872-4574 or, from the U.S., 202-459-4661.

Ixtapa/Zihuatanejo: Hotel Fontan, Blvd. Ixtapa, telephone (52)(755) 553-2100.

Mazatlán: Playa Gaviotas #202, Zona Dorada, telephone (52)(669) 916-5889.

Oaxaca: Macedonio Alcalá no. 407, interior 20, telephone (52)(951) 514-3054 (52)(951) 516-2853.

Piedras Negras: Abasolo #211, Zona Centro, Piedras Negras, Coah., Tel. (878) 782-5586.

Playa del Carmen: "The Palapa," Calle 1 Sur, between Avenida 15 and Avenida 20, telephone (52)(984) 873-0303 or, from the U.S., 202-370-6708.

Puerto Vallarta: Paradise Plaza, Paseo de los Cocoteros #1, Local #4, Interior #17, Nuevo Vallarta, Nayarit, telephone (52)(322) 222-0069.

Reynosa: Calle Monterrey #390, Esq. Sinaloa, Colonia Rodríguez, telephone: (52)(899) 923 - 9331.

San Luis Potosí: Edificio "Las Terrazas", Avenida Venustiano Carranza 2076-41, Col. Polanco, telephone: (52)(444) 811-7802/7803.

San Miguel de Allende: Dr. Hernandez Macias #72, telephone (52)(415) 152-2357 or (52)(415) 152-0068.

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 01-Jun-20 04:12 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.46
Host Name 172.69.62.46


Execution Time

Total Time Avg Time Count Template
80 ms 80 ms 1 top level /home/www/html/trv_rd.cfm
40 ms 40 ms 1 /home/www/html/navsidesbottom_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
37 ms 37 ms 1 /home/www/html/navtop_rdesign4.cfm
12 ms 12 ms 1 /home/www/html/leftnav_rdesign4.cfm
5 ms 5 ms 1 /home/www/html/navtower_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
2 ms 2 ms 1 /home/www/html/bottommobilenav_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 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
85 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:12:39.039
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 16:12:39.039
      	  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:12:39.039
	Select *
	From articles
	Where articleID = 3425 
UpdateImpressions (Datasource=expert, Time=1ms, Records=1) in /home/www/html/trv_rd.cfm @ 16:12:39.039
  UPDATE articles
  SET impressions = impressions + 1
	Where articleID = 3425 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 16:12:39.039
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 16:12:39.039
	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:12:39.039
	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:12:39.039
  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:12:39.039
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-06-01 00:00:00.000"
and logtime < "2020-06-01 23:59:59.999"
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:12:39.039
	SELECT *
	From contentcountcountry
	Where networkid = 77 
getmovingintro (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:12:39.039
	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-01"

    ORDER by articles.articleID asc   
    
gettentips (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navtop_rdesign4.cfm @ 16:12:39.039
	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-01"
    ORDER by articles.articleID asc
gethealthintro (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:12:39.039
	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-01"

    ORDER by articles.articleID asc   
    
getmovingintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navtop_rdesign4.cfm @ 16:12:39.039
	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-01"

    ORDER by articles.articleID asc   
    
gettentips (Datasource=expert, Time=5ms, Records=2) in /home/www/html/leftnav_rdesign4.cfm @ 16:12:39.039
	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-01"
    ORDER by articles.articleID desc
checkhealthintro (Datasource=expert, Time=0ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 16:12:39.039
	Select hcsectionintro
	From contentcountcountry
	where networkid = 77 
	and hcsectionintro <> 0
contentcount (Datasource=expert, Time=0ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 16:12:39.039
	Select *
	From contentcountcountry
	where networkid = 77 
gethealthintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/leftnav_rdesign4.cfm @ 16:12:39.039
	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-01"

    ORDER by articles.articleID asc   
    
gettower (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navtower_rdesign4.cfm @ 16:12:39.039
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eesubtower"
    and toDate > "2020-05-31"
    and fromDate < "2020-06-01"
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navtower_rdesign4.cfm @ 16:12:39.039
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 864 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign4.cfm @ 16:12:39.039
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-31"
    and fromDate < "2020-06-01"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign4.cfm @ 16:12:39.039
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getpropertyslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:12:39.039
SELECT *
FROM topics
WHERE topicid = 6
getclass (Datasource=tipripper, Time=23ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:12:39.039
	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-01" < 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:12:39.039
	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:12:39.039
	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:12:39.039
	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:12:39.039
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:12:39.039
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:12:39.039
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=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:12:39.039
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:12:39.039
	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-01"
    ORDER by articles.articleID asc
checkhealthintro (Datasource=expert, Time=0ms, Records=1) in /home/www/html/bottommobilenav_rdesign4.cfm @ 16:12:39.039
	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:12:39.039
	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-01"

    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=3425&networkid=77
REMOTE_ADDR=172.69.62.46
REMOTE_HOST=172.69.62.46
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=28830928
cftoken=31531858
sessionid=IBEXPATEXCHANGE.COM_28830928_31531858
urltoken=CFID=28830928&CFTOKEN=31531858
URL Parameters:
articleid=3425
networkid=77
Debug Rendering Time: 9 ms