Semantic search
SQLStore debug output
ASK Query
[[Part of::Property:Corolla]]
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
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='2719' AND t1.o_id='3566')
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
500
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
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='2719' AND t1.o_id='3566')
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
500
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id | 5 | const | 916 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | mediawiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneL
- Lobe arrangement or shape
- Lobe arrangement or shape or course
- Lobe atypical length
- Lobe atypical quantity
- Lobe atypical some measurement
- Lobe atypical width
- Lobe character
- Lobe character or shape
- Lobe coating
- Lobe coloration
- Lobe coloration or density
- Lobe coloration or odor
- Lobe coloration or pubescence or relief
- Lobe condition
- Lobe condition or size
- Lobe course
- Lobe degree
L cont.
- Lobe density
- Lobe depth
- Lobe derivation
- Lobe development
- Lobe duration
- Lobe fixation or orientation
- Lobe fragility
- Lobe fragility or size
- Lobe fragility or texture
- Lobe fusion
- Lobe growth form or texture
- Lobe height
- Lobe height or length
- Lobe height or length or size
- Lobe l w ratio
- Lobe length
- Lobe length or size
L cont.
- Lobe length/width
- Lobe lengths
- Lobe life cycle
- Lobe more or les length
- Lobe orientation
- Lobe orientation or shape
- Lobe position
- Lobe position or shape
- Lobe position or structure subtype
- Lobe position relational or variability
- Lobe presence
- Lobe prominence
- Lobe pubescence
- Lobe pubescence or relief
- Lobe pubescence or texture
- Lobe quantity