| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `MetaDatum`.`id`, `MetaDatum`.`controller`, `MetaDatum`.`action`, `MetaDatum`.`type`, `MetaDatum`.`heading`, `MetaDatum`.`title`, `MetaDatum`.`description`, `MetaDatum`.`keywords`, `MetaDatum`.`created`, `MetaDatum`.`modified` FROM `clubentr_staging`.`meta_data` AS `MetaDatum` WHERE `controller` = 'Members' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `BusinessSector`.`id`, `BusinessSector`.`title` FROM `clubentr_staging`.`business_sectors` AS `BusinessSector` WHERE 1 = 1 ORDER BY `title` ASC | 26 | 26 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 18 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 19 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 12 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 14 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 3 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 25 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 26 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 21 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 9 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 27 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 8 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 24 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 15 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 23 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 22 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 10 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 13 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 6 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 5 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 4 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 7 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 16 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 20 | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 17 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 2 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) LEFT JOIN `clubentr_staging`.`users` AS `User` ON (`User`.`member_id` = `Member`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 11 | 1 | 1 | 0 | |