MOST RATED IN NSW

SELECT Plate, State, Num, OffenceName, RegionName AS OccurredRegion, OccurredStates.StateAbbreviation AS OccurredState, IF (DAYOFYEAR(LatestRating.OffenceDttm)=DAYOFYEAR(CURRENT_DATE()), 'Today', IF (DAYOFYEAR(LatestRating.OffenceDttm)=DAYOFYEAR(CURRENT_DATE())-1, 'Yesterday', DATE_FORMAT(LatestRating.OffenceDttm, '%a %d %b %Y'))) as OffenceDttmFormatted FROM ( SELECT UPPER(RegistrationNumberText) AS Plate, RegoStates.StateAbbreviation AS State, MAX(OffenceReportID) AS LatestRatingID, COUNT(VWApprovedRatings.RegistrationNumberID) AS Num FROM VWApprovedRatings INNER JOIN TBLRegistrationNumbers ON VWApprovedRatings.RegistrationNumberID=TBLRegistrationNumbers.RegistrationNumberID INNER JOIN TBLStates RegoStates ON TBLRegistrationNumbers.RegistrationState=RegoStates.StateID WHERE State='NSW' GROUP BY RegistrationNumberText, RegoStates.StateAbbreviation ORDER BY Num DESC, Plate, State LIMIT 0, 5) AS RawRatings INNER JOIN VWApprovedRatings LatestRating ON RawRatings.LatestRatingID=LatestRating.OffenceReportID INNER JOIN TBLOffences ON LatestRating.OffenceID=TBLOffences.OffenceID LEFT JOIN TBLRegions ON LatestRating.OccurredInRegionID=TBLRegions.RegionID INNER JOIN TBLStates OccurredStates ON LatestRating.OccurredInStateID=OccurredStates.StateID Unknown column 'State' in 'where clause'