1690: BIGINT UNSIGNED value is out of range in '((`srportug_sls`.`sls_t_standings`.`Points` - `srportug_sls`.`sls_t_standings`.`Penalties`) + `srportug_sls`.`sls_t_standings`.`Bonuses`)'
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=98 AND sls_t_standings.IDseason=73 ) AND ( IDdriver=6 ) GROUP BY IDdriver ; |
