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
55
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
`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
55
OFFSET
100
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
- Mod xslt false
- Converts XML files to HTML files on the fly
- Mopowg false
- a doc generator with styles, and syntax highlighting blocks.
- Multitail false
- Tail on multiple windows with a ncurses interface
- Natural Docs false
- Multi-language, source code documentation generator
- OOoLatexEquation false
- provide LaTeX support into LibreOffice
- OmegaT false
- OmegaT is a free multiplatform Computer Assisted Translation tool with fuzzy matching, translation memory, keyword search, glossaries, and translation leveraging into updated projects.
- OneModel false
- Atomic knowledge, all you wish, with a single data model -- record, manage and share -- fast, free and open.
- OpenDAM false
- OpenDAM was an open source Digital Asset Management software
- OpenProdoc false
- Document management System and Thesaurus manager
- Orgadoc true
- Helps organize documentation.
- Oxref false
- cross-reference and call-tree generator
- PDFResurrect false
- PDF analysis, extraction, and scrubbing tool.
- PDFedit false
- Free editor for PDF documents.
- PDFjam.txt false
- Interface to the pdfpages package for pdfLaTeX
- PDFrecycle false
- create a PDF file by composing pages from other PDF files.
- PDFtoPNG false
- a small utility that can convert PDFs to PNGs.
- Pandoc false
- General markup converter
- Pasdoc false
- Documentation generator for pascal source code
- PdfTeX false
- Creates and enhances PDF output from TeX source files
- Pdftk false
- Toolkit for working with PDF documents
- Perl-reference false
- Displays Perl reference documentation
- PhpMyFAQ false
- Database-driven FAQ system
- Phpman false
- PHP/MySQL-based system for publishing manuals and documentation
- Pinfo false
- Ncurses based info documentation browser
- PipeMore false
- Pipes data to a new window
- Poppler false
- a PDF rendering library.
- Poppler Encoding Data false
- encoding data for the Poppler PDF library.
- Preview-latex false
- Embeds LaTeX environments into Emacs source buffers
- Python-tex false
- Convert LaTeX or TeX source to PDF or DVI, and escape strings for LaTeX.
- QuHelp false
- a program that generates a help site (with tree navigator and other nice stuff) using a template and a content directory.
- 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
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.
