Study on capitalisation of European decentralized cooperation experiences

The European Commission has funded a study on decentralised cooperation in EU Member states for the period 2007-2013.

This report, produced by 'Business and Strategies Europe' in April 2013, provides an overview of this phenomena which has increased significantly the past few years, of its aims, stakeholders and trends. One must note that not all European countries have the same vision of decentralised cooperation and the way it works; this report focuses on decentralised cooperation as a partnership between European local authorities and local authorities in partner countries.

Furthermore, this study presents an analysis of the CE financial instruments, as well as of European strategies and those of Member States in the field of decentralised cooperation. Finally, a list of recommandations intended for the EC is given.

Download the study

Joomla! Debug Console

Application 0.000 seconds (+0.000); 0.48 MB (+0.485) - afterLoad

Application 0.074 seconds (+0.074); 3.38 MB (+2.890) - afterInitialise

Application 0.087 seconds (+0.013); 4.05 MB (+0.680) - afterRoute

Application 0.316 seconds (+0.229); 9.75 MB (+5.695) - afterDispatch

Application 0.323 seconds (+0.007); 9.87 MB (+0.116) - beforeRenderModule mod_custom (Mentions U.E. (EN))

Application 0.327 seconds (+0.003); 9.88 MB (+0.018) - afterRenderModule mod_custom (Mentions U.E. (EN))

Application 0.327 seconds (+0.000); 9.88 MB (-0.002) - beforeRenderModule mod_menu (Menu Footer EN)

Application 0.332 seconds (+0.005); 9.94 MB (+0.053) - afterRenderModule mod_menu (Menu Footer EN)

Application 0.332 seconds (+0.000); 9.93 MB (-0.004) - beforeRenderModule mod_custom (baseline EN)

Application 0.332 seconds (+0.000); 9.94 MB (+0.003) - afterRenderModule mod_custom (baseline EN)

Application 0.332 seconds (+0.000); 9.93 MB (-0.002) - beforeRenderModule mod_custom (News (lien))

Application 0.333 seconds (+0.000); 9.94 MB (+0.003) - afterRenderModule mod_custom (News (lien))

Application 0.333 seconds (+0.000); 9.94 MB (-0.002) - beforeRenderModule mod_cck_list (News)

Application 0.497 seconds (+0.164); 10.80 MB (+0.863) - afterRenderModule mod_cck_list (News)

Application 0.497 seconds (+0.000); 10.76 MB (-0.033) - beforeRenderModule mod_custom (Facebook)

Application 0.497 seconds (+0.000); 10.77 MB (+0.003) - afterRenderModule mod_custom (Facebook)

Application 0.498 seconds (+0.000); 10.77 MB (-0.001) - beforeRenderModule mod_menu (Newsletter)

Application 0.500 seconds (+0.002); 10.78 MB (+0.014) - afterRenderModule mod_menu (Newsletter)

Application 0.500 seconds (+0.000); 10.78 MB (-0.003) - beforeRenderModule mod_menu (Submenu (EN))

Application 0.503 seconds (+0.003); 10.80 MB (+0.019) - afterRenderModule mod_menu (Submenu (EN))

Application 0.504 seconds (+0.000); 10.79 MB (-0.003) - beforeRenderModule mod_search (Recherche)

Application 0.507 seconds (+0.004); 10.81 MB (+0.017) - afterRenderModule mod_search (Recherche)

Application 0.507 seconds (+0.000); 10.81 MB (-0.005) - beforeRenderModule mod_menu (Navigation (EN))

Application 0.509 seconds (+0.002); 10.82 MB (+0.009) - afterRenderModule mod_menu (Navigation (EN))

Application 0.509 seconds (+0.000); 10.81 MB (-0.004) - beforeRenderModule mod_languages (Language selector)

Application 0.524 seconds (+0.015); 11.05 MB (+0.234) - afterRenderModule mod_languages (Language selector)

Application 0.524 seconds (+0.000); 11.04 MB (-0.003) - beforeRenderModule mod_custom (topline EN)

Application 0.524 seconds (+0.000); 11.05 MB (+0.003) - afterRenderModule mod_custom (topline EN)

Application 0.527 seconds (+0.003); 11.10 MB (+0.052) - afterRender

133 Queries Logged

SELECT `data` FROM `joomla_session` WHERE `session_id` = '93af037ccbcc302bdb8e30ec2d1419d2'
DELETE FROM `joomla_session` WHERE `time` < '1594790759'
SELECT `session_id` FROM `joomla_session` WHERE `session_id` = '93af037ccbcc302bdb8e30ec2d1419d2' LIMIT 0, 1
INSERT INTO `joomla_session` (`session_id`, `client_id`, `time`) VALUES ('93af037ccbcc302bdb8e30ec2d1419d2', 0, '1594801559')
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 = "recherche_ressources_externes"
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 = 123 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-07-15 08:25:59') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-07-15 08:25:59') 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=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 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` = 123 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 = "170"
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` = '123'
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 ( 123)
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='123'
SHOW FULL COLUMNS FROM `joomla_users`
SELECT * FROM `joomla_users` WHERE `id` = 123
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 = 123
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-07-15 08:25:59') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-07-15 08:25:59') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 127 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-07-15 08:25:59' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2020-07-15 08:25:59' ) 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-07-15 10:25:59' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2020-07-15 10:25:59' ) 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=127
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 =123
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:1594801559;s:18:\"session.timer.last\";i:1594801559;s:17:\"session.timer.now\";i:1594801559;s:24:\"session.client.forwarded\";s:12:\"3.227.235.23\";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:12:\"3.227.235.23\";s:10:\"session_id\";s:32:\"93af037ccbcc302bdb8e30ec2d1419d2\";s:12:\"where_clause\";s:45:\"session_id=\"93af037ccbcc302bdb8e30ec2d1419d2\"\";s:3:\"gid\";i:25;}}' , `time` = '1594801559' WHERE `session_id` = '93af037ccbcc302bdb8e30ec2d1419d2'

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 `key` FROM `joomla_associations`
12 × SELECT c.`title`, c.`alias`, c.`introtext`, c.`language`, c.`created` FROM `joomla_content` as c
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.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 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 `u`.`name` FROM `joomla_content` as `c`, `joomla_users` as `u`
2 × SELECT a.* FROM joomla_cck_core_fields AS a
2 × SELECT a.sef AS sef,a.lang_code AS lang_code FROM joomla_languages AS
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 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 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 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 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 storage_location, storage_table FROM joomla_cck_core
1 × SELECT * FROM `joomla_users`
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 a.rules FROM joomla_assets AS a
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.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 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 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 ( 123
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:1594801559;s:18:\"session.timer.last\";i:1594801559;s:17:\"session.timer.now\";i:1594801559;s:24:\"session.client.forwarded\";s:12:\"3.227.235.23\";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:12:\"3.227.235.23\";s:10:\"session_id\";s:32:\"93af037ccbcc302bdb8e30ec2d1419d2\";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 ('93af037ccbcc302bdb8e30ec2d1419d2', 0, '1594801559'
1 × DELETE FROM `joomla_session`

External resources