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
60
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
60
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 | 238 | 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
NoneCategory: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
1992–1993 Folger Institute Scholarly Programs
LindseyReinstrom
25 January 2017
Category:1993-1994
MeaghanBrown
4 September 2014
File:1993NEHHumanitiesInst.pdf
AtesedeMakonnen
14 June 2017
1993–1994 Folger Institute Scholarly Programs
LindseyReinstrom
25 January 2017
File:1994 Standup Shakespeare Folger 4.jpg
RebekahSheffer
6 January 2022
Category:1994-1995
MeaghanBrown
29 September 2014
Category:1994-Summer
RachelDankert
23 November 2016
File:1994NEHSI.pdf
AtesedeMakonnen
14 June 2017
1994–1995 Folger Institute Scholarly Programs
LindseyReinstrom
25 January 2017
Category:1995-1996
MeaghanBrown
4 September 2014
File:19951996HumInstNEH.pdf
AtesedeMakonnen
14 June 2017
1995–1996 Folger Institute Scholarly Programs
LindseyReinstrom
25 January 2017
Category:1996-1997
MeaghanBrown
28 October 2014
1996–1997 Folger Institute Scholarly Programs
LindseyReinstrom
25 January 2017
Category:1997-1998
MeaghanBrown
15 August 2014
Category:1997-Summer
RachelDankert
23 November 2016
File:1997NEHSI.pdf
AtesedeMakonnen
14 June 2017
1997–1998 Folger Institute Scholarly Programs
AtesedeMakonnen
30 June 2017
Category:1998-1999
MeaghanBrown
15 August 2014
File:1998NEHSI.pdf
AtesedeMakonnen
14 June 2017
1998–1999 Folger Institute Scholarly Programs
AtesedeMakonnen
30 June 2017
Category:1999-2000
MeaghanBrown
13 August 2014
1999–2000 Folger Institute Scholarly Programs
AtesedeMakonnen
30 June 2017
File:1Chanson1415.jpeg
JenniferBowman
25 June 2015
File:1Elizthumbnail1415.jpeg
JenniferBowman
24 June 2015
File:1HIVBrews.jpg
KatelynManfre
22 May 2020
1Lib1Ref
SarahHovde
26 February 2019
Category:2000-2001
MeaghanBrown
14 August 2014
File:2000NEHSI.pdf
AtesedeMakonnen
14 June 2017
2000–2001 Folger Institute Scholarly Programs
AtesedeMakonnen
30 June 2017