Cuando la marca es un tesoro

Estrategia 2030

El encargo

En los destinos coloniales del centro de México aparecieron pequeños establecimientos de hospedaje que, con la fórmula de hotel boutique, buscaban ofertar al mercado una experiencia singular en espacios únicos.

Asimismo, pequeños restaurantes abrieron sus puertas conforme los destinos se fueron consolidando. Michoacán fue el Estado pionero en buscar una estrategia que permitiera aglutinar las inversiones en comercialización y cualificación de este sector, clave para el posicionamiento del Estado como destino cultural.

Cliente

Secretaría de Turismo del Estado de Chiapas
Secretaría de Turismo del Estado de Puebla
Secretaria de Desarrollo Turístico del Estado de Guanajuato. SEDETUR
Secretaría de Turismo del Estado de Morelos
Secretaría de Turismo del Estado de Michoacán

País

México

Cómo lo hicimos

Proporcionamos a los estados un modelo de trabajo cuyo objetivo es ayudar a las Pymes turísticas a elevar y mantener altos niveles de calidad, mejorar la cualificación de los recursos humanos, fomentar el trabajo en red y poner en marcha políticas de marca y venta exitosas. A través del programa, las empresas participantes tienen acceso a capacitación y asistencia técnica, y se comprometen a llevar a cabo las acciones de mejora continua exigidas.

Cada año realizamos auditorías del Club y evaluamos el servicio mediante consumos anónimos. Diseñamos guías de prestigio y para el viajero, y hemos desarrollado los sitios Web específicos para cada estado, con centrales de reserva.

Aquí encontrarás algunos ejemplos de los Clubes que hemos puesto en marcha.

Especialidades

Targeting · Performance · Networking · Content & context · Analysis

El resultado

El Club de Calidad Tesoros de México nació como Club de Calidad Tesoros de Michoacán en 1999, y en los años siguientes la fórmula fue implantada con éxito en cuatro estados más: Guanajuato, Chiapas, Morelos y Puebla hasta 2012, cuando se cedió la marca y el programa a la SECTUR Federal.

Tesoros se convierte en una marca que representa la propuesta turística más singular y exclusiva para el viajero al corazón colonial del país, cuyos atributos incluyen el confort, el cosmopolitismo, la autenticidad y la elegancia. Estos establecimientos logran un efecto demostración sobre el resto de la oferta, impulsando con su ejemplo un incremento en los niveles de calidad y servicio en los destinos donde se implantan.

Construyendo el gran espacio turístico maya

Cuando las artes entablan conversación

Consola de Joomla! Debug

