(SELECT ALL j.JID, j.JDate, js.Name, j.amount, jl.JobLocation, cst.Name, j.QuantityPrints,
j.Mileage
FROM jobs j LEFT JOIN job_status js ON (js.Jsld = j.Status)
LEFT JOIN customers c ON (j.CID = c.CID) LEFT JOIN company cst ON (c.CmpId = cst.CmpId)
LEFT JOIN job_location jl ON (jl.jlid = j.OfficeLocation_id)
WHERE (j.InOffice = 'true') AND (c.CTId =  1 )  AND ( (j.Status =  1 )  OR (j.Status =  2 )
OR (j.Status =  3 )  OR (j.Status =  4 )  OR (j.Status =  5 ) ) )

(SELECT ALL j.JID, j.JDate, js.Name, j.amount, jl.JobLocation, cst.Name, j.QuantityPrints,
j.Mileage
FROM jobs j LEFT JOIN job_status js ON (js.Jsld = j.Status)
LEFT JOIN customers c ON (j.CID = c.CID) LEFT JOIN company cst ON (c.CmpId = cst.CmpId)
LEFT JOIN job_location jl ON (jl.jlid = j.OfficeLocation_id)
WHERE (j.InOffice = 'true') AND (c.CTId =  1 )  AND ( (j.Status =  1 )  OR (j.Status =  2 )
OR (j.Status =  3 )  OR (j.Status =  4 )  OR (j.Status =  5 ) ) )

UNION

(SELECT ALL j.JID,j.JDate, js.Name, j.amount, j.MobileLocation, cst.Name, j.QuantityPrints,
j.Mileage
FROM jobs j LEFT JOIN job_status js ON (js.Jsld = j.Status)
LEFT JOIN customers c ON (j.CID = c.CID) LEFT JOIN person cst ON (c.PersId = cst.PersId)
WHERE (j.InOffice = 'false') AND (c.CTId =  3 )  AND ( (j.Status =  1 )  OR (j.Status =  2 )
OR (j.Status =  3 )  OR (j.Status =  4 )  OR (j.Status = 5 ) ) )

SELECT ALL j.JID, j.JDate, js.Name, j.amount, jl.JobLocation, cst.Name, j.QuantityPrints,
 j.Mileage
 FROM jobs j LEFT JOIN job_status js ON (js.Jsld = j.Status)
 LEFT JOIN customers c ON (j.CID = c.CID) LEFT JOIN company cst ON (c.CmpId = cst.CmpId)
 LEFT JOIN job_location jl ON (jl.jlid = j.OfficeLocation_id)
 WHERE (j.InOffice = 'true') AND (c.CTId =  1 )  AND ( (j.Status =  1 )  OR (j.Status =  2 )
 OR (j.Status =  3 )  OR (j.Status =  4 )  OR (j.Status =  5 ) )
 union
 SELECT all j2.JID,j2.JDate, js2.Name, j2.amount, j2.MobileLocation, cst2.Name, j2.QuantityPrints,
 j2.Mileage
 FROM jobs j2 LEFT JOIN job_status js2 ON (js2.Jsld = j2.Status)
 LEFT JOIN customers c2 ON (j2.CID = c2.CID) LEFT JOIN person cst2 ON (c2.PersId = cst2.PersId)
 WHERE (j2.InOffice = 'false') AND (c2.CTId =  3 )  AND ( (j2.Status =  1 )  OR (j2.Status =  2 )
 OR (j2.Status =  3 )  OR (j2.Status =  4 )  OR (j2.Status = 5 ) )