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, t4.o_sortkey
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
INNER JOIN
`pedia_smw_fpt_mdat` AS t4 ON t0.smw_id=t4.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
t4.o_sortkey DESC
LIMIT
15
OFFSET
0
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, t4.o_sortkey
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
INNER JOIN
`pedia_smw_fpt_mdat` AS t4 ON t0.smw_id=t4.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
t4.o_sortkey DESC
LIMIT
15
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ALL | s_id | 6576 | 100.00 | Using temporary; Using filesort | |||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 4 | folgerpedia_mw.t4.s_id | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | t2 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | folgerpedia_mw.t1.o_id | 1 | 50.87 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | folgerpedia_mw.t4.s_id | 1 | 100.00 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneMARC 506 Restrictions on Access Note
ErinBlake
17 May 2024
Shakespeare's Birthday Lecture: "The Goodness of the Night: Editing Othello"
LeahThomas
16 May 2024
Collation Blog Guest Post Guidelines
HeatherWolfe
16 May 2024
File:The Goodness of the Night.pdf
LeahThomas
15 May 2024
Shakespeare's Birthday Lecture
LeahThomas
15 May 2024
Guidelines for Proposing an Institute Scholarly Program
OwenWilliams
15 May 2024
Banking-related papers of Robert Clayton, John Morris, et al., from the Fairfax Library, circa 1650-1700
ErinBlake
14 May 2024
List of cataloging text strings
DeborahLeslie
14 May 2024
List of digital resources at the Folger
MorganEllison
14 May 2024
Folger Institute
LeahThomas
13 May 2024