Semantic search
Debug output SQLStore
ASK Query
[[Last editor is::!User:127.0.0.1]]
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
`pedia_smw_object_ids` AS t0
INNER JOIN
(`pedia_smw_fpt_ledt` AS t1
INNER JOIN
`pedia_smw_object_ids` AS t2 ON t1.o_id=t2.smw_id) ON t0.smw_id=t1.s_id
WHERE
(
(t2.smw_sortkey!='127.0.0.1')
)
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
10
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
`pedia_smw_object_ids` AS t0
INNER JOIN
(`pedia_smw_fpt_ledt` AS t1
INNER JOIN
`pedia_smw_object_ids` AS t2 ON t1.o_id=t2.smw_id) ON t0.smw_id=t1.s_id
WHERE
(
(t2.smw_sortkey!='127.0.0.1')
)
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
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t0 | index | PRIMARY, smw_id, smw_iw, smw_iw_2 | smw_sort | 262 | 133 | 94.92 | Using where; Using temporary | |
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | s_id | 4 | folgerpedia_mw.t0.smw_id | 1 | 100.00 | Using where; Distinct |
1 | SIMPLE | t2 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | folgerpedia_mw.t1.o_id | 1 | 50.80 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneFile:003247.jpg
RachelDankert
17 June 2014
File:003249.jpg
RachelDankert
17 June 2014
File:003281.jpg
JustineDeCamillis
24 April 2018
File:003309.jpg
RachelDankert
29 July 2014
File:006885.jpg
RachelDankert
22 February 2019
File:009112.jpg
JustineDeCamillis
4 August 2017
File:019807.jpg
MariaHorne
23 March 2018
File:026878.jpg
MorganEllison
20 January 2022
File:027138 Medium.jpg
MorganEllison
19 January 2022
File:028653.jpg
OwenWilliams
29 September 2020
File:028728.jpg
OwenWilliams
23 January 2018
File:029038.jpg
MeaghanBrown
5 January 2015
File:030535.jpg
MeaghanBrown
1 April 2015
File:031516.jpg
MariaHorne
2 March 2018
File:039252.jpg
KateLong
2 September 2015
File:04 Prospero Ariel Tempest.jpg
RebekahSheffer
31 January 2023
File:064426.jpg
MeaghanBrown
9 October 2015
File:066502.jpg
JustineDeCamillis
4 August 2017
File:077985.jpg
JustineDeCamillis
4 August 2017
1 Henry IV (2019)
RebekahSheffer
29 March 2021
1 Henry IV (Folger Theatre, 2008)
DavidPolk
4 February 2021
10 Artists After Paul Klee at the Phillips Collection: Sherwin Bitsui and Paisley Rekdal (2018)
RebekahSheffer
1 February 2021
File:1024px-Andrea di Bartolo - Massacre of the Innocents - Walters 371018.jpg
MariaHorne
23 March 2018
File:11 Cast Tempest.jpg
RebekahSheffer
31 January 2023
File:110 Transcription.pdf
BethDeBold
27 January 2015
File:112364.jpg
RachelDankert
1 December 2017
File:12 Trinculo Stephano Tempest.jpg
RebekahSheffer
31 January 2023
File:128312.jpg
MeaghanBrown
9 April 2018
File:13a Ariel Miranda Prospero.jpg
RebekahSheffer
31 January 2023
File:144461qtp.jpg
BethDeBold
11 April 2020
File:1471091q.jpg
BethDeBold
16 April 2020
File:1559.pdf
BethDeBold
20 November 2017
File:155925.jpg
MelanieLeung
25 August 2021
File:155974.jpg
MelanieLeung
25 August 2021
File:156656.jpg
MelanieLeung
25 August 2021
File:157- 096q.jpg
JustineDeCamillis
4 August 2017
File:1570.pdf
BethDeBold
13 November 2017
File:1576 newest.pdf
BethDeBold
5 August 2017
File:1576.pdf
BethDeBold
5 August 2017
File:157684FD endband.jpg
MelanieLeung
25 August 2021
File:1578.pdf
BethDeBold
3 August 2017
File:158-258q clasp.jpg
MelanieLeung
25 August 2021
File:1602.pdf
BethDeBold
2 August 2017
1603: Kingship Renewed (seminar)
MeaghanBrown
13 March 2015
File:162 EH.mp3
MeaghanBrown
21 November 2014
File:171062 large.jpg
MorganEllison
19 January 2022
File:176711qfoldout.jpg
BethDeBold
11 April 2020
File:18FallKirsten-Gillibrand400.jpg
KatelynManfre
21 May 2020
File:1936 Accessions register page.jpg
ErinBlake
4 March 2017
File:1979CHBPT(NEH).pdf
AtesedeMakonnen
26 June 2017