what type of ship is a class pirate?
(AND boats.ship_type (JOIN boats.ship_type.ship_class m.026f691))