EC communication on migration as a driving force for development

The European Commission released a communicationon "Maximising the development impact of migration" on 21 May 2013. In this communication, it links migration and mobility to inclusive and socio-economic development.

This Communication was published in a context of increased migration and intensification of global mobility, which lead to troubling phenomenon such as "brain drain", migrant exploitation and rapid urbanization, but which offers numerous opportunities for the citizens of the world and to reduce povery. The European Union, within the framework of its Global Approach on Migration and Mobility, attaches much importance to migration, this being a priority for its development cooperation.

The EC tackles different elements she considers important in this Communication: the link between migration and development, the post-2015 development framework, the human rights of migrants, regular, orderly and safe migration, human trafficking, cooperation and partnership, labour mobility...

This document will be used to elaborate a common EU position that will be defended at the High-level Dialogue on International Migration and Development organised by the United Nations General Assembly on October 3-4 2013.

Read the press release
Read the Communication

Joomla! Debug Console

Application 0.000 seconds (+0.000); 0.20 MB (+0.200) - afterLoad

Application 0.061 seconds (+0.061); 1.00 MB (+0.797) - afterInitialise

Application 0.076 seconds (+0.015); 1.41 MB (+0.416) - afterRoute

Application 0.215 seconds (+0.139); 3.12 MB (+1.705) - afterDispatch

Application 0.220 seconds (+0.005); 3.17 MB (+0.053) - beforeRenderModule mod_custom (Mentions U.E. (EN))

Application 0.223 seconds (+0.002); 3.18 MB (+0.005) - afterRenderModule mod_custom (Mentions U.E. (EN))

Application 0.223 seconds (+0.000); 3.18 MB (-0.002) - beforeRenderModule mod_menu (Menu Footer EN)

Application 0.226 seconds (+0.003); 3.19 MB (+0.015) - afterRenderModule mod_menu (Menu Footer EN)

Application 0.226 seconds (+0.000); 3.19 MB (-0.003) - beforeRenderModule mod_custom (baseline EN)

Application 0.226 seconds (+0.000); 3.19 MB (+0.003) - afterRenderModule mod_custom (baseline EN)

Application 0.226 seconds (+0.000); 3.19 MB (-0.002) - beforeRenderModule mod_custom (News (lien))

Application 0.226 seconds (+0.000); 3.19 MB (+0.003) - afterRenderModule mod_custom (News (lien))

Application 0.226 seconds (+0.000); 3.19 MB (-0.002) - beforeRenderModule mod_cck_list (News)

Application 0.357 seconds (+0.131); 3.61 MB (+0.424) - afterRenderModule mod_cck_list (News)

Application 0.357 seconds (+0.000); 3.58 MB (-0.032) - beforeRenderModule mod_custom (Facebook)

Application 0.357 seconds (+0.000); 3.58 MB (+0.003) - afterRenderModule mod_custom (Facebook)

Application 0.357 seconds (+0.000); 3.58 MB (-0.001) - beforeRenderModule mod_menu (Newsletter)

Application 0.359 seconds (+0.002); 3.59 MB (+0.009) - afterRenderModule mod_menu (Newsletter)

Application 0.359 seconds (+0.000); 3.59 MB (-0.003) - beforeRenderModule mod_menu (Submenu (EN))

Application 0.362 seconds (+0.003); 3.61 MB (+0.018) - afterRenderModule mod_menu (Submenu (EN))

Application 0.362 seconds (+0.000); 3.60 MB (-0.003) - beforeRenderModule mod_search (Recherche)

Application 0.365 seconds (+0.003); 3.62 MB (+0.014) - afterRenderModule mod_search (Recherche)

Application 0.365 seconds (+0.000); 3.61 MB (-0.004) - beforeRenderModule mod_menu (Navigation (EN))

Application 0.366 seconds (+0.001); 3.62 MB (+0.009) - afterRenderModule mod_menu (Navigation (EN))

Application 0.366 seconds (+0.000); 3.62 MB (-0.003) - beforeRenderModule mod_languages (Language selector)

Application 0.380 seconds (+0.014); 3.79 MB (+0.167) - afterRenderModule mod_languages (Language selector)

