Just paste
Create new paste
Pastes Archive
2022-08-19 16:02:53
copy
raw
download
CREATE OR REPLACE VIEW op_customers (realid,virtualid) AS SELECT users.login as login, CRC32(users.login) as payid FROM users LEFT JOIN payment_id ON (users.login = payment_id.login) WHERE payment_id.login IS NULL GROUP BY login UNION SELECT DISTINCT login as login, payment_id as payid from payment_id
↑
2022-08-19 16:02:53
Create new paste
Pastes Archive