Биллинговая система Nodeny

SELECT * FROM dopvalues WHERE dopfield_id=6 and field_value=$F{port} AND parent_id IN 
(SELECT DISTINCT parent_id FROM dopvalues WHERE dopfield_id=5 AND field_value='$sw_ip')
ORDER BY revision DESC

потом брать 1ю запись

SELECT * FROM dopvalues WHERE dopfield_id=6 and field_value=$F{port} AND revision IN 
(SELECT dv.revision FROM dopvalues dv INNER JOIN rev_users r ON r.rev=dv.revision WHERE dv.dopfield_id=5 AND dv.field_value='$sw_ip' AND r.template_num=1)

INNER JOIN rev_users r ON r.rev=dv.revision WHERE dv.dopfield_id=5 AND dv.field_value='$sw_ip' AND r.template_num=1)

select parent_id
from dopvalues dv
where field_value = $F{port}
  and dopfield_id = 6  and not exists (select *  from dopvalues dvs where dvs.parent_id = dv.parent_id and dvs.dopfield_id = dv.dopfield_id and dvs.revision > dv.revision)
  and parent_id in (select parent_id
from dopvalues dv
where field_value = '$sw_ip'
  and dopfield_id = 5
  and not exists (select *  from dopvalues dvs where dvs.parent_id = dv.parent_id and dvs.dopfield_id = dv.dopfield_id and dvs.revision > dv.revision)
)

SELECT dv.* FROM dopvalues dv
INNER JOIN dopfields df
ON df.id=dv.dopfield_id
WHERE df.template_num=y AND parent_id=x