...
| Code Block | ||
|---|---|---|
| ||
select realm_key
from sakai_realm
where locate("/site/",realm_id)!=0
and substring_index(substring_index(realm_id,'/site/',-1),'/group/',1) not in ("!admin","!error","!gateway","!site", "!urlError", "citationsAdmin", "mercury", "PortfolioAdmin","~admin")
and substring_index(substring_index(realm_id,'/site/',-1),'/group/',1) not in (select site_id
from sakai_site)
order by realm_key asc |
3.2 - Oracle
| Code Block |
|---|
select realm_key
from sakai_realm
where instr(realm_id,'/site/',1,1)!=0
and substr(substr(realm_id,instr(realm_id,'/site/')+length('/site/')),1,
instr(substr(realm_id,instr(realm_id,'/site/')+length('/site/')),'/group/',1)-1) not in ('!admin','!error','!gateway','!site', '!urlError', 'citationsAdmin', 'mercury', 'PortfolioAdmin','~admin')
and not exists ( select 'x' from sakai_site where site_id=substr(substr(realm_id,instr(realm_id,'/site/')+length('/site/')),1,
instr(substr(realm_id,instr(realm_id,'/site/')+length('/site/')),'/group/',1)-1))
order by realm_key asc |
4 - Limpieza de Message Center
...