SELECT 
konstest.in_date, konstest.nimushis_nomer,
Year([in_date]) AS YY,
Month([in_date]) AS MM,
konstest.out_date, konstest.id_konstest, konstest.id_patient, patients.patient_family, patients.patient_name,
[patient_family] & " " & [patient_name] AS gvarname,
patients.sqesi, patients.mother_name, patients.father_name, patients.birthday, birthday_place.city, patients.piradi_nomeri, patients.piradi_nomeri_other,
IIf(IsNull([piradi_nomeri]),[piradi_nomeri_other],[piradi_nomeri]) AS piradoba,
Left([patient_name],1) & Format(Len([patient_family]),"00") & Left([mother_name],2) & Left([father_name],2) & Format([birthday],"dd") & Format([birthday],"mm") & Format([birthday],"yy") & Left([birthday_place].[city],1) & IIf([sqesi]="mmm","1",IIf([sqesi]="ddd","2","")) AS kodi,
patients.telephone, patients.shenishvna, city.city, konstest.id_organization, organization.organization, konstest.id_consultant,
Left([consultant_name],1) & ". " & [consultant_family] AS consultant,
konstest.id_eqimi_laboranti,
Left([eqimi_laboranti_name],1) & ". " & [eqimi_laboranti_family] AS eqimi,
konstest.test_dadebiti, konstest.test_uarkofiti, konstest.test_ganmeoreba, konstest.chvenebis_kodi, konstest.narkotiki, konstest.seksmushaki, konstest.homobisexual, konstest.riskgroup_other, konstest.cxeleba, konstest.sisuste, konstest.tsonashi_kleba, konstest.oflianoba, konstest.limfadenopatia, konstest.qronikuli_diarea, konstest.filtvebis_anteba, konstest.gamonakari_kanze, konstest.nervuli_sistema, konstest.tavis_tkivili, konstest.symptom_other, konstest.mark_konstest
FROM ((((consultant RIGHT JOIN (city RIGHT JOIN konstest ON city.id_city = konstest.id_city) ON consultant.id_consultant = konstest.id_consultant) 
LEFT JOIN eqimi_laboranti ON konstest.id_eqimi_laboranti = eqimi_laboranti.id_eqimi_laboranti) 
LEFT JOIN organization ON konstest.id_organization = organization.id_organization) 
RIGHT JOIN patients ON konstest.id_patient = patients.id_patient) 
LEFT JOIN city AS birthday_place ON patients.id_city = birthday_place.id_city
ORDER BY konstest.in_date, konstest.nimushis_nomer;