Ticket #118: comments_delete_by_status.txt

    public static function delete_by_status( $status )
    {
        $comments= DB::table( 'comments' );
        $commentinfo= DB::table( 'commentinfo' );

        $sql= "DELETE FROM {$comments}
            WHERE {$comments}.status = ?;";
        
        DB::query( $sql, array( Comment::status( $status ) ) );

        $sql = "DELETE FROM {commentinfo} 
            WHERE {commentinfo}.comment_id NOT IN 
                (SELECT {comments}.id FROM {comments});";
        DB::query( $sql );
    }