Fernand Labrie

All Communications

Page 1 of 1, showing 2 records out of 2 total, starting on record 1, ending on 2

Communication	Category	Year
2. Labrie F (2011) Androgens in Ageing Women - The physiological basis of androgen deficiency in postmenopausal women. Abstract of Plenary Sessions of the 13th World Congress on the Menopause, June 2011, Climacteric, Volume 14, Supplement 1, page 36.	All communications	2011
1. Labrie F, Archer D, Bouchard, C, Fortier M, Cusan L, Girard G, Baron M, Ayotte N, Moreau M, Dubé R, Côté I, Labrie C, Lavoie L, Martel C and Balser J (2010) Effect of intravaginal DHEA in postmenopausal women suffering from vaginal atrophy with pain at sexual activity (dyspareunia) as their most bothersome symptom. COGI - 13th World Congress on Controversies in Obstetrics Gynecology & Infertility, Berlin, Germany, November 4-7. Abstract A-12.	All communications	2010

<< previous

next >>

19 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT COUNT(*) AS `count` FROM `commcategories_communications` AS `CommcategoriesCommunication` LEFT JOIN `communications` AS `Communication` ON (`CommcategoriesCommunication`.`communication_id` = `Communication`.`id`) LEFT JOIN `commcategories` AS `Commcategory` ON (`CommcategoriesCommunication`.`commcategory_id` = `Commcategory`.`id`) WHERE `Commcategory`.`id` = 10 AND `Communication`.`display` IN (0,1)	1	1	0
2	SELECT `CommcategoriesCommunication`.`communication_id`, `CommcategoriesCommunication`.`commcategory_id`, `Communication`.`id`, `Communication`.`texte`, `Communication`.`texte_strip`, `Communication`.`year`, `Communication`.`filename`, `Communication`.`link`, `Communication`.`display`, `Communication`.`multimedia`, `Commcategory`.`id`, `Commcategory`.`name` FROM `commcategories_communications` AS `CommcategoriesCommunication` LEFT JOIN `communications` AS `Communication` ON (`CommcategoriesCommunication`.`communication_id` = `Communication`.`id`) LEFT JOIN `commcategories` AS `Commcategory` ON (`CommcategoriesCommunication`.`commcategory_id` = `Commcategory`.`id`) WHERE `Commcategory`.`id` = 10 AND `Communication`.`display` IN (0,1) ORDER BY `year` desc, `texte_strip` asc LIMIT 50	2	2	0
3	DESCRIBE `multimedia`	15	15	1
4	SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (785)	1	1	0
5	SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (753)	1	1	0
6	SELECT `Communication`.`id`, `Communication`.`texte`, `Communication`.`texte_strip`, `Communication`.`year`, `Communication`.`filename`, `Communication`.`link`, `Communication`.`display`, `Communication`.`multimedia` FROM `communications` AS `Communication` WHERE `Communication`.`id` = 4752	1	1	0
7	SELECT `Commcategory`.`id`, `Commcategory`.`name`, `CommcategoriesCommunication`.`communication_id`, `CommcategoriesCommunication`.`commcategory_id` FROM `commcategories` AS `Commcategory` JOIN `commcategories_communications` AS `CommcategoriesCommunication` ON (`CommcategoriesCommunication`.`communication_id` = 4752 AND `CommcategoriesCommunication`.`commcategory_id` = `Commcategory`.`id`) WHERE 1 = 1	1	1	0
8	SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (785)	1	1	0
9	SELECT `Communication`.`id`, `Communication`.`texte`, `Communication`.`texte_strip`, `Communication`.`year`, `Communication`.`filename`, `Communication`.`link`, `Communication`.`display`, `Communication`.`multimedia` FROM `communications` AS `Communication` WHERE `Communication`.`id` = 4750	1	1	0
10	SELECT `Commcategory`.`id`, `Commcategory`.`name`, `CommcategoriesCommunication`.`communication_id`, `CommcategoriesCommunication`.`commcategory_id` FROM `commcategories` AS `Commcategory` JOIN `commcategories_communications` AS `CommcategoriesCommunication` ON (`CommcategoriesCommunication`.`communication_id` = 4750 AND `CommcategoriesCommunication`.`commcategory_id` = `Commcategory`.`id`) WHERE 1 = 1	1	1	0
11	SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (753)	1	1	0
12	SELECT `Commcategory`.`id`, `Commcategory`.`name` FROM `commcategories` AS `Commcategory` WHERE `Commcategory`.`id` = 10	1	1	0
13	SELECT `Communication`.`id`, `Communication`.`texte`, `Communication`.`texte_strip`, `Communication`.`year`, `Communication`.`filename`, `Communication`.`link`, `Communication`.`display`, `Communication`.`multimedia`, `CommcategoriesCommunication`.`communication_id`, `CommcategoriesCommunication`.`commcategory_id` FROM `communications` AS `Communication` JOIN `commcategories_communications` AS `CommcategoriesCommunication` ON (`CommcategoriesCommunication`.`commcategory_id` = 10 AND `CommcategoriesCommunication`.`communication_id` = `Communication`.`id`) WHERE 1 = 1	2	2	0
14	SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (753)	1	1	0
15	SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (785)	1	1	0
16	SELECT `Commcategory`.`id`, `Commcategory`.`name` FROM `commcategories` AS `Commcategory` WHERE `Commcategory`.`id` = 10	1	1	0
17	SELECT `Communication`.`id`, `Communication`.`texte`, `Communication`.`texte_strip`, `Communication`.`year`, `Communication`.`filename`, `Communication`.`link`, `Communication`.`display`, `Communication`.`multimedia`, `CommcategoriesCommunication`.`communication_id`, `CommcategoriesCommunication`.`commcategory_id` FROM `communications` AS `Communication` JOIN `commcategories_communications` AS `CommcategoriesCommunication` ON (`CommcategoriesCommunication`.`commcategory_id` = 10 AND `CommcategoriesCommunication`.`communication_id` = `Communication`.`id`) WHERE 1 = 1	2	2	0
18	SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (753)	1	1	0
19	SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (785)	1	1	0

