SELECT * FROM fielddef WHERE TableName='user' ORDER BY FieldDefsOrder ASC Somerset Online Parish Clerks (OPC) home page
SELECT * FROM fielddef WHERE TableName='person' ORDER BY FieldDefsOrder ASCSELECT COUNT(*) AS NumRows FROM person AS A INNER JOIN peoplecategories AS D ON A.FKCategoryId=D.PersonCategoryId WHERE A.FKCategoryId = '1'SELECT DISTINCT A.PKPersonId, A.PersonEmailDomain, A.PersonEmail, A.PersonPhone, A.PersonMobile, A.PersonAddress, A.PersonWeb, A.Notes, A.PersonWeb2, A.PersonPhoto, A.PersonLetter, A.FKCategoryId, A.FKCategoryId, D.PersonCategoryName AS FKCategoryIdPersonCategoryName, A.PersonTitle, A.PersonSurname, A.PersonSurname, A.PersonFirstName, A.PersonFirstName FROM person AS A INNER JOIN peoplecategories AS D ON A.FKCategoryId=D.PersonCategoryId WHERE A.FKCategoryId = '1' ORDER BY A.PersonSurname, A.PersonFirstName LIMIT 0,16SELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 30) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 121) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 190) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 103) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 44) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 28) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 31) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 5) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 176) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 63) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 194) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 39) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 90) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 112) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 170) AND ((FKCountyId = 116))) ORDER BY ParishNameSELECT ParishName, PKParishId FROM parish WHERE ((FKOPCId = 100) AND ((FKCountyId = 116))) ORDER BY ParishName
LIST OF ONLINE PARISH CLERKS ASSIGNED TO PARISHES
Last nameFirst name(s)Parishes
Page 1 of 6, (16 rows per page; 88 rows available)
First Previous

Next Last
AddisonJenniferChiselborough, East ChinnockMagnifying glass image
BaddeleySarah TickenhamMagnifying glass image
baddeleysarahStoke St. MaryMagnifying glass image
BarrettSandra MaryBuckland St MaryMagnifying glass image
BumsteadSteveChewton MendipMagnifying glass image
ChantJohnStoke sub HamdonMagnifying glass image
CharaniClutton, Greinton, WaltonMagnifying glass image
ClynickAnnHillfarrance, Oake, Sampford Arundel, StaplegroveMagnifying glass image
CoxMyra East HuntspillMagnifying glass image
CraigLizDunsterMagnifying glass image
CridlandGeraldineMagnifying glass image
CridlandJanetMagnifying glass image
DayCathyKilmington, PenselwoodMagnifying glass image
DixonJayeBedminsterMagnifying glass image
Duppa-MillerPeterCombe HayMagnifying glass image
EdgeCathyMagnifying glass image