Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Functions]]
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1179)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
0
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1179)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 52 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wikidb.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneLifecycle Functions | Definition |
---|---|
Academic Social Networking | Tools that support making connections, sharing research and maximising the impact of digital data. |
Access | Tools that facilitate access to digital data by users. |
Active Data Storage | Tools that support the storage, management, and ultimately the preservation, of evolving research data. |
Annotation | Tools that facilitate annotation of digital data by users. |
Appraisal | Tools that enable the assessment of content against in order to decide on it's relevance or appropriateness for preservation |
Backup | Tools that support the backing up of digital data to another storage location, typically in a scheduled manner. |
Benefits | Tools that enable the identification and articulation of the benefits of preservation and curation. |
Binary & Hexidecimal Editing | Tools for viewing and editing of files displayed in different views such as binary, hexadecimal. These are typically known as hex editors. |
Citation and Impact Tracking | Tools that support the citation of data and the tracking of the impact of usage of that data. |
Content Profiling | Tools that build a profile of the characteristics of digital content, typically by combining or analysing a number of sources of information such as extracted metadata and file format identifications. |
Costing | Tools that support the calculation or prediction of the cost of preservation or curation activities. |
Data Management Planning | Tools that support the development of research data management plans and related activities. |
Data capture and Deposit | Tools that enable the capture and deposit of data. |
De-Duplication | Tools that enable the identification and/or removal of duplicate or similar files. |
Decryption | Tools for recovering passwords or unlocking encrypted digital files. |
Dependency Analysis | Tools for identifying essential information that resides externally to a digital object, or for identifying dependent processes such as which DLLs are required by a Windows process. |
Discovery | Tools that facilitate the discovery of digital data by users. |
Disk Imaging | Tools that enable the capture, viewing or extraction of contents of a disk image (which is a computer file containing the contents and structure of a disk volume or an entire data storage device, such as a hard drive or floppy disk). |
Emulation | Tools that enable the emulation or virtualisation of a hardware or software system on another system. |
Encryption Detection | Tools that support the detection of encryption or password protection in files. |