select C.ID_CLIENT, C.OWNERSHIP_TYPE_ID, C.CLIENT_NAME, C.CLIENT_FULL_NAME, C.CLIENT_UNP, C.CLIENT_SPECIALIZATION,
       C.CLIENT_FAX, C.CLIENT_EMAIL, C.CLIENT_BILL_MUST_FLAG, C.CLIENT_NOTE, C.BAILEE_USER_ID, C.CLIENT_NOTE_FOR_DRIVER,
       C.CLIENT_NOTE_FOR_DRIVER_UNLOAD, C.POST_COUNTRY, C.POST_CITY, C.POST_STREET_AND_OTHER, C.POST_ZIP_CODE,
       C.ADDRESS_POST_ZIP_CODE, C.POST_OTHER_NAME, C.ADDRESS_COUNTRY,
       (select COUNTRYNAME_RUS_SHORT
        from ADDR_COUNTRY
        where ID_COUNTRY = C.ADDRESS_COUNTRY) as ADDRESS_COUNTRY_STRING, C.ADDRESS_CITY,
       (select CITYNAME_RUS
        from ADDR_CITY
        where ID_CITY = C.ADDRESS_CITY) as ADDRESS_CITY_STRING, C.ADDRESS_STREET_AND_OTHER, C.USER_ADDED,
       (select USER_SURMANE || ' ' || left(USER_FIRST_NAME, 1) || '.' || left(USER_PATRONYMIC_NAME, 1) || '.'
        from SUPP_USER
        where ID_USER = C.USER_ADDED) as USER_ADDED_STRING,
       (select USER_SURMANE || ' ' || left(USER_FIRST_NAME, 1) || '.' || left(USER_PATRONYMIC_NAME, 1) || '.'
        from SUPP_USER
        where ID_USER = C.BAILEE_USER_ID) as BAILEE_USER_STRING, C.DATE_ADDED, upper((select COUNTRYNAME_RUS_SHORT
                                                                                      from ADDR_COUNTRY
                                                                                      where ID_COUNTRY = C.POST_COUNTRY)) as POST_COUNTRY_STRING, upper((select COUNTRYNAME_ENG
                                                                                                                                                         from ADDR_COUNTRY
                                                                                                                                                         where ID_COUNTRY = C.POST_COUNTRY)) as POST_COUNTRY_ENG, upper((select CITYNAME_RUS
                                                                                                                                                                                                                         from ADDR_CITY
                                                                                                                                                                                                                         where ID_CITY = C.POST_CITY)) as POST_CITY_STRING, upper((select CITYNAME_ORIG
                                                                                                                                                                                                                                                                                   from ADDR_CITY
                                                                                                                                                                                                                                                                                   where ID_CITY = C.POST_CITY)) as POST_CITY_ENG,
       O.OWNERSHIP_TYPE_SHORT,
       case
         when CLIENT_NAME is not null and CLIENT_FULL_NAME is not null and OWNERSHIP_TYPE_ID is not null and ADDRESS_COUNTRY is not null and ADDRESS_CITY is not null and ADDRESS_STREET_AND_OTHER is not null and CLIENT_UNP is not null then 1
         else 0
       end as ALL_FILL,
       C.DATE_CREATED, C.DATE_LIQUIDATION
from ORDER_CLIENT C
left join ORDER_OWNERSHIP_TYPE O on O.ID_OWNERSHIP_TYPE = C.OWNERSHIP_TYPE_ID
order by upper(C.CLIENT_NAME)