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
30
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
30
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 | 175 | 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.81 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None1 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
Category:1983-1984
RachelDankert
23 November 2016
Category:1984-1985
MeaghanBrown
2 December 2014
Category:1985-1986
MeaghanBrown
3 November 2014
Category:1986-1987
MeaghanBrown
1 December 2014
Category:1987-1988
MeaghanBrown
2 December 2014
Category:1987-Summer
RachelDankert
23 November 2016
Category:1988-1989
MeaghanBrown
3 November 2014
Category:1988-Summer
MeaghanBrown
3 November 2014
Category:1989-1990
MeaghanBrown
2 December 2014
Category:1989-Summer
MeaghanBrown
2 December 2014
Category:1990-1991
MeaghanBrown
3 November 2014
Category:1990-Summer
MeaghanBrown
2 December 2014
File:1990NEHSI.pdf
AtesedeMakonnen
14 June 2017
Category:1991-1992
MeaghanBrown
23 September 2014
Category:1991-Summer
MeaghanBrown
3 November 2014
File:1991NEHSI.pdf
AtesedeMakonnen
14 June 2017
1991–1992 Folger Institute Scholarly Programs
LindseyReinstrom
25 January 2017
Category:1992-1993
MeaghanBrown
4 September 2014
Category:1992-Summer
MeaghanBrown
3 November 2014
File:1992NEHSI.pdf
AtesedeMakonnen
14 June 2017