Skip to content

Instantly share code, notes, and snippets.

@nOy39
Last active September 17, 2018 14:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nOy39/1ac24952be7fcb0c4181e18bac00c7ad to your computer and use it in GitHub Desktop.
Save nOy39/1ac24952be7fcb0c4181e18bac00c7ad to your computer and use it in GitHub Desktop.
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;
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