Skip to content
This repository has been archived by the owner on May 22, 2021. It is now read-only.

Use join query to get just tasks which author isn't banned #213

Open
PAException opened this issue Apr 17, 2020 · 1 comment
Open

Use join query to get just tasks which author isn't banned #213

PAException opened this issue Apr 17, 2020 · 1 comment
Labels
Improvement Improvement of existing feature Priority Extra attention is needed
Milestone
Alpha 0.2.x

Comments

@PAException
Copy link
Contributor

PAException commented Apr 17, 2020 •
edited
Loading

Example query:

SELECT solution.solution_id, solution.author_id, banned.user_id FROM solution WHERE (COUNT * 
FROM banned WHERE banned.user_id != solution.author_id)
@PAException PAException added the Improvement Improvement of existing feature label Apr 17, 2020
@PAException PAException added this to the Alpha milestone Apr 17, 2020
@PAException PAException modified the milestones: Alpha, Beta Apr 23, 2020
@PAException
Copy link
Contributor Author

In general we have to use more efficient querys everywhere

@PAException PAException added the Priority Extra attention is needed label May 15, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
Improvement Improvement of existing feature Priority Extra attention is needed
Projects
None yet
Milestone
Alpha 0.2.x
Development

No branches or pull requests
1 participant
@PAException