Search

Meet Guatemala

Land where men, nature, and time have coincided and where they dwell together for ever. More than 3000 years ago a people endowed with extraordinary skills formed one of the most well known and most respected civilizations in history, the Maya

Know more

Destinations

Page 0 of 1, showing 0 records out of 0 total, starting on record 0, ending on 0

Id Name Description Created Modified Municipio Departamento Seo Actions
<< previous
|
next >>

Latest Tweets

the new website design is coming together, stay tuned for more information! http://bit.ly/cxgLO

We are now linked on Facebook and Twitter! Stay tuned for more information!!! http://bit.ly/anFVF

goGuate.com, where all colors meet. Visit us soon

Search

Let's Socialize! Facebook Twitter RSS

(default) 14 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `destinations`881
2DESCRIBE `municipios`221
3DESCRIBE `departamentos`220
4DESCRIBE `schools`771
5DESCRIBE `hotels`770
6DESCRIBE `restaurants`771
7DESCRIBE `dates`660
8DESCRIBE `packages`770
9DESCRIBE `operators`880
10DESCRIBE `destinations_packages`220
11DESCRIBE `activities`660
12DESCRIBE `activities_destinations`220
13SELECT COUNT(*) AS `count` FROM `destinations` AS `Destination` LEFT JOIN `municipios` AS `Municipio` ON (`Destination`.`municipio_id` = `Municipio`.`id`) LEFT JOIN `departamentos` AS `Departamento` ON (`Destination`.`departamento_id` = `Departamento`.`id`) WHERE 1 = 1 110
14SELECT `Destination`.`id`, `Destination`.`name`, `Destination`.`description`, `Destination`.`created`, `Destination`.`modified`, `Destination`.`municipio_id`, `Destination`.`departamento_id`, `Destination`.`seo`, `Municipio`.`id`, `Municipio`.`name`, `Departamento`.`id`, `Departamento`.`name` FROM `destinations` AS `Destination` LEFT JOIN `municipios` AS `Municipio` ON (`Destination`.`municipio_id` = `Municipio`.`id`) LEFT JOIN `departamentos` AS `Departamento` ON (`Destination`.`departamento_id` = `Departamento`.`id`) WHERE 1 = 1 ORDER BY `Destination`.`name` asc LIMIT 20000