1690: BIGINT UNSIGNED value is out of range in '((`therapy_sls`.`sls_t_standings`.`Points` - `therapy_sls`.`sls_t_standings`.`Penalties`) + `therapy_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=124 AND sls_t_standings.IDseason=67 ) AND ( IDdriver=185 ) GROUP BY IDdriver ; |