Guest User

Untitled

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