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

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

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

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

See the background paper of the e-discussion here

Joomla! Debug Console

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

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

Application 0.032 seconds (+0.007); 1.40 MB (+0.405) - afterRoute

Application 0.087 seconds (+0.055); 3.12 MB (+1.715) - afterDispatch

Application 0.090 seconds (+0.003); 3.17 MB (+0.047) - beforeRenderModule mod_custom (Mentions U.E. (EN))

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

Application 0.091 seconds (+0.000); 3.17 MB (-0.002) - beforeRenderModule mod_menu (Menu Footer EN)

Application 0.092 seconds (+0.001); 3.19 MB (+0.015) - afterRenderModule mod_menu (Menu Footer EN)

Application 0.092 seconds (+0.000); 3.18 MB (-0.003) - beforeRenderModule mod_custom (baseline EN)

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

Application 0.093 seconds (+0.000); 3.18 MB (-0.002) - beforeRenderModule mod_custom (News (lien))

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

Application 0.093 seconds (+0.000); 3.18 MB (-0.002) - beforeRenderModule mod_cck_list (News)

Application 0.187 seconds (+0.094); 3.62 MB (+0.440) - afterRenderModule mod_cck_list (News)

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

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

Application 0.188 seconds (+0.000); 3.59 MB (-0.001) - beforeRenderModule mod_menu (Newsletter)

Application 0.189 seconds (+0.001); 3.60 MB (+0.009) - afterRenderModule mod_menu (Newsletter)

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

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

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

Application 0.193 seconds (+0.001); 3.63 MB (+0.014) - afterRenderModule mod_search (Recherche)

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

Application 0.194 seconds (+0.001); 3.63 MB (+0.009) - afterRenderModule mod_menu (Navigation (EN))

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

Application 0.202 seconds (+0.007); 3.80 MB (+0.166) - afterRenderModule mod_languages (Language selector)

Application 0.202 seconds (+0.000); 3.79 MB (-0.003) - beforeRenderModule mod_custom (topline EN)

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

Application 0.204 seconds (+0.002); 3.83 MB (+0.030) - afterRender

134 Queries Logged

