Subversion Repositories DevTools

Rev

Rev 6586 | Rev 6612 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6586 Rev 6588
Line 44... Line 44...
44 
               vi.base_view,
44 
               vi.base_view,
45 
               Count(pv.pkg_id) AS pkg_count,
45 
               Count(pv.pkg_id) AS pkg_count,
46 
               0 as owner_id
 46 
               0 as owner_id
47 
          FROM views vi, release_content rc, package_versions pv
 47 
          FROM views vi, release_content rc, package_versions pv
48 
         WHERE  vi.base_view = 'Y'
 48 
         WHERE  vi.base_view = 'Y'
49 
               AND rc.base_view_id = vi.view_id
 49 
               AND rc.base_view_id(+) = vi.view_id
50 
               AND rc.pv_id = pv.pv_id
 50 
               AND rc.pv_id = pv.pv_id(+)
51 
         GROUP BY vi.view_id, vi.view_name, vi.base_view
51 
         GROUP BY vi.view_id, vi.view_name, vi.base_view
52 
       ) pview
 52 
       ) pview
53 
 ORDER BY UPPER(pview.view_name) ASC
 53 
 ORDER BY UPPER(pview.view_name) ASC