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
150
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
150
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ALL | PRIMARY | 3384 | 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
- Artanis true
- Web application framework written in Guile Scheme.
- Article Difficulty Level false
- Through this plugin, user can able to select the post difficulty level in admin dash board post area for each post.
- Arvados false
- Arvados is a free and open source platform for big data science.
- Asciinema-player false
- Web player for terminal session recordings
- Asdf false
- a system definition facility for Common Lisp programs and libraries
- Asdf-vm false
- Version manager for multiple programming languages
- Aseprite false
- Pixel art editor
- Ash text editor false
- a terminal based text editor
- AsmEdit false
- Editor and IDE written in assembler
- AsmIDE false
- Is a utility programs that support assembler development
- AsmRef false
- Reference for x86 assembly language programmers
- Aspell true
- Spell checker.
- Asset Trip false
- Rails asset bundling plugin that will expand your mind.
- Association Freezer false
- Freeze a belongs_to association in Active Record.
- Astroid false
- a Mail User Agent for notmuch
- Astronomical Papers Library false
- A C library of published theories of motion of solar system objects.
- Astyle false
- Source code formatter
- Asymptopia Blackjack false
- Blackjack for kids!
- 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.
- 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.
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.