181 Registro Consultas

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM d4xh9_menu AS m LEFT JOIN d4xh9_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT id FROM d4xh9_zoo_item WHERE alias = 'cuando-la-marca-es-un-tesoro' LIMIT 1
SELECT joomlatablename,tablepkID FROM `d4xh9_falang_tableinfo`
SELECT * FROM d4xh9_languages ORDER BY ordering
SHOW FULL COLUMNS FROM `d4xh9_languages`
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1350) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1350
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1350) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_application WHERE id = 14
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(14) AND falang_content.reference_table='zoo_application'
SELECT a.rules FROM d4xh9_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SHOW FULL COLUMNS FROM `d4xh9_assets`
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT b.rules FROM d4xh9_assets AS a LEFT JOIN d4xh9_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.id = 1 OR a.parent_id=0) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT * FROM d4xh9_zoo_category WHERE application_id = 14 AND published = 1 ORDER BY ordering
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(54,53,56) AND falang_content.reference_table='zoo_category'
UPDATE d4xh9_zoo_item SET hits = (hits + 1) WHERE id = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Artículo-Proyecto' AND item2 = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SHOW FULL COLUMNS FROM `d4xh9_content`
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Proyecto-Cliente' AND item1 = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (918, 921, 928, 920, 923) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,918, 921, 928, 920, 923)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(918,921,928,920,923) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Proyecto-Cliente' AND item1 = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (918, 921, 928, 920, 923) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,918, 921, 928, 920, 923)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(918,921,928,920,923) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Proyecto-Cliente' AND item1 = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (918, 921, 928, 920, 923) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,918, 921, 928, 920, 923)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(918,921,928,920,923) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_application WHERE id = 15
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(15) AND falang_content.reference_table='zoo_application'
SELECT * FROM d4xh9_zoo_category WHERE application_id = 15 AND published = 1 ORDER BY ordering
SELECT * FROM d4xh9_zoo_category WHERE id = 14
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(14) AND falang_content.reference_table='zoo_category'
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=918 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=918 AND a.category_id = 0
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=921 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=921 AND a.category_id = 0
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=928 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=928 AND a.category_id = 0
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=920 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=920 AND a.category_id = 0
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=923 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=923 AND a.category_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Proyecto-Responsable' AND item1 = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Proyecto-Especialidad' AND item1 = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1399, 1403, 1404, 1402, 1398) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,1399, 1403, 1404, 1402, 1398)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1399,1403,1404,1402,1398) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Proyecto-Especialidad' AND item1 = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1399, 1403, 1404, 1402, 1398) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,1399, 1403, 1404, 1402, 1398)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1399,1403,1404,1402,1398) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Proyecto-Especialidad' AND item1 = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1399, 1403, 1404, 1402, 1398) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,1399, 1403, 1404, 1402, 1398)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1399,1403,1404,1402,1398) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_application WHERE id = 22
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(22) AND falang_content.reference_table='zoo_application'
SELECT * FROM d4xh9_zoo_category WHERE application_id = 22 AND published = 1 ORDER BY ordering
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=1399 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1399 AND a.category_id = 0
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=1403 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1403 AND a.category_id = 0
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=1404 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1404 AND a.category_id = 0
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=1402 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1402 AND a.category_id = 0
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=1398 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1398 AND a.category_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_category WHERE id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT ROWNUM FROM (SELECT @rownum:= @rownum+1 ROWNUM, id FROM (SELECT @rownum:=0) r, (SELECT id FROM d4xh9_zoo_item AS a WHERE a.application_id = 14 AND access IN (1) AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-04 07:10:28') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-04 07:10:28') AND a.highlight = 1 GROUP BY a.id ORDER BY a.priority DESC, a.name) t1) t2 WHERE id = 1350
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT ROWNUM, id FROM (SELECT @rownum:= @rownum+1 ROWNUM, id FROM (SELECT @rownum:=0) r, (SELECT id FROM d4xh9_zoo_item AS a WHERE a.application_id = 14 AND access IN (1) AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-04 07:10:28') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-04 07:10:28') AND a.highlight = 1 GROUP BY a.id ORDER BY a.priority DESC, a.name) t1) t2 WHERE ROWNUM = 14 OR ROWNUM = 16
SELECT * FROM d4xh9_zoo_item WHERE id = 1075
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1075) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1082
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1082) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id WHERE a.item_id=1075 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1075 AND a.category_id = 0
SELECT * FROM d4xh9_zoo_application WHERE id = 23
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(23) AND falang_content.reference_table='zoo_application'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT a.* FROM d4xh9_zoo_item AS a WHERE a.type = 'microsite' AND a.application_id = 23 AND access IN (1) AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-04 07:10:28') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-04 07:10:28') GROUP BY a.id ORDER BY a.priority DESC, a.name LIMIT 0,5
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1714,1405,1408,1406,1407) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT DISTINCT (zi.id) AS id, zi.name as name, zi.latitude as lat, zi.longitude as lng, zi.application_id as application_id, 0 AS distance FROM ( d4xh9_zoo_item zi ) WHERE (zi.publish_up = '0000-00-00 00:00:00' OR zi.publish_up <= '2024-12-04 07:10:28') AND (zi.publish_down = '0000-00-00 00:00:00' OR zi.publish_down >= '2024-12-04 07:10:28') AND zi.state =1 AND zi.application_id IN (26) HAVING distance < 10 ORDER BY zi.priority DESC, zi.name ASC, zi.name ASC
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1411,1412,1413,1800) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1411
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1411) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1412
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1412) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1413
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1413) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1800
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1800) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_application WHERE id = 26
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(26) AND falang_content.reference_table='zoo_application'
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Sede-Contacto' AND item1 = 1411
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1090) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,1090)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1090) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_application WHERE id = 16
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(16) AND falang_content.reference_table='zoo_application'
SELECT * FROM d4xh9_zoo_category WHERE application_id = 16 AND published = 1 ORDER BY ordering
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Sede-Contacto' AND item1 = 1412
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1091) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,1091)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1091) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Sede-Contacto' AND item1 = 1413
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1583) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,1583)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content WHERE falang_content.language_id=3 AND falang_content.published=1 AND falang_content.reference_id IN(1583) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Sede-Contacto' AND item1 = 1800
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1089) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-04 07:10:28') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-04 07:10:28') ORDER BY FIELD(id,1089)

