Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Page type::Link]] [[Topic::US Republican Party]]
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, t9.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_wikipage` AS t2
INNER JOIN
`smw_di_wikipage` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_time` AS t9 ON t0.smw_id=t9.s_id
WHERE
(t2.p_id=17834 AND t2.o_id=18079
AND (t5.p_id=17850 AND t5.o_id=24354)
)
AND (t9.p_id=17822)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t9.o_sortkey DESC
LIMIT
35
OFFSET
30
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, t9.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_wikipage` AS t2
INNER JOIN
`smw_di_wikipage` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_time` AS t9 ON t0.smw_id=t9.s_id
WHERE
(t2.p_id=17834 AND t2.o_id=18079
AND (t5.p_id=17850 AND t5.o_id=24354)
)
AND (t9.p_id=17822)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t9.o_sortkey DESC
LIMIT
35
OFFSET
30
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t5 | 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 | 43 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | t2 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | s_id_2 | 9 | ispda_en_mw.t5.s_id, const | 1 | 22.24 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | ispda_en_mw.t5.s_id | 1 | 50.04 | Using where |
1 | SIMPLE | t9 | ref | s_id, p_id, p_id_2, s_id_2 | s_id_2 | 8 | ispda_en_mw.t5.s_id, const | 1 | 100.00 | Using index |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneRelated
- 2011/07/24 [L..T] JP Morgan Tells Investors Why Middle Class Americans Are Screwed
- 2011/07/14 [L..T] Getting to Crazy The insanity of the GOP, which many people are finally just noticing, has been building gradually for a long time.
- 2009/05/31 [L..T] Why do people persist in voting Republican? “I happened to read University of Virginia Psychologist Jonathan Haidt's thoughtful essay on what makes people vote Republican ... Read the whole thing. You might even conclude, as I suspect Haidt does, that Republican voters tend to be more nuanced and sophisticated than Democratic voters.”
- 2009/03/07 [L..T] "Bipartisan DEFINED !" : RUSH LIMBAUGH : CPAC Convention 2009 “To us, bipartisanship is them being forced to agree with us after we have politically cleaned their clocks and beaten them.”
- 2008/09/19 [L..T] Scientists Explain Why People Vote For Republicans a collection of scientific investigations into why people vote Republican
- 2008/09/09 [L..T] What Makes People Vote Republican? “People vote Republican because Republicans offer "moral clarity" – a simple vision of good and evil that activates deep seated fears in much of the electorate. Democrats, in contrast, appeal to reason with their long-winded explorations of policy options for a complex world.” However, “to see what Democrats have been missing, it helps to take off the halo, step back for a moment, and think about what morality really is.”