Hi,

I would like to execute this SQL request. But wpdatatables doesn't seem to execute the request correctly.

SELECT  nom,
        (SELECT sum(time_to_sec((cast(temps as time))) / 60 / 60)
            FROM rapport_brut
            WHERE appareil = ICAO) as "HEURES UTILISÉES"
    FROM flotte
    WHERE active = '1'
    ORDER BY (SELECT sum(time_to_sec((cast(temps as time))) / 60 / 60)
            FROM rapport_brut
            WHERE appareil = ICAO) DESC
    LIMIT 10

At this time... limit clause doesn't work. It is completely ignored.

Also, the order by doesn't work either.

I want to have a top 10 of uses of airplane.

Thanks for your help

Francis