Get all parent project

[mhonmon23]

Hi,

Is there any function from the api which I can get all the Parent Projects?
If yes please let me know and if no how about in DB?

Thanks

[mhonmon23]

If no api, for reference :

SELECT * FROM mantis_project_table as a
WHERE id NOT IN (SELECT child_id FROM mantis_project_hierarchy_table)
AND enabled = 1