ARTICLES
Le syndrome de Williams présenté par l'APAJH
Un dossier présenté par l'Association pour Adultes et Jeunes Handicapés
Un dossier présenté par l'Association pour Adultes et Jeunes Handicapés
Powered by Joomla!®
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
link ⇒ http://www.williams-france.org/index.php/bibliographie-et-sources/articles/129-les-troubles-visuo-constructifs
link ⇒ http://www.williams-france.org/index.php/bibliographie-et-sources/articles/127-dossier-syndrome-de-williams-par-l-apajh
session.token ⇒ f0051a084a66483a22aacc2f9c10e213
Application 0.000 seconds (+0.000); 0.59 MB (+0.594) - afterLoad
Application 0.061 seconds (+0.060); 4.38 MB (+3.791) - afterInitialise
Application 0.095 seconds (+0.034); 8.85 MB (+4.461) - afterRoute
Application 0.170 seconds (+0.075); 13.81 MB (+4.965) - afterDispatch
Application 0.174 seconds (+0.004); 14.11 MB (+0.295) - beforeRenderModule mod_custom (Mentions légales)
Application 0.176 seconds (+0.003); 14.15 MB (+0.044) - afterRenderModule mod_custom (Mentions légales)
Application 0.176 seconds (+0.000); 14.17 MB (+0.015) - beforeRenderModule mod_slideshowck (Partenaires)
Application 0.181 seconds (+0.005); 14.45 MB (+0.281) - afterRenderModule mod_slideshowck (Partenaires)
Application 0.181 seconds (+0.000); 14.38 MB (-0.069) - beforeRenderModule mod_custom (COORDONNÉES FÉDÉRATION)
Application 0.182 seconds (+0.000); 14.38 MB (+0.004) - afterRenderModule mod_custom (COORDONNÉES FÉDÉRATION)
Application 0.182 seconds (+0.000); 14.38 MB (-0.002) - beforeRenderModule mod_custom (DON)
Application 0.182 seconds (+0.000); 14.38 MB (+0.004) - afterRenderModule mod_custom (DON)
Application 0.182 seconds (+0.000); 14.38 MB (+0.000) - beforeRenderModule mod_jbox_addthis (mod_jbox_addthis)
Application 0.184 seconds (+0.003); 14.41 MB (+0.027) - afterRenderModule mod_jbox_addthis (mod_jbox_addthis)
Application 0.185 seconds (+0.000); 14.41 MB (-0.002) - beforeRenderModule mod_allevents (AGENDA)
Application 0.278 seconds (+0.094); 21.19 MB (+6.785) - afterRenderModule mod_allevents (AGENDA)
Application 0.278 seconds (+0.000); 21.17 MB (-0.022) - beforeRenderModule mod_banners (Bannière 4)
Application 0.285 seconds (+0.007); 21.32 MB (+0.150) - afterRenderModule mod_banners (Bannière 4)
Application 0.285 seconds (+0.000); 21.36 MB (+0.034) - beforeRenderModule mod_maximenuck (Menu)
Application 0.318 seconds (+0.032); 22.13 MB (+0.774) - afterRenderModule mod_maximenuck (Menu)
Application 0.318 seconds (+0.000); 22.05 MB (-0.086) - beforeRenderModule mod_breadcrumbs (Fil de navigation)
Application 0.323 seconds (+0.005); 22.07 MB (+0.026) - afterRenderModule mod_breadcrumbs (Fil de navigation)
Application 0.323 seconds (+0.001); 22.11 MB (+0.034) - beforeRenderModule mod_maximenuck (Menu Haut)
Application 0.342 seconds (+0.019); 22.38 MB (+0.278) - afterRenderModule mod_maximenuck (Menu Haut)
Application 0.349 seconds (+0.007); 22.41 MB (+0.023) - afterRender
22.26 MB (23,338,888 Bytes)
SELECT `data`
FROM `aswb_session`
WHERE `session_id` = 'b51bf7c496a8656509eb2ef6433afc55'
SELECT `session_id`
FROM `aswb_session`
WHERE `session_id` = 'b51bf7c496a8656509eb2ef6433afc55'
LIMIT 0, 1
INSERT INTO `aswb_session`
(`session_id`, `client_id`, `time`)
VALUES
('b51bf7c496a8656509eb2ef6433afc55', 0, '1618332512')
SELECT extension_id AS id, element AS "option", params, enabled
FROM aswb_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM aswb_usergroups AS a
LEFT JOIN aswb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `aswb_viewlevels`
SELECT folder AS type, element AS name, params
FROM aswb_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM aswb_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
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 aswb_menu AS m
LEFT JOIN aswb_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 aswb_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM aswb_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM aswb_template_styles as s
LEFT JOIN aswb_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 aswb_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM aswb_assets AS a
LEFT JOIN aswb_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 c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM aswb_categories as c
LEFT JOIN aswb_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 aswb_categories AS cat JOIN aswb_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
LEFT JOIN `aswb_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=50
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
ORDER BY c.lft
SELECT b.rules
FROM aswb_assets AS a
LEFT JOIN aswb_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.50')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM aswb_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) 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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM aswb_content AS a
LEFT JOIN aswb_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN aswb_categories AS c
ON c.id = a.catid
LEFT JOIN aswb_users AS ua
ON ua.id = a.created_by
LEFT JOIN aswb_users AS uam
ON uam.id = a.modified_by
LEFT JOIN aswb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN aswb_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM aswb_categories AS cat JOIN aswb_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 a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 50
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-13 16:48:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-13 16:48:32')
ORDER BY c.lft, a.ordering, a.created
LIMIT 0, 10
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM aswb_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) 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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM aswb_content AS a
LEFT JOIN aswb_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN aswb_categories AS c
ON c.id = a.catid
LEFT JOIN aswb_users AS ua
ON ua.id = a.created_by
LEFT JOIN aswb_users AS uam
ON uam.id = a.modified_by
LEFT JOIN aswb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN aswb_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM aswb_categories AS cat JOIN aswb_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 a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 50
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-13 16:48:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-13 16:48:32')
ORDER BY c.lft, a.ordering, a.created
SELECT `name`, `value`
FROM `aswb_jsn_imageshow_config`
WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')
SELECT *
FROM aswb_extensions
WHERE element='com_imageshow'
AND type='component'
SELECT extension_id AS id, element AS "option", params, enabled
FROM aswb_extensions
WHERE `type` = 'component'
AND `element` = 'com_imageshow'
SELECT *
FROM aswb_extensions
WHERE element='com_imageshow'
AND type='component'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM aswb_categories as c
LEFT JOIN aswb_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 aswb_categories AS cat JOIN aswb_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=50
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
ORDER BY c.lft
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM aswb_modules AS m
LEFT JOIN aswb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN aswb_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 <= '2021-04-13 16:48:32')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-13 16:48:32')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 217 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM aswb_extensions
WHERE `type` = 'component'
AND `element` = 'com_allevents'
SHOW TABLES
SHOW FULL COLUMNS
FROM `aswb_allevents_settings`
SELECT *
FROM aswb_allevents_settings
ORDER BY id ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROM aswb_extensions
WHERE `type` = 'component'
AND `element` = 'com_media'
SHOW TABLES
SHOW FULL COLUMNS
FROM `aswb_contact_details`
SELECT `id`, `name`, `catid`
FROM aswb_contact_details
WHERE (`user_id`=999999999)
ORDER BY id ASC
SHOW FULL COLUMNS
FROM `aswb_allevents_groups`
SELECT *
FROM `aswb_allevents_groups`
WHERE (`id` in (8))
ORDER BY `id` ASC
SHOW FULL COLUMNS
FROM `aswb_allevents_activities`
SELECT activity.titre, activity.agenda_id, image_bullet, activity.description, activity.intro, activity.lastmod, count(event.id) As nbr_events, activity.ordering, activity.vignette, activity.access, activity.published, activity.id, activity.alias
FROM `aswb_allevents_activities` activity
LEFT JOIN `aswb_allevents_events` event
ON (activity.id = event.activity_id)
AND (event.deleted=0)
WHERE (`activity`.`deleted`=0)
AND (`activity`.`access` in (0,1))
AND (`activity`.`deleted`=0)
GROUP BY `activity`.`id`
ORDER BY `id` ASC
LIMIT 0, 9223372036854775807
SHOW FULL COLUMNS
FROM `aswb_allevents_public`
SELECT public.titre, public.agenda_id, image_bullet,count(event.id) As nbr_events, public.vignette, public.lastmod, public.ordering, public.access, public.published, public.id, public.alias, public.description, public.intro
FROM `aswb_allevents_public` public
LEFT JOIN `aswb_allevents_events` event
ON (public.id = event.public_id)
AND (event.deleted=0)
WHERE (`public`.`deleted`=0)
AND (`public`.`access` in (0,1))
AND (`public`.`deleted`=0)
GROUP BY `public`.`id`
ORDER BY `id` ASC
LIMIT 0, 9223372036854775807
SHOW FULL COLUMNS
FROM `aswb_allevents_sections`
SELECT sections.titre, sections.agenda_id, sections.image_bullet, sections.lastmod, count(categories.id) As nbr_items, COALESCE(event.nbr_events, 0) as nbr_events,sections.vignette, sections.ordering, sections.access, sections.published, sections.id, sections.alias,sections.description,sections.intro
FROM `aswb_allevents_sections` sections
LEFT JOIN (SELECT section_id, count(id) As nbr_events
FROM `aswb_allevents_events`
WHERE (`deleted`=0)
GROUP BY section_id) event
ON sections.id = event.section_id
LEFT JOIN `aswb_allevents_categories` categories
ON sections.id = categories.section_id
AND (categories.deleted=0)
WHERE (`sections`.`deleted`=0)
AND (`sections`.`access` in (0,1))
AND (`sections`.`deleted`=0)
GROUP BY `sections`.`id`
ORDER BY `id` ASC
LIMIT 0, 9223372036854775807
SHOW FULL COLUMNS
FROM `aswb_allevents_categories`
SELECT categories.titre, sections.agenda_id, categories.section_id,categories.image_bullet, categories.lastmod, COALESCE(event.nbr_events, 0) as nbr_events, categories.vignette, categories.ordering, categories.access, categories.published, categories.id, categories.alias, categories.description,categories.intro
FROM `aswb_allevents_categories` categories
LEFT JOIN (SELECT category_id, count(id) As nbr_events
FROM `aswb_allevents_events`
WHERE (`deleted`=0)
GROUP BY category_id) event
ON categories.id = event.category_id
LEFT JOIN `aswb_allevents_sections` sections
ON categories.section_id = sections.id
WHERE (`categories`.`deleted`=0)
AND (sections.`deleted`=0)
AND (`categories`.`access` in (0,1))
AND (`categories`.`deleted`=0)
GROUP BY `categories`.`id`
ORDER BY `id` ASC
LIMIT 0, 9223372036854775807
SHOW FULL COLUMNS
FROM `aswb_allevents_places`
SELECT places.titre, places.agenda_id, pays, `latitude`, `longitude`, `image_bullet`, count(event.id) As nbr_events, places.vignette, places.lastmod, places.ordering, places.access, showmap, places.published, places.id, places.alias, places.description, places.intro
FROM `aswb_allevents_places` places
LEFT JOIN `aswb_allevents_events` event
ON (places.id = event.place_id)
AND (event.deleted=0)
WHERE (`places`.`deleted`=0)
AND (`places`.`access` in (0,1))
AND (`places`.`deleted`=0)
GROUP BY `places`.`id`
ORDER BY `id` ASC
LIMIT 0, 9223372036854775807
SHOW FULL COLUMNS
FROM `aswb_allevents_events`
SELECT event.titre, event.agenda_id, public_id, activity_id, section_id, category_id, event.vignette, affiche, hot, event.intro, intern_album_id, event.ressource_id, place_id, pays, enrolment_enabled, enrolments.nbr_items, enrolments.last_enrol_date, ranking.id as rank_id, enrolment_max_participant,
CASE WHEN (enrolment_enabled=1) THEN (
CASE WHEN (enrolment_max_participant>0) THEN (enrolment_max_participant -
CASE WHEN COALESCE(enrol_definitive.nbr_enroldef,0)>enrolment_max_participant THEN enrolment_max_participant ELSE COALESCE(enrol_definitive.nbr_enroldef,0) END ) ELSE -99 END) ELSE -999 END as remaining_place, date, enddate, openingdate, closingdate, expirationdate, event.lastmod, proposal, event.cancelled, event.hits, event.access, event.published, event.proposed_by, event.adminLock, event.ordering, event.id, event.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, event.created_date, event.showreadmore
FROM `aswb_allevents_events` event
LEFT JOIN
(SELECT event_id, count(id) as nbr_items, max(lastmod) as last_enrol_date
FROM `aswb_allevents_enrolments`
WHERE (`deleted`=0)
GROUP BY event_id) as enrolments
ON event.id = enrolments.event_id
LEFT JOIN
(SELECT event_id, count(id) as nbr_enroldef
FROM `aswb_allevents_enrolments`
WHERE (`deleted`=0)
AND (`enroltype`=0)
AND (`pending`=0)
GROUP BY event_id) as enrol_definitive
ON event.id = enrol_definitive.event_id
LEFT JOIN
(SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id
FROM `aswb_allevents_links` links
LEFT JOIN `aswb_allevents_ressources` ressources
ON links.ressource_id = ressources.id
WHERE (`type`='1')
AND (`links`.`deleted`=0)
GROUP BY ressources.id) as ranking
ON event.ressource_id = ranking.ressource_id
LEFT JOIN
(SELECT links.id, links.tooltip, links.url, ressources.id as ressource_id
FROM `aswb_allevents_links` links
LEFT JOIN `aswb_allevents_ressources` ressources
ON links.ressource_id = ressources.id
WHERE (`type`='2')
AND (`links`.`deleted`=0)
GROUP BY ressources.id) as enrolment
ON event.ressource_id = enrolment.ressource_id
LEFT JOIN `aswb_allevents_agenda` agenda
ON (event.agenda_id = agenda.id)
AND (agenda.`deleted`=0)
LEFT JOIN `aswb_allevents_places` places
ON (event.place_id = places.id)
AND (places.`deleted`=0)
WHERE (`event`.`deleted`=0)
AND ( (isnull(`agenda`.`published`)) OR ( (`agenda`.`published`=1)
AND (`agenda`.`access` in (0,1)) ) )
AND ((`event`.publishingdate='0000-00-00 00:00:00') OR (ISNULL(`event`.publishingdate)) OR (`event`.publishingdate<= '2021-04-13 16:48:32'))
AND ((`event`.expirationdate='0000-00-00 00:00:00') OR (ISNULL(`event`.expirationdate)) OR (`event`.expirationdate>= '2021-04-13 16:48:32'))
AND (`date` >='2021-04-13 00:00:00')
AND (`event`.`published`=1)
AND (`event`.`access` in (0,1))
AND (`event`.`deleted`=0)
GROUP BY `event`.`id`
ORDER BY date ASC
LIMIT 0, 10
SHOW FULL COLUMNS
FROM `aswb_allevents_agenda`
SELECT `id`, `titre` as value, `couleur`, `couleur_texte`, `image_bullet`, `template`, `vignette`, `contact_id`, `access`, `alias`
FROM aswb_allevents_agenda
WHERE (`deleted`=0)
ORDER BY `id` ASC
SELECT `id`, `titre` as value, `couleur`, `couleur_texte`, `image_bullet`, `alias`
FROM aswb_allevents_activities
WHERE (`deleted`=0)
ORDER BY `id` ASC
SELECT `id`, `titre` as value, `image_bullet`, `alias`
FROM aswb_allevents_public
WHERE (`deleted`=0)
ORDER BY `id` ASC
SELECT `id`, `titre` as value, `image_bullet`, `agenda_id`, `alias`
FROM aswb_allevents_sections
WHERE (`deleted`=0)
ORDER BY `id` ASC
SELECT `id`, `titre` as value, `image_bullet`, `alias`
FROM aswb_allevents_categories
WHERE (`deleted`=0)
ORDER BY `id` ASC
SELECT `id`, `titre` as value, `couleur`, `couleur_texte`, `image_bullet`, `template`, `vignette`, `contact_id`, `access`, `alias`
FROM aswb_allevents_agenda
WHERE (`deleted`=0)
ORDER BY `id` ASC
SELECT `id`, `titre` as value, `couleur`, `couleur_texte`, `image_bullet`, `template`, `vignette`, `contact_id`, `access`, `alias`
FROM aswb_allevents_agenda
WHERE (`deleted`=0)
ORDER BY `id` ASC
SELECT `id`, `titre` as value, `couleur`, `couleur_texte`, `image_bullet`, `template`, `vignette`, `contact_id`, `access`, `alias`
FROM aswb_allevents_agenda
WHERE (`deleted`=0)
ORDER BY `id` ASC
SELECT *
FROM aswb_banners
WHERE '2021-04-13 16:48:32' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM aswb_banners as a
LEFT JOIN aswb_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN aswb_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 4
AND cl.state = 1
AND a.catid IN (104)
ORDER BY a.sticky DESC,a.ordering
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM aswb_banners as a
LEFT JOIN aswb_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN aswb_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 4
AND cl.state = 1
AND a.catid IN (104)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5
SELECT *
FROM aswb_modules
WHERE published=1
ORDER BY id
;
SELECT *
FROM aswb_modules
WHERE published=1
ORDER BY id
;
SELECT extension_id AS id, element AS "option", params, enabled
FROM aswb_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM aswb_categories as c
LEFT JOIN aswb_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 aswb_categories AS cat JOIN aswb_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=2
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
ORDER BY c.lft
UPDATE `aswb_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618332512;s:18:\"session.timer.last\";i:1618332512;s:17:\"session.timer.now\";i:1618332512;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\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:8:\"usertype\";N;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:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:2:{s:40:\"1cef1501c70bcf47aeeb7fc0c836b7358e89e7b3\";O:8:\"stdClass\":2:{s:4:\"link\";s:110:\"http://www.williams-france.org/index.php/bibliographie-et-sources/articles/129-les-troubles-visuo-constructifs\";s:6:\"expiry\";i:1618332512;}s:40:\"8e62f86f95f75ac16e5ef3dce46e4aad7844a54b\";O:8:\"stdClass\":2:{s:4:\"link\";s:119:\"http://www.williams-france.org/index.php/bibliographie-et-sources/articles/127-dossier-syndrome-de-williams-par-l-apajh\";s:6:\"expiry\";i:1618332512;}}s:13:\"session.token\";s:32:\"f0051a084a66483a22aacc2f9c10e213\";}'
, `time` = '1618332513'
WHERE `session_id` = 'b51bf7c496a8656509eb2ef6433afc55'
7 × SELECT extension_id AS id, element AS "option", params, enabled
FROM aswb_extensions
4 × SELECT `id`, `titre` as value, `couleur`, `couleur_texte`, `image_bullet`, `template`, `vignette`, `contact_id`, `access`, `alias`
FROM aswb_allevents_agenda
2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM aswb_contact_details AS contact
2 × SELECT *
FROM aswb_extensions
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM aswb_categories as c
LEFT JOIN aswb_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 aswb_categories AS cat JOIN aswb_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
2 × SELECT *
FROM aswb_modules
2 × SELECT b.rules
FROM aswb_assets AS a
LEFT JOIN aswb_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM aswb_banners as a
LEFT JOIN aswb_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN aswb_categories as cat
ON a.catid = cat.id
1 × SELECT *
FROM aswb_banners
1 × SELECT categories.titre, sections.agenda_id, categories.section_id,categories.image_bullet, categories.lastmod, COALESCE(event.nbr_events, 0) as nbr_events, categories.vignette, categories.ordering, categories.access, categories.published, categories.id, categories.alias, categories.description,categories.intro
FROM `aswb_allevents_categories` categories
LEFT JOIN (SELECT category_id, count(id) As nbr_events
FROM `aswb_allevents_events`
1 × SELECT sections.titre, sections.agenda_id, sections.image_bullet, sections.lastmod, count(categories.id) As nbr_items, COALESCE(event.nbr_events, 0) as nbr_events,sections.vignette, sections.ordering, sections.access, sections.published, sections.id, sections.alias,sections.description,sections.intro
FROM `aswb_allevents_sections` sections
LEFT JOIN (SELECT section_id, count(id) As nbr_events
FROM `aswb_allevents_events`
1 × SELECT public.titre, public.agenda_id, image_bullet,count(event.id) As nbr_events, public.vignette, public.lastmod, public.ordering, public.access, public.published, public.id, public.alias, public.description, public.intro
FROM `aswb_allevents_public` public
LEFT JOIN `aswb_allevents_events` event
ON (public.id = event.public_id)
AND (event.deleted=0)
1 × SELECT places.titre, places.agenda_id, pays, `latitude`, `longitude`, `image_bullet`, count(event.id) As nbr_events, places.vignette, places.lastmod, places.ordering, places.access, showmap, places.published, places.id, places.alias, places.description, places.intro
FROM `aswb_allevents_places` places
LEFT JOIN `aswb_allevents_events` event
ON (places.id = event.place_id)
AND (event.deleted=0)
1 × SELECT `id`, `titre` as value, `image_bullet`, `alias`
FROM aswb_allevents_categories
1 × SELECT `id`, `titre` as value, `couleur`, `couleur_texte`, `image_bullet`, `alias`
FROM aswb_allevents_activities
1 × SELECT activity.titre, activity.agenda_id, image_bullet, activity.description, activity.intro, activity.lastmod, count(event.id) As nbr_events, activity.ordering, activity.vignette, activity.access, activity.published, activity.id, activity.alias
FROM `aswb_allevents_activities` activity
LEFT JOIN `aswb_allevents_events` event
ON (activity.id = event.activity_id)
AND (event.deleted=0)
1 × SELECT `id`, `titre` as value, `image_bullet`, `agenda_id`, `alias`
FROM aswb_allevents_sections
1 × SELECT event.titre, event.agenda_id, public_id, activity_id, section_id, category_id, event.vignette, affiche, hot, event.intro, intern_album_id, event.ressource_id, place_id, pays, enrolment_enabled, enrolments.nbr_items, enrolments.last_enrol_date, ranking.id as rank_id, enrolment_max_participant,
CASE WHEN (enrolment_enabled=1) THEN (
CASE WHEN (enrolment_max_participant>0) THEN (enrolment_max_participant -
CASE WHEN COALESCE(enrol_definitive.nbr_enroldef,0)>enrolment_max_participant THEN enrolment_max_participant ELSE COALESCE(enrol_definitive.nbr_enroldef,0) END ) ELSE -99 END) ELSE -999 END as remaining_place, date, enddate, openingdate, closingdate, expirationdate, event.lastmod, proposal, event.cancelled, event.hits, event.access, event.published, event.proposed_by, event.adminLock, event.ordering, event.id, event.alias, ranking.url as rank_url, ranking.tooltip as rank_tooltip, enrolment.url as enrolment_url, enrolment.tooltip as enrolment_tooltip, event.created_date, event.showreadmore
FROM `aswb_allevents_events` event
LEFT JOIN
(SELECT event_id, count(id) as nbr_items, max(lastmod) as last_enrol_date
FROM `aswb_allevents_enrolments`
1 × SELECT `id`, `titre` as value, `image_bullet`, `alias`
FROM aswb_allevents_public
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM aswb_modules AS m
LEFT JOIN aswb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN aswb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM aswb_menu AS m
LEFT JOIN aswb_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM aswb_languages
1 × SELECT folder AS type, element AS name, params
FROM aswb_extensions
1 × SELECT id, rules
FROM `aswb_viewlevels
1 × SELECT `session_id`
FROM `aswb_session`
1 × SELECT b.id
FROM aswb_usergroups AS a
LEFT JOIN aswb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, home, template, s.params
FROM aswb_template_styles as s
LEFT JOIN aswb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT a.rules
FROM aswb_assets AS a
1 × SELECT *
FROM aswb_allevents_settings
1 × SELECT `id`, `name`, `catid`
FROM aswb_contact_details
1 × SELECT `data`
FROM `aswb_session`
1 × SELECT `name`, `value`
FROM `aswb_jsn_imageshow_config`
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM aswb_categories as c
LEFT JOIN aswb_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 aswb_categories AS cat JOIN aswb_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM `aswb_allevents_groups`
2 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_places
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_categories
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_events
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_agenda
1 × UPDATE `aswb_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618332512;s:18:\"session.timer.last\";i:1618332512;s:17:\"session.timer.now\";i:1618332512;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\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:8:\"usertype\";N;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:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:2:{s:40:\"1cef1501c70bcf47aeeb7fc0c836b7358e89e7b3\";O:8:\"stdClass\":2:{s:4:\"link\";s:110:\"http://www.williams-france.org/index.php/bibliographie-et-sources/articles/129-les-troubles-visuo-constructifs\";s:6:\"expiry\";i:1618332512;}s:40:\"8e62f86f95f75ac16e5ef3dce46e4aad7844a54b\";O:8:\"stdClass\":2:{s:4:\"link\";s:119:\"http://www.williams-france.org/index.php/bibliographie-et-sources/articles/127-dossier-syndrome-de-williams-par-l-apajh\";s:6:\"expiry\";i:1618332512;}}s:13:\"session.token\";s:32:\"f0051a084a66483a22aacc2f9c10e213\";}' , `time` = '1618332513'
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_sections
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_public
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_settings
1 × SHOW FULL COLUMNS
FROM `aswb_contact_details
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_groups
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_activities
1 × INSERT INTO `aswb_session` (`session_id`, `client_id`, `time`)
VALUES ('b51bf7c496a8656509eb2ef6433afc55', 0, '1618332512'