Semantic search
No Barikadopēdija
SQLStore debug output
ASK Query
[[Issue of::Padomju 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, t0.smw_sort
FROM
`wik2smw_object_ids` AS t0
INNER JOIN
`wik2smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='522' AND t1.o_id='610')
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
150
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
`wik2smw_object_ids` AS t0
INNER JOIN
`wik2smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='522' AND t1.o_id='610')
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
150
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 | 994 | Using temporary; Using filesort |
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 | |
---|---|---|---|---|
PJ19860808 | 1986-08-08 | 1986 | 153 | 4 |
PJ19860809 | 1986-08-09 | 1986 | 154 | 4 |
PJ19860812 | 1986-08-12 | 1986 | 155 | 4 |
PJ19860813 | 1986-08-13 | 1986 | 156 | 4 |
PJ19860815 | 1986-08-15 | 1986 | 157 | 4 |
PJ19860816 | 1986-08-16 | 1986 | 158 | 4 |
PJ19860819 | 1986-08-19 | 1986 | 159 | 4 |
PJ19860820 | 1986-08-20 | 1986 | 160 | 4 |
PJ19860821 | 1986-08-21 | 1986 | 161 | 4 |
PJ19860822 | 1986-08-22 | 1986 | 162 | 4 |
PJ19860823 | 1986-08-23 | 1986 | 163 | 4 |
PJ19860826 | 1986-08-26 | 1986 | 164 | 4 |
PJ19860827 | 1986-08-27 | 1986 | 165 | 4 |
PJ19860828 | 1986-08-28 | 1986 | 166 | 4 |
PJ19860829 | 1986-08-29 | 1986 | 167 | 4 |
PJ19860830 | 1986-08-30 | 1986 | 168 | 4 |
PJ19860902 | 1986-09-02 | 1986 | 169 | 4 |
PJ19860903 | 1986-09-03 | 1986 | 170 | 4 |
PJ19860904 | 1986-09-04 | 1986 | 171 | 4 |
PJ19860905 | 1986-09-05 | 1986 | 172 | 4 |
PJ19860906 | 1986-09-06 | 1986 | 173 | 4 |
PJ19860909 | 1986-09-09 | 1986 | 174 | 4 |
PJ19860910 | 1986-09-10 | 1986 | 175 | 4 |
PJ19860911 | 1986-09-11 | 1986 | 176 | 4 |
PJ19860912 | 1986-09-12 | 1986 | 177 | 4 |
PJ19860913 | 1986-09-13 | 1986 | 178 | 4 |
PJ19860916 | 1986-09-16 | 1986 | 179 | 4 |
PJ19860917 | 1986-09-17 | 1986 | 180 | 4 |
PJ19860918 | 1986-09-18 | 1986 | 181 | 4 |
PJ19860919 | 1986-09-19 | 1986 | 182 | 4 |
PJ19860920 | 1986-09-20 | 1986 | 183 | 4 |
PJ19860923 | 1986-09-23 | 1986 | 184 | 4 |
PJ19860924 | 1986-09-24 | 1986 | 185 | 4 |
PJ19860926 | 1986-09-26 | 1986 | 186 | 4 |
PJ19860930 | 1986-09-30 | 1986 | 188 | 4 |
PJ19861001 | 1986-10-01 | 1986 | 189 | 4 |
PJ19861002 | 1986-10-02 | 1986 | 190 | 4 |
PJ19861003 | 1986-10-03 | 1986 | 191 | 4 |
PJ19861004 | 1986-10-04 | 1986 | 192 | 4 |
PJ19861007 | 1986-10-07 | 1986 | 193 | 4 |
PJ19861009 | 1986-10-09 | 1986 | 194 | 4 |
PJ19861010 | 1986-10-10 | 1986 | 195 | 4 |
PJ19861011 | 1986-10-11 | 1986 | 196 | 4 |
PJ19861014 | 1986-10-14 | 1986 | 197 | 4 |
PJ19861015 | 1986-10-15 | 1986 | 198 | 4 |
PJ19861016 | 1986-10-16 | 1986 | 199 | 4 |
PJ19861017 | 1986-10-17 | 1986 | 200 | 4 |
PJ19861018 | 1986-10-18 | 1986 | 201 | 4 |
PJ19861021 | 1986-10-21 | 1986 | 202 | 4 |
PJ19861022 | 1986-10-22 | 1986 | 203 | 4 |