SELECT * FROM Container WHERE ContainerID=;OUTPUT NIL SELECT CategoryName FROM ContainerCategory WHERE ContainerCategoryID=;OUTPUT NIL ne '0' && $in{'DidCID'.$in{CID}} ne 'Y'>='Y'>=$in{PName}>=$in{PCAbbr}>SELECT ContainerID CID,ParentLink PLk,Name PName FROM Container WHERE ContainerID=;OUTPUT CStream SELECT ContainerID CID,ParentLink PLk,Name PName,CAbbr PCAbbr FROM Container WHERE ContainerID=;OUTPUT CStream UPDATE Container SET TreeIDs=',,,' WHERE ContainerID=;FINISH Our Campaigns - <VAR TitleStream,Safe> DELETE FROM UserNewItems WHERE UserLink= AND ItemType='Container' AND ItemLink=;FINISH INSERT INTO UserNewItems (UserLink,ItemType,ItemLink,ReadDate) VALUES (,'Container',,Now());FINISH SELECT Nym FROM User WHERE UserID=;OUTPUT NIL SELECT Nym CNym FROM User WHERE UserID=;OUTPUT NIL
  
SELECT SecLink FROM Security WHERE SecLink=47 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=48 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=49 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=54 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=32 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=60 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=73 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=56 AND UserLink=;OUTPUT NIL
Party Registration Delete Not Yet Ready.
 ne '' && $in{Security_ContainDel} ne '0E0'>Container Deleted.
DELETE FROM Book WHERE AttachTo='Container' AND AttachID=;OUTPUT NIL DELETE FROM InfoLink WHERE AttachTo='Container' AND AttachID=;OUTPUT NIL DELETE FROM Discussion WHERE AttachTo='Container' AND AttachLink=;OUTPUT NIL DELETE FROM PartyReg WHERE ParentContainer=;OUTPUT NIL DELETE FROM Book WHERE AttachTo='Race' AND AttachID=;OUTPUT NIL DELETE FROM InfoLink WHERE AttachTo='Race' AND AttachID=;OUTPUT NIL DELETE FROM Discussion WHERE AttachTo='Race' AND AttachLink=;OUTPUT NIL DELETE FROM Leaning WHERE RaceLink=;OUTPUT NIL DELETE FROM RaceMember WHERE RaceLink=;OUTPUT NIL DELETE FROM Race WHERE RaceID=;OUTPUT NIL SELECT RaceID DelRace FROM Race WHERE ParentContainer=;OUTPUT DelRaceTem UPDATE Container SET ParentLink= WHERE ParentLink=;OUTPUT NIL DELETE FROM Container WHERE ContainerID=;OUTPUT NIL ne '' && $in{Security_RaceDel}>Race Deleted.
DELETE FROM Book WHERE AttachTo='Race' AND AttachID=;OUTPUT NIL DELETE FROM InfoLink WHERE AttachTo='Race' AND AttachID=;OUTPUT NIL DELETE FROM Discussion WHERE AttachTo='Race' AND AttachLink=;OUTPUT NIL DELETE FROM Leaning WHERE RaceLink=;OUTPUT NIL DELETE FROM RaceMember WHERE RaceLink=;OUTPUT NIL DELETE FROM Race WHERE RaceID=;OUTPUT NIL SELECT * FROM Cart WHERE UserLink= AND ItemType='Container' AND ItemID=;OUTPUT NIL UPDATE Cart SET Pickup=,Follow=,AmIn=,Email= WHERE UserLink= AND ItemType='Container' AND ItemID=;FINISH INSERT INTO Cart (Pickup,Follow,AmIn,Email,UserLink,ItemType,ItemID) VALUES (,,,,,'Container',);FINISH SELECT * FROM Cart WHERE UserLink= AND ItemType='Container' AND ItemID=;OUTPUT NIL UPDATE Cart SET Pickup='Y' WHERE UserLink= AND ItemType='Container' AND ItemID=;FINISH INSERT INTO Cart (UserLink,ItemType,ItemID,Pickup) VALUES (,'Container',,'Y');FINISH SELECT ContainerID PUCID FROM Container WHERE ParentLink= AND StartDate < AND (EndDate >= OR EndDate='0000-00-00 00:00:00');OUTPUT DELETE FROM Cart WHERE UserLink= AND ItemType='Container' AND ItemID=;FINISH UPDATE Cart SET Pickup='' WHERE UserLink= AND ItemType='Container' AND ItemID=;FINISH UPDATE Container SET ParentLink= WHERE ContainerID=;FINISH SELECT * FROM Cart WHERE UserLink= AND ItemType='Container' AND Pickup='Y';OUTPUT DELETE FROM ContainerAttach WHERE ContainerAttachID=;FINISH=''> SELECT ContainerAttachID,ParentLink PUCID FROM ContainerAttach WHERE ChildLink=;OUTPUT SELECT ContainerAttachID,ChildLink PUCID FROM ContainerAttach WHERE ParentLink=;OUTPUT DELETE FROM Cart WHERE UserLink= AND ItemType='Container' AND ItemID=;FINISH UPDATE Cart SET Pickup='' WHERE UserLink= AND ItemType='Container' AND ItemID=;FINISH INSERT INTO ContainerAttach (ParentLink,ChildLink,FirstBy,FirstEnter) VALUES (,,,Now());FINISH SELECT * FROM Cart WHERE UserLink= AND ItemType='Container' AND Pickup='Y';OUTPUT DELETE FROM Cart WHERE UserLink= AND ItemType='Container' AND ItemID=;FINISH UPDATE Cart SET Pickup='' WHERE UserLink= AND ItemType='Container' AND ItemID=;FINISH INSERT INTO RiskLinks (ContainerA,ContainerB,Type) VALUES (,,'L');FINISH SELECT * FROM Cart WHERE UserLink= AND ItemType='Container' AND Pickup='Y';OUTPUT SELECT RaceID,MaxWinners,Color,Name,CandidateID,FirstName,LastName,Photo,PollEnd,TakeOffice,TermEnd,WinVotes,SecondVotes,AllVotes FROM Race,Candidate,RaceMember,Party WHERE ParentContainer= AND ((Type!='Primary Election' AND Type!='Primary Runoff' AND Type!='Run-Off') OR TakesSeat='Y') AND TakeOffice <= AND (TermEnd > OR TermEnd='0000-00-00 00:00:00') AND CandidateID=Winner AND RaceLink=RaceID AND CandidateLink=Winner AND PartyID=RaceMember.PartyLink ORDER BY PollEnd DESC LIMIT 1;OUTPUT NIL ne '0E0'> SELECT FirstName,LastName FROM CandidateNameChange WHERE CandidateLink= AND StartDate <= AND EndDate > LIMIT 1;OUTPUT NIL SELECT PicDate FROM CandidatePic WHERE CandidateLink= ORDER BY ABS(TO_DAYS()-TO_DAYS(PicDate)) LIMIT 1;OUTPUT NIL SELECT FinalVoteTotal WinVotes,PartyID,Color,Name,CandidateID,FirstName,LastName,Photo FROM RaceMember,Candidate,Party WHERE RaceLink= AND CandidateID=CandidateLink AND PartyID=RaceMember.PartyLink ORDER BY Won DESC,FinalVoteTotal DESC LIMIT ;OUTPUT EachIncumbent
INCUMBENTS
  ne ''> Party
