| 119 |
ghuddy |
1 |
/* Formatted on 2006/08/25 11:04 (Formatter Plus v4.8.6) */
|
|
|
2 |
SELECT wip.pv_id, pv.pkg_version, pkg.pkg_name, 'WIP' AS state
|
|
|
3 |
FROM work_in_progress wip, package_versions pv, PACKAGES pkg
|
|
|
4 |
WHERE wip.rtag_id = :rtag_id AND pv.pv_id = wip.pv_id
|
|
|
5 |
AND pv.pkg_id = pkg.pkg_id
|
|
|
6 |
UNION
|
|
|
7 |
SELECT pl.pv_id, pv.pkg_version, pkg.pkg_name, 'PENDING' AS state
|
|
|
8 |
FROM planned pl, package_versions pv, PACKAGES pkg
|
|
|
9 |
WHERE pl.rtag_id = :rtag_id AND pl.pv_id = pv.pv_id
|
|
|
10 |
AND pkg.pkg_id = pv.pkg_id
|
|
|
11 |
ORDER BY STATE desc, pkg_name, pkg_version asc
|