SELECT SecLink FROM Security WHERE SecLink=76 AND UserLink=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=77 AND UserLink=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=78 AND UserLink=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=79 AND UserLink=;OUTPUT NIL
eq 'Y') && ( ne ) && $in{Security_UserOth} ne '0E0'>
You are not authorized to see that User.
ne 'Y') || ( eq ) || $in{Security_UserOth} ne '0E0'>
 |
USER DETAILS |
eq ) || $in{Security_UserOth} ne '0E0'> |
|
| Screen Name | |
ne ''> |
| Name | |
| Location | , , |
| Email | |
| Birthday | > , |
| Affiliation | |
| First Login | > , : |
| Last Login | > , : |
| Predictions |
Points:
Predictions: / (%)
Points Per: / ()
|
| Messages Posted |
SELECT COUNT(*) MPost FROM Discussion WHERE UserLink=;OUTPUT NIL
|
| PAST LEANING PREDICTIONS |
| ? | Race | Predicted | Lean | Points |
SELECT Winner,Winner2,WinVotes,AllVotes,((WinVotes-SecondVotes)/AllVotes)*100 MarginW FROM Race WHERE RaceID=;OUTPUT NIL
SELECT SUM(Amount) PTotal FROM Leaning WHERE RaceLink= AND UserLink IN ();OUTPUT NIL
SELECT ((-FinalVoteTotal)/)*100 Margin FROM RaceMember WHERE RaceLink= AND CandidateLink=;OUTPUT NIL
SELECT SUM(Amount) Against FROM Leaning WHERE RaceLink= AND CandidateLink!= AND EndDate='0000-00-00 00:00:00' AND StartDate < AND UserLink IN ();OUTPUT NIL
ne '0'>
ne '0'>
ne '0'>
ne '0'>
ne '0'>
SELECT SUM(Amount) PTotal FROM Leaning WHERE RaceLink= AND UserLink IN ();OUTPUT NIL
>
X  |
|
|
Slight Lean Strong Safe |
> points |
eq ''>
SELECT RaceID,Title,Office,PollStart,PollEnd,CandidateID,FirstName,LastName,Amount,Winner,Winner2,AllVotes,((WinVotes-SecondVotes)/AllVotes)*100 MarginW,Color FROM Leaning,Race,Container,Candidate,Party WHERE
UserLink= AND Leaning.EndDate='0000-00-00 00:00:00' AND RaceID=RaceLink AND Race.Silly!='Y' AND MaxWinners=1 AND WinVotes > 0 AND AllVotes > 0 AND PollEnd < Now() AND Leaning.StartDate < PollStart AND ContainerID=ParentContainer AND
CandidateID=CandidateLink AND PartyID=PartyLink ORDER BY PollEnd DESC,Amount,Title LIMIT ,;OUTPUT
| Page Total | points |
|
>
|