An e-discussion on the territorial approach to migration and development

The Joint Migration and Development Initiative, together with the Eunomad network and the UNDP ART initiative, have launched an e-discussion on "Promoting a territorial approach to migration and development: the practices, frameworks and strategies of local authorities to harness the potentiel of migration for development".

This e-discussion will be opened from July 8^th to August 4^th 2013; you can participate by sending your contribution and arguments to This email address is being protected from spambots. You need JavaScript enabled to view it. or directly on the 'Migration for Development' website.

The JMDI is a program (2012-2015) by the European Commission and the United Nations launched in 2008; its second phase started in 2012 and will run until 2015. This program aims at supporting the civil society and local authorities in the fields of migration and development. For more information on the JMDI program, go to the Migration for Development website.

See the background paper of the e-discussion here

Joomla! Debug Console

Application 0.000 seconds (+0.000); 0.19 MB (+0.195) - afterLoad

Application 0.046 seconds (+0.046); 0.97 MB (+0.774) - afterInitialise

Application 0.053 seconds (+0.006); 1.37 MB (+0.402) - afterRoute

Application 0.106 seconds (+0.054); 2.98 MB (+1.609) - afterDispatch

Application 0.109 seconds (+0.003); 3.03 MB (+0.046) - beforeRenderModule mod_custom (Mentions U.E. (EN))

Application 0.110 seconds (+0.001); 3.03 MB (+0.005) - afterRenderModule mod_custom (Mentions U.E. (EN))

Application 0.110 seconds (+0.000); 3.03 MB (-0.001) - beforeRenderModule mod_menu (Menu Footer EN)

Application 0.111 seconds (+0.001); 3.04 MB (+0.014) - afterRenderModule mod_menu (Menu Footer EN)

Application 0.111 seconds (+0.000); 3.04 MB (-0.003) - beforeRenderModule mod_custom (baseline EN)

Application 0.112 seconds (+0.000); 3.04 MB (+0.003) - afterRenderModule mod_custom (baseline EN)

Application 0.112 seconds (+0.000); 3.04 MB (-0.002) - beforeRenderModule mod_custom (News (lien))

Application 0.112 seconds (+0.000); 3.05 MB (+0.003) - afterRenderModule mod_custom (News (lien))

Application 0.112 seconds (+0.000); 3.04 MB (-0.002) - beforeRenderModule mod_cck_list (News)

Application 0.196 seconds (+0.084); 3.47 MB (+0.431) - afterRenderModule mod_cck_list (News)

Application 0.196 seconds (+0.000); 3.44 MB (-0.032) - beforeRenderModule mod_custom (Facebook)

Application 0.196 seconds (+0.000); 3.45 MB (+0.003) - afterRenderModule mod_custom (Facebook)

Application 0.196 seconds (+0.000); 3.45 MB (-0.001) - beforeRenderModule mod_menu (Newsletter)

Application 0.198 seconds (+0.001); 3.45 MB (+0.009) - afterRenderModule mod_menu (Newsletter)

Application 0.198 seconds (+0.000); 3.45 MB (-0.003) - beforeRenderModule mod_menu (Submenu (EN))

Application 0.200 seconds (+0.003); 3.47 MB (+0.017) - afterRenderModule mod_menu (Submenu (EN))

Application 0.200 seconds (+0.000); 3.47 MB (-0.003) - beforeRenderModule mod_search (Recherche)

Application 0.201 seconds (+0.001); 3.48 MB (+0.014) - afterRenderModule mod_search (Recherche)

Application 0.201 seconds (+0.000); 3.47 MB (-0.004) - beforeRenderModule mod_menu (Navigation (EN))

Application 0.203 seconds (+0.001); 3.48 MB (+0.008) - afterRenderModule mod_menu (Navigation (EN))

Application 0.203 seconds (+0.000); 3.48 MB (-0.003) - beforeRenderModule mod_languages (Language selector)

Application 0.210 seconds (+0.007); 3.65 MB (+0.166) - afterRenderModule mod_languages (Language selector)

