[NamelessKing1337]

Hidden Content

You must register or login to view this content.

sample;


INSERT INTO `orders` (`id`, `order_id`, `name`, `email`, `phone`, `date_created`, `user_date_creation`, `payment_date`, `order_name`, `status`, `price`, `payed`, `manager`, `utm_source`, `utm_medium`, `utm_campaign`, `utm_content`, `utm_term`, `utm_banner`, `utm_phrase`, `report_ptoducttype`, `report_productname`, `report_productcategory`, `report_ordertype`, `linkorder`, `date_on`, `date_off`, `dana_dates`, `dana_participants`, `type`, `report_webinar1`, `report_webinar2`, `report_webinar3`, `report_webinar4`, `report_webinar5`, `report_webinar6`, `salebot_messenger`, `positions_price`, `id_polzovatelya`, `promocode`, `promoaction`, `id_zakaza`, `created_at_webhook`, `created_at`, `date_updated`, `paid_at_webhook`, `user_utm_source`, `user_utm_medium`, `user_utm_campaign`, `user_utm_content`, `user_utm_term`, `user_utm_group`, `user_gcpc`, `order_tags`, `offer_tags`, `paid_order`, `freeapplication`, `rejection_reason`, `location`) VALUES


(1, '1423311', 'Александр Алексеевич Квитченко', 'staak@yandex.ru', '+79067774284', '2025-10-01 00:08:43', '2023-07-03 00:00:00', NULL, 'Онлайн | Мастер - класс Игоря Будникова “Я не вывожу” | Регистрация', 'Завершен', 0.00, 0.00, '', '', '', '', '', '', '', '', '', 'Мастер - класс Игоря Будникова “Я не вывожу”', '', '', 'https://minddetox.getcourse.ru/sales/control/deal/update/id/731900751', '', '', '', '', '', '', 'Пришел', '', '', '', NULL, '', NULL, 322766853, '', '', 731900751, NULL, '2025-10-12 21:01:54', NULL, NULL, 'welcomebackhome.academy', 'referral', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL),

[thelastwhitehat]

For anyone who wants to unlock this database, it doesn’t contain 5.7 million records (it has 74,837) and the .SQL file appears to be parsed or broken. See below:

Breach Analysis Spoiler

SQL file values seem to be completely missing compared to the INSERT query. After I fixed that with placeholder or NULL values, this is what I got. MD5 hash of getcourse.ru.sql: E96D2261C5F645024F022A474E0FFBCA File: getcourse.ru - orders.csv (43.78 MB) Hash: 80555B0B00F9B3238E66C48B9B51B86E Records: 74837 Unique Emails: 29273 (based on HIBP guidelines) Breach Date: 2025-11-26 (estimated) Records Range: 2014-05-30 <---> 2025-11-26 Detected date range for the column 'user_date_creation': +-----+---------------------+---------------------+ | # | oldest (dates) | newest (dates) | |-----+---------------------+---------------------| | 1 | 2014-05-30 00:00:00 | 2025-11-26 00:00:00 | | 2 | 2014-06-03 00:00:00 | 2025-11-25 00:00:00 | | 3 | 2014-07-23 00:00:00 | 2025-11-24 00:00:00 | | 4 | 2014-07-29 00:00:00 | 2025-11-23 00:00:00 | | 5 | 2014-07-30 00:00:00 | 2025-11-22 00:00:00 | +-----+---------------------+---------------------+ Detected values for the column 'email': +---------+----------+---------+-----------+-----------+ | total | unique | dupes | invalid | valid % | |---------+----------+---------+-----------+-----------| | 74837 | 29532 | 45305 | 0 | 100% | +---------+----------+---------+-----------+-----------+ Detected values for the column 'phone': +---------+----------+---------+-----------+-----------+ | total | unique | dupes | invalid | valid % | |---------+----------+---------+-----------+-----------| | 74837 | 27900 | 45884 | 1053 | 99% | +---------+----------+---------+-----------+-----------+ Top 10 email domains detected: +-----+------------+---------+-----+ | # | domain | count | % | |-----+------------+---------+-----| | 1 | mail.ru | 9993 | 34% | | 2 | gmail.com | 9462 | 32% | | 3 | yandex.ru | 5183 | 18% | | 4 | bk.ru | 885 | 3% | | 5 | list.ru | 615 | 2% | | 6 | inbox.ru | 508 | 2% | | 7 | ya.ru | 395 | 1% | | 8 | rambler.ru | 389 | 1% | | 9 | icloud.com | 322 | 1% | | 10 | yahoo.com | 143 | 0% | +-----+------------+---------+-----+

[NamelessKing1337]

For anyone who wants to unlock this database, it doesn’t contain 5.7 million records (it has 74,837) and the .SQL file appears to be parsed or broken. See below:

Breach Analysis Spoiler

SQL file values seem to be completely missing compared to the INSERT query. After I fixed that with placeholder or NULL values, this is what I got. MD5 hash of getcourse.ru.sql: E96D2261C5F645024F022A474E0FFBCA File: getcourse.ru - orders.csv (43.78 MB) Hash: 80555B0B00F9B3238E66C48B9B51B86E Records: 74837 Unique Emails: 29273 (based on HIBP guidelines) Breach Date: 2025-11-26 (estimated) Records Range: 2014-05-30 <---> 2025-11-26 Detected date range for the column 'user_date_creation': +-----+---------------------+---------------------+ |  #  |  oldest (dates)    |  newest (dates)    | |-----+---------------------+---------------------| |  1  | 2014-05-30 00:00:00 | 2025-11-26 00:00:00 | |  2  | 2014-06-03 00:00:00 | 2025-11-25 00:00:00 | |  3  | 2014-07-23 00:00:00 | 2025-11-24 00:00:00 | |  4  | 2014-07-29 00:00:00 | 2025-11-23 00:00:00 | |  5  | 2014-07-30 00:00:00 | 2025-11-22 00:00:00 | +-----+---------------------+---------------------+ Detected values for the column 'email': +---------+----------+---------+-----------+-----------+ |  total  |  unique  |  dupes  |  invalid  |  valid %  | |---------+----------+---------+-----------+-----------| |  74837  |  29532  |  45305  |    0    |  100%    | +---------+----------+---------+-----------+-----------+ Detected values for the column 'phone': +---------+----------+---------+-----------+-----------+ |  total  |  unique  |  dupes  |  invalid  |  valid %  | |---------+----------+---------+-----------+-----------| |  74837  |  27900  |  45884  |  1053    |    99%    | +---------+----------+---------+-----------+-----------+ Top 10 email domains detected: +-----+------------+---------+-----+ |  #  |  domain  |  count  |  %  | |-----+------------+---------+-----| |  1  |  mail.ru  |  9993  | 34% | |  2  | gmail.com  |  9462  | 32% | |  3  | yandex.ru  |  5183  | 18% | |  4  |  bk.ru    |  885  | 3%  | |  5  |  list.ru  |  615  | 2%  | |  6  |  inbox.ru  |  508  | 2%  | |  7  |  ya.ru    |  395  | 1%  | |  8  | rambler.ru |  389  | 1%  | |  9  | icloud.com |  322  | 1%  | | 10  | yahoo.com  |  143  | 0%  | +-----+------------+---------+-----+

yes my bad, moderators can change title, i cant change

[Ruddy124]

public since last year DEC but THX anyways