CREATE DATABASE IF NOT EXISTS my_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'new_password';
GRANT ALL ON my_db.* TO 'new_user'@'localhost';
FLUSH PRIVILEGES;

SELECT * FROM `auth_user` 
  WHERE not EXISTS (SELECT * FROM userprofile_userprofile WHERE userprofile_userprofile.user_id=auth_user.id );

SELECT * FROM `auth_user` 
WHERE id NOT IN (SELECT user_id FROM userprofile_userprofile)
ORDER BY `id`  ASC    

DELETE FROM `auth_user` 
  WHERE not EXISTS (SELECT * FROM userprofile_userprofile WHERE userprofile_userprofile.user_id=auth_user.id );

SELECT * FROM `userboard_usersactions` 
where `dopinfo` REGEXP BINARY '^[А-Яа-яЁё]{8}\ \ \ Email'
ORDER BY `id`  DESC

SELECT text,CONCAT('https://vk.com/id', vkuser) AS vklink FROM `msg_message` 
LEFT JOIN msg_user ON msg_message.author_id = msg_user.id
WHERE time > 2024-01-01 AND (text LIKE '%продвижение' OR text LIKE '%сео' OR text LIKE '%директ');