Ritual topic: CNC URL?

Question

Search Engine Optimization

Which CNC to choose?
There are three options:
lol.ru/hovan-comb
lol.ru/larin-chushka
Are there advice articles from the search engines themselves??
Personal experience on this matter.
thanks :)

Answer 1

Google officially recommends transliteration (see recommendations for transliteration) with "dash as a replacement for spaces", Cyrillic is likely to give the developer a lot of pain.
If you have more than 1 language, it’s not bad (read very well) to prescribe a language tag in the url, a la lol.ru/ru/larin-chushka
From personal experience, it’s convenient for work when a controller and an action are registered in the url, it turns out something like lol. ru/ru/post/show/larin-chushka, in general, no influence was noticed on the ranking, while it greatly speeds up the selection on sites with a lot of different content (let's say where there are products, categories, articles and a few more sections)

Answer 2

I did not see the third option, but oh well. Use the Latin alphabet - you can't go wrong.
Cyrillic does not provide any advantages. (except for very, very dubious ones)

Answer 3

well, suppose the table structure is:
--servers
server_id | version_ms
1 | 1.9
2 | 2.2
3 | 3.0
--mods
mod_id | mode_name
1 | "A"
2 | "B"
3 | "C"
4 | "4"
--mods_on_servers
server_id | mod_id
1 | 1
1 | 2
1 | 3
3 | 2
3 | 3
3 | 4
2 | 2
2 | 4
----
In MS SQL this is done with one query:

select mod_name from mods 
where mod_id in (select mod_id from mods_on_servers where server_id = 3)

Maybe MySQL has something similar ?

Answer 4

The classic implementation of a many-to-many relationship is a separate relationship table, in your case (`server_id`, `mod_id`).