Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:External Dictionary - Hopkins2015]]
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
`ry_smw_object_ids` AS t0
INNER JOIN
`ry_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1256659)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
50
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
`ry_smw_object_ids` AS t0
INNER JOIN
`ry_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1256659)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 36726 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- Steinert App Dictionaries/01-Hopkins2015/10042
- Steinert App Dictionaries/01-Hopkins2015/10043
- Steinert App Dictionaries/01-Hopkins2015/10044
- Steinert App Dictionaries/01-Hopkins2015/10045
- Steinert App Dictionaries/01-Hopkins2015/10046
- Steinert App Dictionaries/01-Hopkins2015/10047
- Steinert App Dictionaries/01-Hopkins2015/10048
- Steinert App Dictionaries/01-Hopkins2015/10049
- Steinert App Dictionaries/01-Hopkins2015/1005
- Steinert App Dictionaries/01-Hopkins2015/10050
- Steinert App Dictionaries/01-Hopkins2015/10051
- Steinert App Dictionaries/01-Hopkins2015/10052
- Steinert App Dictionaries/01-Hopkins2015/10053
- Steinert App Dictionaries/01-Hopkins2015/10054
- Steinert App Dictionaries/01-Hopkins2015/10055
- Steinert App Dictionaries/01-Hopkins2015/10056
- Steinert App Dictionaries/01-Hopkins2015/10057
- Steinert App Dictionaries/01-Hopkins2015/10058
- Steinert App Dictionaries/01-Hopkins2015/10059
- Steinert App Dictionaries/01-Hopkins2015/1006
- Steinert App Dictionaries/01-Hopkins2015/10060
- Steinert App Dictionaries/01-Hopkins2015/10061
- Steinert App Dictionaries/01-Hopkins2015/10062
- Steinert App Dictionaries/01-Hopkins2015/10063
- Steinert App Dictionaries/01-Hopkins2015/10064
- Steinert App Dictionaries/01-Hopkins2015/10065
- Steinert App Dictionaries/01-Hopkins2015/10066
- Steinert App Dictionaries/01-Hopkins2015/10067
- Steinert App Dictionaries/01-Hopkins2015/10068
- Steinert App Dictionaries/01-Hopkins2015/10069
- Steinert App Dictionaries/01-Hopkins2015/1007
- Steinert App Dictionaries/01-Hopkins2015/10070
- Steinert App Dictionaries/01-Hopkins2015/10071
- Steinert App Dictionaries/01-Hopkins2015/10072
- Steinert App Dictionaries/01-Hopkins2015/10073
- Steinert App Dictionaries/01-Hopkins2015/10074
- Steinert App Dictionaries/01-Hopkins2015/10075
- Steinert App Dictionaries/01-Hopkins2015/10076
- Steinert App Dictionaries/01-Hopkins2015/10077
- Steinert App Dictionaries/01-Hopkins2015/10078
- Steinert App Dictionaries/01-Hopkins2015/10079
- Steinert App Dictionaries/01-Hopkins2015/1008
- Steinert App Dictionaries/01-Hopkins2015/10080
- Steinert App Dictionaries/01-Hopkins2015/10081
- Steinert App Dictionaries/01-Hopkins2015/10082
- Steinert App Dictionaries/01-Hopkins2015/10083
- Steinert App Dictionaries/01-Hopkins2015/10084
- Steinert App Dictionaries/01-Hopkins2015/10085
- Steinert App Dictionaries/01-Hopkins2015/10086
- Steinert App Dictionaries/01-Hopkins2015/10087
- Steinert App Dictionaries/01-Hopkins2015/10088
- Steinert App Dictionaries/01-Hopkins2015/10089
- Steinert App Dictionaries/01-Hopkins2015/1009
- Steinert App Dictionaries/01-Hopkins2015/10090
- Steinert App Dictionaries/01-Hopkins2015/10091
- Steinert App Dictionaries/01-Hopkins2015/10092
- Steinert App Dictionaries/01-Hopkins2015/10093
- Steinert App Dictionaries/01-Hopkins2015/10094
- Steinert App Dictionaries/01-Hopkins2015/10095
- Steinert App Dictionaries/01-Hopkins2015/10096
- Steinert App Dictionaries/01-Hopkins2015/10097
- Steinert App Dictionaries/01-Hopkins2015/10098
- Steinert App Dictionaries/01-Hopkins2015/10099
- Steinert App Dictionaries/01-Hopkins2015/101
- Steinert App Dictionaries/01-Hopkins2015/1010
- Steinert App Dictionaries/01-Hopkins2015/10100
- Steinert App Dictionaries/01-Hopkins2015/10101
- Steinert App Dictionaries/01-Hopkins2015/10102
- Steinert App Dictionaries/01-Hopkins2015/10103
- Steinert App Dictionaries/01-Hopkins2015/10104
- Steinert App Dictionaries/01-Hopkins2015/10105
- Steinert App Dictionaries/01-Hopkins2015/10106
- Steinert App Dictionaries/01-Hopkins2015/10107
- Steinert App Dictionaries/01-Hopkins2015/10108
- Steinert App Dictionaries/01-Hopkins2015/10109
- Steinert App Dictionaries/01-Hopkins2015/1011
- Steinert App Dictionaries/01-Hopkins2015/10110
- Steinert App Dictionaries/01-Hopkins2015/10111
- Steinert App Dictionaries/01-Hopkins2015/10112
- Steinert App Dictionaries/01-Hopkins2015/10113
- Steinert App Dictionaries/01-Hopkins2015/10114
- Steinert App Dictionaries/01-Hopkins2015/10115
- Steinert App Dictionaries/01-Hopkins2015/10116
- Steinert App Dictionaries/01-Hopkins2015/10117
- Steinert App Dictionaries/01-Hopkins2015/10118
- Steinert App Dictionaries/01-Hopkins2015/10119
- Steinert App Dictionaries/01-Hopkins2015/1012
- Steinert App Dictionaries/01-Hopkins2015/10120
- Steinert App Dictionaries/01-Hopkins2015/10121
- Steinert App Dictionaries/01-Hopkins2015/10122
- Steinert App Dictionaries/01-Hopkins2015/10123
- Steinert App Dictionaries/01-Hopkins2015/10124
- Steinert App Dictionaries/01-Hopkins2015/10125
- Steinert App Dictionaries/01-Hopkins2015/10126
- Steinert App Dictionaries/01-Hopkins2015/10127
- Steinert App Dictionaries/01-Hopkins2015/10128
- Steinert App Dictionaries/01-Hopkins2015/10129
- Steinert App Dictionaries/01-Hopkins2015/1013
- Steinert App Dictionaries/01-Hopkins2015/10130
- Steinert App Dictionaries/01-Hopkins2015/10131