Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has participant::Victor Halberstadt]]
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1326704' AND t1.o_id='89801')
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
50
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1326704' AND t1.o_id='89801')
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
50
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 | 58 | Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikispooks.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneEvent | Start | End | Location(s) | Description |
---|---|---|---|---|
WEF/Annual Meeting/2013 | 23 January 2013 | 27 January 2013 | Switzerland | 2500 mostly unelected leaders met to discuss "leading through adversity" |
WEF/Annual Meeting/2014 | 22 January 2014 | 25 January 2014 | World Economic Forum Switzerland | 2604 guests in Davos considered "Reshaping The World" |
WEF/Annual Meeting/2016 | 20 January 2016 | 23 January 2016 | World Economic Forum Switzerland | Attended by over 2500 people, both leaders and followers, who were explained how the Fourth Industrial Revolution would changed everything, including being a "revolution of values". |
WEF/Annual Meeting/2017 | 17 January 2017 | 20 January 2017 | World Economic Forum Switzerland | 2950 known participants, including prominently Bill Gates. "Offers a platform for the most effective and engaged leaders to achieve common goals for greater societal leadership." |
WEF/Annual Meeting/2019 | 22 January 2019 | 25 January 2019 | Switzerland | |
WEF/Annual Meeting/2020 | 21 January 2020 | 24 January 2020 | World Economic Forum Switzerland | This mega-summit of the world's ruling class and their political and media appendages happens every year, but 2020 was special, as the continuous corporate media coverage of COVID-19 started more or less from one day to the next on 20/21 January 2020, coinciding with the start of the meeting. |
WEF/Annual Meeting/2022 | 22 May 2022 | 26 May 2022 | World Economic Forum Switzerland | 1912 guests in Davos |
WEF/Annual Meeting/2023 | 16 January 2023 | 20 January 2023 | World Economic Forum Switzerland | The theme of the meeting was "Cooperation in a Fragmented World" |