| 11.12.20162016-12-11 21:15:00 | 21:15 | Primeira Liga | 13. R | Braga - Pacos de Ferreira | -:- |
| 5.12.20162016-12-5 21:00:00 | 21:00 | Primeira Liga | 12. R | Pacos de Ferreira - Boavista | -:- |
| 27.11.20162016-11-27 17:00:00 | 17:00 | Primeira Liga | 11. R | Arouca - Pacos de Ferreira | 1:0 (1:0) |
| 20.11.20162016-11-20 16:00:00 | 16:00 | Cup | 4. R | Vilafranquense - Pacos de Ferreira | 1:0 (0:0) |
| 5.11.20162016-11-5 17:00:00 | 17:00 | Primeira Liga | 10. R | Pacos de Ferreira - Chaves | 1:1 (0:0) |
| 28.10.20162016-10-28 20:00:00 | 20:00 | Primeira Liga | 9. R | Benfica - Pacos de Ferreira | 3:0 (1:0) |
| 25.10.20162016-10-25 16:30:00 | 16:30 | League Cup | 2. R | Pacos de Ferreira - Nacional | 4:0 (1:0) |
| 21.10.20162016-10-21 20:00:00 | 20:00 | Primeira Liga | 8. R | Pacos de Ferreira - Nacional | 1:1 (0:1) |
SELECT e.id
FROM event AS e
INNER JOIN event_participants AS ep ON e.id = ep.eventFK
LEFT JOIN participant AS p ON ep.participantFK = p.id
WHERE p.id =
AND e.status_type = 'finished'
ORDER BY e.startdate DESC
LIMIT 6 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND e.status_type = 'finished'
ORDER BY e.startdate DESC
' at line 8