Name
Won//
Votes (%)
Margin (%)
Term// - //
$catcolor{'V'}='#ddd'; $catparty{'V'}='Vacant'; $catseats{'V'}+=1; $catvotes{'V'}=0; eq ''> SELECT COUNT(*) Terms FROM Race WHERE Winner= AND ParentContainer=2094 AND ParentRace=0 AND TakeOffice < AND OfficeLink= AND (Type='General Election' OR Type='Running Mate');OUTPUT NIL SELECT RaceID LastWinRaceID,PartyLink LastWinParty FROM Race,RaceMember WHERE ParentContainer= AND Type!='Primary Election' AND ParentRace=0 AND TakeOffice < AND RaceLink=RaceID AND CandidateLink=Winner ORDER BY TakeOffice DESC LIMIT 1,1;OUTPUT NIL SELECT ((WinVotes-SecondVotes)/AllVotes)*100 LRPct FROM Race WHERE RaceID=;OUTPUT NIL ne '0E0'> $catcolor{$in{LPartyID}}=$in{LColor}; $catparty{$in{LPartyID}}=$in{LPartyName}; $catseats{$in{LPartyID}}+=1; $catvotes{$in{LPartyID}}+=$in{CFinalVoteTotal};=$in{LColor}>=$in{LCColor}>=($in{CMPcnt}/100)**.35> eq ''> =$in{LCColor}>=$in{LFirstName}>=$in{LLastName}>=$in{LLat}>=$in{LLon}> SELECT PicDate FROM CandidatePic WHERE CandidateLink= ORDER BY ABS(TO_DAYS()-TO_DAYS(PicDate)) LIMIT 1;OUTPUT NIL undef $catvotes; undef $catseats; SELECT RaceID,Office,OfficeLink,Type,WinVotes,AllVotes,MaxWinners,PollStart,ParentRace,OfficialCert,((CAST(WinVotes as signed)-CAST(SecondVotes as signed))/AllVotes)*100 MPcnt FROM Race WHERE ParentContainer= AND (TakesSeat='Y' OR (Type!='Primary Election' AND Type!='Primary Runoff')) AND TakeOffice <= AND TermEnd > ORDER BY PollEnd DESC LIMIT 1;OUTPUT NIL =$in{CMapImageID}>='Y'> SELECT RaceID,Type,Winner,PollStart,FirstName,LastName,PartyID,Color,((WinVotes-SecondVotes)/AllVotes)*100 MPcnt FROM Race as r,Candidate as c,RaceMember as m,Party as p WHERE ParentContainer= AND Type!='Primary Election' AND Type!='Primary Runoff' AND Type!='Caucus' AND PollEnd < AND TakeOffice >= AND TermEnd > AND Winner > 0 AND TakesSeat='Y' AND CandidateID=Winner AND m.RaceLink=RaceID AND m.CandidateLink=CandidateID AND PartyID=m.PartyLink ORDER BY PollEnd LIMIT 1;OUTPUT NIL > SELECT DNumber FROM DemographicNum WHERE AttachID= AND AttachTo='Container' AND DemographicLink=1 AND StartDate < AND (EndDate >= OR EndDate='0000-00-00 00:00:00') ORDER BY StartDate DESC LIMIT 1;OUTPUT NIL SELECT FinalVoteTotal,Won,Incumbent,p.PartyID,p.Name PartyName,p.Color,cp.Color CColor,CandidateID,FirstName,LastName,Photo,c.Latitude,c.Longitude FROM RaceMember as rm,Candidate as c,Party as p,Party as cp WHERE RaceLink= AND Won='Y' AND CandidateID=CandidateLink AND p.PartyID=rm.PartyLink AND cp.PartyID=c.PartyLink ORDER BY FinalVoteTotal DESC LIMIT ;OUTPUT MultiWin SELECT FinalVoteTotal,Won,Incumbent,p.PartyID,p.Name PartyName,p.Color,cp.Color CColor,CandidateID,FirstName,LastName,Photo,c.Latitude,c.Longitude FROM RaceMember as rm,Candidate as c,Party as p,Party as cp WHERE RaceLink= AND Won='' AND FinalVoteTotal > 0 AND CandidateID=CandidateLink AND p.PartyID=rm.PartyLink AND cp.PartyID=c.PartyLink ORDER BY FinalVoteTotal DESC LIMIT ,;OUTPUT MultiWin SELECT ChildLink AS AID FROM ContainerAttach WHERE ParentLink=;OUTPUT AttContainerIds SELECT DISTINCT ContainerID,Name,c.StartDate,c.LastModify,c.Silly,CategoryName,MapImageID,ma.MapImageLink,ParentLink FROM Container as c JOIN ContainerCategory as cc ON ContainerCategoryID=CategoryLink LEFT JOIN MapLocation as cm ON cm.ContainerLink=ContainerID AND cm.StartDate < AND (cm.EndDate >= OR cm.EndDate='0000-00-00 00:00:00') AND cm.MapImageLink NOT IN (101,102,167,159,559,16032) AND LLPolyCoords!='' LEFT JOIN MapLocationAttach as ma ON ma.MapLocationLink=cm.MapLocationID LEFT JOIN MapImage as mm ON MapImageID=ma.MapImageLink AND mm.MapStartDate < AND (mm.MapEndDate >= OR mm.MapEndDate='0000-00-00 00:00:00') WHERE (ParentLink= OR ContainerID IN ()) AND (c.StartDate < OR DATE_SUB(c.StartDate, INTERVAL 2 YEAR) < ) AND (c.EndDate >= OR c.EndDate='0000-00-00 00:00:00') ORDER BY cc.Priority DESC,CategoryName='State Government' DESC,CategoryName='President' DESC,CategoryName='Senate' DESC,CategoryName='House of Representatives' DESC,CategoryName='Institutions' DESC,CategoryName='State' DESC,CategoryName='Territory/ Commonwealth' DESC,CategoryName='Domestic Dependent Nations' DESC,CategoryName='Unincorporated' ASC,CategoryName='Census Designated Place',CategoryName,c.Priority DESC,Name,mm.CategoryLink!=168,mm.MapName NOT LIKE ,MapImageID DESC;OUTPUT SELECT ContainerID,Name,LastModify,CategoryName,cc.Priority CatPri,c.Priority CPri FROM ContainerAttach as a,Container as c,ContainerCategory as cc WHERE a.ChildLink= AND ContainerID=a.ParentLink AND StartDate < AND (EndDate >= OR EndDate='0000-00-00 00:00:00') AND ContainerCategoryID=CategoryLink ORDER BY CatPri DESC,CategoryName='State Government' DESC,CategoryName='President' DESC,CategoryName='Senate' DESC,CategoryName='House of Representatives' DESC,CategoryName='Institutions' DESC,CategoryName='State' DESC,CategoryName='Territory/ Commonwealth' DESC,CategoryName='Domestic Dependent Nations' DESC,CategoryName='Unincorporated' DESC,CategoryName,CPri DESC,Name; FINISH OUTPUT SELECT ContainerID DCID,Name DCName FROM Cart,Container WHERE UserLink= AND ItemType='Container' AND Pickup='Y' AND ContainerID=ItemID ORDER BY DCName; FINISH OUTPUT
       
