1690: BIGINT value is out of range in '`ods_sls`.`sls_t_standings`.`QualPos` - `ods_sls`.`sls_t_standings`.`RacePos`'
SELECT COUNT(IF(RacePos <> 9999,1,null)) AS Events, SUM(Laps) AS DriverLaps, COUNT(IF(FinStatus <> 0,1,NULL)) NotFinished, COUNT(IF(RacePos<=3,1,NULL)) AS TOP3, COUNT(IF(RacePos<=10,1,NULL)) AS TOP8, AVG(IF(QualPos<>9999,QualPos,NULL)) AS AvrQualPos, AVG(IF(RacePos<>9999,RacePos,NULL)) AS AvrRacePos, AVG(IF(QualPos<9999 AND RacePos<9999 AND RacePos IS NOT NULL,CAST(QualPos-RacePos AS SIGNED),NULL)) AS PosProgress, AVG(Points-Penalties+Bonuses+LLbonus+FLbonus+MLbonus+RFbonus+PPbonus) avgpts FROM sls_t_standings WHERE ( sls_t_standings.IDcarClass=64 AND sls_t_standings.IDseason=47 ) AND ( IDdriver=362 ) GROUP BY IDdriver ; |