21 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

88 × SELECT id FROM d4xh9_assets
27 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content
17 × SELECT * FROM d4xh9_zoo_item
12 × SELECT * FROM d4xh9_zoo_items_relations
11 × SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id
6 × SELECT * FROM d4xh9_zoo_category
6 × SELECT * FROM d4xh9_zoo_application
1 × SELECT DISTINCT (zi.id) AS id, zi.name as name, zi.latitude as lat, zi.longitude as lng, zi.application_id as application_id, 0 AS distance FROM ( d4xh9_zoo_item zi )
1 × SELECT a.* FROM d4xh9_zoo_item AS a
1 × SELECT ROWNUM FROM (SELECT @rownum:= @rownum+1 ROWNUM, id FROM (SELECT @rownum:=0) r, (SELECT id FROM d4xh9_zoo_item AS a
1 × SELECT ROWNUM, id FROM (SELECT @rownum:= @rownum+1 ROWNUM, id FROM (SELECT @rownum:=0) r, (SELECT id FROM d4xh9_zoo_item AS a
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM d4xh9_menu AS m LEFT JOIN d4xh9_extensions AS e ON m.component_id = e.extension_id
1 × SELECT joomlatablename,tablepkID FROM `d4xh9_falang_tableinfo
1 × SELECT * FROM d4xh9_languages
1 × SELECT a.rules FROM d4xh9_assets AS a
1 × SELECT id FROM d4xh9_zoo_item
1 × SELECT b.rules FROM d4xh9_assets AS a LEFT JOIN d4xh9_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt

OTRAS Tablas:

1 × SHOW FULL COLUMNS FROM `d4xh9_content
1 × UPDATE d4xh9_zoo_item SET hits = (hits + 1)
1 × SHOW FULL COLUMNS FROM `d4xh9_assets
1 × SHOW FULL COLUMNS FROM `d4xh9_languages

Laura Fandos

España

+ 34 963 354 900

Lupita Gómez

México

+52 (55) 52 64 06 96

Leo Villella

Argentina

+54 11 5254 2020

Estados Unidos

Marian Olmos

Cuestiones legales y administrativas

+ 34 963 354 901

Work

Una muestra de los 2.000+ proyectos para ilustrar cómo trabajamos con nuestros clientes.

Toolkit

Una colección de productos y servicios pensados para los gestores públicos y testados en destinos turísticos maduros e incipientes.

People

Soñadores pensando en drones, geeks construyendo algoritmos, canas aportando confianza.

Blog

Siempre hay una manera diferente de mirar la actualidad. Esta es nuestra perspectiva.

IDT

Operamos en México con nuestra filial IDT. Desde nuestras oficinas en La Condesa, Ciudad de México, gestionamos los proyectos en las Américas.

About us

Somos un equipo que opera para gobiernos y corporaciones de la industria de turismo y viajes.

Archive

2.000+ proyectos para 200+ clientes nos han enseñado mucho. La lección más importante es que cuanto más sabemos, más necesitamos seguir aprendiendo.

¿Te ayudamos? :)

Dile a nuestro 'bot' qué buscas...

¿Te gusta esta página? ¡Compártela!

A ellos seguro que también :)