colspan="2">    SELECT PicDate FROM CandidatePic WHERE CandidateLink= ORDER BY ABS(TO_DAYS()-TO_DAYS(PicDate)) LIMIT 1;OUTPUT NIL
elect  
S A style="color:#333333;">
Leading 		%
Dem Seats:
   * SELECT ContainerIconName,ContainerIconImage FROM ContainerIconAttach AS cia JOIN ContainerIcon as ci ON ci.ContainerIconID=cia.ContainerIconLink WHERE cia.ContainerLink= AND cia.StartDate < AND (cia.EndDate >= OR cia.EndDate='0000-00-00 00:00:00') AND ci.PrimaryOnly=0;OUTPUT CIcons >Active > ,    
   *
elect  
Summation
$totalseats=0; $totalvotes=0; foreach $key (keys %catseats) { $totalseats+=$catseats{$key}; $totalvotes+=$catvotes{$key}; } foreach $key (sort {$catseats{$b} <=> $catseats{$a}} (keys %catseats)) { print ''; }
 PartySeatsVotesSeat %Vote %
 '.$catparty{$key}.''.$catseats{$key}.''.$catvotes{$key}.''.int(($catseats{$key}/$totalseats)*100).'%'.int(($catvotes{$key}/$totalvotes)*100).'%
