Ninja Mate

WHERE ps_ur > 1 AND ( ps_datetime BETWEEN '2016-08-23' AND '2016-11-22' )

SELECT SUM( CASE WHEN patient_gender = 'Male' THEN 1 ELSE 0 END ) Male, SUM( CASE WHEN patient_gender = 'Female' THEN 1 ELSE 0 END ) Female FROM patients WHERE patient_ur 
IN( 
    SELECT ps_ur FROM patient_services 
    AS ur JOIN ( 
        SELECT eng_ur FROM engagements WHERE eng_ur > 1 AND ( eng_datetime BETWEEN '2016-08-23' AND '2016-11-22' )) AS ur
    //где-то здесь WHERE поставить 
  )

<Route path="/" component={App}>
  <Route onEnter={checkAuth}>{/* Auth routes */}</Route>
  {/* Home page route */}
  <IndexRoute component={Home}>
  {/* Other public routes /*}
  <Route path="about" component={AboutPage} />
</Route>

export default class Link extends Component {
  constructor(props) {
    super(props);
  }

  componentDidMount() {
    this.onMouseEnterHandler()
  }

  onMouseEnterHandler() {
    $(this.refs.link).mouseover(function(ev){
      console.log(ev.currentTarget.text)
    });
  }

  render() {
    return (
        <a href='' ref='link'>My link</a>
    );
  }
}

export default class Link extends Component {
  constructor(props) {
    super(props);
    this.state = {
      title: 'Login'
    };
  }
  componentDidMount() {
    this.onMouseEnterHandler()
  }
  shouldComponentUpdate(nextProps, nextState) {
    return nextState.title !== this.state.title;
  }

  changeLoginState() {
    this.setState(({title}) => {
      return {title: 'Log out'};
    });
  }

  onMouseEnterHandler() {
    const link = $(this.refs.link)
    link.mouseover((ev) => {
      console.log(ev.currentTarget.text)
    });
    link.on('click', (ev) => {
      ev.preventDefault()
      this.changeLoginState()
    });
  }

  render() {
    const {title} = this.state
    return (
      <a href='' ref='link'>{title}</a>
    );
  }
}