diff options
| author | randomdan <randomdan@localhost> | 2010-11-13 18:20:48 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-11-13 18:20:48 +0000 |
| commit | 4a4e3f20845e45725340e48ad171898fbb06b6a5 (patch) | |
| tree | 7a70aa4a1309a366d413234a94632e6f63489fe6 /gentoobrowse/emails | |
| parent | Use package description from ebuild with highest version number, not file ID (diff) | |
| download | gentoobrowse-4a4e3f20845e45725340e48ad171898fbb06b6a5.tar.bz2 gentoobrowse-4a4e3f20845e45725340e48ad171898fbb06b6a5.tar.xz gentoobrowse-4a4e3f20845e45725340e48ad171898fbb06b6a5.zip | |
Remove most uses of files table from website, data now in ebuilds table
Diffstat (limited to 'gentoobrowse/emails')
| -rw-r--r-- | gentoobrowse/emails/newpackageversions.xml | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/gentoobrowse/emails/newpackageversions.xml b/gentoobrowse/emails/newpackageversions.xml index 83bebbc..f65a2de 100644 --- a/gentoobrowse/emails/newpackageversions.xml +++ b/gentoobrowse/emails/newpackageversions.xml @@ -7,14 +7,13 @@ select ut.cname, ut.pname, ut.version from ( select e.ebuildid, up.userid, u.useremail, p.name as pname, c.name as cname, e.version - from files f, ebuilds e, user_packages up, users u, packages p, categories c + from ebuilds e, user_packages up, users u, packages p, categories c where e.packageid = up.packageid - and f.fileid = e.ebuildid and u.userid = up.userid and u.userid = ? and e.packageid = p.packageid and c.categoryid = p.categoryid - and f.firstseen > up.trackedsince) as ut left outer join user_ebuild_emails ebe + and e.firstseen > up.trackedsince) as ut left outer join user_ebuild_emails ebe on ebe.userid = ut.userid and ebe.ebuildid = ut.ebuildid where ebe.userid is null order by ut.cname, ut.pname, ut.version |