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
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, 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
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ALL | s_id | 6573 | 100.00 | Using temporary; Using filesort | |||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | s_id | 4 | folgerpedia_mw.t4.s_id | 1 | 100.00 | Using where |
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
NoneProvenance
ErinBlake
4 May 2024
Augustin Daly
ErinBlake
4 May 2024
List of digital resources at the Folger
JulieSwierczek
4 May 2024
User:DeborahLeslie/Workflows
DeborahLeslie
1 May 2024
Guidelines for Proposing an Institute Scholarly Program
OwenWilliams
1 May 2024
Unicode characters for cataloging
ErinBlake
30 April 2024
List of cataloging text strings
DeborahLeslie
29 April 2024
MARC 852 Location
ErinBlake
25 April 2024
OpenAthens
ErinBlake
22 April 2024
File:MyAthens login screen.png
JulieSwierczek
21 April 2024