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

Digital Marketing Solutions - R20Digital.com Sql © Chucky 

Sql © Chucky Digital Marketing Solutions - R20Digital.com
Joined
Jun 7, 2021
Messages
4,301
Reaction score
56,158
#CR
172
Today I have uploaded the R20digital.com Database for you to download, thanks for reading and enjoy!
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖

zYkjsbZhlb39iRg__1IysJ-PN6E-960.jpg


HTML:
`leads` (`id`, `account_id`, `first_name`, `last_name`, `lead_status_id`, `lead_direct_status_id`, `leads_category_id`, `lead_category_id`, `company_name`, `phone1`, `phone2`, `address`, `address2`, `city`, `state`, `zip`, `message`, `position`, `converted_lead`, `created_by_user_id`, `assigned_to_user_id`, `assigned_to_group_id`, `updated_by_user_id`, `integration_id`, `integration_relative_id`, `source`, `contact @fbi_gov _method`, `contact @fbi_gov _time`, `make_model`, `points`, `field_1`, `field_2`, `field_3`, `field_4`, `field_5`, `field_6`, `field_7`, `field_8`, `field_9`, `field_10`, `billing_address`, `billing_city`, `billing_state`, `billing_zip`, `reference_1_name`, `reference_1_phone`, `reference_1_relationship`, `reference_2_name`, `reference_2_phone`, `reference_2_relationship`, `employer_name`, `employer_phone`, `employer_payment_amount`, `employer_payment_frequency`, `ssn`, `dob`, `license`)

`versi_customer` (`id`, `r20_account_id`, `RegionID`, `DistrictID`, `STID`, `CustID`, `CUST_TYPE`, `CUSTOMER`, `FIRST_NAME`, `MIDDLE_NAME`, `LAST_NAME`, `ADDRESS`, `APARTMENT`, `CITY`, `STATE`, `ZIP`, `PHONE`, `PHONE_MARKET`, `EMAIL`, `EMAIL_MARKET`, `FLOAT_FUND`, `BONUS_BUCKS`, `BONUS_POINTS`, `FIRST_LEASED`, `LAST_LEASED`)

INSERT INTO `leads` (`id`, `account_id`, `contact @fbi_gov _id`, `first_name`, `last_name`, `lead_status_id`, `lead_direct_status_id`, `leads_category_id`, `lead_category_id`, `company_name`, `phone1`, `phone2`, `address`, `address2`, `city`, `state`, `zip`, `message`, `position`, `converted_lead`, `created_by_user_id`, `assigned_to_user_id`, `assigned_to_group_id`, `updated_by_user_id`, `integration_id`, `integration_relative_id`, `source`, `contact @fbi_gov _method`, `contact @fbi_gov _time`, `make_model`, `points`, `field_1`, `field_2`, `field_3`, `field_4`, `field_5`, `field_6`, `field_7`, `field_8`, `field_9`, `field_10`, `billing_address`, `billing_city`, `billing_state`, `billing_zip`, `reference_1_name`, `reference_1_phone`)