Attached Containers
Picked Up Containers
 

Add New Subcategory To

SELECT DISTINCT ContainerID,Name,CategoryName FROM RaceSub as s,Race as r,Container as c,ContainerCategory as cc WHERE s.SubLink= AND RaceID=s.RaceLink AND ContainerID=r.ParentContainer AND r.TakeOffice > DATE_SUB(,INTERVAL 20 YEAR) AND r.Silly!='Y' AND ContainerCategoryID=c.CategoryLink AND c.StartDate < AND (c.EndDate >= OR c.EndDate='0000-00-00 00:00:00') ORDER BY cc.Priority DESC,CategoryName='State Government' DESC,CategoryName='President' DESC,CategoryName='Senate' DESC,CategoryName='House of Representatives' DESC,CategoryName='Institutions' DESC,CategoryName='State' DESC,CategoryName='Territory/ Commonwealth' DESC,CategoryName='Domestic Dependent Nations' DESC,CategoryName='Unincorporated' DESC,CategoryName,c.Priority DESC,Name; FINISH SELECT DISTINCT RaceID,Office,OfficeLink,Type,Winner,WinVotes,AllVotes,MaxWinners,PollStart,ParentRace,OfficialCert,((WinVotes-SecondVotes)/AllVotes)*100 MPcnt FROM RaceSub as s,Race as r WHERE s.SubLink= AND RaceID=s.RaceLink AND r.ParentContainer= AND Type!='Primary Election' AND Type!='Primary Runoff' AND TakeOffice <= AND TermEnd > ORDER BY PollEnd DESC LIMIT 1;OUTPUT NIL SELECT SUM(s.FinalVoteTotal) TotalSubVotes FROM RaceSub as s WHERE s.SubLink= AND s.RaceLink=;OUTPUT NIL SELECT CandidateID,FirstName,LastName,PartyID,Color,s.FinalVoteTotal FROM RaceSub as s,RaceMember as m,Candidate as c,Party as p WHERE s.SubLink= AND s.RaceLink= AND m.RaceLink=s.RaceLink AND m.CandidateLink=s.CandidateLink AND CandidateID=s.CandidateLink AND PartyID=m.PartyLink ORDER BY s.FinalVoteTotal DESC,m.FinalVoteTotal DESC LIMIT 1;OUTPUT NIL SELECT FinalVoteTotal ParentRVotes FROM RaceMember WHERE RaceLink= AND CandidateLink=;OUTPUT NIL OUTPUT
Sub-Races
% Of Total VotesOffice WinnerYr Votes% of Sub% Vs. Full Race
%   % %

(SELECT ContainerID CID,Name CName,c.ParentLink PLink,CategoryLink CTL,l.Type CType,RiskLinksID,HasPort FROM RiskLinks as l,Container as c where ContainerA= and ContainerID=ContainerB) UNION (SELECT ContainerID CID,Name CName,c.ParentLink PLink,CategoryLink CTL,l.Type CType,RiskLinksID,HasPort FROM RiskLinks as l,Container as c where ContainerB= and ContainerID=ContainerA) ORDER BY CTL=338,CName; FINISH > SELECT Name PName FROM Container WHERE ContainerID=;OUTPUT NIL OUTPUT
Neighbors
Oceans / Seas / Gulfs
,  

