Ampliación del SICTED

Noticias · Jueves, 06 de Octubre de 2011

Tras una primera oleada de implantación del SICTED en el destino, el Ayuntamiento de Pamplona decidió ampliar este proyecto para dar cabida a nuevas empresas y sectores, además de renovar el distintivo de las empresas que ya cuentan con el Compromiso de Calidad Turística (24 empresas/servicios turísticos y 51 taxis).

Se concluye ahora el proyecto de implantación, cuyo objetivo ha sido distinguir 10 nuevas empresas y 10 taxis nuevos. Las 10 nuevas empresas han recibido sesiones formativas, visitas de asesoría individualizada y visitas de evaluación. Por su parte, las empresas ya distinguidas recibieron seis sesiones formativas con diferentes módulos. 2 sesiones formativas (El SICTED y El Manual de Buenas Prácticas y la autoevaluación), 20 visitas individualizadas y 10 visitas de evaluación, además de evaluaciones individualizadas.

Aprende como lo hicimos

Pamplona no es (solo) San Fermín

Otros proyectos

También te puede interesar

Buenas prácticas en los taxis de San Sebastián

Noticias

Finaliza el Plan de Calidad Turística de Requena

Noticias

El II Plan de Calidad Turística de Andalucía

Noticias

MACT en Requena. Última etapa

Noticias

Plan de Calidad Turística de Requena

Noticias

Etiquetas

España · Transformación · Calidad

Finaliza el SCTE Buenas Prácticas en Bolivia

Marketing... Ser, estar y parecer

Consola de Joomla! Debug

Application 0.001 seconds (+0.001); 0.34 MB (+0.339) - afterLoad

Application 0.052 seconds (+0.051); 1.58 MB (+1.245) - afterInitialise

Application 0.073 seconds (+0.020); 2.20 MB (+0.611) - afterRoute

Application 0.353 seconds (+0.280); 4.85 MB (+2.652) - afterDispatch

Application 0.364 seconds (+0.011); 5.01 MB (+0.157) - beforeRenderModule mod_menufooter (Menu footer)

Application 0.370 seconds (+0.006); 5.11 MB (+0.107) - beforeRenderModule mod_social (Links social media)

Application 0.371 seconds (+0.001); 5.12 MB (+0.008) - afterRenderModule mod_social (Links social media)

Application 0.372 seconds (+0.001); 5.08 MB (-0.039) - afterRenderModule mod_menufooter (Menu footer)

Application 0.372 seconds (+0.000); 5.01 MB (-0.074) - beforeRenderModule mod_zooitem (Microsites (zona globaldit))

Application 0.448 seconds (+0.076); 5.62 MB (+0.615) - afterRenderModule mod_zooitem (Microsites (zona globaldit))

Application 0.449 seconds (+0.002); 5.58 MB (-0.040) - beforeRenderModule mod_custom (Logos footer)

Application 0.451 seconds (+0.002); 5.59 MB (+0.007) - afterRenderModule mod_custom (Logos footer)

Application 0.453 seconds (+0.002); 5.58 MB (-0.004) - beforeRenderModule mod_custom (Acceso microsites movil)

Application 0.454 seconds (+0.001); 5.59 MB (+0.004) - afterRenderModule mod_custom (Acceso microsites movil)

Application 0.455 seconds (+0.002); 5.59 MB (+0.002) - beforeRenderModule mod_menu (Menú secundario)

Application 0.458 seconds (+0.003); 5.62 MB (+0.034) - afterRenderModule mod_menu (Menú secundario)

Application 0.460 seconds (+0.001); 5.60 MB (-0.021) - beforeRenderModule mod_menu (Menú Principal)

Application 0.462 seconds (+0.002); 5.68 MB (+0.080) - afterRenderModule mod_menu (Menú Principal)

Application 0.463 seconds (+0.001); 5.61 MB (-0.078) - beforeRenderModule mod_custom (Logo)

Application 0.463 seconds (+0.000); 5.61 MB (+0.004) - afterRenderModule mod_custom (Logo)

Application 0.464 seconds (+0.000); 5.58 MB (-0.025) - beforeRenderModule mod_compartir (Compartir)

Application 0.465 seconds (+0.001); 5.59 MB (+0.009) - afterRenderModule mod_compartir (Compartir)

Application 0.466 seconds (+0.001); 5.62 MB (+0.025) - beforeRenderModule mod_search (Buscador (header))

Application 0.468 seconds (+0.002); 5.64 MB (+0.017) - afterRenderModule mod_search (Buscador (header))

Application 0.468 seconds (+0.000); 5.61 MB (-0.029) - beforeRenderModule mod_contact (Contacto)

Application 0.535 seconds (+0.067); 6.80 MB (+1.197) - afterRenderModule mod_contact (Contacto)

Application 0.542 seconds (+0.007); 6.84 MB (+0.034) - afterRender

