Uncategorized – Polysyncronism

It is the practice of making tweets invisible to the general public in an attempt to censor a particular user. That is the truth. A more politically correct answer is that it is the technique of blocking a user that so that they don’t know that they are being blocked. It is pure deception.

Originally, the concept was intended to reduce spam or undesirable posts from a user that was considered a problem. However, there is a potential that this practice can be abused and used for nefarious purposes. Who judges whether a user is a problem or not and what motives are behind that decision?

I really became interested in this because after the topic came up on twitter. A well known cartoonist named Scott Adams wrote this blog post about shadow banning.

http://allnewspipeline.com/Smoking_Gun_Twitter_Shadow_Ban_List.php
http://www.breitbart.com/tech/2017/02/16/twitter-introduces-account-limiting-for-abusive-behavior/

CREATE TABLE #Sample
(  
 Status int,
Month varchar(5),  
Capacity int
);  

Insert into #Sample (Status,Month,Capacity) values (1,'01/16',5)
Insert into #Sample (Status,Month,Capacity) values (3,'01/16',2)
Insert into #Sample (Status,Month,Capacity) values (1,'02/16',11)
Insert into #Sample (Status,Month,Capacity) values (3,'02/16',20)
Insert into #Sample (Status,Month,Capacity) values (1,'03/16',8)
Insert into #Sample (Status,Month,Capacity) values (3,'03/16',12)
Insert into #Sample (Status,Month,Capacity) values (1,'04/16',4)
Insert into #Sample (Status,Month,Capacity) values (2,'04/16',10)
Insert into #Sample (Status,Month,Capacity) values (3,'04/16',18)
Insert into #Sample (Status,Month,Capacity) values (2,'05/16',14)
Insert into #Sample (Status,Month,Capacity) values (3,'05/16',37)
Insert into #Sample (Status,Month,Capacity) values (2,'06/16',4)
Insert into #Sample (Status,Month,Capacity) values (3,'06/16',8)

select * from #Sample

SELECT
   a.status,
   a.month,
   a.capacity,
   b.capacity AS total_capacity,
   a.capacity - b.capacity AS net_capacity
FROM
   #Sample a
JOIN
   #Sample b
   ON (a.month = b.month)
   AND (b.status = 3)
WHERE
   a.status IN (1,2);

drop table #Sample

CREATE TABLE #Sample

(

Status int,

Month varchar(5),

Capacity int

);

Insert into #Sample (Status,Month,Capacity) values (1,'01/16',5)

Insert into #Sample (Status,Month,Capacity) values (3,'01/16',2)

Insert into #Sample (Status,Month,Capacity) values (1,'02/16',11)

Insert into #Sample (Status,Month,Capacity) values (3,'02/16',20)

Insert into #Sample (Status,Month,Capacity) values (1,'03/16',8)

Insert into #Sample (Status,Month,Capacity) values (3,'03/16',12)

Insert into #Sample (Status,Month,Capacity) values (1,'04/16',4)

Insert into #Sample (Status,Month,Capacity) values (2,'04/16',10)

Insert into #Sample (Status,Month,Capacity) values (3,'04/16',18)

Insert into #Sample (Status,Month,Capacity) values (2,'05/16',14)

Insert into #Sample (Status,Month,Capacity) values (3,'05/16',37)

Insert into #Sample (Status,Month,Capacity) values (2,'06/16',4)

Insert into #Sample (Status,Month,Capacity) values (3,'06/16',8)

select * from #Sample

SELECT

a.status,

a.month,

a.capacity,

b.capacity AS total_capacity,

a.capacity - b.capacity AS net_capacity

FROM

#Sample a

JOIN

#Sample b

ON (a.month = b.month)

AND (b.status = 3)

WHERE

a.status IN (1,2);

drop table #Sample

A handy way of calculating based on a transaction file.

Category: Uncategorized

What is Twitter shadow ban?

Video Sample on WordPress

Sample net capacity SQL

Site Rebuilt