{speeds = SELECT n.id, INET_NTOA(n.ipaddr) as ip,
                           s.assignmentid as node_assignment,
                           a.id as customer_assignment,
                           IFNULL(t.downceil, 0) as downceil, IFNULL(t.upceil, 0) as upceil,
                           IFNULL(t.downrate, 0) as downrate, IFNULL(t.uprate, 0) as uprate
FROM nodes n
LEFT JOIN customers c on c.id = n.ownerid /* jeśli nie potrzebujemy urządzeń, to można zrobić zwykłego join'a */
LEFT JOIN nodeassignments s on n.id=s.nodeid
LEFT JOIN assignments a ON ((a.id = s.assignmentid or a.customerid = c.id)
                                           AND a.datefrom <= unix_timestamp()
                                           AND (a.dateto > unix_timestamp() or a.dateto = 0))
LEFT JOIN tariffs t ON a.tariffid = t.id
WHERE n.access = 1 /* IP ma dostęp */
AND (c.id is NULL OR c.deleted = 0) /* klient nie skasowany, jeśli mamy joina z customers można usunąć c.id is NULL */
AND (s.assignmentid IS NULL OR s.assignmentid = a.id OR a.id IS NULL)
AND (a.id is NULL OR not (t.downceil <= 0 AND t.upceil <= 0 AND t.downrate <= 0 AND t.uprate <= 0))
ORDER BY n.ipaddr, a.id;

without_assignment=""
duplicates=""
last=null
last_a=null
for (i=0; i<number(speeds);i++)
    if(speeds[i].downceil == 0 && speeds[i].upceil == 0)
        without_assignment = without_assignment + speeds[i].ip + "\n"
        continue
    /if
    if (last==speeds[i].ip && (last_a==null || last!=last_a))
        duplicates = duplicates + last + "\n"
        last_a=last
    /if
    speeds[i].ip" "speeds[i].downceil" "speeds[i].upceil"\n"

    last = speeds[i].ip
/for
"\n"}#ip without assignments:{"\n"
without_assignment
"\n"}#ip with more than one assignments:{"\n"
duplicates
}\