DELETE FROM ContainerFrom WHERE ContainerFromID=;FINISH INSERT INTO ContainerFrom (ParentLink,ChildLink,FirstBy,FirstEnter) VALUES (,,,Now());FINISH DELETE FROM Cart WHERE UserLink= AND ItemType='Container' AND ItemID= AND Pickup='Y';FINISH SELECT ContainerID FromID,c.Name FromName FROM Cart as t,Container as c WHERE t.UserLink= AND t.ItemType='Container' AND t.Pickup='Y' and ContainerID=ItemID order by c.Name;OUTPUT INSERT INTO ContainerFrom (ParentLink,ChildLink,FirstBy,FirstEnter) VALUES (,,,Now());FINISH DELETE FROM Cart WHERE UserLink= AND ItemType='Container' AND ItemID= AND Pickup='Y';FINISH SELECT ContainerID ToID,c.Name ToName FROM Cart as t,Container as c WHERE t.UserLink= AND t.ItemType='Container' AND t.Pickup='Y' and ContainerID=ItemID order by c.Name;OUTPUT SELECT ContainerID FromID,c.Name FromName,c.EndDate CFDate,f.*,CategoryName CCName FROM ContainerFrom as f JOIN Container as c ON f.ChildLink= AND ContainerID=f.ParentLink JOIN ContainerCategory as cc ON cc.ContainerCategoryID=c.CategoryLink ORDER BY ChildPercent DESC,c.Name; FINISH
>OUTPUT SELECT ContainerID FromID,c.Name FromName,CategoryName FROM Cart as t JOIN Container as c ON t.UserLink= AND t.ItemType='Container' AND t.Pickup='Y' and ContainerID=ItemID JOIN ContainerCategory as cc ON cc.ContainerCategoryID=c.CategoryLink ORDER BY c.Name; FINISH
Created From
[X] > ,
>OUTPUT
Created From
Add Created From
 SELECT ContainerID ToID,c.Name ToName,c.StartDate MTDate,f.*,CategoryName CCName FROM ContainerFrom as f JOIN Container as c ON f.ParentLink= AND ContainerID=f.ChildLink JOIN ContainerCategory as cc ON cc.ContainerCategoryID=c.CategoryLink ORDER BY ParentPercent DESC,c.Name; FINISH
>OUTPUT SELECT ContainerID ToID,c.Name ToName FROM Cart as t,Container as c WHERE t.UserLink= AND t.ItemType='Container' AND t.Pickup='Y' and ContainerID=ItemID order by c.Name; FINISH
Split/Merged/Changed To
[X] > ,
>OUTPUT
Split/Merged/Changed To
Add Split/Merged/Changed To
 SELECT c.ContainerID as dcid,c.Name FROM RaceSub JOIN Container as c ON RaceLink= AND ContainerID=SubLink AND c.CategoryLink=77 ORDER BY c.Name;OUTPUT >SELECT SUM(DNumber) as DMApop FROM ContainerAttach as a JOIN DemographicNum as d ON d.AttachTo='Container' AND ((a.ParentLink= AND d.AttachID=a.ChildLink) OR (a.ChildLink= AND d.AttachID=a.ParentLink)) AND d.DemographicLink=1 AND d.StartDate < Now() AND d.EndDate='0000-00-00';OUTPUT NILSELECT SUM(DNumber) as RacePop FROM ContainerAttach as a JOIN DemographicNum as d ON d.AttachTo='Container' AND ((a.ParentLink= AND a.ChildLink IN (0) AND d.AttachID=a.ChildLink) OR (a.ChildLink= AND a.ParentLink IN (0) AND d.AttachID=a.ParentLink)) AND d.DemographicLink=1 AND d.EndDate='0000-00-00';OUTPUT NILSELECT DISTINCT c.ContainerID as dcid,c.Name FROM ContainerAttach as a JOIN Container as c ON ((a.ChildLink IN (0) AND ContainerID=a.ParentLink) OR (a.ParentLink IN (0) AND ContainerID=a.ChildLink)) AND c.CategoryLink=153 ORDER BY c.Name;OUTPUT
