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