Semantic search
SQLStore debug output
ASK Query
[[Software-development::+]]OR[[Use::software-development]]
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
590
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
590
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ALL | PRIMARY | 3473 | 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 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id
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='software-development') - Temporary table t3
Recursively computed hierarchy for element(s) ('1014289').
SELECT s_id FROM `smw_fpt_subp` WHERE o_id='1014289' LIMIT 1 - Temporary table t5
Recursively computed hierarchy for element(s) ('1014157').
SELECT s_id FROM `smw_fpt_subp` WHERE o_id='1014157' LIMIT 1
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None
- Cvs2cl false
- CVS-log-message-to-ChangeLog conversion script
- Cvs2html false
- Translates cvs log output to HTML
- CvsKnit false
- Knits up a CVS repository from existing source
- CvsWeb false
- Web interface to CVS
- Cvsauth false
- Authentication daemon for the CVS pserver method
- Cvschk false
- Checks for new files and modifications to old files
- Cvsd false
- CVS wrapper
- Cvsdelta false
- Summarizes the difference between a CVS project and its local version
- Cvsfs false
- Presents CVS contents as a mountable file system
- Cvsphpview false
- Web interface for accessing CVS repositories
- Cvsplot false
- Analyzes the CVS history of a project
- Cvsstat false
- Shows CVS activity
- Cw false
- Real-time color wrapper for common commands
- Cwriter false
- Web-based collaborative writer.
- Cxcl false
- Interpreter for the XCLE language
- Cxmon false
- File manipulation tool
- CxxTest false
- JUnit/CppUnit/xUnit-like framework for C++
- Cython false
- compiler for writing C extensions for the Python language.
- Cytopia false
- A retro pixel-art city building game with a big focus on mods
- D3.js false
- JavaScript visualization library for HTML and SVG
- DATAGERRY false
- Enterprise-Grade OpenSource CMDB with flexible data model.
- DBG-Client false
- Client for the DBG debugger
- DBG-Server false
- PHP debugger and profiler
- DBeaver false
- Free universal database manager
- DENIM false
- Web design tool that supports sketching input
- DEWAWI false
- Merchandise Management System
- DFASDL false
- The DFASDL is a language based upon XML Schema that can be used to describe data formats and additionally the semantics of it.
- DFASDL Utils false
- A utilities package for the Data Format and Semantics Description Language.
- DIAP false
- Distributed Internet Archiving Protocol
- DIDKit false
- Decentralized Identifiers and Verifiable Credentials Toolkit
- DMBCS Embedded C++ HTTP Server false
- C++ library allowing applications to self-host web services
- DMBCS Trader Desk false
- Yet another stock market charting application
- DNSleak false
- A tool to locally detect DNS leaks
- DOSBox false
- An x86 emulator with DOS
- DSSI false
- Header file for compiling DSSI plugins and hosts
- DTemplate false
- Template system
- DUNE-Common false
- contains the basic classes used by all DUNE-modules.
- DUNE-Grid false
- defines nonconforming, hierarchically nested, multi-element-type, parallel grids in arbitrary space dimensions.
- DUNE-ISTL false
- provides generic sparse matrix/vector classes and a variety of solvers based on these classes.
- DVC for Emacs false
- Emacs front-end for a number of distributed version control systems
- Dabo false
- a 3-tier framework for developing desktop applications.
- Daily Pictures false
- an iOS App that reminds you to take a picture every day
- Dajax false
- easy to use ajax library for django.
- Danectl false
- DNSSEC DANE implementation manager
- Dap true
- Statistics and graphics package.
- Darcs false
- Version control system
- Darkvale Technologies Assistant false
- General purpose virtual assistant and C code generator
- Data.Gov Importer for the National Data Catalog false
- Import data.gov datasets to the National Data Catalog.
- DataMelt false
- Computation and Visualization enviroment
- DataStatix false
- A free software to manage data and statistics with MySql
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.
