How to create a mySQL query?

Question

MySQL

There are call statistics on the telephony server, you need to bring it into a readable form.
Here is an example of statistics, there are 6 calls and 14 events that made these calls.
One call merges the linkedID field.
That is, subscriber A calls subscriber B. Subscriber B calls an internal number and the call is forwarded to another SIP (dstchannel like 'SIP/vs-kv-ak03%'), or to a mobile (dstchannel like 'Local/mobile number%' ).
Ideally, I would like to get a separate table from this table without extra data.

What is


What I want to get at the output - highlighted in blue.

Answer 1

What didn't suit LIKE? In general, the logic of highlighting the marked lines is not very clear. Especially in the context of "joins the linkedID field". On the second screen they are all different.