Subversion Repositories DevTools

select * from (
    select 2 as etype, bs.blat_id, bs.blat_display_name, rt.proj_id, p.proj_name as proj_name, rt.rtag_id, rt.rtag_name from blat_servers bs, blat_projects bp, release_tags rt, projects p where bp.proj_id = rt.proj_id and rt.proj_id = p.proj_id AND bs.blat_id = bp.blat_id and rt.official in ('Y', 'C', 'R', 'N')
    UNION
    select 3 as etype, bs.blat_id, bs.blat_display_name, rt.proj_id, p.proj_name as proj_name, rt.rtag_id, rt.rtag_name from blat_servers bs, blat_releases br, release_tags rt, projects p where br.rtag_id = rt.rtag_id and rt.proj_id = p.proj_id AND bs.blat_id = br.blat_id
    UNION
    select 1 as etype, bs.blat_id, bs.blat_display_name,  null as proj_id, '' as proj_name, null as rtag_id, '' as rtag_name from blat_servers bs where bs.blat_full = 'Y'
    UNION
    select 0 as etype, bs.blat_id, bs.blat_display_name, null as proj_id, '' as proj_name, null as rtag_id, '' as rtag_name from blat_servers bs
)
order by blat_id, etype, UPPER(proj_name), UPPER(rtag_name)