-- your code goes hereselect * from new_lms_customerwallettransaction cwt
join new_lms_customerwallet cw on cw.id = cwt.customer_wallet_id
join crm_app_customer c on c.id = cw.customer_id
where cwt.created_at ::date >= '2025-10-28' and c.id in (649830, 270907, 516056, 406568, 127146, 280781, 148747, 144544, 88286);
 
 
 
select * from ledger_amount where id in (183955829, 183968303, 183956677, 183955077, 183956049, 183967747, 183976131, 183947869, 183956605);
 
select * from ledger_entry  where id in (25773430, 25777103, 25773726, 25773157, 25773519, 25776889, 25779231, 25771430, 25773702)
 
 
 
UPDATE new_lms_customerwallet cw
SET total_amount = COALESCE((
    SELECT SUM(t.amount)
    FROM new_lms_customerwallettransaction t
    WHERE t.customer_wallet_id = cw.id
), 0)
WHERE cw.id IN (14549, 11813, 14377, 14550, 13825, 6432, 14551, 14552, 14553);

LS0geW91ciBjb2RlIGdvZXMgaGVyZXNlbGVjdCAqIGZyb20gbmV3X2xtc19jdXN0b21lcndhbGxldHRyYW5zYWN0aW9uIGN3dApqb2luIG5ld19sbXNfY3VzdG9tZXJ3YWxsZXQgY3cgb24gY3cuaWQgPSBjd3QuY3VzdG9tZXJfd2FsbGV0X2lkCmpvaW4gY3JtX2FwcF9jdXN0b21lciBjIG9uIGMuaWQgPSBjdy5jdXN0b21lcl9pZAp3aGVyZSBjd3QuY3JlYXRlZF9hdCA6OmRhdGUgPj0gJzIwMjUtMTAtMjgnIGFuZCBjLmlkIGluICg2NDk4MzAsIDI3MDkwNywgNTE2MDU2LCA0MDY1NjgsIDEyNzE0NiwgMjgwNzgxLCAxNDg3NDcsIDE0NDU0NCwgODgyODYpOwoKCgpzZWxlY3QgKiBmcm9tIGxlZGdlcl9hbW91bnQgd2hlcmUgaWQgaW4gKDE4Mzk1NTgyOSwgMTgzOTY4MzAzLCAxODM5NTY2NzcsIDE4Mzk1NTA3NywgMTgzOTU2MDQ5LCAxODM5Njc3NDcsIDE4Mzk3NjEzMSwgMTgzOTQ3ODY5LCAxODM5NTY2MDUpOwoKc2VsZWN0ICogZnJvbSBsZWRnZXJfZW50cnkgIHdoZXJlIGlkIGluICgyNTc3MzQzMCwgMjU3NzcxMDMsIDI1NzczNzI2LCAyNTc3MzE1NywgMjU3NzM1MTksIDI1Nzc2ODg5LCAyNTc3OTIzMSwgMjU3NzE0MzAsIDI1NzczNzAyKQoKCgpVUERBVEUgbmV3X2xtc19jdXN0b21lcndhbGxldCBjdwpTRVQgdG90YWxfYW1vdW50ID0gQ09BTEVTQ0UoKAogICAgU0VMRUNUIFNVTSh0LmFtb3VudCkKICAgIEZST00gbmV3X2xtc19jdXN0b21lcndhbGxldHRyYW5zYWN0aW9uIHQKICAgIFdIRVJFIHQuY3VzdG9tZXJfd2FsbGV0X2lkID0gY3cuaWQKKSwgMCkKV0hFUkUgY3cuaWQgSU4gKDE0NTQ5LCAxMTgxMywgMTQzNzcsIDE0NTUwLCAxMzgyNSwgNjQzMiwgMTQ1NTEsIDE0NTUyLCAxNDU1Myk7