Missing unique pages from the index in favor of someone who steals them?

Question

SQL

There is an article, it is unique, it was published and indexed yesterday. Today this article was copied by other sites, the original article disappeared from the search results, but in its place is its copy from another resource that copied it. What could be the problem? Why does Google consider it a duplicate, and not the resource that copied it? And so with all the articles that impudently copy

Answer 1

You can try through CTE, although there is no less cycling.

with cte as (select product_id, count(order_id) as cnt from orders_products)

select top 1 a.product1, b.product2, a.cnt
from cte as a
left join cte as b on b.cnt = a.cnt and a.product_id > b.product_id
order by a.cnt desc

Answer 2

understand
what was there? ban, penalty? lily left?

Answer 3

Google don't care about the author. He considers a more trusted site to be the primary source. Even if he is a thief!

Answer 4

A similar situation. There is no desire to continue working with the site.