Application 0.210 seconds (+0.000); 3.64 MB (-0.002) - beforeRenderModule mod_custom (topline EN)

Application 0.210 seconds (+0.000); 3.65 MB (+0.003) - afterRenderModule mod_custom (topline EN)

Application 0.213 seconds (+0.002); 3.68 MB (+0.030) - afterRender

131 Queries Logged

SELECT `data` FROM `joomla_session` WHERE `session_id` = '706109a8fd5f7605b4ec2765c1c79bbd'
SELECT `session_id` FROM `joomla_session` WHERE `session_id` = '706109a8fd5f7605b4ec2765c1c79bbd' LIMIT 0, 1
INSERT INTO `joomla_session` (`session_id`, `client_id`, `time`) VALUES ('706109a8fd5f7605b4ec2765c1c79bbd', 0, '1561491092')
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id FROM joomla_usergroups AS a LEFT JOIN joomla_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
SELECT id, rules FROM `joomla_viewlevels`
SELECT folder AS type, element AS name, params FROM joomla_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1) ORDER BY ordering
SELECT * FROM joomla_languages WHERE published=1 ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_cck'
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 joomla_menu AS m LEFT JOIN joomla_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 a.storage_location, a.options FROM joomla_cck_core_searchs AS a WHERE a.name = "page_actualites"
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT id, home, template, s.params FROM joomla_template_styles as s LEFT JOIN joomla_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 a.rules FROM joomla_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM joomla_content AS a LEFT JOIN joomla_categories AS c on c.id = a.catid LEFT JOIN joomla_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM joomla_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN joomla_categories as parent ON parent.id = c.parent_id LEFT JOIN joomla_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM joomla_categories AS cat JOIN joomla_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.language in ('en-GB','*') AND (contact.language in ('en-GB','*') OR contact.language IS NULL) AND a.id = 139 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-25 19:31:32') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-25 19:31:32') AND (a.state = 1 OR a.state =2)
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM joomla_categories as c LEFT JOIN joomla_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM joomla_categories AS cat JOIN joomla_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=17 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_tags'
SELECT `m`.`tag_id`,`t`.* FROM `joomla_contentitem_tag_map` AS m INNER JOIN `joomla_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 139 AND `t`.`published` = 1 AND t.access IN (1,1)
SELECT a.id, a.pk, a.pkb, a.cck, a.storage_location, a.store_id, b.id as type_id, b.alias as type_alias, b.indexed, b.options_content, b.options_intro, c.template as content_template, c.params as content_params, d.template as intro_template, d.params as intro_params, f.app as folder_app FROM joomla_cck_core AS a LEFT JOIN joomla_cck_core_types AS b ON b.name = a.cck LEFT JOIN joomla_template_styles AS c ON c.id = b.template_content LEFT JOIN joomla_template_styles AS d ON d.id = b.template_intro LEFT JOIN joomla_cck_core_folders AS f ON f.id = b.folder WHERE a.id = "188"
SELECT cc.*, c.label as label2, c.variation, c.link, c.link_options, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.position FROM joomla_cck_core_type_field AS c LEFT JOIN joomla_cck_core_types AS sc ON sc.id = c.typeid LEFT JOIN joomla_cck_core_fields AS cc ON cc.id = c.fieldid WHERE sc.name = "publication" AND sc.published = 1 AND c.client = "content" AND c.access IN (1,1) ORDER BY c.ordering ASC
SELECT * FROM joomla_cck_core_type_position AS a LEFT JOIN joomla_cck_core_types AS b ON b.id = a.typeid WHERE b.name = "publication" AND a.client ="content"
SHOW FULL COLUMNS FROM `joomla_content`
SELECT * FROM joomla_content WHERE `id` = '139'
SELECT a.title, a.alias FROM joomla_categories AS a WHERE a.id = 17
SELECT `t`.`id` FROM `joomla_tags` AS t INNER JOIN `joomla_contentitem_tag_map` AS m ON `m`.`tag_id` = `t`.`id` AND `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` IN ( 139)
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='139'
SELECT `u`.`name` FROM `joomla_content` as `c`, `joomla_users` as `u` WHERE `c`.`created_by` = `u`.`id` AND `c`.`id`='139'
SHOW FULL COLUMNS FROM `joomla_users`
SELECT * FROM `joomla_users` WHERE `id` = 139
SELECT a.* FROM joomla_cck_core_fields AS a WHERE a.name="art_attachment"
SELECT a.* FROM joomla_cck_core_fields AS a WHERE a.name="art_media"
UPDATE joomla_content SET hits = hits + 1 WHERE id = 139
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joomla_modules AS m LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joomla_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 <= '2019-06-25 19:31:32') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-06-25 19:31:32') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 153 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering
SELECT a.id, a.title, a.name, a.description, a.content, a.location, a.storage_location, b.app as folder_app, a.options, a.template_search, a.template_filter, a.template_list, a.template_item FROM joomla_cck_core_searchs AS a LEFT JOIN joomla_cck_core_folders AS b ON b.id = a.folder WHERE a.name ="liste_actualites" AND a.published = 1
SELECT DISTINCT a.*, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.live, c.live_options, c.live_value, c.markup_class, c.match_collection, c.match_mode, c.match_options, c.match_value, c.stage, c.access, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position FROM joomla_cck_core_fields AS a LEFT JOIN joomla_cck_core_search_field AS c ON c.fieldid = a.id LEFT JOIN joomla_cck_core_searchs AS b ON b.id = c.searchid WHERE b.name = "liste_actualites" AND c.client = "search" AND c.access IN (1,1) ORDER BY c.ordering ASC
SELECT DISTINCT a.*, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.live, c.live_options, c.live_value, c.markup_class, c.match_collection, c.match_mode, c.match_options, c.match_value, c.stage, c.access, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position FROM joomla_cck_core_fields AS a LEFT JOIN joomla_cck_core_search_field AS c ON c.fieldid = a.id LEFT JOIN joomla_cck_core_searchs AS b ON b.id = c.searchid WHERE b.name = "liste_actualites" AND c.client = " order" AND c.access IN (1,1) ORDER BY c.ordering ASC
SELECT a.id, a.template as name, a.params FROM joomla_template_styles AS a LEFT JOIN joomla_cck_core_templates AS b ON b.name = a.template WHERE a.id = 64 AND b.published = 1
SELECT a.position, a.client, a.legend, a.variation, a.variation_options, a.width, a.height, a.css FROM joomla_cck_core_search_position AS a WHERE a.searchid = 507 AND a.client ="search"
SELECT a.id, a.title, a.level FROM joomla_categories AS a WHERE a.parent_id > 0 AND extension = 'com_content' AND a.published IN (0,1) ORDER BY a.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.2') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.8') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.9') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.10') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.12') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.13') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.11') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.14') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.15') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.16') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.17') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.22') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.23') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.24') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT title,name FROM joomla_cck_core_types WHERE published=1 ORDER BY title ASC
SELECT `id`, `description` FROM `joomla_cck_core_searchs` WHERE `name`='liste_actualites'
SELECT a.id, a.template as name, a.params FROM joomla_template_styles AS a LEFT JOIN joomla_cck_core_templates AS b ON b.name = a.template WHERE a.id = 155 AND b.published = 1
SELECT cc.*, c.label as label2, c.variation, c.link, c.link_options, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.position FROM joomla_cck_core_search_field AS c LEFT JOIN joomla_cck_core_searchs AS sc ON sc.id = c.searchid LEFT JOIN joomla_cck_core_fields AS cc ON cc.id = c.fieldid WHERE sc.name = "liste_actualites" AND sc.published = 1 AND c.client = "item" AND c.access IN (1,1) ORDER BY c.ordering ASC
SELECT a.position, a.client, a.legend, a.variation, a.variation_options, a.width, a.height, a.css FROM joomla_cck_core_search_position AS a WHERE a.searchid = 507 AND a.client ="item"
SELECT a.id, a.template as name, a.params FROM joomla_template_styles AS a LEFT JOIN joomla_cck_core_templates AS b ON b.name = a.template WHERE a.id = 66 AND b.published = 1
SELECT a.*, b.title AS category_title, b.alias AS category_alias FROM joomla_content AS a LEFT JOIN joomla_categories AS b ON b.id = a.catid WHERE a.id IN (399,398,392,366,139,169,141,128,468,270)
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='399'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='398'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='392'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='366'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='139'
SELECT `u`.`name` FROM `joomla_content` as `c`, `joomla_users` as `u` WHERE `c`.`created_by` = `u`.`id` AND `c`.`id`='139'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='169'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='141'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='128'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='468'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='270'
SELECT t0.id as pid, t0.pk as pk, t0.pkb as pkb,t0.cck as cck, t0.storage_location as loc,tt.id AS type_id, tt.alias AS type_alias FROM `joomla_cck_core` AS t0 LEFT JOIN `joomla_content` AS t1 ON t1.id = t0.pk LEFT JOIN `joomla_cck_core_types` AS tt ON tt.name = t0.cck WHERE t1.state = 1 AND t1.access IN (1,1) AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2019-06-25 09:31:32' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2019-06-25 09:31:32' ) AND t0.storage_location = 'joomla_article' AND ((t1.catid LIKE '%15%') OR (t1.catid LIKE '%16%') OR (t1.catid LIKE '%17%')) GROUP BY t0.pk ORDER BY t1.created DESC LIMIT 0, 12
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='399'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='399'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='398'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='398'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='392'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='392'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='366'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='366'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='139'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='139'
SELECT `u`.`name` FROM `joomla_content` as `c`, `joomla_users` as `u` WHERE `c`.`created_by` = `u`.`id` AND `c`.`id`='139'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='169'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='169'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='141'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='141'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='128'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='128'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='468'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='468'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='270'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='270'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='263'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='263'
SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c WHERE c.`id`='467'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='467'
SELECT `key` FROM `joomla_associations` WHERE `id`='399'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='8558432c8e524d3a74eb254c69c96a91'
SELECT `key` FROM `joomla_associations` WHERE `id`='398'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='8558432c8e524d3a74eb254c69c96a91'
SELECT `key` FROM `joomla_associations` WHERE `id`='392'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='29f6353be86780b8fa416c3820d6333b'
SELECT `key` FROM `joomla_associations` WHERE `id`='366'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='29f6353be86780b8fa416c3820d6333b'
SELECT `key` FROM `joomla_associations` WHERE `id`='139'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='8d047b533871d1026789a8e373043723'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='9cb4f3017adef76b8617e3d4f06f7a84'
SELECT `key` FROM `joomla_associations` WHERE `id`='169'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='80dd38f243ab1e46e893833b6f6efd00'
SELECT `key` FROM `joomla_associations` WHERE `id`='141'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='9cb4f3017adef76b8617e3d4f06f7a84'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='b78fe3275eb8249c4d8a7113636ce26c'
SELECT `key` FROM `joomla_associations` WHERE `id`='128'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='80dd38f243ab1e46e893833b6f6efd00'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='c68c7655b2f21215137d92c0ee8e9880'
SELECT `key` FROM `joomla_associations` WHERE `id`='468'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='503e85fc4f7c374f10a2c1382bc681fc'
SELECT `key` FROM `joomla_associations` WHERE `id`='270'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='503e85fc4f7c374f10a2c1382bc681fc'
SELECT `key` FROM `joomla_associations` WHERE `id`='263'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='2cd39bba130e636dc58c019e07167d30'
SELECT `key` FROM `joomla_associations` WHERE `id`='467'
SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c` WHERE `a`.`id`=`c`.`id` AND `a`.`key`='779802c1306faa429e749bb1435b6ed3'
SELECT m2.language, m2.id FROM joomla_menu as m INNER JOIN joomla_associations as a ON a.id=m.id AND a.context='com_menus.item' INNER JOIN joomla_associations as a2 ON a.key=a2.key INNER JOIN joomla_menu as m2 ON a2.id=m2.id WHERE m.id=153
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` FROM `joomla_content` AS `c` INNER JOIN `joomla_associations` AS `a` ON a.id = c.id AND a.context='com_content.item' INNER JOIN `joomla_associations` AS `a2` ON a.key = a2.key INNER JOIN `joomla_content` AS `c2` ON a2.id = c2.`id` INNER JOIN `joomla_categories` AS `ca` ON `c2`.`catid` = ca.id AND ca.extension = 'com_content' WHERE c.id =139
SELECT a.sef AS sef,a.lang_code AS lang_code FROM joomla_languages AS a
SELECT a.sef AS sef,a.lang_code AS lang_code FROM joomla_languages AS a
UPDATE `joomla_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1561491092;s:18:\"session.timer.last\";i:1561491092;s:17:\"session.timer.now\";i:1561491092;s:24:\"session.client.forwarded\";s:13:\"54.226.30.186\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:2:\"ip\";s:13:\"54.226.30.186\";s:10:\"session_id\";s:32:\"706109a8fd5f7605b4ec2765c1c79bbd\";s:12:\"where_clause\";s:45:\"session_id=\"706109a8fd5f7605b4ec2765c1c79bbd\"\";s:3:\"gid\";i:25;}}' , `time` = '1561491092' WHERE `session_id` = '706109a8fd5f7605b4ec2765c1c79bbd'

