Advertisement
Guest User

Untitled

a guest
Dec 6th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. SELECT
  2. `TaskRefUser`.`id`,
  3. `TaskRefUser`.`status` AS `task_status`,
  4. `TaskRefUser`.`is_tutor`,
  5. `TaskRefUser`.`mark`,
  6. `TaskRefUser`.`date_start`,
  7. `TaskRefUser`.`date_finish`,
  8. `user`.`id` AS `user.id`,
  9. `user`.`firstname` AS `user.firstname`,
  10. `user`.`secondname` AS `user.secondname`,
  11. `user`.`patronymic` AS `user.patronymic`,
  12. `user`.`login` AS `user.login`,
  13. `user`.`tags` AS `user.tags`,
  14. `user`.`department` AS `user.department`,
  15. `user`.`position` AS `user.position`,
  16. `user`.`city` AS `user.city`,
  17. `user`.`is_chief` AS `user.is_chief`,
  18. `user`.`is_active` AS `user.is_active`,
  19. `user`.`email` AS `user.email`,
  20. `task`.`id` AS `task.id`,
  21. `task`.`result_mode` AS `task.result_mode`
  22. FROM
  23. `els_tasks_ref_users` AS `TaskRefUser`
  24. INNER JOIN
  25. `cms_users` AS `user` ON `TaskRefUser`.`user_id` = `user`.`id`
  26. INNER JOIN
  27. `els_tasks` AS `task` ON `TaskRefUser`.`task_id` = `task`.`id`
  28. WHERE
  29. `TaskRefUser`.`is_tutor` = TRUE
  30. AND `user`.`is_deleted` = FALSE
  31. AND `task`.`is_deleted` != 'true'
  32. AND `task`.`site_id` = 3
  33. AND `task`.`type` = 'meetup'
  34. AND `TaskRefUser`.`task_id` = 20878
  35. LIMIT 0 , 10;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement