To get rid of this ad please Sign up/Login.
Semantic search
Debug output SQLStore
ASK Query
[[Category:Arkadia Underground Deeds Revenues]]
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_time` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=44055)
AND (t4.p_id=52550)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
255
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, t4.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_time` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=44055)
AND (t4.p_id=52550)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
255
OFFSET
100
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 | 283 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t4 | ref | s_id, p_id, p_id_2, s_id_2 | s_id_2 | 8 | entropiamw.t1.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | entropiamw.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneDate | Arkadia Underground Total (PED) | Revenue/Deed (PED) | Markup | Form Edit Link |
---|---|---|---|---|
28 September 2014 | 0.02 | ¦class=fa fa-pencil | ||
27 September 2014 | 0.01 | ¦class=fa fa-pencil | ||
26 September 2014 | 0 | ¦class=fa fa-pencil | ||
25 September 2014 | 0.01 | ¦class=fa fa-pencil | ||
24 September 2014 | 0.01 | ¦class=fa fa-pencil | ||
23 September 2014 | 0.01 | ¦class=fa fa-pencil | ||
22 September 2014 | 0.02 | ¦class=fa fa-pencil | ||
21 September 2014 | 0.03 | ¦class=fa fa-pencil | ||
20 September 2014 | 0.02 | ¦class=fa fa-pencil | ||
19 September 2014 | 0 | ¦class=fa fa-pencil | ||
18 September 2014 | 0.01 | ¦class=fa fa-pencil | ||
17 September 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
16 September 2014 | 0.01 | 48.85 | ¦class=fa fa-pencil | |
15 September 2014 | 0.01 | 49.29 | ¦class=fa fa-pencil | |
14 September 2014 | 0.01 | 48.78 | ¦class=fa fa-pencil | |
13 September 2014 | 0.01 | 43.05 | ¦class=fa fa-pencil | |
12 September 2014 | 0.01 | 49.1 | ¦class=fa fa-pencil | |
11 September 2014 | 0.01 | 50.13 | ¦class=fa fa-pencil | |
10 September 2014 | 0 | 49.12 | ¦class=fa fa-pencil | |
9 September 2014 | 0.01 | ¦class=fa fa-pencil | ||
8 September 2014 | 0.01 | 49.17 | ¦class=fa fa-pencil | |
7 September 2014 | 0.01 | 48.9 | ¦class=fa fa-pencil | |
6 September 2014 | 0 | 47.5 | ¦class=fa fa-pencil | |
5 September 2014 | 0.01 | 48.6 | ¦class=fa fa-pencil | |
4 September 2014 | 0.01 | 48.1 | ¦class=fa fa-pencil | |
3 September 2014 | 0.01 | 50.1 | ¦class=fa fa-pencil | |
2 September 2014 | 0 | 50.2 | ¦class=fa fa-pencil | |
1 September 2014 | 0.01 | 49.9 | ¦class=fa fa-pencil | |
31 August 2014 | 0.01 | 47.6 | ¦class=fa fa-pencil | |
28 August 2014 | 0.01 | 47.5 | ¦class=fa fa-pencil | |
27 August 2014 | 0.01 | 48.45 | ¦class=fa fa-pencil | |
26 August 2014 | 0 | 48.9 | ¦class=fa fa-pencil | |
25 August 2014 | 0.03 | 49.8 | ¦class=fa fa-pencil | |
24 August 2014 | 0.06 | 48.5 | ¦class=fa fa-pencil | |
23 August 2014 | 0.02 | 48.05 | ¦class=fa fa-pencil | |
22 August 2014 | 0.01 | 48.15 | ¦class=fa fa-pencil | |
21 August 2014 | 0.01 | 47.3 | ¦class=fa fa-pencil | |
20 August 2014 | 0.01 | 48 | ¦class=fa fa-pencil | |
19 August 2014 | 0.01 | 46 | ¦class=fa fa-pencil | |
18 August 2014 | 0.01 | 45.5 | ¦class=fa fa-pencil | |
17 August 2014 | 0.01 | 47 | ¦class=fa fa-pencil | |
16 August 2014 | 0 | 49 | ¦class=fa fa-pencil | |
15 August 2014 | 0.01 | 48.3 | ¦class=fa fa-pencil | |
14 August 2014 | 0.01 | 48.2 | ¦class=fa fa-pencil | |
13 August 2014 | 0.01 | 47.16 | ¦class=fa fa-pencil | |
12 August 2014 | 0.01 | 49 | ¦class=fa fa-pencil | |
11 August 2014 | 0.01 | 49 | ¦class=fa fa-pencil | |
10 August 2014 | 0.02 | 49 | ¦class=fa fa-pencil | |
9 August 2014 | 0.01 | 49 | ¦class=fa fa-pencil | |
8 August 2014 | 0.01 | 49 | ¦class=fa fa-pencil | |
7 August 2014 | 0.01 | 49 | ¦class=fa fa-pencil | |
6 August 2014 | 0 | 49 | ¦class=fa fa-pencil | |
5 August 2014 | 0.01 | 49 | ¦class=fa fa-pencil | |
4 August 2014 | 0.09 | 44.4 | ¦class=fa fa-pencil | |
3 August 2014 | 0.05 | 44.42 | ¦class=fa fa-pencil | |
2 August 2014 | 0.01 | 44.42 | ¦class=fa fa-pencil | |
1 August 2014 | 0.01 | 44.43 | ¦class=fa fa-pencil | |
31 July 2014 | 0.01 | 44.43 | ¦class=fa fa-pencil | |
30 July 2014 | 0.01 | 44.43 | ¦class=fa fa-pencil | |
29 July 2014 | 0.01 | 44.45 | ¦class=fa fa-pencil | |
28 July 2014 | 0 | 44.49 | ¦class=fa fa-pencil | |
27 July 2014 | 0.01 | 44.53 | ¦class=fa fa-pencil | |
26 July 2014 | 0.01 | 44.56 | ¦class=fa fa-pencil | |
25 July 2014 | 0 | 44.59 | ¦class=fa fa-pencil | |
24 July 2014 | 0.01 | 44.61 | ¦class=fa fa-pencil | |
23 July 2014 | 0 | 44.64 | ¦class=fa fa-pencil | |
22 July 2014 | 0.01 | 44.67 | ¦class=fa fa-pencil | |
21 July 2014 | 0.02 | 44.7 | ¦class=fa fa-pencil | |
20 July 2014 | 0.04 | 44.73 | ¦class=fa fa-pencil | |
19 July 2014 | 0.01 | 44.75 | ¦class=fa fa-pencil | |
18 July 2014 | 0.01 | 44.77 | ¦class=fa fa-pencil | |
17 July 2014 | 0 | 44.8 | ¦class=fa fa-pencil | |
16 July 2014 | 0.01 | 44.83 | ¦class=fa fa-pencil | |
15 July 2014 | 0.01 | 44.85 | ¦class=fa fa-pencil | |
14 July 2014 | 0 | 44.87 | ¦class=fa fa-pencil | |
13 July 2014 | 0.01 | 44.9 | ¦class=fa fa-pencil | |
12 July 2014 | 0 | 44.93 | ¦class=fa fa-pencil | |
11 July 2014 | 0.01 | 44.96 | ¦class=fa fa-pencil | |
10 July 2014 | 0 | 44.97 | ¦class=fa fa-pencil | |
9 July 2014 | 0 | 45 | ¦class=fa fa-pencil | |
8 July 2014 | 0.01 | 45.03 | ¦class=fa fa-pencil | |
7 July 2014 | 0.02 | 45.06 | ¦class=fa fa-pencil | |
6 July 2014 | 0.01 | 45.09 | ¦class=fa fa-pencil | |
5 July 2014 | 0.02 | 45.13 | ¦class=fa fa-pencil | |
4 July 2014 | 0.00111 | 50 | ¦class=fa fa-pencil | |
3 July 2014 | 0.01 | 45.21 | ¦class=fa fa-pencil | |
2 July 2014 | 0 | 45.26 | ¦class=fa fa-pencil | |
1 July 2014 | 0.01 | 45.31 | ¦class=fa fa-pencil | |
30 June 2014 | 0 | 45.38 | ¦class=fa fa-pencil | |
29 June 2014 | 0.01 | 45.47 | ¦class=fa fa-pencil | |
28 June 2014 | 0 | 45.55 | ¦class=fa fa-pencil | |
27 June 2014 | 0.01 | 45.64 | ¦class=fa fa-pencil | |
26 June 2014 | 0 | 45.72 | ¦class=fa fa-pencil | |
25 June 2014 | 0 | 45.81 | ¦class=fa fa-pencil | |
24 June 2014 | 0.01 | 45.91 | ¦class=fa fa-pencil | |
23 June 2014 | 0 | 46.02 | ¦class=fa fa-pencil | |
22 June 2014 | 0.01 | 46.13 | ¦class=fa fa-pencil | |
21 June 2014 | 0.01 | 46.26 | ¦class=fa fa-pencil | |
20 June 2014 | 0 | 46.43 | ¦class=fa fa-pencil | |
19 June 2014 | 0.01 | 46.62 | ¦class=fa fa-pencil | |
18 June 2014 | 0 | 46.76 | ¦class=fa fa-pencil | |
17 June 2014 | 0.01 | 46.9 | ¦class=fa fa-pencil | |
16 June 2014 | 0.01 | 47.03 | ¦class=fa fa-pencil | |
15 June 2014 | 0.01 | 47.19 | ¦class=fa fa-pencil | |
14 June 2014 | 0 | 47.31 | ¦class=fa fa-pencil | |
13 June 2014 | 0.01 | 47.45 | ¦class=fa fa-pencil | |
12 June 2014 | 0 | 47.44 | ¦class=fa fa-pencil | |
11 June 2014 | 0.01 | 47.44 | ¦class=fa fa-pencil | |
10 June 2014 | 0.01 | 47.43 | ¦class=fa fa-pencil | |
9 June 2014 | 0 | 47.43 | ¦class=fa fa-pencil | |
8 June 2014 | 0.01 | 47.42 | ¦class=fa fa-pencil | |
7 June 2014 | 0.01 | 47.41 | ¦class=fa fa-pencil | |
6 June 2014 | 0 | 47.41 | ¦class=fa fa-pencil | |
5 June 2014 | 0.01 | 47.4 | ¦class=fa fa-pencil | |
4 June 2014 | 0 | 47.4 | ¦class=fa fa-pencil | |
3 June 2014 | 0.01 | 47.39 | ¦class=fa fa-pencil | |
2 June 2014 | 0.01 | 47.39 | ¦class=fa fa-pencil | |
1 June 2014 | 0.01 | 47.38 | ¦class=fa fa-pencil | |
31 May 2014 | 0 | 47.37 | ¦class=fa fa-pencil | |
30 May 2014 | 0.01 | 47.37 | ¦class=fa fa-pencil | |
29 May 2014 | 0.01 | 47.36 | ¦class=fa fa-pencil | |
28 May 2014 | 0 | 47.35 | ¦class=fa fa-pencil | |
27 May 2014 | 0.01 | 47.34 | ¦class=fa fa-pencil | |
26 May 2014 | 0.01 | 47.34 | ¦class=fa fa-pencil | |
25 May 2014 | 0 | 47.5 | ¦class=fa fa-pencil | |
24 May 2014 | 0.03 | 47.71 | ¦class=fa fa-pencil | |
23 May 2014 | 0.01 | 47.83 | ¦class=fa fa-pencil | |
22 May 2014 | 0 | 48.01 | ¦class=fa fa-pencil | |
21 May 2014 | 0 | 48.16 | ¦class=fa fa-pencil | |
20 May 2014 | 0.01 | 48.39 | ¦class=fa fa-pencil | |
19 May 2014 | 0.01 | 48.58 | ¦class=fa fa-pencil | |
18 May 2014 | 0.01 | 48.71 | ¦class=fa fa-pencil | |
17 May 2014 | 0.01 | 48.89 | ¦class=fa fa-pencil | |
16 May 2014 | 0 | 49.1 | ¦class=fa fa-pencil | |
15 May 2014 | 0.01 | 49.26 | ¦class=fa fa-pencil | |
14 May 2014 | 0.01 | 49.4 | ¦class=fa fa-pencil | |
13 May 2014 | 0.01 | 49.51 | ¦class=fa fa-pencil | |
12 May 2014 | 0.01 | 49.65 | ¦class=fa fa-pencil | |
11 May 2014 | 0.01 | 49.8 | ¦class=fa fa-pencil | |
10 May 2014 | 0.01 | 49.9 | ¦class=fa fa-pencil | |
8 May 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
7 May 2014 | 0 | 50 | ¦class=fa fa-pencil | |
6 May 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
5 May 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
4 May 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
3 May 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
2 May 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
1 May 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
30 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
29 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
28 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
27 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
26 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
25 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
24 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
23 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
22 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
21 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
20 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
19 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
18 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
17 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
16 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
15 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
14 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
13 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
12 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
11 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
10 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
9 April 2014 | 0.03 | 50 | ¦class=fa fa-pencil | |
8 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
7 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
6 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
5 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
4 April 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
3 April 2014 | 0.03 | 50 | ¦class=fa fa-pencil | |
2 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
1 April 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
31 March 2014 | 0.01 | 50 | ¦class=fa fa-pencil | |
30 March 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
29 March 2014 | 0.02 | 50 | ¦class=fa fa-pencil | |
28 March 2014 | 0.03 | 50 | ¦class=fa fa-pencil | |
27 March 2014 | 0.01 | 50 | ¦class=fa fa-pencil |