Support:Database Cleanup: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann |
imported>Kymara |
||
Line 20:
) AND status='active';
</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 ==
| |||