Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*)
- FROM (
- SELECT f0_.id
- FROM
- final_car_user f0_
- LEFT JOIN questionnaire q1_ ON f0_.id = q1_.finalCarUser_id
- LEFT JOIN final_car_user_companies f2_ ON f0_.id = f2_.finalCarUser_id
- AND (f2_.finalCarUser_id = f0_.id)
- LEFT JOIN external_ordering_company e3_ ON f2_.externalOrderingCompany_id = e3_.id
- AND (
- f2_.externalOrderingCompany_id = e3_.id
- )
- WHERE
- replace(
- replace(e3_.nip, '-', ''),
- ' ',
- ''
- ) = 1070016099
- GROUP BY f0_.id
- ORDER BY
- f0_.first_name ASC,
- f0_.last_name ASC
- ) as t1
Advertisement
Add Comment
Please, Sign In to add comment