Filing for posterity

Player creation dates are null for many players, nearly all controller / receivers.

Andy identifies this due to players added via Jive not storing created date.

Andy--feel free to mark as fixed. I'll monitor the data for a week or so and confirm.

SELECT
SUM( IF( t2.deviceid=4, 1, 0 ) ) AS "SB 2/3",
SUM( IF( t2.deviceid=5, 1, 0 ) ) AS "Transporter",
SUM( IF( t2.deviceid=7, 1, 0 ) ) AS "Receiver",
SUM( IF( t2.deviceid=9, 1, 0 ) ) AS "Controller",
SUM( IF( t2.deviceid=10, 1, 0 ) ) AS "Boom"
FROM users AS t1 JOIN players AS t2 ON t1.id=t2.userid
WHERE (
  ( t1.created IS NOT NULL ) AND
  ( t1.created>"2009-03-01 00:00:00" ) AND
  ( t2.created IS NULL )
)
ORDER BY t1.registered DESC;

versus

SELECT
SUM( IF( t2.deviceid=4, 1, 0 ) ) AS "SB 2/3",
SUM( IF( t2.deviceid=5, 1, 0 ) ) AS "Transporter",
SUM( IF( t2.deviceid=7, 1, 0 ) ) AS "Receiver",
SUM( IF( t2.deviceid=9, 1, 0 ) ) AS "Controller",
SUM( IF( t2.deviceid=10, 1, 0 ) ) AS "Boom"
FROM users AS t1 JOIN players AS t2 ON t1.id=t2.userid
WHERE (
  ( t1.created IS NOT NULL ) AND
  ( t1.created>"2009-03-01 00:00:00" ) AND
  ( t2.created IS NOT NULL )
)
ORDER BY t1.registered DESC;