Guest User

Untitled

a guest
Jan 8th, 2016
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. SELECT COUNT(*)
  2. FROM
  3. final_car_user f0_
  4. LEFT JOIN questionnaire q1_ ON f0_.id = q1_.finalCarUser_id
  5. LEFT JOIN final_car_user_companies f2_ ON f0_.id = f2_.finalCarUser_id
  6. AND (f2_.finalCarUser_id = f0_.id)
  7. LEFT JOIN external_ordering_company e3_ ON f2_.externalOrderingCompany_id = e3_.id
  8. AND (
  9. f2_.externalOrderingCompany_id = e3_.id
  10. )
  11. WHERE
  12. replace(
  13. replace(e3_.nip, '-', ''),
  14. ' ',
  15. ''
  16. ) = 1070016099
  17. GROUP BY f0_.id
  18. ORDER BY
  19. f0_.first_name ASC,
  20. f0_.last_name ASC
Add Comment
Please, Sign In to add comment