Support:Database Cleanup: Difference between revisions

Jump to navigation Jump to search
Content deleted Content added
imported>Kymara
imported>Kymara
Line 31: Line 31:
SELECT account.* FROM account LEFT JOIN characters
SELECT account.* FROM account LEFT JOIN characters
ON player_id=account.id
ON player_id=account.id
where STATUS='active' and player_id is null;
where account.STATUS='active' and player_id is null;
</source>
</source>