Semantic search

Jump to navigation Jump to search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Category:Contrib]]
 |?Version
 |?Category
 |format=table
 |limit=50
 |offset=0
 |link=all
 |sort=
 |order=asc
 |headers=show
 |mainlabel=
}}

Results 1 – 50 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Contrib]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0243",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Contrib]]

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
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=5884)
  AND 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
0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	const	171		Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	mediawiki.t1.s_id	1		Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None

	Version	Category
Advanced Samba	Devel10 Contrib9	Administration Advanced Contrib
Advancedprompt	Contrib10 Contrib9 ContribRPM10 ContribRPM9	Contrib
Affa	Devel10 Contrib10 Contrib9	Backup Advanced Contrib
AltQmail	Contrib9 Devel10	Contrib
Arpwatch	Contrib10 Contrib9	Administration:Monitoring Contrib
Autodiscover	Contrib10	Mail Contrib
AutoMysqlBackup	Contrib10 Contrib9 ContribRPM10 ContribRPM9	Contrib
AWStats	Contrib10 Contrib9 ContribRPM10 ContribRPM9	Administration:Monitoring Contrib Dungog
Backup with Affa and FreeDup	ContribRPM10 ContribRPM9	Backup Contrib
BackupPC	Contrib10 Contrib9	Backup Contrib
Bandwidthd	Contrib10 Contrib9 Devel10	Easy Contrib
Bash-insulter	Contrib10 Contrib9 ContribRPM10 ContribRPM9	Contrib
BridgeInterface	Contrib10 Contrib9	Administration:VPN Contrib
Bugzilla	Contrib10 ContribRPM10	Pages with syntax highlighting errors Contrib Coding
Cacti	Contrib10 Contrib9 ContribRPM10 ContribRPM9 DevelRPM10	Administration:Monitoring Contrib
Centos2sme	Contrib10 Contrib9	Contrib Cli
Certificate ssl management	Contrib10 Contrib9	Contrib Administration:Certificates
Check4updates	Contrib10 Contrib9	Contrib
Clamav unofficial sigs	Contrib9 Contrib10	Security Contrib
Collabora	Contrib10	Contrib Cloud
Contrib/Template		Contrib Category you want
Contrib/Template-smeserver-		Contrib
CoovaChilli	Alpha10 Contrib9 AlphaRPM10 ContribRPM9	Contrib Administration:Remote Access
Crontab Manager	Contrib10 Contrib9	Administration Contrib
Dansguardian	ContribRPM9 Contrib9 Devel9	Medium Administration:Content Spam Virus Blocking Security Contrib:webfiltering Contrib Dungog
Dansguardian-panel	Devel9 ContribRPM9 Contrib9	Medium Administration:Content Spam Virus Blocking Security Contrib:webfiltering Contrib Dungog
Dansguardian-stats		Easy Administration:Monitoring Administration:Content Spam Virus Blocking Contrib:webfiltering Contrib
Dansguardian/ConfigFiles		Administration:Content Spam Virus Blocking Contrib:webfiltering Contrib Dungog
DAR2	contrib9 Alpha10	Easy Backup Contrib
Ddclient	Contrib10 Contrib9 Devel10	Pages with syntax highlighting errors Administration Contrib
Denyhosts	Contrib10 Contrib9 ContribRPM10 ContribRPM9	Security Contrib Administration:Remote Access
Detox	ContribRPM10	Easy Administration:Monitoring Contrib
Dhcp-dns	Contrib10 Contrib9	Beginner Contrib
Dhcpmanager	Contrib10 Contrib9	Beginner Contrib
Dirty Tools	Alpha10	Administration Contrib
Disk Manager	Devel10 Contrib9	Medium Contrib Administration:Storage
Diskusage	Contrib10 Contrib9	Easy Administration:Monitoring Contrib
Docker	Devel10	Work in progress Containers:Docker Containers Contrib
Dokuwiki	Contrib10 ContribRPM10	Easy Webapps Contrib
Domains	Contrib10 Contrib9	Medium Email Administration Contrib Dungog
Dovecot-extras	Contrib10 Contrib9	Easy Contrib
DownloadTicketService	contrib9 Contrib10 ContribRPM10	Webapps Contrib
DSPAM		Mail Administration:Content Spam Virus Blocking Contrib
Durep	Contrib10 Contrib9	Contrib
Egroupware	Alpha9	Webapps Groupware Contrib
Email Whitelist-Blacklist Control	Contrib10 Contrib9	Mail Administration:Content Spam Virus Blocking Contrib
Email-Management	Contrib10 Contrib9	Contrib
Expire-Accounts	contrib9 Contrib10	Administration Contrib
Extrarepositories	Add-on10 Add-on9 Alpha9	Yum Yum Repository Contrib
Ezmlm	Contrib10 Contrib9 ContribRPM10 ContribRPM9	Mail Mail:Mailinglists Contrib

Retrieved from "https://wiki.koozali.org/Special:Ask"

Semantic search

Query log

Navigation menu

Search