NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
ORDER BY
"public".victim.victim_localid ASC
</pre>
=== Victim Assistance===__NOEDITSECTION__
<pre>
SELECT
victim_assistance.guid,
victim_assistance.location_guid,
victim_assistance.localid
from victim_assistance
where not exists (
select 1
from victim_assistance_version
where victim_assistance.guid = victim_assistance_version.victim_assistance_guid
and exists (
select 1
from link
where approval_state = 'NEW'
and link.from_guid = victim_assistance_version.guid
)
)
ORDER BY victim_assistance.localid
</pre>
=== Education ===__NOEDITSECTION__
