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
105
OFFSET
170
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
170
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ALL | PRIMARY | 3470 | 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
- Async-timeout false
- Manages timeout contexts for programs using Python's asyncio
- Aterr false
- Threaded forum system
- Atom false
- Text and source code editor based on Web technologies
- Atomthreads false
- a lightweight, portable, real-time scheduler for embedded systems.
- Atrack false
- A Tracker for Google's App Engine
- Attrs false
- Classes in Python without object protocols
- Auale false
- Play oware abapa against the computer or annotate your games
- Auctex true
- A sophisticated TeX environment for Emacs.
- Audacious false
- Audacious Audio Player
- Audacity false
- Audio editor and recorder
- Aumix false
- Audio mixer for X and the console
- Aumonet false
- Autoconnector for SFTP mountpoints
- Authz-tools false
- Tools for manipulating 'authz' files
- AuthzForce false
- Attribute-Based Access Control (ABAC) framework compliant with OASIS XACML 3.0
- AutoCodeGenerator false
- Generates programs that maintain database records
- Autobuild false
- Processes output from building software and generates HTML summaries.
- Autoconf false
- Produce shell scripts which automatically configure source code.
- Autoconf-archive true
- Collection of autoconf macros.
- Autodist false
- Distribution creation system
- Autogen true
- Automated program and text generation.
- Autohosts false
- Automate hosts file updates on Linux and MacOS. Block Firefox telemetry, Google snooping and web trackers at the root.
- Automake true
- Makefile generator.
- Automated-tasks false
- A collection of scripts I have written and/or adapted that I currently use on my systems as automated tasks.
- Autopackage false
- Builds packages that will run on different distros
- Autoproject false
- Creates a skeleton source package for a new program
- Autosetup false
- A build environment "autoconfigurator"
- Avahi false
- Service Discovery for GNU/Linux using mDNS/DNS-SD -- compatible with Bonjour
- Avaneya false
- Recover lost photographs from the first mission to Mars.
- Avl true
- Libraries for the manipulation of binary trees and balanced binary trees.
- Avogadro false
- an advanced molecule editor and visualizer designed for cross-platform use in computational chemistry, molecular modeling, bioinformatics, materials science, and related areas.
- Avrotest false
- arbitrary performance test between avro and thrift.
- Awesome (node.js) false
- a Redis implementation in node.js
- AwesomeBump false
- Normal map generator, and much more
- Awhttpd false
- Single-process Web server
- Axiom false
- Axiom is a general purpose Computer Algebra system.
- Ayttm false
- All in one instant messaging program.
- Azimuth false
- Azimuth is a top-down shooter adventure game where you play as a ship
- B2ePMS false
- replaces paper phone message slips with emails sent via a web browser form directly to the recipients inbox.
- BALL false
- Biochemical ALgorithms Library.
- BASH Debugger false
- Patched BASH shell with extra debugging support
- BASM false
- The Basic Computer Assembler
- BBclone false
- PHP Web counter
- BBrun false
- Run window for Blackbox
- BEYE false
- A multiplatform portable viewer of binary files with built-in editor in binary, hexadecimal and disassembler modes. It uses native Intel syntax for disassemble.
- BFFFT false
- Fortran 90 2D Vectorized Fast Fourier Transform
- BIABAM false
- Bash shell tool for mailing attachments from the command line
- BIF false
- PHP framework for Web application development
- BRL false
- Language for server-side Web applications
- BRL-CAD false
- Is a powerful Constructive Solid Geometry (CSG) solid modeling system
- BWidget Toolkit false
- High-level widget set for Tcl/Tk
- BYLD false
- Helps users build a mini distribution
- Babel false
- a collection of tools for internationalizing Python applications.
- Baby false
- Software project for chess and fractals.
- Backbone.js false
- Gives structure to Web applications by providing models with key-value binding and custom events
- Backup Shell false
- Shell for ssh
- Bacon false
- a small RSpec clone.
- Badger false
- a library used to generate badge sheets for events.
- Bakery false
- C++ framework for creating GNOME applications
- Ballandpaddle true
- Ball and paddle game.
- Bar false
- User backup utility
- Barcode true
- Convert text strings to printed bars.
- Barista false
- transparent coffeescript support for rails 3
- Bas55 false
- ECMA-55 Minimal BASIC Interpreter
- Basapp false
- Web infrastructure for database application
- Bash true
- The GNU Project implementation of the standard Unix shell.
- Bash-dirstack false
- An implementation of a persistent directory stack in bash.
- Bash.Diff false
- Extended version of the 'bash' shell
- BashBurn false
- A CD burning utility.
- BashDiff false
- A patch for Bash with features from Awk, Python, Zsh, Ksh, and others.
- Bayonne true
- Telephony server.
- Bazaar true
- Friendly powerful distributed version control system.
- Bazel false
- a fast, scalable, multi-language and extensible build system
- Bbdb false
- Contact management utility for Emacs.
- Bbe false
- A binary block editor
- Bc true
- Interactive algebraic language.
- Bcaml false
- tools for B formal
- Bcbio-nextgen false
- Genome variant calling and RNA-seq analysis.
- Bcrypt false
- Password hashing Python library
- Beacon false
- Simple date and category-driven Web publishing system.
- Beancounter false
- A stock portfolio performance monitoring tool
- Beanstalkc false
- a simple beanstalkd client library.
- Bedtools false
- Suite of utilities for comparing genomic features.
- Beehive false
- Flexible event/agent & automation system.
- Benchmark-Timer false
- Times and becnhmarks portions of code
- Beremiz false
- Integrated development environment for machine automation.
- Besssugo false
- a tool to build videos out of scientific calculations
- BezierComposer false
- Continuous composing using Bézier curves
- Bff false
- BrainF*ck language interpreter
- Bfloop false
- An interpreter for the BLooP and FLooP programming languages.
- Bhl false
- Converts plain TXT files into HTML, LaTeX, and SGML.
- Bhpos false
- E-commerce point of sale system.
- Bib2xhtml false
- Converts BibTeX files into XHTML 1.0
- BibTeXConv false
- BibTeX Converter
- Bibfilex false
- Bibliographic manager
- BibleTime false
- A Bible study software
- Bibliogram false
- An alternative libre frotend for Instagram
- Biferno false
- Scripting language for web development
- BigFORTH false
- Forth compiler
- Bigloo false
- Implementation of the Scheme programming language
- Binfind false
- Searches for a byte sequence in a binary file
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.
