SELECT
                                t3.ID ID_3GP,
                                t3.RECORD_NUM RECORD_NUM_3G,
                                t3.CC_NUMBER CC_NUMBER_3GP,
                                t3.FL_STATUS FL_STATUS_3GP,
                                t7.ID ID_7GP,
                                t7.RECORD_NUM RECORD_NUM_7G,
                                t7.CC_NUMBER CC_NUMBER_7GP,
                                t7.FL_STATUS FL_STATUS_7GP
                             FROM converter.SREZ_RECORD t3
                                LEFT JOIN converter.SREZ_RECORD t7 ON t3.ID = t7.ID
                             WHERE t3.SREZ_LOAD_ID = {Id}
                                AND t3.CARD_3GP IS NOT NULL
                             ORDER BY t3.ID, t7.ID