Alliance Retail Management Group Inc.

National Key Account Coverage
Strong Presence in Key Accounts in Canada

This strong Key Account presence includes:

Educating Category Managers on all brands represented
Providing a resource/assist with category management
Reviewing all sales and business building opportunities (Business Reviews)

National Retail Coverage

Alliance is committed to providing the highest quality in-store retail coverage. Our experienced and highly motivated sales representatives are well equipped to get the results expected by our clients and retailers.

Marketing

Alliance has the expertise to provide support with Marketing needs such as:

Graphic design
Developing sales tools for the Canadian market
POP displays
Advertising buying
French/English translations



Warehousing / Distribution Customs brokerage and clearing Warehousing Distribution Regulatory Affairs Alliance works closely with our principals to ensure products follow Health Canada requirements. DIN NHP Medical Devices

37 queries took 86 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `pages`	9	9	6
2	DESCRIBE `page_histories`	9	9	8
3	DESCRIBE `groups`	5	5	3
4	DESCRIBE `users`	12	12	3
5	DESCRIBE `provinces`	4	4	2
6	DESCRIBE `stores`	10	10	3
7	DESCRIBE `banners`	4	4	2
8	DESCRIBE `vendors`	4	4	3
9	DESCRIBE `products`	9	9	2
10	DESCRIBE `call_report_entries`	10	10	2
11	DESCRIBE `call_reports`	8	8	2
12	DESCRIBE `cycles`	6	6	8
13	DESCRIBE `cycles_products`	3	3	2
14	DESCRIBE `sa_funds_report_entries`	11	11	2
15	DESCRIBE `sa_funds_reports`	6	6	3
16	DESCRIBE `sa_funds_report_entry_cheques`	6	6	2
17	DESCRIBE `accesses`	6	6	3
18	DESCRIBE `groups_pages`	3	3	5
19	SELECT `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 1	0	0	0
20	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1	1	1	0
21	SELECT `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)	0	0	0
22	SELECT `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)	21	21	0
23	DESCRIBE `settings`	3	3	4
24	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	4	4	0
25	SELECT `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` = 'accounts' LIMIT 1	1	1	1
26	SELECT `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 (21) AND `GroupsPage`.`group_id` = `Group`.`id`)	3	3	0
27	DESCRIBE `navigations`	8	8	7
28	DESCRIBE `navigation_sections`	21	21	6
29	DESCRIBE `groups_navigations`	3	3	7
30	SELECT `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 1	0	0	0
31	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1	1	1	0
32	SELECT `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)	0	0	0
33	SELECT `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)	21	21	0
34	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	4	4	0
35	SELECT `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 1	1	1	0
36	SELECT `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	5	5	0
37	SELECT `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`)	15	15	0

37 queries took 86 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `pages`

DESCRIBE `page_histories`

DESCRIBE `groups`

DESCRIBE `users`

DESCRIBE `provinces`

DESCRIBE `stores`

DESCRIBE `banners`

DESCRIBE `vendors`

DESCRIBE `products`

DESCRIBE `call_report_entries`

DESCRIBE `call_reports`

DESCRIBE `cycles`

DESCRIBE `cycles_products`

DESCRIBE `sa_funds_report_entries`

DESCRIBE `sa_funds_reports`

DESCRIBE `sa_funds_report_entry_cheques`

DESCRIBE `accesses`

DESCRIBE `groups_pages`

SELECT `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 1

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1

SELECT `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)

DESCRIBE `settings`

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1

SELECT `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` = 'accounts' LIMIT 1

SELECT `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 (21) AND `GroupsPage`.`group_id` = `Group`.`id`)

DESCRIBE `navigations`

DESCRIBE `navigation_sections`

DESCRIBE `groups_navigations`

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1

SELECT `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)

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1

SELECT `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 1

SELECT `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

SELECT `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`)