seo – Web with two languages. URLs with / es / are not indexed

Hello,

I launched a website with English and Spanish languages. I did this using WPML, but I have a lot of problems with indexing and classifying Spanish URLs, which appear in the / es / URL.

Google Search Console declares all URLs such as domain.com/en/wwhat as "Duplicate and submitted URL not selected as canonical"

I really need these pages, although they are translations from the English version, to index and classify keywords as well.

Solutions? Thank you!

Create an indexed list – Mathematica Stack Exchange

I am trying to create an indexed list with Association[] but i only get a few keys when accessing a specific key.
Here is the code:

In[] :=series = Association[
      "white" -> 1,
      "white" -> 0,
      "blue" -> 2,
      "green" -> 1,
      "green" -> 2,
      "yellow" -> 3
      ]
 Out[] :=<|"white" -> 0, "blue" -> 2, "green" -> 2, "yellow" -> 3|>

And when I access the "white" key it only displays the number 0, instead of 1 and 0.

 In[]:= series["white"]
 Out:= 0

google search console – How can I fix the indexed issue, although blocked by robots.txt if the reported pages do not exist at all?

I found related information like How to fix Google "Indexed, although blocked by robots.txt" but that doesn't answer my question.

The pages I saw in the report do not exist at all.

enter description of image here

For example, the two links above do not exist at all. I don't know why people add a number or a image?url= to my URL. He's so weird.

How can I tell Google to ignore these URLs?

I can create a SEO backlink on the premium indexed site dofollow DR 90 for $ 10

I can create a SEO backlink on the premium indexed site dofollow DR 90

Need Google recognition? This concert is obvious! For just a decent cost, I'm going to create a backlink on a DR 90 world famous website which will be indexed with a dofollow backlink pointing to your website.

Website Statistics:

– SEMRush traffic: 6.3 M per month
– Similar web traffic: 8.4 million per month
– Dofollow and indexed
– HTTPS and own URL structure
– No subdomain
– World renowned website
– DA 88 and DR 90

Satisfaction is guaranteed:

– 100% permanent position

– 100% dofollow
– FREE HQ image (s) as it looks attractive

Note: all niches are accepted (with the exception of pornographic / gambling sites / illegal sites)

Requirements:

-Article, anchor text and your target URL

So what are you waiting for? Simply select the package, click on the ORDER button and have the chance to meet your future audience!***ORDER NOW***

. (tagsToTranslate) guest (t) post (t) link (t) building (t) seo (t) backlink

Backlinks are no longer indexed

I currently manage 2 websites on Search Engine Ranker and for these projects, I got over 700 verified links, but not a single indexed backlink as I see on the Alexa traffic page. I use the same indexing software as for the previous project, but for the previous project, I managed the website but also the Web 2.0 which points to the main website and for the website it has shown around 900 links checked but for web 2.0 around 120 and it's about the same number shown on the alexa traffic page as the indexed backlinks for the website. So my conclusion is that the best way to index backlinks is to have a lot of links pointing to your Web 2.0 sites that lead to your site and to index those links.
Is this conclusion correct for why my 2 websites are no longer indexed?
And does the link wheel still work today, for example, the more levels, the better?

join – Get data from different tables indexed by the same ID

I have a table people:

person_id | name
----------+-----
1         |John
2         |Paul
3         |Jim
...

Each person can have zero or more auto insurance contracts, so I have another table car_contracts as following:

contract_id | person_id | contract_number | date_from | insured_value | car_tag | .... (more fields)
------------+-----------+-----------------+-----------+---------------+---------+ 
1           | 1         | C99             |2020-01-01 | 5000          | ABC     | ....
2           | 1         | C02             |2020-03-01 | 4000          | XYZ     | ....
3           | 3         | C96             |2020-02-02 | 12000         | KKK     | ....
4           | 1         | C01             |2019-01-01 | 5500          | XXX     | ....
5           | 2         | C02             |2019-06-01 | 1000          | 666     | ....
6           | 3         | C03             |2020-02-20 | 11000         | KPX     | ....
...

Each person can also have zero or more power plants (or whatever; the fact is, another table with different fields but still linked to people by means of person_id), so the table plants is like

