This worked:
Code: Select all
SELECT diesel.km - IFNULL((SELECT diesel.km FROM diesel WHERE diesel.car=(select diesel.car from diesel where diesel.id = %ID%) AND diesel.id < %ID% order by diesel.data DESC limit 1),0) from diesel where diesel.id=%ID%
Code: Select all
SELECT diesel.km - IFNULL((SELECT diesel.km FROM diesel WHERE diesel.car=(select diesel.car from diesel where diesel.id = %ID%) AND diesel.id < %ID% order by diesel.data DESC limit 1),0) from diesel where diesel.id=%ID%