select cl.id as 'CLIENT_ID', crd.start_card_code as 'CARD' from trm_in_clients cl INNER JOIN trm_in_card_client ccl on ccl.global_id=cl.global_id and ccl.client=cl.id INNER JOIN trm_in_cards crd on crd.global_id=ccl.global_id and crd.id=ccl.card where (cl.active=1 and cl.deleted=0 and ccl.deleted=0 and crd.active=1 and crd.deleted=0);