Ronda lekérdezés

SELECT
    senderinformation.senderfunction AS senderfunction ,
    receiver.functionname AS receiverfunction ,
    COUNT(*) AS dataflowcount
FROM
    (
        SELECT
            sender.functionname AS senderfunction ,
            comm.writecycles AS sendcycle ,
            comm.channel AS commaddress ,
            comm.readcycles AS receivecycle
        FROM
            communication comm LEFT OUTER JOIN controlflow sender
                ON(
                comm.writecycles BETWEEN sender.startcyclecount AND sender.endcyclecount
            )
        WHERE
            TYPE = 1
            OR(
                TYPE = 0
                AND channel IN(
                    0 ,
                    1 ,
                    2 ,
                    3 ,
                    4 ,
                    5 ,
                    6 ,
                    7 ,
                    8 ,
                    9 ,
                    10 ,
                    11 ,
                    12 ,
                    13 ,
                    14 ,
                    15 ,
                    16 ,
                    17
                )
            )
    ) AS senderinformation LEFT OUTER JOIN controlflow receiver
        ON(
        senderinformation.receivecycle BETWEEN receiver.startcyclecount AND receiver.endcyclecount
    )
WHERE
    senderinformation.senderfunction != receiver.functionname
GROUP BY
    senderinformation.senderfunction ,
    receiver.functionname
;