John Mora

Partner & corporate venturing

The next big thing es la idea que preside su trabajo.

John idea y proyecta la visión de futuro de la firma. Siempre alerta a la rápida evolución de la industria, contagia su entusiasmo por las enormes posibilidades que la tecnología ofrece tanto a las marcas en la comunicación y conversación con los mercados como a los gobiernos al afrontar los retos que les impone la nueva sociedad.

John ejerce su liderazgo manteniendo a los equipos en permanente tensión hacia delante. En él convergen la visión de Tono Franco con la obsesión por los resultados de Ilde Mozas y el pensamiento abstracto de Laura Fandosy las mentes matemáticas de los programadores con la sensibilidad artística y la defensa de la interacción perfecta.

Siempre pendiente de los últimos desarrollos, John forja alianzas estratégicas con socios tecnológicos. Actualmente explora nuevas líneas de trabajo para futuros proyectos con Gerardo Roger y Nando Igual de écran.

John es muy visual y en su inseparable Moleskine ilustra cada idea. Interesado en emprendeduría, invierte en startups - la última, para fabricar drones. Nacido en la generación X y educado por boomers, se siente millennial, british de nacimiento y latino de espíritu. Viene a trabajar cada día en su Brompton.

j.mora@globaldit.com

Especialidades

Networking · Content & context · User Experience · Targeting · Analysis · Strategy · Performance · Engagement

Mati Valcárcel

Mavi Franco

Consola de Joomla! Debug

172 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 = 'john-mora' 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(1092) AND falang_content.reference_table='zoo_item'
SELECT id, home, template, s.params FROM d4xh9_template_styles as s LEFT JOIN d4xh9_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT * FROM d4xh9_zoo_item WHERE id = 1092
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(1092) 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 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 = 16 AND published = 1 ORDER BY ordering
UPDATE d4xh9_zoo_item SET hits = (hits + 1) WHERE id = 1092
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
SHOW FULL COLUMNS FROM `d4xh9_content`
SELECT * FROM d4xh9_zoo_item WHERE id = 1093
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(1093) 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=1093 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1093 AND a.category_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id = 1089
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(1089) 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=1089 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1089 AND a.category_id = 0
SELECT * FROM d4xh9_zoo_item WHERE 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_item WHERE id = 1580
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(1580) 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=1580 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1580 AND a.category_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id = 1581
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(1581) 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=1581 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1581 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 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_items_relations WHERE name = 'Persona-Especialidad' AND item1 = 1092
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1404, 1402, 1401, 1399, 1398, 1397, 1403, 1400) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-20 12:57:26') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 12:57:26') ORDER BY FIELD(id,1404, 1402, 1401, 1399, 1398, 1397, 1403, 1400)
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(1404,1402,1401,1399,1398,1397,1403,1400) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Persona-Especialidad' AND item1 = 1092
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1404, 1402, 1401, 1399, 1398, 1397, 1403, 1400) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-20 12:57:26') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 12:57:26') ORDER BY FIELD(id,1404, 1402, 1401, 1399, 1398, 1397, 1403, 1400)
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(1404,1402,1401,1399,1398,1397,1403,1400) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Persona-Especialidad' AND item1 = 1092
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1404, 1402, 1401, 1399, 1398, 1397, 1403, 1400) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-20 12:57:26') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 12:57:26') ORDER BY FIELD(id,1404, 1402, 1401, 1399, 1398, 1397, 1403, 1400)
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(1404,1402,1401,1399,1398,1397,1403,1400) 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=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=1401 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1401 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=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=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 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=1397 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1397 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=1400 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1400 AND a.category_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 LEFT JOIN d4xh9_zoo_category_item AS b ON a.id = b.item_id WHERE a.application_id = 16 AND b.category_id = 0 AND access IN (1) AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 12:57:26') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 12:57:26') GROUP BY a.id ORDER BY a.priority DESC, a.name) t1) t2 WHERE id = 1092
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 LEFT JOIN d4xh9_zoo_category_item AS b ON a.id = b.item_id WHERE a.application_id = 16 AND b.category_id = 0 AND access IN (1) AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 12:57:26') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 12:57:26') GROUP BY a.id ORDER BY a.priority DESC, a.name) t1) t2 WHERE ROWNUM = 1 OR ROWNUM = 3
SELECT * FROM d4xh9_zoo_item WHERE id = 1578
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(1578) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1575
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(1575) 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=1578 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1578 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=1575 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1575 AND a.category_id = 0
SELECT id, title, alias, link, level, parent_id, browserNav, type, params FROM d4xh9_menu WHERE published = 1 AND (access = 0 || access = 1) AND menutype = 'mainmenu' AND home=0 AND level >=1 AND level <=2 ORDER BY parent_id, lft
SELECT id, title, alias, link, level, parent_id, browserNav, type, params FROM d4xh9_menu WHERE published = 1 AND (access = 0 || access = 1) AND menutype = 'secondary-menu' AND home=0 AND level >=1 AND level <=2 ORDER BY parent_id, lft
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-04-20 12:57:26') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 12:57:26') 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-04-20 12:57:27') AND (zi.publish_down = '0000-00-00 00:00:00' OR zi.publish_down >= '2024-04-20 12:57:27') 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-04-20 12:57:26') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 12:57:26') 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_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-04-20 12:57:26') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 12:57:26') 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-04-20 12:57:26') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 12:57:26') 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-04-20 12:57:26') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 12:57:26') ORDER BY FIELD(id,1089)

23 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

83 × SELECT id FROM d4xh9_assets
25 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content
19 × SELECT * FROM d4xh9_zoo_item
14 × SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id
7 × SELECT * FROM d4xh9_zoo_items_relations
4 × SELECT * FROM d4xh9_zoo_application
3 × SELECT * FROM d4xh9_zoo_category
2 × SELECT id, title, alias, link, level, parent_id, browserNav, type, params FROM d4xh9_menu
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 ROWNUM, id FROM (SELECT @rownum:= @rownum+1 ROWNUM, id FROM (SELECT @rownum:=0) r, (SELECT id FROM d4xh9_zoo_item AS a LEFT JOIN d4xh9_zoo_category_item AS b ON a.id = b.item_id
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 LEFT JOIN d4xh9_zoo_category_item AS b ON a.id = b.item_id
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 * FROM d4xh9_languages
1 × SELECT joomlatablename,tablepkID FROM `d4xh9_falang_tableinfo
1 × SELECT id, home, template, s.params FROM d4xh9_template_styles as s LEFT JOIN d4xh9_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
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

l.fandos@globaldit.com

Gran Vía del Marqués del Turia, 49, 46005 Valencia (España)

Lupita Gómez

México

+52 (55) 52 64 06 96

g.gomez@ditglobal.com

Citlaltépetl 24, desp. 201 Col. Hipódromo Condesa 06170 México D.F. (México)

Leo Villella

Argentina

+54 11 5254 2020

San Martín 1009 - 3ro B, 1004 Ciudad Autónoma de Buenos Aires (Argentina)

Estados Unidos

Marian Olmos

Cuestiones legales y administrativas

+ 34 963 354 901

m.olmos@globaldit.com

Plaza Los Pinazo, 2 46004 Valencia (España)

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 :)

John Mora

Partner & corporate venturing

Especialidades

Consola de Joomla! Debug

Sesión

__default

user

Información de Perfil

Uso de Memoria

Registro Database

172 Registro Consultas

23 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

OTRAS Tablas: