gistfile1.txt

/* socorro.search.Search search */ SELECT r.signature, count(r.id) as total, count(CASE WHEN (r.os_name = E'Windows NT') THEN 1 END) AS is_windows, count(CASE WHEN (r.os_name = E'Mac OS X') THEN 1 END) AS is_mac, count(CASE WHEN (r.os_name = E'Linux') THEN 1 END) AS is_linux, SUM (CASE WHEN r.hangid IS NULL THEN 0  ELSE 1 END) AS numhang, SUM (CASE WHEN r.process_type IS NULL THEN 0  ELSE 1 END) AS numplugin FROM reports rWHERE r.date_processed BETWEEN '2011-12-07T18:41:04' AND '2011-12-14T18:41:04'AND (r.product=E'Firefox') AND ((r.product=E'Firefox' AND r.release_channel ILIKE 'Beta' AND r.build IN ('20111206234556', '20111206234556', '20111206234556', '20111206234556') AND r.version=E'9.0b5')) GROUP BY r.signature ORDER BY total DESC LIMIT 100
 OFFSET 0


/* socorro.search.Search search */ SELECT r.signature, count(r.id) as total, count(CASE WHEN (r.os_name = E'Windows NT') THEN 1 END) AS is_windows, count(CASE W
HEN (r.os_name = E'Mac OS X') THEN 1 END) AS is_mac, count(CASE WHEN (r.os_name 
= E'Linux') THEN 1 END) AS is_linux, SUM (CASE WHEN r.hangid IS NULL THEN 0  ELS
E 1 END) AS numhang, SUM (CASE WHEN r.process_type IS NULL THEN 0  ELSE 1 END) A
S numplugin FROM reports r 
WHERE r.date_processed BETWEEN '2011-12-07T18:41:04' AND '2011-12-14T18:41:04'
AND (r.product=E'Firefox') AND ((r.product=E'Firefox' AND r.release_channel ILIKE 'Beta' AND r.build IN ('20111206234556', '20111206234556', '20111206234556', '20111206234556') AND r.version=E'9.0b5') OR (r.product=E'Firefox' AND r.release_channel ILIKE 'Beta' AND r.build IN ('20111130065942', '20111130065942', '20111130065942', '20111130065942') AND r.version=E'9.0')) GROUP BY r.signature
ORDER BY total DESC
LIMIT 100
OFFSET 0