Semantic search
Jump to navigation
Jump to search
Query-Depth:1
SQLStore debug output
ASK Query
[[Has telegram::+]]
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_uri` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='4040150')
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_uri` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='4040150')
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,p_id | p_id | 4 | const | 65 | 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:1Query-Depth:1
Errors and Warnings
None| Has telegram | Description | |
|---|---|---|
| Chris Sky | https://t.me/realchrissky | Canadian fighter for freedom, COVID-19/Resistance activist, anti-mask activist, anti-mandate activist, anti-communist, anti-tyranny activist |
| Lauren Southern | https://t.me/Lauren Southern | Lauren Southern is a Canadian activist. Probably the most famous personality in the Culture war of the late 2010s. |
| StopFake | https://t.me/StopFake | Spooky "fact checking" website to counter "Russian Propaganda". Backed by an alliance of groups including the Integrity Initiative. Some staff crossover with the Institute for Statecraft. |
| Maram Susli | https://t.me/syriangirlpartisan | Syrian girl. |
| The Duran | https://t.me/thedurancom | Alternative view on US/Nato foreign policy. |
| The Gateway Pundit | https://t.me/gatewaypunditofficial | The Gateway Pundit is an online news publication consisting of news, commentary and analysis. |
| Brittany Venti | https://t.me/brittanyventi | An American internet celebrity, who has been deeply affected by censorship on social media. |
| White Rose | https://t.me/JoinTheWhiteRose | COVID-19 resistance group taking the immense power of memetic warfare to the streets, via the medium of stickers! |
| Gerhard Wisnewski | https://t.me/GWisnewski | |
| Michael Yon | https://t.me/michaelyon | Former US soldier turned journalist |
| Maria Zakharova | https://t.me/MariaVladimirovnaZakharova | Russian female diplomat. Known for being the spokeswoman at the Ministry of Foreign Affairs. |
| Maria Zeee | https://t.me/s/zeeemedia | |
| Zev Zelenko | https://t.me/DrZelenkoMD | A New York doctor who has treated coronavirus patients using hydroxychloroquine with high success rate |
| Maksym Zhorin | https://t.me/MaksymZhorin | Azov commander |
| Garrett Ziegler | https://t.me/s/GarrettZ | Trump White House aide who published the content of Hunter Bidens devices online |
