Query_Name: Abstract_Fix Query_Type: Select Query_DateCreated: 30/04/2011 11:05:08 Query_DateChanged: 01/05/2011 10:30:43 Query_SQL:SELECT Books.Location, Books.ID1, Books.Author, Books.Title, Books.[Purchased?], Books.Abstract, Len([Abstract]) AS [Abstract?], IIf(InStr([Abstract],"|Colour_")>0,"Yes") AS [Coloured?]
FROM Books
WHERE (((Books.[Purchased?])<>"Buy?") AND ((Len([Abstract]))>0))
ORDER BY Books.Location, Books.Author;
Link To Column Definitions: Abstract_Fix
Query_Name: Abstracts_Changed_List_AllNotes Query_Type: Select Query_DateCreated: 01/02/2009 10:16:31 Query_DateChanged: 01/02/2009 10:26:10 Query_SQL:SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Abstract, Papers.Comments
FROM Papers
WHERE ((([Abstract] & "") Like "*+N*")) OR ((([Comments] & "") Like "*+N*"))
ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Abstracts_Changed_List_AllNotes
Query_Name: Abstracts_Changed_List2 Query_Type: Select Query_DateCreated: 02/11/2016 19:21:33 Query_DateChanged: 02/11/2016 19:21:33 Query_SQL:SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Abstract, Papers.Comments, Papers.Source
FROM (Abstracts_Archive RIGHT JOIN Papers ON Abstracts_Archive.ID = Papers.ID) LEFT JOIN Notes ON Papers.Write_Up_Note_ID = Notes.ID
WHERE ((([Papers]![Comments] & "")<>([Abstracts_Archive]![Comments] & ""))) OR ((([Papers]![Abstract] & "")<>([Abstracts_Archive]![Abstract] & ""))) OR ((([Papers]![Title] & "")<>([Abstracts_Archive]![Title] & ""))) OR ((([Papers]![Author] & "")<>([Abstracts_Archive]![Author] & ""))) OR ((([Notes]![Status] & "")="Temp"))
ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Abstracts_Changed_List2
Query_Name: Abstracts_Changed_List3 Query_Type: Select Query_DateCreated: 11/03/2018 20:41:01 Query_DateChanged: 11/03/2018 20:42:38 Query_SQL:SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Abstract, Papers.Comments, Papers.Source
FROM (Abstracts_Archive RIGHT JOIN Papers ON Abstracts_Archive.ID = Papers.ID) LEFT JOIN Notes ON Papers.Write_Up_Note_ID = Notes.ID
WHERE ((([Papers]![Comments] & "")<>([Abstracts_Archive]![Comments] & ""))) OR ((([Papers]![Abstract] & "")<>([Abstracts_Archive]![Abstract] & ""))) OR ((([Papers]![Title] & "")<>([Abstracts_Archive]![Title] & ""))) OR ((([Papers]![Author] & "")<>([Abstracts_Archive]![Author] & ""))) OR ((([Papers]![Write_Up_Note_ID] & "")<>""))
ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Abstracts_Changed_List3
Query_Name: Abstracts_Recent Query_Type: Select Query_DateCreated: 12/04/2011 15:12:48 Query_DateChanged: 12/04/2011 16:07:28 Query_SQL:SELECT [Papers]![Author] & " - " & [Papers]![Title] AS Paper, Papers.ID, IIf((Now()-[Timestamp])<7,1,IIf((Now()-[Timestamp])<14,2,IIf((Now()-[Timestamp])<28,4,0))) AS Period, Nz(Len([Papers]![Comments]))+Nz(Len([Papers]![Abstract])) AS [Size]
FROM Papers INNER JOIN Abstracts_Archive ON Papers.ID = Abstracts_Archive.ID
WHERE (((Abstracts_Archive.Timestamp)>Now()-28) AND ((Nz(Len([Papers]![Comments]))+Nz(Len([Papers]![Abstract])))>200))
ORDER BY [Papers]![Author] & " - " & [Papers]![Title];
Link To Column Definitions: Abstracts_Recent
Query_Name: Active_Notes Query_Type: Select Query_DateCreated: 22/02/2009 17:51:01 Query_DateChanged: 12/09/2010 13:06:13 Query_SQL:SELECT Notes_List_Auto.ID
FROM Notes_List_Auto LEFT JOIN Notes_Archive_Temp ON Notes_List_Auto.ID = Notes_Archive_Temp.ID
WHERE (((Notes_Archive_Temp.ID) Is Not Null))
ORDER BY Notes_List_Auto.ID;
Link To Column Definitions: Active_Notes
Query_Name: Active_Notes_Associations Query_Type: Select Query_DateCreated: 22/02/2009 18:05:22 Query_DateChanged: 22/02/2009 20:13:34 Query_SQL:SELECT Note_Links.Note_2 AS ID
FROM Notes_Archive_Temp INNER JOIN Note_Links ON Notes_Archive_Temp.ID = Note_Links.Note_1
GROUP BY Note_Links.Note_2
ORDER BY Note_Links.Note_2;
Link To Column Definitions: Active_Notes_Associations
Query_Name: Active_Notes_Full Query_Type: Select Query_DateCreated: 22/02/2009 20:15:54 Query_DateChanged: 22/02/2009 20:15:54 Query_SQL:SELECT Active_Notes_Union.ID
FROM Active_Notes_Union
GROUP BY Active_Notes_Union.ID;
Link To Column Definitions: Active_Notes_Full
Query_Name: Aeon_Averages Query_Type: Select Query_DateCreated: 21/08/2017 18:57:49 Query_DateChanged: 21/08/2017 18:57:49 Query_SQL:SELECT Min(Papers.Pages) AS MinOfPages, Max(Papers.Pages) AS MaxOfPages, Avg(Papers.Pages) AS AvgOfPages, Max(Papers.[Actual - Total]) AS [MaxOfActual - Total], Avg(Papers.[Actual - Total]) AS [AvgOfActual - Total]
FROM Papers
WHERE (((Papers.Source) Like "*Aeon, *"));
Link To Column Definitions: Aeon_Averages
Query_Name: Aeon_Date_Fixes Query_Type: Select Query_DateCreated: 09/04/2021 15:49:13 Query_DateChanged: 10/10/2021 23:42:29 Query_SQL:SELECT PID_Note_Reading_Lists.Note_Title, PID_Note_Reading_Lists.Note_ID, PID_Note_Reading_Lists.Category, Papers.Author, Papers.Title, Papers.Comments, PID_Note_Reading_Lists.Item_Year, Papers.Source, Papers.Pages, Papers.[On_Laptop?], PID_Note_Reading_Lists.[Aeon_Video_Fixed?], "Fix pages, Category, Date + On Laptop. Print to PDF." AS [To Do]
FROM PID_Note_Reading_Lists INNER JOIN Papers ON PID_Note_Reading_Lists.Called_ID = Papers.ID
WHERE (((Papers.Source) Like "Aeon, *") AND ((Papers.[On_Laptop?])=No) AND ((PID_Note_Reading_Lists.[Aeon_Video_Fixed?])=No))
ORDER BY PID_Note_Reading_Lists.Note_Title, PID_Note_Reading_Lists.Category, Papers.Author, Papers.Title;
Link To Column Definitions: Aeon_Date_Fixes
Query_Name: Aeon_Papers_LastYearHours_Total Query_Type: Select Query_DateCreated: 07/04/2021 20:10:48 Query_DateChanged: 10/10/2021 11:23:02 Query_SQL:SELECT 24006 AS [Paper_Actuals ID], Sum([Timesheet_Last Year].Hours) AS SumOfHours, 2021-2 AS [Year], "Update Paper_Actuals ... reduce by the Hours in this Query" AS Comments
FROM (Papers INNER JOIN (Aeon_Papers_Add_Prelist INNER JOIN [Timesheet_Last Year] ON Aeon_Papers_Add_Prelist.WebRef = [Timesheet_Last Year].Topic) ON (Papers.Title = Aeon_Papers_Add_Prelist.Aeon_Title) AND (Papers.Author = Aeon_Papers_Add_Prelist.Authors)) LEFT JOIN Paper_Actuals ON Papers.ID = Paper_Actuals.ID
GROUP BY 24006, "Update Paper_Actuals ... reduce by the Hours in this Query";
Link To Column Definitions: Aeon_Papers_LastYearHours_Total
Query_Name: Aeon_Test_Time Query_Type: Select Query_DateCreated: 09/04/2021 12:07:17 Query_DateChanged: 09/04/2021 12:11:45 Query_SQL:SELECT PID_Note_Reading_Lists.Note_Title, Count(Papers.ID) AS CountOfID
FROM PID_Note_Reading_Lists INNER JOIN Papers ON PID_Note_Reading_Lists.Called_ID = Papers.ID
WHERE (((Papers.Source) Like "Aeon, *") AND ((PID_Note_Reading_Lists.[Book/Paper])="Paper") AND ((Papers.ID)>24522))
GROUP BY PID_Note_Reading_Lists.Note_Title
ORDER BY PID_Note_Reading_Lists.Note_Title;
Link To Column Definitions: Aeon_Test_Time
Query_Name: Ambiguous_Objects Query_Type: Select Query_DateCreated: 25/06/2013 13:36:32 Query_DateChanged: 25/06/2013 13:54:40 Query_SQL:SELECT Code_Table.Procedure_Name, Query_Definitions.Query_Name, Table_Definitions.Table_Name
FROM (Query_Definitions RIGHT JOIN Code_Table ON Query_Definitions.Query_Name = Code_Table.Procedure_Name) LEFT JOIN Table_Definitions ON Code_Table.Procedure_Name = Table_Definitions.Table_Name
WHERE (((Query_Definitions.Query_Name) Is Not Null)) OR (((Table_Definitions.Table_Name) Is Not Null))
ORDER BY Code_Table.Procedure_Name;
Link To Column Definitions: Ambiguous_Objects
Query_Name: Author_Citation_Counts Query_Type: Select Query_DateCreated: 12/12/2019 00:58:09 Query_DateChanged: 12/12/2019 11:02:54 Query_SQL:SELECT Authors.Author_Name AS Author, Count(Authors_Cited_By_All_List.Title) AS Citations
FROM Authors_Cited_By_All_List INNER JOIN Authors ON Authors_Cited_By_All_List.Author_ID = Authors.Author_ID
GROUP BY Authors.Author_Name
ORDER BY Authors.Author_Name, Count(Authors_Cited_By_All_List.Title);
Link To Column Definitions: Author_Citation_Counts
Query_Name: Author_Letters_Latest Query_Type: Select Query_DateCreated: 19/05/2018 21:49:05 Query_DateChanged: 19/05/2018 23:07:26 Query_SQL:SELECT "Author_Letters" AS Title, Min(Author_Letters.Latest_Author_Letter_Update) AS MinOfLatest_Author_Letter_Update
FROM Author_Letters
GROUP BY "Author_Letters";
Link To Column Definitions: Author_Letters_Latest
Query_Name: AuthorNarrs - Search for Update Query_Type: Select Query_DateCreated: 21/05/2014 22:43:17 Query_DateChanged: 24/11/2020 20:01:57 Query_SQL:SELECT Authors.Author_Name, Authors.Author_Narrative, Authors.Author_Name_Display, Authors.Author_ID
FROM Authors
WHERE (((Authors.Author_Name) Like "*" & [Enter String] & "*"))
ORDER BY Authors.Author_Name;
Link To Column Definitions: AuthorNarrs - Search for Update
Query_Name: Authors_Cited_By_Authors_List Query_Type: Select Query_DateCreated: 09/09/2015 00:13:43 Query_DateChanged: 09/09/2015 00:14:28 Query_SQL:SELECT Authors.Author_Name AS Author, " N/A" AS Title, "Author" AS Medium, "" AS Display_Text, "" AS Icon, "N/A" AS [Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Author_ID
FROM Authors INNER JOIN Cross_Reference ON Authors.Author_ID = Cross_Reference.Calling_ID
WHERE (((Cross_Reference.Called_Type)="A") AND ((Cross_Reference.Called_Timestamp)=0) AND ((Cross_Reference.Calling_Type)="A"))
ORDER BY Authors.Author_Name, "N/A", Cross_Reference.Calling_NameRef;
Link To Column Definitions: Authors_Cited_By_Authors_List
Query_Name: Authors_Cited_By_Books_List Query_Type: Select Query_DateCreated: 09/09/2015 00:12:35 Query_DateChanged: 10/04/2020 23:59:08 Query_SQL:SELECT Books.Author, Books.Title, "Book" AS Medium, Quality_Markers.Display_Text, Quality_Markers.Icon, Books.[Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Author_ID
FROM (Cross_Reference INNER JOIN Books ON Cross_Reference.Calling_ID = Books.ID1) INNER JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality
WHERE (((Cross_Reference.Called_Type)="A") AND ((Cross_Reference.Called_Timestamp)=0) AND ((Cross_Reference.Calling_Type)="B"))
ORDER BY Books.Author, Books.Title, Cross_Reference.Calling_NameRef;
Link To Column Definitions: Authors_Cited_By_Books_List
Query_Name: Authors_Cited_By_Notes_List Query_Type: Select Query_DateCreated: 09/09/2015 00:15:11 Query_DateChanged: 09/09/2015 00:20:20 Query_SQL:SELECT "Todman (Theo)" AS Author, Notes.Item_Title AS Title, "Note" AS Medium, Notes.Note_Group AS Display_Text, "" AS Icon, "N/A" AS [Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Author_ID
FROM Notes INNER JOIN Cross_Reference ON Notes.ID = Cross_Reference.Calling_ID
WHERE (((Cross_Reference.Called_Type)="A") AND ((Cross_Reference.Calling_Timestamp)=0) AND ((Cross_Reference.Calling_Type)="N"))
ORDER BY "Todman (Theo)", "N/A", Cross_Reference.Calling_NameRef;
Link To Column Definitions: Authors_Cited_By_Notes_List
Query_Name: Authors_Cited_By_Papers_List Query_Type: Select Query_DateCreated: 09/09/2015 00:09:46 Query_DateChanged: 10/04/2020 23:59:00 Query_SQL:SELECT Papers.Author, Papers.Title, "Paper" AS Medium, Quality_Markers.Display_Text, Quality_Markers.Icon, Papers.[Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Author_ID
FROM (Papers INNER JOIN Cross_Reference ON Papers.ID = Cross_Reference.Calling_ID) INNER JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality
WHERE (((Cross_Reference.Called_Type)="A") AND ((Cross_Reference.Calling_Type)="P"))
ORDER BY Papers.Author, Papers.Title, Cross_Reference.Calling_NameRef;
Link To Column Definitions: Authors_Cited_By_Papers_List
Query_Name: Authors_List_Authors Query_Type: Select Query_DateCreated: 29/05/2012 17:22:05 Query_DateChanged: 13/05/2014 22:47:04 Query_SQL:SELECT Authors_List_Authors_Table.Author_Name
FROM Authors_List_Authors_Table
ORDER BY Authors_List_Authors_Table.Author_Name;
Link To Column Definitions: Authors_List_Authors
Query_Name: Authors_List_Fix Query_Type: Select Query_DateCreated: 23/07/2013 08:26:57 Query_DateChanged: 11/12/2014 17:13:31 Query_SQL:SELECT Papers.Location, Books.[Author & Title], Authors_List1.Author_Name, Authors_List1.Title, Authors_List1.Book_ID
FROM (Authors_List1 LEFT JOIN Papers ON Authors_List1.Book_ID = Papers.ID) LEFT JOIN Books ON Papers.Book_ID = Books.ID1
WHERE (((Authors_List1.Medium)="Paper") AND ((InStr([Author_Name],"("))=0))
GROUP BY Papers.Location, Books.[Author & Title], Authors_List1.Author_Name, Authors_List1.Title, Authors_List1.Book_ID
HAVING (((Papers.Location)>"Library (Right) - 4,7"))
ORDER BY Papers.Location, Books.[Author & Title], Authors_List1.Author_Name, Authors_List1.Title;
Link To Column Definitions: Authors_List_Fix
Query_Name: Authors_Summary Query_Type: Select Query_DateCreated: 30/12/2014 18:58:07 Query_DateChanged: 10/04/2020 00:29:22 Query_SQL:SELECT Authors.Author_Name AS Author, IIf([Authors]![Author_Narrative] & ""=""," ","Yes") AS [Author's Abstract?], IIf([Author_Book_Count]=0," ",[Author_Book_Count]) AS [Book Count], IIf([Author_Paper_Count]=0," ",[Author_Paper_Count]) AS [Paper Count], IIf([Author_Citation_Count]=0," ",[Author_Citation_Count]) AS [Citation Count]
FROM Authors
ORDER BY Authors.Author_Name;
Link To Column Definitions: Authors_Summary
Query_Name: Auto_Ref_Notes_Stats_Detailed Query_Type: Select Query_DateCreated: 24/09/2020 14:09:09 Query_DateChanged: 21/10/2020 18:04:27 Query_SQL:SELECT IIf([Object_Type]="Notes","Note","Other") AS [Object Category], Auto_Reference_Notes_Actions.Object_Type AS [Object Type], Sum(IIf([Accepted]=True,1,IIf([Suppressed]=True,0,IIf([Already_Linked]=True,1,0)))) AS [Accepted?], Sum(IIf([Suppressed]=True,1,0)) AS [Suppressed?], Sum(IIf([Ignored]=True,1,IIf([Already_Linked]=True,0,1))) AS [Unprocessed / Ignored?], Sum(IIf([Quoted_Text]=True,1,0)) AS [In Quoted Text?], Sum(IIf([Footnote]=True,1,0)) AS [In Footnote?]
FROM Note_Alternates INNER JOIN Auto_Reference_Notes_Actions ON Note_Alternates.ID = Auto_Reference_Notes_Actions.Note_ID
WHERE (((Note_Alternates.[Auto_Link?])=True) AND ((Auto_Reference_Notes_Actions.Cognate_Rejected)=False) AND ((Auto_Reference_Notes_Actions.In_Author)=False) AND ((Auto_Reference_Notes_Actions.In_HTML_Tag)=False))
GROUP BY IIf([Object_Type]="Notes","Note","Other"), Auto_Reference_Notes_Actions.Object_Type
ORDER BY IIf([Object_Type]="Notes","Note","Other");
Link To Column Definitions: Auto_Ref_Notes_Stats_Detailed
Query_Name: Auto_Ref_Notes_Stats_Grand_Summary Query_Type: Select Query_DateCreated: 22/10/2020 20:02:33 Query_DateChanged: 24/10/2020 19:05:34 Query_SQL:SELECT IIf([Object_Type]="Notes","[" & [Item_Title] & "]+L" & [Note_ID] & "L+",[Item_Title]) AS [Note], IIf([Object_Type]="Notes","Note","Other") AS [Object Category], Sum(IIf([Accepted]=True,1,IIf([Suppressed]=True,0,IIf([Already_Linked]=True,1,0)))) AS [Accepted?], Sum(IIf([Suppressed]=True,1,0)) AS [Suppressed?], Sum(IIf([Ignored]=True,1,IIf([Already_Linked]=True,0,1))) AS [Unprocessed / Ignored?], Sum(IIf([Quoted_Text]=True,1,0)) AS [In Quoted Text?], Sum(IIf([Footnote]=True,1,0)) AS [In Footnote?]
FROM Note_Alternates INNER JOIN Auto_Reference_Notes_Actions ON Note_Alternates.ID = Auto_Reference_Notes_Actions.Note_ID
WHERE (((Auto_Reference_Notes_Actions.Cognate_Rejected)=False) AND ((Auto_Reference_Notes_Actions.In_Author)=False) AND ((Auto_Reference_Notes_Actions.In_HTML_Tag)=False) AND ((Note_Alternates.Item_Title)=[Item_Alt_Title]))
GROUP BY IIf([Object_Type]="Notes","[" & [Item_Title] & "]+L" & [Note_ID] & "L+",[Item_Title]), IIf([Object_Type]="Notes","Note","Other"), Note_Alternates.Item_Title
ORDER BY Note_Alternates.Item_Title, IIf([Object_Type]="Notes","Note","Other");
Link To Column Definitions: Auto_Ref_Notes_Stats_Grand_Summary
Query_Name: Auto_Ref_Notes_Stats_Grandest_Summary Query_Type: Select Query_DateCreated: 24/10/2020 17:43:19 Query_DateChanged: 24/10/2020 17:47:55 Query_SQL:SELECT IIf([Object_Type]="Notes","Note","Other") AS [Object Category], Sum(IIf([Accepted]=True,1,IIf([Suppressed]=True,0,IIf([Already_Linked]=True,1,0)))) AS [Accepted?], Sum(IIf([Suppressed]=True,1,0)) AS [Suppressed?], Sum(IIf([Ignored]=True,1,IIf([Already_Linked]=True,0,1))) AS [Unprocessed / Ignored?], Sum(IIf([Quoted_Text]=True,1,0)) AS [In Quoted Text?], Sum(IIf([Footnote]=True,1,0)) AS [In Footnote?]
FROM Auto_Reference_Notes_Actions
WHERE (((Auto_Reference_Notes_Actions.Cognate_Rejected)=False) AND ((Auto_Reference_Notes_Actions.In_Author)=False) AND ((Auto_Reference_Notes_Actions.In_HTML_Tag)=False))
GROUP BY IIf([Object_Type]="Notes","Note","Other")
ORDER BY IIf([Object_Type]="Notes","Note","Other");
Link To Column Definitions: Auto_Ref_Notes_Stats_Grandest_Summary
Query_Name: Auto_Ref_Notes_Stats_Summary Query_Type: Select Query_DateCreated: 24/09/2020 13:46:33 Query_DateChanged: 21/10/2020 18:04:48 Query_SQL:SELECT IIf([Object_Type]="Notes","Note","Other") AS [Object Category], Sum(IIf([Accepted]=True,1,IIf([Suppressed]=True,0,IIf([Already_Linked]=True,1,0)))) AS [Accepted?], Sum(IIf([Suppressed]=True,1,0)) AS [Suppressed?], Sum(IIf([Ignored]=True,1,IIf([Already_Linked]=True,0,1))) AS [Unprocessed / Ignored?], Sum(IIf([Quoted_Text]=True,1,0)) AS [In Quoted Text?], Sum(IIf([Footnote]=True,1,0)) AS [In Footnote?]
FROM Note_Alternates INNER JOIN Auto_Reference_Notes_Actions ON Note_Alternates.ID = Auto_Reference_Notes_Actions.Note_ID
WHERE (((Note_Alternates.[Auto_Link?])=True) AND ((Auto_Reference_Notes_Actions.Cognate_Rejected)=False) AND ((Auto_Reference_Notes_Actions.In_Author)=False) AND ((Auto_Reference_Notes_Actions.In_HTML_Tag)=False))
GROUP BY IIf([Object_Type]="Notes","Note","Other")
ORDER BY IIf([Object_Type]="Notes","Note","Other");
Link To Column Definitions: Auto_Ref_Notes_Stats_Summary
Query_Name: Backup_Directory_Structure_List Query_Type: Select Query_DateCreated: 17/05/2014 22:28:43 Query_DateChanged: 07/06/2014 10:17:28 Query_SQL:SELECT Backup_Directory_Structure.Directory, Backup_Control.Input_Root
FROM Backup_Directory_Structure, Backup_Control
ORDER BY Backup_Directory_Structure.Directory;
Link To Column Definitions: Backup_Directory_Structure_List
Query_Name: Bible_Latest_Prelist_1 Query_Type: Select Query_DateCreated: 02/08/2021 17:38:03 Query_DateChanged: 31/07/2022 19:32:19 Query_SQL:SELECT Bible_Reading_Control.OT_NT_LXX, Max(Bible_Reading_Control.Book_ID) AS MaxOfBook_ID
FROM Bible_Reading_Control
WHERE (((Bible_Reading_Control.Last_Verse_Read)>0) AND ((Bible_Reading_Control.Out_Of_Order)=No))
GROUP BY Bible_Reading_Control.OT_NT_LXX;
Link To Column Definitions: Bible_Latest_Prelist_1
Query_Name: Bible_Latest_Prelist_2 Query_Type: Select Query_DateCreated: 02/08/2021 17:43:04 Query_DateChanged: 02/08/2021 17:43:25 Query_SQL:SELECT Bible_Reading_Control.OT_NT_LXX, Bible_Reading_Control.Book_ID, Max(Bible_Reading_Control.Chapter_No) AS MaxOfChapter_No
FROM Bible_Latest_Prelist_1 INNER JOIN Bible_Reading_Control ON (Bible_Latest_Prelist_1.MaxOfBook_ID = Bible_Reading_Control.Book_ID) AND (Bible_Latest_Prelist_1.OT_NT_LXX = Bible_Reading_Control.OT_NT_LXX)
WHERE (((Bible_Reading_Control.Last_Verse_Read)>0))
GROUP BY Bible_Reading_Control.OT_NT_LXX, Bible_Reading_Control.Book_ID;
Link To Column Definitions: Bible_Latest_Prelist_2
Query_Name: Bible_Progress_Updt Query_Type: Select Query_DateCreated: 21/07/2021 01:35:20 Query_DateChanged: 24/07/2023 23:32:31 Query_SQL:SELECT Bible_Reading_Control.*
FROM Bible_Reading_Control
WHERE (((Bible_Reading_Control.OT_NT_LXX)="OT") AND ((Bible_Reading_Control.Book_Name)="1 Samuel")) OR (((Bible_Reading_Control.OT_NT_LXX)="LXX") AND ((Bible_Reading_Control.Book_Name)="2 Esdras")) OR (((Bible_Reading_Control.OT_NT_LXX)="NT2") AND ((Bible_Reading_Control.Book_Name)="John"))
ORDER BY Bible_Reading_Control.OT_NT_LXX DESC , Bible_Reading_Control.Book_Name, Bible_Reading_Control.Chapter_No;
Link To Column Definitions: Bible_Progress_Updt
Query_Name: Bible_Reading_Summary_1 Query_Type: Select Query_DateCreated: 21/07/2021 01:41:39 Query_DateChanged: 27/12/2022 19:14:37 Query_SQL:SELECT Bible_Reading_Control.OT_NT_LXX, Sum(Bible_Reading_Control.Verses) AS [Total Verses], Sum(Bible_Reading_Control.Last_Verse_Read) AS [Verses Read], Bible_Completion_Dates_Aim.Start_Date AS Start
FROM Bible_Reading_Control INNER JOIN Bible_Completion_Dates_Aim ON Bible_Reading_Control.OT_NT_LXX = Bible_Completion_Dates_Aim.OT_NT_LXX
GROUP BY Bible_Reading_Control.OT_NT_LXX, Bible_Completion_Dates_Aim.Start_Date;
Link To Column Definitions: Bible_Reading_Summary_1
Query_Name: Book_Abstracts_Recent Query_Type: Select Query_DateCreated: 12/04/2011 17:09:32 Query_DateChanged: 23/05/2014 15:02:25 Query_SQL:SELECT [Author] & " - " & [Title] AS Book, Book_Abstracts_Archive.ID1, IIf((Now()-[Timestamp])<7,1,IIf((Now()-[Timestamp])<14,2,IIf((Now()-[Timestamp])<28,4,0))) AS Period, Nz(Len([Comments]))+Nz(Len([Abstract])) AS [Size]
FROM Book_Abstracts_Archive
WHERE (((Nz(Len([Comments]))+Nz(Len([Abstract])))>250) AND ((Book_Abstracts_Archive.Timestamp)>Now()-28))
ORDER BY [Author] & " - " & [Title];
Link To Column Definitions: Book_Abstracts_Recent
Query_Name: Book_Author_List_Changed1 Query_Type: Select Query_DateCreated: 28/06/2011 10:16:03 Query_DateChanged: 29/07/2013 11:08:31 Query_SQL:SELECT Author_Book_Links.Author AS Author_Name
FROM Author_Book_Links, System_Parameters
WHERE (((Author_Book_Links.Timestamp)>Now()-[Author_Change_Days]))
GROUP BY Author_Book_Links.Author;
Link To Column Definitions: Book_Author_List_Changed1
Query_Name: Book_Book_List_Changed1 Query_Type: Select Query_DateCreated: 28/06/2011 11:52:58 Query_DateChanged: 28/06/2011 11:54:20 Query_SQL:SELECT Book_Book_List.Book_ID
FROM Book_Summary_Changed_List INNER JOIN Book_Book_List ON Book_Summary_Changed_List.ID1 = Book_Book_List.Object_ID
GROUP BY Book_Book_List.Book_ID
ORDER BY Book_Book_List.Book_ID;
Link To Column Definitions: Book_Book_List_Changed1
Query_Name: Book_Citings_Page_List (Letters) Query_Type: Select Query_DateCreated: 15/06/2014 15:59:37 Query_DateChanged: 15/06/2014 16:00:46 Query_SQL:SELECT Left([Author],1) AS Letter
FROM Book_Citings_Page_List
GROUP BY Left([Author],1)
ORDER BY Left([Author],1);
Link To Column Definitions: Book_Citings_Page_List (Letters)
Query_Name: Book_Note_Counts Query_Type: Select Query_DateCreated: 28/01/2009 09:14:45 Query_DateChanged: 25/07/2010 19:49:02 Query_SQL:SELECT Note_Book_Links.Book, Count(Note_Book_Links.Note) AS CountOfNote
FROM Note_Book_Links
WHERE (((Note_Book_Links.Origin)="Note"))
GROUP BY Note_Book_Links.Book
ORDER BY Note_Book_Links.Book;
Link To Column Definitions: Book_Note_Counts
Query_Name: Book_Note_Link_List Query_Type: Select Query_DateCreated: 23/07/2020 19:19:48 Query_DateChanged: 11/08/2020 00:22:32 Query_SQL:SELECT Books.ID1 AS Book_ID, Notes.ID AS [Note ID], Books.Author AS [Book Author], Books.Title AS [Book Title], IIf([Live_Note?]=0,[Notes]![Item_Title],[Notes_Archive]![Item_Title]) AS [Note], Note_Groups.Note_Group AS [Note Group], IIf([Live_Note?]=0,Year(Int([Notes]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes]![Last_Changed]/1000))+100,2),Year(Int([Notes_Archive]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes_Archive]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes_Archive]![Last_Changed]/1000))+100,2)) AS [Date Last Changed], Cross_Reference.Calling_Timestamp, Cross_Reference.Calling_NameRef
FROM (((Cross_Reference INNER JOIN (Notes INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID) ON Cross_Reference.Calling_ID = Notes.ID) INNER JOIN Cross_Reference_Prelims ON (Cross_Reference.Called_ID = Cross_Reference_Prelims.Called_ID) AND (Cross_Reference.Called_Type = Cross_Reference_Prelims.Called_Type) AND (Cross_Reference.Calling_Type = Cross_Reference_Prelims.Calling_Type) AND (Cross_Reference.Calling_ID = Cross_Reference_Prelims.Calling_ID)) LEFT JOIN Notes_Archive ON (Cross_Reference_Prelims.Latest_Archive_Note = Notes_Archive.Timestamp) AND (Cross_Reference_Prelims.Calling_ID = Notes_Archive.ID)) INNER JOIN Books ON Cross_Reference.Called_ID = Books.ID1
WHERE (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="B") AND ((Cross_Reference_Prelims.[Live_Note?])=0) AND ((Cross_Reference.Calling_Timestamp)=0)) OR (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="B") AND ((Cross_Reference_Prelims.[Live_Note?])=1) AND ((Cross_Reference.Calling_Timestamp)=[Latest_Archive_Note]))
GROUP BY Books.ID1, Notes.ID, Books.Author, Books.Title, IIf([Live_Note?]=0,[Notes]![Item_Title],[Notes_Archive]![Item_Title]), Note_Groups.Note_Group, IIf([Live_Note?]=0,Year(Int([Notes]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes]![Last_Changed]/1000))+100,2),Year(Int([Notes_Archive]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes_Archive]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes_Archive]![Last_Changed]/1000))+100,2)), Cross_Reference.Calling_Timestamp, Cross_Reference.Calling_NameRef
ORDER BY Books.ID1, Books.Author, Books.Title, IIf([Live_Note?]=0,[Notes]![Item_Title],[Notes_Archive]![Item_Title]);
Link To Column Definitions: Book_Note_Link_List
Query_Name: Book_Paper_List_Changed1 Query_Type: Select Query_DateCreated: 28/06/2011 11:55:08 Query_DateChanged: 28/06/2011 11:55:32 Query_SQL:SELECT Book_Paper_List.Book_ID
FROM Paper_Summary_Changed_List INNER JOIN Book_Paper_List ON Paper_Summary_Changed_List.ID = Book_Paper_List.Object_ID
GROUP BY Book_Paper_List.Book_ID
ORDER BY Book_Paper_List.Book_ID;
Link To Column Definitions: Book_Paper_List_Changed1
Query_Name: Book_Papers_Changed Query_Type: Select Query_DateCreated: 22/02/2009 16:05:38 Query_DateChanged: 20/06/2012 12:29:29 Query_SQL:SELECT Book_Papers3.Book_ID
FROM Papers INNER JOIN (Books INNER JOIN (Book_Papers3 LEFT JOIN Book_Papers_Full ON (Book_Papers3.Paper_ID = Book_Papers_Full.Paper_ID) AND (Book_Papers3.Book_ID = Book_Papers_Full.Book_ID)) ON Books.ID1 = Book_Papers3.Book_ID) ON Papers.ID = Book_Papers3.Paper_ID
WHERE (((Book_Papers_Full.Paper_ID) Is Null)) OR (((Book_Papers_Full.Sequence)<>[Papers]![Sequence])) OR (((Book_Papers_Full.Book_Author_Title)<>[Author & Title])) OR (((Book_Papers_Full.Paper_Author_Title)<>([Papers]![Author] & " - " & [Papers]![Title]))) OR (((Book_Papers_Full.Paper_Abstract_Quality)<>[Papers]![Abstract_Quality])) OR (((Book_Papers_Full.Paper_Pages)<>[Papers]![Pages])) OR (((Book_Papers_Full.Hours_Left)<>[Papers]![Hours Left])) OR (((Book_Papers_Full.Paper_Abstract_Length)<>Len([Papers]![Abstract] & "")+Len([Papers]![Comments] & "")+0))
GROUP BY Book_Papers3.Book_ID;
Link To Column Definitions: Book_Papers_Changed
Query_Name: Book_Papers3 Query_Type: Select Query_DateCreated: 26/01/2009 19:56:05 Query_DateChanged: 10/02/2009 20:03:13 Query_SQL:SELECT Book_Papers2.Book_ID, Book_Papers2.Paper_ID
FROM Book_Papers2
GROUP BY Book_Papers2.Book_ID, Book_Papers2.Paper_ID;
Link To Column Definitions: Book_Papers3
Query_Name: Book_Papers4 Query_Type: Select Query_DateCreated: 10/02/2009 19:53:54 Query_DateChanged: 10/02/2009 19:53:54 Query_SQL:SELECT Book_Papers3.Book_ID, Papers.Author
FROM Book_Papers3 INNER JOIN Papers ON Book_Papers3.Paper_ID = Papers.ID
GROUP BY Book_Papers3.Book_ID, Papers.Author
ORDER BY Book_Papers3.Book_ID;
Link To Column Definitions: Book_Papers4
Query_Name: Book_Papers5 Query_Type: Select Query_DateCreated: 10/02/2009 19:55:35 Query_DateChanged: 10/02/2009 19:55:35 Query_SQL:SELECT Book_Papers4.Book_ID, Count(Book_Papers4.Author) AS CountAuthors
FROM Book_Papers4
GROUP BY Book_Papers4.Book_ID;
Link To Column Definitions: Book_Papers5
Query_Name: Book_Papers6 Query_Type: Select Query_DateCreated: 28/02/2009 16:44:02 Query_DateChanged: 28/02/2009 16:46:18 Query_SQL:SELECT Book_Papers3.Book_ID, Papers.Sequence
FROM Book_Papers3 INNER JOIN Papers ON Book_Papers3.Paper_ID = Papers.ID
GROUP BY Book_Papers3.Book_ID, Papers.Sequence
ORDER BY Book_Papers3.Book_ID;
Link To Column Definitions: Book_Papers6
Query_Name: Book_Papers7 Query_Type: Select Query_DateCreated: 28/02/2009 16:47:42 Query_DateChanged: 28/02/2009 16:47:50 Query_SQL:SELECT Book_Papers6.Book_ID, Count(Book_Papers6.Sequence) AS CountSequences
FROM Book_Papers6
GROUP BY Book_Papers6.Book_ID;
Link To Column Definitions: Book_Papers7
Query_Name: Book_Subject_All Query_Type: Select Query_DateCreated: 12/04/2009 14:49:17 Query_DateChanged: 12/04/2009 14:49:53 Query_SQL:SELECT Book_Subject_Union.ID1, Book_Subject_Union.Subject
FROM Book_Subject_Union
GROUP BY Book_Subject_Union.ID1, Book_Subject_Union.Subject;
Link To Column Definitions: Book_Subject_All
Query_Name: Book_Subject1 Query_Type: Select Query_DateCreated: 12/04/2009 14:42:33 Query_DateChanged: 12/04/2009 14:43:44 Query_SQL:SELECT Books.ID1, Books.Subject
FROM Books
WHERE (((Books.Subject) Is Not Null));
Link To Column Definitions: Book_Subject1
Query_Name: Book_Subject2 Query_Type: Select Query_DateCreated: 12/04/2009 14:43:53 Query_DateChanged: 12/04/2009 14:44:13 Query_SQL:SELECT Books.ID1, Books.Subject2 AS Subject
FROM Books
WHERE (((Books.Subject2) Is Not Null));
Link To Column Definitions: Book_Subject2
Query_Name: Book_Subject3 Query_Type: Select Query_DateCreated: 12/04/2009 14:44:25 Query_DateChanged: 12/04/2009 14:44:38 Query_SQL:SELECT Books.ID1, Books.Subject3 AS Subject
FROM Books
WHERE (((Books.Subject3) Is Not Null));
Link To Column Definitions: Book_Subject3
Query_Name: Book_SubTopic_All Query_Type: Select Query_DateCreated: 12/04/2009 16:29:26 Query_DateChanged: 12/04/2009 16:36:27 Query_SQL:SELECT Book_SubTopic_Union.ID1, Book_SubTopic_Union.[Sub-Topic]
FROM Book_SubTopic_Union
GROUP BY Book_SubTopic_Union.ID1, Book_SubTopic_Union.[Sub-Topic];
Link To Column Definitions: Book_SubTopic_All
Query_Name: Book_SubTopic1 Query_Type: Select Query_DateCreated: 12/04/2009 16:26:06 Query_DateChanged: 12/04/2009 16:27:15 Query_SQL:SELECT Books.ID1, Books.[Sub-Topic]
FROM Books
WHERE (((Books.[Sub-Topic]) Is Not Null));
Link To Column Definitions: Book_SubTopic1
Query_Name: Book_SubTopic2 Query_Type: Select Query_DateCreated: 12/04/2009 16:26:33 Query_DateChanged: 12/04/2009 16:29:03 Query_SQL:SELECT Books.ID1, Books.[Sub-Topic2] AS [Sub-Topic]
FROM Books
WHERE (((Books.[Sub-Topic2]) Is Not Null));
Link To Column Definitions: Book_SubTopic2
Query_Name: Book_SubTopic3 Query_Type: Select Query_DateCreated: 12/04/2009 16:28:42 Query_DateChanged: 12/04/2009 16:28:49 Query_SQL:SELECT Books.ID1, Books.[Sub-Topic3] AS [Sub-Topic]
FROM Books
WHERE (((Books.[Sub-Topic3]) Is Not Null));
Link To Column Definitions: Book_SubTopic3
Query_Name: Book_Summary_Ranges_Latest Query_Type: Select Query_DateCreated: 19/05/2018 23:09:29 Query_DateChanged: 19/05/2018 23:09:29 Query_SQL:SELECT "Book_Summary_Ranges" AS Title, Min(Book_Summary_Ranges.Latest_Book_Range_Update) AS MinOfLatest_Book_Range_Update
FROM Book_Summary_Ranges
GROUP BY "Book_Summary_Ranges";
Link To Column Definitions: Book_Summary_Ranges_Latest
Query_Name: Book_Topic_All Query_Type: Select Query_DateCreated: 12/04/2009 16:25:07 Query_DateChanged: 12/04/2009 16:25:45 Query_SQL:SELECT Book_Topic_Union.ID1, Book_Topic_Union.Topic
FROM Book_Topic_Union
GROUP BY Book_Topic_Union.ID1, Book_Topic_Union.Topic;
Link To Column Definitions: Book_Topic_All
Query_Name: Book_Topic1 Query_Type: Select Query_DateCreated: 12/04/2009 14:50:32 Query_DateChanged: 12/04/2009 14:50:44 Query_SQL:SELECT Books.ID1, Books.Topic
FROM Books
WHERE (((Books.Topic) Is Not Null));
Link To Column Definitions: Book_Topic1
Query_Name: Book_Topic2 Query_Type: Select Query_DateCreated: 12/04/2009 14:51:00 Query_DateChanged: 12/04/2009 14:51:27 Query_SQL:SELECT Books.ID1, Books.Topic2 AS Topic
FROM Books
WHERE (((Books.Topic2) Is Not Null));
Link To Column Definitions: Book_Topic2
Query_Name: Book_Topic3 Query_Type: Select Query_DateCreated: 12/04/2009 14:51:38 Query_DateChanged: 12/04/2009 14:51:44 Query_SQL:SELECT Books.ID1, Books.Topic3 AS Topic
FROM Books
WHERE (((Books.Topic3) Is Not Null));
Link To Column Definitions: Book_Topic3
Query_Name: Booklist - On Order Query_Type: Select Query_DateCreated: 29/04/2005 18:06:40 Query_DateChanged: 27/07/2013 11:02:32 Query_SQL:SELECT Books.[Purchased?], Books.[Purchase Date], Books.Author, Books.Title, Books.ID1, Books.Subject, Books.[Plan ID], Books.Pages, Books.Priority, Books.Status, Books.Cost, Books.[Checked?], Books.Location, Books.Comments, Books.Abstract
FROM Books
WHERE (((Books.[Purchased?])="ordered" Or (Books.[Purchased?])="in transit"))
ORDER BY Books.[Purchased?], Books.Author, Books.Title, Books.Subject;
Link To Column Definitions: Booklist - On Order
Query_Name: BookPaperAbstract_Ranges_Latest Query_Type: Select Query_DateCreated: 20/05/2018 00:02:59 Query_DateChanged: 20/05/2018 00:02:59 Query_SQL:SELECT "BookPaperAbstract_Ranges" AS Title, Min(BookPaperAbstract_Ranges.Latest_Book_Range_Update) AS MinOfLatest_Book_Range_Update
FROM BookPaperAbstract_Ranges
GROUP BY "BookPaperAbstract_Ranges";
Link To Column Definitions: BookPaperAbstract_Ranges_Latest
Query_Name: BookPaperAbstracts_List_Query Query_Type: Select Query_DateCreated: 23/06/2009 10:41:01 Query_DateChanged: 13/04/2020 23:49:08 Query_SQL:SELECT Books.ID1 AS [Book ID], Papers.ID AS [Paper ID], Books.Author AS [Book Author], Books.Title AS [Book Title], Papers.Author AS [Paper Author], Papers.Title AS [Paper Title], Papers.Source, IIf([Papers]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Books.Abstract AS [Book Abstract], Books.Comments AS [Book Comments], Papers.Abstract AS [Paper Abstracts], Papers.Comments AS [Paper Comments], IIf([Sequence]<0,[Sequence],IIf([CountAuthors]>10,IIf([CountSequences]/[CountAuthors]<0.5,0,[Sequence]),IIf([CountSequences]<4,0,[Sequence]))) AS Seq, Nz(Len([Books]![Comments]))+Nz(Len([Books]![Abstract])) AS Book_BlurbLen, Nz(Len([Papers]![Comments]))+Nz(Len([Papers]![Abstract])) AS Paper_BlurbLen, Papers.Write_Up_Note_ID, IIf([Pseudo_Books]![Book_ID] & ""="","No","Yes") AS PseudoBook
FROM (((((Book_Papers3 INNER JOIN Books ON Book_Papers3.Book_ID = Books.ID1) INNER JOIN Papers ON Book_Papers3.Paper_ID = Papers.ID) INNER JOIN Book_Papers5 ON Books.ID1 = Book_Papers5.Book_ID) INNER JOIN Book_Papers7 ON Book_Papers5.Book_ID = Book_Papers7.Book_ID) LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality) LEFT JOIN Pseudo_Books ON Books.ID1 = Pseudo_Books.Book_ID
ORDER BY Books.ID1, IIf([Sequence]<0,[Sequence],IIf([CountAuthors]>10,IIf([CountSequences]/[CountAuthors]<0.5,0,[Sequence]),IIf([CountSequences]<4,0,[Sequence]))), Books.Author, Books.Title, Papers.Author, Papers.Title, Books.Location;
Link To Column Definitions: BookPaperAbstracts_List_Query
Query_Name: BookPaperControl_Latest Query_Type: Select Query_DateCreated: 19/05/2018 21:42:45 Query_DateChanged: 19/05/2018 21:46:41 Query_SQL:SELECT "BookPaperControl" AS Title, Min(BookPaperControl.Latest_Update) AS MinOfLatest_Update
FROM BookPaperControl
WHERE (((BookPaperControl.ID)<>"Documentation_Generator_Bridge"))
GROUP BY "BookPaperControl";
Link To Column Definitions: BookPaperControl_Latest
Query_Name: BookPaperLinks_Ranges_Latest Query_Type: Select Query_DateCreated: 19/05/2018 23:56:16 Query_DateChanged: 19/05/2018 23:56:16 Query_SQL:SELECT "BookPaperLinks_Ranges" AS Title, Min(BookPaperLinks_Ranges.Latest_Book_Range_Update) AS MinOfLatest_Book_Range_Update
FROM BookPaperLinks_Ranges
GROUP BY "BookPaperLinks_Ranges";
Link To Column Definitions: BookPaperLinks_Ranges_Latest
Query_Name: Books - All - Categorised Query_Type: Select Query_DateCreated: 12/04/2009 16:41:33 Query_DateChanged: 02/10/2009 11:12:32 Query_SQL:SELECT [Books - All - Categorised_Table].Category, [Books - All - Categorised_Table].Author, [Books - All - Categorised_Table].Title, [Books - All - Categorised_Table].Location, [Books - All - Categorised_Table].Pages, [Books - All - Categorised_Table].Priority, [Books - All - Categorised_Table].[Read?], [Books - All - Categorised_Table].More, [Books - All - Categorised_Table].Topic, [Books - All - Categorised_Table].ID, [Books - All - Categorised_Table].ID1
FROM [Books - All - Categorised_Table]
ORDER BY [Books - All - Categorised_Table].Category, [Books - All - Categorised_Table].Author, [Books - All - Categorised_Table].Title;
Link To Column Definitions: Books - All - Categorised
Query_Name: Books - All - Categorised (Titles) - Counter Query_Type: Select Query_DateCreated: 02/10/2009 10:35:49 Query_DateChanged: 02/10/2009 10:36:40 Query_SQL:SELECT Val([Top_ID]) AS [Top ID], Count([Books - All - Categorised (Titles)].ID) AS CountOfID
FROM [Books - All - Categorised (Titles)]
GROUP BY Val([Top_ID]);
Link To Column Definitions: Books - All - Categorised (Titles) - Counter
Query_Name: Books - All - Categorised (Titles) - Prelist Query_Type: Select Query_DateCreated: 12/04/2009 14:16:20 Query_DateChanged: 12/04/2009 14:17:53 Query_SQL:SELECT [Books - All - Categorised].Category, [Books - All - Categorised].ID, Count([Books - All - Categorised].ID1) AS [Count]
FROM [Books - All - Categorised]
GROUP BY [Books - All - Categorised].Category, [Books - All - Categorised].ID;
Link To Column Definitions: Books - All - Categorised (Titles) - Prelist
Query_Name: Books - All - Categorised (Titles) - Prelist - Top Query_Type: Select Query_DateCreated: 02/10/2009 10:43:31 Query_DateChanged: 02/10/2009 21:26:26 Query_SQL:SELECT IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)) AS X, IIf(InStr([ID],"_")=0,[ID]*1,Left([ID],InStr([ID],"_")-1)) AS Y, Count([Books - All - Categorised].ID1) AS [Count]
FROM [Books - All - Categorised]
GROUP BY IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)), IIf(InStr([ID],"_")=0,[ID]*1,Left([ID],InStr([ID],"_")-1));
Link To Column Definitions: Books - All - Categorised (Titles) - Prelist - Top
Query_Name: Books - All (Letters) Query_Type: Select Query_DateCreated: 12/05/2007 10:49:35 Query_DateChanged: 12/05/2007 10:51:23 Query_SQL:SELECT Left([Author],1) AS Letter
FROM Books
WHERE (((Books.Author)<>"zzzz" And (Books.Author)<>"Various") AND ((Books.Location)<>"Senate House Library"))
GROUP BY Left([Author],1)
ORDER BY Left([Author],1);
Link To Column Definitions: Books - All (Letters)
Query_Name: Books - Collections of Papers Query_Type: Select Query_DateCreated: 06/08/2005 10:19:48 Query_DateChanged: 08/08/2005 16:22:38 Query_SQL:SELECT Books.Subject, [Author] & " - " & [Title] AS [Author/Title], Books.Location, Books.Comments, Books.[Purchased?]
FROM Books
WHERE (((Books.Comments) Like "*edited*") AND ((Books.[Purchased?])<>"Buy?")) OR (((Books.Title) Like "*paper*") AND ((Books.[Purchased?])<>"Buy?"))
ORDER BY Books.Subject, [Author] & " - " & [Title];
Link To Column Definitions: Books - Collections of Papers
Query_Name: Books - Papers Catalogued Query_Type: Select Query_DateCreated: 06/08/2005 10:05:47 Query_DateChanged: 12/03/2006 09:07:06 Query_SQL:SELECT qryBooks.[A+T], qryBooks.IDs, Count(Papers.ID) AS [Count]
FROM Papers INNER JOIN qryBooks ON Papers.Book = qryBooks.IDs
GROUP BY qryBooks.[A+T], qryBooks.IDs
ORDER BY qryBooks.[A+T];
Link To Column Definitions: Books - Papers Catalogued
Query_Name: Books - Papers Uncatalogued Query_Type: Select Query_DateCreated: 06/08/2005 10:20:56 Query_DateChanged: 08/08/2005 16:20:12 Query_SQL:SELECT [Books - Collections of Papers].Subject, [Books - Collections of Papers].[Author/Title], [Books - Collections of Papers].Location, [Books - Collections of Papers].Comments
FROM [Books - Collections of Papers] LEFT JOIN [Books - Papers Catalogued] ON [Books - Collections of Papers].[Author/Title] = [Books - Papers Catalogued].[A+T]
WHERE ((([Books - Papers Catalogued].[A+T]) Is Null))
ORDER BY [Books - Collections of Papers].Subject, [Books - Collections of Papers].[Author/Title];
Link To Column Definitions: Books - Papers Uncatalogued
Query_Name: Books - Read Query_Type: Select Query_DateCreated: 08/10/2005 20:40:30 Query_DateChanged: 08/10/2005 20:53:24 Query_SQL:SELECT Books.*
FROM Books
WHERE (((Books.[Read?])=Yes))
ORDER BY Books.Author, Books.Title;
Link To Column Definitions: Books - Read
Query_Name: Books - Recent (Letters) Query_Type: Select Query_DateCreated: 05/12/2017 23:26:44 Query_DateChanged: 05/12/2017 23:42:10 Query_SQL:SELECT Left([Author],1) AS Letter
FROM [Books - Recent]
WHERE ((([Books - Recent].Author)<>"zzzz" And ([Books - Recent].Author)<>"Various"))
GROUP BY Left([Author],1)
ORDER BY Left([Author],1);
Link To Column Definitions: Books - Recent (Letters)
Query_Name: Books_By_SubTopic1 Query_Type: Select Query_DateCreated: 27/07/2009 11:27:39 Query_DateChanged: 17/06/2013 22:54:02 Query_SQL:SELECT Note_Usage_Temp.Note_ID AS [Note ID], "Book - By Subtopic" AS Medium, Books.ID1 AS [Book ID], 0 AS [Paper ID], Books.Author, Books.Title, Books.[Author & Title] AS Source, Books.[Sub-Topic], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?]
FROM ((((Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN [Sub-Topics] ON Notes.Item_Title = [Sub-Topics].[Sub-Topic]) INNER JOIN Books ON [Sub-Topics].ID = Books.[Sub-Topic]) INNER JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group) LEFT JOIN Books_Cited ON Books.ID1 = Books_Cited.[Book ID]
WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null));
Link To Column Definitions: Books_By_SubTopic1
Query_Name: Books_By_SubTopic2 Query_Type: Select Query_DateCreated: 27/07/2009 11:27:51 Query_DateChanged: 17/06/2013 22:55:07 Query_SQL:SELECT Note_Usage_Temp.Note_ID AS [Note ID], "Book - By Subtopic" AS Medium, Books.ID1 AS [Book ID], 0 AS [Paper ID], Books.Author, Books.Title, Books.[Author & Title] AS Source, Books.[Sub-Topic2], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?]
FROM (((Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN [Sub-Topics] ON Notes.Item_Title = [Sub-Topics].[Sub-Topic]) INNER JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group) INNER JOIN (Books LEFT JOIN Books_Cited ON Books.ID1 = Books_Cited.[Book ID]) ON [Sub-Topics].ID = Books.[Sub-Topic2]
WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null));
Link To Column Definitions: Books_By_SubTopic2
Query_Name: Books_By_SubTopic3 Query_Type: Select Query_DateCreated: 27/07/2009 11:28:29 Query_DateChanged: 17/06/2013 22:57:41 Query_SQL:SELECT Note_Usage_Temp.Note_ID AS [Note ID], "Book - Referenced" AS Medium, Books.ID1 AS [Book ID], 0 AS [Paper ID], Books.Author, Books.Title, Books.[Author & Title] AS Source, Books.[Sub-Topic3], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?]
FROM (((Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN [Sub-Topics] ON Notes.Item_Title = [Sub-Topics].[Sub-Topic]) INNER JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group) INNER JOIN (Books LEFT JOIN Books_Cited ON Books.ID1 = Books_Cited.[Book ID]) ON [Sub-Topics].ID = Books.[Sub-Topic3]
WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null));
Link To Column Definitions: Books_By_SubTopic3
Query_Name: Books_from_Papers_By_Subtopic Query_Type: Select Query_DateCreated: 12/11/2007 16:59:01 Query_DateChanged: 30/07/2009 17:50:44 Query_SQL:SELECT Papers_By_SubTopic.[Note ID], "Book - By Subtopic (via Paper By Subtopic)" AS Medium, Papers_By_SubTopic.[Book ID], 0 AS [Paper ID], Books.Author, Books.Title, Books.[Author & Title] AS Source, Books.[Sub-Topic], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?]
FROM ((Papers_By_SubTopic INNER JOIN Books ON Papers_By_SubTopic.[Book ID] = Books.ID1) LEFT JOIN Books_By_SubTopic ON Papers_By_SubTopic.[Book ID] = Books_By_SubTopic.[Book ID]) LEFT JOIN Books_Cited ON Papers_By_SubTopic.[Book ID] = Books_Cited.[Book ID]
WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null) AND ((Books_By_SubTopic.[Book ID]) Is Null));
Link To Column Definitions: Books_from_Papers_By_Subtopic
Query_Name: Books_from_Papers_Cited Query_Type: Select Query_DateCreated: 12/11/2007 13:46:54 Query_DateChanged: 23/07/2010 09:40:16 Query_SQL:SELECT Papers_Cited.[Note ID], IIf([Papers_Cited]![Medium] Like "*Cited*","Book - Cited (via Paper Cited)","Book - Referencing (via Paper Referencing)") AS Medium, Papers_Cited.[Book ID], 0 AS [Paper ID], Books.Author, Books.Title, "Bibliographical details to be supplied" AS Source, Books.[Sub-Topic], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?]
FROM ((Papers_Cited INNER JOIN Books ON Papers_Cited.[Book ID] = Books.ID1) LEFT JOIN Books_Cited ON Papers_Cited.[Book ID] = Books_Cited.[Book ID]) LEFT JOIN Books_By_SubTopic ON Papers_Cited.[Book ID] = Books_By_SubTopic.[Book ID]
WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null) AND ((Books_By_SubTopic.[Book ID]) Is Null));
Link To Column Definitions: Books_from_Papers_Cited
Query_Name: Books_Locations (Titles) - Prelist - Top Query_Type: Select Query_DateCreated: 09/09/2013 12:25:45 Query_DateChanged: 09/09/2013 13:24:19 Query_SQL:SELECT Location_Group_IDs.Location_Group AS X, Location_Group_IDs.MinOfID AS Y, Count(Books_Locations_Table.ID1) AS [Count]
FROM (Books_Locations_Table INNER JOIN Locations ON Books_Locations_Table.Location = Locations.Location) INNER JOIN Location_Group_IDs ON Locations.Location_Group = Location_Group_IDs.Location_Group
GROUP BY Location_Group_IDs.Location_Group, Location_Group_IDs.MinOfID;
Link To Column Definitions: Books_Locations (Titles) - Prelist - Top
Query_Name: Books_Missing_By_Thesis_Chapter Query_Type: Select Query_DateCreated: 09/03/2021 16:49:08 Query_DateChanged: 20/07/2022 20:56:17 Query_SQL:SELECT Notes.Item_Title AS [Calling Note], Cross_Reference.Calling_ID, Books.Author, Books.Title, "Book" AS [Work Type], Cross_Reference.Called_ID
FROM ((Cross_Reference INNER JOIN Notes ON Cross_Reference.Calling_ID = Notes.ID) LEFT JOIN Thesis_Reading_Lists_Books ON (Cross_Reference.Calling_ID = Thesis_Reading_Lists_Books.Thesis_Chapter_Note_ID) AND (Cross_Reference.Called_ID = Thesis_Reading_Lists_Books.Called_ID)) INNER JOIN Books ON Cross_Reference.Called_ID = Books.ID1
WHERE (((Notes.Note_Group)=1) AND ((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="B") AND ((Cross_Reference.Calling_Timestamp)=0) AND (([Book/Paper] & "")<>"Book"))
GROUP BY Notes.Item_Title, Cross_Reference.Calling_ID, Books.Author, Books.Title, "Book", Cross_Reference.Called_ID
HAVING (((Notes.Item_Title) Like "*thesis*" And Not (Notes.Item_Title)="Thesis - References"))
ORDER BY Notes.Item_Title, Books.Author, Books.Title;
Link To Column Definitions: Books_Missing_By_Thesis_Chapter
Query_Name: Books_Nearly_Read Query_Type: Select Query_DateCreated: 22/12/2010 11:00:37 Query_DateChanged: 22/12/2010 11:44:53 Query_SQL:SELECT Books.Subject, Books.[Sub-Topic], Books.Author, Books.Title, Books.[Read?], Books.Location, (Nz([Actual (BA Year 3-4)])+Nz([Actual (Year 0)])+Nz([Actual (Year 1)])+Nz([Actual (Year 2)])+Nz([Actual - MPhil Year 1])+Nz([Actual - Intermission Year 1])+Nz([Actual - Intermission Year 2])+Nz([Actual - Heythrop Year 1])+Nz([Actual - Heythrop Year 2])) AS [Total Actual Hours]
FROM (Books INNER JOIN Subjects ON Books.Subject = Subjects.ID) INNER JOIN [Sub-Topics] ON Books.[Sub-Topic] = [Sub-Topics].ID
WHERE (((Subjects.Subject)<>"All") AND ((Books.Author)<>"Various") AND ((Books.[Read?])=No) AND (((Nz([Actual (BA Year 3-4)])+Nz([Actual (Year 0)])+Nz([Actual (Year 1)])+Nz([Actual (Year 2)])+Nz([Actual - MPhil Year 1])+Nz([Actual - Intermission Year 1])+Nz([Actual - Intermission Year 2])+Nz([Actual - Heythrop Year 1])+Nz([Actual - Heythrop Year 2])))>4))
ORDER BY Subjects.Subject, [Sub-Topics].[Sub-Topic], Books.Author, Books.Title, (Nz([Actual (BA Year 3-4)])+Nz([Actual (Year 0)])+Nz([Actual (Year 1)])+Nz([Actual (Year 2)])+Nz([Actual - MPhil Year 1])+Nz([Actual - Intermission Year 1])+Nz([Actual - Intermission Year 2])+Nz([Actual - Heythrop Year 1])+Nz([Actual - Heythrop Year 2])) DESC;
Link To Column Definitions: Books_Nearly_Read
Query_Name: Books_Versus_Papers Query_Type: Select Query_DateCreated: 24/12/2006 11:11:54 Query_DateChanged: 17/09/2014 18:23:01 Query_SQL:SELECT qryBooks.Location, qryBooks.Author, qryBooks.Title AS Book, qryBooks.Pages, Sum([Papers]![Pages]) AS Paper_Total, Count(Papers.ID) AS CountOfID, Sum([Papers]![Pages])-[qryBooks]![Pages] AS Difference, Books.[Papers_Logged?]
FROM (Papers RIGHT JOIN qryBooks ON Papers.Book = qryBooks.IDs) INNER JOIN Books ON qryBooks.ID1 = Books.ID1
GROUP BY qryBooks.Location, qryBooks.Author, qryBooks.Title, qryBooks.Pages, Books.[Papers_Logged?], qryBooks.Author, qryBooks.[Philosophy Book?]
HAVING (((qryBooks.Location)<>"") AND ((Count(Papers.ID))<3) AND ((qryBooks.[Philosophy Book?])=Yes) AND ((qryBooks.Author)<>"Admin"))
ORDER BY qryBooks.Location, qryBooks.Author, qryBooks.Title, qryBooks.Author;
Link To Column Definitions: Books_Versus_Papers
Query_Name: BookSummaries_Changed_List Query_Type: Select Query_DateCreated: 25/06/2007 10:15:14 Query_DateChanged: 21/09/2013 14:05:23 Query_SQL:SELECT Books.ID1, Books.Author, Books.Title, Subjects.Subject AS Subject, Subjects_1.Subject AS [Subject 2], Subjects_2.Subject AS [Subject 3], Topics.Topic, Topics_1.Topic AS [Topic 2], Topics_2.Topic AS [Topic 3], [Sub-Topics].[Sub-Topic] AS [Sub-Topic], [Sub-Topics_1].[Sub-Topic] AS [Sub-Topic 2], [Sub-Topics_2].[Sub-Topic] AS [Sub-Topic 3], Books.Location, Books.Pages, Books.Priority, Books.Difficulty, Books.Estimate AS [Estimated Hours], Nz([Actual - Total]) AS [Total Actual Hours], Books.Status, IIf([Read?]=True,"Yes","") AS [Read], "<A HREF = ""BooksToPapers_" & [ID1] & ".htm"">Papers</A>" AS [Papers in this Book], "<A HREF = ""BookPaperAbstracts/BookPaperAbstracts_" & [ID1] & ".htm"">Link</A>" AS [Book / Papers Abstracts Summary], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","") AS [Abstract Quality], IIf([CountOfNote] & ""="","","<A HREF = ""BooksToNotes_" & [Books]![ID1] & ".htm"">Notes</A>") AS [Notes Referencing this Book], IIf(Len([Books]![Comments])<250,[Books]![Comments],"") AS Comments
FROM ((((((((Book_Summary_Temp INNER JOIN (((Books LEFT JOIN Subjects ON Books.Subject = Subjects.ID) LEFT JOIN Subjects AS Subjects_1 ON Books.Subject2 = Subjects_1.ID) LEFT JOIN Subjects AS Subjects_2 ON Books.Subject3 = Subjects_2.ID) ON Book_Summary_Temp.ID = Books.ID1) LEFT JOIN Topics ON Books.Topic = Topics.ID) LEFT JOIN Topics AS Topics_1 ON Books.Topic2 = Topics_1.ID) LEFT JOIN Topics AS Topics_2 ON Books.Topic3 = Topics_2.ID) LEFT JOIN [Sub-Topics] ON Books.[Sub-Topic] = [Sub-Topics].ID) LEFT JOIN [Sub-Topics] AS [Sub-Topics_1] ON Books.[Sub-Topic2] = [Sub-Topics_1].ID) LEFT JOIN [Sub-Topics] AS [Sub-Topics_2] ON Books.[Sub-Topic3] = [Sub-Topics_2].ID) LEFT JOIN Book_Note_Counts ON Books.ID1 = Book_Note_Counts.Book) LEFT JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality
ORDER BY Books.ID1;
Link To Column Definitions: BookSummaries_Changed_List
Query_Name: BookSummaryCountCostLocation Query_Type: Select Query_DateCreated: 27/08/2013 20:26:35 Query_DateChanged: 27/08/2013 22:16:35 Query_SQL:SELECT IIf(InStr([Location],"-")>0,Left([Location],InStr([Location],"-")-1),[Location]) AS [Major Location], Sum(Locations.Book_Count) AS [Count], Sum(Locations.Book_Value) AS Cost
FROM Locations
GROUP BY IIf(InStr([Location],"-")>0,Left([Location],InStr([Location],"-")-1),[Location])
ORDER BY IIf(InStr([Location],"-")>0,Left([Location],InStr([Location],"-")-1),[Location]);
Link To Column Definitions: BookSummaryCountCostLocation
Query_Name: Citations_Count Query_Type: Select Query_DateCreated: 18/08/2010 00:12:21 Query_DateChanged: 18/08/2010 00:12:21 Query_SQL:SELECT Citations_List.Medium, Count(Citations_List.[Book ID]) AS [CountOfBook ID]
FROM Citations_List
GROUP BY Citations_List.Medium
ORDER BY Citations_List.Medium;
Link To Column Definitions: Citations_Count
Query_Name: Code_Archive_Table_Latest Query_Type: Select Query_DateCreated: 23/06/2013 19:16:07 Query_DateChanged: 23/06/2013 19:16:08 Query_SQL:SELECT Code_Archive_Table.Procedure_Name, Max(Code_Archive_Table.Archive_Date) AS MaxOfArchive_Date
FROM Code_Archive_Table
GROUP BY Code_Archive_Table.Procedure_Name
ORDER BY Code_Archive_Table.Procedure_Name;
Link To Column Definitions: Code_Archive_Table_Latest
Query_Name: Coxes_Farm_Gardens Query_Type: Select Query_DateCreated: 08/02/2019 10:14:43 Query_DateChanged: 23/02/2019 12:52:24 Query_SQL:SELECT Photos_Raw.*
FROM Photos_Raw
WHERE (((Photos_Raw.Photo_Type)="CoxesFarmGardens") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Full") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmGardens") AND (([Matching_Photo_FileName] & "")="") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmGardens") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Medium - Larger") AND ((Photos_Raw.[Exclude?])=False))
ORDER BY Year(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual])) & Right(Month(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]))+100,2) DESC , Photos_Raw.Photo_Subgroup, IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]) DESC , Photos_Raw.Photo_Timestamp DESC , Photos_Raw.Photo_ID DESC;
Link To Column Definitions: Coxes_Farm_Gardens
Query_Name: Coxes_Farm_Photos_Backup Query_Type: Select Query_DateCreated: 04/02/2019 18:37:02 Query_DateChanged: 06/02/2019 16:28:28 Query_SQL:SELECT Backup_Site_Map.Directory, Backup_Site_Map.FIle_Name, Backup_Site_Map.Size, Backup_Site_Map.File_Timestamp, Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\","") AS Expr1
FROM Backup_Site_Map
WHERE (((Backup_Site_Map.Directory) Like "*C:\Theo's Files\Photos\Coxes Farm\*") AND ((Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Coxes Farm_201307\" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Lych_Gate\" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Survey\" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Sylvia\" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Coxes Farm Selective Delapidations\"))
ORDER BY Backup_Site_Map.Directory, Backup_Site_Map.FIle_Name;
Link To Column Definitions: Coxes_Farm_Photos_Backup
Query_Name: Coxes_Farm_Pre_Repairs Query_Type: Select Query_DateCreated: 03/02/2019 12:40:34 Query_DateChanged: 23/02/2019 12:52:04 Query_SQL:SELECT Photos_Raw.*
FROM Photos_Raw
WHERE (((Photos_Raw.Photo_Type)="CoxesFarmPreRepairs") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Full") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmPreRepairs") AND (([Matching_Photo_FileName] & "")="") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmPreRepairs") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Medium - Larger") AND ((Photos_Raw.[Exclude?])=False))
ORDER BY Year(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual])) & Right(Month(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]))+100,2) DESC , Photos_Raw.Photo_Subgroup, IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]) DESC , Photos_Raw.Photo_Timestamp DESC , Photos_Raw.Photo_ID DESC;
Link To Column Definitions: Coxes_Farm_Pre_Repairs
Query_Name: Coxes_Farm_Repairs Query_Type: Select Query_DateCreated: 12/01/2019 21:42:21 Query_DateChanged: 23/02/2019 12:37:49 Query_SQL:SELECT Photos_Raw.*
FROM Photos_Raw
WHERE (((Photos_Raw.Photo_Type)="CoxesFarmRepairs") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Full") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmRepairs") AND (([Matching_Photo_FileName] & "")="") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmRepairs") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Medium - Larger") AND ((Photos_Raw.[Exclude?])=False))
ORDER BY Year(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual])) & Right(Month(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]))+100,2) DESC , Photos_Raw.Photo_Subgroup, IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]) DESC , Photos_Raw.Photo_Timestamp DESC , Photos_Raw.Photo_ID DESC;
Link To Column Definitions: Coxes_Farm_Repairs
Query_Name: Cross_Reference_By_Year Query_Type: Select Query_DateCreated: 14/05/2020 14:17:08 Query_DateChanged: 23/05/2020 11:58:13 Query_SQL:SELECT Year([Timestamp]) AS Expr1, Count(Cross_Reference.ID) AS CountOfID
FROM Cross_Reference
GROUP BY Year([Timestamp]);
Link To Column Definitions: Cross_Reference_By_Year
Query_Name: Cross_Reference_Changes_By_Month Query_Type: Select Query_DateCreated: 27/06/2020 00:46:23 Query_DateChanged: 27/06/2020 00:47:53 Query_SQL:SELECT Year([Timestamp]) & "_" & Right(100+Month([Timestamp]),2) AS Expr1, Count(Cross_Reference_Changes.ID) AS CountOfID
FROM Cross_Reference_Changes
GROUP BY Year([Timestamp]) & "_" & Right(100+Month([Timestamp]),2)
ORDER BY Year([Timestamp]) & "_" & Right(100+Month([Timestamp]),2);
Link To Column Definitions: Cross_Reference_Changes_By_Month
Query_Name: Cross_Reference_Changes_By_Year Query_Type: Select Query_DateCreated: 24/05/2020 23:27:18 Query_DateChanged: 24/05/2020 23:28:15 Query_SQL:SELECT Year([Timestamp]) AS Expr1, Count(Cross_Reference_Changes.ID) AS CountOfID
FROM Cross_Reference_Changes
GROUP BY Year([Timestamp]);
Link To Column Definitions: Cross_Reference_Changes_By_Year
Query_Name: Current_Year_Papers_Actuals_Check Query_Type: Select Query_DateCreated: 17/06/2015 09:28:08 Query_DateChanged: 17/06/2015 09:30:17 Query_SQL:SELECT qryPapers.ID, Actual_Hours_Temp.[Actual Hours]
FROM qryPapers RIGHT JOIN Actual_Hours_Temp ON qryPapers.IDs = Actual_Hours_Temp.ID
WHERE (((Actual_Hours_Temp.[Actual Hours])>0) AND ((qryPapers.IDs) Is Null));
Link To Column Definitions: Current_Year_Papers_Actuals_Check
Query_Name: Deleted_Queries Query_Type: Select Query_DateCreated: 23/06/2013 22:43:42 Query_DateChanged: 18/10/2015 17:04:11 Query_SQL:SELECT Query_Definitions_Historic.*
FROM Query_Definitions_Historic LEFT JOIN Query_Definitions ON Query_Definitions_Historic.Query_Name = Query_Definitions.Query_Name
WHERE (((Query_Definitions.Query_Name) Is Null))
ORDER BY Query_Definitions_Historic.Query_Name;
Link To Column Definitions: Deleted_Queries
Query_Name: Development_Log_Categories Query_Type: Select Query_DateCreated: 19/03/2018 20:34:55 Query_DateChanged: 04/04/2018 21:10:39 Query_SQL:SELECT Development_Log.Category
FROM Development_Log
GROUP BY Development_Log.Category;
Link To Column Definitions: Development_Log_Categories
Query_Name: Development_Log_List_Outstanding_Others_Category_Pri1 Query_Type: Select Query_DateCreated: 29/03/2018 23:58:57 Query_DateChanged: 30/03/2018 00:00:11 Query_SQL:SELECT Development_Log.Category, Development_Log.Priority, Development_Log.Status, Development_Log.Development, Development_Log.[Own_Website?], Development_Log.Raised, Development_Log.Implemented, Development_Log.Implementation_Period
FROM Development_Log
WHERE (((Development_Log.Priority)=1) AND ((Development_Log.[Own_Website?])=No) AND (([Status] & "")<>"Complete"))
ORDER BY Development_Log.Category, Development_Log.Development;
Link To Column Definitions: Development_Log_List_Outstanding_Others_Category_Pri1
Query_Name: Development_Log_List_Outstanding_Own_Category_Pri1 Query_Type: Select Query_DateCreated: 29/03/2018 23:58:03 Query_DateChanged: 24/05/2018 00:48:02 Query_SQL:SELECT Development_Log.Category, Development_Log.Priority, Development_Log.Status, Development_Log.Development, Development_Log.[Own_Website?], Development_Log.Raised, Development_Log.Implemented, Development_Log.Implementation_Period, Development_Log.ID
FROM Development_Log
WHERE (((Development_Log.Priority)=1) AND ((Development_Log.[Own_Website?])=Yes) AND (([Status] & "")<>"Complete"))
ORDER BY Development_Log.Category, Development_Log.Priority, Development_Log.Development;
Link To Column Definitions: Development_Log_List_Outstanding_Own_Category_Pri1
Query_Name: Development_Log_Search Query_Type: Select Query_DateCreated: 27/03/2018 23:23:30 Query_DateChanged: 10/08/2018 22:15:29 Query_SQL:SELECT Development_Log.*
FROM Development_Log
WHERE (((Development_Log.Category) Like "*" & [Enter String] & "*")) OR (((Development_Log.Development) Like "*" & [Enter String] & "*"))
ORDER BY Development_Log.Category, Development_Log.Development;
Link To Column Definitions: Development_Log_Search
Query_Name: Dud_Abstracts_Books Query_Type: Select Query_DateCreated: 24/11/2013 18:39:33 Query_DateChanged: 01/06/2022 20:02:17 Query_SQL:SELECT Books.Author, Books.Title, Books.Priority, Books.Status, IIf([Book_Summary_Refs]![ID1] Is Not Null,[Book_Summary],0) AS More, Left([Comments],200) AS Source, Books.Pages, Books.ID1
FROM Books LEFT JOIN Book_Summary_Refs ON Books.ID1 = Book_Summary_Refs.ID1
WHERE (((Books.Abstract) Not Like "*|Colour_*") AND (([Abstract] & "")<>"") AND ((Books.[Abstract_Fixed?])=False))
ORDER BY Books.Author, Books.Title, Books.Priority;
Link To Column Definitions: Dud_Abstracts_Books
Query_Name: Dud_Abstracts_Books (Letters) Query_Type: Select Query_DateCreated: 24/11/2013 18:46:41 Query_DateChanged: 24/11/2013 18:47:16 Query_SQL:SELECT Left([Author],1) AS Letter
FROM Dud_Abstracts_Books
GROUP BY Left([Author],1)
ORDER BY Left([Author],1);
Link To Column Definitions: Dud_Abstracts_Books (Letters)
Query_Name: Dud_Abstracts_Books_Updateable Query_Type: Select Query_DateCreated: 24/11/2013 18:48:21 Query_DateChanged: 27/11/2014 18:43:33 Query_SQL:SELECT Books.Author, Books.Title, Len([Abstract]) AS Length, Books.Priority, Books.ID1, Books.Status, Books.Comments, Books.Abstract, Books.Abstract_Quality, Books.Location, Books.Pages, Books.[Abstract_Fixed?]
FROM Books
WHERE (((Books.Abstract) Not Like "*|Colour_*") AND ((Books.[Abstract_Fixed?])=No) AND (([Abstract] & "")<>""))
ORDER BY Books.Author, Books.Title, Len([Abstract]), Books.Priority;
Link To Column Definitions: Dud_Abstracts_Books_Updateable
Query_Name: Dud_Abstracts_Papers Query_Type: Select Query_DateCreated: 24/11/2013 10:56:14 Query_DateChanged: 01/06/2022 20:01:44 Query_SQL:SELECT Papers.Author, Papers.Title, Papers.Priority, Papers.Status, IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Source, Papers.Pages, Papers.ID
FROM Papers
WHERE (((Papers.Abstract) Not Like "*|Colour_*") AND (([Abstract] & "")<>"") AND ((Papers.[Abstract_Fixed?])=False))
ORDER BY Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Dud_Abstracts_Papers
Query_Name: Dud_Abstracts_Papers (Letters) Query_Type: Select Query_DateCreated: 24/11/2013 12:11:57 Query_DateChanged: 24/11/2013 18:08:55 Query_SQL:SELECT Left([Author],1) AS Letter
FROM Dud_Abstracts_Papers
GROUP BY Left([Author],1)
ORDER BY Left([Author],1);
Link To Column Definitions: Dud_Abstracts_Papers (Letters)
Query_Name: Dud_Abstracts_Papers_Updateable Query_Type: Select Query_DateCreated: 24/11/2013 12:16:03 Query_DateChanged: 12/05/2015 10:16:00 Query_SQL:SELECT Papers.Author, Papers.Title, Len([Abstract]) AS Length, Papers.Priority, Papers.Status, Papers.Comments, Papers.Abstract, Papers.Abstract_Quality, Papers.Source, Papers.Pages, Papers.ID, Papers.[Abstract_Fixed?], Papers.Write_Up_Note_ID
FROM Papers
WHERE (((Papers.Abstract) Not Like "*|Colour_*") AND ((Papers.[Abstract_Fixed?])=No) AND (([Abstract] & "")<>""))
ORDER BY Papers.Author, Papers.Title, Len([Abstract]), Papers.Priority;
Link To Column Definitions: Dud_Abstracts_Papers_Updateable
Query_Name: Dud_Cross_References_This_Year Query_Type: Select Query_DateCreated: 23/05/2020 12:31:30 Query_DateChanged: 23/05/2020 13:06:11 Query_SQL:SELECT Year([Timestamp]) AS Timestamp_Year, Count(Cross_Reference.Timestamp) AS CountOfTimestamp, Year([Last_Run_Start]) AS Year_Last_Regen, MonthName(Month([Last_Run_Start])) AS Month_Last_Regen
FROM Cross_Reference, Website_Regen_Last_Run_Start
WHERE (((Cross_Reference.Timestamp)<[Last_Run_Start]-1))
GROUP BY Year([Timestamp]), Year([Last_Run_Start]), MonthName(Month([Last_Run_Start]));
Link To Column Definitions: Dud_Cross_References_This_Year
Query_Name: Dud_DevLog_Descriptions Query_Type: Select Query_DateCreated: 28/07/2018 21:07:27 Query_DateChanged: 28/07/2018 21:07:27 Query_SQL:SELECT *
FROM Development_Log
WHERE (((Development_Log.Development) Like "*|99|*")) OR (((Development_Log.Development) Like "*|##|*"));
Link To Column Definitions: Dud_DevLog_Descriptions
Query_Name: Dup_Papers Query_Type: Select Query_DateCreated: 26/11/2005 10:22:02 Query_DateChanged: 26/11/2005 10:39:24 Query_SQL:SELECT Papers.Author, Papers.Title, Papers.ID AS ID, Papers.Pages AS Pages, Papers.Book AS Book, Papers.Comments AS Comments
FROM (Dup_Papers1 INNER JOIN Papers ON (Dup_Papers1.Title = Papers.Title) AND (Dup_Papers1.Author = Papers.Author)) INNER JOIN Papers AS Papers_1 ON (Dup_Papers1.Title = Papers_1.Title) AND (Dup_Papers1.Author = Papers_1.Author)
WHERE (((Papers.ID)<>[Papers_1]![ID]))
ORDER BY Papers.Author, Papers.Title, Papers.Book;
Link To Column Definitions: Dup_Papers
Query_Name: Dup_Papers1 Query_Type: Select Query_DateCreated: 26/11/2005 10:19:12 Query_DateChanged: 26/11/2005 10:19:16 Query_SQL:SELECT Papers.Author, Papers.Title, Count(Papers.ID) AS CountOfID
FROM Papers INNER JOIN Papers AS Papers_1 ON (Papers.Title = Papers_1.Title) AND (Papers.Author = Papers_1.Author)
GROUP BY Papers.Author, Papers.Title
HAVING (((Count(Papers.ID))>1))
ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Dup_Papers1
Query_Name: Duplicate_Papers_Prelist Query_Type: Select Query_DateCreated: 05/06/2021 15:59:51 Query_DateChanged: 05/06/2021 16:13:49 Query_SQL:SELECT Papers.Author, Papers.Title, Count(Papers.ID) AS CountOfID
FROM Papers
GROUP BY Papers.Author, Papers.Title
HAVING (((Count(Papers.ID))>1));
Link To Column Definitions: Duplicate_Papers_Prelist
Query_Name: Earliest_Lang Query_Type: Select Query_DateCreated: 13/11/2020 10:45:55 Query_DateChanged: 12/12/2020 12:46:19 Query_SQL:SELECT Language_Location_Primer.Priority, Min(IIf([Date_Last_Study]>"0",[Date_Last_Study],"999999999")) AS Aeon, Min(Language_Location_Primer.[Date_Last_Study_Non_Ling]) AS Non_Aeon
FROM Language_Location_Primer INNER JOIN Language_Animadversions_Counts_Prelist ON Language_Location_Primer.Language = Language_Animadversions_Counts_Prelist.Language
GROUP BY Language_Location_Primer.Priority
HAVING (((Language_Location_Primer.Priority)>0));
Link To Column Definitions: Earliest_Lang
Query_Name: Earliest_Lang_Dates_Non_Ling Query_Type: Select Query_DateCreated: 11/12/2020 12:50:47 Query_DateChanged: 02/03/2022 19:50:50 Query_SQL:SELECT "Non-Ling" AS Category, Language_Location_Primer.Priority, Val(IIf([Date_Last_Study_Non_Ling] & ""="",0,[Date_Last_Study_Non_Ling])) AS [Date], Language_Location_Primer.Language, "" AS Ling_Progress, "" AS Ling_Revision_Progress
FROM Language_Location_Primer INNER JOIN Language_Animadversions_Counts_Prelist ON Language_Location_Primer.Language_Key = Language_Animadversions_Counts_Prelist.Language
ORDER BY Language_Location_Primer.Priority, Val(IIf([Date_Last_Study_Non_Ling] & ""="",0,[Date_Last_Study_Non_Ling])), Language_Location_Primer.Language;
Link To Column Definitions: Earliest_Lang_Dates_Non_Ling
Query_Name: Electronic Resources Query_Type: Select Query_DateCreated: 07/05/2007 10:45:58 Query_DateChanged: 07/05/2007 11:11:36 Query_SQL:SELECT ElectronicPapers.*
FROM ElectronicPapers
ORDER BY ElectronicPapers.Publication;
Link To Column Definitions: Electronic Resources
Query_Name: Electronic Resources (Letters) Query_Type: Select Query_DateCreated: 07/05/2007 10:46:10 Query_DateChanged: 07/05/2007 11:11:31 Query_SQL:SELECT Left([Publication],1) AS Letter
FROM ElectronicPapers
GROUP BY Left([Publication],1)
ORDER BY Left([Publication],1);
Link To Column Definitions: Electronic Resources (Letters)
Query_Name: Full_Backup_Site_Map_Temp_Delete_Control Query_Type: Select Query_DateCreated: 07/12/2022 12:36:58 Query_DateChanged: 07/12/2022 20:01:35 Query_SQL:SELECT Full_Backup_Directory_Structure_Temp.Directory, Full_Backup_Site_Map_Temp.File_Name, Full_Backup_Site_Map_Temp.Delete, Full_Backup_Site_Map_Temp.Deleted, Full_Backup_Site_Map_Temp.Deletion_Failed
FROM Full_Backup_Site_Map_Temp INNER JOIN Full_Backup_Directory_Structure_Temp ON Full_Backup_Site_Map_Temp.Directory_ID = Full_Backup_Directory_Structure_Temp.Directory_ID
WHERE (((Full_Backup_Site_Map_Temp.Delete)=Yes) AND ((Full_Backup_Site_Map_Temp.Deleted)=No))
ORDER BY Full_Backup_Directory_Structure_Temp.Directory, Full_Backup_Site_Map_Temp.File_Name;
Link To Column Definitions: Full_Backup_Site_Map_Temp_Delete_Control
Query_Name: Full_Backup_Site_Map_Temp_Delete_Failed Query_Type: Select Query_DateCreated: 07/12/2022 16:20:21 Query_DateChanged: 07/12/2022 19:57:42 Query_SQL:SELECT Full_Backup_Site_Map_Temp_Delete_Control.Directory, Full_Backup_Site_Map_Temp_Delete_Control.File_Name, Full_Backup_Site_Map_Temp_Delete_Control.Delete, Full_Backup_Site_Map_Temp_Delete_Control.Deleted, Full_Backup_Site_Map_Temp_Delete_Control.Deletion_Failed
FROM Full_Backup_Site_Map_Temp_Delete_Control
WHERE (((Full_Backup_Site_Map_Temp_Delete_Control.Deletion_Failed)=Yes))
ORDER BY Full_Backup_Site_Map_Temp_Delete_Control.File_Name, Full_Backup_Site_Map_Temp_Delete_Control.Directory;
Link To Column Definitions: Full_Backup_Site_Map_Temp_Delete_Failed
Query_Name: Home_Page_Static_Page_Backups Query_Type: Select Query_DateCreated: 07/01/2016 09:48:12 Query_DateChanged: 07/01/2016 10:09:06 Query_SQL:SELECT Full_Backup_Site_Map_Temp.*
FROM Full_Backup_Site_Map_Temp
WHERE (((Full_Backup_Site_Map_Temp.File_Name) Like "*phil0*") AND ((Full_Backup_Site_Map_Temp.[Delete?])=False) AND ((Right([File_Name],4))=".htm"))
ORDER BY Full_Backup_Site_Map_Temp.File_Name, Full_Backup_Site_Map_Temp.File_Timestamp DESC;
Link To Column Definitions: Home_Page_Static_Page_Backups
Query_Name: Identity Papers - Abstracts - Full Query_Type: Select Query_DateCreated: 29/04/2007 11:03:07 Query_DateChanged: 18/09/2013 18:26:19 Query_SQL:SELECT Papers.Author, Papers.Title, Papers.Priority, [Sub-Topics].[Sub-Topic], IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Source, Papers.Pages, IIf([Papers]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")) AS [Read?], Papers.ID
FROM Papers INNER JOIN [Sub-Topics] ON Papers.[Sub-Topic] = [Sub-Topics].ID
WHERE (((Papers.Author)<>"Admin") AND ((Papers.Topic)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.Topic2)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.Topic3)=104))
ORDER BY Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Identity Papers - Abstracts - Full
Query_Name: Identity Papers - Abstracts - Full (Letters) Query_Type: Select Query_DateCreated: 05/05/2007 12:23:46 Query_DateChanged: 18/09/2013 18:27:05 Query_SQL:SELECT Left([Author],1) AS Letter
FROM Papers
WHERE (((Papers.Topic)=104)) OR (((Papers.Topic2)=104)) OR (((Papers.Topic3)=104))
GROUP BY Left([Author],1)
ORDER BY Left([Author],1);
Link To Column Definitions: Identity Papers - Abstracts - Full (Letters)
Query_Name: Identity Papers - Abstracts - Read Query_Type: Select Query_DateCreated: 27/11/2005 11:36:21 Query_DateChanged: 18/09/2013 18:27:34 Query_SQL:SELECT Papers.Author, Papers.Title, Papers.Priority, [Sub-Topics].[Sub-Topic], IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Source, Papers.Pages, Papers.ID
FROM Papers INNER JOIN [Sub-Topics] ON Papers.[Sub-Topic] = [Sub-Topics].ID
WHERE (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes) AND ((Papers.Topic)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes) AND ((Papers.Topic2)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes) AND ((Papers.Topic3)=104))
ORDER BY Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Identity Papers - Abstracts - Read
Query_Name: Identity Papers - Abstracts - Read (Letters) Query_Type: Select Query_DateCreated: 05/05/2007 16:43:05 Query_DateChanged: 18/09/2013 18:38:09 Query_SQL:SELECT Left([Author],1) AS Letter
FROM Papers
WHERE (((Papers.[Read?])=Yes) AND ((Papers.Topic)=104))
GROUP BY Left([Author],1)
ORDER BY Left([Author],1);
Link To Column Definitions: Identity Papers - Abstracts - Read (Letters)
Query_Name: Identity_Papers_SubTopic_All Query_Type: Select Query_DateCreated: 12/04/2009 18:42:00 Query_DateChanged: 12/04/2009 18:42:00 Query_SQL:SELECT Identity_Papers_SubTopic_Union.ID, Identity_Papers_SubTopic_Union.[Sub-Topic]
FROM Identity_Papers_SubTopic_Union
GROUP BY Identity_Papers_SubTopic_Union.ID, Identity_Papers_SubTopic_Union.[Sub-Topic];
Link To Column Definitions: Identity_Papers_SubTopic_All
Query_Name: Identity_Papers_SubTopic2 Query_Type: Select Query_DateCreated: 12/04/2009 18:38:31 Query_DateChanged: 18/09/2013 18:39:19 Query_SQL:SELECT Papers.ID, Papers.[Sub-Topic2] AS [Sub-Topic]
FROM Papers INNER JOIN Paper_Topic_All ON Papers.ID = Paper_Topic_All.ID
WHERE (((Papers.[Sub-Topic2]) Is Not Null) AND ((Paper_Topic_All.Topic)=104));
Link To Column Definitions: Identity_Papers_SubTopic2
Query_Name: Identity_Papers_SubTopic3 Query_Type: Select Query_DateCreated: 12/04/2009 18:39:11 Query_DateChanged: 18/09/2013 18:39:40 Query_SQL:SELECT Papers.ID, Papers.[Sub-Topic3] AS [Sub-Topic]
FROM Papers INNER JOIN Paper_Topic_All ON Papers.ID = Paper_Topic_All.ID
WHERE (((Papers.[Sub-Topic3]) Is Not Null) AND ((Paper_Topic_All.Topic)=104));
Link To Column Definitions: Identity_Papers_SubTopic3
Query_Name: IdentityBooks_Unreferenced Query_Type: Select Query_DateCreated: 12/03/2021 21:00:54 Query_DateChanged: 12/03/2021 21:45:30 Query_SQL:SELECT IIf([Books]![Read?]=Yes,"Yes","") AS [Read?], [Sub-Topics].[Sub-Topic] AS [Sub-Topic1], [Sub-Topics_1].[Sub-Topic] AS [Sub-Topic2], [Sub-Topics_2].[Sub-Topic] AS [Sub-Topic3], "+B" & [ID1] & "B+" AS [Book Link]
FROM (((Books LEFT JOIN PID_Note_Reading_Lists_Books ON Books.ID1 = PID_Note_Reading_Lists_Books.Called_ID) INNER JOIN [Sub-Topics] ON Books.[Sub-Topic] = [Sub-Topics].ID) LEFT JOIN [Sub-Topics] AS [Sub-Topics_1] ON Books.[Sub-Topic2] = [Sub-Topics_1].ID) LEFT JOIN [Sub-Topics] AS [Sub-Topics_2] ON Books.[Sub-Topic3] = [Sub-Topics_2].ID
WHERE (((Books.Topic)=104) AND ((PID_Note_Reading_Lists_Books.Called_ID) Is Null)) OR (((PID_Note_Reading_Lists_Books.Called_ID) Is Null) AND ((Books.Topic2)=104)) OR (((PID_Note_Reading_Lists_Books.Called_ID) Is Null) AND ((Books.Topic3)=104))
ORDER BY IIf([Books]![Read?]=Yes,"Yes","") DESC , [Sub-Topics].[Sub-Topic], Books.Author, Books.Title;
Link To Column Definitions: IdentityBooks_Unreferenced
Query_Name: IdentityPapersRead Query_Type: Select Query_DateCreated: 10/03/2021 09:42:21 Query_DateChanged: 10/03/2021 09:48:59 Query_SQL:SELECT Papers.Author, Papers.Title, Papers.ID, Papers.Source, Papers.Book_ID, Papers.Priority, [Sub-Topics].[Sub-Topic], IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Pages
FROM Papers INNER JOIN [Sub-Topics] ON Papers.[Sub-Topic] = [Sub-Topics].ID
WHERE (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes) AND ((Papers.Topic)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes) AND ((Papers.Topic2)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes) AND ((Papers.Topic3)=104))
ORDER BY Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: IdentityPapersRead
Query_Name: IdentityPapersRead_Unreferenced Query_Type: Select Query_DateCreated: 10/03/2021 09:47:23 Query_DateChanged: 30/03/2021 13:58:26 Query_SQL:SELECT IIf([PID_Note_Reading_Lists_Books]![Called_ID] & ""="","",IIf([Read?]=True,"Yes - but Book read","Yes")) AS [Book Cited?], IdentityPapersRead.[Sub-Topic], "+P" & [ID] & "P+" AS [Paper Link], "+B" & [IdentityPapersRead]![Book_ID] & "B+" AS [Book Link], IdentityPapersRead.Priority
FROM ((IdentityPapersRead LEFT JOIN PID_Note_Reading_Lists_Books ON IdentityPapersRead.Book_ID = PID_Note_Reading_Lists_Books.Called_ID) LEFT JOIN PID_Note_Reading_Lists_Papers ON IdentityPapersRead.ID = PID_Note_Reading_Lists_Papers.Called_ID) LEFT JOIN Book_Paper_Solitons ON PID_Note_Reading_Lists_Books.Called_ID = Book_Paper_Solitons.Book_ID
WHERE (((IIf([PID_Note_Reading_Lists_Books]![Called_ID] & ""="","",IIf([Read?]=True,"Yes - but Book read","Yes")))<>"Yes - but Book read") AND ((IdentityPapersRead.Author)<>"Todman (Theo)") AND (([CountOfPaper_ID] & IIf([PID_Note_Reading_Lists_Books]![Called_ID] & ""="","","Yes"))<>"1Yes") AND ((PID_Note_Reading_Lists_Papers.Called_ID) Is Null))
ORDER BY IIf([PID_Note_Reading_Lists_Books]![Called_ID] & ""="","",IIf([Read?]=True,"Yes - but Book read","Yes")), IdentityPapersRead.[Sub-Topic], IdentityPapersRead.Author, IdentityPapersRead.Title;
Link To Column Definitions: IdentityPapersRead_Unreferenced
Query_Name: Image_Usage Query_Type: Select Query_DateCreated: 22/06/2013 10:57:36 Query_DateChanged: 25/06/2013 00:10:05 Query_SQL:SELECT Site_Map.*
FROM Site_Map
WHERE (((Site_Map.FIle_Name) Like "*.jpg*" Or (Site_Map.FIle_Name) Like "*.gif*"))
ORDER BY Site_Map.Directory, Site_Map.FIle_Name;
Link To Column Definitions: Image_Usage
Query_Name: Koran_Latest_Prelist_1 Query_Type: Select Query_DateCreated: 14/11/2022 13:06:11 Query_DateChanged: 14/11/2022 13:06:11 Query_SQL:SELECT Max(Koran.Surah) AS MaxOfSurah
FROM Koran
WHERE (((Koran.Verses_Read_English)>0));
Link To Column Definitions: Koran_Latest_Prelist_1
Query_Name: Koran_Reading_Summary Query_Type: Select Query_DateCreated: 14/11/2022 13:32:10 Query_DateChanged: 27/12/2022 19:16:21 Query_SQL:SELECT "Koran" AS OT_NT_LXX, Sum(Koran.Verses) AS [Total Verses], Sum(Koran.Verses_Read_English) AS [Verses Read], Bible_Completion_Dates_Aim.Start_Date AS Start
FROM Koran, Bible_Completion_Dates_Aim
WHERE (((Bible_Completion_Dates_Aim.OT_NT_LXX)="Koran"))
GROUP BY "Koran", Bible_Completion_Dates_Aim.Start_Date;
Link To Column Definitions: Koran_Reading_Summary
Query_Name: Language_Animadversions_Counts Query_Type: Select Query_DateCreated: 26/11/2020 13:32:04 Query_DateChanged: 26/11/2020 13:32:04 Query_SQL:SELECT Language_Animadversions_Counts_Prelist.Priority, Count(Language_Animadversions_Counts_Prelist.Language) AS CountOfLanguage
FROM Language_Animadversions_Counts_Prelist
GROUP BY Language_Animadversions_Counts_Prelist.Priority;
Link To Column Definitions: Language_Animadversions_Counts
Query_Name: Language_Animadversions_Counts_Prelist Query_Type: Select Query_DateCreated: 26/11/2020 13:25:39 Query_DateChanged: 26/11/2020 13:30:09 Query_SQL:SELECT Language_Location_Primer.Priority, Language_Animadversions.Language, Count(Language_Animadversions.ID) AS CountOfID
FROM Language_Animadversions INNER JOIN Language_Location_Primer ON Language_Animadversions.Language = Language_Location_Primer.Language_Key
GROUP BY Language_Location_Primer.Priority, Language_Animadversions.Language
ORDER BY Language_Location_Primer.Priority, Language_Animadversions.Language;
Link To Column Definitions: Language_Animadversions_Counts_Prelist
Query_Name: Language_Animadversions_List1 Query_Type: Select Query_DateCreated: 27/10/2020 00:47:11 Query_DateChanged: 28/10/2020 21:27:22 Query_SQL:SELECT Language_Animadversions.Language, Language_Animadversions.ID, Language_Animadversions.Date_Raised AS [Date Raised], Language_Animadversions.Animadversion
FROM Language_Animadversions
ORDER BY IIf([Language]="General",0,1), Language_Animadversions.Language, Language_Animadversions.Date_Raised;
Link To Column Definitions: Language_Animadversions_List1
Query_Name: Language_Animadversions_XRef1 Query_Type: Select Query_DateCreated: 28/10/2020 19:57:53 Query_DateChanged: 24/01/2021 23:18:09 Query_SQL:SELECT Language_Animadversions.Language, Language_Location_Primer.Resources_Books, Language_Location_Primer.Resources_Papers, Format([Language_Location_Primer]![Date_Last_Study],"Medium Date") AS Date_Last_Study, Language_Location_Primer.Time_This_Year, IIf([Date_Last_Study_Non_Ling]>"0",Format([Language_Location_Primer]![Date_Last_Study_Non_Ling],"Medium Date"),"None") AS Date_Last_Study_NonLing, Language_Location_Primer.[50Lang_ID]
FROM Language_Animadversions LEFT JOIN Language_Location_Primer ON Language_Animadversions.Language = Language_Location_Primer.Language_Key
GROUP BY Language_Animadversions.Language, Language_Location_Primer.Resources_Books, Language_Location_Primer.Resources_Papers, Format([Language_Location_Primer]![Date_Last_Study],"Medium Date"), Language_Location_Primer.Time_This_Year, IIf([Date_Last_Study_Non_Ling]>"0",Format([Language_Location_Primer]![Date_Last_Study_Non_Ling],"Medium Date"),"None"), Language_Location_Primer.[50Lang_ID]
ORDER BY Language_Animadversions.Language;
Link To Column Definitions: Language_Animadversions_XRef1
Query_Name: Large_Page_List Query_Type: Select Query_DateCreated: 02/06/2021 21:07:14 Query_DateChanged: 03/06/2021 21:44:23 Query_SQL:SELECT Site_Map.Full_File_Name AS [File Name], Site_Map.Timestamp_Logged AS [Timestamp], Round([Size]/1024/1024,1) AS Mb, Page_Raw_Link_Counts.CountOfRaw_Link AS Links, "" AS [Note]
FROM Site_Map INNER JOIN Page_Raw_Link_Counts ON (Site_Map.FIle_Name = Page_Raw_Link_Counts.File_Name) AND (Site_Map.Directory = Page_Raw_Link_Counts.Directory)
ORDER BY Page_Raw_Link_Counts.CountOfRaw_Link DESC;
Link To Column Definitions: Large_Page_List
Query_Name: Latest_Archives Query_Type: Select Query_DateCreated: 06/12/2009 10:37:01 Query_DateChanged: 31/07/2013 11:02:37 Query_SQL:SELECT Notes_Archive.ID, Notes_Archive.Item_Title, Notes_Archive.Item_Text, Notes_Archive.Note_Group, Notes_Archive.Last_Changed, Notes_Archive.Timestamp, Now()*1-[Timestamp]/1000 AS Age, System_Parameters.Notes_Archive_Days
FROM Notes_Archive, System_Parameters
WHERE (((Now()*1-[Timestamp]/1000)<[Notes_Archive_Days]))
ORDER BY Now()*1-[Timestamp]/1000;
Link To Column Definitions: Latest_Archives
Query_Name: Ling_Dialogue_Lesson_Counts Query_Type: Select Query_DateCreated: 13/04/2021 23:30:36 Query_DateChanged: 13/04/2021 23:49:21 Query_SQL:SELECT "Dialogue" AS Type, Ling_Dialogue_Language.Language, Count(Ling_Dialogue_Language.Lesson_ID) AS Lessons
FROM Language_Location_Primer INNER JOIN Ling_Dialogue_Language ON Language_Location_Primer.Language_Key = Ling_Dialogue_Language.Language
WHERE (((Ling_Dialogue_Language.Dialogue_ID)=1) AND ((Ling_Dialogue_Language.Phrase_ID)=1) AND ((Ling_Dialogue_Language.Phrase_Language)<>""))
GROUP BY "Dialogue", Ling_Dialogue_Language.Language
ORDER BY "Dialogue", Ling_Dialogue_Language.Language;
Link To Column Definitions: Ling_Dialogue_Lesson_Counts
Query_Name: Ling_English_Categories Query_Type: Select Query_DateCreated: 19/08/2021 00:02:49 Query_DateChanged: 19/08/2021 00:02:49 Query_SQL:SELECT Ling_English_Category_Extras.Category, Count(Ling_English_Category_Extras.Vocab_English) AS CountOfVocab_English
FROM Ling_English_Category_Extras
GROUP BY Ling_English_Category_Extras.Category
ORDER BY Ling_English_Category_Extras.Category;
Link To Column Definitions: Ling_English_Categories
Query_Name: Ling_English_Category_Categories Query_Type: Select Query_DateCreated: 14/07/2022 09:11:55 Query_DateChanged: 14/07/2022 09:12:33 Query_SQL:SELECT Ling_English_Category_Extras.Category
FROM Ling_English_Category_Extras
GROUP BY Ling_English_Category_Extras.Category;
Link To Column Definitions: Ling_English_Category_Categories
Query_Name: Ling_English_Category_Extras_Editable Query_Type: Select Query_DateCreated: 14/07/2022 09:08:27 Query_DateChanged: 14/07/2022 09:34:47 Query_SQL:SELECT Ling_English_Category_Extras.Category, Ling_English_Category_Extras.Vocab_English
FROM Ling_English_Category_Extras
WHERE (((Ling_English_Category_Extras.Category)="Unclassified"))
ORDER BY Ling_English_Category_Extras.Vocab_English;
Link To Column Definitions: Ling_English_Category_Extras_Editable
Query_Name: Ling_Language_Dialogue_List_All_Prelist Query_Type: Select Query_DateCreated: 16/04/2021 23:23:24 Query_DateChanged: 16/04/2021 23:34:59 Query_SQL:SELECT Ling_Dialogue_English.Lesson_ID AS Lesson, Ling_Dialogue_English.Dialogue_ID AS Dialogue, Ling_Dialogue_English.Phrase_ID AS ID, Ling_Dialogue_English.[A/B], Ling_Dialogue_English.Phrase_English AS English, Ling_Dialogue_Language.Language, Ling_Dialogue_Language.Phrase_Language AS Phrase, Ling_Dialogue_Language.Phrase_Transliteration_Language AS Transliteration, Language_Location_Primer.Lang_Group, Language_Location_Primer.[Non_Latin_Script?]
FROM ((Ling_Dialogue_Language INNER JOIN Ling_Dialogue_English ON (Ling_Dialogue_Language.Phrase_ID = Ling_Dialogue_English.Phrase_ID) AND (Ling_Dialogue_Language.Dialogue_ID = Ling_Dialogue_English.Dialogue_ID) AND (Ling_Dialogue_Language.Lesson_ID = Ling_Dialogue_English.Lesson_ID)) INNER JOIN Language_Location_Primer ON Ling_Dialogue_Language.Language = Language_Location_Primer.Language_Key) INNER JOIN Ling_Lessons ON Ling_Dialogue_English.Lesson_ID = Ling_Lessons.Lesson_ID
WHERE (((Ling_Dialogue_Language.Phrase_Language)<>""))
ORDER BY Ling_Dialogue_English.Lesson_ID, Ling_Dialogue_English.Dialogue_ID, Ling_Dialogue_English.Phrase_ID, Ling_Dialogue_Language.Language;
Link To Column Definitions: Ling_Language_Dialogue_List_All_Prelist
Query_Name: Ling_Language_Dialogue_List_Latin Query_Type: Select Query_DateCreated: 14/04/2021 16:15:28 Query_DateChanged: 17/04/2021 23:15:34 Query_SQL:SELECT Ling_Dialogue_Language.Language, [Ling_Lessons]![Lesson_ID] AS Lesson, Ling_Dialogue_English.Dialogue_ID AS Dialogue, Ling_Dialogue_English.Phrase_ID AS ID, Ling_Dialogue_English.[A/B] AS Speaker, Ling_Dialogue_English.Phrase_English AS English, Ling_Dialogue_Language.Phrase_Language AS Phrase
FROM ((Ling_Dialogue_English INNER JOIN Ling_Dialogue_Language ON (Ling_Dialogue_English.Phrase_ID = Ling_Dialogue_Language.Phrase_ID) AND (Ling_Dialogue_English.Dialogue_ID = Ling_Dialogue_Language.Dialogue_ID) AND (Ling_Dialogue_English.Lesson_ID = Ling_Dialogue_Language.Lesson_ID)) INNER JOIN Ling_Lessons ON Ling_Dialogue_English.Lesson_ID = Ling_Lessons.Lesson_ID) INNER JOIN Language_Location_Primer ON Ling_Dialogue_Language.Language = Language_Location_Primer.Language_Key
WHERE (((Ling_Dialogue_Language.Phrase_Language)<>"") AND ((Language_Location_Primer.[Non_Latin_Script?])=False))
ORDER BY Ling_Dialogue_Language.Language, Ling_Dialogue_English.Lesson_ID, Ling_Dialogue_English.Dialogue_ID, Ling_Dialogue_English.Phrase_ID;
Link To Column Definitions: Ling_Language_Dialogue_List_Latin
Query_Name: Ling_Language_Dialogue_List_NonLatin Query_Type: Select Query_DateCreated: 14/04/2021 16:04:30 Query_DateChanged: 01/07/2023 00:02:02 Query_SQL:SELECT Ling_Dialogue_Language.Language, [Ling_Lessons]![Lesson_ID] AS Lesson, Ling_Dialogue_English.Dialogue_ID AS Dialogue, Ling_Dialogue_English.Phrase_ID AS ID, Ling_Dialogue_English.[A/B] AS Speaker, Ling_Dialogue_English.Phrase_English AS English, Ling_Dialogue_Language.Phrase_Transliteration_Language AS [Phrase Transliteration], Ling_Dialogue_Language.Phrase_Language AS Phrase
FROM ((Ling_Dialogue_English INNER JOIN Ling_Dialogue_Language ON (Ling_Dialogue_English.Phrase_ID = Ling_Dialogue_Language.Phrase_ID) AND (Ling_Dialogue_English.Dialogue_ID = Ling_Dialogue_Language.Dialogue_ID) AND (Ling_Dialogue_English.Lesson_ID = Ling_Dialogue_Language.Lesson_ID)) INNER JOIN Ling_Lessons ON Ling_Dialogue_English.Lesson_ID = Ling_Lessons.Lesson_ID) INNER JOIN Language_Location_Primer ON Ling_Dialogue_Language.Language = Language_Location_Primer.Language_Key
WHERE (((Ling_Dialogue_Language.Phrase_Language)<>"") AND ((Language_Location_Primer.[Non_Latin_Script?])=True))
ORDER BY Ling_Dialogue_Language.Language, Ling_Dialogue_English.Lesson_ID, Ling_Dialogue_English.Dialogue_ID, Ling_Dialogue_English.Phrase_ID;
Link To Column Definitions: Ling_Language_Dialogue_List_NonLatin
Query_Name: Ling_Language_Vocab_List_All_Prelist_1_ru_uk Query_Type: Select Query_DateCreated: 28/03/2022 17:55:05 Query_DateChanged: 22/06/2023 18:07:04 Query_SQL:SELECT Ling_Language_Vocab_List_All_Prelist_1.*
FROM Ling_Language_Vocab_List_All_Prelist_1
WHERE (((Ling_Language_Vocab_List_All_Prelist_1.Language)="Russian" Or (Ling_Language_Vocab_List_All_Prelist_1.Language)="Ukrainian" Or (Ling_Language_Vocab_List_All_Prelist_1.Language)="Polish"));
Link To Column Definitions: Ling_Language_Vocab_List_All_Prelist_1_ru_uk
Query_Name: Ling_Language_Vocab_List_Latin Query_Type: Select Query_DateCreated: 14/04/2021 15:22:22 Query_DateChanged: 14/04/2021 23:32:01 Query_SQL:SELECT Ling_Vocabulary_Langauge.Language, [Ling_Lessons]![Lesson_ID] AS Lesson, Ling_Vocabulary_English.Vocab_ID AS Item, Ling_Vocabulary_English.Vocab_English AS English, Ling_Vocabulary_Langauge.Vocab_Language AS Vocabulary, Ling_Vocabulary_English.Phrase_English AS [English Phrase], Ling_Vocabulary_Langauge.Phrase_Language AS Phrase
FROM ((Ling_Lessons INNER JOIN Ling_Vocabulary_English ON Ling_Lessons.Lesson_ID = Ling_Vocabulary_English.Lesson_ID) INNER JOIN Ling_Vocabulary_Langauge ON (Ling_Vocabulary_English.Vocab_ID = Ling_Vocabulary_Langauge.Vocab_ID) AND (Ling_Vocabulary_English.Lesson_ID = Ling_Vocabulary_Langauge.Lesson_ID)) INNER JOIN Language_Location_Primer ON Ling_Vocabulary_Langauge.Language = Language_Location_Primer.Language_Key
WHERE (((Ling_Vocabulary_Langauge.Vocab_Language)<>"") AND ((Language_Location_Primer.[Non_Latin_Script?])=False))
ORDER BY Ling_Vocabulary_Langauge.Language, Ling_Vocabulary_English.Lesson_ID, Ling_Vocabulary_English.Vocab_ID;
Link To Column Definitions: Ling_Language_Vocab_List_Latin
Query_Name: Ling_Language_Vocab_List_NonLatin Query_Type: Select Query_DateCreated: 14/04/2021 00:59:22 Query_DateChanged: 30/06/2023 23:59:14 Query_SQL:SELECT Ling_Vocabulary_Langauge.Language, [Ling_Lessons]![Lesson_ID] AS Lesson, Ling_Vocabulary_English.Vocab_ID AS Item, Ling_Vocabulary_English.Vocab_English AS English, Ling_Vocabulary_Langauge.Vocab_Transliteration_Language AS [Vocabulary Transliteration], Ling_Vocabulary_English.Phrase_English AS [English Phrase], Ling_Vocabulary_Langauge.Phrase_Transliteration_Language AS [Phrase Transliteration], Ling_Vocabulary_Langauge.Vocab_Language AS Vocabulary, Ling_Vocabulary_Langauge.Phrase_Language AS Phrase
FROM ((Ling_Lessons INNER JOIN Ling_Vocabulary_English ON Ling_Lessons.Lesson_ID = Ling_Vocabulary_English.Lesson_ID) INNER JOIN Ling_Vocabulary_Langauge ON (Ling_Vocabulary_English.Vocab_ID = Ling_Vocabulary_Langauge.Vocab_ID) AND (Ling_Vocabulary_English.Lesson_ID = Ling_Vocabulary_Langauge.Lesson_ID)) INNER JOIN Language_Location_Primer ON Ling_Vocabulary_Langauge.Language = Language_Location_Primer.Language_Key
WHERE (((Ling_Vocabulary_Langauge.Vocab_Language)<>"") AND ((Language_Location_Primer.[Non_Latin_Script?])=True))
ORDER BY Ling_Vocabulary_Langauge.Language, Ling_Vocabulary_English.Lesson_ID, Ling_Vocabulary_English.Vocab_ID;
Link To Column Definitions: Ling_Language_Vocab_List_NonLatin
Query_Name: Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk Query_Type: Select Query_DateCreated: 28/03/2022 14:29:19 Query_DateChanged: 22/06/2023 18:06:35 Query_SQL:SELECT Ling_Language_Vocab_Phrase_List_All_Prelist_1.*
FROM Ling_Language_Vocab_Phrase_List_All_Prelist_1
WHERE (((Ling_Language_Vocab_Phrase_List_All_Prelist_1.Language)="Ukrainian" Or (Ling_Language_Vocab_Phrase_List_All_Prelist_1.Language)="Russian" Or (Ling_Language_Vocab_Phrase_List_All_Prelist_1.Language)="Polish"));
Link To Column Definitions: Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk
Query_Name: Ling_Progress Query_Type: Select Query_DateCreated: 18/04/2021 14:10:58 Query_DateChanged: 25/08/2021 12:53:49 Query_SQL:SELECT Language_Location_Primer.Priority, Language_Location_Primer.Ling_Progress, Language_Location_Primer.Language_Key, Language_Location_Primer.Ling_Revision_Progress
FROM Language_Location_Primer
WHERE (((Language_Location_Primer.Ling_Progress)>0))
ORDER BY Language_Location_Primer.Priority, Language_Location_Primer.Ling_Progress, Language_Location_Primer.Ling_Revision_Progress, Language_Location_Primer.Language_Key;
Link To Column Definitions: Ling_Progress
Query_Name: Ling_Vocab_Lesson_Counts Query_Type: Select Query_DateCreated: 13/04/2021 23:29:51 Query_DateChanged: 13/04/2021 23:43:08 Query_SQL:SELECT "Vocabulary" AS Type, Ling_Vocabulary_Langauge.Language, Count(Ling_Vocabulary_Langauge.Lesson_ID) AS Lessons
FROM Ling_Vocabulary_Langauge INNER JOIN Language_Location_Primer ON Ling_Vocabulary_Langauge.Language = Language_Location_Primer.Language_Key
WHERE (((Ling_Vocabulary_Langauge.Vocab_ID)=1) AND ((Ling_Vocabulary_Langauge.Vocab_Language)<>""))
GROUP BY "Vocabulary", Ling_Vocabulary_Langauge.Language
ORDER BY "Vocabulary", Ling_Vocabulary_Langauge.Language;
Link To Column Definitions: Ling_Vocab_Lesson_Counts
Query_Name: Location_Group_IDs Query_Type: Select Query_DateCreated: 09/09/2013 11:49:43 Query_DateChanged: 09/09/2013 11:49:43 Query_SQL:SELECT Locations.Location_Group, Min(Locations.ID) AS MinOfID
FROM Locations
GROUP BY Locations.Location_Group
ORDER BY Locations.Location_Group;
Link To Column Definitions: Location_Group_IDs
Query_Name: Location_Supergroup_IDs Query_Type: Select Query_DateCreated: 09/09/2013 11:49:01 Query_DateChanged: 09/09/2013 11:49:02 Query_SQL:SELECT Locations.Location_SuperGroup, Min(Locations.ID) AS MinOfID
FROM Locations
GROUP BY Locations.Location_SuperGroup
ORDER BY Locations.Location_SuperGroup;
Link To Column Definitions: Location_Supergroup_IDs
Query_Name: Missing Priority Tasks For Timesheet Query_Type: Select Query_DateCreated: 23/10/2009 11:39:41 Query_DateChanged: 14/04/2014 08:56:06 Query_SQL:SELECT qrySources.IDs, qrySources.[A+T] AS Paper, GetTopic([Papers]![Topic],[Papers]![Topic2],[Papers]![Topic3]) AS Subject, qrySources.[Sub-Topic], Nz([qrySources]![Hours Left]) AS Estimate
FROM (Papers INNER JOIN qrySources ON Papers.ID = qrySources.ID1) LEFT JOIN Subject_Plan ON qrySources.IDs = Subject_Plan.ID
WHERE (((qrySources.IDs) Like "T*") AND ((Subject_Plan.ID) Is Null) AND ((qrySources.Priority)=0))
ORDER BY GetTopic([Papers]![Topic],[Papers]![Topic2],[Papers]![Topic3]), qrySources.[Sub-Topic], qrySources.[A+T];
Link To Column Definitions: Missing Priority Tasks For Timesheet
Query_Name: Missing_Papers_For_Actuals Query_Type: Select Query_DateCreated: 17/06/2015 09:12:22 Query_DateChanged: 17/06/2015 09:12:22 Query_SQL:SELECT Paper_Actuals.*
FROM Paper_Actuals LEFT JOIN Papers ON Paper_Actuals.ID = Papers.ID
WHERE (((Papers.ID) Is Null));
Link To Column Definitions: Missing_Papers_For_Actuals
Query_Name: Missing_Webref_DisplayText_List_Books Query_Type: Select Query_DateCreated: 30/07/2021 21:15:52 Query_DateChanged: 30/07/2021 21:19:56 Query_SQL:SELECT "+B" & [ID1] & "B+" AS Book, Webrefs_Table.ID, "+W" & [Webrefs_Table!ID] & "W+" AS Webrefs
FROM (Books INNER JOIN (Cross_Reference INNER JOIN Webrefs_Table ON Cross_Reference.Called_ID = Webrefs_Table.ID) ON Books.ID1 = Cross_Reference.Calling_ID) INNER JOIN PID_Note_Reading_Lists ON Books.ID1 = PID_Note_Reading_Lists.Called_ID
WHERE (((PID_Note_Reading_Lists.[Book/Paper])="Book") AND ((Cross_Reference.Called_Type)="W") AND ((Cross_Reference.Calling_Type)="B") AND (([Display_Text] & "")="")) OR (((PID_Note_Reading_Lists.[Book/Paper])="Book") AND ((Cross_Reference.Called_Type)="W") AND ((Cross_Reference.Calling_Type)="B") AND ((Webrefs_Table.[Defunct?])=True))
GROUP BY "+B" & [ID1] & "B+", Webrefs_Table.ID, "+W" & [Webrefs_Table!ID] & "W+", Webrefs_Table.[Defunct?], Books.Author, Books.Title, Webrefs_Table.ID
ORDER BY Webrefs_Table.[Defunct?] DESC , Books.Author, Books.Title, Webrefs_Table.ID;
Link To Column Definitions: Missing_Webref_DisplayText_List_Books
Query_Name: New_Year_Crosstab_Prime_NewYear_SubList Query_Type: Select Query_DateCreated: 03/10/2010 18:53:55 Query_DateChanged: 03/10/2010 18:54:57 Query_SQL:SELECT Year_Crosstab_Prime.Task_Group, Year_Crosstab_Prime.Group, Year_Crosstab_Prime.Subgroup
FROM Year_Crosstab_Prime
GROUP BY Year_Crosstab_Prime.Task_Group, Year_Crosstab_Prime.Group, Year_Crosstab_Prime.Subgroup
ORDER BY Year_Crosstab_Prime.Task_Group, Year_Crosstab_Prime.Group, Year_Crosstab_Prime.Subgroup;
Link To Column Definitions: New_Year_Crosstab_Prime_NewYear_SubList
Query_Name: NewSubTopics_GEN Query_Type: Select Query_DateCreated: 04/12/2011 18:05:05 Query_DateChanged: 21/01/2016 09:48:28 Query_SQL:SELECT Topics.ID, Topics.Topic, Topics.Rationale, Topics.File_Type
FROM Topics LEFT JOIN [Sub-Topics] ON Topics.Topic = [Sub-Topics].[Sub-Topic]
WHERE ((([Sub-Topics].ID) Is Null));
Link To Column Definitions: NewSubTopics_GEN
Query_Name: Next_Qtr_Plans Query_Type: Select Query_DateCreated: 09/04/2013 17:55:19 Query_DateChanged: 09/04/2013 18:01:52 Query_SQL:SELECT Project_Plans.Project, Avg(Project_Plans.Weekly_Hours) AS [Average Next Qtr Plan]
FROM Reporting_Periods, Project_Plans
WHERE (((Project_Plans.Period)>=[Start_Next_Quarter] And (Project_Plans.Period)<=[End_Next_Quarter]))
GROUP BY Project_Plans.Project;
Link To Column Definitions: Next_Qtr_Plans
Query_Name: Note_Archive_Regen_Ranges_Latest Query_Type: Select Query_DateCreated: 20/05/2018 00:13:12 Query_DateChanged: 20/05/2018 00:13:12 Query_SQL:SELECT "Note_Archive_Regen_Ranges" AS Title, Min(Note_Archive_Regen_Ranges.Latest_Note_Range_Update) AS MinOfLatest_Note_Range_Update
FROM Note_Archive_Regen_Ranges
GROUP BY "Note_Archive_Regen_Ranges";
Link To Column Definitions: Note_Archive_Regen_Ranges_Latest
Query_Name: Note_Book_Links_List Query_Type: Select Query_DateCreated: 29/03/2014 17:42:21 Query_DateChanged: 06/02/2022 12:45:21 Query_SQL:SELECT Note_Book_Links_Prelim.Author, Note_Book_Links_Prelim.Title, IIf([MinOfCalling_Timestamp]=0,[BooksToNoteLink],".") AS [Current Note], IIf([MinOfCalling_Timestamp]>0,[BooksToNoteLink],".") AS [Archive Note Only]
FROM Note_Book_Links_Prelim INNER JOIN Book_Note_Link_Refs ON Note_Book_Links_Prelim.ID1 = Book_Note_Link_Refs.ID1
ORDER BY Note_Book_Links_Prelim.Author, Note_Book_Links_Prelim.Title;
Link To Column Definitions: Note_Book_Links_List
Query_Name: Note_Book_Links_List (Letters) Query_Type: Select Query_DateCreated: 29/03/2014 18:10:23 Query_DateChanged: 29/03/2014 18:10:23 Query_SQL:SELECT Left([Author],1) AS Letter
FROM Note_Book_Links_List
GROUP BY Left([Author],1)
ORDER BY Left([Author],1);
Link To Column Definitions: Note_Book_Links_List (Letters)
Query_Name: Note_Book_Links_Prelim Query_Type: Select Query_DateCreated: 29/03/2014 17:36:17 Query_DateChanged: 06/02/2022 12:42:43 Query_SQL:SELECT Books.Author, Books.Title, Books.ID1, Min(Cross_Reference.Calling_Timestamp) AS MinOfCalling_Timestamp, Max(Cross_Reference.Calling_Timestamp) AS MaxOfCalling_Timestamp
FROM Books INNER JOIN Cross_Reference ON Books.ID1 = Cross_Reference.Called_ID
WHERE (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="B"))
GROUP BY Books.Author, Books.Title, Books.ID1
ORDER BY Books.Author, Books.Title;
Link To Column Definitions: Note_Book_Links_Prelim
Query_Name: Note_Lengths_PI Query_Type: Select Query_DateCreated: 26/05/2010 14:45:47 Query_DateChanged: 03/07/2015 18:20:05 Query_SQL:SELECT Len([Item_Text]) AS Length, Notes.*
FROM Notes
WHERE (((Notes.Note_Group)=1))
ORDER BY Len([Item_Text]), Notes.Item_Title;
Link To Column Definitions: Note_Lengths_PI
Query_Name: Note_List Query_Type: Select Query_DateCreated: 13/07/2013 14:21:40 Query_DateChanged: 25/07/2013 15:27:34 Query_SQL:SELECT Notes.*
FROM Notes
ORDER BY Notes.Item_Title;
Link To Column Definitions: Note_List
Query_Name: Note_Paper_Links_List Query_Type: Select Query_DateCreated: 30/03/2014 19:14:16 Query_DateChanged: 05/02/2022 21:11:47 Query_SQL:SELECT Note_Paper_Links_Prelim.Author, Note_Paper_Links_Prelim.Title, IIf([MinOfCalling_Timestamp]=0,[PapersToNoteLink],".") AS [Current Note], IIf([MinOfCalling_Timestamp]>0,[PapersToNoteLink],".") AS [Archive Note Only]
FROM Note_Paper_Links_Prelim INNER JOIN Paper_Note_Link_Refs ON Note_Paper_Links_Prelim.ID = Paper_Note_Link_Refs.ID
ORDER BY Note_Paper_Links_Prelim.Author, Note_Paper_Links_Prelim.Title;
Link To Column Definitions: Note_Paper_Links_List
Query_Name: Note_Paper_Links_List (Letters) Query_Type: Select Query_DateCreated: 30/03/2014 19:15:07 Query_DateChanged: 31/10/2018 18:18:14 Query_SQL:SELECT Left([Author],1) AS Letter
FROM Note_Paper_Links_List
GROUP BY Left([Author],1)
ORDER BY Left([Author],1);
Link To Column Definitions: Note_Paper_Links_List (Letters)
Query_Name: Note_Paper_Links_Prelim Query_Type: Select Query_DateCreated: 30/03/2014 19:05:07 Query_DateChanged: 05/02/2022 21:01:30 Query_SQL:SELECT Papers.Author, Papers.Title, Papers.ID, Min(Cross_Reference.Calling_Timestamp) AS MinOfCalling_Timestamp, Max(Cross_Reference.Calling_Timestamp) AS MaxOfCalling_Timestamp
FROM Papers INNER JOIN Cross_Reference ON Papers.ID = Cross_Reference.Called_ID
WHERE (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="P"))
GROUP BY Papers.Author, Papers.Title, Papers.ID
ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Note_Paper_Links_Prelim
Query_Name: Note_Regen_Ranges_Latest Query_Type: Select Query_DateCreated: 20/05/2018 00:09:34 Query_DateChanged: 20/05/2018 00:09:34 Query_SQL:SELECT "Note_Regen_Ranges" AS Title, Min(Note_Regen_Ranges.Latest_Note_Range_Update) AS MinOfLatest_Note_Range_Update
FROM Note_Regen_Ranges
GROUP BY "Note_Regen_Ranges";
Link To Column Definitions: Note_Regen_Ranges_Latest
Query_Name: Note_Snippet_Lookup Query_Type: Select Query_DateCreated: 12/05/2022 11:11:24 Query_DateChanged: 07/10/2022 12:32:58 Query_SQL:SELECT "Snippet" AS Snippet, Note_Snippets.PID_Note_Title, Note_Snippets.PID_Note_ID, Note_Snippets.ID AS Snippet_ID, Note_Snippets.Note_Snippet
FROM Note_Snippets
WHERE (((Note_Snippets.PID_Note_Title) Like "*" & [Enter Snippet Title String] & "*"));
Link To Column Definitions: Note_Snippet_Lookup