Use the next SQL query:
Code: |
DELETE SI,S FROM jos_ariquizstatisticsinfo SI LEFT JOIN jos_ariquizstatistics S ON SI.StatisticsInfoId = S.StatisticsInfoId WHERE SI.Status <> "Finished"
|
or the next if you want to delete not finished quiz sessions for specific users (for example with user ID equals to 75):
Code: |
DELETE SI,S FROM jos_ariquizstatisticsinfo SI LEFT JOIN jos_ariquizstatistics S ON SI.StatisticsInfoId = S.StatisticsInfoId WHERE SI.Status <> "Finished" AND SI.UserId = 75
|
Regards,
ARI Soft