Last active
September 17, 2018 14:30
-
-
Save nOy39/1ac24952be7fcb0c4181e18bac00c7ad to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select task0_.id as taskId, | |
task0_.color as taskColor, | |
task0_.created as created, | |
task0_.is_done as isDone, | |
task0_.task_id as subTask_id, | |
task0_.user_id as user_id | |
from task task0_ | |
where task0_.user_id=1 and (task0_.task_id is null) | |
group by task0_.id | |
order by task0_.id asc; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select count(task0_.id) as count from task task0_ where task0_.task_id=1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment