Semantic search
Jump to navigation
Jump to search
Query-Depth:11: User:BomberBlur07 edits, 0 articles 1: User:Boonotakota edits, 0 articles 59: User:Borman edits, 0 articles 1: User:Bosshunter edits, 0 articles 3: User:Bradyreino edits, 0 articles 2: User:Breh edits, 0 articles 2: User:Brianrobert607 edits, 0 articles 75: User:Bro3256 edits, 0 articles 1: User:Bruhmurka edits, 0 articles 37: User:BrunoValads edits, 0 articles 3: User:BryanBit edits, 0 articles 1: User:BuNtEr edits, 0 articles 1: User:Bugmenot edits, 0 articles 1: User:Bumsas2001 edits, 0 articles 5: User:Bun edits, 0 articles 7: User:Burninrubber0 edits, 0 articles 10: User:CB9001 edits, 0 articles 2: User:CKDEV edits, 0 articles 9: User:Cake edits, 0 articles 1: User:Caliburn edits, 0 articles 1: User:Cameronfindssonic edits, 0 articles 1: User:Cammykool edits, 0 articles 2: User:Camron milam edits, 0 articles 1: User:Camron.milam2005 edits, 0 articles 1: User:Capi92 edits, 0 articles 1: User:CaptainViridianDumps edits, 0 articles 1: User:Caristizabalm edits, 0 articles 2: User:CarltonXII edits, 0 articles 1: User:CarrieBrewington edits, 0 articles 2: User:Carter193 edits, 0 articles 1: User:Catbomm edits, 0 articles 98: User:Catsus edits, 0 articles 6: User:Cazzhmir edits, 0 articles 1: User:CebolaBros64 edits, 0 articles 322: User:Cerv3ro edits, 0 articles 1,996: User:Chagosan edits, 0 articles 1: User:Chainspike edits, 0 articles 8: User:Charlesinspectorgadgetfan78 edits, 0 articles 1: User:Charlieadhet edits, 0 articles 33: User:Chasm edits, 0 articles 1: User:Cheerio22 edits, 0 articles 7: User:Chilistudios edits, 0 articles 4: User:Chooks123456 edits, 0 articles 1: User:ChrisLP edits, 0 articles 1: User:ChrisSkeeter edits, 0 articles 1: User:ChristalPocock8 edits, 0 articles 1: User:Christtc777 edits, 0 articles 78: User:Chunkinator edits, 0 articles 3: User:CitricDolphin edits, 0 articles 1: User:Ckdev edits, 0 articles
Debug output SQLStore
ASK Query
[[User edit count::+]]
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_di_number` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=5789)
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
117
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_di_number` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=5789)
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
117
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, p_id, p_id_2, s_id_2 | p_id | 4 | const | 1006 | Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | hp_wiki_new.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:1
Errors and Warnings
None