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
260
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
260
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t0 | ALL | PRIMARY, smw_id, smw_iw, smw_iw_2 | 7444 | 94.92 | Using where; Using temporary; Using filesort | |||
| 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
NoneA Semi-Diplomatic Transcription of Selections from the John Ward Diaries, vol. 10 (1663-1665), V.a.293
EmilyWahl
16 September 2021
A Semi-Diplomatic Transcription of Selections from the John Ward Diaries, vol. 9 (1662-1663), V.a.292
ErinBlake
23 November 2022
A Sense of the Archive (seminar)
MeaghanBrown
13 March 2015
A Shared Passion: Henry Clay Folger, Jr. and Emily Jordan Folger as Collectors
NicoleWinard
30 January 2017
A Spanish Christmas: Festive Music from Spain's Golden Age (2008)
SophieByvik
22 July 2014
A Tribute to Raymond Carver: Richard Ford, Tobias Wolff, Jayne Anne Phillips, & Joy Williams (2006)
RebekahSheffer
21 July 2021
A Tribute to Robert Stone (2016)
DanicaZielinski
22 July 2020
File:A scribbed form catalog.pdf
SarahHovde
19 March 2019
File:A scribbled form flyer.pdf
SarahHovde
19 March 2019
File:A&C SetRender 8-10-17.jpg
KatelynManfre
11 May 2020
A.R. Braunmuller
MeaghanBrown
13 March 2015
File:AC-2017-digital-poster.jpg
KatelynManfre
5 May 2020
File:AC-Brews-2017.jpg
KatelynManfre
6 May 2020
File:AC.jpg
BethDeBold
2 December 2016
ACLS Humanities E-Book collection
ErinBlake
17 June 2022
File:ACLS-logo.jpg
ErinBlake
11 August 2018
File:APacker.png
EmilyWahl
27 March 2020
File:ART 264511 (size L).jpg
RachelDankert
9 May 2017
File:ART Box H688 no.10.1 pt.3.jpg
LeahThomas
16 November 2022
File:ART Box R763 no.23.jpg
JustineDeCamillis
14 July 2017
File:ART Box S827.5 no.5 (size L).jpg
JustineDeCamillis
4 August 2017
File:ART File C496 no.1 (size M).jpg
JustineDeCamillis
13 July 2017
File:ART File H734.5 no.1.jpg
JustineDeCamillis
3 August 2017
File:ART File S527 no.193 (size M).jpg
JustineDeCamillis
4 August 2017
ART Inv. numbers
RachelDankert
16 December 2016
File:ART Vol. b23.pdf
ErinBlake
6 January 2015
File:ART Vol. b24.pdf
ErinBlake
6 January 2015
File:ART Vol. b25.pdf
ErinBlake
6 January 2015
File:ART Vol. b26.pdf
ErinBlake
6 January 2015
File:ART Vol. b27.pdf
ErinBlake
6 January 2015
File:ART Vol. b28.pdf
ErinBlake
6 January 2015
File:ART Vol. b29.pdf
ErinBlake
6 January 2015
File:ART Vol. b30.pdf
ErinBlake
6 January 2015
File:ART Vol. b31.pdf
ErinBlake
6 January 2015
File:ART Vol. b32.pdf
ErinBlake
6 January 2015
File:ART Vol. b33.pdf
ErinBlake
6 January 2015
File:ART Vol. b34.pdf
ErinBlake
6 January 2015
File:ART Vol. f81 no.2.jpg
JustineDeCamillis
4 August 2017
File:ART206-773.jpg
JustineDeCamillis
3 August 2017
File:ART264511L.jpg
RachelDankert
19 October 2016
File:ARTBoxB433no10sizeS.jpg
BethDeBold
8 April 2020
File:ARTBoxB433no20sizeS.jpg
BethDeBold
8 April 2020
File:ARTBoxB433no7sizeS.jpg
BethDeBold
8 April 2020
File:ARTBoxF993no9sizeXL.jpg
BethDeBold
9 April 2020
File:ARTBoxR469no108size L.jpg
BethDeBold
9 April 2020
File:ASpace Physical Facet note.png
SaraButterfassSchliep
14 August 2023
File:ASpace filing hole note.png
SaraButterfassSchliep
14 August 2023
File:ASpace materials specific.png
SaraButterfassSchliep
14 August 2023
File:AVanJordan.jpg
RebekahSheffer
13 January 2021
User:AbbieWeinberg
AbbieWeinberg
7 May 2015