GLOBALDIT Y SU FILIAL MEXICANA IDT ES UNA EMPRESA INTERNACIONAL DE ASESORAMIENTO EXPERTO EN EL SECTOR VIAJES, TURISMO Y OCIO. SOMOS UNA FIRMA DE REFERENCIA PARA PROYECTOS DE DESARROLLO INCLUSIVO Y TECNOLOGÍAS APLICADAS AL TURISMO. EN NUESTRO NEW BOOK 2019 TE CONTAMOS CÓMO TRABAJAMOS.
BOOK 2020Aceptar
session.client.forwarded ⇒ 18.97.14.82
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
session.token ⇒ 6b8ffd960c659527fdfc019b88e9f6ce
Application 0.000 seconds (+0.000); 0.34 MB (+0.339) - afterLoadApplication 0.058 seconds (+0.057); 1.54 MB (+1.199) - afterInitialiseApplication 0.064 seconds (+0.006); 1.85 MB (+0.315) - afterRouteApplication 0.188 seconds (+0.124); 4.02 MB (+2.167) - beforeRenderModule mod_compartir (Compartir)Application 0.189 seconds (+0.001); 4.03 MB (+0.009) - afterRenderModule mod_compartir (Compartir)Application 0.192 seconds (+0.003); 4.06 MB (+0.035) - afterDispatchApplication 0.198 seconds (+0.005); 4.14 MB (+0.078) - beforeRenderModule mod_zooitem (Microsites (zona innovación))Application 0.245 seconds (+0.047); 4.88 MB (+0.739) - afterRenderModule mod_zooitem (Microsites (zona innovación))Application 0.245 seconds (+0.001); 4.82 MB (-0.061) - beforeRenderModule mod_compartir (Compartir)Application 0.246 seconds (+0.000); 4.82 MB (+0.004) - afterRenderModule mod_compartir (Compartir)Application 0.247 seconds (+0.001); 4.85 MB (+0.028) - beforeRenderModule mod_search (Buscador (header))Application 0.248 seconds (+0.001); 4.87 MB (+0.017) - afterRenderModule mod_search (Buscador (header))Application 0.248 seconds (+0.000); 4.84 MB (-0.029) - beforeRenderModule mod_contact (Contacto)Application 0.288 seconds (+0.040); 6.02 MB (+1.178) - afterRenderModule mod_contact (Contacto)Application 0.293 seconds (+0.005); 6.05 MB (+0.031) - afterRender6.07 MB (6,368,744 Bytes)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.lftSELECT *
FROM d4xh9_zoo_category
WHERE id = 50SELECT joomlatablename,tablepkID
FROM `d4xh9_falang_tableinfo`SELECT *
FROM d4xh9_languages
ORDER BY orderingSHOW 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(50)
AND falang_content.reference_table='zoo_category'SHOW FULL COLUMNS
FROM `d4xh9_content`SELECT a.rules
FROM d4xh9_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSHOW FULL COLUMNS
FROM `d4xh9_assets`SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT 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.lftSELECT a.*
FROM d4xh9_zoo_item AS a
LEFT JOIN d4xh9_zoo_category_item AS b
ON a.id = b.item_id
WHERE a.application_id = 24
AND b.category_id = 50
AND access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-17 11:34:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-17 11:34:15')
GROUP BY a.id
ORDER BY a.priority DESC, a.nameSELECT 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(1716,1717,1718,1722,1719,1720,1721)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_application
WHERE id = 24SELECT 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(24)
AND falang_content.reference_table='zoo_application'SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Artículo-Proyecto'
AND item1 = 1716SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (983, 978)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-01-17 11:34:15')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-17 11:34:15')
ORDER BY FIELD(id,983, 978)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(983,978)
AND falang_content.reference_table='zoo_item'SELECT *
FROM d4xh9_zoo_application
WHERE id = 14SELECT 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 *
FROM d4xh9_zoo_category
WHERE application_id = 14
AND published = 1
ORDER BY orderingSELECT 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'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=983
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=983
AND a.category_id = 0SELECT 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=978
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=978
AND a.category_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Artículo-Proyecto'
AND item1 = 1717SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (983, 1353, 967, 1727)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-01-17 11:34:15')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-17 11:34:15')
ORDER BY FIELD(id,983, 1353, 967, 1727)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(983,1353,967,1727)
AND falang_content.reference_table='zoo_item'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=1727
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1727
AND a.category_id = 0SELECT 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=967
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=967
AND a.category_id = 0SELECT 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=1353
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1353
AND a.category_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Artículo-Proyecto'
AND item1 = 1718SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (978, 1726, 1353, 1761)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-01-17 11:34:15')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-17 11:34:15')
ORDER BY FIELD(id,978, 1726, 1353, 1761)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(978,1726,1353,1761)
AND falang_content.reference_table='zoo_item'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=1726
AND b.published = 1 UNION SELECT 0
FROM d4xh9_zoo_category_item AS a
WHERE a.item_id=1726
AND a.category_id = 0SELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Artículo-Proyecto'
AND item1 = 1722SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
FROM d4xh9_zoo_item
WHERE id IN (983, 978, 967, 1761)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-01-17 11:34:15')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-17 11:34:15')
ORDER BY FIELD(id,983, 978, 967, 1761)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(983,978,967,1761)
AND falang_content.reference_table='zoo_item'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM d4xh9_modules AS m
LEFT JOIN d4xh9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN d4xh9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-01-17 11:34:15')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-17 11:34:15')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 167 OR mm.menuid <= 0)
AND m.language IN ('es-ES','*')
ORDER BY m.position, m.orderingSELECT *
FROM d4xh9_zoo_application
WHERE id = 23SELECT 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 = 0SELECT 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 <= '2025-01-17 11:34:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-17 11:34:15')
GROUP BY a.id
ORDER BY a.priority DESC, a.name
LIMIT 0,5SELECT 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 = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT
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 <= '2025-01-17 11:34:15')
AND (zi.publish_down = '0000-00-00 00:00:00' OR zi.publish_down >= '2025-01-17 11:34:15')
AND zi.state =1
AND zi.application_id IN (26)
HAVING distance < 10
ORDER BY zi.priority DESC, zi.name ASC, zi.name ASCSELECT 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 = 1411SELECT 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 = 1412SELECT 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 = 1413SELECT 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 = 1800SELECT 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 = 26SELECT 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 = 1411SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
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 <= '2025-01-17 11:34:15')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-17 11:34:15')
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 = 16SELECT 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 orderingSELECT *
FROM d4xh9_zoo_items_relations
WHERE name = 'Sede-Contacto'
AND item1 = 1412SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
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 <= '2025-01-17 11:34:15')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-17 11:34:15')
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 = 1413SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
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 <= '2025-01-17 11:34:15')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-17 11:34:15')
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 = 1800SELECT id
FROM d4xh9_assets
WHERE parent_id = 0SELECT *
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 <= '2025-01-17 11:34:15')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-17 11:34:15')
ORDER BY FIELD(id,1089)58 × SELECT id
FROM d4xh9_assets21 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM d4xh9_falang_content AS falang_content12 × SELECT *
FROM d4xh9_zoo_item8 × SELECT *
FROM d4xh9_zoo_items_relations6 × SELECT b.id
FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b
ON a.category_id = b.id5 × SELECT *
FROM d4xh9_zoo_application3 × SELECT *
FROM d4xh9_zoo_category1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM d4xh9_modules AS m
LEFT JOIN d4xh9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN d4xh9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT a.*
FROM d4xh9_zoo_item AS a1 × 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 b.rules
FROM d4xh9_assets AS a
LEFT JOIN d4xh9_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT joomlatablename,tablepkID
FROM `d4xh9_falang_tableinfo1 × SELECT *
FROM d4xh9_languages1 × SELECT a.rules
FROM d4xh9_assets AS a1 × 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_id1 × SELECT a.*
FROM d4xh9_zoo_item AS a
LEFT JOIN d4xh9_zoo_category_item AS b
ON a.id = b.item_id1 × SHOW FULL COLUMNS
FROM `d4xh9_assets1 × SHOW FULL COLUMNS
FROM `d4xh9_content1 × SHOW FULL COLUMNS
FROM `d4xh9_languages