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
105
OFFSET
130
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
105
OFFSET
130
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
- ROBODoc false
- Documentation tool
- RTFX false
- Converts RTF files into a generic XML format
- Refafit false
- Processes PDF or images
- Reftex true
- Emacs minor mode for doing labels, references and citations in LaTeX
- Rfcfold false
- Fold or unfold a text file according to RFC 8792
- Rlib false
- Creates reports from XML definition files
- Rubber false
- Building system for LaTeX documents
- Rusty false
- a collection of Sphinx extensions.
- Scdoc false
- A simple man page generator for POSIX systems written in C99
- Seealso false
- Searches and prints references from manpages
- Setheader false
- Add, replace or remove top header comments in source files.
- Shipyard false
- a module to process data in a format inspired by email headers (RFC 2822).
- Skribe false
- A schemey document authoring system.
- Skribilo false
- Document production tool written in Guile Scheme.
- Slidedown false
- Generate syntax-highlighted slides from Markdown.
- Sourcehut-man false
- sr.ht wiki
- Sphinx false
- Python documentation generator.
- Src-highlite true
- Produce document with syntax highlighting from source file.
- StandardizeIPA false
- This program translates "North American IPA" in UTF-8 Unicode into the standard International Phonetic Alphabet.
- Stenciltools false
- Tools for text generation and manipulation
- System-V banner clone false
- Displays a 'banner' text
- TeXML false
- XML vocabulary for TeX
- TeXstudio false
- A modern LaTeX editor
- Tea false
- Powerful multipurpose editor
- Tex2im false
- Converts LaTeX formulas into graphics
- Texcaller false
- interface to the TeX command line tools
- Texinfo true
- Produces manuals, ASCII text, and on-line documentation.
- Texmaker false
- A LaTeX development environment.
- TidyDoc false
- A documentation organizer
- TikiWiki false
- The Free/Libre Software Web Application with the most built-in features.
- TinyMCE false
- The Most Advanced WYSIWYG HTML Editor
- TinyRML2PDF false
- Creates PDF documents
- Tk Brief false
- GUI for facilitating letter writing using LaTeX
- Trilium Notes false
- Hierarchical note taking application with focus on building large personal knowledge bases
- Txt2man false
- Converts ASCII text to man page format
- Txt2tags false
- Format conversion tool
- UDO false
- Converts documentation from its own UDO format to various other formats
- Uni2ascii false
- A pair of programs that convert between Unicode and various 7-bit ASCII representations.
- Unrtf true
- Converts from RTF to other formats.
- Untitled false
- Multi-site static site generator
- Verbiste false
- A French conjugation system.
- Vim2html false
- Converts vim files to HTML
- Weblate false
- Online, Web-based translation platform
- WikiLaTex false
- Wiki for developing and cataloging LaTeX works
- WikiSuite false
- Enterprise Suite
- Winefish false
- A LaTeX editor for experienced users.
- Wkhtmltopdf false
- Convert web pages to images and PDF
- XML Boiler false
- Automatically transform XML documents based on namespaces
- XML Twig false
- Processes XML documents
- Xinfo false
- X window program for reading Info files.
- Xlit false
- Converts text from one writing system into another.
- Xmlg false
- Splits an XML file into a TextArray and XML markup information
- Xmlmp false
- Facilitates writing *nix manpages using XML
- Yelp false
- Gnome help browser
- Yodl false
- Your Own Document Language (Yodl) is a pre-document language
- Z2tml false
- Converts files in the Z document language to HTML
- Zettelkasten false
- Zettelkasten according to Luhmann
- Zotero-better-bibtex false
- An extension for Zotero and Juris-M that makes it easier to manage bibliographic data
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.
