The SPORTS PAGE ARCHIVE Serving the Tri-Cities from 1976 to 1984 |
SPI-t010 Admin menu rev 05/18/2024 17:05 SECTIONS
SPI Menu
SPI Public Menu 100: Full DB List 400: Contact Sheet List 130: Search 800: Documentation You find links to 750 in 100 and 720. 720: OLD Auto Load 740: OLD Database list 760: DIR CONVERT (2023). 770: Audit issues and pages 780: Update Amazon/Kindle codes 790: Audit Database 710: Test TXT file LINE read Directory test FTP test 500-ERROR analysis and tests: "Auto Load" basics to test 500 error Force 500 (NO flush) Error, but NO 500. (with cfFLUSH) SPI-t010 admin menu rev 05/18/2024 17:05 |
SPI-0790.cfm rev 03/03/2024 10:58
SPORTS PAGE ANALYZE MAIN DATABASE (2)
{ts '2024-12-01 13:15:53'}
First box. Count records on file Start tick 1,733,076,953,129 SPI_Type = P says individual page entry. <cfquery name="SPIq_Stories" datasource="MyBayCity" > SELECT * FROM mbc_tsportspage_idx WHERE SPI_Type = "P" ORDER BY SPI_IssueDate </cfquery> SPIq_Stories returned 6,304 pages. End tick 1,733,076,956,254 3.125 seconds elapsed. close 1st box. Start 2nd, DISTINCT box DISTINCT ISSUE YEARs on file list. <cfquery name="SPIq_Issues" datasource="MyBayCity" > SELECT DISTINCT SPI_IssueDate FROM mbc_tsportspage_idx WHERE SPI_Type = "P" ORDER BY SPI_IssueDate </cfquery> SPIq_Issues returned 10 distinct years. [] quoted nul value [0] len zero (nul) not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year is Null </cfquery> SPIq_IssuePages returned 25 [1976] value [4] not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year = "1976" </cfquery> SPIq_IssuePages returned 236 [1977] value [4] not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year = "1977" </cfquery> SPIq_IssuePages returned 498 [1978] value [4] not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year = "1978" </cfquery> SPIq_IssuePages returned 752 [1979] value [4] not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year = "1979" </cfquery> SPIq_IssuePages returned 1021 [1980] value [4] not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year = "1980" </cfquery> SPIq_IssuePages returned 974 [1981] value [4] not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year = "1981" </cfquery> SPIq_IssuePages returned 584 [1982] value [4] not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year = "1982" </cfquery> SPIq_IssuePages returned 585 [1983] value [4] not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year = "1983" </cfquery> SPIq_IssuePages returned 788 [1984] value [4] not-isNull <cfquery name="SPIq_IssuePages" datasource="MyBayCity"> SELECT SPI_Issue_year FROM mbc_tsportspage_idx WHERE SPI_Type = "P" and SPI_Issue_year = "1984" </cfquery> SPIq_IssuePages returned 841 End distinct years box 0.626 seconds elapsed. Start 2nd, DISTINCT box
DISTINCT ISSUEs on file list. <cfquery name="SPIq_Issues" datasource="MyBayCity" > SELECT DISTINCT SPI_IssueDate FROM mbc_tsportspage_idx ORDER BY SPI_IssueDate </cfquery> SPIq_Issues returned 362 distinct issues. 1976-07-05 1976-07-19 1976-08-02 1976-08-16 1976-09-06 1976-09-20 1976-10-04 1976-10-18 1976-11-01 1976-11-15 1976-12-06 1976-12-20 1977-01-03 1977-01-17 1977-02-07 1977-02-21 1977-03-07 1977-03-21 1977-04-04 1977-04-18 1977-05-02 1977-05-16 1977-06-06 1977-06-20 1977-07-04 1977-07-18 1977-08-01 1977-08-15 1977-09-05 1977-09-20 1977-10-03 1977-10-17 1977-11-07 1977-11-21 1977-12-05 1977-12-19 1978-01-02 1978-01-16 1978-02-06 1978-02-20 1978-03-06 1978-03-20 1978-04-03 1978-04-17 1978-05-05 1978-05-12 1978-05-19 1978-05-26 1978-06-02 1978-06-09 1978-06-16 1978-06-23 1978-06-30 1978-07-07 1978-07-14 1978-07-21 1978-07-28 1978-08-04 1978-08-11 1978-08-18 1978-08-25 1978-09-01 1978-09-08 1978-09-15 1978-09-22 1978-09-29 1978-10-06 1978-10-13 1978-10-20 1978-10-27 1978-11-03 1978-11-10 1978-11-17 1978-11-24 1978-12-01 1978-12-08 1978-12-15 1978-12-22 1978-12-29 1979-01-01 1979-02-02 1979-02-09 1979-02-16 1979-02-23 1979-03-02 1979-03-09 1979-03-16 1979-03-23 1979-03-30 1979-04-06 1979-04-13 1979-04-20 1979-04-27 1979-05-04 1979-05-11 1979-05-18 1979-05-25 1979-06-01 1979-06-08 1979-06-15 1979-06-22 1979-06-29 1979-07-06 1979-07-13 1979-07-20 1979-07-27 1979-08-03 1979-08-10 1979-08-17 1979-08-24 1979-08-31 1979-09-07 1979-09-14 1979-09-21 1979-09-28 1979-10-05 1979-10-12 1979-10-19 1979-10-26 1979-11-02 1979-11-09 1979-11-16 1979-11-23 1979-11-30 1979-12-07 1979-12-14 1979-12-21 1979-12-28 1980-01-01 1980-02-01 1980-02-08 1980-02-15 1980-02-22 1980-03-07 1980-03-14 1980-03-21 1980-03-28 1980-04-04 1980-04-11 1980-04-18 1980-04-25 1980-05-02 1980-05-09 1980-05-16 1980-05-23 1980-05-30 1980-06-06 1980-06-13 1980-06-20 1980-06-27 1980-07-04 1980-07-11 1980-07-18 1980-07-25 1980-08-01 1980-08-08 1980-08-15 1980-08-22 1980-08-29 1980-09-05 1980-09-12 1980-09-19 1980-10-02 1980-10-09 1980-10-16 1980-10-23 1980-10-30 1980-11-06 1980-11-13 1980-11-20 1980-11-27 1980-12-04 1980-12-11 1980-12-18 1980-12-25 1981-02-05 1981-02-12 1981-02-19 1981-02-26 1981-03-05 1981-03-12 1981-03-19 1981-03-26 1981-04-02 1981-04-09 1981-04-16 1981-04-30 1981-05-07 1981-05-14 1981-05-21 1981-05-28 1981-06-04 1981-06-11 1981-06-18 1981-06-25 1981-07-02 1981-07-09 1981-07-16 1981-07-23 1981-07-30 1981-08-06 1981-08-13 1981-08-20 1981-08-27 1981-09-03 1981-09-10 1981-09-17 1981-09-24 1981-10-01 1981-10-08 1981-10-15 1981-10-22 1981-10-29 1981-11-05 1981-11-12 1981-11-19 1981-11-26 1981-12-03 1981-12-10 1981-12-17 1981-12-24 1981-12-31 1982-02-04 1982-02-11 1982-02-18 1982-02-25 1982-03-04 1982-03-11 1982-03-18 1982-03-25 1982-04-01 1982-04-08 1982-04-15 1982-04-22 1982-04-29 1982-05-06 1982-05-13 1982-05-20 1982-05-27 1982-06-03 1982-06-10 1982-06-17 1982-06-24 1982-07-01 1982-07-08 1982-07-15 1982-07-22 1982-07-29 1982-08-05 1982-08-12 1982-08-19 1982-08-26 1982-09-02 1982-09-09 1982-09-16 1982-09-23 1982-09-30 1982-10-07 1982-10-14 1982-10-21 1982-10-28 1982-11-02 1982-11-04 1982-11-11 1982-11-18 1982-11-25 1982-12-02 1982-12-03 1982-12-09 1982-12-16 1982-12-23 1982-12-30 1983-01-01 1983-01-27 1983-02-03 1983-02-10 1983-02-17 1983-02-24 1983-03-10 1983-03-17 1983-03-24 1983-03-31 1983-04-07 1983-04-14 1983-04-21 1983-04-28 1983-05-05 1983-05-12 1983-05-19 1983-05-26 1983-06-02 1983-06-09 1983-06-16 1983-06-23 1983-06-30 1983-07-07 1983-07-14 1983-07-21 1983-07-28 1983-08-04 1983-08-11 1983-08-18 1983-08-25 1983-09-01 1983-09-08 1983-09-15 1983-09-22 1983-09-29 1983-10-06 1983-10-13 1983-10-20 1983-10-27 1983-11-03 1983-11-10 1983-11-17 1983-11-24 1983-12-01 1983-12-08 1983-12-15 1983-12-22 1983-12-29 1984-01-19 1984-02-02 1984-02-09 1984-02-16 1984-02-23 1984-03-01 1984-03-08 1984-03-15 1984-03-22 1984-03-29 1984-04-05 1984-04-12 1984-04-19 1984-04-26 1984-05-03 1984-05-10 1984-05-17 1984-05-24 1984-05-31 1984-06-07 1984-06-14 1984-06-21 1984-06-28 1984-07-05 1984-07-12 1984-07-19 1984-07-26 1984-08-02 1984-08-09 1984-08-16 1984-08-23 1984-08-30 1984-09-06 1984-09-13 1984-09-20 1984-09-27 1984-10-04 1984-10-11 1984-10-18 2022-05-04 End 2nd box 0.015 seconds elapsed. End right column, row and table (in t900 rev 03/30/2024 16:16 ) |
| |
---|---|
SPI_TickNow | 1,733,076,956,895 |
SPI_TickBegin | 1,733,076,953,129 |
SPI_Elapsed | 3,766 |