Candidates

SELECT SecLink FROM Security WHERE SecLink=23 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=24 AND UserLink=;OUTPUT NIL ne '' && $in{Security_CandidateDel} ne '0E0'>Candidate Deleted. DELETE FROM Book WHERE AttachTo='Candidate' AND AttachID=;OUTPUT NIL DELETE FROM InfoLink WHERE AttachTo='Candidate' AND AttachID=;OUTPUT NIL DELETE FROM Discussion WHERE AttachTo='Candidate' AND AttachLink=;OUTPUT NIL DELETE FROM Leaning WHERE CandidateLink=;OUTPUT NIL DELETE FROM RaceMember WHERE CandidateLink=;OUTPUT NIL DELETE FROM TagAttach WHERE ParentType='Candidate' AND ParentID=;OUTPUT NIL DELETE FROM FamilyConnect WHERE SourceLink= OR TargetLink=;OUTPUT NIL DELETE FROM Endorsement WHERE Type='Candidate' AND TypeID=;OUTPUT NIL DELETE FROM Candidate WHERE CandidateID=;OUTPUT NIL eq ''> eq 'Search'> eq 'Previous Page'> eq 'Next Page'> > SELECT count(*) NumRecords FROM Candidate as c LEFT JOIN TagAttach as t ON t.ParentID=c.CandidateID LEFT JOIN Party as p ON PartyID=PartyLink LEFT JOIN CandidateNameChange as cnc ON cnc.CandidateLink=c.CandidateID WHERE 1=1 AND c.Silly!='Y' ne ''>AND TagLink= AND ParentType='Candidate' AND p.Silly!='Y' ne ''>AND (c.FirstName LIKE OR cnc.FirstName LIKE OR MATCH(c.FirstName) AGAINST ()) ne ''>AND (c.LastName LIKE OR cnc.LastName LIKE OR MATCH(c.LastName) AGAINST ()) ne ''>AND City LIKE ne 'Any'>AND StateLink= ne 'Any'>AND Country= ne '--Any--'>AND PartyLink= ;OUTPUT NIL SELECT CandidateID,c.FirstName,c.LastName,City,BirthDate,DeathDate,StateLink,c.CountryLink,Name PName,PartyLink,Gender,Color,cnc.FirstName PFN,cnc.LastName PLN FROM Candidate as c LEFT JOIN TagAttach as t ON t.ParentID=c.CandidateID LEFT JOIN Party as p ON PartyID=PartyLink LEFT JOIN CandidateNameChange as cnc ON cnc.CandidateLink=c.CandidateID WHERE 1=1 AND c.Silly!='Y' ne ''>AND TagLink= AND ParentType='Candidate' AND p.Silly!='Y' ne ''>AND (c.FirstName LIKE OR cnc.FirstName LIKE OR MATCH(c.FirstName) AGAINST ()) ne ''>AND (c.LastName LIKE OR cnc.LastName LIKE OR MATCH(c.LastName) AGAINST ()) ne ''>AND City LIKE ne 'Any'>AND StateLink= ne 'Any'>AND Country= ne '--Any--'>AND PartyLink= ORDER BY c.LastName,c.FirstName LIMIT ,25;OUTPUT CANDIDATE LIST Last Name First Name Country Any eq > selected="selected"> SELECT DISTINCT ContainerID CTCID,c.Name CTName FROM Candidate as p JOIN Container as c ON c.ContainerID=p.CountryLink WHERE CategoryLink=76 ORDER BY CTName!='United States',CTName;OUTPUT State Any eq > selected="selected"> SELECT DISTINCT ContainerID STCID,c.Name STName,CountryLink FROM Candidate as p JOIN Container as c ON c.ContainerID=p.StateLink WHERE CategoryLink=248 ORDER BY STName;OUTPUT City Party --Any-- eq > SELECTED> SELECT DISTINCT PartyID PID,Name PName,Abbr FROM XXParty WHERE Abbr != '' ORDER BY Abbr;OUTPUT Born - Died Tag --Any-- ---- eq > SELECTED> SELECT TagID,TagName,Category TagCat FROM Tag ORDER BY Category,TagName;OUTPUT bgcolor="#33CCFF" bgcolor="#FFCCCC" bgcolor="#FFFFCC"   ()  () SELECT CAbbr FROM Container WHERE ContainerID=;OUTPUT NIL SELECT CAbbr FROM Container WHERE ContainerID=;OUTPUT NIL ,Safe> , Unknown - ,Safe> ,   - of