| 6770 |
dpurdie |
1 |
select * from (
|
|
|
2 |
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')
|
|
|
3 |
UNION
|
|
|
4 |
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
|
|
|
5 |
UNION
|
|
|
6 |
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'
|
|
|
7 |
UNION
|
|
|
8 |
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
|
|
|
9 |
)
|
|
|
10 |
order by blat_id, etype, UPPER(proj_name), UPPER(rtag_name)
|