| CARVIEW |
Select Language
HTTP/2 200
date: Sat, 11 Oct 2025 07:35:19 GMT
content-type: text/html; charset=UTF-8
server: cloudflare
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 1;mode=block
vary: accept-encoding
cf-cache-status: DYNAMIC
content-encoding: gzip
set-cookie: _csrf-frontend=93c53459ae6b5c184c0cd5066d23cc7a9b55731df70ecf470c848d9429a59921a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22nV3bX2NkeQ2HQQb09JIukCZPepzJufuC%22%3B%7D; HttpOnly; Path=/
cf-ray: 98ccae157e09f424-BLR
WITH x AS ( -- begin WITH SELECT au.* --into actor.usrs_to_delete_2024 - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH x AS ( -- begin WITH
- SELECT au.*
- --into actor.usrs_to_delete_2024_09_20
- FROM actor.usr au
- JOIN permission.grp_tree grp ON (au.profile = grp.id)
- WHERE
- ( -- begin OR
- ( -- begin regular patrons
- grp.name in (
- 'Digital Only',
- 'GLS',
- 'Homebound',
- 'NonResident',
- 'OutOfState',
- 'Patron',
- 'Quipu',
- 'Restricted',
- 'Temp',
- 'TempRes12',
- 'TempRes6',
- 'Trustee'
- )
- AND date(au.expire_date) < date(now()) - '4 years'::interval
- -- no owed money in either direction and no payment within the last 4 years
- AND NOT EXISTS (
- SELECT 1
- FROM money.materialized_billable_xact_summary mmbxs
- WHERE mmbxs.usr = au.id
- AND (
- balance_owed <> '0.00' OR (now() - last_payment_ts) < '4 years'::interval)
- )
- -- no activity entries within the last 4 years
- AND NOT EXISTS (
- SELECT 1
- FROM actor.usr_activity aua
- WHERE aua.usr = au.id
- AND (now() - event_time) < '4 years'::interval
- )
- -- no accounts created within the last 4 years
- AND date(au.create_date) < date(now()) - '4 years'::interval
- ) -- end regular patrons
- OR
- ( -- begin PLAY cards
- -- PLAY Cards are deleted one year after expire date\
- -- They can't owe any money.
- grp.name = 'PLAY Card'
- AND NOT EXISTS (
- SELECT 1
- FROM money.materialized_billable_xact_summary mmbxs
- WHERE mmbxs.usr = au.id
- AND balance_owed <> '0.00'
- )
- AND date(au.expire_date) < date(now()) - '1 year'::interval
- ) -- end PLAY cards
- ) -- end OR
- AND au.deleted = false
- -- consider open circs
- AND NOT EXISTS (
- SELECT 1
- FROM action.circulation circ
- WHERE circ.usr = au.id
- AND xact_finish is null
- )
- -- not in collections - PATRON_IN_COLLECTIONS standing penalty
- AND NOT EXISTS (
- SELECT 1
- FROM actor.usr_standing_penalty usp
- WHERE usp.usr = au.id
- AND usp.standing_penalty = 30
- )
- ) -- end WITH
- SELECT actor.usr_delete(u.id, NULL) FROM actor.usr u WHERE u.id in (SELECT id FROM x)
- ;
Advertisement
Add Comment
Please, Sign In to add comment
-
⭐⭐⭐Exploit 500$ in 15 Minutes⭐⭐
Java | 8 sec ago | 0.10 KB
-
⭐✅ Online Marketplace Exploit ✅ NEVER SEEN BE...
JavaScript | 10 sec ago | 0.24 KB
-
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ T
JavaScript | 12 sec ago | 0.24 KB
-
⭐✅ Trading Profit Method ✅ NEVER SEEN BEFORE...
JavaScript | 19 sec ago | 0.24 KB
-
⭐⭐⭐GMAIL Logs (2FA disabled)⭐⭐
Java | 22 sec ago | 0.10 KB
-
⭐✅ Swapzone Glitch ✅ Working⭐⭐⭐ V
JavaScript | 23 sec ago | 0.24 KB
-
⭐ Instant BTC Profit Method ✅ NEVER SEEN BEFO...
JavaScript | 28 sec ago | 0.24 KB
-
✅ Make $2500 in 20 minutes⭐⭐⭐ 8
JavaScript | 34 sec ago | 0.24 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
