jcartledge / au-senate-committee-memberships

Australian Senate committees and membership

Scrapes www.aph.gov.au

Home – Parliament of Australia


Last run completed successfully .

Console output of last run

Injecting configuration and compiling... [1G-----> Node.js app detected [1G [1G-----> Reading application state [1G package.json... [1G build directory... [1G cache directory... [1G environment variables... [1G [1G Node engine: unspecified [1G Npm engine: unspecified [1G Start mechanism: Procfile [1G node_modules source: package.json [1G node_modules cached: false [1G [1G NPM_CONFIG_PRODUCTION=true [1G NPM_CONFIG_CAFILE=/etc/ssl/certs/ca-certificates.crt [1G NODE_MODULES_CACHE=true [1G [1G-----> Installing binaries [1G Resolving node version (latest stable) via semver.io... [1G Downloading and installing node 5.6.0... [1G Using default npm version: 3.6.0 [1G [1G-----> Building dependencies [1G No cache available [1G Installing node modules [1G npm WARN deprecated CSSselect@0.4.1: the module is now available as 'css-select' [1G npm WARN deprecated CSSwhat@0.4.7: the module is now available as 'css-what' [1G [1G > sqlite3@3.1.1 install /tmp/build/node_modules/sqlite3 [1G > node-pre-gyp install --fallback-to-build [1G [1G [sqlite3] Success: "/tmp/build/node_modules/sqlite3/lib/binding/node-v47-linux-x64/node_sqlite3.node" is installed via remote [1G /tmp/build [1G +-- sequelize@3.19.2 [1G | +-- bluebird@3.3.1 [1G | +-- depd@1.1.0 [1G | +-- dottie@1.1.1 [1G | +-- generic-pool@2.4.0 [1G | +-- inflection@1.8.0 [1G | +-- lodash@4.4.0 [1G | +-- moment@2.11.2 [1G | +-- moment-timezone@0.5.0 [1G | +-- node-uuid@1.4.7 [1G | +-- retry-as-promised@2.0.1 [1G | +-- semver@5.1.0 [1G | +-- shimmer@1.1.0 [1G | +-- toposort-class@1.0.1 [1G | +-- validator@4.8.0 [1G | +-- wellknown@0.4.1 [1G | | +-- concat-stream@1.5.1 [1G | | | +-- inherits@2.0.1 [1G | | | +-- readable-stream@2.0.5 [1G | | | | +-- core-util-is@1.0.2 [1G | | | | +-- isarray@0.0.1 [1G | | | | +-- process-nextick-args@1.0.6 [1G | | | | +-- string_decoder@0.10.31 [1G | | | | `-- util-deprecate@1.0.2 [1G | | | `-- typedarray@0.0.6 [1G | | `-- minimist@1.1.3 [1G | `-- wkx@0.2.0 [1G +-- sqlite3@3.1.1 [1G | +-- nan@2.1.0 [1G | `-- node-pre-gyp@0.6.14 [1G | +-- mkdirp@0.5.1 [1G | | `-- minimist@0.0.8 [1G | +-- nopt@3.0.4 [1G | | `-- abbrev@1.0.7 [1G | +-- npmlog@1.2.1 [1G | | +-- ansi@0.3.0 [1G | | +-- are-we-there-yet@1.0.4 [1G | | | +-- delegates@0.1.0 [1G | | | `-- readable-stream@1.1.13 [1G | | | +-- core-util-is@1.0.1 [1G | | | +-- inherits@2.0.1 [1G | | | +-- isarray@0.0.1 [1G | | | `-- string_decoder@0.10.31 [1G | | `-- gauge@1.2.2 [1G | | +-- has-unicode@1.0.0 [1G | | +-- lodash.pad@3.1.1 [1G | | | +-- lodash._basetostring@3.0.1 [1G | | | `-- lodash._createpadding@3.6.1 [1G | | | `-- lodash.repeat@3.0.1 [1G | | +-- lodash.padleft@3.1.1 [1G | | | +-- lodash._basetostring@3.0.1 [1G | | | `-- lodash._createpadding@3.6.1 [1G | | | `-- lodash.repeat@3.0.1 [1G | | `-- lodash.padright@3.1.1 [1G | | +-- lodash._basetostring@3.0.1 [1G | | `-- lodash._createpadding@3.6.1 [1G | | `-- lodash.repeat@3.0.1 [1G | +-- rc@1.1.2 [1G | | +-- deep-extend@0.2.11 [1G | | +-- ini@1.3.4 [1G | | +-- minimist@1.2.0 [1G | | `-- strip-json-comments@0.1.3 [1G | +-- request@2.64.0 [1G | | +-- aws-sign2@0.5.0 [1G | | +-- bl@1.0.0 [1G | | | `-- readable-stream@2.0.2 [1G | | | +-- core-util-is@1.0.1 [1G | | | +-- inherits@2.0.1 [1G | | | +-- isarray@0.0.1 [1G | | | +-- process-nextick-args@1.0.3 [1G | | | +-- string_decoder@0.10.31 [1G | | | `-- util-deprecate@1.0.1 [1G | | +-- caseless@0.11.0 [1G | | +-- combined-stream@1.0.5 [1G | | | `-- delayed-stream@1.0.0 [1G | | +-- extend@3.0.0 [1G | | +-- forever-agent@0.6.1 [1G | | +-- form-data@1.0.0-rc3 [1G | | | `-- async@1.4.2 [1G | | +-- har-validator@1.8.0 [1G | | | +-- bluebird@2.10.2 [1G | | | +-- chalk@1.1.1 [1G | | | | +-- ansi-styles@2.1.0 [1G | | | | +-- escape-string-regexp@1.0.3 [1G | | | | +-- has-ansi@2.0.0 [1G | | | | | `-- ansi-regex@2.0.0 [1G | | | | +-- strip-ansi@3.0.0 [1G | | | | | `-- ansi-regex@2.0.0 [1G | | | | `-- supports-color@2.0.0 [1G | | | +-- commander@2.8.1 [1G | | | | `-- graceful-readlink@1.0.1 [1G | | | `-- is-my-json-valid@2.12.2 [1G | | | +-- generate-function@2.0.0 [1G | | | +-- generate-object-property@1.2.0 [1G | | | | `-- is-property@1.0.2 [1G | | | +-- jsonpointer@2.0.0 [1G | | | `-- xtend@4.0.0 [1G | | +-- hawk@3.1.0 [1G | | | +-- boom@2.9.0 [1G | | | +-- cryptiles@2.0.5 [1G | | | +-- hoek@2.16.3 [1G | | | `-- sntp@1.0.9 [1G | | +-- http-signature@0.11.0 [1G | | | +-- asn1@0.1.11 [1G | | | +-- assert-plus@0.1.5 [1G | | | `-- ctype@0.5.3 [1G | | +-- isstream@0.1.2 [1G | | +-- json-stringify-safe@5.0.1 [1G | | +-- mime-types@2.1.7 [1G | | | `-- mime-db@1.19.0 [1G | | +-- node-uuid@1.4.3 [1G | | +-- oauth-sign@0.8.0 [1G | | +-- qs@5.1.0 [1G | | +-- stringstream@0.0.4 [1G | | +-- tough-cookie@2.1.0 [1G | | `-- tunnel-agent@0.4.1 [1G | +-- rimraf@2.4.3 [1G | | `-- glob@5.0.15 [1G | | +-- inflight@1.0.4 [1G | | | `-- wrappy@1.0.1 [1G | | +-- inherits@2.0.1 [1G | | +-- minimatch@3.0.0 [1G | | | `-- brace-expansion@1.1.1 [1G | | | +-- balanced-match@0.2.0 [1G | | | `-- concat-map@0.0.1 [1G | | +-- once@1.3.2 [1G | | | `-- wrappy@1.0.1 [1G | | `-- path-is-absolute@1.0.0 [1G | +-- semver@5.0.3 [1G | +-- tar@2.2.1 [1G | | +-- block-stream@0.0.8 [1G | | +-- fstream@1.0.8 [1G | | | `-- graceful-fs@4.1.2 [1G | | `-- inherits@2.0.1 [1G | `-- tar-pack@2.0.0 [1G | +-- debug@0.7.4 [1G | +-- fstream@0.1.31 [1G | | +-- graceful-fs@3.0.8 [1G | | `-- inherits@2.0.1 [1G | +-- fstream-ignore@0.0.7 [1G | | +-- inherits@2.0.1 [1G | | `-- minimatch@0.2.14 [1G | | +-- lru-cache@2.7.0 [1G | | `-- sigmund@1.0.1 [1G | +-- graceful-fs@1.2.3 [1G | +-- once@1.1.1 [1G | +-- readable-stream@1.0.33 [1G | | +-- core-util-is@1.0.1 [1G | | +-- inherits@2.0.1 [1G | | +-- isarray@0.0.1 [1G | | `-- string_decoder@0.10.31 [1G | +-- rimraf@2.2.8 [1G | +-- tar@0.1.20 [1G | | +-- block-stream@0.0.8 [1G | | `-- inherits@2.0.1 [1G | `-- uid-number@0.0.3 [1G `-- x-ray@2.0.3 [1G +-- batch@0.5.3 [1G +-- chalk@1.1.1 [1G | +-- ansi-styles@2.1.0 [1G | +-- escape-string-regexp@1.0.4 [1G | +-- has-ansi@2.0.0 [1G | | `-- ansi-regex@2.0.0 [1G | +-- strip-ansi@3.0.0 [1G | `-- supports-color@2.0.0 [1G +-- cheerio@0.19.0 [1G | +-- css-select@1.0.0 [1G | | +-- boolbase@1.0.0 [1G | | +-- css-what@1.0.0 [1G | | +-- domutils@1.4.3 [1G | | `-- nth-check@1.0.1 [1G | +-- dom-serializer@0.1.0 [1G | | `-- domelementtype@1.1.3 [1G | +-- entities@1.1.1 [1G | +-- htmlparser2@3.8.3 [1G | | +-- domelementtype@1.3.0 [1G | | +-- domhandler@2.3.0 [1G | | +-- domutils@1.5.1 [1G | | +-- entities@1.0.0 [1G | | `-- readable-stream@1.1.13 [1G | `-- lodash@3.10.1 [1G +-- debug@2.2.0 [1G | `-- ms@0.7.1 [1G +-- enstore@1.0.1 [1G | `-- monotonic-timestamp@0.0.8 [1G +-- http-context@1.1.0 [1G | +-- accepts@1.3.1 [1G | | `-- negotiator@0.6.0 [1G | +-- assert@1.3.0 [1G | | `-- util@0.10.3 [1G | +-- content-disposition@0.5.1 [1G | +-- content-type@1.0.1 [1G | +-- delegates@0.1.0 [1G | +-- destroy@1.0.4 [1G | +-- error-inject@1.0.0 [1G | +-- escape-html@1.0.3 [1G | +-- http-incoming@0.12.0 [1G | +-- http-outgoing@0.12.0 [1G | +-- koa-is-json@1.0.0 [1G | +-- mime-types@2.1.10 [1G | | `-- mime-db@1.22.0 [1G | +-- on-finished@2.3.0 [1G | | `-- ee-first@1.1.1 [1G | +-- parseurl@1.3.1 [1G | +-- querystring@0.2.0 [1G | +-- statuses@1.2.1 [1G | +-- type-is@1.6.11 [1G | | `-- media-typer@0.3.0 [1G | `-- vary@1.1.0 [1G +-- is-url@1.2.1 [1G +-- isobject@1.0.2 [1G +-- object-assign@2.1.1 [1G +-- prettyjson@1.1.3 [1G | `-- colors@1.1.2 [1G +-- x-ray-crawler@2.0.2 [1G | +-- cheerio@0.18.0 [1G | | +-- CSSselect@0.4.1 [1G | | | `-- CSSwhat@0.4.7 [1G | | +-- dom-serializer@0.0.1 [1G | | | `-- domelementtype@1.1.3 [1G | | `-- lodash@2.4.2 [1G | +-- emitter-component@1.1.1 [1G | +-- enqueue@1.0.2 [1G | +-- selectn@0.9.6 [1G | +-- sliced@0.0.5 [1G | +-- superagent@1.7.2 [1G | | +-- component-emitter@1.2.0 [1G | | +-- cookiejar@2.0.6 [1G | | +-- extend@3.0.0 [1G | | +-- form-data@0.2.0 [1G | | | +-- async@0.9.2 [1G | | | +-- combined-stream@0.0.7 [1G | | | | `-- delayed-stream@0.0.5 [1G | | | `-- mime-types@2.0.14 [1G | | | `-- mime-db@1.12.0 [1G | | +-- formidable@1.0.17 [1G | | +-- methods@1.1.2 [1G | | +-- mime@1.3.4 [1G | | +-- qs@2.3.3 [1G | | +-- readable-stream@1.0.27-1 [1G | | `-- reduce-component@1.0.1 [1G | +-- wrap-fn@0.1.5 [1G | | `-- co@3.1.0 [1G | `-- yieldly@0.0.1 [1G | `-- is-browser@2.0.1 [1G +-- x-ray-parse@1.0.1 [1G | `-- format-parser@0.0.2 [1G `-- yargs@3.32.0 [1G +-- camelcase@2.1.0 [1G +-- cliui@3.1.0 [1G | `-- wrap-ansi@1.0.0 [1G +-- decamelize@1.1.2 [1G +-- os-locale@1.4.0 [1G | `-- lcid@1.0.0 [1G | `-- invert-kv@1.0.0 [1G +-- string-width@1.0.1 [1G | +-- code-point-at@1.0.0 [1G | | `-- number-is-nan@1.0.0 [1G | `-- is-fullwidth-code-point@1.0.0 [1G +-- window-size@0.1.4 [1G `-- y18n@3.2.0 [1G [1G npm WARN build No description [1G npm WARN build No repository field. [1G npm WARN build No license field. [1G [1G-----> Checking startup method [1G Found Procfile [1G [1G-----> Finalizing build [1G Creating runtime environment [1G Exporting binary paths [1G Cleaning npm artifacts [1G Cleaning previous cache [1G Caching results for future builds [1G [1G-----> Build succeeded! [1G [1G /tmp/build [1G +-- sequelize@3.19.2 [1G +-- sqlite3@3.1.1 [1G `-- x-ray@2.0.3 [1G [1G WARNING: Node version not specified in package.json [1G https://devcenter.heroku.com/articles/nodejs-support#specifying-a-node-js-version [1G [1G-----> Discovering process types [1G Procfile declares types -> scraper Injecting scraper and running... Executing (default): DROP TABLE IF EXISTS `members`; Executing (default): CREATE TABLE IF NOT EXISTS `members` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL); Executing (default): PRAGMA INDEX_LIST(`members`) Executing (default): DROP TABLE IF EXISTS `committees`; Executing (default): CREATE TABLE IF NOT EXISTS `committees` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` VARCHAR(255), `url` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL); Executing (default): PRAGMA INDEX_LIST(`committees`) Executing (default): DROP TABLE IF EXISTS `memberships`; Executing (default): CREATE TABLE IF NOT EXISTS `memberships` (`office` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `committeeId` INTEGER NOT NULL REFERENCES `committees` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `memberId` INTEGER NOT NULL REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, PRIMARY KEY (`committeeId`, `memberId`)); Executing (default): PRAGMA INDEX_LIST(`memberships`) Executing (default): PRAGMA INDEX_INFO(`sqlite_autoindex_memberships_1`) Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Appropriations and Staffing','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Appropriations','2016-02-17 05:27:42.998 +00:00','2016-02-17 05:27:42.998 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Certain Aspects of the Queensland Government Administration related to Commonwealth Government Affairs','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Certain_Aspects_of_Queensland_Government_Administration','2016-02-17 05:27:43.006 +00:00','2016-02-17 05:27:43.006 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Community Affairs','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Community_Affairs','2016-02-17 05:27:43.007 +00:00','2016-02-17 05:27:43.007 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Economics','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Economics','2016-02-17 05:27:43.009 +00:00','2016-02-17 05:27:43.009 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Education and Employment','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Education_and_Employment','2016-02-17 05:27:43.010 +00:00','2016-02-17 05:27:43.010 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Environment and Communications','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Environment_and_Communications','2016-02-17 05:27:43.011 +00:00','2016-02-17 05:27:43.011 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Finance and Public Administration','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Finance_and_Public_Administration','2016-02-17 05:27:43.012 +00:00','2016-02-17 05:27:43.012 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Foreign Affairs, Defence and Trade','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Foreign_Affairs_Defence_and_Trade','2016-02-17 05:27:43.012 +00:00','2016-02-17 05:27:43.012 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Health (Select)','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Health','2016-02-17 05:27:43.015 +00:00','2016-02-17 05:27:43.015 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Legal and Constitutional Affairs','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Legal_and_Constitutional_Affairs','2016-02-17 05:27:43.015 +00:00','2016-02-17 05:27:43.015 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' National Broadband Network (Select)','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/National_Broadband_Network','2016-02-17 05:27:43.018 +00:00','2016-02-17 05:27:43.018 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Privileges','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Privileges','2016-02-17 05:27:43.019 +00:00','2016-02-17 05:27:43.019 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Procedure','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Procedure','2016-02-17 05:27:43.020 +00:00','2016-02-17 05:27:43.020 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Publications','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Publications','2016-02-17 05:27:43.021 +00:00','2016-02-17 05:27:43.021 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Regulations and Ordinances','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Regulations_and_Ordinances','2016-02-17 05:27:43.022 +00:00','2016-02-17 05:27:43.022 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Rural and Regional Affairs and Transport','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Rural_and_Regional_Affairs_and_Transport','2016-02-17 05:27:43.023 +00:00','2016-02-17 05:27:43.023 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Scrutiny of Bills','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Scrutiny_of_Bills','2016-02-17 05:27:43.025 +00:00','2016-02-17 05:27:43.025 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Selection of Bills','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Selection_of_Bills','2016-02-17 05:27:43.027 +00:00','2016-02-17 05:27:43.027 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Senators'' Interests','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Senators_Interests','2016-02-17 05:27:43.030 +00:00','2016-02-17 05:27:43.030 +00:00'); Executing (default): INSERT INTO `committees` (`id`,`name`,`url`,`updatedAt`,`createdAt`) VALUES (NULL,' Wind Turbines','http://www.aph.gov.au/Parliamentary_Business/Committees/Senate/Wind_Turbines','2016-02-17 05:27:43.031 +00:00','2016-02-17 05:27:43.031 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Glenn Lazarus ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Joseph Ludwig ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Chris Ketter ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Ian Macdonald ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Larissa Waters ' LIMIT 1; Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Glenn Lazarus ','2016-02-17 05:27:44.771 +00:00','2016-02-17 05:27:44.771 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Ian Macdonald ','2016-02-17 05:27:44.776 +00:00','2016-02-17 05:27:44.776 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Chris Ketter ','2016-02-17 05:27:44.777 +00:00','2016-02-17 05:27:44.777 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Joseph Ludwig ','2016-02-17 05:27:44.777 +00:00','2016-02-17 05:27:44.777 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Larissa Waters ','2016-02-17 05:27:44.780 +00:00','2016-02-17 05:27:44.780 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 2 AND `membership`.`memberId` IN (1); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 2 AND `membership`.`memberId` IN (2); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 2 AND `membership`.`memberId` IN (3); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 2 AND `membership`.`memberId` IN (4); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 2 AND `membership`.`memberId` IN (5); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Chair ',2,1,'2016-02-17 05:27:44.818 +00:00','2016-02-17 05:27:44.818 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',2,5,'2016-02-17 05:27:44.822 +00:00','2016-02-17 05:27:44.822 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',2,3,'2016-02-17 05:27:44.823 +00:00','2016-02-17 05:27:44.823 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Deputy Chair ',2,4,'2016-02-17 05:27:44.823 +00:00','2016-02-17 05:27:44.823 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',2,2,'2016-02-17 05:27:44.823 +00:00','2016-02-17 05:27:44.823 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator David Bushby ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Anne McEwen ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Matthew Canavan ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Rachel Siewert ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Zhenya Wang ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Catryna Bilyk ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator David Fawcett ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Mitch Fifield ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Claire Moore ' LIMIT 1; Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Rachel Siewert ','2016-02-17 05:27:45.604 +00:00','2016-02-17 05:27:45.604 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Catryna Bilyk ','2016-02-17 05:27:45.612 +00:00','2016-02-17 05:27:45.612 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator David Fawcett ','2016-02-17 05:27:45.613 +00:00','2016-02-17 05:27:45.613 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Mitch Fifield ','2016-02-17 05:27:45.614 +00:00','2016-02-17 05:27:45.614 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Claire Moore ','2016-02-17 05:27:45.615 +00:00','2016-02-17 05:27:45.615 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Zhenya Wang ','2016-02-17 05:27:45.615 +00:00','2016-02-17 05:27:45.615 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator David Bushby ','2016-02-17 05:27:45.616 +00:00','2016-02-17 05:27:45.616 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Matthew Canavan ','2016-02-17 05:27:45.621 +00:00','2016-02-17 05:27:45.621 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Anne McEwen ','2016-02-17 05:27:45.622 +00:00','2016-02-17 05:27:45.622 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 18 AND `membership`.`memberId` IN (6); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 18 AND `membership`.`memberId` IN (7); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 18 AND `membership`.`memberId` IN (8); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 18 AND `membership`.`memberId` IN (9); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 18 AND `membership`.`memberId` IN (10); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 18 AND `membership`.`memberId` IN (11); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 18 AND `membership`.`memberId` IN (12); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 18 AND `membership`.`memberId` IN (13); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 18 AND `membership`.`memberId` IN (14); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',18,7,'2016-02-17 05:27:45.714 +00:00','2016-02-17 05:27:45.714 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',18,10,'2016-02-17 05:27:45.716 +00:00','2016-02-17 05:27:45.716 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Palmer United Party Whip ',18,11,'2016-02-17 05:27:45.716 +00:00','2016-02-17 05:27:45.716 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Government Whip (Chair) ',18,12,'2016-02-17 05:27:45.716 +00:00','2016-02-17 05:27:45.716 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Nationals Whip ',18,13,'2016-02-17 05:27:45.716 +00:00','2016-02-17 05:27:45.716 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Opposition Whip ',18,14,'2016-02-17 05:27:45.717 +00:00','2016-02-17 05:27:45.717 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',18,9,'2016-02-17 05:27:45.724 +00:00','2016-02-17 05:27:45.724 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',18,8,'2016-02-17 05:27:45.724 +00:00','2016-02-17 05:27:45.724 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Australian Greens Whip ',18,6,'2016-02-17 05:27:45.724 +00:00','2016-02-17 05:27:45.724 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Helen Polley ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator John Williams ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Cory Bernardi ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Bill Heffernan ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Joseph Ludwig ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Rachel Siewert ' LIMIT 1; Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Helen Polley ','2016-02-17 05:27:46.154 +00:00','2016-02-17 05:27:46.154 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 17 AND `membership`.`memberId` IN (6); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 17 AND `membership`.`memberId` IN (4); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator John Williams ','2016-02-17 05:27:46.160 +00:00','2016-02-17 05:27:46.160 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Bill Heffernan ','2016-02-17 05:27:46.161 +00:00','2016-02-17 05:27:46.161 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Cory Bernardi ','2016-02-17 05:27:46.162 +00:00','2016-02-17 05:27:46.162 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 17 AND `membership`.`memberId` IN (15); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 17 AND `membership`.`memberId` IN (16); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 17 AND `membership`.`memberId` IN (17); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 17 AND `membership`.`memberId` IN (18); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',17,6,'2016-02-17 05:27:46.181 +00:00','2016-02-17 05:27:46.181 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',17,4,'2016-02-17 05:27:46.185 +00:00','2016-02-17 05:27:46.185 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Chair ',17,15,'2016-02-17 05:27:46.185 +00:00','2016-02-17 05:27:46.185 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',17,18,'2016-02-17 05:27:46.195 +00:00','2016-02-17 05:27:46.195 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Deputy Chair ',17,16,'2016-02-17 05:27:46.197 +00:00','2016-02-17 05:27:46.197 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',17,17,'2016-02-17 05:27:46.197 +00:00','2016-02-17 05:27:46.197 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Jan McLucas ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon David Johnston ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Catryna Bilyk ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Stephen Conroy ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Joanna Lindgren ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Scott Ludlam ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Linda Reynolds ' LIMIT 1; Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Stephen Conroy ','2016-02-17 05:27:47.044 +00:00','2016-02-17 05:27:47.044 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Scott Ludlam ','2016-02-17 05:27:47.050 +00:00','2016-02-17 05:27:47.050 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Linda Reynolds ','2016-02-17 05:27:47.051 +00:00','2016-02-17 05:27:47.051 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon David Johnston ','2016-02-17 05:27:47.051 +00:00','2016-02-17 05:27:47.051 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Jan McLucas ','2016-02-17 05:27:47.052 +00:00','2016-02-17 05:27:47.052 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Joanna Lindgren ','2016-02-17 05:27:47.053 +00:00','2016-02-17 05:27:47.053 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 11 AND `membership`.`memberId` IN (7); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 11 AND `membership`.`memberId` IN (19); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 11 AND `membership`.`memberId` IN (20); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 11 AND `membership`.`memberId` IN (21); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 11 AND `membership`.`memberId` IN (22); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 11 AND `membership`.`memberId` IN (23); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 11 AND `membership`.`memberId` IN (24); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',11,7,'2016-02-17 05:27:47.088 +00:00','2016-02-17 05:27:47.088 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Deputy Chair ',11,22,'2016-02-17 05:27:47.090 +00:00','2016-02-17 05:27:47.090 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Chair ',11,23,'2016-02-17 05:27:47.090 +00:00','2016-02-17 05:27:47.090 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',11,21,'2016-02-17 05:27:47.090 +00:00','2016-02-17 05:27:47.090 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',11,19,'2016-02-17 05:27:47.090 +00:00','2016-02-17 05:27:47.090 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',11,20,'2016-02-17 05:27:47.091 +00:00','2016-02-17 05:27:47.091 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',11,24,'2016-02-17 05:27:47.091 +00:00','2016-02-17 05:27:47.091 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Catryna Bilyk ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Cory Bernardi ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator David Bushby ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Sarah Hanson-Young ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon David Johnston ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Sue Lines ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Gavin Marshall ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Deborah O''Neill ' LIMIT 1; Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 19 AND `membership`.`memberId` IN (7); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 19 AND `membership`.`memberId` IN (18); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 19 AND `membership`.`memberId` IN (12); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 19 AND `membership`.`memberId` IN (22); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Sarah Hanson-Young ','2016-02-17 05:27:48.381 +00:00','2016-02-17 05:27:48.381 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Sue Lines ','2016-02-17 05:27:48.381 +00:00','2016-02-17 05:27:48.381 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Gavin Marshall ','2016-02-17 05:27:48.382 +00:00','2016-02-17 05:27:48.382 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Deborah O''Neill ','2016-02-17 05:27:48.384 +00:00','2016-02-17 05:27:48.384 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 19 AND `membership`.`memberId` IN (25); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 19 AND `membership`.`memberId` IN (26); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 19 AND `membership`.`memberId` IN (27); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 19 AND `membership`.`memberId` IN (28); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Chair ',19,7,'2016-02-17 05:27:48.398 +00:00','2016-02-17 05:27:48.398 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',19,22,'2016-02-17 05:27:48.401 +00:00','2016-02-17 05:27:48.401 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',19,18,'2016-02-17 05:27:48.401 +00:00','2016-02-17 05:27:48.401 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',19,12,'2016-02-17 05:27:48.401 +00:00','2016-02-17 05:27:48.401 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',19,25,'2016-02-17 05:27:48.412 +00:00','2016-02-17 05:27:48.412 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',19,27,'2016-02-17 05:27:48.416 +00:00','2016-02-17 05:27:48.416 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',19,28,'2016-02-17 05:27:48.418 +00:00','2016-02-17 05:27:48.418 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',19,26,'2016-02-17 05:27:48.418 +00:00','2016-02-17 05:27:48.418 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator John Madigan ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Bob Day AO' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Chris Back ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Matthew Canavan ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator David Leyonhjelm ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Anne Urquhart ' LIMIT 1; Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator John Madigan ','2016-02-17 05:27:49.477 +00:00','2016-02-17 05:27:49.477 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 20 AND `membership`.`memberId` IN (13); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Bob Day AO','2016-02-17 05:27:49.486 +00:00','2016-02-17 05:27:49.486 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Chris Back ','2016-02-17 05:27:49.488 +00:00','2016-02-17 05:27:49.488 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator David Leyonhjelm ','2016-02-17 05:27:49.488 +00:00','2016-02-17 05:27:49.488 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Anne Urquhart ','2016-02-17 05:27:49.489 +00:00','2016-02-17 05:27:49.489 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 20 AND `membership`.`memberId` IN (29); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 20 AND `membership`.`memberId` IN (30); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 20 AND `membership`.`memberId` IN (31); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 20 AND `membership`.`memberId` IN (32); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 20 AND `membership`.`memberId` IN (33); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',20,13,'2016-02-17 05:27:49.525 +00:00','2016-02-17 05:27:49.525 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Chair ',20,29,'2016-02-17 05:27:49.526 +00:00','2016-02-17 05:27:49.526 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Deputy Chair ',20,30,'2016-02-17 05:27:49.535 +00:00','2016-02-17 05:27:49.535 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',20,32,'2016-02-17 05:27:49.536 +00:00','2016-02-17 05:27:49.536 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',20,33,'2016-02-17 05:27:49.536 +00:00','2016-02-17 05:27:49.536 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',20,31,'2016-02-17 05:27:49.540 +00:00','2016-02-17 05:27:49.540 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator John Williams ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Gavin Marshall ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Claire Moore ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Nova Peris OAM' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Linda Reynolds ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Zed Seselja ' LIMIT 1; Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 15 AND `membership`.`memberId` IN (16); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 15 AND `membership`.`memberId` IN (27); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 15 AND `membership`.`memberId` IN (21); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 15 AND `membership`.`memberId` IN (10); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Nova Peris OAM','2016-02-17 05:27:50.429 +00:00','2016-02-17 05:27:50.429 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Zed Seselja ','2016-02-17 05:27:50.430 +00:00','2016-02-17 05:27:50.430 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 15 AND `membership`.`memberId` IN (34); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 15 AND `membership`.`memberId` IN (35); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Chair ',15,16,'2016-02-17 05:27:50.445 +00:00','2016-02-17 05:27:50.445 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',15,10,'2016-02-17 05:27:50.447 +00:00','2016-02-17 05:27:50.447 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Deputy Chair ',15,27,'2016-02-17 05:27:50.447 +00:00','2016-02-17 05:27:50.447 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',15,21,'2016-02-17 05:27:50.447 +00:00','2016-02-17 05:27:50.447 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',15,34,'2016-02-17 05:27:50.463 +00:00','2016-02-17 05:27:50.463 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',15,35,'2016-02-17 05:27:50.465 +00:00','2016-02-17 05:27:50.465 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Stephen Parry ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Gavin Marshall ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon George Brandis QC' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Penny Wong ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Chris Back ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Jacinta Collins ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator David Fawcett ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Mitch Fifield ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator John Madigan ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Anne McEwen ' LIMIT 1; Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Stephen Parry ','2016-02-17 05:27:51.073 +00:00','2016-02-17 05:27:51.073 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (31); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (8); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (9); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (29); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (14); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Jacinta Collins ','2016-02-17 05:27:51.079 +00:00','2016-02-17 05:27:51.079 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (27); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon George Brandis QC','2016-02-17 05:27:51.082 +00:00','2016-02-17 05:27:51.082 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Penny Wong ','2016-02-17 05:27:51.082 +00:00','2016-02-17 05:27:51.082 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (36); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (37); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (38); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 1 AND `membership`.`memberId` IN (39); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',1,14,'2016-02-17 05:27:51.095 +00:00','2016-02-17 05:27:51.095 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The President of the Senate (Chair) ',1,36,'2016-02-17 05:27:51.097 +00:00','2016-02-17 05:27:51.097 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',1,29,'2016-02-17 05:27:51.097 +00:00','2016-02-17 05:27:51.097 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',1,31,'2016-02-17 05:27:51.097 +00:00','2016-02-17 05:27:51.097 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',1,8,'2016-02-17 05:27:51.101 +00:00','2016-02-17 05:27:51.101 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',1,9,'2016-02-17 05:27:51.101 +00:00','2016-02-17 05:27:51.101 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Deputy President of the Senate ',1,27,'2016-02-17 05:27:51.104 +00:00','2016-02-17 05:27:51.104 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',1,37,'2016-02-17 05:27:51.105 +00:00','2016-02-17 05:27:51.105 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Leader of the Government in the Senate ',1,38,'2016-02-17 05:27:51.118 +00:00','2016-02-17 05:27:51.118 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Leader of the Opposition in the Senate ',1,39,'2016-02-17 05:27:51.120 +00:00','2016-02-17 05:27:51.120 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Stephen Parry ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Gavin Marshall ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon George Brandis QC' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Penny Wong ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator David Bushby ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Mitch Fifield ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Anne McEwen ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Claire Moore ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Rachel Siewert ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Dean Smith ' LIMIT 1; Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (36); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (27); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (38); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (39); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (12); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (9); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (14); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (10); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (6); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Dean Smith ','2016-02-17 05:27:51.873 +00:00','2016-02-17 05:27:51.873 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 13 AND `membership`.`memberId` IN (40); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The President of the Senate ',13,36,'2016-02-17 05:27:51.886 +00:00','2016-02-17 05:27:51.886 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',13,12,'2016-02-17 05:27:51.887 +00:00','2016-02-17 05:27:51.887 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',13,9,'2016-02-17 05:27:51.887 +00:00','2016-02-17 05:27:51.887 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',13,14,'2016-02-17 05:27:51.887 +00:00','2016-02-17 05:27:51.887 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',13,10,'2016-02-17 05:27:51.895 +00:00','2016-02-17 05:27:51.895 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Leader of the Opposition in the Senate ',13,39,'2016-02-17 05:27:51.896 +00:00','2016-02-17 05:27:51.896 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Deputy President of the Senate (Chair) ',13,27,'2016-02-17 05:27:51.896 +00:00','2016-02-17 05:27:51.896 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' The Leader of the Government in the Senate ',13,38,'2016-02-17 05:27:51.896 +00:00','2016-02-17 05:27:51.896 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',13,6,'2016-02-17 05:27:51.896 +00:00','2016-02-17 05:27:51.896 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',13,40,'2016-02-17 05:27:51.918 +00:00','2016-02-17 05:27:51.918 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Linda Reynolds ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Catryna Bilyk ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Chris Back ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator David Bushby ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Joanna Lindgren ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Gavin Marshall ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Nova Peris OAM' LIMIT 1; Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 14 AND `membership`.`memberId` IN (12); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 14 AND `membership`.`memberId` IN (24); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 14 AND `membership`.`memberId` IN (27); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 14 AND `membership`.`memberId` IN (34); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 14 AND `membership`.`memberId` IN (31); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 14 AND `membership`.`memberId` IN (7); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 14 AND `membership`.`memberId` IN (21); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',14,12,'2016-02-17 05:27:52.980 +00:00','2016-02-17 05:27:52.980 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',14,27,'2016-02-17 05:27:52.982 +00:00','2016-02-17 05:27:52.982 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Chair ',14,21,'2016-02-17 05:27:52.982 +00:00','2016-02-17 05:27:52.982 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',14,24,'2016-02-17 05:27:52.983 +00:00','2016-02-17 05:27:52.983 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Deputy Chair ',14,7,'2016-02-17 05:27:52.983 +00:00','2016-02-17 05:27:52.983 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',14,34,'2016-02-17 05:27:52.983 +00:00','2016-02-17 05:27:52.983 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',14,31,'2016-02-17 05:27:52.984 +00:00','2016-02-17 05:27:52.984 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Jacinta Collins ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Ian Macdonald ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator the Hon Eric Abetz ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Scott Ludlam ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Anne McEwen ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Bridget McKenzie ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Dean Smith ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Anne Urquhart ' LIMIT 1; Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 12 AND `membership`.`memberId` IN (14); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 12 AND `membership`.`memberId` IN (37); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 12 AND `membership`.`memberId` IN (20); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 12 AND `membership`.`memberId` IN (33); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 12 AND `membership`.`memberId` IN (40); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 12 AND `membership`.`memberId` IN (2); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator the Hon Eric Abetz ','2016-02-17 05:27:53.838 +00:00','2016-02-17 05:27:53.838 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Bridget McKenzie ','2016-02-17 05:27:53.839 +00:00','2016-02-17 05:27:53.839 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 12 AND `membership`.`memberId` IN (41); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 12 AND `membership`.`memberId` IN (42); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',12,14,'2016-02-17 05:27:53.854 +00:00','2016-02-17 05:27:53.854 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',12,33,'2016-02-17 05:27:53.856 +00:00','2016-02-17 05:27:53.856 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Chair ',12,37,'2016-02-17 05:27:53.856 +00:00','2016-02-17 05:27:53.856 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Deputy Chair ',12,2,'2016-02-17 05:27:53.856 +00:00','2016-02-17 05:27:53.856 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',12,20,'2016-02-17 05:27:53.856 +00:00','2016-02-17 05:27:53.856 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',12,40,'2016-02-17 05:27:53.856 +00:00','2016-02-17 05:27:53.856 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',12,41,'2016-02-17 05:27:53.873 +00:00','2016-02-17 05:27:53.873 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',12,42,'2016-02-17 05:27:53.875 +00:00','2016-02-17 05:27:53.875 +00:00'); Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Deborah O''Neill ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Ricky Muir ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Sean Edwards ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Jenny McAllister ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Claire Moore ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator Zed Seselja ' LIMIT 1; Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `members` AS `member` WHERE `member`.`name` = 'Senator John Williams ' LIMIT 1; Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 9 AND `membership`.`memberId` IN (16); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 9 AND `membership`.`memberId` IN (10); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 9 AND `membership`.`memberId` IN (35); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 9 AND `membership`.`memberId` IN (28); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Ricky Muir ','2016-02-17 05:27:55.204 +00:00','2016-02-17 05:27:55.204 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Sean Edwards ','2016-02-17 05:27:55.205 +00:00','2016-02-17 05:27:55.205 +00:00'); Executing (default): INSERT INTO `members` (`id`,`name`,`updatedAt`,`createdAt`) VALUES (NULL,'Senator Jenny McAllister ','2016-02-17 05:27:55.205 +00:00','2016-02-17 05:27:55.205 +00:00'); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 9 AND `membership`.`memberId` IN (43); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 9 AND `membership`.`memberId` IN (44); Executing (default): SELECT `office`, `createdAt`, `updatedAt`, `committeeId`, `memberId` FROM `memberships` AS `membership` WHERE `membership`.`committeeId` = 9 AND `membership`.`memberId` IN (45); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',9,16,'2016-02-17 05:27:55.223 +00:00','2016-02-17 05:27:55.223 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Chair ',9,28,'2016-02-17 05:27:55.225 +00:00','2016-02-17 05:27:55.225 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',9,35,'2016-02-17 05:27:55.225 +00:00','2016-02-17 05:27:55.225 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',9,10,'2016-02-17 05:27:55.225 +00:00','2016-02-17 05:27:55.225 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Deputy Chair ',9,43,'2016-02-17 05:27:55.240 +00:00','2016-02-17 05:27:55.240 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',9,44,'2016-02-17 05:27:55.247 +00:00','2016-02-17 05:27:55.247 +00:00'); Executing (default): INSERT INTO `memberships` (`office`,`committeeId`,`memberId`,`createdAt`,`updatedAt`) VALUES (' Member ',9,45,'2016-02-17 05:27:55.248 +00:00','2016-02-17 05:27:55.248 +00:00');

Data

Downloaded 4 times by MikeRalphson

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (27 KB) Use the API

rows 10 / 45

id name createdAt updatedAt
1
Senator Glenn Lazarus
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
2
Senator the Hon Ian Macdonald
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
3
Senator Chris Ketter
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
4
Senator the Hon Joseph Ludwig
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
5
Senator Larissa Waters
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
6
Senator Rachel Siewert
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00
7
Senator Catryna Bilyk
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00
8
Senator David Fawcett
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00
9
Senator the Hon Mitch Fifield
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00
10
Senator Claire Moore
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (27 KB) Use the API

rows 10 / 20

id name url createdAt updatedAt
1
Appropriations and Staffing
2016-02-17T05:27:42+00:00
2016-02-17T05:27:42+00:00
2
Certain Aspects of the Queensland Government Administration related to Commonwealth Government Affairs
2016-02-17T05:27:43+00:00
2016-02-17T05:27:43+00:00
3
Community Affairs
2016-02-17T05:27:43+00:00
2016-02-17T05:27:43+00:00
4
Economics
2016-02-17T05:27:43+00:00
2016-02-17T05:27:43+00:00
5
Education and Employment
2016-02-17T05:27:43+00:00
2016-02-17T05:27:43+00:00
6
Environment and Communications
2016-02-17T05:27:43+00:00
2016-02-17T05:27:43+00:00
7
Finance and Public Administration
2016-02-17T05:27:43+00:00
2016-02-17T05:27:43+00:00
8
Foreign Affairs, Defence and Trade
2016-02-17T05:27:43+00:00
2016-02-17T05:27:43+00:00
9
Health (Select)
2016-02-17T05:27:43+00:00
2016-02-17T05:27:43+00:00
10
Legal and Constitutional Affairs
2016-02-17T05:27:43+00:00
2016-02-17T05:27:43+00:00

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (27 KB) Use the API

rows 10 / 89

office createdAt updatedAt committeeId memberId
Chair
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
2
1
Member
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
2
5
Member
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
2
3
Deputy Chair
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
2
4
Member
2016-02-17T05:27:44+00:00
2016-02-17T05:27:44+00:00
2
2
Member
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00
18
7
Member
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00
18
10
The Palmer United Party Whip
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00
18
11
The Government Whip (Chair)
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00
18
12
The Nationals Whip
2016-02-17T05:27:45+00:00
2016-02-17T05:27:45+00:00
18
13

Statistics

Average successful run time: 2 minutes

Total run time: 2 minutes

Total cpu time used: less than 5 seconds

Total disk space used: 53.8 KB

History

  • Manually ran revision e53fceba and completed successfully .
    156 records added in the database
    29 pages scraped
  • Created on morph.io