Advertisement
mardrdr

Untitled

Apr 7th, 2020
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.17 KB | None | 0 0
  1.             SELECT
  2.                 ur.user_id,
  3.                 ur.center_id,
  4.                 IF(s.gender = 1, 'm', 'f') AS gender,
  5.                 s.stage_number,
  6.                 s.agestart,
  7.                 s.ageend
  8.             FROM user_results__2020 ur
  9.                 INNER JOIN users u ON ur.user_id = u.oId
  10.                 INNER JOIN stages s ON TIMESTAMPDIFF(YEAR, u.birthday, ur.start) BETWEEN s.agestart AND s.ageend
  11.                     AND s.gender = u.gender
  12.                     AND ur.start >= s.stagestart
  13.                     AND ur.start < s.stageend
  14.                     AND ((u.special_group IS NULL AND s.special_group IS NULL) OR u.special_group = s.special_group)
  15.             WHERE
  16.                 ur.start BETWEEN STR_TO_DATE(:dateStart, '%d.%m.%Y') AND STR_TO_DATE(:dateEnd, '%d.%m.%Y')
  17.                 AND ur.status = 1
  18.                 AND IFNULL(ur.result, '') <> ''
  19.                 AND NOT EXISTS (
  20.                     SELECT 1 FROM tmp_unique_user_center uuc
  21.                     WHERE uuc.user_id = ur.user_id
  22.                         AND uuc.center_id = ur.center_id
  23.                 )
  24.             GROUP BY ur.user_id, ur.center_id, s.stage_number
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement