Inclusion des personnes atteintes d'une maladie rare
L'Alliance Maladies Rares diffuse un petit film sur l'inclusion de personnes atteintes d'une maladie rare.
L'Alliance Maladies Rares diffuse un petit film sur l'inclusion de personnes atteintes d'une maladie rare.
Powered by Joomla!®
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
link ⇒ http://williams-france.org/index.php/divers/309-inclusion-maladies-rares
session.token ⇒ 9e9f7ac3eb1472af0676af84ae86f659
Application 0.000 seconds (+0.000); 0.59 MB (+0.594) - afterLoad
Application 0.040 seconds (+0.040); 4.38 MB (+3.791) - afterInitialise
Application 0.094 seconds (+0.054); 9.00 MB (+4.618) - afterRoute
Application 0.157 seconds (+0.062); 13.30 MB (+4.296) - afterDispatch
Application 0.161 seconds (+0.004); 13.60 MB (+0.301) - beforeRenderModule mod_custom (Mentions légales)
Application 0.164 seconds (+0.003); 13.64 MB (+0.044) - afterRenderModule mod_custom (Mentions légales)
Application 0.164 seconds (+0.000); 13.66 MB (+0.015) - beforeRenderModule mod_slideshowck (Partenaires)
Application 0.169 seconds (+0.005); 13.96 MB (+0.296) - afterRenderModule mod_slideshowck (Partenaires)
Application 0.169 seconds (+0.000); 13.89 MB (-0.068) - beforeRenderModule mod_custom (COORDONNÉES FÉDÉRATION)
Application 0.169 seconds (+0.000); 13.89 MB (+0.004) - afterRenderModule mod_custom (COORDONNÉES FÉDÉRATION)
Application 0.169 seconds (+0.000); 13.89 MB (-0.002) - beforeRenderModule mod_custom (DON)
Application 0.169 seconds (+0.000); 13.89 MB (+0.004) - afterRenderModule mod_custom (DON)
Application 0.169 seconds (+0.000); 13.89 MB (+0.000) - beforeRenderModule mod_jbox_addthis (mod_jbox_addthis)
Application 0.173 seconds (+0.003); 13.92 MB (+0.027) - afterRenderModule mod_jbox_addthis (mod_jbox_addthis)
Application 0.173 seconds (+0.000); 13.92 MB (-0.002) - beforeRenderModule mod_allevents (AGENDA)
Application 0.282 seconds (+0.109); 20.83 MB (+6.910) - afterRenderModule mod_allevents (AGENDA)
Application 0.282 seconds (+0.000); 20.81 MB (-0.022) - beforeRenderModule mod_banners (Bannière 4)
Application 0.291 seconds (+0.009); 21.01 MB (+0.207) - afterRenderModule mod_banners (Bannière 4)
Application 0.291 seconds (+0.000); 21.05 MB (+0.034) - beforeRenderModule mod_maximenuck (Menu)
Application 0.327 seconds (+0.036); 21.82 MB (+0.774) - afterRenderModule mod_maximenuck (Menu)
Application 0.327 seconds (+0.000); 21.74 MB (-0.085) - beforeRenderModule mod_breadcrumbs (Fil de navigation)
Application 0.332 seconds (+0.005); 21.76 MB (+0.025) - afterRenderModule mod_breadcrumbs (Fil de navigation)
Application 0.332 seconds (+0.001); 21.80 MB (+0.034) - beforeRenderModule mod_maximenuck (Menu Haut)
Application 0.352 seconds (+0.020); 22.07 MB (+0.278) - afterRenderModule mod_maximenuck (Menu Haut)
Application 0.363 seconds (+0.011); 22.09 MB (+0.021) - afterRender
21.94 MB (23,008,744 Bytes)
SELECT `data`
FROM `aswb_session`
WHERE `session_id` = '9d27a6f0e00464b18db9b267c439f2b4'
DELETE
FROM `aswb_session`
WHERE `time` < '1618323991'
SELECT `session_id`
FROM `aswb_session`
WHERE `session_id` = '9d27a6f0e00464b18db9b267c439f2b4'
LIMIT 0, 1
INSERT INTO `aswb_session`
(`session_id`, `client_id`, `time`)
VALUES
('9d27a6f0e00464b18db9b267c439f2b4', 0, '1618334791')
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 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=309
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 alias, catid
FROM aswb_content
WHERE id = 309
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 a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, 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,(
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
FROM aswb_content AS a
LEFT JOIN aswb_categories AS c
on c.id = a.catid
LEFT JOIN aswb_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 309
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-13 17:26:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-13 17:26:32')
AND (a.state = 1 OR a.state =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
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=93
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 `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 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.article.309')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.language,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM aswb_content AS a
LEFT JOIN aswb_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 93
AND a.state = 1
AND a.access = 1
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-04-13 17:26:32')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-04-13 17:26:32')
ORDER BY a.ordering
UPDATE aswb_content
SET hits = hits + 1
WHERE id = 309
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 17:26:32')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-13 17:26:32')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 306 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 17:26:32'))
AND ((`event`.expirationdate='0000-00-00 00:00:00') OR (ISNULL(`event`.expirationdate)) OR (`event`.expirationdate>= '2021-04-13 17:26: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 17:26: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:1618334791;s:18:\"session.timer.last\";i:1618334791;s:17:\"session.timer.now\";i:1618334791;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:1:{s:40:\"71786533c403b4b66697a80a84f95167f887dfa8\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://williams-france.org/index.php/divers/309-inclusion-maladies-rares\";s:6:\"expiry\";i:1618334792;}}s:13:\"session.token\";s:32:\"9e9f7ac3eb1472af0676af84ae86f659\";}'
, `time` = '1618334792'
WHERE `session_id` = '9d27a6f0e00464b18db9b267c439f2b4'
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
3 × 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 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
2 × SELECT *
FROM aswb_modules
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 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 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 *
FROM `aswb_allevents_groups`
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 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 `id`, `titre` as value, `couleur`, `couleur_texte`, `image_bullet`, `alias`
FROM aswb_allevents_activities
1 × SELECT `id`, `titre` as value, `image_bullet`, `alias`
FROM aswb_allevents_categories
1 × SELECT *
FROM aswb_banners
1 × SELECT `id`, `titre` as value, `image_bullet`, `agenda_id`, `alias`
FROM aswb_allevents_sections
1 × SELECT `id`, `titre` as value, `image_bullet`, `alias`
FROM aswb_allevents_public
1 × SELECT `id`, `name`, `catid`
FROM aswb_contact_details
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 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 alias, catid
FROM aswb_content
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 *
FROM aswb_languages
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.id, a.language,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM aswb_content AS a
LEFT JOIN aswb_categories AS cc
ON cc.id = a.catid
1 × SELECT `data`
FROM `aswb_session`
1 × SELECT *
FROM aswb_extensions
1 × SELECT `name`, `value`
FROM `aswb_jsn_imageshow_config`
1 × SELECT a.rules
FROM aswb_assets AS a
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, 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,( SELECT MAX(contact.id) AS id
FROM aswb_contact_details AS contact
1 × SELECT *
FROM aswb_allevents_settings
2 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_categories
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_sections
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_places
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_events
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_agenda
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_public
1 × UPDATE `aswb_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618334791;s:18:\"session.timer.last\";i:1618334791;s:17:\"session.timer.now\";i:1618334791;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:1:{s:40:\"71786533c403b4b66697a80a84f95167f887dfa8\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://williams-france.org/index.php/divers/309-inclusion-maladies-rares\";s:6:\"expiry\";i:1618334792;}}s:13:\"session.token\";s:32:\"9e9f7ac3eb1472af0676af84ae86f659\";}' , `time` = '1618334792'
1 × SHOW FULL COLUMNS
FROM `aswb_allevents_activities
1 × UPDATE aswb_content
SET hits = hits + 1
1 × INSERT INTO `aswb_session` (`session_id`, `client_id`, `time`)
VALUES ('9d27a6f0e00464b18db9b267c439f2b4', 0, '1618334791'
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 × DELETE
FROM `aswb_session`