47 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

23 × SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content`
15 × SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c`
15 × SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
12 × SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c
12 × SELECT `key` FROM `joomla_associations`
5 × SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions
3 × SELECT a.id, a.template as name, a.params FROM joomla_template_styles AS a LEFT JOIN joomla_cck_core_templates AS b ON b.name = a.template
3 × SELECT `u`.`name` FROM `joomla_content` as `c`, `joomla_users` as `u`
2 × SELECT DISTINCT a.*, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.live, c.live_options, c.live_value, c.markup_class, c.match_collection, c.match_mode, c.match_options, c.match_value, c.stage, c.access, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position FROM joomla_cck_core_fields AS a LEFT JOIN joomla_cck_core_search_field AS c ON c.fieldid = a.id LEFT JOIN joomla_cck_core_searchs AS b ON b.id = c.searchid
2 × SELECT a.sef AS sef,a.lang_code AS lang_code FROM joomla_languages AS
2 × SELECT a.position, a.client, a.legend, a.variation, a.variation_options, a.width, a.height, a.css FROM joomla_cck_core_search_position AS a
2 × SELECT a.* FROM joomla_cck_core_fields AS a
1 × SELECT a.id, a.title, a.name, a.description, a.content, a.location, a.storage_location, b.app as folder_app, a.options, a.template_search, a.template_filter, a.template_list, a.template_item FROM joomla_cck_core_searchs AS a LEFT JOIN joomla_cck_core_folders AS b ON b.id = a.folder
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joomla_modules AS m LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joomla_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT `id`, `description` FROM `joomla_cck_core_searchs`
1 × SELECT a.*, b.title AS category_title, b.alias AS category_alias FROM joomla_content AS a LEFT JOIN joomla_categories AS b ON b.id = a.catid
1 × SELECT t0.id as pid, t0.pk as pk, t0.pkb as pkb,t0.cck as cck, t0.storage_location as loc,tt.id AS type_id, tt.alias AS type_alias FROM `joomla_cck_core` AS t0 LEFT JOIN `joomla_content` AS t1 ON t1.id = t0.pk LEFT JOIN `joomla_cck_core_types` AS tt ON tt.name = t0.cck
1 × SELECT m2.language, m2.id FROM joomla_menu as m INNER JOIN joomla_associations as a ON a.id=m.id AND a.context='com_menus.item' INNER JOIN joomla_associations as a2 ON a.key=a2.key INNER JOIN joomla_menu as m2 ON a2.id=m2.id
1 × SELECT cc.*, c.label as label2, c.variation, c.link, c.link_options, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.position FROM joomla_cck_core_search_field AS c LEFT JOIN joomla_cck_core_searchs AS sc ON sc.id = c.searchid LEFT JOIN joomla_cck_core_fields AS cc ON cc.id = c.fieldid
1 × SELECT * FROM `joomla_users`
1 × SELECT title,name FROM joomla_cck_core_types
1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` FROM `joomla_content` AS `c` INNER JOIN `joomla_associations` AS `a` ON a.id = c.id AND a.context='com_content.item' INNER JOIN `joomla_associations` AS `a2` ON a.key = a2.key INNER JOIN `joomla_content` AS `c2` ON a2.id = c2.`id` INNER JOIN `joomla_categories` AS `ca` ON `c2`.`catid` = ca.id AND ca.extension = 'com_content'
1 × SELECT a.id, a.title, a.level FROM joomla_categories AS a
1 × SELECT `t`.`id` FROM `joomla_tags` AS t INNER JOIN `joomla_contentitem_tag_map` AS m ON `m`.`tag_id` = `t`.`id` AND `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` IN ( 139
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 joomla_menu AS m LEFT JOIN joomla_extensions AS e ON m.component_id = e.extension_id
1 × SELECT a.storage_location, a.options FROM joomla_cck_core_searchs AS a
1 × SELECT id, home, template, s.params FROM joomla_template_styles as s LEFT JOIN joomla_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT * FROM joomla_languages
1 × SELECT folder AS type, element AS name, params FROM joomla_extensions
1 × SELECT `session_id` FROM `joomla_session`
1 × SELECT b.id FROM joomla_usergroups AS a LEFT JOIN joomla_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `joomla_viewlevels
1 × SELECT a.rules FROM joomla_assets AS a
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM joomla_content AS a LEFT JOIN joomla_categories AS c on c.id = a.catid LEFT JOIN joomla_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM joomla_contact_details AS contact
1 × SELECT * FROM joomla_cck_core_type_position AS a LEFT JOIN joomla_cck_core_types AS b ON b.id = a.typeid
1 × SELECT * FROM joomla_content
1 × SELECT a.title, a.alias FROM joomla_categories AS a
1 × SELECT cc.*, c.label as label2, c.variation, c.link, c.link_options, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.position FROM joomla_cck_core_type_field AS c LEFT JOIN joomla_cck_core_types AS sc ON sc.id = c.typeid LEFT JOIN joomla_cck_core_fields AS cc ON cc.id = c.fieldid
1 × SELECT a.id, a.pk, a.pkb, a.cck, a.storage_location, a.store_id, b.id as type_id, b.alias as type_alias, b.indexed, b.options_content, b.options_intro, c.template as content_template, c.params as content_params, d.template as intro_template, d.params as intro_params, f.app as folder_app FROM joomla_cck_core AS a LEFT JOIN joomla_cck_core_types AS b ON b.name = a.cck LEFT JOIN joomla_template_styles AS c ON c.id = b.template_content LEFT JOIN joomla_template_styles AS d ON d.id = b.template_intro LEFT JOIN joomla_cck_core_folders AS f ON f.id = b.folder
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM joomla_categories as c LEFT JOIN joomla_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM joomla_categories AS cat JOIN joomla_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT `m`.`tag_id`,`t`.* FROM `joomla_contentitem_tag_map` AS m INNER JOIN `joomla_tags` AS t ON `m`.`tag_id` = `t`.`id`
1 × SELECT `data` FROM `joomla_session`

OTHER Tables:

1 × UPDATE `joomla_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1561491092;s:18:\"session.timer.last\";i:1561491092;s:17:\"session.timer.now\";i:1561491092;s:24:\"session.client.forwarded\";s:13:\"54.226.30.186\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:2:\"ip\";s:13:\"54.226.30.186\";s:10:\"session_id\";s:32:\"706109a8fd5f7605b4ec2765c1c79bbd\";s:12:\"
1 × UPDATE joomla_content SET hits = hits + 1
1 × SHOW FULL COLUMNS FROM `joomla_users
1 × SHOW FULL COLUMNS FROM `joomla_content
1 × INSERT INTO `joomla_session` (`session_id`, `client_id`, `time`) VALUES ('706109a8fd5f7605b4ec2765c1c79bbd', 0, '1561491092'

News