Semantic search
No Barikadopēdija
SQLStore debug output
ASK Query
[[Issue of::Latvijas Jaunatne]]
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, t5.o_sortkey
FROM
`wik2smw_object_ids` AS t0
INNER JOIN
`wik2smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`wik2smw_di_time` AS t5 ON t0.smw_id=t5.s_id
WHERE
(t1.p_id='522' AND t1.o_id='662')
AND (t5.p_id='515')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t5.o_sortkey ASC
LIMIT
55
OFFSET
100
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, t5.o_sortkey
FROM
`wik2smw_object_ids` AS t0
INNER JOIN
`wik2smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`wik2smw_di_time` AS t5 ON t0.smw_id=t5.s_id
WHERE
(t1.p_id='522' AND t1.o_id='662')
AND (t5.p_id='515')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t5.o_sortkey ASC
LIMIT
55
OFFSET
100
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_3 | 9 | const,const | 937 | Using temporary; Using filesort |
1 | SIMPLE | t5 | ref | s_id,p_id,p_id_2,s_id_2 | s_id_2 | 8 | bpd_wikiver2.t1.s_id,const | 1 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | bpd_wikiver2.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneDatums | Gads | Numurs | Lappuses | |
---|---|---|---|---|
LJ19900606 | 1990-06-06 | 1990 | 101 | 4 |
LJ19900608 | 1990-06-08 | 1990 | 102 | 4 |
LJ19900609 | 1990-06-09 | 1990 | 103 | 4 |
LJ19900612 | 1990-06-12 | 1990 | 104 | 4 |
LJ19900614 | 1990-06-14 | 1990 | 105 | 4 |
LJ19900616 | 1990-06-16 | 1990 | 106 | 4 |
LJ19900619 | 1990-06-19 | 1990 | 107 | 4 |
LJ19900620 | 1990-06-20 | 1990 | 108 | 4 |
LJ19900622 | 1990-06-22 | 1990 | 109 | 4 |
LJ19900623 | 1990-06-23 | 1990 | 110 | 7 |
LJ19900626 | 1990-06-26 | 1990 | 111 | 4 |
LJ19900628 | 1990-06-28 | 1990 | 112 | 4 |
LJ19900630 | 1990-06-30 | 1990 | 113 | 4 |
LJ19900703 | 1990-07-03 | 1990 | 114 | 4 |
LJ19900704 | 1990-07-04 | 1990 | 115 | 4 |
LJ19900706 | 1990-07-06 | 1990 | 116 | 4 |
LJ19900707 | 1990-07-07 | 1990 | 117 | 4 |
LJ19900710 | 1990-07-10 | 1990 | 118 | 4 |
LJ19900712 | 1990-07-12 | 1990 | 119 | 4 |
LJ19900714 | 1990-07-14 | 1990 | 120 | 4 |
LJ19900717 | 1990-07-17 | 1990 | 121 | 4 |
LJ19900718 | 1990-07-18 | 1990 | 122 | 4 |
LJ19900720 | 1990-07-20 | 1990 | 123 | 4 |
LJ19900721 | 1990-07-21 | 1990 | 124 | 4 |
LJ19900724 | 1990-07-24 | 1990 | 125 | 4 |
LJ19900726 | 1990-07-26 | 1990 | 126 | 4 |
LJ19900728 | 1990-07-28 | 1990 | 127 | 4 |
LJ19900731 | 1990-07-31 | 1990 | 128 | 4 |
LJ19900801 | 1990-08-01 | 1990 | 129 | 4 |
LJ19900803 | 1990-08-03 | 1990 | 130 | 4 |
LJ19900804 | 1990-08-04 | 1990 | 131 | 4 |
LJ19900807 | 1990-08-07 | 1990 | 132 | 4 |
LJ19900808 | 1990-08-08 | 1990 | 133 | 4 |
LJ19900810 | 1990-08-10 | 1990 | 134 | 4 |
LJ19900811 | 1990-08-11 | 1990 | 135 | 4 |
LJ19900814 | 1990-08-14 | 1990 | 136 | 4 |
LJ19900815 | 1990-08-15 | 1990 | 137 | 4 |
LJ19900817 | 1990-08-17 | 1990 | 138 | 4 |
LJ19900818 | 1990-08-18 | 1990 | 139 | 4 |
LJ19900821 | 1990-08-21 | 1990 | 140 | 4 |
LJ19900822 | 1990-08-22 | 1990 | 141 | 4 |
LJ19900823 | 1990-08-23 | 1990 | 142 | 4 |
LJ19900825 | 1990-08-25 | 1990 | 143 | 4 |
LJ19900828 | 1990-08-28 | 1990 | 144 | 4 |
LJ19900829 | 1990-08-29 | 1990 | 145 | 4 |
LJ19900831 | 1990-08-31 | 1990 | 146 | 4 |
LJ19900901 | 1990-09-01 | 1990 | 147 | 4 |
LJ19900904 | 1990-09-04 | 1990 | 148 | 4 |
LJ19900905 | 1990-09-05 | 1990 | 149 | 4 |
LJ19900907 | 1990-09-07 | 1990 | 150 | 4 |