Semantic search
SQLStore debug output
ASK Query
[[Documentation-tool::+]]OR[[Text-creation::documentation-tool]]
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
30
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
30
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ALL | PRIMARY | 188 | Using temporary; Using filesort | |||
| 1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikidb.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 WHERE t2.p_id='1014272'
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_blob` AS t4 INNER JOIN `t5` AS t5 ON t4.p_id=t5.id WHERE (t4.o_hash='documentation-tool') - Temporary table t5
Recursively computed hierarchy for element(s) ('1014181').
SELECT s_id FROM `smw_fpt_subp` WHERE o_id='1014181' LIMIT 1
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None
- Docbook2X false
- Converts DocBook documents to man pages and Texinfo
- Doclifter false
- Translates n/t/g/roff documentation to DocBook XML markup
- Docmenta false
- Single source publishing and help-authoring web-application. Allows collaborative creation of documentation, e-books and online-help.
- Docutils false
- a text processing system for processing plaintext documentation into formats such as HTML or LaTeX.
- Dot2Tex false
- a Graphviz to LaTeX converter.
- Dox false
- Graphical documentation browser
- Doxia false
- content generation framework
- Doxide false
- Modern documentation for modern C++
- Doxygen false
- Cross-platform documentation system
- Doxymacs false
- Makes using/creating Doxygen easier for Emacs users
- Dungeon-mode false
- Create free (as in freedom) RPGs with GNU Emacs. And then play them.
- Dvipng false
- PNG graphics from TeX DVI files.
- EXtrans false
- Translates XML documents into other formats
- Earm2ipa false
- This program translates Armenian in UTF-8 Unicode to the International Phonetic Alphabet assuming that the dialect represented is Eastern Armenian.
- Epix false
- High-level language for plotting and drawing in LaTeX.
- Epydoc false
- A tool for documenting Python projects
- Eyecite false
- A tool for extracting American legal citations from text
- Faq-O-Matic false
- Automates the creation and maintenance of a FAQ
- Fig2ps false
- Converts xfig files to PS or PDF
- FormatPDF false
- A free online PDF editor
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the page “GNU Free Documentation License”.
The copyright and license notices on this page only apply to the text on this page. Any software or copyright-licenses or other similar notices described in this text has its own copyright notice and license, which can usually be found in the distribution or license text itself.
