Semantic search
Jump to navigation
Jump to search
Query-Depth:2
Debug output SQLStore
ASK Query
[[Category:Tools]] [[Function.Stage::Create or Receive (Acquire)]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
(`smw_di_wikipage` AS t4
INNER JOIN
`smw_di_wikipage` AS t6 ON t4.o_id=t6.s_id) ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=1157
AND (t6.p_id=1162 AND t6.o_id=1186)
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
100
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
(`smw_di_wikipage` AS t4
INNER JOIN
`smw_di_wikipage` AS t6 ON t4.o_id=t6.s_id) ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=1157
AND (t6.p_id=1162 AND t6.o_id=1186)
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
100
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t6 | ref|filter | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id|p_id | 5|4 | const | 10 (2%) | Using where; Using temporary; Using filesort; Using rowid filter | |
1 | SIMPLE | t4 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id | 5 | wikidb.t6.s_id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wikidb.t4.s_id | 1 | Using where | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 4 | wikidb.t4.s_id | 1 | Using where; Using index; Distinct | |
1 | SIMPLE | t3 | eq_ref | PRIMARY | PRIMARY | 4 | wikidb.t2.o_id | 1 | Distinct |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (517).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=517 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:2
Errors and Warnings
NoneTool | Function | Purpose |
---|---|---|
Teleport | Web Capture | Teleport is a web crawling tool that enables offline browsing |
TeraCopy | File Copy File Management Transfer | Performs file copying, whilst also logging and verifying accuracy and completeness by using checksums |
Tesseract-ocr | OCR | Open source OCR engine, accepting uncompressed TIFF files as input |
The DeDuplicator (Heritrix add-on module) | De-Duplication Web Capture | The DeDuplicator is an add-on module for Heritrix to reduce the amount of duplicate data collected in a series of snapshot crawls. |
Tree | File Management Metadata Processing Appraisal | Tree displays the directory structure of a path or of the disk in a drive graphically. |
TreeSize | File Management Appraisal | Manage disk space and scan your hard disks. |
TubeKit | Web Capture | TubeKit is a toolkit for creating YouTube crawlers. |
Tufts Submission-Agreement Builder Tool | Data capture and Deposit Planning | SABT is a web-based tool that guides records creators and records managers through the process of creating submission agreements, both for single transfers and for standing submissions. |
UKWA GSuite Add-On | Validation Appraisal | GSuite functions for people working with web archives. The functions use the Memento API (specifically the TimeGate) to look up whether a given archive holds a given URL. It currently supports checks against:
|
UnArchiver | Fixity Decryption Transfer | UnArchiver is a native macOS utility which supports infinitely more archive formats then other common archiving utilities. |
VeraCrypt | Decryption Transfer | Securely encrypts large amounts of files |
Virtual CloneDrive | Disk Imaging | Virtual CloneDrive works and behaves just like a physical CD/DVD drive, but it exists only virtually. |
WARCreate | Data capture and Deposit Personal Archiving Web Capture | Google Chrome browser extension for creating WARC files from web pages |
WAS (Web Archiving Service) | Web Capture | The Web Archiving Service (WAS) is a Web-based curatorial tool that enables libraries and archivists to capture, curate, analyze, and preserve Web-based government and political information. |
WAXToolbar | Web Capture | WAXToolbar is a firefox extension to help users with common tasks encountered surfing a web archive. |
WCT (Web Curator Tool) | Metadata Processing Web Capture | Web Curator Tool (WCT) is a workflow management application for selective web archiving. |
WarcManager | File Management Web Capture | The WARC Manager is a web-based UI for managing and querying collections of web crawl data. |
Warrick | Web Capture | Warrick is a free utility for reconstructing (or recovering) a website from web archives. |
Wayback Machine | Access Discovery Web Capture | The Wayback Machine is a powerful search and discovery tool for use with collections of Web site "snapshots" collected through Web harvesting, usually with Heritrix (ARC or WARC files). |
Web Scraper Plus+ | Web Capture | Web Scraper Plus+ takes data from the web and puts it into a spreadsheet or database. |
WebCite | Citation and Impact Tracking Persistent Identification Web Capture | WebCite is an on-demand web archiving service that takes snapshots of Internet-accessible digital objects at the behest of users, storing the data on their own servers and assigning unique identifiers to those instances of the material. |
WebShot | Web Capture | WebShot allows you to take screenshots of web pages and save them as full sized images or thumbnails. |
Webkit2png | Web Capture | webkit2png is a command line tool that creates png screenshots of webpages. |
Webrecorder | Web Capture | Webrecorder is a hosted web archiving tool with which users can capture what they see as they browse websites and save that information (locally or to a free account) |
XXCopy | File Copy | XXCopy is an expanded version of Xcopy |
Xcopy | File Copy | Xcopy copies files and directories, including subdirectories. |
Xenu's Link Sleuth | Web Capture | The tool checks the hyperlinks on websites. |
YT-DLP (You Tube Download P) | Web Capture | Supports download of youtube videos, based on the now defunct YT-DL |