Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Page type::Link]]
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, t5.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_time` AS t5 ON t0.smw_id=t5.s_id
WHERE
(t1.p_id=17834 AND t1.o_id=18079)
AND (t5.p_id=17822)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t5.o_sortkey DESC
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, t5.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_time` AS t5 ON t0.smw_id=t5.s_id
WHERE
(t1.p_id=17834 AND t1.o_id=18079)
AND (t5.p_id=17822)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t5.o_sortkey DESC
LIMIT
55
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t5 | ref | s_id, p_id, p_id_2, s_id_2 | p_id | 4 | const | 1020 | 100.00 | Backward index scan; Using temporary |
1 | SIMPLE | t1 | 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 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None- 2019/11/03 [L..T] Rabidly pro-Trump fake news site Epoch Times may be engaging in astroturfing “on Thursday, religious right activist Jim Garlow took to Facebook to confirm what a lot of people suspected – the most rabid fundies believe rolling back abortion and marriage equality are so important that they must go all-in for Trump. [..] Garlow took part in a gathering of Trumpvangelicals at the White House on Tuesday, and included a link to coverage of that gathering from an outfit known as "The BL". [...] a search turned up a Snopes investigation from October that revealed some too-close-for-comfort ties between BL and Epoch Times.”
- 2019/10/29 [L..T] [Serious Discussion] Attracting a higher homeless population with Durham's Affordable Housing Plan? “With a proposed $10,455,838 (pg. 4 in the referendum) to be spent on homeless programs over the next 5 years, how do we protect Durham from attracting an even greater number of homeless people?”
- 2019/10/29 [L..T] The Long Shadow of the 'Welfare Queen' “When Ronald Reagan and his advisors wanted to undermine the very institution of social programs, he turned to a news story out of Chicago – the tale of one Linda Taylor, who'd bilked the government benefits system out of so much money she was dubbed the "welfare queen."”
- 2019/10/28 [L..T] Facebook allows prominent right-wing website to break the rules “The Daily Wire, the right-wing website founded by pundit Ben Shapiro, is a cesspool of misogyny, bigotry, and misinformation. Its toxic content is also fantastically successful on Facebook, with each story reaching more people than any other major media outlet. A Popular Information investigation reveals some of this success is attributable to a clandestine network of 14 large Facebook pages that purport to be independent but exclusively promote content from The Daily Wire in a coordinated fashion.”
- 2019/10/28 [L..T] Protests Continue Against Neo-Confederates in North Carolina “Anti-racists continue to mobilize in North Carolina against neo-Confederate and white nationalist groups, with this weekend seeing two more arrests on the anti-racist side.”
- 2019/10/28 [L..T] James Patrick Shillinglaw, Identity Evropa/American Identity Movement, Jamestown, North Carolina “Asheville Anti-Racism exposed James Patrick Shillinglaw, of Jamestown, North Carolina, as a member of white nationalist group Identity Evropa, recently renamed the American Identity Movement.”
- 2019/10/28 [L..T] Jeremy Bertino, Proud Boy in Charlotte, North Carolina “Jeremy Bertino, of Locust, North Carolina, was exposed as a Proud Boy this week after rallying in Pittsboro, North Carolina.”
- 2019/10/28 [L..T] Victory over the worst gerrymander in modern history: Court blocks North Carolina GOP's House map “On Monday, a bipartisan panel of state court judges delivered a monumental victory against the worst gerrymander in modern history when it blocked North Carolina from using its Republican-drawn congressional map in the 2020 elections, clearing the way for a fairer replacement that could see Democrats pick up three or more seats.”
- 2019/10/21 [L..T] Statement on GitLab "The MoodleNet team use products and services from GitLab Inc. to develop the MoodleNet code base. We were therefore disappointed to learn of a recent decision by GitLab Inc. to change their policies around who they will and will not do business with."
- 2019/10/20 [L..T] Amazon is shipping expired food, from baby formula to old beef jerky, scaring consumers and putting big brands at risk “...items are arriving spoiled and well past their sell-by date, Amazon customers say. Interviews with brands, consumers, third-party sellers and consultants all point to loopholes in Amazon’s technology and logistics system that allow for expired items to proliferate with little to no accountability.”
- 2019/10/17 [L..T] Inside TurboTax's 20-Year Fight to Stop Americans From Filing Their Taxes for Free “Using lobbying, the revolving door and "dark pattern" customer tricks, Intuit fended off the government's attempts to make tax filing free and easy, and created its multi-billion-dollar franchise.”
- 2019/09/30 [L..T] Richard Dawkins Loves Evangelicals if They Hate Social Justice Richard Dawkins is uncompromising in his opposition to religion – except when it happens to oppose something that he thinks is worse, like social justice.
- 2019/09/12 [L..T] Why the neurodiversity movement has become harmful The movement has good intentions, but it favours the high-functioning and overlooks those who struggle with severe autism.
- 2019/08/05 [L..T] Will Durham’s business community support the city’s $95M affordable housing bond? ““A generation of opportunity” could be lost if voters don’t approve Durham’s $95 million affordable-housing bond this fall, [local businessman Steve Toler] said Monday.”
- 2019/06/24 [L..T] Abortion & Ben Shapiro “To DESTROY Ben Shapiro, you must first BECOME Ben Shapiro”
- 2019/04/22 [L..T] Here's How TurboTax Just Tricked You Into Paying to File Your Taxes "Did you know that if you make less than $66,000 a year, you can prepare and file your taxes for free? No? That’s no accident. Companies that make tax preparation software, like Intuit, the maker of TurboTax, would rather you didn’t know."
- 2019/02/26 [L..T] What You Need to Know About the Largest Proposed Housing Bond Referendum in North Carolina History "In [Mayor Steve Schewel's] view, the city's current funding for affordable housing isn’t enough to keep downtown from becoming an expensive enclave for white people. If residents are serious about preventing displacement, they need to put their money where their mouths are."
- 2019/01/03 [L..T] Transphobia in the UK a mostly-audio (spoken word) video (35:05) giving a fairly detailed layout of transnegation arguments in the UK
- 2018/11/05 [L..T] Why is British media so transphobic? "The answer lies in part to the coalescence of a certain set of ideas in a very specific circle of voices in the early 21st century – voices that later went on to hold high profile positions in much of the U.K.'s print and broadcast media."
- 2018/08/30 [L..T] Offering a more progressive definition of freedom Pete Buttigieg is the mayor of South Bend, Indiana. He is a progressive Democrat, Rhodes scholar, served a tour of duty in Afghanistan during his time as mayor, and is openly gay. In a recent interview with Rolling Stone, Buttigieg talked about the need for progressives to recast concepts that political conservatives have traditionally “owned” – like freedom, family, and patriotism – in more progressive terms.
- 2018/08/30 [L..T] Beaten for Autism? The person filmed by KGW News on June 4 being struck on the head 16 times by a Marion County sheriff deputy while pinned down by three additional officers says the incident may be partly understood as the response of uninformed individuals to people they don’t understand.
- 2018/08/16 [L..T] Rapid-onset gender dysphoria in adolescents and young adults: A study of parental reports In on-line forums, parents have been reporting that their children are experiencing what is described here as “rapid-onset gender dysphoria,” appearing for the first time during puberty or even after its completion.
- 2018/08/09 [L..T] Protester Maimed by Portland Police: ‘I Thought I Was Going to Die’ Anthony, who asked to be identified only by his first name, was injured last weekend when cops in riot gear unleashed flashbangs, pepper spray, rubber bullets and other less-lethal weapons as local protesters demonstrated against far-right groups massed downtown.
- 2018/08/07 [L..T] Protesters clash with guards at Portland City Hall; 2 arrested Protesters demanding reforms in police use of crowd control clashed with security officers at Portland City Hall after Mayor Ted Wheeler shut down a Wednesday morning City Council meeting.
- 2018/08/06 [L..T] Portland Police Chief: Allegations Of Protest Favoritism 'Ridiculous' "Everything that was anticipated ... with the very clear intent of what people wanted to do, with the level of confrontation and violence that they were expecting to bring, that did not occur. The officers were there and they prevented all of that from happening."
- 2018/08/04 [L..T] IGD Portland: Mass Community Mobilization Against Far-Right Live blog from antifascist mobilization in Portland, Oregon.
- 2018/08/04 [L..T] Portland's Patriot Prayer Rally Could Be Most Violent Since Charlottesville, Activists Say Armed, proto-fascist gangs are set to rally in Portland, Oregon, this weekend, stirring fears that the city could witness the kind of political violence not seen since the deadly white supremacist “Unite the Right” event in Charlottesville, Virginia, nearly a year ago.
- 2018/07/17 [L..T] Top Voting Machine Vendor Admits It Installed Remote-Access Software on Systems Sold to States “The nation's top voting machine maker has admitted in a letter to a federal lawmaker that the company installed remote-access software on election-management systems it sold over a period of six years, raising questions about the security of those systems and the integrity of elections that were conducted with them.”
- 2018/07/06 [L..T] Director’s Desk: Portland has criminalized poverty and mental illness “Now we know: More than half of the people arrested in Portland last year were homeless. [...] The ACLU of Oregon issued a report last year documenting 224 laws around the state that target people who are homeless. It identified laws that target people for sleeping in public places, for begging for money and for loitering. In other words, ACLU of Oregon researchers identified laws that matter only if you are homeless.”
- 2018/07/04 [L..T] Sheriff's office called on Oregon state legislator for representing constituents while black “"Casing" the neighborhood by knocking on doors and having extended conversations with the homeowners, carrying only a phone, a pen, and some leaflets. Bynum appears to have, sadly, taken it in stride. "It was just bizarre," she told an Oregonian reporter. "It boils down to people not knowing their neighbors and people having a sense of fear in their neighborhoods, which is kind of my job to help eradicate. But at the end of the day, it's important for people to feel like they can talk to each other to help minimize misunderstandings." Indeed. Had the woman who called the cops – it was a woman – simply engaged with Bynum, problem solved.”
- 2018/07/01 [L..T] When Children Say They’re Trans «Hormones? Surgery? The choices are fraught – and there are no easy answers.» ...except puberty blockers are generally a good idea. This article emphasizes the unknowns and the risks, and mistakenly implies they're not a good general solution.
- 2018/07/01 [L..T] Right-Wing Portland Rally Declared Riot Amid Clashes With Antifa Protesters A rally in Oregon sponsored by the right-wing group Patriot Prayer turned violent on Saturday as demonstrators clashed with anti-fascist protesters, who showed up in opposition to the event.
- 2018/06/30 [L..T] Portland Police Declare a Riot After Right-Wing Marchers Begin Beating Antifascists with Flag Poles «For the first time in more than a year of street brawling, Portland police today deemed a march by Proud Boys and other right-wing protesters too violent to continue.»
- 2018/06/27 [L..T] Portland Police Saw Right-Wing Protesters as "Much More Mainstream" Than Leftist Ones “Newly released draft reports from a city review of how Portland police handled dueling demonstrations last summer reveal cops admitting what activists have long suspected: They saw right-wing protesters as less of a threat than leftist ones.”
- 2018/06/22 [L..T] Contra the Fearmongering Atlantic Story, Trans-Affirming Care Is Great for Kids «Given all this hand-wringing over the children, it feels necessary to say, unambiguously, that such fears are overblown and can lead parents astray, guiding them toward decisions that may permanently harm their kids and endanger their relationship with them for the rest of their lives. Contrary to the fears of Singal and his ilk, current research supports a flexible approach that does not push children toward any particular outcome, and best practices put the needs of seriously distressed children first.»
- 2018/06/22 [L..T] Woman who set self on fire in Portland park remembered as 'brilliant and tortured' artist “The 31-year-old woman walked on crutches into a downtown Portland park. Minutes later, she set herself on fire. Bystanders put out the fire that consumed Chloe Sagal, but she died from her injuries. It was an act, witnesses and friends say, that was a political protest as well as a suicide.”
- 2018/06/06 [L..T] Portland Police Chief Danielle Outlaw on protests, trust and learning her new city "The mix-up proved to be a quick, hard lesson for Outlaw on Portland's unusual commission form of government. Mayor Ted Wheeler, who also serves as police commissioner, doesn’t have the final say on decisions like this. He must wade through established city procedures and gain majority support on the City Council."
- 2018/03/28 [L..T] Is J.K. Rowling Transphobic? A Trans Woman Investigates "Ultimately, the answer is yes, she is transphobic, at least in the ways that so many average cisgender people can be. However, because she’s J.K. Rowling, creator of the best-selling book series of all time and an idol to so many LGBTQ+ children and now adults, she gets called out for it. I think it's fair that she receives criticism from trans people, especially given her advocacy on behalf of queer people in general, but also because she has a huge platform. Many people look up to her for creating a singular piece of popular culture that holds deep meaning for fans from different walks of life, and she has a responsibility to handle that platform wisely."
- 2018/03/05 [L..T] Sex Change: Physically Impossible, Psychosocially Unhelpful, and Philosophically Misguided "Modern medicine can’t reassign sex physically, and attempting to do so doesn’t produce good outcomes psychosocially. Here is the evidence." Article presents evidence to the contrary, ignores it, and repeatedly concludes that selected ideologues are prima facie correct.
- 2018/02/15 [L..T] Transgender Women Aren't "Women" "I wanted to talk about the fact that I personally find it kind of offensive when transgender people don't own the fact that they're trans." Video is Tweeted, and much debate ensues.
- 2018/01/22 [L..T] Vast majority of new wealth last year went to top 1% “A new billionaire is created every other day. The three richest Americans have the same amount of wealth as the poorest half of the U.S. population. And 82% of the global wealth generated last year went to just 1% of the world's population.”
- 2018/01/15 [L..T] Arsonist TERF thinks trans women are immoral & should be beaten "I’m quite prepared to threaten violence because it seems to me that politically what they’re seeking to do is piss on all women. That’s what they’re doing for their personal gratification. There aren’t many of them, but what really offends me is the extent to which academia and political parties have listened to them in a way that they’re not listening to us as women." – Linda Bellos
- 2017/09/04 [L..T] The Purge Of Transgender People From American Life Has Begun “Five members of Trump's evangelical executive advisory board, including the founder of the Family Research Council James Dobson, signed the Nashville Statement. The Nashville statement dictated that transgender people should not be tolerated in society, and that anyone who tolerates them is not a Christian.”
- 2017/09/01 [L..T] How Russian & Alt-Right Twitter Accounts Worked Together to Skew the Narrative About Berkeley “The narrative surrounding last weekend’s protests in Berkeley took shape on social media and was picked up, at least in part, by mainstream news outlets. The result was a skewed presentation of events that was almost entirely devoid of the context in which they took place. Even more troubling: that narrative was influenced by pro-Russian social media networks, including state-sponsored propaganda outlets, botnets, cyborgs, and individual users.”
- 2017/09/01 [L..T] The Idiot Boys of Antifa and the Alt-Right “A lot of what’s happened over the last 10,000 years can be attributed to hormonally charged young men pulling stupid crap.”
- 2017/08/31 [L..T] Preacher Aligned with Portland-Area Far-Right Group Promises “Bloodshed” at Future Rallies “Portland resident and far-right preacher Allen Pucket has penned an inflammatory Facebook post promising violence at future protests, possibly including the upcoming "Freedom March" and counter-protests slated to envelop downtown Portland on Sept. 10..”
- 2017/08/31 [L..T] The Right Wing 'God Will Wipe Them Out': White Supremacist Preacher Promises 'Bloodshed' at Future Rallies “In a video, Pucket also said that “God’s going to wipe them out one day anyway,” referring to anti-racist and anti-fascist counter-protesters who have marched against white supremacist groups in recent months. He also professed a belief that those who organize such rallies shouldn’t cancel them for fear of violent retaliation, but should be "patriots" willing to "fight" in the streets for their white supremacist beliefs.”
- 2017/08/19 [L..T] The truth has got its boots on: what the evidence says about Mr. Damore’s Google memo a detailed rebuttal of the supposedly-scientific arguments supporting Damore's arguments; includes links to many other rebuttals and related resources
- 2017/08/13 [L..T] Damore's Claim There Are Population-Level Differences Between the Genders Is Not The Central Problem With His Manifesto. “In response to the Damore manifesto, "Heterodox Academy", a group that includes multiple political points of view, posted that the scientific evidence is strong that there are population-level differences between the genders. However, the bare assertion that there are population-level differences between the genders is not the central problem with Damore's manifesto.”
- 2017/08/11 [L..T] We've studied gender and STEM for 25 years. The science doesn't support the Google memo. “These are some issues that males simply do not have to face. The "anxiety gap" exists for a reason, and it is not about biology.”