Deleting multiple containers using sql like syntax

I am trying to delete multiple containers using sql syntax, but I am getting this error on the container object
Error: Not Allowed On Non-leaf - Unable to delete

I can delete container using the admin tool table view but unable to delete them using sql syntax.

Try running the same sql a few time with subtreescope and skip all errors
for e.g. DELETE FROM o=stooges subtreescope

It will delete the child records in each run and will eventually delete the container

(Please always make sure that you are deleting the correct entries)