Forum Kurallarını Okumak İçin Lütfen Tıklayınız .

Arcangel.com SqlSql Mix 

Sql Mix Arcangel.com Sql
Joined
Aug 23, 2022
Messages
30
Reaction score
200
#CR
75
arcangel.com
Dump date 04.2024
SQL (accounts, leads) 176MB unpacked

<-New link

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`, `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_type_c`, `if_other_contact_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:
Home Register
Top Bottom