Mercurial > hgrepos > hgweb.cgi > s4

comparison s4-funcs.sh @ 274:0f7bc60985d6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Count only text in grpaction list
author HIROSE Yuuji <yuuji@gentei.org>
date Mon, 01 Aug 2016 22:30:02 +0859
parents 31fbfcd4fc25
children b82007959b54
comparison
equal deleted inserted replaced
273:31fbfcd4fc25 274:0f7bc60985d6
2077 FROM article NATURAL JOIN article_s 2077 FROM article NATURAL JOIN article_s
2078 WHERE blogid IN 2078 WHERE blogid IN
2079 (SELECT id FROM blog_s 2079 (SELECT id FROM blog_s
2080 WHERE key='owner' 2080 WHERE key='owner'
2081 AND val=(SELECT gname FROM grp where rowid=$grid)) 2081 AND val=(SELECT gname FROM grp where rowid=$grid))
2082 AND author=a.name) 2082 AND author=a.name AND key='text')
2083 as POST, 2083 as POST,
2084 (SELECT group_concat(val, ',') 2084 (SELECT group_concat(val, ',')
2085 FROM grp_mem_m 2085 FROM grp_mem_m
2086 WHERE gname='$grp' AND user=a.name AND key='team') as TEAM 2086 WHERE gname='$grp' AND user=a.name AND key='team') as TEAM
2087 from 2087 from

yatex.org