SQL запросы

Выданные публичные адреса

SELECT login, INET_NTOA(BIN2IPV4(segment)), name,vgadr.address, tar.descr, tar.rent, tar.shape select vg.login, INET_NTOA(BIN2IPV4(segment)),vgadr.address, name, tar.descr, round(tar.rent), tar.shape
FROM staff stf, vgroups vg, vgroups_addr vgadr, billing.agreements agr, billing.accounts acc, tarifs tar
WHERE
(stf.vg_id=vg.vg_id)
and (vg.vg_id=vgadr.vg_id)
and (BIN2IPV4(segment)<1680000000)
and (vg.agrm_id = agr.agrm_id)
and (agr.uid=acc.uid)
and (vg.tar_id=tar.tar_id)
ORDER BY BIN2IPV4(segment);