Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Запрос который выводит количество файлов по успешности конвертирования
- --и наличию хорошей оценки у зарегистрированных/незарегистрированных пользователей.
- SELECT
- IF( `id_user` IS NULL, 'Visitor', 'User' ) AS `user_type`,
- COUNT(*) AS `count`
- FROM `files`
- WHERE
- `flag_converted` > 0 AND `rating` = 5
- GROUP BY `user_type`
- ORDER BY `count` DESC
- ------
- -- Формат вывода
- SELECT
- IF( `id_user` IS NULL, 'Visitor', 'User' ) AS `user_type`,
- `flag_converted`,
- IF ( `rating` = 5, 1, 0 ) AS `is_best_rating`
- FROM `files`
- ORDER BY `is_best_rating` DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement