limit 5 iclouding also all the equals value with the 5th

From: Kostas Konstantinidis <kost36_at_gmail.com>
Date: Sat, 7 Oct 2017 07:58:24 -0700 (PDT)
Message-ID: <96480ca2-7736-47a3-8741-6d6318e0fa81_at_googlegroups.com>

Hi all,
[Quoted] [Quoted] trying to display the top 10 Greek men directors I use:

    SELECT

        `t_people`.`person` AS `person`,
        COUNT(`st_peoplefilms`.`ID_films`) AS `CountOfID_films`
    FROM
        (`t_people`
        JOIN `st_peoplefilms` ON ((`t_people`.`ID_person` = `st_peoplefilms`.`ID_person`)))
    GROUP BY `t_people`.`person` , `st_peoplefilms`.`ID_idiotita` , `kost36_greekfilm`.`t_people`.`an`
    HAVING ((`st_peoplefilms`.`ID_idiotita` = 29)
        AND (`t_people`.`man` = 1))

    ORDER BY COUNT(`st_peoplefilms`.`ID_films`) DESC     LIMIT 5 What I need is to display also all the equal with the 5th records

e.g.
person CountOfID_films

1            100
2             95
3             70
4             68
5             65
-----------------
6             65
7             65
8             65

Any idea how to make it to work?
thank's Received on Sat Oct 07 2017 - 16:58:24 CEST