SELECT
	egisso_account_objects.*,
	egisso_account_info.*,
	egisso_house_info.*
FROM
	cegisso.egisso_account_objects
	LEFT JOIN cegisso.egisso_account_info ON egisso_account_objects.account_guid = egisso_account_info.account_guid
	LEFT JOIN cegisso.egisso_house_info ON egisso_account_objects.hm_house_guid = egisso_house_info.hm_house_guid
WHERE
	egisso_account_objects.apartment_guid IN ('58a2f369-c1c6-4d30-bdd3-d4920a5e092d',
				  	 '62bcccc5-eb90-45d7-96d1-45484e9eca1f',
					 'dadeedb4-7840-4aca-9fd1-a80074630aa6',
					 'ca3a5eb2-8608-4d53-a204-23d13be6ec57',
					 '9e7a85ff-6e43-4735-9e67-d615544922e4',
					 '9e1bedf9-42b8-46d5-8c3f-d8130e2327bf',
					 'e5af891d-4d83-49a0-822c-0a517ea794e4',
					 'cd28545d-e420-420f-8958-0980beb7c263',
					 '3ce726c2-2164-4b20-994a-90f24569c0a4',
					 'c87ad495-975b-4778-a5f5-838f029b3a70');