DMA Analysis (County-Level)
DMADMA PopulationDistrict PopulationWasted %
%
SELECT RaceID TopPresRace FROM Race WHERE ParentContainer=2382 AND Type!='Primary Election' AND Type!='Primary Runoff' AND TakeOffice <= AND TermEnd > ;OUTPUT NIL =$in{'TopPres'.$in{PartyLink}}+$in{FinalVoteTotal}>=$in{PartyLink}> SELECT PartyLink,FinalVoteTotal FROM RaceMember WHERE RaceLink= ORDER BY FinalVoteTotal DESC;OUTPUT =$in{'LocPres'.$in{PartyLink}}+$in{FinalVoteTotal}> SELECT PartyLink,FinalVoteTotal FROM RaceMember WHERE RaceLink=OUTPUT SELECT Abbr PVIAbbr FROM Party WHERE PartyID=;OUTPUT NIL SELECT Abbr PVIAbbr FROM Party WHERE PartyID=;OUTPUT NIL
[X] DETAILS
Parents > ,Safe> ne ''> 
Website [Link]
Alternate Names
Established > ,
Disbanded == 0>Still Active !=0>> ,
Contributor
Last Modified > , :
Description ne 'Y'>,plaintext>
SELECT * FROM DatedText WHERE AttachTo='Container' AND AttachID= AND StartDate <= AND (EndDate > OR EndDate='0000-00-00') ORDER BY StartDate,EndDate;OUTPUT DatedOutput
PVI+ ( SELECT PartyID TPID,Abbr TAbbr FROM Party WHERE PartyID IN () ORDER BY Priority DESC,Abbr;OUTPUT)
Cart
SELECT * FROM Cart WHERE UserLink= AND ItemType='Container' AND ItemID=;OUTPUT NIL checked="checked">Pickup checked="checked">Follow checked="checked">Am In checked="checked">Email
SELECT MapImageID,MapName,MapLocationID,StartDate MLStart,EndDate MLEnd,FillCoords MCFill,PolyCoords MCPoly,LLPolyCoords MCLLPoly,Width MIWidth,Height MIHeight,ST_Distance_Sphere(point(LngMin, LatMin), point(LngMin, LatMax))/ST_Distance_Sphere(point(LngMin, LatMin), point(LngMax, LatMin)) MRatio FROM MapLocation as l JOIN MapLocationAttach as a ON ContainerLink= AND StartDate<= AND (EndDate>= OR EndDate='0000-00-00') AND a.MapLocationLink=l.MapLocationID JOIN MapImage as i ON i.MapImageID=a.MapImageLink AND MapStartDate <= AND (MapEndDate >= OR MapEndDate='0000-00-00') WHERE LLPolyCoords!='' ORDER BY MapName NOT LIKE ;OUTPUT NIL $in{cmplc}="["; $in{MCLLPoly}=~s/\r\n/\n/g; $in{MCLLPoly}=~s/\r/\n/g; $np=0; $npc=0; $bgc=0; $npg=1; $in{cmnlo}=99999; $in{cmnlt}=99999; $in{cmxlo}=-99999; $in{cmxlt}=-99999; $llon=9999999; $llat=9999999; $tptmp=''; foreach $pyl (split "\n",$in{MCLLPoly}) { if (length($pyl) > 10) { ($lon,$lat)=split(" ",$pyl); $lon=$lon+0; $lat=$lat+0; if ($bgc==0) { $in{cmplc}.="[["; $bgc=1; } else { if ($np > 0) { $in{cmplc}.=","; } $in{cmplc}.= '['.$lon.','.$lat.']'; if ($in{cmnlo} > $lon) { $in{cmnlo}=$lon; } if ($in{cmxlo} < $lon) { $in{cmxlo}=$lon; } if ($in{cmnlt} > $lat) { $in{cmnlt}=$lat; } if ($in{cmxlt} < $lat) { $in{cmxlt}=$lat; } $np++; } } elsif ($bgc != 0) { if ($bgc == 1) { $in{cmplc}.="]],"; $npc++; } $bgc=0; $np=0; } } $in{cmplc}.="]]]";
MAPS
SELECT MapName,MapStartDate,MapEndDate,DATE_FORMAT(MapStartDate,'%b %e, %Y') FStartDate,DATE_FORMAT(MapEndDate,'%b %e, %Y') FEndDate,MapDescription,LLBoundary,TileSetURL,Height CvsHeight FROM MapImage WHERE MapImageID=,F%d> ORDER BY Category!='Municipalities',Category;OUTPUT NIL
-
SELECT * FROM MapInset WHERE MapImageLink=,F%d> order by Priority;OUTPUT InsetButton
Data:
Curve
Embed Code Data
SELECT a.ContainerID CountyID,a.Name CountyName,b.ContainerID CityID,b.Name CityName,c.DNumber,c.StartDate PopDate FROM Container as b JOIN DemographicNum as c ON c.AttachTo='Container' AND c.AttachID=b.ContainerID LEFT JOIN Container as a ON (a.CategoryLink=77 OR a.CategoryLink=478) AND a.ContainerID=b.ParentLink WHERE b.TreeIDs LIKE '%,,%' AND b.CategoryLink IN (40,306,288,284,24,168,478) AND c.DemographicLink=1 AND c.StartDate <= AND (c.EndDate > OR c.EndDate='0000-00-00') ORDER BY c.DNumber DESC LIMIT ; FINISH >OUTPUT EachBigCity
Largest Population Cities  
# City County Population As Of
SELECT ContainerIconName,ContainerIconImage FROM ContainerIconAttach AS cia JOIN ContainerIcon as ci ON ci.ContainerIconID=cia.ContainerIconLink WHERE cia.ContainerLink= AND cia.StartDate < AND (cia.EndDate >= OR cia.EndDate='0000-00-00 00:00:00');OUTPUT CIcons
[More]
 SELECT a.ContainerID CountyID,a.Name as CountyName,s.ContainerID as StateID,s.CAbbr as StateName,c.DNumber,c.StartDate PopDate FROM Container as s,Container as a,DemographicNum as c WHERE s.TreeIDs LIKE '%,,%' AND s.CategoryLink=248 AND a.TreeIDs LIKE CONCAT('%,',s.ContainerID,',%') AND (a.CategoryLink=77 OR a.CategoryLink=478) AND c.AttachTo='Container' AND c.AttachID=a.ContainerID AND c.DemographicLink=1 AND c.StartDate <= AND (c.EndDate > OR c.EndDate='0000-00-00') ORDER BY c.DNumber DESC LIMIT ; FINISH >OUTPUT EachBigCounty
