query

I'm looking for a query that does the following in Mysql

What he does is pick up the final price of an item. I use this code only if he does anything or not but he grabs the latest price!

Does anyone know how the final price can get it out.

Prizes will be saved per year on a weekly level.

Code:

SELECT tblart.aid
, tblart.A_nr
, tblart.A_naam
, tblprijs.ap_prijs
, tblprijs.ap_week
, tblprijs.ap_jaar
FROM
vm06inkdb1.tblart
INNER JOIN vm06inkdb1.tblprijs
ON tblart.aid = tblprijs.aid
WHERE
tblart.A_nr = 774971
GROUP BY
tblprijs.aid