Alliance Retail Management Group Inc.
7577 Keele St.
Suite 102 Concord, ON
L4K 4X3 Canada
Fax: 905-669-0781

Jacques Cousineau - Partner/Business Manager
 905-669-9889 xt. 22
 jcousineau@allianceretail.ca

Roman Forys - Partner/Business Manager
905-669-9889 xt. 24
rforys@allianceretail.ca 

Spiro Koten - Business Manager Western Canada
905-669-9889 xt. 23
 skoten@allianceretail.ca

Michel Ethier - Business Manager Quebec
450-621-8832
 methier@allianceretail.ca

Jenny Fiorini - Business Manager Ontario
905-669-9889 xt. 28
 jfiorini@allianceretail.ca

 Kelly Chomiak - Sales Administrator
905-669-9889 xt. 21
 kchomiak@allianceretail.ca

General Inquiries
905-669-9889 xt 21
 mail@allianceretail.ca

36 queries took 55 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`994
2DESCRIBE `page_histories`993
3DESCRIBE `groups`552
4DESCRIBE `users`12123
5DESCRIBE `provinces`442
6DESCRIBE `stores`10102
7DESCRIBE `banners`442
8DESCRIBE `vendors`442
9DESCRIBE `products`992
10DESCRIBE `call_report_entries`10102
11DESCRIBE `call_reports`883
12DESCRIBE `cycles`662
13DESCRIBE `cycles_products`332
14DESCRIBE `sa_funds_report_entries`11112
15DESCRIBE `sa_funds_reports`662
16DESCRIBE `sa_funds_report_entry_cheques`662
17DESCRIBE `accesses`662
18DESCRIBE `groups_pages`332
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 1000
20SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1110
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) 000
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) 21210
23SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 440
24SELECT `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` = 'contact' LIMIT 1111
25SELECT `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 (2) AND `GroupsPage`.`group_id` = `Group`.`id`) 440
26DESCRIBE `navigations`887
27DESCRIBE `navigation_sections`21213
28DESCRIBE `groups_navigations`332
29SELECT `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
30SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1110
31SELECT `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
32SELECT `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) 21210
33SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 440
34SELECT `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 1110
35SELECT `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 551
36SELECT `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`) 16160