Advertisement
Guest User

Untitled

a guest
May 16th, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. $consents = $consentsTable->find('all')->where([
  2. 'Consents.is_accepted' => 0,
  3. 'Consents.requested_at IS NULL',
  4. 'Consents.consent_type' => 'use_by_jev'
  5. ])
  6. ->contain(['Prospects'], function( Query $qmail )
  7. {
  8. return $qmail
  9. -> where (['Prospects.email IS NOT NULL', 'Prospects.email !=' => ''] );
  10. }
  11. );
  12. ->page($page, 100)
  13. ->order('Consents.id', 'DESC');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement