Support:Database Cleanup: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Hendrik Brummermann |
imported>Kymara |
||
| Line 20: | Line 20: | ||
) AND status='active'; |
) AND status='active'; |
||
</source> |
</source> |
||
Consider: |
|||
<source lang="sql"> |
|||
SELECT account.* FROM account LEFT JOIN characters |
|||
ON player_id=account.id |
|||
where STATUS='active' and player_id is null; |
|||
</source> |
|||
== Metrics for discontinuted accounts == |
== Metrics for discontinuted accounts == |
||