Sql Mix Arcangel.com Sql

Sql Mix Arcangel.com Sql

danaya

User
0
LEVEL RANK
User ID
3164
Aug 23, 2022
41
392
#CR
69
  • Thread starter
  • Thread Author
  • #1
arcangel.com
Dump date 04.2024
SQL (accounts, leads) 176MB unpacked

If link is expiried send me msg and I will reupload it!

INSERT INTO `accounts` (`id`, `name`, `date_entered`, `date_modified`, `date_indexed`, `modified_user_id`, `created_by`, `description`, `deleted`, `tags`, `assigned_user_id`, `name_2`, `account_type`, `industry`, `annual_revenue`, `phone_fax`, `is_inactive`, `billing_address_street`, `billing_address_street_2`, `billing_address_street_3`, `billing_address_street_4`, `billing_address_street_number`, `billing_address_street_suffix`, `billing_address_attn`, `billing_address_city`, `billing_address_district`, `billing_address_state`, `billing_address_postalcode`, `billing_address_pobox`, `billing_address_country`, `billing_address_latitude`, `billing_address_longitude`, `billing_address_georesult`, `rating`, `phone_office`, `phone_alternate`, `website`, `ownership`, `employees`, `ticker_symbol`, `shipping_address_street`, `shipping_address_street_2`, `shipping_address_street_3`, `shipping_address_street_4`, `shipping_address_street_number`, `shipping_address_street_number_suffix`, `shipping_address_attn`, `shipping_address_city`, `shipping_address_district`, `shipping_address_state`, `shipping_address_postalcode`, `shipping_address_pobox`, `shipping_address_country`, `shipping_address_latitude`, `shipping_address_longitude`, `shipping_address_georesult`, `company_logo`, `parent_id`, `sic_code`, `campaign_id`, `ext_id`, `vat_nr`, `vat_details`, `first_name`, `last_name`, `display_name`, `system_id`, `login_id`, `fast_id`, `company_name`, `Continent`, `accounting_number`, `source_status`, `royal_rate`, `copyright`, `sales_contact @fbi_gov `, `source_agent_firstname`, `source_agent_lastname`, `source_agent_fastid`, `company_text`, `administrator`, `group_for_this_cotact`, `royalty_distribution_type`, `royalty_distribution_period`, `record_id`, `identifier`, `source_royalty_rate`, `currency`, `companycode_id`, `royalty_payment_method`, `royalty_payment_method_other`, `paypal_email`, `bank_details`, `royalty_rate`, `apply_irpf_deduction`, `vat`, `hold_royalties`, `cortex_link`, `irpf_type`) VALUES
('100325aa-4965-bc0c-7e28-65bc8417bf55', 'Arcades Santé', '2024-02-02 05:57:04', '2024-02-02 13:04:20', '2024-03-07 11:05:16', '1', '1', NULL, 0, NULL, NULL, NULL, 'Company', NULL, NULL, '', NULL, '17 rue Rast Maupas', NULL, NULL, NULL, NULL, NULL, NULL, 'Lyon', NULL, '', NULL, NULL, 'France', NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accounts Payable', '', 'Accounts Payable Arcades Santé', 'AA1CT124828865 ', 'AA1CT124828865', NULL, 'Arcades Santé', 'EUR_Price', '43000001487', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, ' Client base access (Security)', NULL, NULL, 'KRQ30AHV2QF', 'AA1CT124828865 ', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, 0, NULL, 'No', NULL, NULL),
('1003e970-28e8-2c6d-9332-65b9f7be993c', 'Kelly Nichols', '2024-01-31 07:30:47', '2024-01-31 07:36:01', '2024-03-07 11:10:13', '1', '1', NULL, 0, NULL, '1', NULL, 'Client', 'Book Publishing', NULL, '9016260802', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Traverse City', NULL, 'MICHIGAN', NULL, NULL, 'United States of America', NULL, NULL, NULL, NULL, '9016260802', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Kelly', 'Nichols', NULL, 'AA2CT6010130', NULL, NULL, 'none', 'USA office', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Client base access (Security)', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, 0, NULL, 'No', NULL, NULL),

INSERT INTO `leads_cstm` (`id_c`, `import_flag_c`, `registration_date_c`, `br_jeanne_darc_c`, `industry_sector_tx_c`, `cdv_2013_c`, `cdv_2014_c`, `invit_pixday_2013_c`, `newsletter_arcangel_c`, `cp_singlefemmes_c`, `status_fr_c`, `language_origin_c`, `middle_name_c`, `area_expertise_c`, `speciality_c`, `area_speciality_c`, `photo_resource_type_c`, `contact @fbi_gov _type_c`, `if_other_contact @fbi_gov _c`, `website_inline_c`, `industry_c`, `stockimage_experience_c`, `other_agencies_c`, `which_agencies_c`, `linkedin_id_c`, `work_examples1_c`, `work_examples2_c`, `work_examples3_c`, `work_examples4_c`, `where_hear_c`, `where_hear_other_c`, `country_code_c`, `web_to_lead_c`, `position_c`, `jobcode_c`, `bkid_c`, `bkcompanyid_c`, `types_c`, `work_phone_c`, `fax_c`, `contributor_industry_c`, `rls_linkedin_account_c`, `rls_linkedin_account2_c`, `rls_industry_c`, `rls_linkedin_url_c`, `rls_description2_c`, `rls_description3_c`, `rls_current_workplace_c`, `rls_last_position_c`, `agency_access_type_c`, `jjwg_maps_geocode_status_c`, `type_c`, `jjwg_maps_lat_c`, `jjwg_maps_lng_c`, `jjwg_maps_address_c`, `website_iframe_c`) VALUES
('6fdbacc3-db66-8687-6be3-532c10a6fa1c', '604Media', NULL, '', 'Department Stores', '', '', '', '', '', '', 'English', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00000000, 0.00000000, NULL, NULL),
('6fdbe7f4-d172-043c-9285-56a657d101a0', 'UK_Graphic_Design-25Jan2016', NULL, '', NULL, '', '', '', '', '', '', '', '', '^^', '^^', '^^', '^^', 'Customer', NULL, '{linkedin_id_c}', NULL, NULL, '', '', '', NULL, '', '', '', '', NULL, '44', '0', 'Designer', 'GD', 'BK10072583', '646', 'Graphic Design', '0117 923 2282', '0117 924 1269', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00000000, 0.00000000, NULL, NULL),
 
Last edited:
Thanks for this share
Post automatically merged:

Only Premium Access
 
Back
Top Bottom