193 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 = 'ampliacion-del-sicted' 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(1261) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1261
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(1261) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_application WHERE id = 17
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(17) 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 = 17 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(47,45,44) AND falang_content.reference_table='zoo_category'
UPDATE d4xh9_zoo_item SET hits = (hits + 1) WHERE id = 1261
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
SHOW FULL COLUMNS FROM `d4xh9_content`
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Entrada-Work' AND item1 = 1261
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1008) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') ORDER BY FIELD(id,1008)
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(1008) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Entrada-Work' AND item1 = 1261
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1008) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') ORDER BY FIELD(id,1008)
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(1008) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Entrada-Work' AND item1 = 1261
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1008) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') ORDER BY FIELD(id,1008)
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(1008) 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 * 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'
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=1008 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1008 AND a.category_id = 0
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Entrada-Etiqueta' AND item1 = 1261
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Entrada-Work' AND item1 = 1261
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1008) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') ORDER BY FIELD(id,1008)
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(1008) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Entrada-Etiqueta' AND item1 = 1261
SELECT et.id, et.name FROM d4xh9_zoo_item zi1, d4xh9_zoo_item et, d4xh9_zoo_items_relations zir WHERE et.application_id = 27 AND zi1.state = 1 AND et.state = 1 AND zi1.id = 1261 AND zir.item1= zi1.id AND zir.item2 = et.id
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(1723,1730,1602) AND falang_content.reference_table='zoo_item'
SELECT et2.id, et2.name FROM d4xh9_zoo_item et1, d4xh9_zoo_item et2, d4xh9_zoo_items_relations zir WHERE et1.application_id =27 AND et1.state = 1 AND et2.state = 1 AND et2.application_id =27 AND zir.item1 = et1.id AND zir.item2 = et2.id AND et1.id =1723
SELECT et2.id, et2.name FROM d4xh9_zoo_item et1, d4xh9_zoo_item et2, d4xh9_zoo_items_relations zir WHERE et1.application_id =27 AND et1.state = 1 AND et2.state = 1 AND et2.application_id =27 AND zir.item1 = et1.id AND zir.item2 = et2.id AND et1.id =1730
SELECT et2.id, et2.name FROM d4xh9_zoo_item et1, d4xh9_zoo_item et2, d4xh9_zoo_items_relations zir WHERE et1.application_id =27 AND et1.state = 1 AND et2.state = 1 AND et2.application_id =27 AND zir.item1 = et1.id AND zir.item2 = et2.id AND et1.id =1602
SELECT zi.id as id, zi.name as name, COUNT( zi.id ) AS count FROM d4xh9_zoo_items_relations zir, d4xh9_zoo_item zi WHERE zi.id = zir.item1 AND zi.state = 1 AND zir.item2 IN (1723,1730,1602) AND zi.id != 1261 AND zi.application_id != 27 GROUP BY zi.id ORDER BY count DESC, zi.publish_up DESC 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(1262,1278,1292,1289,1283) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1262
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(1262) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1278
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(1278) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1292
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(1292) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1289
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(1289) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1283
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(1283) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Entrada-Etiqueta' AND item1 = 1261
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1723, 1730, 1602) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') ORDER BY FIELD(id,1723, 1730, 1602)
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(1723,1730,1602) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Entrada-Etiqueta' AND item1 = 1261
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1723, 1730, 1602) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') ORDER BY FIELD(id,1723, 1730, 1602)
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(1723,1730,1602) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_items_relations WHERE name = 'Entrada-Etiqueta' AND item1 = 1261
SELECT id FROM d4xh9_assets WHERE parent_id = 0
SELECT * FROM d4xh9_zoo_item WHERE id IN (1723, 1730, 1602) AND state = 1 AND access IN (1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') ORDER BY FIELD(id,1723, 1730, 1602)
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(1723,1730,1602) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_application WHERE id = 27
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(27) AND falang_content.reference_table='zoo_application'
SELECT * FROM d4xh9_zoo_category WHERE application_id = 27 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=1723 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1723 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=1730 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1730 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=1602 AND b.published = 1 UNION SELECT 0 FROM d4xh9_zoo_category_item AS a WHERE a.item_id=1602 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 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 = 17 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-19 07:32:51') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 07:32:51') GROUP BY a.id ORDER BY a.priority DESC, a.created DESC) t1) t2 WHERE id = 1261
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 = 17 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-19 07:32:51') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 07:32:51') GROUP BY a.id ORDER BY a.priority DESC, a.created DESC) t1) t2 WHERE ROWNUM = 67 OR ROWNUM = 69
SELECT * FROM d4xh9_zoo_item WHERE id = 1260
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(1260) AND falang_content.reference_table='zoo_item'
SELECT * FROM d4xh9_zoo_item WHERE id = 1199
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(1199) AND falang_content.reference_table='zoo_item'
SELECT id FROM d4xh9_assets WHERE parent_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-19 07:32:51') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 07:32:51') 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-19 07:32:52') AND (zi.publish_down = '0000-00-00 00:00:00' OR zi.publish_down >= '2024-04-19 07:32:52') 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-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') 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-04-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') 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-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') 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-19 07:32:51') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 07:32:51') ORDER BY FIELD(id,1089)

25 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

87 × SELECT id FROM d4xh9_assets
35 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM d4xh9_falang_content AS falang_content
23 × SELECT * FROM d4xh9_zoo_item
13 × SELECT * FROM d4xh9_zoo_items_relations
6 × SELECT * FROM d4xh9_zoo_application
4 × SELECT b.id FROM d4xh9_zoo_category_item AS a JOIN d4xh9_zoo_category AS b ON a.category_id = b.id
4 × SELECT * FROM d4xh9_zoo_category
3 × SELECT et2.id, et2.name FROM d4xh9_zoo_item et1, d4xh9_zoo_item et2, d4xh9_zoo_items_relations zir
2 × SELECT id, title, alias, link, level, parent_id, browserNav, type, params FROM d4xh9_menu
1 × SELECT zi.id as id, zi.name as name, COUNT( zi.id ) AS count FROM d4xh9_zoo_items_relations zir, d4xh9_zoo_item zi
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 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 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 et.id, et.name FROM d4xh9_zoo_item zi1, d4xh9_zoo_item et, d4xh9_zoo_items_relations zir
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
1 × SELECT * FROM d4xh9_languages
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 id FROM d4xh9_zoo_item
1 × SELECT a.rules FROM d4xh9_assets AS a

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