SeaQuest » SeaScape

Mariusz had a first look into this:

Here is an example of a query for Hodoscope 1, display mode: multiplicty filter: intime.

SELECT IF="P",CONCAT,"_",RIGHT),detectorName)
AS `grpName`, `multiplicity`, COUNT()
FROM (SELECT detectorName, COUNT() as `multiplicity` FROM run_009218_R001.Hit WHERE spillID BETWEEN 319981 AND 319985 AND inTime = 1 GROUP BY detectorName, eventID) slice WHERE detectorName
IN ("H1T", "H1B", "H1L", "H1R") GROUP BY grpName, `multiplicity`
ORDER BY grpName ASC, `multiplicity` ASC

The query is always written to the console after: "INFO in db [C:\Users\Mariusz Witek\seascapeNEW\seascape\seascape\db.py:181]:
Executing query:" which is where I got this from.

I tried loading other detectors with the same display mode and filter and I got what seemed to be good looking data (it wasn't only 0). Attached is a picture of what I got for Drift Chamber D3m with the following query:

SELECT IF="P",CONCAT,"_",RIGHT),detectorName)
AS `grpName`, `multiplicity`, COUNT()
FROM (SELECT detectorName, COUNT() as `multiplicity` FROM run_009218_R001.Hit WHERE spillID BETWEEN 319988 AND 319992 AND inTime = 1 GROUP BY detectorName, eventID) slice WHERE detectorName
IN ("D3mU", "D3mX", "D3mV", "D3mUp", "D3mXp", "D3mVp") GROUP BY grpName, `multiplicity` ORDER BY grpName ASC, `multiplicity` ASC

Is the problem the long section of 0's that I highlighted? I checked to see if the query consisted of on values 0 and it didn't, that's just flot putting in 0 if it has no value for it.