Deleting smartqueue leaves it's corresponding record on smartqueue table

When you delete a smartqueue, the record on smartqueue table remains.

Some code need to be added/fixed to handle deleting this and an update function need to be added to delete those ghost records.

I have ran the following code to clean up my smartqueue table:

delete from smartqueue where qid not in (select qid from nodequeue_queue);