SELECT SecLink FROM Security WHERE SecLink=52 AND UserLink=;OUTPUT NIL DELETE FROM VotingDistrict WHERE VotingDistrictID=;FINISH Map Location Deleted.
SELECT COUNT(*) ItemCnt FROM VotingDistrict as m JOIN Container as c ON c.ContainerID=m.ParentLink WHERE 1=1 AND YEAR(m.StartDate)= AND YEAR(m.EndDate)= AND m.ParentLink= ne ''>AND m.Name LIKE '' ne ''>AND GEOID LIKE '' ORDER BY c.Name,m.StartDate,m.EndDate,m.Name;OUTPUT NIL

  Map Locations

>SELECT m.VotingDistrictID,m.StartDate,m.EndDate,VTD,GEOID,m.Name,c.ContainerID,c.Name as StateName FROM VotingDistrict as m JOIN Container as c ON c.ContainerID=m.ParentLink WHERE 1=1 AND YEAR(m.StartDate)= AND YEAR(m.EndDate)= AND m.ParentLink= ne ''>AND m.Name LIKE '' ne ''>AND GEOID LIKE '' ORDER BY c.Name,m.StartDate,m.EndDate,m.Name LIMIT ,;OUTPUT VOTING DISTRICTS - of Start Year End Year State --Any-- SELECTED> SELECT ContainerID as TCID,Name as CName FROM Container WHERE ParentLink=1 and CategoryLink=248 ORDER BY Name;OUTPUT Name GEO ID ne ''>Attach  -- --   ne ''>[Attach]