Index: trunk/ippTools/share/chiptool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 27797)
+++ trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 27856)
@@ -10,5 +10,6 @@
     rawExp.camera,
     rawExp.telescope,
-    rawExp.filelevel
+    rawExp.filelevel,
+    IFNULL(Label.priority, 10000) AS priority
 FROM chipRun
 JOIN rawExp
@@ -25,4 +26,5 @@
 LEFT JOIN chipMask
     ON chipRun.label = chipMask.label
+LEFT JOIN Label ON chipRun.label = Label.label
 WHERE
     ((chipRun.state = 'new'
@@ -35,2 +37,3 @@
     AND chipProcessedImfile.data_state = 'update'
     AND chipProcessedImfile.fault = 0))
+    AND (Label.active OR Label.active IS NULL)
Index: trunk/ippTools/share/pstamptool_completedreq.sql
===================================================================
--- trunk/ippTools/share/pstamptool_completedreq.sql	(revision 27797)
+++ trunk/ippTools/share/pstamptool_completedreq.sql	(revision 27856)
@@ -1,4 +1,6 @@
-SELECT * 
+SELECT pstampRequest.* ,
+    IFNULL(labels.priority, 0) AS priority
 FROM pstampRequest 
+    LEFT JOIN labels USING(label) 
 WHERE state = 'run'
     AND (
Index: trunk/ippTools/share/pstamptool_getdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_getdependent.sql	(revision 27797)
+++ trunk/ippTools/share/pstamptool_getdependent.sql	(revision 27856)
@@ -1,5 +1,5 @@
 SELECT DISTINCT pstampDependent.*
 FROM pstampDependent
-JOIN pstampJob USING(dep_id)
-JOIN pstampRequest USING(req_id)
+-- JOIN pstampJob USING(dep_id)
+-- JOIN pstampRequest USING(req_id)
 WHERE pstampDependent.state = 'new'
Index: trunk/ippTools/share/pstamptool_pendingdependent.sql
===================================================================
--- trunk/ippTools/share/pstamptool_pendingdependent.sql	(revision 27797)
+++ trunk/ippTools/share/pstamptool_pendingdependent.sql	(revision 27856)
@@ -1,8 +1,11 @@
-SELECT DISTINCT pstampDependent.*
+SELECT DISTINCT pstampDependent.*,
+    IFNULL(Label.priority, 10000) AS priority
 FROM pstampDependent
 JOIN pstampJob USING(dep_id)
 JOIN pstampRequest USING(req_id)
+JOIN Label ON pstampRequest.label = Label.label
 WHERE pstampDependent.state = 'new'
     AND pstampDependent.fault = 0
     AND pstampJob.state = 'run'
     AND pstampRequest.state = 'run'
+    AND (Label.active OR Label.active IS NULL)
Index: trunk/ippTools/share/pstamptool_pendingjob.sql
===================================================================
--- trunk/ippTools/share/pstamptool_pendingjob.sql	(revision 27797)
+++ trunk/ippTools/share/pstamptool_pendingjob.sql	(revision 27856)
@@ -1,6 +1,8 @@
-SELECT pstampJob.*
+SELECT pstampJob.*,
+    IFNULL(Label.priority, 10000) AS priority
 FROM pstampJob
     JOIN pstampRequest USING(req_id)
     LEFT JOIN pstampDependent USING(dep_id)
+    LEFT JOIN Label ON pstampRequest.label = Label.label
 WHERE pstampRequest.state = 'run'
     AND pstampRequest.fault = 0
@@ -8,2 +10,3 @@
     AND pstampJob.fault = 0
     AND (dep_id = 0 OR pstampDependent.state = 'full')
+    AND (Label.active OR Label.active IS NULL)
Index: trunk/ippTools/share/pstamptool_pendingreq.sql
===================================================================
--- trunk/ippTools/share/pstamptool_pendingreq.sql	(revision 27797)
+++ trunk/ippTools/share/pstamptool_pendingreq.sql	(revision 27856)
@@ -1,9 +1,11 @@
 -- postage stamp requests ready for download and parsing
 SELECT
- pstampRequest.*,
- pstampDataStore.outProduct as ds_outProduct
- FROM pstampRequest
- LEFT JOIN pstampDataStore
-    USING(ds_id)
- WHERE pstampRequest.state = 'new'
+    pstampRequest.*,
+    pstampDataStore.outProduct AS ds_outProduct,
+    IFNULL(Label.priority, 10000) AS priority
+    FROM pstampRequest
+    LEFT JOIN pstampDataStore USING(ds_id)
+    LEFT JOIN Label ON pstampRequest.label = Label.label
+WHERE pstampRequest.state = 'new'
     AND pstampRequest.fault = 0
+    AND (Label.active OR Label.active IS NULL)
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 27797)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 27856)
@@ -1332,4 +1332,5 @@
         imagedb    VARCHAR(64),
         rlabel     VARCHAR(64),
+        outdir     VARCHAR(255),
         need_magic TINYINT,
         PRIMARY KEY(dep_id),
@@ -1599,4 +1600,14 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE Label (
+    label       VARCHAR(64),
+    priority    INT,
+    active      TINYINT,
+    comment     VARCHAR(80),
+    PRIMARY KEY(label),
+    KEY(priority),
+    KEY(active)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 -- This comment line is here to avoid empty query error.
 -- Another way to avoid that problem is to omit the semicolon above but I think that is untidy.
Index: trunk/ippTools/share/pxadmin_drop_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 27797)
+++ trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 27856)
@@ -84,4 +84,5 @@
 DROP TABLE IF EXISTS staticskyResult;
 DROP TABLE IF EXISTS staticskyRun;
+DROP TABLE IF EXISTS Label;
 
 SET FOREIGN_KEY_CHECKS=1