BridgeMan Images Database
Dec 2020
Domain:
bridgemanimages.co.uk
Breach Count:
297,303
Region:
Global
News Report:
-
Leak from:
File Size:
207.01 MB
Uncompressed File Size:
2.21 GB
File Count:
13
The BridgeMan Images Database leak occurred on 2020 from the UK. The database, which can be accessed through bridgemanimages.co.uk, was compromised, resulting in the exposure of a massive 297,303 records.nThe leaked information includes images and text data related to the BridgeMan Images Database, which is a platform that provides access to a vast library of images and creative content.
The affected data includes full-resolution images, image metadata, and other related information. The leak also includes database connection details, username, and password, which could allow attackers to further exploit the system.
The BridgeMan Images Database leak highlights the importance of cybersecurity and the need for organizations to ensure the protection of their sensitive data and systems.
Leaked Information:
Full Name
Email
Phone
Password
Address
We have loaded this breach into our database.
File List:
addresses.sql
clients.sql
clients_backup_2018_04_24.sql
clients_backup_2020_01_28_1553.sql
clients_temp.sql
contactmethods.sql
contacts.sql
creators.sql
invoices.sql
orderitems.sql
orders.sql
projectdeliverycontacts.sql
registrations.sql
File Content Sample:
INSERT INTO `clients` (`client_id`, `client_loan_period`, `client_accountstatus_id`, `client_account_manager_id`, `client_research_manager_id`, `client_rights_manager_id`, `client_currency_id`, `client_vat_number`, `client_credit_limit`, `client_credit_term_days`, `client_referrer_id`, `client_referrer_other`, `client_courier`, `client_courier_ref`, `client_publication`, `client_search_keys`, `client_notes`, `client_marketing_notes`, `client_key_account`, `client_account_notes`, `client_pre_paid_search`, `client_self_billing`, `client_credit_style`, `client_vat_registered`, `client_multi_currency`, `client_credit_charge_applies`, `client_on_sap`, `client_web_download_limit`, `client_created`, `client_last_modified`, `client_created_contact_id`, `client_last_modified_contact_id`, `client_parent_id`, `client_office_id`, `client_name`, `client_code`, `client_glssource`, `client_legal_name`, `client_comments`, `client_gls_id`, `client_company_pimms_guid`, `client_company_pimms_uuid`, `client_pimms_guid`, `client_pimms_uuid`, `client_deleted`, `client_clientcreditstyle_id`, `client_clienttype_id`, `client_clientstatus_id`, `client_email_news`, `client_email_news_date`, `client_vat_registration_status`, `client_sap_status`, `client_last_sap_sync`, `client_clientclassification_level_4_id`, `client_creditterm_id`, `client_latepaymentterm_id`, `client_sap_cardcode`, `client_credit_status`, `client_busdev_manager_id`, `client_chase_projects`, `client_allow_unlimited_downloads`, `client_auto_email_invoices`, `client_autoemail_cc_account_manager`, `client_autoemail_cc_delivery_contact`, `client_print_invoices`, `client_fast_download`, `client_vat_override`, `client_country_unique_code`, `client_guest`, `client_it_fiscal_code`, `client_it_invoice_code`, `client_it_legal_email`, `client_it_cig_code`, `client_it_cup_code`, `client_it_invoice_type`) VALUES
(1, 90, 1, 112, 115, 0, 1, '', 5000.00, 30, 1, 'Other Source', '', '', '', 'MARSHALL CAVENDISH LTD.,[email protected],W1F OUW,MCL', NULL, '', 0, ' **have changed \'return by\' date to automatic 90 DAY PERIOD\r
Angela Griggs:Picture editor - contact her for chasing ', 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:03', '2018-08-24 10:56:44', 1, 106916, NULL, 1, 'Marshall Cavendish Ltd', 'MAR090588', 'E', 'Marshall Cavendish Ltd', NULL, 1, '7A921E60-8342-48F8-8255-44B72D807CE9', 90588, '1DE2FFC7-19A4-4BEA-9B6F-CFEB522DBFAA', 89713, 0, 2, 1, 4, 1, NULL, 'not_registered', 'update_sap', '2014-01-30 11:01:26', 4, 2, NULL, NULL, 'CC', NULL, 1, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 42, 1, 55, 0, 0, 2, '', 500.00, 45, 1, 'Other Source', '', '', '', 'ANNE LAUPRETE,[email protected],FREE LANCE', '9012345678', 'a travaille chez milan puis en free lance', 0, ' ', 0.00, 0, NULL, 0, 0, 0, 1, 0, '2008-06-01 15:07:04', '2018-07-10 09:00:40', 1, 55, NULL, 2, 'Pénélope Estrada', 'ANN090589', 'E', 'Pénélope Estrada', NULL, 2, 'C30E0148-2D79-48C1-9BEE-0EF4657F20BA', 90589, '28F95F7C-56D6-4A06-BE96-8138D0E5594C', 89714, 0, 4, 2, 4, 0, NULL, 'not_registered', 'sap_updated', '2018-07-10 09:00:56', 45, 7, NULL, 'C000ANN090589', 'CA', NULL, 0, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 42, 1, 112, 18, 0, 1, NULL, 100.00, 30, 8, NULL, NULL, NULL, NULL, 'REID & CASEMENT RESEARCH,[email protected],W1R 5LF,REID CASEMENT,W1R5LF', NULL, NULL, 0, NULL, 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:04', '2008-06-01 15:07:04', 1, 1, NULL, 1, 'Reid & Casement Research', 'REI090590', 'E', 'Reid & Casement Research', NULL, 3, 'DEFEEC15-E72E-4F62-AE7F-5529352B1388', 90590, '8382C907-7583-4D7B-96AD-D77C9F6FD5B4', 89715, 0, 2, 1, 3, 1, NULL, 'not_registered', 'update_sap', NULL, 20, 2, NULL, NULL, NULL, NULL, 1, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 90, 3, 172404, 18, 0, 1, NULL, 100.00, 30, 1, 'Other Source', NULL, NULL, 'Reader\'s Digest', 'THE READER\'S DIGEST ASSOCIATION LTD,READER\'S DIGEST,[email protected],E14 4HE,DIGEST,LTD,RD,READERS DIGEST,READERS DOGEST,THE READER\'S DIGEST ASSOCIATION LIMITED,[email protected]', NULL, NULL, 0, 'THIS CODE IS FOR READER\'S DIGEST GENERAL BOOKS\r
Any trans for Helen Ashford should be bkd out to Condensed\r
Books/code 11407\r
NEVER SEND MASTERS\r
MUST HAVE PURCHASE ORDER NO.', 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:05', '2014-09-02 15:12:57', 1, 105887, NULL, 1, 'The Reader\'s Digest Association Ltd', 'THE090591', 'E', 'The Readers Digest Association Ltd', NULL, 4, '90E332CD-80A3-479E-8D90-851082D52743', 90591, '7C9ECA2E-F780-4E1F-9D22-05E52D42CA8F', 89716, 0, 2, 1, 3, 1, NULL, 'not_registered', 'sap_updated', '2014-09-02 15:13:30', 1, 2, NULL, 'C000THE090591', 'CC', NULL, 1, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 42, 1, 47, 43, 0, 2, NULL, 500.00, 45, 6, NULL, NULL, NULL, NULL, 'BIBLIOTHEQUE NATIONALE DE LUXEMBOURG,[email protected],EMILE VAN DER VEKENE', NULL, 'website', 0, NULL, 0.00, 0, NULL, 0, 0, 0, 1, 0, '2008-06-01 15:07:05', '2014-04-16 13:59:45', 1, 47, NULL, 2, 'Bibliotheque Nationale de Luxembourg', 'BIB090592', 'E', 'Bibliotheque Nationale de Luxembourg', NULL, 5, '0C770158-B880-4AD7-BD53-7F33F9B75778', 90592, '4F0F0540-1202-4B3A-935B-45FFF136FC8A', 89717, 0, 2, 1, 2, 0, NULL, 'not_registered', 'sap_updated', '2014-04-16 13:59:47', 2, 7, 2, 'C000BIB090592', 'CA', 0, 0, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 42, NULL, 146099, 18, 0, 1, '', 100.00, 30, 1, 'Other Source', '', '', 'New Scientist', 'REED BUSINESS INFORMATION LTD,NEW SCIENTIST,WC1 8NS,LUDIVINE MOREL,[email protected] [email protected]', NULL, '', 0, ' *********Next to PROJECT: please write NEW SCIENTIST***** ', 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:06', '2019-06-18 11:47:11', 1, 146099, NULL, 1, 'Reed Business Information Ltd', 'REE090593', 'E', 'Reed Business Information Ltd', NULL, 6, '678515C2-B1D7-4AA4-8DCD-C6AE6180C25D', 90593, '9149D1B8-D1AE-43E2-8261-2496F5EE1855', 89718, 0, 2, 1, 4, 1, NULL, 'not_registered', 'sap_updated', '2019-06-18 11:39:38', 14, 2, NULL, 'C000REE090593', 'H', NULL, 1, NULL, 0, 0, 0, 1, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 42, 1, 0, 0, 0, 1, NULL, 500.00, 30, 1, 'Other Source', NULL, NULL, NULL, 'MEADOW', '9012345678', NULL, 0, NULL, 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:06', '2008-06-01 15:07:06', 1, 1, NULL, 1, 'meadow', 'MEA090594', 'E', 'meadow', '9012345678', 7, 'DB050BCC-3234-4134-B947-62A4BCED5AF3', 90594, '002B1C86-DC0F-4146-98C9-CCA36D9719F8', 89719
INSERT INTO `contacts` (`contact_id`, `contact_office_id`, `contact_title`, `contact_first_name`, `contact_middle_name`, `contact_last_name`, `contact_suffix`, `contact_display_as`, `contact_gender`, `contact_department`, `contact_job_title`, `contact_telephone`, `contact_initials`, `contact_gls_initials`, `contact_is_default`, `contact_guest`, `contact_is_primary`, `contact_is_staff`, `contact_studio_status`, `contact_manager_name`, `contact_assistant_name`, `contact_email`, `contact_staff_user_id`, `contact_username`, `contact_password`, `contact_password_hash`, `contact_password_sha1`, `contact_comments`, `contact_created`, `contact_last_modified`, `contact_created_contact_id`, `contact_last_modified_contact_id`, `contact_pimms_guid`, `contact_pimms_uuid`, `contact_gls_id`, `contact_deleted`, `contact_current_lightbox_id`, `contact_owner_id`, `contact_owner_type`, `contact_type_other`, `contact_address_id`, `contact_email_newsletter`, `contact_results_per_page`, `contact_thumbnail_size`, `contact_current_project_id`, `contact_registration_id`, `contact_reset_password_key`, `contact_phone`, `contact_mobile`, `contact_fax`, `contact_second_email`, `contact_second_phone`, `contact_third_phone`, `contact_second_fax`, `contact_sap_status`, `contact_last_sap_sync`, `contact_id_SAP_L`, `contact_id_SAP_P`, `contact_id_SAP_B`, `contact_id_SAP_N`, `contact_status`, `contact_current_office_id`, `contact_display_metadataformat_id`, `contact_email_is_shared`, `contact_breadcrumb_format`, `contact_search_assettype_id`, `contact_password_salt`, `contact_wp_token_value`, `contact_wp_token_expire`, `contact_wp_ip`, `contact_wp_user_id`, `contact_wp_magic_token_value`, `contact_wp_magic_token_expire`, `contact_reset_password_key_log`, `contact_sync_to_hubspot`) VALUES
(0, 1, NULL, 'System User', NULL, 'System User', NULL, 'System User', 'M', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 1, 'no', NULL, NULL, NULL, 'System User', 'System User', 'u234190437023914782341asdklfja9', NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'update_sap', '2013-11-27 16:38:36', NULL, NULL, NULL, NULL, 'dead', 1, NULL, 0, 'projects_lightboxes_auto', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),
(1, 1, NULL, 'dataloader', NULL, 'dataloader', NULL, 'dataloader', 'M', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 1, 'no', NULL, NULL, NULL, 'dataloader', 'dataloader', 'guest', NULL, '{SHA}nGaEjuemGMTzqFu+bv7IiLjeBDk=', NULL, '2008-05-22 09:08:49', '2008-05-22 09:08:49', 1, 1, '8FD9FF71-56F1-4449-B4D1-9E73A3128F9A', 685, 0, 1, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dead', 1, NULL, 0, 'projects_lightboxes_auto', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),
(2, 1, NULL, 'Georgina', NULL, 'French', NULL, 'Georgina French_', 'M', NULL, NULL, NULL, 'GF', NULL, 0, 0, 0, 1, 'no', NULL, NULL, '[email protected]', 'gfrench', 'GFrench', 'guest', NULL, '{SHA}JqusPMMUYauxv6aSDzcKhzrXpto=', NULL, '2008-05-22 09:08:49', '2009-10-20 13:08:58', 1, 70, 'C8851EB4-8218-42BB-B2F1-A50B6DE7E95E', 686, 1, 1, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dead', 1, NULL, 0, 'projects_lightboxes_auto', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),
(3, 1, NULL, 'Martha', NULL, 'Lineham', NULL, 'Martha Lineham', 'M', NULL, NULL, NULL, 'ML', 'HA', 0, 0, 0, 0, 'no', NULL, NULL, '[email protected]', 'mlineham', 'MLineham', 'guest', NULL, '{SHA}2ZAcs1tb5pTF20DHpO2XxyH21DE=', NULL, '2008-05-22 09:08:49', '2009-10-20 13:15:13', 1, 70, '90B6B1E1-E63F-48A5-B2DD-069535D38EC1', 687, 5, 1, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dead', 1, NULL, 0, 'projects_lightboxes_auto', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),
(1, 90, 1, 112, 115, 0, 1, '', 5000.00, 30, 1, 'Other Source', '', '', '', 'MARSHALL CAVENDISH LTD.,[email protected],W1F OUW,MCL', NULL, '', 0, ' **have changed \'return by\' date to automatic 90 DAY PERIOD\r
Angela Griggs:Picture editor - contact her for chasing ', 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:03', '2018-08-24 10:56:44', 1, 106916, NULL, 1, 'Marshall Cavendish Ltd', 'MAR090588', 'E', 'Marshall Cavendish Ltd', NULL, 1, '7A921E60-8342-48F8-8255-44B72D807CE9', 90588, '1DE2FFC7-19A4-4BEA-9B6F-CFEB522DBFAA', 89713, 0, 2, 1, 4, 1, NULL, 'not_registered', 'update_sap', '2014-01-30 11:01:26', 4, 2, NULL, NULL, 'CC', NULL, 1, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 42, 1, 55, 0, 0, 2, '', 500.00, 45, 1, 'Other Source', '', '', '', 'ANNE LAUPRETE,[email protected],FREE LANCE', '9012345678', 'a travaille chez milan puis en free lance', 0, ' ', 0.00, 0, NULL, 0, 0, 0, 1, 0, '2008-06-01 15:07:04', '2018-07-10 09:00:40', 1, 55, NULL, 2, 'Pénélope Estrada', 'ANN090589', 'E', 'Pénélope Estrada', NULL, 2, 'C30E0148-2D79-48C1-9BEE-0EF4657F20BA', 90589, '28F95F7C-56D6-4A06-BE96-8138D0E5594C', 89714, 0, 4, 2, 4, 0, NULL, 'not_registered', 'sap_updated', '2018-07-10 09:00:56', 45, 7, NULL, 'C000ANN090589', 'CA', NULL, 0, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 42, 1, 112, 18, 0, 1, NULL, 100.00, 30, 8, NULL, NULL, NULL, NULL, 'REID & CASEMENT RESEARCH,[email protected],W1R 5LF,REID CASEMENT,W1R5LF', NULL, NULL, 0, NULL, 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:04', '2008-06-01 15:07:04', 1, 1, NULL, 1, 'Reid & Casement Research', 'REI090590', 'E', 'Reid & Casement Research', NULL, 3, 'DEFEEC15-E72E-4F62-AE7F-5529352B1388', 90590, '8382C907-7583-4D7B-96AD-D77C9F6FD5B4', 89715, 0, 2, 1, 3, 1, NULL, 'not_registered', 'update_sap', NULL, 20, 2, NULL, NULL, NULL, NULL, 1, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 90, 3, 172404, 18, 0, 1, NULL, 100.00, 30, 1, 'Other Source', NULL, NULL, 'Reader\'s Digest', 'THE READER\'S DIGEST ASSOCIATION LTD,READER\'S DIGEST,[email protected],E14 4HE,DIGEST,LTD,RD,READERS DIGEST,READERS DOGEST,THE READER\'S DIGEST ASSOCIATION LIMITED,[email protected]', NULL, NULL, 0, 'THIS CODE IS FOR READER\'S DIGEST GENERAL BOOKS\r
Any trans for Helen Ashford should be bkd out to Condensed\r
Books/code 11407\r
NEVER SEND MASTERS\r
MUST HAVE PURCHASE ORDER NO.', 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:05', '2014-09-02 15:12:57', 1, 105887, NULL, 1, 'The Reader\'s Digest Association Ltd', 'THE090591', 'E', 'The Readers Digest Association Ltd', NULL, 4, '90E332CD-80A3-479E-8D90-851082D52743', 90591, '7C9ECA2E-F780-4E1F-9D22-05E52D42CA8F', 89716, 0, 2, 1, 3, 1, NULL, 'not_registered', 'sap_updated', '2014-09-02 15:13:30', 1, 2, NULL, 'C000THE090591', 'CC', NULL, 1, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 42, 1, 47, 43, 0, 2, NULL, 500.00, 45, 6, NULL, NULL, NULL, NULL, 'BIBLIOTHEQUE NATIONALE DE LUXEMBOURG,[email protected],EMILE VAN DER VEKENE', NULL, 'website', 0, NULL, 0.00, 0, NULL, 0, 0, 0, 1, 0, '2008-06-01 15:07:05', '2014-04-16 13:59:45', 1, 47, NULL, 2, 'Bibliotheque Nationale de Luxembourg', 'BIB090592', 'E', 'Bibliotheque Nationale de Luxembourg', NULL, 5, '0C770158-B880-4AD7-BD53-7F33F9B75778', 90592, '4F0F0540-1202-4B3A-935B-45FFF136FC8A', 89717, 0, 2, 1, 2, 0, NULL, 'not_registered', 'sap_updated', '2014-04-16 13:59:47', 2, 7, 2, 'C000BIB090592', 'CA', 0, 0, NULL, 0, 0, 0, 1, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 42, NULL, 146099, 18, 0, 1, '', 100.00, 30, 1, 'Other Source', '', '', 'New Scientist', 'REED BUSINESS INFORMATION LTD,NEW SCIENTIST,WC1 8NS,LUDIVINE MOREL,[email protected] [email protected]', NULL, '', 0, ' *********Next to PROJECT: please write NEW SCIENTIST***** ', 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:06', '2019-06-18 11:47:11', 1, 146099, NULL, 1, 'Reed Business Information Ltd', 'REE090593', 'E', 'Reed Business Information Ltd', NULL, 6, '678515C2-B1D7-4AA4-8DCD-C6AE6180C25D', 90593, '9149D1B8-D1AE-43E2-8261-2496F5EE1855', 89718, 0, 2, 1, 4, 1, NULL, 'not_registered', 'sap_updated', '2019-06-18 11:39:38', 14, 2, NULL, 'C000REE090593', 'H', NULL, 1, NULL, 0, 0, 0, 1, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 42, 1, 0, 0, 0, 1, NULL, 500.00, 30, 1, 'Other Source', NULL, NULL, NULL, 'MEADOW', '9012345678', NULL, 0, NULL, 0.00, 0, NULL, 0, 0, 1, 1, 0, '2008-06-01 15:07:06', '2008-06-01 15:07:06', 1, 1, NULL, 1, 'meadow', 'MEA090594', 'E', 'meadow', '9012345678', 7, 'DB050BCC-3234-4134-B947-62A4BCED5AF3', 90594, '002B1C86-DC0F-4146-98C9-CCA36D9719F8', 89719
INSERT INTO `contacts` (`contact_id`, `contact_office_id`, `contact_title`, `contact_first_name`, `contact_middle_name`, `contact_last_name`, `contact_suffix`, `contact_display_as`, `contact_gender`, `contact_department`, `contact_job_title`, `contact_telephone`, `contact_initials`, `contact_gls_initials`, `contact_is_default`, `contact_guest`, `contact_is_primary`, `contact_is_staff`, `contact_studio_status`, `contact_manager_name`, `contact_assistant_name`, `contact_email`, `contact_staff_user_id`, `contact_username`, `contact_password`, `contact_password_hash`, `contact_password_sha1`, `contact_comments`, `contact_created`, `contact_last_modified`, `contact_created_contact_id`, `contact_last_modified_contact_id`, `contact_pimms_guid`, `contact_pimms_uuid`, `contact_gls_id`, `contact_deleted`, `contact_current_lightbox_id`, `contact_owner_id`, `contact_owner_type`, `contact_type_other`, `contact_address_id`, `contact_email_newsletter`, `contact_results_per_page`, `contact_thumbnail_size`, `contact_current_project_id`, `contact_registration_id`, `contact_reset_password_key`, `contact_phone`, `contact_mobile`, `contact_fax`, `contact_second_email`, `contact_second_phone`, `contact_third_phone`, `contact_second_fax`, `contact_sap_status`, `contact_last_sap_sync`, `contact_id_SAP_L`, `contact_id_SAP_P`, `contact_id_SAP_B`, `contact_id_SAP_N`, `contact_status`, `contact_current_office_id`, `contact_display_metadataformat_id`, `contact_email_is_shared`, `contact_breadcrumb_format`, `contact_search_assettype_id`, `contact_password_salt`, `contact_wp_token_value`, `contact_wp_token_expire`, `contact_wp_ip`, `contact_wp_user_id`, `contact_wp_magic_token_value`, `contact_wp_magic_token_expire`, `contact_reset_password_key_log`, `contact_sync_to_hubspot`) VALUES
(0, 1, NULL, 'System User', NULL, 'System User', NULL, 'System User', 'M', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 1, 'no', NULL, NULL, NULL, 'System User', 'System User', 'u234190437023914782341asdklfja9', NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'update_sap', '2013-11-27 16:38:36', NULL, NULL, NULL, NULL, 'dead', 1, NULL, 0, 'projects_lightboxes_auto', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),
(1, 1, NULL, 'dataloader', NULL, 'dataloader', NULL, 'dataloader', 'M', NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 1, 'no', NULL, NULL, NULL, 'dataloader', 'dataloader', 'guest', NULL, '{SHA}nGaEjuemGMTzqFu+bv7IiLjeBDk=', NULL, '2008-05-22 09:08:49', '2008-05-22 09:08:49', 1, 1, '8FD9FF71-56F1-4449-B4D1-9E73A3128F9A', 685, 0, 1, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dead', 1, NULL, 0, 'projects_lightboxes_auto', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),
(2, 1, NULL, 'Georgina', NULL, 'French', NULL, 'Georgina French_', 'M', NULL, NULL, NULL, 'GF', NULL, 0, 0, 0, 1, 'no', NULL, NULL, '[email protected]', 'gfrench', 'GFrench', 'guest', NULL, '{SHA}JqusPMMUYauxv6aSDzcKhzrXpto=', NULL, '2008-05-22 09:08:49', '2009-10-20 13:08:58', 1, 70, 'C8851EB4-8218-42BB-B2F1-A50B6DE7E95E', 686, 1, 1, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dead', 1, NULL, 0, 'projects_lightboxes_auto', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),
(3, 1, NULL, 'Martha', NULL, 'Lineham', NULL, 'Martha Lineham', 'M', NULL, NULL, NULL, 'ML', 'HA', 0, 0, 0, 0, 'no', NULL, NULL, '[email protected]', 'mlineham', 'MLineham', 'guest', NULL, '{SHA}2ZAcs1tb5pTF20DHpO2XxyH21DE=', NULL, '2008-05-22 09:08:49', '2009-10-20 13:15:13', 1, 70, '90B6B1E1-E63F-48A5-B2DD-069535D38EC1', 687, 5, 1, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dead', 1, NULL, 0, 'projects_lightboxes_auto', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),