plant_id | person_id | plant_name | power | address     | .... (more fields)
---------+-----------+------------+-------+-------------+ 
1        | 2         | plant01    |100    | 230 rue st. | ....
2        | 3         | jimsplant1 |50     | ...         | ....
3        | 3         | jimsplant2 |65.5   |             | ....
4        | 2         | plant02    |12.5   |             | ....
5        | 1         | house01    |20     |             | ....
6        | 1         | house02    |20     |             | ....
...

I can get a list of people with their contracts or people with their factories by joining the people board car_contracts and plants table respectively.
Is it possible to somehow get all the information at once (the people with their contracts and their factories) with one request?

Hash link must be indexed and analyzed

I create my table of contents manually by specifying the anchor and creating my bulleted list.

Links are represented as https://example.com/posturl#test1

Do you think these hash links should be crawled and indexed or no index no follow

postgresql – Very slow indexed varchar column (40M + rows)

I have an event table with over 40 million rows. It has a btree index on type: "index_events_on_type" btree (type).

Any quest for equality takes ages! I tried to adjust the work_mem get rid of the lossy value but it had little to no effect.

dev=# EXPLAIN (ANALYZE, BUFFERS) SELECT "events".* FROM "events" WHERE "events"."type" = 'contact.card.added';
                                                                   QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on events  (cost=56176.20..1633783.13 rows=1614405 width=296) (actual time=252.846..13832.331 rows=1550851 loops=1)
   Recheck Cond: ((type)::text = 'contact.card.added'::text)
   Rows Removed by Index Recheck: 10414231
   Heap Blocks: exact=39335 lossy=758338
   Buffers: shared read=807020
   ->  Bitmap Index Scan on index_events_on_type  (cost=0.00..55772.60 rows=1614405 width=0) (actual time=243.096..243.096 rows=1550851 loops=1)
         Index Cond: ((type)::text = 'contact.card.added'::text)
         Buffers: shared read=9347
 Planning time: 0.100 ms
 Execution time: 13924.612 ms
(10 rows)

… and the table

dev=# d events
                                            Table "public.events"
      Column       |            Type             | Collation | Nullable |              Default
-------------------+-----------------------------+-----------+----------+------------------------------------
 id                | bigint                      |           | not null | nextval('events_id_seq'::regclass)
 type              | character varying           |           | not null |
 aggregate_root_id | uuid                        |           | not null |
 entity_id         | uuid                        |           |          |
 parent_id         | bigint                      |           |          |
 created_at        | timestamp without time zone |           | not null |
 body              | jsonb                       |           |          | '{}'::jsonb
Indexes:
    "events_pkey" PRIMARY KEY, btree (id)
    "index_events_on_aggregate_root_id" btree (aggregate_root_id)
    "index_events_on_created_at" btree (created_at)
    "index_events_on_entity_id" btree (entity_id)
    "index_events_on_parent_id" btree (parent_id)
    "index_events_on_type" btree (type)
Foreign-key constraints:
    "fk_rails_68f023eb25" FOREIGN KEY (parent_id) REFERENCES events(id)
Referenced by:
    TABLE "events" CONSTRAINT "fk_rails_68f023eb25" FOREIGN KEY (parent_id) REFERENCES events(id)

Any advice would be appreciated.

SQL server – Insert in indexed view?

I give an example to show my problem.
I create 2 tables as follows:

CREATE TABLE a
(
    id INT
)

CREATE TABLE b
(
    name NVARCHAR(10),
    id INT
)

Then insert data into these tables

INSERT INTO a VALUES(1),(2)
INSERT INTO b VALUES('Kan',1),('Michael',2)

Then, I create an indexed view which joins these tables via id

CREATE VIEW a_b
WITH SCHEMABINDING
AS
(
SELECT a.id,b.name FROM a INNER JOIN b ON a.id=b.id
)

CREATE UNIQUE CLUSTERED INDEX ix_a_b
ON a_b(id)

INSERT INTO a_b VALUES (3,'Joe') will be wrong

As I know from the view:

  • views don't store data, just saved queries

  • but an indexed view that stored the data physically as a table in the database. So why not insert, delete from a_b?

And what do I know about VIEW is good or bad? Help me improve?