SELECT `data` FROM `joomla_session` WHERE `session_id` = 'd0f4ecba764577567713dd81cc45e81b'
DELETE FROM `joomla_session` WHERE `time` < '1555780231'
SELECT `session_id` FROM `joomla_session` WHERE `session_id` = 'd0f4ecba764577567713dd81cc45e81b' LIMIT 0, 1
INSERT INTO `joomla_session` (`session_id`, `client_id`, `time`) VALUES ('d0f4ecba764577567713dd81cc45e81b', 0, '1555791031')
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id FROM joomla_usergroups AS a LEFT JOIN joomla_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
SELECT id, rules FROM `joomla_viewlevels`
SELECT folder AS type, element AS name, params FROM joomla_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1) ORDER BY ordering
SELECT * FROM joomla_languages WHERE published=1 ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_cck'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM joomla_menu AS m LEFT JOIN joomla_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT a.storage_location, a.options FROM joomla_cck_core_searchs AS a WHERE a.name = "page_actualites"
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT id, home, template, s.params FROM joomla_template_styles as s LEFT JOIN joomla_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT a.rules FROM joomla_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM joomla_content AS a LEFT JOIN joomla_categories AS c on c.id = a.catid LEFT JOIN joomla_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM joomla_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN joomla_categories as parent ON parent.id = c.parent_id LEFT JOIN joomla_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM joomla_categories AS cat JOIN joomla_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.language in ('en-GB','*') AND (contact.language in ('en-GB','*') OR contact.language IS NULL) AND a.id = 139 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-04-20 20:10:31') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-04-20 20:10:31') AND (a.state = 1 OR a.state =2)
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM joomla_categories as c LEFT JOIN joomla_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM joomla_categories AS cat JOIN joomla_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=17 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
SELECT extension_id AS id, element AS "option", params, enabled FROM joomla_extensions WHERE `type` = 'component' AND `element` = 'com_tags'
SELECT `m`.`tag_id`,`t`.* FROM `joomla_contentitem_tag_map` AS m INNER JOIN `joomla_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 139 AND `t`.`published` = 1 AND t.access IN (1,1)
SELECT a.id, a.pk, a.pkb, a.cck, a.storage_location, a.store_id, b.id as type_id, b.alias as type_alias, b.indexed, b.options_content, b.options_intro, c.template as content_template, c.params as content_params, d.template as intro_template, d.params as intro_params, f.app as folder_app FROM joomla_cck_core AS a LEFT JOIN joomla_cck_core_types AS b ON b.name = a.cck LEFT JOIN joomla_template_styles AS c ON c.id = b.template_content LEFT JOIN joomla_template_styles AS d ON d.id = b.template_intro LEFT JOIN joomla_cck_core_folders AS f ON f.id = b.folder WHERE a.id = "188"
SELECT cc.*, c.label as label2, c.variation, c.link, c.link_options, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.position FROM joomla_cck_core_type_field AS c LEFT JOIN joomla_cck_core_types AS sc ON sc.id = c.typeid LEFT JOIN joomla_cck_core_fields AS cc ON cc.id = c.fieldid WHERE sc.name = "publication" AND sc.published = 1 AND c.client = "content" AND c.access IN (1,1) ORDER BY c.ordering ASC
SELECT * FROM joomla_cck_core_type_position AS a LEFT JOIN joomla_cck_core_types AS b ON b.id = a.typeid WHERE b.name = "publication" AND a.client ="content"
SHOW FULL COLUMNS FROM `joomla_content`
SELECT * FROM joomla_content WHERE `id` = '139'
SELECT a.title, a.alias FROM joomla_categories AS a WHERE a.id = 17
SELECT `t`.`id` FROM `joomla_tags` AS t INNER JOIN `joomla_contentitem_tag_map` AS m ON `m`.`tag_id` = `t`.`id` AND `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` IN ( 139)
SELECT `eunomad_plateforme` FROM `joomla_cck_store_item_content` WHERE `id`='139'
SELECT `u`.`name` FROM `joomla_content` as `c`, `joomla_users` as `u` WHERE `c`.`created_by` = `u`.`id` AND `c`.`id`='139'
SHOW FULL COLUMNS FROM `joomla_users`
SELECT * FROM `joomla_users` WHERE `id` = 139
SELECT a.* FROM joomla_cck_core_fields AS a WHERE a.name="art_attachment"
SELECT a.* FROM joomla_cck_core_fields AS a WHERE a.name="art_media"
UPDATE joomla_content SET hits = hits + 1 WHERE id = 139
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joomla_modules AS m LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joomla_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-04-20 20:10:31') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-04-20 20:10:31') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 153 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering
SELECT a.id, a.title, a.name, a.description, a.content, a.location, a.storage_location, b.app as folder_app, a.options, a.template_search, a.template_filter, a.template_list, a.template_item FROM joomla_cck_core_searchs AS a LEFT JOIN joomla_cck_core_folders AS b ON b.id = a.folder WHERE a.name ="liste_actualites" AND a.published = 1
SELECT DISTINCT a.*, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.live, c.live_options, c.live_value, c.markup_class, c.match_collection, c.match_mode, c.match_options, c.match_value, c.stage, c.access, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position FROM joomla_cck_core_fields AS a LEFT JOIN joomla_cck_core_search_field AS c ON c.fieldid = a.id LEFT JOIN joomla_cck_core_searchs AS b ON b.id = c.searchid WHERE b.name = "liste_actualites" AND c.client = "search" AND c.access IN (1,1) ORDER BY c.ordering ASC
SELECT DISTINCT a.*, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.live, c.live_options, c.live_value, c.markup_class, c.match_collection, c.match_mode, c.match_options, c.match_value, c.stage, c.access, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position FROM joomla_cck_core_fields AS a LEFT JOIN joomla_cck_core_search_field AS c ON c.fieldid = a.id LEFT JOIN joomla_cck_core_searchs AS b ON b.id = c.searchid WHERE b.name = "liste_actualites" AND c.client = " order" AND c.access IN (1,1) ORDER BY c.ordering ASC
SELECT a.id, a.template as name, a.params FROM joomla_template_styles AS a LEFT JOIN joomla_cck_core_templates AS b ON b.name = a.template WHERE a.id = 64 AND b.published = 1
SELECT a.position, a.client, a.legend, a.variation, a.variation_options, a.width, a.height, a.css FROM joomla_cck_core_search_position AS a WHERE a.searchid = 507 AND a.client ="search"
SELECT a.id, a.title, a.level FROM joomla_categories AS a WHERE a.parent_id > 0 AND extension = 'com_content' AND a.published IN (0,1) ORDER BY a.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.2') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.8') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.9') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.10') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.12') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.13') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.11') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.14') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.15') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.16') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.17') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.22') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.23') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM joomla_assets AS a LEFT JOIN joomla_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.24') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT title,name FROM joomla_cck_core_types WHERE published=1 ORDER BY title ASC
SELECT `id`, `description` FROM `joomla_cck_core_searchs` WHERE `name`='liste_actualites'
SELECT 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 <= '2019-04-20 20:10:31' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2019-04-20 20:10:31' ) 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 <= '2019-04-20 10:10:31' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2019-04-20 10:10:31' ) 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=153
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` FROM `joomla_content` AS `c` INNER JOIN `joomla_associations` AS `a` ON a.id = c.id AND a.context='com_content.item' INNER JOIN `joomla_associations` AS `a2` ON a.key = a2.key INNER JOIN `joomla_content` AS `c2` ON a2.id = c2.`id` INNER JOIN `joomla_categories` AS `ca` ON `c2`.`catid` = ca.id AND ca.extension = 'com_content' WHERE c.id =139
SELECT a.sef AS sef,a.lang_code AS lang_code FROM joomla_languages AS a
SELECT a.sef AS sef,a.lang_code AS lang_code FROM joomla_languages AS a
UPDATE `joomla_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1555791031;s:18:\"session.timer.last\";i:1555791031;s:17:\"session.timer.now\";i:1555791031;s:24:\"session.client.forwarded\";s:12:\"3.91.157.213\";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.91.157.213\";s:10:\"session_id\";s:32:\"d0f4ecba764577567713dd81cc45e81b\";s:12:\"where_clause\";s:45:\"session_id=\"d0f4ecba764577567713dd81cc45e81b\"\";s:3:\"gid\";i:25;}}' , `time` = '1555791031' WHERE `session_id` = 'd0f4ecba764577567713dd81cc45e81b'

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 c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM joomla_categories as c LEFT JOIN joomla_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM joomla_categories AS cat JOIN joomla_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT `m`.`tag_id`,`t`.* FROM `joomla_contentitem_tag_map` AS m INNER JOIN `joomla_tags` AS t ON `m`.`tag_id` = `t`.`id`
1 × SELECT 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 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.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 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 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 a.storage_location, a.options FROM joomla_cck_core_searchs AS a
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 ( 139
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:1555791031;s:18:\"session.timer.last\";i:1555791031;s:17:\"session.timer.now\";i:1555791031;s:24:\"session.client.forwarded\";s:12:\"3.91.157.213\";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.91.157.213\";s:10:\"session_id\";s:32:\"d0f4ecba764577567713dd81cc45e81b\";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 ('d0f4ecba764577567713dd81cc45e81b', 0, '1555791031'
1 × DELETE FROM `joomla_session`

News