Alliance Retail Management Group Inc.
Integrated Business Management
Through Experience, Skill and Creativity

The Alliance Business Management Team have an in-depth knowledge of the Canadian Retail Drug Industry. With their longstanding business relationships throughout the trade they have created a network of contacts which goes to work for every Manufacturer represented.

The Alliance Business Managers maintain a strong presence in every Key Account across Canada no matter how big or small.

In partnership with the Principal and Retailers, Alliance’s ideas mean business, and get results.

Your Partners for Performance
National Key Account and Retail Sales Coverage

Our organization is a blend of young ambitious sales people combined with a strong foundation of experienced reps from the Drug Industry.

Association memberships such as CACDS help maintain our status as a leading Drug Retail Broker by being at the forefront of changes in the retail market and in the categories in which we compete.

Whether it’s launching new products or expanding current business, we capitalize on potential and turn it into
Performance Results.

37 queries took 686 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`9938
2DESCRIBE `page_histories`9939
3DESCRIBE `groups`5543
4DESCRIBE `users`121227
5DESCRIBE `provinces`4417
6DESCRIBE `stores`101035
7DESCRIBE `banners`4426
8DESCRIBE `vendors`4429
9DESCRIBE `products`9925
10DESCRIBE `call_report_entries`101049
11DESCRIBE `call_reports`8833
12DESCRIBE `cycles`6634
13DESCRIBE `cycles_products`3344
14DESCRIBE `sa_funds_report_entries`111114
15DESCRIBE `sa_funds_reports`6615
16DESCRIBE `sa_funds_report_entry_cheques`6621
17DESCRIBE `accesses`6627
18DESCRIBE `groups_pages`3313
19SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`province_id`, `User`.`email`, `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`, `Province`.`id`, `Province`.`name`, `Province`.`date_created`, `Province`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `provinces` AS `Province` ON (`User`.`province_id` = `Province`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1001
20SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1119
21SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`province_id`, `User`.`email`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3) 009
22SELECT `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) 212113
23DESCRIBE `settings`334
24SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 441
25SELECT `Page`.`id`, `Page`.`title`, `Page`.`content`, `Page`.`filename`, `Page`.`layout`, `Page`.`show_title`, `Page`.`date_created`, `Page`.`date_modified`, `Page`.`active` FROM `pages` AS `Page` WHERE `Page`.`filename` = 'home' LIMIT 11113
26SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsPage`.`id`, `GroupsPage`.`page_id`, `GroupsPage`.`group_id` FROM `groups` AS `Group` LEFT JOIN `groups_pages` AS `GroupsPage` ON (`GroupsPage`.`page_id` IN (17) AND `GroupsPage`.`group_id` = `Group`.`id`) 4410
27DESCRIBE `navigations`8820
28DESCRIBE `navigation_sections`212128
29DESCRIBE `groups_navigations`3325
30SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`province_id`, `User`.`email`, `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`, `Province`.`id`, `Province`.`name`, `Province`.`date_created`, `Province`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `provinces` AS `Province` ON (`User`.`province_id` = `Province`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1000
31SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1110
32SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`fax`, `User`.`province_id`, `User`.`email`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3) 000
33SELECT `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) 21211
34SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 440
35SELECT `NavigationSection`.`id`, `NavigationSection`.`name`, `NavigationSection`.`linkage`, `NavigationSection`.`style`, `NavigationSection`.`font-family`, `NavigationSection`.`image`, `NavigationSection`.`image_hover`, `NavigationSection`.`image_active`, `NavigationSection`.`font-color`, `NavigationSection`.`font-color_hover`, `NavigationSection`.`font-color_active`, `NavigationSection`.`center`, `NavigationSection`.`xcoord`, `NavigationSection`.`ycoord`, `NavigationSection`.`font-size`, `NavigationSection`.`vertical`, `NavigationSection`.`seperator`, `NavigationSection`.`date_created`, `NavigationSection`.`date_modified`, `NavigationSection`.`upper_case`, `NavigationSection`.`dropdown` FROM `navigation_sections` AS `NavigationSection` WHERE `linkage` = 'bottom' LIMIT 1119
36SELECT `Navigation`.`id`, `Navigation`.`label`, `Navigation`.`navigation_section_id`, `Navigation`.`url`, `Navigation`.`order`, `Navigation`.`parent_id`, `Navigation`.`date_created`, `Navigation`.`date_modified` FROM `navigations` AS `Navigation` WHERE `Navigation`.`navigation_section_id` = 2 ORDER BY `Navigation`.`order` ASC 555
37SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsNavigation`.`id`, `GroupsNavigation`.`navigation_id`, `GroupsNavigation`.`group_id` FROM `groups` AS `Group` LEFT JOIN `groups_navigations` AS `GroupsNavigation` ON (`GroupsNavigation`.`navigation_id` IN (11, 12, 13, 15, 14) AND `GroupsNavigation`.`group_id` = `Group`.`id`) 16169