It is the rare big-city mayor , after all , who serves six months in prison for a drug conviction stemming from an FBI video tape showing him smoking crack in a hotel room with a lady friend not his wife .