select     
A.SYS_GUID as "ОУ_GUID",
FED_OKR_RF."NAME" as "Федеральный округ",
RBDC_REGIONS.REGIONNAME as "Субъект РФ",
A.SCHOOLNAME as "Полное наименование",
A.SHORTNAME as "Сокращенное наименование",
A.BRANCH as "Признак филиала",
A.PARENTSCHOOLFK as "Головное ОУ_GUID",
coalesce((select RBD_SCHOOLS.SCHOOLNAME from RBD_SCHOOLS where RBD_SCHOOLS.SYS_GUID = A.PARENTSCHOOLFK
and (RBD_SCHOOLS.SYS_STATE NOT IN (1,3) or RBD_SCHOOLS.SYS_STATE is null)
), 'null') as "Головное ОУ наименование",
A.FUNCT as "Действует",
RBDC_SCHOOL_SUBPROPERTIES.SCHOOLPROPERTYNAME as "Вид организационно-правовой формы значение",
A.SCHOOLPROPERTYFK as "Вид организационно-правовой формы_GUID",
SCHOOL_KINDS.SCHOOL_KINDNAME as "Вид ОУ",
A.SCHOOLKINDFK as "Вид ОУ_GUID",
SCHOOL_SUBTYPES.SCHOOL_SUBTYPENAME as "Тип ОУ",
A.SCHOOLTYPEFK as "Тип ОУ_GUID",
A.INN as "ИНН",
A.GOSREGNUM as "Номер государственной регистрации в ЕГРЮЛ(ОГРН)",
A.GOSREG_DATE as "Дата регистрации в ЕГРЮЛ",
A.KPP as "КПП",
FOUNDERS.UCHR_NAME as "Учредитель(из таблицы учредителей)",
A.LAWADDRESS as "Юридический адрес",
A.ADDRESS as "Фактический адрес",
A.CHARGEFIO as "ФИО руководителя",
A.CHARGEPOSITION as "Должность руководителя",
A.PHONES as "Телефон",
A.FAXS as "ФАКС",
A.MAILS as "e-mail ОУ",
A.WWW as "Адрес сайта ОУ"
from RBD_SCHOOLS as A
LEFT JOIN RBDC_REGIONS ON A.REGION_LOCATION = RBDC_REGIONS.REGION
LEFT JOIN FED_OKR_RF ON RBDC_REGIONS.FED_OKR_FK = FED_OKR_RF.SYS_GUID
LEFT JOIN RBDC_SCHOOL_SUBPROPERTIES ON A.SCHOOLPROPERTYFK = RBDC_SCHOOL_SUBPROPERTIES.SYS_GUID
LEFT JOIN SCHOOL_KINDS ON A.SCHOOLKINDFK = SCHOOL_KINDS.SYS_GUID
LEFT JOIN SCHOOL_SUBTYPES ON A.SCHOOLTYPEFK = SCHOOL_SUBTYPES.SYS_GUID
LEFT JOIN FOUNDER_SCHOOLS ON A.SYS_GUID = FOUNDER_SCHOOLS.SCHOOLSFK
LEFT JOIN FOUNDERS ON FOUNDER_SCHOOLS.FOUNDERSFK = FOUNDERS.SYS_GUID
where (A.SYS_STATE NOT IN (1,3) or A.SYS_STATE is null)
and (RBDC_REGIONS.SYS_STATE NOT IN (1,3) or RBDC_REGIONS.SYS_STATE is null)
and (FED_OKR_RF.SYS_STATE NOT IN (1,3) or FED_OKR_RF.SYS_STATE is null)
and (RBDC_SCHOOL_SUBPROPERTIES.SYS_STATE NOT IN (1,3) or RBDC_SCHOOL_SUBPROPERTIES.SYS_STATE is null)
and (SCHOOL_KINDS.SYS_STATE NOT IN (1,3) or SCHOOL_KINDS.SYS_STATE is null)
and (SCHOOL_SUBTYPES.SYS_STATE NOT IN (1,3) or SCHOOL_SUBTYPES.SYS_STATE is null)
and (FOUNDER_SCHOOLS.SYS_STATE NOT IN (1,3) or FOUNDER_SCHOOLS.SYS_STATE is null)
and (FOUNDERS.SYS_STATE NOT IN (1,3) or FOUNDERS.SYS_STATE is null)