19 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT COUNT(*) AS `count` FROM `commcategories_communications` AS `CommcategoriesCommunication` LEFT JOIN `communications` AS `Communication` ON (`CommcategoriesCommunication`.`communication_id` = `Communication`.`id`) LEFT JOIN `commcategories` AS `Commcategory` ON (`CommcategoriesCommunication`.`commcategory_id` = `Commcategory`.`id`) WHERE `Commcategory`.`id` = 10 AND `Communication`.`display` IN (0,1)

SELECT `CommcategoriesCommunication`.`communication_id`, `CommcategoriesCommunication`.`commcategory_id`, `Communication`.`id`, `Communication`.`texte`, `Communication`.`texte_strip`, `Communication`.`year`, `Communication`.`filename`, `Communication`.`link`, `Communication`.`display`, `Communication`.`multimedia`, `Commcategory`.`id`, `Commcategory`.`name` FROM `commcategories_communications` AS `CommcategoriesCommunication` LEFT JOIN `communications` AS `Communication` ON (`CommcategoriesCommunication`.`communication_id` = `Communication`.`id`) LEFT JOIN `commcategories` AS `Commcategory` ON (`CommcategoriesCommunication`.`commcategory_id` = `Commcategory`.`id`) WHERE `Commcategory`.`id` = 10 AND `Communication`.`display` IN (0,1) ORDER BY `year` desc, `texte_strip` asc LIMIT 50

DESCRIBE `multimedia`

SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (785)

SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (753)

SELECT `Commcategory`.`id`, `Commcategory`.`name`, `CommcategoriesCommunication`.`communication_id`, `CommcategoriesCommunication`.`commcategory_id` FROM `commcategories` AS `Commcategory` JOIN `commcategories_communications` AS `CommcategoriesCommunication` ON (`CommcategoriesCommunication`.`communication_id` = 4752 AND `CommcategoriesCommunication`.`commcategory_id` = `Commcategory`.`id`) WHERE 1 = 1

SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (785)

SELECT `Commcategory`.`id`, `Commcategory`.`name`, `CommcategoriesCommunication`.`communication_id`, `CommcategoriesCommunication`.`commcategory_id` FROM `commcategories` AS `Commcategory` JOIN `commcategories_communications` AS `CommcategoriesCommunication` ON (`CommcategoriesCommunication`.`communication_id` = 4750 AND `CommcategoriesCommunication`.`commcategory_id` = `Commcategory`.`id`) WHERE 1 = 1

SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (753)

SELECT `Commcategory`.`id`, `Commcategory`.`name` FROM `commcategories` AS `Commcategory` WHERE `Commcategory`.`id` = 10

SELECT `Communication`.`id`, `Communication`.`texte`, `Communication`.`texte_strip`, `Communication`.`year`, `Communication`.`filename`, `Communication`.`link`, `Communication`.`display`, `Communication`.`multimedia`, `CommcategoriesCommunication`.`communication_id`, `CommcategoriesCommunication`.`commcategory_id` FROM `communications` AS `Communication` JOIN `commcategories_communications` AS `CommcategoriesCommunication` ON (`CommcategoriesCommunication`.`commcategory_id` = 10 AND `CommcategoriesCommunication`.`communication_id` = `Communication`.`id`) WHERE 1 = 1

SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (753)

SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (785)

SELECT `Commcategory`.`id`, `Commcategory`.`name` FROM `commcategories` AS `Commcategory` WHERE `Commcategory`.`id` = 10

SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (753)

SELECT `Multimedium`.`filename`, `Multimedium`.`path`, `Multimedium`.`id`, `Multimedium`.`ext`, `Multimedium`.`size` FROM `multimedia` AS `Multimedium` WHERE `Multimedium`.`id` = (785)