Application 0.380 seconds (+0.000); 3.78 MB (-0.003) - beforeRenderModule mod_custom (topline EN)

Application 0.380 seconds (+0.000); 3.79 MB (+0.003) - afterRenderModule mod_custom (topline EN)

Application 0.383 seconds (+0.002); 3.82 MB (+0.030) - afterRender

133 Queries Logged

SELECT `data` FROM `joomla_session` WHERE `session_id` = 'fca6e8c61ddd5d76456d0c6107b912f1'
DELETE FROM `joomla_session` WHERE `time` < '1606724329'
SELECT `session_id` FROM `joomla_session` WHERE `session_id` = 'fca6e8c61ddd5d76456d0c6107b912f1' LIMIT 0, 1
INSERT INTO `joomla_session` (`session_id`, `client_id`, `time`) VALUES ('fca6e8c61ddd5d76456d0c6107b912f1', 0, '1606735129')
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 extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT alias FROM joomla_content WHERE id=201
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=14 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 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 = 201 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-30 11:18:49') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-30 11:18:49') AND (a.state = 1 OR a.state =2)
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` = 201 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 = "281"
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` = '201'
SELECT a.title, a.alias FROM joomla_categories AS a WHERE a.id = 14
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 ( 201)
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='201'
SHOW FULL COLUMNS FROM `joomla_users`
SELECT * FROM `joomla_users` WHERE `id` = 201
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 = 201
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 <= '2020-11-30 11:18:49') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-30 11:18:49') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 102 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 storage_location, storage_table FROM joomla_cck_core WHERE cck IN ("publication") ORDER BY id DESC LIMIT 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 WHERE t1.state = 1 AND t1.access IN (1,1) AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2020-11-30 11:18:49' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2020-11-30 11:18:49' ) AND ((t1.catid = '16') OR (t1.catid = '17')) AND t0.cck = 'publication' GROUP BY t0.pk ORDER BY t1.created DESC
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,270,468)
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`='270'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='468'
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 <= '2020-11-30 12:18:50' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2020-11-30 12:18:50' ) 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`='135'
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='135'
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`='135'
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=102
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 =201
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:1606735129;s:18:\"session.timer.last\";i:1606735129;s:17:\"session.timer.now\";i:1606735129;s:24:\"session.client.forwarded\";s:13:\"34.237.138.69\";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:\"34.237.138.69\";s:10:\"session_id\";s:32:\"fca6e8c61ddd5d76456d0c6107b912f1\";s:12:\"where_clause\";s:45:\"session_id=\"fca6e8c61ddd5d76456d0c6107b912f1\"\";s:3:\"gid\";i:25;}}' , `time` = '1606735130' WHERE `session_id` = 'fca6e8c61ddd5d76456d0c6107b912f1'

50 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
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 `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.* FROM joomla_cck_core_fields AS a
1 × SELECT title,name FROM joomla_cck_core_types
1 × SELECT a.id, a.title, a.level FROM joomla_categories AS a
1 × SELECT `id`, `description` FROM `joomla_cck_core_searchs`
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 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 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 `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 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 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 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 storage_location, storage_table FROM joomla_cck_core
1 × SELECT * FROM `joomla_users`
1 × SELECT alias FROM joomla_content
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 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 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 * FROM joomla_languages
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 folder AS type, element AS name, params FROM joomla_extensions
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 a.title, a.alias 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 ( 201
1 × SELECT `data` FROM `joomla_session`
1 × SELECT * FROM joomla_content
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 `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 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 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 `session_id` FROM `joomla_session`

OTHER Tables:

1 × UPDATE joomla_content SET hits = hits + 1
1 × UPDATE `joomla_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1606735129;s:18:\"session.timer.last\";i:1606735129;s:17:\"session.timer.now\";i:1606735129;s:24:\"session.client.forwarded\";s:13:\"34.237.138.69\";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:\"34.237.138.69\";s:10:\"session_id\";s:32:\"fca6e8c61ddd5d76456d0c6107b912f1\";s:12:\"
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 ('fca6e8c61ddd5d76456d0c6107b912f1', 0, '1606735129'
1 × DELETE FROM `joomla_session`