Repost, was originally posted by someone on RaidForums

Download:
https://cdn.breached.to/share/limetray.sql.gz

Requested here:
https://breached.to/Thread-Found-Database-limetray-com-India-4-067-234-food-order-info

Original RaidForums Thread:

https://raidforums.com/Thread-SQL-4M-limetray-com-user-data-email-name-phone


Offloading some dumps. This first hand data.


Sample:


CREATE TABLE limetray.users (
    brand_user_id text PRIMARY KEY,
    brand_id text,
    created_at bigint,
    email text,
    first_failed_order_time bigint,
    first_non_void_order_time bigint,
    first_order_time bigint,
    first_void_order_time bigint,
    full_name text,
    last_interaction_time bigint,
    loss double,
    mobile text,
    revenue double,
    source_id int,
    source_name text,
    total_discount double,
    total_failed_orders int,
    total_loyalty_amount double,
    total_non_void_orders int,
    total_orders int,
    total_preorders int,
    total_void_orders int
)


INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('19293803', '5287', 1515927857, '[email protected]', 1515927645000, 1515927645000, 0, 'Ronan Pooh', 1515927645000, 0.0, '8383045737', 401.52, 0, 'Admin', 95.6, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('20014474', '5235', 1518453734, '[email protected]', 1518449299000, 1518449299000, 0, 'Prathmesh Thakur', 1518449299000, 0.0, '9920805720', 542.48, 0, 'Admin', 82.35, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('10383645', '3786', 1505812065, 1477222194000, 'sakshi  ', 1477222194000, 0.0, '9920099249', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('13108577', '3789', 1505829216, 1489710045000, 'kanwar  ', 1489710045000, 0.0, '8146101994', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('15993150', '1138', 1505831605, '[email protected]', 1504788799000, 1504788799000, 0, 'Arjun Tandon', 1505051717000, 0.0, '9920567744', 5614.529999999999, 0, 'Admin', 536.0, 0, 0.0, 9, 9, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('19145832', '4843', 1515338633, '[email protected]', 1515338577000, 1515338577000, 'Sid J', 1515338577000, 443.7, '9769184466', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 1);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('17773879', '3258', 1510470867, '[email protected]', 1510470424000, 'Pradeep Banavara', 1510470424000, 0.0, '8095978063', 611.24, 0, 'Admin', 81.0, 0, 0.0, 1, 1, 0, 0);



link
https://mega.nz/file/HltwkIZJ#fofw17w3Xi...xFwfs_Z6AI

Pom this was so f*ing quick. Thank you so much.

Recall this one being huge pain in the ass to parse properly as most lines of same table had different headers so wrote script just for this damn db to clean it up. anyway here's cleaned up version with useless cols removed and deduped by name, email and phone. End result is 3.2m beautiful records. you're welcome,

https://anonfiles.com/hbj6X9Gbyc/limetray_cleaned_and_merged_7z

Damn for a sec I was think that "someone" as back to the business
sadly he is not back in the business.

Good Share trought.

Good share and great effort, broken link though.. possible to reshare?

good thank you

(November 15, 2022, 02:11 PM)jeffyh Wrote: Good share and great effort, broken link though.. possible to reshare?

not sure which link you mean, but just tested and neither is broken at moment