SELECT 
	array_to_string (array(SELECT d_t_ids."ID" FROM "DOCTOR_TYPES" d_t 
		       LEFT JOIN "DOCTOR_TYPE_IDS" d_t_ids ON d_t_ids."ID" = d_t."DOCTOR_TYPE_ID" 
		       WHERE d_t."DOCTOR_ID" = d."ID" ORDER BY d_t_ids."ID" ASC), ',') as DOCTOR_TYPE_ID, 
	array_to_string (array(SELECT d_t_ids."NAME" FROM "DOCTOR_TYPES" d_t 
		       LEFT JOIN "DOCTOR_TYPE_IDS" d_t_ids ON d_t_ids."ID" = d_t."DOCTOR_TYPE_ID" 
		       WHERE d_t."DOCTOR_ID" = d."ID" ORDER BY d_t_ids."ID" ASC), ',') as DOCTOR_TYPE_NAME
	FROM "DOCTORS" d
	LEFT JOIN "CLINIC_DOCTOR_SCHEDULE" c_d_s ON d."ID" = c_d_s."DOCTOR_ID"
	WHERE c_d_s."CLINIC_ID" = 1
	AND c_d_s."EXPIRATION_TIME" is NULL
	ORDER BY d."ID" ASC;