• Images
- Pharmaceutical
------------------------------------
• WHL Pharmaceutical Accounts
- Arana Therapeutics, Inc.
- Comentis
- Codexis
- Cerimon Pharmaceuticals
- Impax Pharmaceuticals
- Global Solutions for Infectious Diseases
- KAl Pharmaceuti-cals, Inc.
- Novartis
- Portola Pharmaceuticals
- Plexxikon, Inc.
- Rigel, Inc.
------------------------------------
• Pharmaceutical Overview
------------------------------------
• Related Documentation

Related Pharmaceutical Documentation


There are currently no documents for the Pharmaceutical sector.
WHLArchitects.com © 2012 Phone: (408) 730-9500
Fax: (408) 730-9588		 1136 West Evelyn Avenue
Sunnyvale, California 94086-5742 
 
21 queries took 72 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `documents`662
2DESCRIBE `sectors`662
3DESCRIBE `overviews`662
4DESCRIBE `accounts`662
5DESCRIBE `galleries`662
6DESCRIBE `gallery_images`772
7SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active`, `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1003
8SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1111
9SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3) 003
10SELECT `Access`.`id`, `Access`.`group_id`, `Access`.`controller`, `Access`.`action`, `Access`.`date_created`, `Access`.`date_modified` FROM `accesses` AS `Access` WHERE `Access`.`group_id` IN (3) 25253
11SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 224
12SELECT `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `sectors` AS `Sector` WHERE `Sector`.`name` = 'Pharmaceutical' LIMIT 1115
13SELECT `Overview`.`id`, `Overview`.`sector_id`, `Overview`.`name`, `Overview`.`description`, `Overview`.`date_created`, `Overview`.`date_modified` FROM `overviews` AS `Overview` WHERE `Overview`.`sector_id` IN (2) 116
14SELECT `Document`.`id`, `Document`.`name`, `Document`.`sector_id`, `Document`.`description`, `Document`.`date_created`, `Document`.`date_modified` FROM `documents` AS `Document` WHERE `Document`.`sector_id` IN (2) 007
15SELECT `Account`.`id`, `Account`.`name`, `Account`.`sector_id`, `Account`.`link`, `Account`.`date_created`, `Account`.`date_modified` FROM `accounts` AS `Account` WHERE `Account`.`sector_id` IN (2) 11113
16SELECT `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`sector_id`, `Gallery`.`parent_id`, `Gallery`.`date_created`, `Gallery`.`date_modified` FROM `galleries` AS `Gallery` WHERE `Gallery`.`sector_id` IN (2) 115
17SELECT `Document`.`id`, `Document`.`name`, `Document`.`sector_id`, `Document`.`description`, `Document`.`date_created`, `Document`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `documents` AS `Document` LEFT JOIN `sectors` AS `Sector` ON (`Document`.`sector_id` = `Sector`.`id`) WHERE `Document`.`sector_id` = 2 002
18SELECT `Account`.`id`, `Account`.`name`, `Account`.`sector_id`, `Account`.`link`, `Account`.`date_created`, `Account`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `accounts` AS `Account` LEFT JOIN `sectors` AS `Sector` ON (`Account`.`sector_id` = `Sector`.`id`) WHERE `Account`.`sector_id` = 2 11112
19SELECT `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`sector_id`, `Gallery`.`parent_id`, `Gallery`.`date_created`, `Gallery`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `galleries` AS `Gallery` LEFT JOIN `sectors` AS `Sector` ON (`Gallery`.`sector_id` = `Sector`.`id`) WHERE `Gallery`.`sector_id` = 2 AND `Gallery`.`parent_id` = 0 112
20SELECT `GalleryImage`.`id`, `GalleryImage`.`file_name`, `GalleryImage`.`gallery_id`, `GalleryImage`.`caption`, `GalleryImage`.`order`, `GalleryImage`.`date_created`, `GalleryImage`.`date_modified` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` IN (68) ORDER BY `GalleryImage`.`order` ASC 11611612
21SELECT `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`sector_id`, `Gallery`.`parent_id`, `Gallery`.`date_created`, `Gallery`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `galleries` AS `Gallery` LEFT JOIN `sectors` AS `Sector` ON (`Gallery`.`sector_id` = `Sector`.`id`) WHERE `Gallery`.`sector_id` = 2 AND `Gallery`.`parent_id` <> 0 002