Topic: Request about search of unique visitings
Greetings! I try to construct request which returns kol-in unique owners of accounts.
Uniqueness condition this absence of other user with intersection across the field in session (at me it fingerprint, but it is possible to think of it as IP). I.e. for example I registered 2 users from the computer me it is necessary to count as 1 unique owner of an account (in computer games it is called to eliminate tvinkov/multov)
Here a reference on the data scheme in SQLFiddle .