HTML:
(488859, 7, 'Billy', 'Wilson', 6, NULL, NULL, NULL, NULL, '', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 1130, NULL, NULL, NULL, NULL, 'christmas-in-july', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'billywilson02061991@gmail.com', NULL, '2019-07-16 21:24:14', '2019-07-30 17:42:54', NULL, NULL, NULL, 28, NULL, 0, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-07-18 16:18:56', NULL, NULL, '2019-07-30 13:42:54', NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488860, 17, 'Jeffrey', 'harrelson ', 6, NULL, NULL, NULL, NULL, '5154479500', '', '', '', '', '', NULL, 'Gaming', NULL, NULL, 0, 2305, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'logitechworm@gmail.com', NULL, '2019-07-17 01:20:45', '2019-07-17 21:38:46', NULL, NULL, NULL, 152, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, 181341, NULL, 'Gaming', NULL, NULL, NULL, '2019-07-17 17:38:46', NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488861, 17, 'Sherry', '', 6, NULL, NULL, NULL, NULL, '812-549-0829', '', '', '', '', '', NULL, 'Mattress Sets', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'lesley.boyle@aol.com', NULL, '2019-07-17 01:21:25', '2019-07-16 21:25:03', NULL, NULL, NULL, 206, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, 181342, NULL, 'Mattress Sets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488862, 17, 'Jeanie', 'LaVonne ', 6, NULL, NULL, NULL, NULL, '3093406427', '', '', '', '', '', NULL, 'Living Room Sets', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, '2019-07-16 20:13:40', NULL, NULL, 'jeaniekrieg@yahoo.com', NULL, '2019-07-17 01:22:17', '2019-07-17 00:13:40', NULL, NULL, NULL, 180, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, 181343, NULL, 'Living Room Sets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488863, 17, 'Jeanie', 'LaVonne ', 6, NULL, NULL, NULL, NULL, '3093406427', '', '', '', '', '', NULL, 'Living Room Sets', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, '2019-07-16 20:13:23', NULL, NULL, 'jeaniekrieg@yahoo.com', NULL, '2019-07-17 01:22:18', '2019-07-17 00:13:23', NULL, NULL, NULL, 180, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, 181344, NULL, 'Living Room Sets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488864, 17, 'Jeanie', 'LaVonne ', 6, NULL, NULL, NULL, NULL, '3093406427', '', '', '', '', '', NULL, 'Living Room Sets', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, '2019-07-16 20:13:18', NULL, NULL, 'jeaniekrieg@yahoo.com', NULL, '2019-07-17 01:22:23', '2019-07-17 00:13:18', NULL, NULL, NULL, 180, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, 181345, NULL, 'Living Room Sets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),

(14660527, 7, '8/24/2022', 14, 140001175, '14-140001175', 'Shanita', 'Pickens', 'shanita.pickens@gmail.com', 0, '2', '140010687', '12/30/2021', '8/27/2022', '183', '7/1/2022', '', '61', 'Video Games', '1/26/2023', '56', '22', 'Bi-Weekly', '$0.00', '$98.88', '', '', '  (717)649-5412', '  (646)241-7750', '2724 N 6th St', '', 'HARRISBURG', 'PA', '17110', '11', '$12,773.26', NULL, '', '0', NULL, NULL, NULL),
(14660528, 7, '8/24/2022', 14, 140001175, '14-140001175', 'Shanita', 'Pickens', 'shanita.pickens@gmail.com', 0, '2', '140011315', '5/26/2022', '8/27/2022', '183', '11/25/2022', '2391.49', '11', 'Multiple Items', '9/21/2024', '121', '108', 'Bi-Weekly', '$0.00', '$87.39', '', '', '  (717)649-5412', '  (646)241-7750', '2724 N 6th St', '', 'HARRISBURG', 'PA', '17110', '54', '$12,773.26', NULL, '', '0', NULL, NULL, NULL),
(14660529, 7, '8/24/2022', 14, 140001175, '14-140001175', 'Shanita', 'Pickens', 'shanita.pickens@gmail.com', 0, '2', '140011316', '5/26/2022', '8/27/2022', '183', '11/25/2022', '791.61', '14', 'Furn/Bedroom', '2/24/2024', '91', '78', 'Bi-Weekly', '$0.00', '$41.38', '', '', '  (717)649-5412', '  (646)241-7750', '2724 N 6th St', '', 'HARRISBURG', 'PA', '17110', '39', '$12,773.26', NULL, '', '0', NULL, NULL, NULL),
(14660530, 7, '8/24/2022', 14, 140001396, '14-140001396', 'CHERISSE ', 'PICKENS', 'pickenscherisse@gmail.com', 0, '1', '140009969', '8/16/2021', '8/22/2022', '183', '2/15/2022', '', '56', 'Multiple Items', '6/5/2023', '94', '41', 'Weekly', '$70.00', '$0.00', '', '', '  (913)486-5994', '', '2552 GREEN ST ', 'B', 'HARRISBURG', 'PA', '17110', '41', '$7,704.41', NULL, '', '0', NULL, NULL, NULL),
(14660531, 7, '8/24/2022', 14, 140001190, '14-140001190', 'Dwayne ', 'McMillen ', 'DMcMillen@hershocks.com', 1, '201', '140010012', '8/27/2021', '8/26/2022', '365', '8/27/2022', '1593.6', '39', 'Multiple Items', '1/19/2024', '120', '73', 'Weekly', '$0.00', '$70.14', '140001190', '2.99', '  (717)648-7853', '  (804)307-1154', '2407 WHITE OAK RD ', '', 'HALIFAX', 'PA', '17032', '73', '$5,547.73', NULL, '', '0', NULL, NULL, NULL),

INSERT INTO `wow_collections` (`id`, `account_id`, `store_number`, `customer_number`, `first_name`, `last_name`, `email`, `agreement_number`, `days_over_due`, `over_due_amount`, `product`, `created_at`, `updated_at`) VALUES
(731884, 17, 55, '36297', 'KYOTTIA', 'JONES', 'DSRMJD@GMAIL.COM', '150015', 17, '229.98', 'TELLURIDE CHARCOAL', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),
(731885, 17, 55, '36297', 'KYOTTIA', 'JONES', 'DSRMJD@GMAIL.COM', '150015', 17, '229.98', 'TELLURIDE CHARCOAL RECLINER', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),
(731886, 17, 55, '36323', 'MARY', 'GRAHAM', 'MARYGRAHAM8532@GMAIL.COM', '150288', 17, '54.99', '55\" 4K LED ROKU TV', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),
(731887, 17, 55, '36323', 'MARY', 'GRAHAM', 'MARYGRAHAM8532@GMAIL.COM', '159941', 17, '54.99', 'INSIGNIA 4.9CF MINI FRIDGE', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),
(731888, 17, 55, '36484', 'LATOYIA', 'PEARSON', 'LATOYIAPEARSON@YAHOO.COM', '150970', 47, '299.96', 'LARKINHURST SOFA/LOVESEAT', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),

INSERT INTO `voip_call_histories` (`id`, `account_id`, `store_id`, `lead_id`, `domain`, `territory`, `type`, `cdr_id`, `orig_sub`, `orig_from_uri`, `from_number`, `to_number`, `orig_from_name`, `orig_req_uri`, `by_sub`, `term_sub`, `term_to_uri`, `time_start`, `time_answer`, `time_release`, `duration`, `time_talking`, `hide`, `talk`, `expected_trace`, `created_at`, `updated_at`) VALUES
(143626, 34, 344, NULL, 'happys01.com', 'happysnation.com', '0', '1668196608128087487be4fc98b3f476165cd6a6fe', '102', 'sip:8138357711@happys01.com', '8138357711', '8132793896', 'Happy 102', 'sip:8132793896@happys01.com', NULL, NULL, 'sip:18132793896@happys01.com', '2022-11-11 14:56:48', '2022-11-11 14:57:22', '2022-11-11 14:57:52', '00:00:30', '00:00:30', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),
(143627, 34, 350, 1406625, 'happys07.com', 'happysnation.com', '0', '16681965815049d9e62526ad06e46ef9fa409535ca', '102', 'sip:9043613696@happys07.com', '9043613696', '9046761727', 'Happys 102', 'sip:9046761727@happys07.com', NULL, NULL, 'sip:19046761727@happys07.com', '2022-11-11 14:56:21', '2022-11-11 14:56:36', '2022-11-11 14:58:31', '00:01:15', '00:00:00', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),
(143628, 34, 353, NULL, 'happys11.com', 'happysnation.com', '0', '1668196578ee0156b45fd20adcc05db704a4d02ef6', '103', 'sip:3525184688@happys11.com', '3525184688', '8134659286', 'Happys 103', 'sip:8134659286@happys11.com', NULL, NULL, 'sip:18134659286@happys11.com', '2022-11-11 14:56:18', '2022-11-11 14:56:42', '2022-11-11 14:56:47', '00:00:05', '00:00:05', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),
(143629, 34, 350, NULL, 'happys07.com', 'happysnation.com', '0', '16681965655d3564ffb7779d9f9fb9ab513a2d2742', '104', 'sip:9043613696@happys07.com', '9043613696', '9998062', 'Happys Home Centers Inc', 'sip:9998062@happys07.com', NULL, NULL, 'sip:19049998062@happys07.com', '2022-11-11 14:56:05', '2022-11-11 14:56:37', '2022-11-11 14:56:50', '00:00:13', '00:00:13', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),
(143630, 34, 344, NULL, 'happys01.com', 'happysnation.com', '0', '166819654642b34704101fbc435600a902eae99681', '102', 'sip:8138357711@happys01.com', '8138357711', '8135349129', 'Happy 102', 'sip:8135349129@happys01.com', NULL, NULL, 'sip:18135349129@happys01.com', '2022-11-11 14:55:46', '2022-11-11 14:56:18', '2022-11-11 14:56:31', '00:00:13', '00:00:13', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),

INSERT INTO `versi_customer` (`id`, `r20_account_id`, `RegionID`, `DistrictID`, `STID`, `CustID`, `CUST_TYPE`, `CUSTOMER`, `FIRST_NAME`, `MIDDLE_NAME`, `LAST_NAME`, `ADDRESS`, `APARTMENT`, `CITY`, `STATE`, `ZIP`, `PHONE`, `PHONE_MARKET`, `EMAIL`, `EMAIL_MARKET`, `FLOAT_FUND`, `BONUS_BUCKS`, `BONUS_POINTS`, `FIRST_LEASED`, `LAST_LEASED`, `NEXT_PAYOUT`, `LAST_PAYOUT`, `LAST_BUYOUT`, `LAST_UNSAT_BUYOUT`, `LAST_PIF`, `LAST_RTS`, `NEXT_DUE`, `BAL_DUE`, `LAST_DAYS_LATE`, `LATE_TIMES_TOTAL`, `LATE_DAYS_TOTAL`, `LATE_7_PLUS_TOTAL`, `LATE_TIMES_AVG`, `LATE_DAYS_AVG`, `LATE_7_PLUS_AVG`, `TOTAL_MONTHLY`, `DAILY`, `WEEKLY`, `BI_WEEKLY`, `SEMI_MONTHLY`, `MONTHLY`, `TOTAL_RENTAL_PAID`, `AVG_RENTAL_PAID`, `LAST_RTS_RENTAL_PAID`, `CLUB_FLAG`, `CLUB_JOIN_DATE`, `CLUB_TERM_DATE`, `CLUB_DUE_DATE`, `FREE_DAYS`, `FREE_MONEY`, `DEFERRED_TOTAL`, `DEFERRED_AVG`, `DEFERRED_ACTIVE`, `AGREEMENTS`, `PENDING`, `ACTIVE`, `RTS`, `EPO`, `UNSAT_BO`, `PIF`, `RET_BAL`, `HOLD`, `SKIP`, `LEGAL`, `CHARGED_OFF`, `RETAIL_SOLD_NUM`, `RETAIL_SOLD_AMT`, `RETAIL_REFUND_NUM`, `RETAIL_REFUND_AMT`) VALUES
(1830, 7, '1', '1', '1', '646', '3', '101079', 'MIKE', NULL, 'EWOLDSEN', '103 S FORD', NULL, 'HUTCHINSON', 'KS', '67501', '  (  )669-9784', 'NO', NULL, 'NO', '0', NULL, NULL, '7/11/2000 11:04:17 PM', '7/11/2000 11:04:17 PM', NULL, NULL, NULL, NULL, NULL, '7/14/2000', NULL, '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '30', '30', '30', 'N', NULL, NULL, NULL, '0', '0', '-41', '-41', '-41', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(1831, 7, '1', '1', '1', '511', '1', '100775', 'JERRY', NULL, 'EZELL', '311 E F', NULL, 'HUTCHINSON', 'KS', '67501', '  (620)899-2181', 'NO', NULL, 'NO', '0', '0', '620', '4/1/2000 11:04:11 PM', '11/18/2019 4:10:03 PM', '12/3/2020', '8/30/2019 10:38:22 AM', '8/30/2019 10:38:22 AM', NULL, NULL, '4/25/2017', '3/3/2020', '0', '0', '3252', '67', '67', '2.8', '63.8', '1.3', '215.21', NULL, NULL, '0', '0', '67.96', '22778.02', '446.63', '1078.87', 'N', NULL, '11/1/2018', NULL, '1335', '3066.05', '1030.91', '20.213921', '1031.52', '51', '0', '3', '4', '37', '0', '0', '4', '0', '0', '0', '3', '56', '12413.98', '2', '457.65'),
(1832, 7, '1', '1', '1', '7322', '2', '111442', 'PRESCIOUS', NULL, 'EZELL', '2102 E 73RD ST', NULL, 'TULSA', 'OK', '74105', NULL, 'NO', 'APT 10 TULSA,OK', 'NO', '0', NULL, NULL, '10/8/2012 11:12:06 PM', '10/8/2012 11:12:06 PM', NULL, '4/12/2013', '4/12/2013', NULL, NULL, NULL, NULL, '0', '15', '97', '5', '5', '6', '97', '5', '0', NULL, NULL, '0', '0', '0', '351.33', '351.33', '0', 'N', NULL, NULL, NULL, '4', '24.79', '0', '0', '0', '1', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '19', '4664.09', '0', '0'),
(1833, 7, '1', '1', '1', '510', '2', '100774', 'SHANTEL', NULL, 'EZELL', NULL, NULL, 'HUTCHINSON', 'KS', '67501', '  (620)899-1592', 'NO', NULL, 'NO', '0', '0', '0', '4/15/2010 11:10:22 PM', '9/19/2017 2:28:50 PM', NULL, '2/11/2011', '2/11/2011', NULL, NULL, '1/11/2018 11:43:01 AM', NULL, '514.5', '72', '318', '18', '18', '3.8', '53', '3', '0', NULL, NULL, '0', '0', '0', '3662.19', '610.37', '233.9', 'N', NULL, NULL, NULL, '27', '54.96', '483.62', '80.603333', '483.62', '6', '0', '0', '0', '4', '0', '0', '2', '0', '0', '0', '0', '11', '293.17', '0', '0'),

INSERT INTO `subscribers` (`id`, `email`, `first_name`, `last_name`, `fullname`, `phone`, `address`, `city`, `state`, `zip`, `type`, `data`, `ip`, `store_id`, `letter`, `created_at`, `updated_at`, `deleted_at`, `account_id`, `lead_id`, `remote_id`, `contact @fbi_gov _id`) VALUES
(1047823, 'kbagrowski@eichhorn-law.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:07:47', '2022-12-19 12:07:47', NULL, 16, NULL, NULL, 584557),
(1047824, 'kbagrowski@eichhorn-law.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:07:47', '2022-12-19 12:07:47', NULL, 16, NULL, NULL, 584557),
(1047825, 'kbagrowski@eichhorn-law.com', NULL, NULL, 'vhcnpuwxax', '+1 213 425 1453', NULL, NULL, NULL, NULL, 'coupon', NULL, '', 134, 0, '2022-12-19 12:07:54', '2022-12-19 12:07:54', NULL, 16, NULL, NULL, 584557),
(1047832, 'jason.ponder@fedex.com', NULL, NULL, 'jason.ponder', NULL, NULL, NULL, NULL, NULL, 'coupon', NULL, '', NULL, 0, '2022-12-19 12:15:52', '2022-12-19 12:15:52', NULL, 9, NULL, NULL, 582001),
(1047833, 'noegiahosleo1986@yahoo.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:16:43', '2022-12-19 12:16:43', NULL, 6, NULL, NULL, 534095),
(1047840, 'noegiahosleo1986@yahoo.com', NULL, NULL, 'grMvWmOLRjefU', NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:17:12', '2022-12-19 12:17:12', NULL, 6, NULL, NULL, 534095),
(1047841, 'loritiner@verizon.net', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:19:19', '2022-12-19 12:19:19', NULL, 16, NULL, NULL, 582662),
(1047842, 'loritiner@verizon.net', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:19:19', '2022-12-19 12:19:19', NULL, 16, NULL, NULL, 582662),


INSERT INTO `perq_api_log` (`id`, `account_id`, `url`, `method`, `get_data`, `post_data`, `response`, `error`, `created_at`) VALUES
(6007680, 15, 'contact @fbi_gov s/6482767', NULL, '[]', '[]', '{\"account_id\":2908,\"communication_consent_statuses\":\"[{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":0,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":1,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":2,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":3,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":4,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":0,\\\"communication_allowed\\\":false,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":1,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":2,\\\"communication_allowed\\\":false,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":3,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":4,\\\"communication_allowed\\\":false,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null}]\",\"ct_token\":\"zanpptge\",\"probability_to_purchase\":20,\"id\":6482767,\"email\":\"marrod1956@gn\",\"email_2\":null,\"phone\":\"(347) 447-0418\",\"phone_2\":null,\"first_name\":\"Maritza\",\"last_name\":\"Rodriguez\",\"company_name\":null,\"level\":\"1\",\"created_at\":\"2022-06-09T14:06:27.640-04:00\",\"updated_at\":\"2022-10-16T21:30:17.380-04:00\",\"location_id\":4186,\"user_id\":30786,\"notes\":null,\"opt_out_at\":null,\"archived_at\":null,\"token\":\"-9bwYmadIp8YQp9ehBJ9eg\",\"next_follow_up\":null,\"follow_up_note\":null,\"interested_merchandise\":null,\"address_1\":\"\",\"address_2\":\"\",\"city\":\"\",\"state\":\"\",\"postal_code\":\"\",\"projected_sale_amount\":\"0.0\",\"passive_no_count\":true,\"sold\":false,\"last_sold_date\":null,\"external_id\":\"1296356\",\"external_import_from\":null,\"country\":\"United States\",\"batch_import_id\":null,\"merged_into_id\":null,\"perq_consumer_id\":null,\"consumer_config_data\":null,\"phone_search\":\"3474470418\",\"phone_2_search\":null,\"full_name_search\":\"maritza rodriguez\",\"auto_responder_state_id\":null,\"phone_type\":null,\"phone_carrier_name\":null,\"phone_2_type\":null,\"phone_2_carrier_name\":null,\"source_id\":3,\"last_contact @fbi_gov ed_at\":\"2022-06-20T12:43:29.390-04:00\",\"consumer_view_link_sent_at\":null,\"is_test\":false,\"sent_opt_out\":false,\"ai_assistant_enabled\":null,\"sms_opt_in_status\":4,\"email_opt_in_status\":4,\"tag_list\":\"web lead\",\"interested_in_merchandise_list\":\"\",\"nurturing_list\":[],\"last_inquiry_at\":\"2022-06-09T14:06:28.271-04:00\",\"last_sold_at\":null,\"last_contact @fbi_gov _date\":\"2022-09-07T14:06:28.271-04:00\",\"tags\":[{\"id\":3877,\"name\":\"web lead\",\"taggings_count\":65693}],\"interested_in_merchandise\":[],\"contact @fbi_gov _attachments\":[],\"user\":{\"firstName\":\"Amin\",\"lastName\":\"Akram\",\"employee_code\":\"\"},\"location\":{\"id\":4186,\"description\":\"Columbus West\"},\"contact @fbi_gov _activities\":[],\"perq\":false,\"within_tcpa_period\":false,\"time_remaining_in_words\":\"Do Not contact @fbi_gov \",\"perq_data\":[],\"contact @fbi_gov _deals\":[{\"id\":4444904,\"contact @fbi_gov _id\":6482767,\"user_id\":30786,\"name\":null,\"description\":\"$0.00 for :  () $ \",\"projected_sale_amount\":\"0.0\",\"probability_to_purchase\":20,\"status_id\":2,\"projected_closed_at\":null,\"closed_at\":\"2022-06-09T00:00:00.000-04:00\",\"lost_reason\":\"No Response / disco number\",\"created_at\":\"2022-06-09T14:06:28.271-04:00\",\"updated_at\":\"2022-06-09T15:49:32.543-04:00\",\"account_id\":2908,\"location_id\":4186,\"batch_import_id\":null,\"pipeline_id\":2913,\"pipeline_stage_id\":10440,\"external_id\":null,\"followed_up_on_at\":null,\"last_activity_at\":\"2022-06-09T15:49:32.543-04:00\",\"auto_closed\":null,\"perq_generated\":false,\"workflow_id\":null,\"interested_in_merchandise_list\":[\":  () $\"],\"tag_list\":[\"promotional leads\"],\"pipeline_stage\":{\"id\":10440,\"pipeline_id\":2913,\"description\":\"Lost\",\"info\":\"Lost\",\"order\":7,\"created_at\":\"2022-02-04T14:15:50.497-05:00\",\"updated_at\":\"2022-02-04T14:15:50.497-05:00\",\"color_code\":\"#694fd9\"},\"interested_in_merchandise\":[{\"id\":38347,\"name\":\":  () $\",\"taggings_count\":9039}],\"tags\":[{\"id\":43364,\"name\":\"promotional leads\",\"taggings_count\":48926}],\"user\":{\"firstName\":\"Amin\",\"lastName\":\"Akram\",\"employee_code\":\"\"}}],\"active_deals\":[],\"scheduled_contact @fbi_gov _appointments\":[],\"combined_activities\":[{\"ca_type\":\"activity\",\"id\":4941098,\"location_description\":\"Columbus West\",\"user_id\":30786,\"user_name\":\"Amin Akram\",\"contact @fbi_gov _deal_id\":null,\"contact @fbi_gov _activity_type_id\":2,\"description\":null,\"due_at\":null,\"completed_at\":\"2022-06-20T12:43:29.327-04:00\",\"notes\":\"\",\"created_at\":\"2022-06-20T12:43:29.335-04:00\",\"updated_at\":\"2022-06-20T12:43:29.335-04:00\",\"contact @fbi_gov _id\":6482767,\"tag_list\":[\"phone\"],\"user\":{\"firstName\":\"Amin\",\"lastName\":\"Akram\",\"employee_code\":\"\"}},{\"ca_type\":\"log\",\"by_user\":\"Amin Akram\",\"created_at\":\"2022-06-09T15:49:35.979-04:00\",\"completed_at\":\"2022-06-09T15:49:35.979-04:00\",\"type_id\":6,\"source_id\":3,\"description\":\"Activity Updated\",\"changed_fields\":{\"fields\":[{\"name\":\"completed_at\",\"before\":null,\"after\":\"2022-06-09T15:49:35.963-04:00\"}]},\"notes\":\"Completed At was changed from \'\' to \'2022-06-09T15:49:35.963-04:00\'.\"},{\"ca_type\":\"activity\",\"id\":4905558,\"location_description\":\"Columbus West\",\"user_id\":30786,\"user_name\":\"Amin Akram\",\"contact @fbi_gov _deal_id\":null,\"contact @fbi_gov _activity_type_id\":2,\"description\":null,\"due_at\":\"2022-06-09T00:00:00.000-04:00\",\"completed_at\":\"2022-06-09T15:49:35.963-04:00\",\"notes\":\"Showplace Rent-To-Own Web Lead: :  () $ \",\"created_at\":\"2022-06-09T14:06:28.516-04:00\",\"updated_at\":\"2022-06-09T15:49:35.963-04:00\",\"contact @fbi_gov _id\":6482767,\"tag_list\":[],\"user\":{\"firstName\":\"Amin\",\"lastName\":\"Akram\",\"employee_code\":\"\"}},{\"ca_type\":\"log\",\"by_user\":\"Amin Akram\",\"created_at\":\"2022-06-09T15:49:32.747-04:00\",\"completed_at\":\"2022-06-09T15:49:32.747-04:00\",\"type_id\":10,\"source_id\":3,\"description\":\"Deal Updated\",\"changed_fields\":{\"fields\":[{\"name\":\"probability_to_purchase\",\"before\":null,\"after\":20},{\"name\":\"status_id\",\"before\":0,\"after\":2},{\"name\":\"closed_at\",\"before\":null,\"after\":\"2022-06-09T00:00:00.000-04:00\"},{\"name\":\"lost_reason\",\"before\":null,\"after\":\"No Response / disco number\"},{\"name\":\"pipeline_stage_id\",\"before\":10257,\"after\":10440},{\"name\":\"last_activity_at\",\"before\":\"2022-06-09T14:06:28.455-04:00\",\"after\":\"2022-06-09T15:49:32.543-04:00\"},{\"name\":\"interested_in_merchandise_list\",\"before\":[\":  () $\"],\"after\":null},{\"name\":\"tag_list\",\"before\":[\"promotional leads\"],\"after\":null}]},\"notes\":\"Probability To Purchase was changed from \'\' to \'20\'. Status was changed from \'0\' to \'2\'. Closed At was changed from \'\' to \'2022-06-09T00:00:00.000-04:00\'. Lost Reason was changed from \'\' to \'No Response / disco number\'. Pipeline Stage was changed from \'10257\' to \'10440\'. Last Activity At was changed from \'2022-06-09T14:06:28.455-04:00\' to \'2022-06-09T15:49:32.543-04:00\'. Interested In Merchandise List was changed from \'[\\\":  () $\\\"]\' to \'\'. Tag List was changed from \'[\\\"promotional leads\\\"]\' to \'\'.\"},{\"ca_type\":\"reassignment\",\"by_user\":\"System Account\",\"from_user\":null,\"to_user\":\"Amin Akram\",\"reason\":null,\"notes\":\"Auto-Assign\",\"completed_at\":\"2022-06-09T15:31:49.814-04:00\"},{\"ca_type\":\"log\",\"by_user\":\"API User\",\"created_at\":\"2022-06-09T14:06:28.388-04:00\",\"completed_at\":\"2022-06-09T14:06:28.388-04:00\",\"type_id\":9,\"source_id\":3,\"description\":\"Deal Created\",\"changed_fields\":{\"fields\":[{\"name\":\"tags\",\"value\":\"promotional leads\"},{\"name\":\"tags\",\"value\":\":  () $\"},{\"name\":\"user_id\",\"value\":30722},{\"name\":\"description\",\"value\":\"$0.00 for :  () $ \"},{\"name\":\"projected_sale_amount\",\"value\":\"0.0\"},{\"name\":\"probability_to_purchase\",\"value\":null},{\"name\":\"status_id\",\"value\":0},{\"name\":\"projected_closed_at\",\"value\":null},{\"name\":\"closed_at\",\"value\":null},{\"name\":\"lost_reason\",\"value\":null},{\"name\":\"pipeline_id\",\"value\":null},{\"name\":\"pipeline_stage_id\",\"value\":null},{\"name\":\"external_id\",\"value\":null},{\"name\":\"followed_up_on_at\",\"value\":null},{\"name\":\"last_activity_at\",\"value\":\"2022-06-09T14:06:28.382-04:00\"},{\"name\":\"auto_closed\",\"value\":null},{\"name\":\"perq_generated\",\"value\":false},{\"name\":\"workflow_id\",\"value\":null},{\"name\":\"interested_in_merchandise_list\",\"value\":[\":  () $\"]},{\"name\":\"tag_list\",\"value\":[\"promotional leads\"]}]},\"notes\":\"Tags: \'promotional leads\'.,Tags: \':  () $\'.,User: \'30722\'.,Description: \'$0.00 for :  () $ \'.,Projected Sale Amount: \'0.0\'.,Probability To Purchase: \'\'.,Status: \'0\'.,Projected Closed At: \'\'.,Closed At: \'\'.,Lost Reason: \'\'.,Pipeline: \'\'.,Pipeline Stage: \'\'.,External: \'\'.,Followed Up On At: \'\'.,Last Activity At: \'2022-06-09T14:06:28.382-04:00\'.,Auto Closed: \'\'.,Perq Generated: \'false\'.,Workflow: \'\'.,Interested In Merchandise List: \'[\\\":  () $\\\"]\'.,Tag List: \'[\\\"promotional leads\\\"]\'.\"},{\"ca_type\":\"log\",\"by_user\":\"API User\",\"created_at\":\"2022-06-09T14:06:27.688-04:00\",\"completed_at\":\"2022-06-09T14:06:27.688-04:00\",\"type_id\":0,\"source_id\":3,\"description\":\"contact @fbi_gov  Created\",\"changed_fields\":{\"fields\":[]},\"notes\":\"\"}],\"communication_preferences\":{\"consent_type\":{\"sms\":1,\"email\":1}},\"any_email_allowed\":true,\"any_sms_allowed\":true,\"drip_automation\":false,\"sales_automation\":null,\"automated_lead_follow_up\":false,\"contact @fbi_gov _alfu_workflows_count\":0}', NULL, '2023-01-20 04:16:00'),
(6007681, 15, 'contact @fbi_gov s/6482767', 'PATCH', '[]', '{\"first_name\":\"\",\"last_name\":\"Maritza Rodriguez\",\"email\":\"marrod1956@gmaul.com\",\"phone\":\"(347) 447-0418\",\"phone2\":\"\",\"address_1\":\"\",\"address_2\":\"\",\"city\":\"\",\"state\":\"\",\"postal_code\":null,\"country\":\"United States\",\"external_id\":1296365,\"level\":1,\"sold\":false,\"projected_sale_amount\":0,\"passive_no_count\":true,\"tag_list\":\"web lead\",\"location_id\":4186}', '{\"success\":\"false\",\"message\":\"Error updating contact @fbi_gov \",\"error_messages\":{\"first_name\":[\"can\'t be blank\"]}}', NULL, '2023-01-20 04:16:00'),
(6007682, 15, 'contact @fbi_gov s/search', NULL, '{\"q\":\"patrickbretta@yahoo.com\",\"show_archived\":\"true\"}', '[]', '{\"success\":true,\"contact @fbi_gov s\":[]}', NULL, '2023-01-20 04:16:00'),
(6007683, 15, 'contact @fbi_gov s/search', NULL, '{\"q\":\"(614) 981-2662\",\"show_archived\":\"true\"}', '[]', '{\"success\":true,\"contact @fbi_gov s\":[]}', NULL, '2023-01-20 04:16:00'),


(1447816, 36, 585291, 'Donald', 'Riedel', 0, NULL, NULL, NULL, NULL, '(181) 035-7557', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Continental - 12/5 - $19 Pays Slot Machine', 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, NULL, NULL, NULL, NULL, NULL, '2022-12-26 16:24:34', NULL, NULL, 'donaldriedel143@gmail.com', NULL, '2022-12-23 02:01:56', '2022-12-26 21:24:34', NULL, NULL, NULL, 379, NULL, 0, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(1447817, 9, 586993, 'Kylie', 'Topham', 0, NULL, NULL, NULL, NULL, '(402) 601-1785', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Dec Promo - Popup', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'kylietopham9@gmail.com', NULL, '2022-12-23 02:06:51', '2022-12-23 02:06:51', NULL, NULL, NULL, 46, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 7567830, 5239570, 0, 0, NULL),
(1447818, 17, 528612, 'Derek', 'Fitch', 7, NULL, NULL, NULL, NULL, '(515) 391-3888', '', '', '', '', NULL, '50428', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Check Inventory', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fitchderek82@gmail.com', NULL, '2022-12-23 02:07:12', '2023-01-16 16:53:38', NULL, NULL, 47078, 167, NULL, 0, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-12-23 10:42:30', '2022-12-23 10:42:30', NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(1447819, 9, 586994, 'Ricardo', 'Hernandez', 0, NULL, NULL, NULL, NULL, '(210) 427-4887', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Dec Promo - Popup', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'kadieandaaronsdaddy2007@gmail.com', NULL, '2022-12-23 02:13:37', '2022-12-23 02:13:38', NULL, NULL, NULL, 54, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 7567841, 5239580, 0, 0, NULL),
(1447820, 17, 586995, 'Cheryl', 'Ayala', 0, NULL, NULL, NULL, NULL, '(515) 473-8536', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'December \'22 - Arona\'s Nice List', 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, NULL, NULL, NULL, NULL, NULL, '2022-12-23 15:56:45', NULL, NULL, 'Godfirst.0913@gmail.com', NULL, '2022-12-23 02:15:00', '2022-12-23 20:56:45', NULL, NULL, NULL, 152, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(1447821, 9, 138941, 'Teresa', 'smith', 0, NULL, NULL, NULL, NULL, '(712) 789-2388', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Dec Promo - Popup', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 't_bazer52@hotmail.com', NULL, '2022-12-23 02:16:07', '2022-12-23 02:16:10', NULL, NULL, NULL, 59, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 5618193, 5239588, 0, 0, NULL),
(1447822, 17, 103970, 'Taraya', 'Dunn-Morrow', 0, NULL, NULL, NULL, NULL, '(319) 359-5477', '', '', '', '', NULL, '52403', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Check Inventory', 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, NULL, NULL, NULL, NULL, NULL, '2022-12-23 15:27:11', NULL, NULL, 'rayadunn4@gmail.com', NULL, '2022-12-23 02:19:43', '2022-12-23 20:27:11', NULL, NULL, 47070, 172, NULL, 0, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),

HTML:
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
█  Format - .sql
█  Size file - 4GB / Compressed - 400mb
█  All rows - 19kk
█  Website - r20digital.com
█  Date - xx.02.2023
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖

 
Last edited:

UPDATED LINKS TO DOWNLOAD THIS DATABASE.
SEE THE NEW URLS IN THE FIRST POST OF THIS TOPIC.
 
Today I have uploaded the R20digital.com Database for you to download, thanks for reading and enjoy!
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖

[IMG]https://a.d-cd.net/zYkjsbZhlb39iRg__1IysJ-PN6E-960.jpg[/IMG]

HTML:
`leads` (`id`, `account_id`, `first_name`, `last_name`, `lead_status_id`, `lead_direct_status_id`, `leads_category_id`, `lead_category_id`, `company_name`, `phone1`, `phone2`, `address`, `address2`, `city`, `state`, `zip`, `message`, `position`, `converted_lead`, `created_by_user_id`, `assigned_to_user_id`, `assigned_to_group_id`, `updated_by_user_id`, `integration_id`, `integration_relative_id`, `source`, `contact @fbi_gov _method`, `contact @fbi_gov _time`, `make_model`, `points`, `field_1`, `field_2`, `field_3`, `field_4`, `field_5`, `field_6`, `field_7`, `field_8`, `field_9`, `field_10`, `billing_address`, `billing_city`, `billing_state`, `billing_zip`, `reference_1_name`, `reference_1_phone`, `reference_1_relationship`, `reference_2_name`, `reference_2_phone`, `reference_2_relationship`, `employer_name`, `employer_phone`, `employer_payment_amount`, `employer_payment_frequency`, `ssn`, `dob`, `license`)

`versi_customer` (`id`, `r20_account_id`, `RegionID`, `DistrictID`, `STID`, `CustID`, `CUST_TYPE`, `CUSTOMER`, `FIRST_NAME`, `MIDDLE_NAME`, `LAST_NAME`, `ADDRESS`, `APARTMENT`, `CITY`, `STATE`, `ZIP`, `PHONE`, `PHONE_MARKET`, `EMAIL`, `EMAIL_MARKET`, `FLOAT_FUND`, `BONUS_BUCKS`, `BONUS_POINTS`, `FIRST_LEASED`, `LAST_LEASED`)

INSERT INTO `leads` (`id`, `account_id`, `contact @fbi_gov _id`, `first_name`, `last_name`, `lead_status_id`, `lead_direct_status_id`, `leads_category_id`, `lead_category_id`, `company_name`, `phone1`, `phone2`, `address`, `address2`, `city`, `state`, `zip`, `message`, `position`, `converted_lead`, `created_by_user_id`, `assigned_to_user_id`, `assigned_to_group_id`, `updated_by_user_id`, `integration_id`, `integration_relative_id`, `source`, `contact @fbi_gov _method`, `contact @fbi_gov _time`, `make_model`, `points`, `field_1`, `field_2`, `field_3`, `field_4`, `field_5`, `field_6`, `field_7`, `field_8`, `field_9`, `field_10`, `billing_address`, `billing_city`, `billing_state`, `billing_zip`, `reference_1_name`, `reference_1_phone`)


HTML:
(488859, 7, 'Billy', 'Wilson', 6, NULL, NULL, NULL, NULL, '', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 1130, NULL, NULL, NULL, NULL, 'christmas-in-july', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'billywilson02061991@gmail.com', NULL, '2019-07-16 21:24:14', '2019-07-30 17:42:54', NULL, NULL, NULL, 28, NULL, 0, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-07-18 16:18:56', NULL, NULL, '2019-07-30 13:42:54', NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488860, 17, 'Jeffrey', 'harrelson ', 6, NULL, NULL, NULL, NULL, '5154479500', '', '', '', '', '', NULL, 'Gaming', NULL, NULL, 0, 2305, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'logitechworm@gmail.com', NULL, '2019-07-17 01:20:45', '2019-07-17 21:38:46', NULL, NULL, NULL, 152, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, 181341, NULL, 'Gaming', NULL, NULL, NULL, '2019-07-17 17:38:46', NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488861, 17, 'Sherry', '', 6, NULL, NULL, NULL, NULL, '812-549-0829', '', '', '', '', '', NULL, 'Mattress Sets', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'lesley.boyle@aol.com', NULL, '2019-07-17 01:21:25', '2019-07-16 21:25:03', NULL, NULL, NULL, 206, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, 181342, NULL, 'Mattress Sets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488862, 17, 'Jeanie', 'LaVonne ', 6, NULL, NULL, NULL, NULL, '3093406427', '', '', '', '', '', NULL, 'Living Room Sets', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, '2019-07-16 20:13:40', NULL, NULL, 'jeaniekrieg@yahoo.com', NULL, '2019-07-17 01:22:17', '2019-07-17 00:13:40', NULL, NULL, NULL, 180, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, 181343, NULL, 'Living Room Sets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488863, 17, 'Jeanie', 'LaVonne ', 6, NULL, NULL, NULL, NULL, '3093406427', '', '', '', '', '', NULL, 'Living Room Sets', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, '2019-07-16 20:13:23', NULL, NULL, 'jeaniekrieg@yahoo.com', NULL, '2019-07-17 01:22:18', '2019-07-17 00:13:23', NULL, NULL, NULL, 180, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, 181344, NULL, 'Living Room Sets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(488864, 17, 'Jeanie', 'LaVonne ', 6, NULL, NULL, NULL, NULL, '3093406427', '', '', '', '', '', NULL, 'Living Room Sets', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'popup-unlock-price', 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, NULL, NULL, NULL, NULL, NULL, '2019-07-16 20:13:18', NULL, NULL, 'jeaniekrieg@yahoo.com', NULL, '2019-07-17 01:22:23', '2019-07-17 00:13:18', NULL, NULL, NULL, 180, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, 181345, NULL, 'Living Room Sets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),

(14660527, 7, '8/24/2022', 14, 140001175, '14-140001175', 'Shanita', 'Pickens', 'shanita.pickens@gmail.com', 0, '2', '140010687', '12/30/2021', '8/27/2022', '183', '7/1/2022', '', '61', 'Video Games', '1/26/2023', '56', '22', 'Bi-Weekly', '$0.00', '$98.88', '', '', '  (717)649-5412', '  (646)241-7750', '2724 N 6th St', '', 'HARRISBURG', 'PA', '17110', '11', '$12,773.26', NULL, '', '0', NULL, NULL, NULL),
(14660528, 7, '8/24/2022', 14, 140001175, '14-140001175', 'Shanita', 'Pickens', 'shanita.pickens@gmail.com', 0, '2', '140011315', '5/26/2022', '8/27/2022', '183', '11/25/2022', '2391.49', '11', 'Multiple Items', '9/21/2024', '121', '108', 'Bi-Weekly', '$0.00', '$87.39', '', '', '  (717)649-5412', '  (646)241-7750', '2724 N 6th St', '', 'HARRISBURG', 'PA', '17110', '54', '$12,773.26', NULL, '', '0', NULL, NULL, NULL),
(14660529, 7, '8/24/2022', 14, 140001175, '14-140001175', 'Shanita', 'Pickens', 'shanita.pickens@gmail.com', 0, '2', '140011316', '5/26/2022', '8/27/2022', '183', '11/25/2022', '791.61', '14', 'Furn/Bedroom', '2/24/2024', '91', '78', 'Bi-Weekly', '$0.00', '$41.38', '', '', '  (717)649-5412', '  (646)241-7750', '2724 N 6th St', '', 'HARRISBURG', 'PA', '17110', '39', '$12,773.26', NULL, '', '0', NULL, NULL, NULL),
(14660530, 7, '8/24/2022', 14, 140001396, '14-140001396', 'CHERISSE ', 'PICKENS', 'pickenscherisse@gmail.com', 0, '1', '140009969', '8/16/2021', '8/22/2022', '183', '2/15/2022', '', '56', 'Multiple Items', '6/5/2023', '94', '41', 'Weekly', '$70.00', '$0.00', '', '', '  (913)486-5994', '', '2552 GREEN ST ', 'B', 'HARRISBURG', 'PA', '17110', '41', '$7,704.41', NULL, '', '0', NULL, NULL, NULL),
(14660531, 7, '8/24/2022', 14, 140001190, '14-140001190', 'Dwayne ', 'McMillen ', 'DMcMillen@hershocks.com', 1, '201', '140010012', '8/27/2021', '8/26/2022', '365', '8/27/2022', '1593.6', '39', 'Multiple Items', '1/19/2024', '120', '73', 'Weekly', '$0.00', '$70.14', '140001190', '2.99', '  (717)648-7853', '  (804)307-1154', '2407 WHITE OAK RD ', '', 'HALIFAX', 'PA', '17032', '73', '$5,547.73', NULL, '', '0', NULL, NULL, NULL),

INSERT INTO `wow_collections` (`id`, `account_id`, `store_number`, `customer_number`, `first_name`, `last_name`, `email`, `agreement_number`, `days_over_due`, `over_due_amount`, `product`, `created_at`, `updated_at`) VALUES
(731884, 17, 55, '36297', 'KYOTTIA', 'JONES', 'DSRMJD@GMAIL.COM', '150015', 17, '229.98', 'TELLURIDE CHARCOAL', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),
(731885, 17, 55, '36297', 'KYOTTIA', 'JONES', 'DSRMJD@GMAIL.COM', '150015', 17, '229.98', 'TELLURIDE CHARCOAL RECLINER', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),
(731886, 17, 55, '36323', 'MARY', 'GRAHAM', 'MARYGRAHAM8532@GMAIL.COM', '150288', 17, '54.99', '55\" 4K LED ROKU TV', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),
(731887, 17, 55, '36323', 'MARY', 'GRAHAM', 'MARYGRAHAM8532@GMAIL.COM', '159941', 17, '54.99', 'INSIGNIA 4.9CF MINI FRIDGE', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),
(731888, 17, 55, '36484', 'LATOYIA', 'PEARSON', 'LATOYIAPEARSON@YAHOO.COM', '150970', 47, '299.96', 'LARKINHURST SOFA/LOVESEAT', '2023-01-18 13:20:42', '2023-01-18 13:20:42'),

INSERT INTO `voip_call_histories` (`id`, `account_id`, `store_id`, `lead_id`, `domain`, `territory`, `type`, `cdr_id`, `orig_sub`, `orig_from_uri`, `from_number`, `to_number`, `orig_from_name`, `orig_req_uri`, `by_sub`, `term_sub`, `term_to_uri`, `time_start`, `time_answer`, `time_release`, `duration`, `time_talking`, `hide`, `talk`, `expected_trace`, `created_at`, `updated_at`) VALUES
(143626, 34, 344, NULL, 'happys01.com', 'happysnation.com', '0', '1668196608128087487be4fc98b3f476165cd6a6fe', '102', 'sip:8138357711@happys01.com', '8138357711', '8132793896', 'Happy 102', 'sip:8132793896@happys01.com', NULL, NULL, 'sip:18132793896@happys01.com', '2022-11-11 14:56:48', '2022-11-11 14:57:22', '2022-11-11 14:57:52', '00:00:30', '00:00:30', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),
(143627, 34, 350, 1406625, 'happys07.com', 'happysnation.com', '0', '16681965815049d9e62526ad06e46ef9fa409535ca', '102', 'sip:9043613696@happys07.com', '9043613696', '9046761727', 'Happys 102', 'sip:9046761727@happys07.com', NULL, NULL, 'sip:19046761727@happys07.com', '2022-11-11 14:56:21', '2022-11-11 14:56:36', '2022-11-11 14:58:31', '00:01:15', '00:00:00', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),
(143628, 34, 353, NULL, 'happys11.com', 'happysnation.com', '0', '1668196578ee0156b45fd20adcc05db704a4d02ef6', '103', 'sip:3525184688@happys11.com', '3525184688', '8134659286', 'Happys 103', 'sip:8134659286@happys11.com', NULL, NULL, 'sip:18134659286@happys11.com', '2022-11-11 14:56:18', '2022-11-11 14:56:42', '2022-11-11 14:56:47', '00:00:05', '00:00:05', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),
(143629, 34, 350, NULL, 'happys07.com', 'happysnation.com', '0', '16681965655d3564ffb7779d9f9fb9ab513a2d2742', '104', 'sip:9043613696@happys07.com', '9043613696', '9998062', 'Happys Home Centers Inc', 'sip:9998062@happys07.com', NULL, NULL, 'sip:19049998062@happys07.com', '2022-11-11 14:56:05', '2022-11-11 14:56:37', '2022-11-11 14:56:50', '00:00:13', '00:00:13', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),
(143630, 34, 344, NULL, 'happys01.com', 'happysnation.com', '0', '166819654642b34704101fbc435600a902eae99681', '102', 'sip:8138357711@happys01.com', '8138357711', '8135349129', 'Happy 102', 'sip:8135349129@happys01.com', NULL, NULL, 'sip:18135349129@happys01.com', '2022-11-11 14:55:46', '2022-11-11 14:56:18', '2022-11-11 14:56:31', '00:00:13', '00:00:13', '0', '', 1, '2022-11-11 20:11:55', '2022-11-11 20:11:55'),

INSERT INTO `versi_customer` (`id`, `r20_account_id`, `RegionID`, `DistrictID`, `STID`, `CustID`, `CUST_TYPE`, `CUSTOMER`, `FIRST_NAME`, `MIDDLE_NAME`, `LAST_NAME`, `ADDRESS`, `APARTMENT`, `CITY`, `STATE`, `ZIP`, `PHONE`, `PHONE_MARKET`, `EMAIL`, `EMAIL_MARKET`, `FLOAT_FUND`, `BONUS_BUCKS`, `BONUS_POINTS`, `FIRST_LEASED`, `LAST_LEASED`, `NEXT_PAYOUT`, `LAST_PAYOUT`, `LAST_BUYOUT`, `LAST_UNSAT_BUYOUT`, `LAST_PIF`, `LAST_RTS`, `NEXT_DUE`, `BAL_DUE`, `LAST_DAYS_LATE`, `LATE_TIMES_TOTAL`, `LATE_DAYS_TOTAL`, `LATE_7_PLUS_TOTAL`, `LATE_TIMES_AVG`, `LATE_DAYS_AVG`, `LATE_7_PLUS_AVG`, `TOTAL_MONTHLY`, `DAILY`, `WEEKLY`, `BI_WEEKLY`, `SEMI_MONTHLY`, `MONTHLY`, `TOTAL_RENTAL_PAID`, `AVG_RENTAL_PAID`, `LAST_RTS_RENTAL_PAID`, `CLUB_FLAG`, `CLUB_JOIN_DATE`, `CLUB_TERM_DATE`, `CLUB_DUE_DATE`, `FREE_DAYS`, `FREE_MONEY`, `DEFERRED_TOTAL`, `DEFERRED_AVG`, `DEFERRED_ACTIVE`, `AGREEMENTS`, `PENDING`, `ACTIVE`, `RTS`, `EPO`, `UNSAT_BO`, `PIF`, `RET_BAL`, `HOLD`, `SKIP`, `LEGAL`, `CHARGED_OFF`, `RETAIL_SOLD_NUM`, `RETAIL_SOLD_AMT`, `RETAIL_REFUND_NUM`, `RETAIL_REFUND_AMT`) VALUES
(1830, 7, '1', '1', '1', '646', '3', '101079', 'MIKE', NULL, 'EWOLDSEN', '103 S FORD', NULL, 'HUTCHINSON', 'KS', '67501', '  (  )669-9784', 'NO', NULL, 'NO', '0', NULL, NULL, '7/11/2000 11:04:17 PM', '7/11/2000 11:04:17 PM', NULL, NULL, NULL, NULL, NULL, '7/14/2000', NULL, '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '30', '30', '30', 'N', NULL, NULL, NULL, '0', '0', '-41', '-41', '-41', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(1831, 7, '1', '1', '1', '511', '1', '100775', 'JERRY', NULL, 'EZELL', '311 E F', NULL, 'HUTCHINSON', 'KS', '67501', '  (620)899-2181', 'NO', NULL, 'NO', '0', '0', '620', '4/1/2000 11:04:11 PM', '11/18/2019 4:10:03 PM', '12/3/2020', '8/30/2019 10:38:22 AM', '8/30/2019 10:38:22 AM', NULL, NULL, '4/25/2017', '3/3/2020', '0', '0', '3252', '67', '67', '2.8', '63.8', '1.3', '215.21', NULL, NULL, '0', '0', '67.96', '22778.02', '446.63', '1078.87', 'N', NULL, '11/1/2018', NULL, '1335', '3066.05', '1030.91', '20.213921', '1031.52', '51', '0', '3', '4', '37', '0', '0', '4', '0', '0', '0', '3', '56', '12413.98', '2', '457.65'),
(1832, 7, '1', '1', '1', '7322', '2', '111442', 'PRESCIOUS', NULL, 'EZELL', '2102 E 73RD ST', NULL, 'TULSA', 'OK', '74105', NULL, 'NO', 'APT 10 TULSA,OK', 'NO', '0', NULL, NULL, '10/8/2012 11:12:06 PM', '10/8/2012 11:12:06 PM', NULL, '4/12/2013', '4/12/2013', NULL, NULL, NULL, NULL, '0', '15', '97', '5', '5', '6', '97', '5', '0', NULL, NULL, '0', '0', '0', '351.33', '351.33', '0', 'N', NULL, NULL, NULL, '4', '24.79', '0', '0', '0', '1', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '19', '4664.09', '0', '0'),
(1833, 7, '1', '1', '1', '510', '2', '100774', 'SHANTEL', NULL, 'EZELL', NULL, NULL, 'HUTCHINSON', 'KS', '67501', '  (620)899-1592', 'NO', NULL, 'NO', '0', '0', '0', '4/15/2010 11:10:22 PM', '9/19/2017 2:28:50 PM', NULL, '2/11/2011', '2/11/2011', NULL, NULL, '1/11/2018 11:43:01 AM', NULL, '514.5', '72', '318', '18', '18', '3.8', '53', '3', '0', NULL, NULL, '0', '0', '0', '3662.19', '610.37', '233.9', 'N', NULL, NULL, NULL, '27', '54.96', '483.62', '80.603333', '483.62', '6', '0', '0', '0', '4', '0', '0', '2', '0', '0', '0', '0', '11', '293.17', '0', '0'),

INSERT INTO `subscribers` (`id`, `email`, `first_name`, `last_name`, `fullname`, `phone`, `address`, `city`, `state`, `zip`, `type`, `data`, `ip`, `store_id`, `letter`, `created_at`, `updated_at`, `deleted_at`, `account_id`, `lead_id`, `remote_id`, `contact @fbi_gov _id`) VALUES
(1047823, 'kbagrowski@eichhorn-law.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:07:47', '2022-12-19 12:07:47', NULL, 16, NULL, NULL, 584557),
(1047824, 'kbagrowski@eichhorn-law.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:07:47', '2022-12-19 12:07:47', NULL, 16, NULL, NULL, 584557),
(1047825, 'kbagrowski@eichhorn-law.com', NULL, NULL, 'vhcnpuwxax', '+1 213 425 1453', NULL, NULL, NULL, NULL, 'coupon', NULL, '', 134, 0, '2022-12-19 12:07:54', '2022-12-19 12:07:54', NULL, 16, NULL, NULL, 584557),
(1047832, 'jason.ponder@fedex.com', NULL, NULL, 'jason.ponder', NULL, NULL, NULL, NULL, NULL, 'coupon', NULL, '', NULL, 0, '2022-12-19 12:15:52', '2022-12-19 12:15:52', NULL, 9, NULL, NULL, 582001),
(1047833, 'noegiahosleo1986@yahoo.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:16:43', '2022-12-19 12:16:43', NULL, 6, NULL, NULL, 534095),
(1047840, 'noegiahosleo1986@yahoo.com', NULL, NULL, 'grMvWmOLRjefU', NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:17:12', '2022-12-19 12:17:12', NULL, 6, NULL, NULL, 534095),
(1047841, 'loritiner@verizon.net', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:19:19', '2022-12-19 12:19:19', NULL, 16, NULL, NULL, 582662),
(1047842, 'loritiner@verizon.net', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'newsletter', NULL, '', NULL, 0, '2022-12-19 12:19:19', '2022-12-19 12:19:19', NULL, 16, NULL, NULL, 582662),


INSERT INTO `perq_api_log` (`id`, `account_id`, `url`, `method`, `get_data`, `post_data`, `response`, `error`, `created_at`) VALUES
(6007680, 15, 'contact @fbi_gov s/6482767', NULL, '[]', '[]', '{\"account_id\":2908,\"communication_consent_statuses\":\"[{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":0,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":1,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":2,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":3,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":0,\\\"communication_type_id\\\":4,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":0,\\\"communication_allowed\\\":false,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":1,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":2,\\\"communication_allowed\\\":false,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":3,\\\"communication_allowed\\\":true,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null},{\\\"medium_type_id\\\":1,\\\"communication_type_id\\\":4,\\\"communication_allowed\\\":false,\\\"last_consent_activity\\\":null,\\\"last_consent_activity_at\\\":null}]\",\"ct_token\":\"zanpptge\",\"probability_to_purchase\":20,\"id\":6482767,\"email\":\"marrod1956@gn\",\"email_2\":null,\"phone\":\"(347) 447-0418\",\"phone_2\":null,\"first_name\":\"Maritza\",\"last_name\":\"Rodriguez\",\"company_name\":null,\"level\":\"1\",\"created_at\":\"2022-06-09T14:06:27.640-04:00\",\"updated_at\":\"2022-10-16T21:30:17.380-04:00\",\"location_id\":4186,\"user_id\":30786,\"notes\":null,\"opt_out_at\":null,\"archived_at\":null,\"token\":\"-9bwYmadIp8YQp9ehBJ9eg\",\"next_follow_up\":null,\"follow_up_note\":null,\"interested_merchandise\":null,\"address_1\":\"\",\"address_2\":\"\",\"city\":\"\",\"state\":\"\",\"postal_code\":\"\",\"projected_sale_amount\":\"0.0\",\"passive_no_count\":true,\"sold\":false,\"last_sold_date\":null,\"external_id\":\"1296356\",\"external_import_from\":null,\"country\":\"United States\",\"batch_import_id\":null,\"merged_into_id\":null,\"perq_consumer_id\":null,\"consumer_config_data\":null,\"phone_search\":\"3474470418\",\"phone_2_search\":null,\"full_name_search\":\"maritza rodriguez\",\"auto_responder_state_id\":null,\"phone_type\":null,\"phone_carrier_name\":null,\"phone_2_type\":null,\"phone_2_carrier_name\":null,\"source_id\":3,\"last_contact @fbi_gov ed_at\":\"2022-06-20T12:43:29.390-04:00\",\"consumer_view_link_sent_at\":null,\"is_test\":false,\"sent_opt_out\":false,\"ai_assistant_enabled\":null,\"sms_opt_in_status\":4,\"email_opt_in_status\":4,\"tag_list\":\"web lead\",\"interested_in_merchandise_list\":\"\",\"nurturing_list\":[],\"last_inquiry_at\":\"2022-06-09T14:06:28.271-04:00\",\"last_sold_at\":null,\"last_contact @fbi_gov _date\":\"2022-09-07T14:06:28.271-04:00\",\"tags\":[{\"id\":3877,\"name\":\"web lead\",\"taggings_count\":65693}],\"interested_in_merchandise\":[],\"contact @fbi_gov _attachments\":[],\"user\":{\"firstName\":\"Amin\",\"lastName\":\"Akram\",\"employee_code\":\"\"},\"location\":{\"id\":4186,\"description\":\"Columbus West\"},\"contact @fbi_gov _activities\":[],\"perq\":false,\"within_tcpa_period\":false,\"time_remaining_in_words\":\"Do Not contact @fbi_gov \",\"perq_data\":[],\"contact @fbi_gov _deals\":[{\"id\":4444904,\"contact @fbi_gov _id\":6482767,\"user_id\":30786,\"name\":null,\"description\":\"$0.00 for :  () $ \",\"projected_sale_amount\":\"0.0\",\"probability_to_purchase\":20,\"status_id\":2,\"projected_closed_at\":null,\"closed_at\":\"2022-06-09T00:00:00.000-04:00\",\"lost_reason\":\"No Response / disco number\",\"created_at\":\"2022-06-09T14:06:28.271-04:00\",\"updated_at\":\"2022-06-09T15:49:32.543-04:00\",\"account_id\":2908,\"location_id\":4186,\"batch_import_id\":null,\"pipeline_id\":2913,\"pipeline_stage_id\":10440,\"external_id\":null,\"followed_up_on_at\":null,\"last_activity_at\":\"2022-06-09T15:49:32.543-04:00\",\"auto_closed\":null,\"perq_generated\":false,\"workflow_id\":null,\"interested_in_merchandise_list\":[\":  () $\"],\"tag_list\":[\"promotional leads\"],\"pipeline_stage\":{\"id\":10440,\"pipeline_id\":2913,\"description\":\"Lost\",\"info\":\"Lost\",\"order\":7,\"created_at\":\"2022-02-04T14:15:50.497-05:00\",\"updated_at\":\"2022-02-04T14:15:50.497-05:00\",\"color_code\":\"#694fd9\"},\"interested_in_merchandise\":[{\"id\":38347,\"name\":\":  () $\",\"taggings_count\":9039}],\"tags\":[{\"id\":43364,\"name\":\"promotional leads\",\"taggings_count\":48926}],\"user\":{\"firstName\":\"Amin\",\"lastName\":\"Akram\",\"employee_code\":\"\"}}],\"active_deals\":[],\"scheduled_contact @fbi_gov _appointments\":[],\"combined_activities\":[{\"ca_type\":\"activity\",\"id\":4941098,\"location_description\":\"Columbus West\",\"user_id\":30786,\"user_name\":\"Amin Akram\",\"contact @fbi_gov _deal_id\":null,\"contact @fbi_gov _activity_type_id\":2,\"description\":null,\"due_at\":null,\"completed_at\":\"2022-06-20T12:43:29.327-04:00\",\"notes\":\"\",\"created_at\":\"2022-06-20T12:43:29.335-04:00\",\"updated_at\":\"2022-06-20T12:43:29.335-04:00\",\"contact @fbi_gov _id\":6482767,\"tag_list\":[\"phone\"],\"user\":{\"firstName\":\"Amin\",\"lastName\":\"Akram\",\"employee_code\":\"\"}},{\"ca_type\":\"log\",\"by_user\":\"Amin Akram\",\"created_at\":\"2022-06-09T15:49:35.979-04:00\",\"completed_at\":\"2022-06-09T15:49:35.979-04:00\",\"type_id\":6,\"source_id\":3,\"description\":\"Activity Updated\",\"changed_fields\":{\"fields\":[{\"name\":\"completed_at\",\"before\":null,\"after\":\"2022-06-09T15:49:35.963-04:00\"}]},\"notes\":\"Completed At was changed from \'\' to \'2022-06-09T15:49:35.963-04:00\'.\"},{\"ca_type\":\"activity\",\"id\":4905558,\"location_description\":\"Columbus West\",\"user_id\":30786,\"user_name\":\"Amin Akram\",\"contact @fbi_gov _deal_id\":null,\"contact @fbi_gov _activity_type_id\":2,\"description\":null,\"due_at\":\"2022-06-09T00:00:00.000-04:00\",\"completed_at\":\"2022-06-09T15:49:35.963-04:00\",\"notes\":\"Showplace Rent-To-Own Web Lead: :  () $ \",\"created_at\":\"2022-06-09T14:06:28.516-04:00\",\"updated_at\":\"2022-06-09T15:49:35.963-04:00\",\"contact @fbi_gov _id\":6482767,\"tag_list\":[],\"user\":{\"firstName\":\"Amin\",\"lastName\":\"Akram\",\"employee_code\":\"\"}},{\"ca_type\":\"log\",\"by_user\":\"Amin Akram\",\"created_at\":\"2022-06-09T15:49:32.747-04:00\",\"completed_at\":\"2022-06-09T15:49:32.747-04:00\",\"type_id\":10,\"source_id\":3,\"description\":\"Deal Updated\",\"changed_fields\":{\"fields\":[{\"name\":\"probability_to_purchase\",\"before\":null,\"after\":20},{\"name\":\"status_id\",\"before\":0,\"after\":2},{\"name\":\"closed_at\",\"before\":null,\"after\":\"2022-06-09T00:00:00.000-04:00\"},{\"name\":\"lost_reason\",\"before\":null,\"after\":\"No Response / disco number\"},{\"name\":\"pipeline_stage_id\",\"before\":10257,\"after\":10440},{\"name\":\"last_activity_at\",\"before\":\"2022-06-09T14:06:28.455-04:00\",\"after\":\"2022-06-09T15:49:32.543-04:00\"},{\"name\":\"interested_in_merchandise_list\",\"before\":[\":  () $\"],\"after\":null},{\"name\":\"tag_list\",\"before\":[\"promotional leads\"],\"after\":null}]},\"notes\":\"Probability To Purchase was changed from \'\' to \'20\'. Status was changed from \'0\' to \'2\'. Closed At was changed from \'\' to \'2022-06-09T00:00:00.000-04:00\'. Lost Reason was changed from \'\' to \'No Response / disco number\'. Pipeline Stage was changed from \'10257\' to \'10440\'. Last Activity At was changed from \'2022-06-09T14:06:28.455-04:00\' to \'2022-06-09T15:49:32.543-04:00\'. Interested In Merchandise List was changed from \'[\\\":  () $\\\"]\' to \'\'. Tag List was changed from \'[\\\"promotional leads\\\"]\' to \'\'.\"},{\"ca_type\":\"reassignment\",\"by_user\":\"System Account\",\"from_user\":null,\"to_user\":\"Amin Akram\",\"reason\":null,\"notes\":\"Auto-Assign\",\"completed_at\":\"2022-06-09T15:31:49.814-04:00\"},{\"ca_type\":\"log\",\"by_user\":\"API User\",\"created_at\":\"2022-06-09T14:06:28.388-04:00\",\"completed_at\":\"2022-06-09T14:06:28.388-04:00\",\"type_id\":9,\"source_id\":3,\"description\":\"Deal Created\",\"changed_fields\":{\"fields\":[{\"name\":\"tags\",\"value\":\"promotional leads\"},{\"name\":\"tags\",\"value\":\":  () $\"},{\"name\":\"user_id\",\"value\":30722},{\"name\":\"description\",\"value\":\"$0.00 for :  () $ \"},{\"name\":\"projected_sale_amount\",\"value\":\"0.0\"},{\"name\":\"probability_to_purchase\",\"value\":null},{\"name\":\"status_id\",\"value\":0},{\"name\":\"projected_closed_at\",\"value\":null},{\"name\":\"closed_at\",\"value\":null},{\"name\":\"lost_reason\",\"value\":null},{\"name\":\"pipeline_id\",\"value\":null},{\"name\":\"pipeline_stage_id\",\"value\":null},{\"name\":\"external_id\",\"value\":null},{\"name\":\"followed_up_on_at\",\"value\":null},{\"name\":\"last_activity_at\",\"value\":\"2022-06-09T14:06:28.382-04:00\"},{\"name\":\"auto_closed\",\"value\":null},{\"name\":\"perq_generated\",\"value\":false},{\"name\":\"workflow_id\",\"value\":null},{\"name\":\"interested_in_merchandise_list\",\"value\":[\":  () $\"]},{\"name\":\"tag_list\",\"value\":[\"promotional leads\"]}]},\"notes\":\"Tags: \'promotional leads\'.,Tags: \':  () $\'.,User: \'30722\'.,Description: \'$0.00 for :  () $ \'.,Projected Sale Amount: \'0.0\'.,Probability To Purchase: \'\'.,Status: \'0\'.,Projected Closed At: \'\'.,Closed At: \'\'.,Lost Reason: \'\'.,Pipeline: \'\'.,Pipeline Stage: \'\'.,External: \'\'.,Followed Up On At: \'\'.,Last Activity At: \'2022-06-09T14:06:28.382-04:00\'.,Auto Closed: \'\'.,Perq Generated: \'false\'.,Workflow: \'\'.,Interested In Merchandise List: \'[\\\":  () $\\\"]\'.,Tag List: \'[\\\"promotional leads\\\"]\'.\"},{\"ca_type\":\"log\",\"by_user\":\"API User\",\"created_at\":\"2022-06-09T14:06:27.688-04:00\",\"completed_at\":\"2022-06-09T14:06:27.688-04:00\",\"type_id\":0,\"source_id\":3,\"description\":\"contact @fbi_gov  Created\",\"changed_fields\":{\"fields\":[]},\"notes\":\"\"}],\"communication_preferences\":{\"consent_type\":{\"sms\":1,\"email\":1}},\"any_email_allowed\":true,\"any_sms_allowed\":true,\"drip_automation\":false,\"sales_automation\":null,\"automated_lead_follow_up\":false,\"contact @fbi_gov _alfu_workflows_count\":0}', NULL, '2023-01-20 04:16:00'),
(6007681, 15, 'contact @fbi_gov s/6482767', 'PATCH', '[]', '{\"first_name\":\"\",\"last_name\":\"Maritza Rodriguez\",\"email\":\"marrod1956@gmaul.com\",\"phone\":\"(347) 447-0418\",\"phone2\":\"\",\"address_1\":\"\",\"address_2\":\"\",\"city\":\"\",\"state\":\"\",\"postal_code\":null,\"country\":\"United States\",\"external_id\":1296365,\"level\":1,\"sold\":false,\"projected_sale_amount\":0,\"passive_no_count\":true,\"tag_list\":\"web lead\",\"location_id\":4186}', '{\"success\":\"false\",\"message\":\"Error updating contact @fbi_gov \",\"error_messages\":{\"first_name\":[\"can\'t be blank\"]}}', NULL, '2023-01-20 04:16:00'),
(6007682, 15, 'contact @fbi_gov s/search', NULL, '{\"q\":\"patrickbretta@yahoo.com\",\"show_archived\":\"true\"}', '[]', '{\"success\":true,\"contact @fbi_gov s\":[]}', NULL, '2023-01-20 04:16:00'),
(6007683, 15, 'contact @fbi_gov s/search', NULL, '{\"q\":\"(614) 981-2662\",\"show_archived\":\"true\"}', '[]', '{\"success\":true,\"contact @fbi_gov s\":[]}', NULL, '2023-01-20 04:16:00'),


(1447816, 36, 585291, 'Donald', 'Riedel', 0, NULL, NULL, NULL, NULL, '(181) 035-7557', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Continental - 12/5 - $19 Pays Slot Machine', 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, NULL, NULL, NULL, NULL, NULL, '2022-12-26 16:24:34', NULL, NULL, 'donaldriedel143@gmail.com', NULL, '2022-12-23 02:01:56', '2022-12-26 21:24:34', NULL, NULL, NULL, 379, NULL, 0, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(1447817, 9, 586993, 'Kylie', 'Topham', 0, NULL, NULL, NULL, NULL, '(402) 601-1785', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Dec Promo - Popup', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'kylietopham9@gmail.com', NULL, '2022-12-23 02:06:51', '2022-12-23 02:06:51', NULL, NULL, NULL, 46, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 7567830, 5239570, 0, 0, NULL),
(1447818, 17, 528612, 'Derek', 'Fitch', 7, NULL, NULL, NULL, NULL, '(515) 391-3888', '', '', '', '', NULL, '50428', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Check Inventory', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fitchderek82@gmail.com', NULL, '2022-12-23 02:07:12', '2023-01-16 16:53:38', NULL, NULL, 47078, 167, NULL, 0, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-12-23 10:42:30', '2022-12-23 10:42:30', NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(1447819, 9, 586994, 'Ricardo', 'Hernandez', 0, NULL, NULL, NULL, NULL, '(210) 427-4887', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Dec Promo - Popup', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'kadieandaaronsdaddy2007@gmail.com', NULL, '2022-12-23 02:13:37', '2022-12-23 02:13:38', NULL, NULL, NULL, 54, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 7567841, 5239580, 0, 0, NULL),
(1447820, 17, 586995, 'Cheryl', 'Ayala', 0, NULL, NULL, NULL, NULL, '(515) 473-8536', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'December \'22 - Arona\'s Nice List', 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, NULL, NULL, NULL, NULL, NULL, '2022-12-23 15:56:45', NULL, NULL, 'Godfirst.0913@gmail.com', NULL, '2022-12-23 02:15:00', '2022-12-23 20:56:45', NULL, NULL, NULL, 152, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),
(1447821, 9, 138941, 'Teresa', 'smith', 0, NULL, NULL, NULL, NULL, '(712) 789-2388', '', '', '', '', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Dec Promo - Popup', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 't_bazer52@hotmail.com', NULL, '2022-12-23 02:16:07', '2022-12-23 02:16:10', NULL, NULL, NULL, 59, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 5618193, 5239588, 0, 0, NULL),
(1447822, 17, 103970, 'Taraya', 'Dunn-Morrow', 0, NULL, NULL, NULL, NULL, '(319) 359-5477', '', '', '', '', NULL, '52403', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'Check Inventory', 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, NULL, NULL, NULL, NULL, NULL, '2022-12-23 15:27:11', NULL, NULL, 'rayadunn4@gmail.com', NULL, '2022-12-23 02:19:43', '2022-12-23 20:27:11', NULL, NULL, 47070, 172, NULL, 0, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, NULL, NULL, 0, 0, NULL),

HTML:
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
█  Format - .sql
█  Size file - 4GB / Compressed - 400mb
█  All rows - 19kk
█  Website - r20digital.com
█  Date - xx.02.2023
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖

*** Hidden text: cannot be quoted. ***
thank you.
 

Users who are viewing this thread

Home Register
Top Bottom