Advertisement
Guest User

Untitled

a guest
Feb 16th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.46 KB | None | 0 0
  1. $query = $builder->select('log')
  2.             ->count('offerId')
  3.             ->setColumns(['errorCode', 'errorMessage'])
  4.             ->groupBy(['errorCode', 'errorMessage'])
  5.             ->where()
  6.             ->equals('offerId', $this->offerId)
  7.             ->equals('date', $this->date)
  8.             ->end();
  9.  
  10. _-------------------_
  11. SELECT COUNT(offerId), errorCode, errorMessage FROM log WHERE offerId = 'test' AND date = '2019-02-12' GROUP BY errorCode, errorMessage
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement