Answer the question
In order to leave comments, you need to log in
How to make a proper exception in .hgignore in hg mercurial?
It is necessary to exclude all *
.txt
files from version control, leaving only files with the name
readme.txt
. regexp
(?!readme)txt
Answer the question
In order to leave comments, you need to log in
Probably the best option is to make 2 queries:
1) Get a list of releases: SELECT r.id, r.name, r.publication_date, <number of likes and users> FROM `releases` `r`
2) Get likes separately: SELECT GROUP_CONCAT(DISTINCT(`lr`.`user_id`)) AS users, COUNT(*) AS cnt FROM `likes_releases` `lr` WHERE `lr`.`release_id` in ( Required releases )
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question