Largest Population Counties  
# County State Population As Of
[More]
 /PolyCoords/Poly.txt'> if ( open(FILE, "$in{BFDIR}/PolyCoords/Poly$in{ContainerID}.txt")) { undef $/; $in{allpolys}=; $/="\n"; close FILE; } /PolyCoords/Poly.txt'> SELECT a.MapImageLink CountyMap,FillCoords MapFill,PolyCoords SMPoly,Width MapX,Height MapY FROM MapLocation as l JOIN MapLocationAttach as a ON ContainerLink= AND PolyCoords!='' AND StartDate <= AND (EndDate > OR EndDate='0000-00-00') AND a.MapLocationLink=l.MapLocationID JOIN MapImage as i ON i.MapImageID=a.MapImageLink WHERE MapGroup='Statewide' ORDER BY MapGroup DESC,EndDate DESC LIMIT 1;OUTPUT NIL $in{SMNPoly}=''; if ($in{MapX} <= 300 && $in{MapY} <= 300) { $pscale=1; } elsif ($in{MapX} > $in{MapY}) { $pscale=300/$in{MapX}; } else { $pscale=300/$in{MapY}; } foreach $pcoord (split /,/,$in{SMPoly}) { $in{SMNPoly}.=''.(int($pcoord * $pscale)).','; } chop $in{SMNPoly}; $in{allpolys}.=''.&SafeHTML($in{CountyName}).''."\n"; $in{PPosX}=0; $in{PPosY}=0; if ($in{MapFill} ne '') { ($in{PPosX}=0,$in{PPosY},$unused)=split(',',$in{MapFill}); $in{PPosX}=int($in{PPosX}*$pscale); $in{PPosY}=int($in{PPosY}*$pscale); } $in{allpdiv}.=''."\n"; SELECT ContainerID CountyID,Name CountyName FROM Container WHERE ParentLink= AND StartDate < AND (EndDate >= OR EndDate='0000-00-00 00:00:00') AND CategoryLink=77 ORDER BY Priority DESC,Name;OUTPUT EachCounty /PolyCoords/Poly.txt,allpolys> /PolyCoords/Poly.txt'> if ( open(FILE, "$in{BFDIR}/PolyCoords/Poly$in{ParentLink}.txt")) { undef $/; $in{allpolys}=; $/="\n"; close FILE; }

SELECT MapImageID,MapName,MapLocationID,l.StartDate MLStart,l.EndDate MLEnd,FillCoords MCFill,PolyCoords MCPoly FROM MapLocation as l,MapLocationAttach as a,MapImage as i WHERE l.ContainerLink= AND l.StartDate<= AND (l.EndDate>= OR l.EndDate='0000-00-00') AND a.MapLocationLink=l.MapLocationID AND i.MapImageID=a.MapImageLink;OUTPUT HRMap

MAPS
 SELECT COUNT(*) NRc FROM Race WHERE Type!='Primary Election' AND Type!='Appointment' AND Winner!=0 AND ParentContainer=;OUTPUT NIL
HISTORY

Click For More History Details
 SELECT COUNT(*) NMl FROM MapLocation WHERE ContainerLink=;OUTPUT NIL
HISTORY
Click For History Details
HISTORY
Click For History Details
 SELECT SecLink FROM Security WHERE SecLink=58 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=59 AND UserLink=;OUTPUT NIL eq 'Pick Up Race'> Picking Up Race.
UPDATE Race SET ParentContainer=0 WHERE RaceID=;FINISH INSERT INTO Cart (UserLink,ItemType,ItemID,Pickup) VALUES (,'Race',,'Y');FINISH SELECT RaceID TRID FROM Race WHERE ParentContainer= AND ((TO_DAYS(PollEnd)+30)>TO_DAYS() OR Winner=0);OUTPUT eq 'Drop Race'> Dropping Race.
DELETE FROM Cart WHERE UserLink= AND ItemType='Race' AND ItemID= AND Pickup='Y';FINISH UPDATE Race SET ParentContainer= WHERE RaceID=;FINISH SELECT ItemID FROM Cart WHERE UserLink= AND ItemType='Race' AND Pickup='Y';OUTPUT

SELECT RaceID,Title,PollStart,PollEnd,TakeOffice FROM Race WHERE ParentContainer= AND (TakeOffice > OR Winner=0) ORDER BY PollEnd;OUTPUT SELECT RaceID,Title,PollStart,PollEnd,TakeOffice FROM Race WHERE ParentContainer= AND TakeOffice <= ORDER BY PollEnd DESC LIMIT 1;OUTPUT SELECT RaceID,Title,PollStart,PollEnd,TakeOffice FROM Cart,Race WHERE UserLink= AND ItemType='Race' AND RaceID=ItemID AND Pickup='Y' ORDER BY PollEnd; OUTPUT
RACES
Polls Close Description Takes Office
> ,  : ne 'Y'> eq 'Y'>   > ,  :
Picked Up
 

