Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- ur.user_id,
- ur.center_id,
- IF(s.gender = 1, 'm', 'f') AS gender,
- s.stage_number,
- s.agestart,
- s.ageend
- FROM user_results__2020 ur
- INNER JOIN users u ON ur.user_id = u.oId
- INNER JOIN stages s ON TIMESTAMPDIFF(YEAR, u.birthday, ur.start) BETWEEN s.agestart AND s.ageend
- AND s.gender = u.gender
- AND ur.start >= s.stagestart
- AND ur.start < s.stageend
- AND ((u.special_group IS NULL AND s.special_group IS NULL) OR u.special_group = s.special_group)
- WHERE
- ur.start BETWEEN STR_TO_DATE(:dateStart, '%d.%m.%Y') AND STR_TO_DATE(:dateEnd, '%d.%m.%Y')
- AND ur.status = 1
- AND IFNULL(ur.result, '') <> ''
- AND NOT EXISTS (
- SELECT 1 FROM tmp_unique_user_center uuc
- WHERE uuc.user_id = ur.user_id
- AND uuc.center_id = ur.center_id
- )
- GROUP BY ur.user_id, ur.center_id, s.stage_number
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement