Eunomad report 2012

The Eunomad European report 2012 "Migration, development and integration in Europe" is available.

After a focus on the impact of the Arab Spring in 2011, Eunomad's European report 2012 analyses the consequences of the financial and economic crisis on international mobility, the rights of migrants and on the development and integration policies in Europe. It also tries to analyse the problem of the benefits of cooperation between the territories in which local authorities have a key role to play alongside the civil society actors. Finally, with examples of concrete projects, it illustrates intercultural skills at work in the dynamics between migration and development.

Eunomad has asked the researcher Lorenzo Gabrielli, who relied on the contributions of the members of the network, to draw this report. Ten recommendations were made: these combine the shared values and the arguments brought forward by the members of the network. This report intends to provide, through objective data, a positive view of international migration in its interaction with the dynamics of cooperation and the issues of citizenship. Many contributions that will renew the ways of making and thinking innovative policies that link migration, development and citizenship.

Download the report

Joomla! Debug Console

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

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

Application 0.073 seconds (+0.012); 1.42 MB (+0.417) - afterRoute

Application 0.214 seconds (+0.141); 3.13 MB (+1.713) - afterDispatch

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

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

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

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

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

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

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

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

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

Application 0.359 seconds (+0.133); 3.63 MB (+0.427) - afterRenderModule mod_cck_list (News)

Application 0.359 seconds (+0.000); 3.59 MB (-0.032) - beforeRenderModule mod_custom (Facebook)

Application 0.359 seconds (+0.000); 3.60 MB (+0.003) - afterRenderModule mod_custom (Facebook)

Application 0.359 seconds (+0.000); 3.60 MB (-0.001) - beforeRenderModule mod_menu (Newsletter)

Application 0.361 seconds (+0.002); 3.61 MB (+0.009) - afterRenderModule mod_menu (Newsletter)

Application 0.361 seconds (+0.000); 3.60 MB (-0.003) - beforeRenderModule mod_menu (Submenu (EN))

Application 0.364 seconds (+0.003); 3.62 MB (+0.018) - afterRenderModule mod_menu (Submenu (EN))

Application 0.364 seconds (+0.000); 3.62 MB (-0.003) - beforeRenderModule mod_search (Recherche)

Application 0.367 seconds (+0.003); 3.63 MB (+0.014) - afterRenderModule mod_search (Recherche)

Application 0.367 seconds (+0.000); 3.63 MB (-0.004) - beforeRenderModule mod_menu (Navigation (EN))

Application 0.368 seconds (+0.001); 3.64 MB (+0.009) - afterRenderModule mod_menu (Navigation (EN))

Application 0.368 seconds (+0.000); 3.63 MB (-0.003) - beforeRenderModule mod_languages (Language selector)

Application 0.383 seconds (+0.015); 3.80 MB (+0.167) - afterRenderModule mod_languages (Language selector)

Application 0.383 seconds (+0.000); 3.80 MB (-0.003) - beforeRenderModule mod_custom (topline EN)

Application 0.384 seconds (+0.000); 3.80 MB (+0.003) - afterRenderModule mod_custom (topline EN)

Application 0.386 seconds (+0.003); 3.83 MB (+0.031) - afterRender

134 Queries Logged

SELECT `data` FROM `joomla_session` WHERE `session_id` = 'aa63d6edbac6649fd54ab9ac17a5ef7b'
DELETE FROM `joomla_session` WHERE `time` < '1600924201'
SELECT `session_id` FROM `joomla_session` WHERE `session_id` = 'aa63d6edbac6649fd54ab9ac17a5ef7b' LIMIT 0, 1
INSERT INTO `joomla_session` (`session_id`, `client_id`, `time`) VALUES ('aa63d6edbac6649fd54ab9ac17a5ef7b', 0, '1600935001')
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=102
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=11 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 = 102 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-24 08:10:01') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-24 08:10:01') 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` = 102 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 = "146"
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` = '102'
SELECT a.title, a.alias FROM joomla_categories AS a WHERE a.id = 11
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 ( 102)
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='102'
SELECT `u`.`name` FROM `joomla_content` as `c`, `joomla_users` as `u` WHERE `c`.`created_by` = `u`.`id` AND `c`.`id`='102'
SHOW FULL COLUMNS FROM `joomla_users`
SELECT * FROM `joomla_users` WHERE `id` = 102
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 = 102
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-09-24 08:10:01') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-24 08:10:01') 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-09-24 08:10:01' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2020-09-24 08:10:01' ) 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,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 <= '2020-09-24 10:10:01' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2020-09-24 10:10:01' ) 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=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 =102
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:1600935001;s:18:\"session.timer.last\";i:1600935001;s:17:\"session.timer.now\";i:1600935001;s:24:\"session.client.forwarded\";s:11:\"34.205.93.2\";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:11:\"34.205.93.2\";s:10:\"session_id\";s:32:\"aa63d6edbac6649fd54ab9ac17a5ef7b\";s:12:\"where_clause\";s:45:\"session_id=\"aa63d6edbac6649fd54ab9ac17a5ef7b\"\";s:3:\"gid\";i:25;}}' , `time` = '1600935001' WHERE `session_id` = 'aa63d6edbac6649fd54ab9ac17a5ef7b'

50 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

23 × SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content`
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
15 × SELECT `c`.`id`, `a`.`key`, `c`.`language` FROM `joomla_associations` as `a`, `joomla_content` as `c`
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.* FROM joomla_cck_core_fields AS a
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.sef AS sef,a.lang_code AS lang_code FROM joomla_languages AS
1 × SELECT storage_location, storage_table FROM joomla_cck_core
1 × SELECT `id`, `description` FROM `joomla_cck_core_searchs`
1 × SELECT title,name FROM joomla_cck_core_types
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.id, a.title, a.level FROM joomla_categories AS a
1 × SELECT * FROM joomla_languages
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 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 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 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 folder AS type, element AS name, params FROM joomla_extensions
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 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 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 `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 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.rules FROM joomla_assets AS a
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 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 * FROM joomla_cck_core_type_position AS a LEFT JOIN joomla_cck_core_types AS b ON b.id = a.typeid
1 × SELECT `session_id` FROM `joomla_session`
1 × SELECT * FROM `joomla_users`
1 × SELECT alias FROM joomla_content
1 × SELECT `data` FROM `joomla_session`
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 ( 102
1 × SELECT * FROM joomla_content
1 × SELECT a.title, a.alias FROM joomla_categories 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

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:1600935001;s:18:\"session.timer.last\";i:1600935001;s:17:\"session.timer.now\";i:1600935001;s:24:\"session.client.forwarded\";s:11:\"34.205.93.2\";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:11:\"34.205.93.2\";s:10:\"session_id\";s:32:\"aa63d6edbac6649fd54ab9ac17a5ef7b\";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 ('aa63d6edbac6649fd54ab9ac17a5ef7b', 0, '1600935001'
1 × DELETE FROM `joomla_session`