>
SELECT COUNT(DISTINCT StartDate) NStd FROM PartyReg WHERE ParentContainer=;OUTPUT NILSELECT SUM(Amount) RegTotal FROM PartyReg WHERE ParentContainer= AND PartyReg.StartDate<= AND (PartyReg.EndDate> OR PartyReg.EndDate='0000-00-00')OUTPUT NILSELECT PartyRegID,Amount,PartyReg.StartDate,PartyID,Abbr,Color,Nym FROM PartyReg,Party,User WHERE ParentContainer= AND PartyReg.StartDate<= AND (PartyReg.EndDate> OR PartyReg.EndDate='0000-00-00') AND PartyID=PartyReg.PartyLink AND UserID=PartyReg.LMBy ORDER BY Amount DESC; ne '0E0'> SELECT Amount LastAmount,TO_DAYS()-TO_DAYS(StartDate) NumDays FROM PartyReg WHERE ParentContainer= AND StartDate < AND PartyLink= ORDER BY StartDate DESC LIMIT 1;OUTPUT NIL OUTPUT
VOTER REGISTRATION
Pty Amount % Yr Chg As Of Contributor
% % > ,

SELECT COUNT(*) RegTotal FROM User;OUTPUT NILSELECT PartyID,Abbr,Color,COUNT(*) Amount FROM User JOIN Party ON PartyID=PartyLink GROUP BY PartyID ORDER BY Amount DESC;OUTPUT
PARTY REGISTRATION 
Pty Amount % As Of Contributor
% > , Auto Generated

SELECT f.ParentLink as PHistory,StartDate as SHistory,c.Name as HName,MainBranch FROM ContainerFrom as f JOIN Container as c ON c.ContainerID=f.ParentLink WHERE ChildLink= AND c.EndDate= ORDER BY MainBranch='',c.Name!= LIMIT 2;OUTPUT AddLinkHistory eq '' && $in{DemoCategory} eq 'Population')> SELECT COUNT(DISTINCT StartDate) NStd FROM DemographicNum,Demographic WHERE AttachTo='Container' AND AttachID IN () AND DemographicID=DemographicLink AND DemoCategory=;OUTPUT NIL SELECT SUM(DNumber) DTotal FROM DemographicNum,Demographic WHERE AttachTo='Container' AND AttachID IN () AND DemographicNum.StartDate<= AND (DemographicNum.EndDate> OR DemographicNum.EndDate='0000-00-00') AND DemographicID=DemographicLink AND DemoCategory=;OUTPUT NILSELECT DemographicNumID,DemoName,Color,DNumber,DemographicNum.StartDate,Nym FROM DemographicNum,Demographic,User WHERE AttachTo='Container' AND AttachID= AND DemographicNum.StartDate<= AND (DemographicNum.EndDate> OR DemographicNum.EndDate='0000-00-00') AND DNumber > 0 AND DemographicID=DemographicLink AND DemoCategory= AND UserID=DemographicNum.LMBy ORDER BY DNumber DESC; ne '0E0'> OUTPUT SELECT DISTINCT(DemoCategory) FROM DemographicNum,Demographic WHERE AttachTo='Container' AND AttachID IN () AND DemographicID=DemographicLink ORDER BY DemoCategory!='Population',DemoCategory;OUTPUT EachDemographic
DEMOGRAPHIC
% > , 
Demographic Amount % As Of Contributor
eq 'Pick Up Media'> Picking Up Media.
UPDATE Media SET ParentContainer=0 WHERE MediaID=;FINISH INSERT INTO Cart (UserLink,ItemType,ItemID,Pickup) VALUES (,'Media',,'Y');FINISH SELECT MediaID TMID FROM Media WHERE ParentContainer= AND StartDate <= Now() AND (EndDate > Now() OR EndDate='0000-00-00');OUTPUT eq 'Drop Media'> Dropping Media.
DELETE FROM Cart WHERE UserLink= AND ItemType='Media' AND ItemID= AND Pickup='Y';FINISH UPDATE Media SET ParentContainer= WHERE MediaID=;FINISH SELECT ItemID FROM Cart WHERE UserLink= AND ItemType='Media' AND Pickup='Y';OUTPUT

SELECT MediaID,Category,Name FROM Media WHERE ParentContainer= ORDER BY Category,Name; ne '0E0'> OUTPUT SELECT MediaID,Category,Name FROM Cart,Media WHERE UserLink= AND ItemType='Media' AND MediaID=ItemID AND Pickup='Y' ORDER BY StartDate,Name; OUTPUT
MEDIA
Category Name
ne 'Y'> eq 'Y'>  
Picked Up
 

>
>
>