SELECT CARD_CARDS.CARD_CODE AS [Код карты]
,CARD_ACCOUNT_LEVELS.NAME AS [Уровень бонуса]
,CARD_PEOPLE_ACCOUNTS.BALANCE AS Баланс
,CARD_PEOPLES.FULL_NAME AS ФИО
,CARD_CONTACTS.CONTACT_VALUE AS Телефон
,CARD_PEOPLES.BIRTHDAY AS [День рождения]
FROM dbo.CARD_PEOPLES
INNER JOIN dbo.CARD_CONTACTS
ON CARD_PEOPLES.PEOPLE_ID = CARD_CONTACTS.PEOPLE_ID
INNER JOIN dbo.CARD_PEOPLE_ACCOUNTS
ON CARD_PEOPLES.PEOPLE_ID = CARD_PEOPLE_ACCOUNTS.PEOPLE_ID
INNER JOIN dbo.CARD_CARDS
ON CARD_PEOPLES.PEOPLE_ID = CARD_CARDS.PEOPLE_ID
INNER JOIN dbo.CARD_ACCOUNT_TYPES
ON CARD_PEOPLE_ACCOUNTS.ACCOUNT_TYPE_ID = CARD_ACCOUNT_TYPES.ACCOUNT_TYPE_ID
INNER JOIN dbo.CARD_ACCOUNT_LEVELS
ON CARD_PEOPLE_ACCOUNTS.ACCOUNT_LEVEL_ID = CARD_ACCOUNT_LEVELS.ACCOUNT_LEVEL_ID
WHERE CARD_CARDS.STATUS = 1
AND CARD_ACCOUNT_TYPES.ACCOUNT_CLASS = 1
AND CARD_ACCOUNT_LEVELS.ACCOUNT_LEVEL_ID NOT IN (35)
AND CARD_CONTACTS.CONTACT_TYPE = 253
AND CARD_PEOPLE_ACCOUNTS.BLOCKED = 0
GROUP BY CARD_PEOPLES.PEOPLE_ID
,CARD_PEOPLES.BIRTHDAY
,CARD_CARDS.CARD_CODE
,CARD_ACCOUNT_LEVELS.NAME
,CARD_PEOPLE_ACCOUNTS.BALANCE
,CARD_PEOPLES.FULL_NAME
,CARD_CONTACTS.CONTACT_VALUE
,CARD_CONTACTS.CONTACT_VALUE
ORDER BY [Код карты], [Уровень бонуса], Баланс, ФИО, Телефон, [День рождения]