Обговорення Вікіпедії:Проєкт:Тематичний тиждень/Тиждень урду-української співпраці
- Чи можна перекласти інши статті з англо-вікі, по зазначеній тематиці?--Lukian (обговорення) 07:21, 27 вересня 2016 (UTC)
- @Lukian: так! статті взагалі з цієї тематики вітаються. ми просто зазначили базові --アンタナナ 22:56, 30 вересня 2016 (UTC)
Hello,
Just noticed that somebody worked on Umrao Jan. While the effort is worth appreciating, I request our friends to concentrate mainly on the lists. We on Urdu Wikipedia are translating the full length articles on Ukraine as per the list and are also updating our local list. We will also update Meta page from time to time. Best, --Hindustanilanguage (обговорення) 20:59, 4 жовтня 2016 (UTC)
- @Hindustanilanguage: we understand the request, but please take into consideration that not all of Ukrainians can translate from English, so they write themselves or translate from other languages they know. the work on the list is our main goal, but we decided not to limit topics people can write about. the month has only started --アンタナナ 00:30, 5 жовтня 2016 (UTC)
First Week Completion
ред.Dear friends,
Greetings from Urdu Wikipedia!
Hope you all are enjoying editing Urdu-related articles the way we are editing articles on Ukraine.
We hope at the end of this program sufficient information will be available to either publish a book on Ukraine or a special periodical issue on your country.
As per our agreed plan, we are pleased to share our progress with you below. We will be glad to hear from our Ukrainian friends as well about their work. Here is our progress:
S No | English Wikipedia article | Urdu Wikipedia article | Status of Urdu article | Size of the Urdu Wikipedia article (bytes) |
---|---|---|---|---|
1 | Jamala | Ur: جمالا | Зроблено | 25,393 (23,174 bytes added to the existing article) |
2 | Oleksandr Usyk | Ur: اولیکساندر اوسیک | Зроблено | 21,601 |
3 | Tunnels of Love Railways | Ur: سرنگِ محبت (ریلوے) | Зроблено | 4,444 |
4 | Ukraine International Airlines | Ur: یوکرین انٹرنیشنل ایئرلائنز | Зроблено | 18,030 (16359 bytes added to the existing article) |
5 | Red Forest | Ur: سرخ جنگل | Зроблено | 11,863 |
6 | Snake Island | Ur: اسنیک آئی لینڈ (بحیرہ اسود) | Зроблено | 23,905 |
7 | Ukrainian cuisine | Ur: یوکرینی پکوان | Зроблено | 17,580 |
Total new bytes added in Week 1 | 1,20,597 bytes |
Note: In comparison to Cyrillic and other scripts, less number of bytes are recorded for text typed in Urdu. Also, three other articles have been started. Their size is not added here because the work is still in progress. --Hindustanilanguage (обговорення) 04:23, 9 жовтня 2016 (UTC)
Entry # 21
ред.Hello again. I guess entry # 21 (recently added by User:Similartothissimilartothat) has nothing to do with Urdu or the collaboration project. --Hindustanilanguage (обговорення) 19:38, 9 жовтня 2016 (UTC)
- Hello! The article says that the original language is Urdu. As I have mentioned above, we want to have more articles around Urdu, so we do not limit people to the topics in the list. Thanks for caring :) --アンタナナ 20:19, 9 жовтня 2016 (UTC)
Статистика
ред.Створено
ред.Urdu-Ukrainian-week-new |
---|
-- Автор SQL запиту: Користувач:Ilya
USE ukwiki_p;
SET SESSION group_concat_max_len = 10000;
SELECT @rownum := @rownum + 1 AS rank,
IFNULL(user_name, 'Всього'),
created,
total_len,
articles
FROM
(
SELECT
CONCAT('[[Користувач:', rev_user_text, '|', ']]') as user_name,
COUNT(1) AS created,
SUM(article.page_len) as total_len,
GROUP_CONCAT(
DISTINCT
-- [[Назва статті]]
CONCAT('[[',
REPLACE(article.page_title, '_', ' '), -- замінюємо у назві '_' на ' '
']]', ' (', article.page_len, ')')
-- список впорядкований за назвою статті
ORDER BY article.page_len DESC
-- розділений пробілом
SEPARATOR ' · '
) AS articles
FROM page article
JOIN revision
ON rev_page = article.page_id AND
rev_parent_id = 0 AND
20161001 * 1000000 <= rev_timestamp AND
rev_timestamp < 20161101 * 1000000
JOIN page talk
ON talk.page_title = article.page_title AND
talk.page_namespace IN (0, 1)
JOIN templatelinks ON
tl_from = talk.page_id AND
tl_title = 'Urdu-Ukrainian-week-new' AND
tl_namespace = 10
WHERE
article.page_namespace = 0 AND
article.page_is_redirect = 0
GROUP BY rev_user_text WITH ROLLUP) t,
(SELECT @rownum := -1) r
ORDER BY created DESC, total_len DESC
|
Покращено
ред.Urdu-Ukrainian-week-improve |
---|
-- Автор SQL запиту: Користувач:Ilya
USE ukwiki_p;
SET SESSION group_concat_max_len = 10000;
SELECT @rownum := @rownum + 1 AS rank,
IFNULL(article, 'Всього'),
user_number,
size_increase,
users
FROM
(
SELECT
CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') as article,
COUNT(1) AS user_number,
SUM(user_size_increase) as size_increase,
GROUP_CONCAT(
DISTINCT
REPLACE(
CONCAT(
'[[Користувач:', rev_user_text, '|', ']]',
' (', user_size_increase ,')')
, '_', ' ')
ORDER BY user_size_increase DESC, rev_user_text
SEPARATOR ' · '
) AS users
FROM
(SELECT
rev.rev_user_text,
article.page_title,
SUM(rev.rev_len) - SUM(parent_rev.rev_len) AS user_size_increase
FROM page article
-- отримати версії статей
JOIN revision rev
ON rev.rev_page = article.page_id AND
20161001 * 1000000 <= rev_timestamp AND
rev_timestamp < 20161101 * 1000000
-- разом із попередніми версіями
JOIN revision parent_rev
ON parent_rev.rev_id = rev.rev_parent_id
-- і на сторінці обговорення чи у статі
JOIN page talk
ON talk.page_title = article.page_title AND
talk.page_namespace IN (0, 1)
-- має бути шаблон
JOIN templatelinks ON
tl_from = talk.page_id AND
tl_title = 'Urdu-Ukrainian-week-improve' AND
tl_namespace = 10
WHERE
article.page_namespace = 0 AND
article.page_is_redirect = 0
GROUP BY rev_user_text, article.page_title) r
GROUP BY article WITH ROLLUP) t,
(SELECT @rownum := -1) r
ORDER BY size_increase DESC, user_number DESC;
|
№ | Статті | Редакторів | Збільшення розміру | Список редакторів |
---|---|---|---|---|
Всього | 6 | 38235 | Juriy tyshkun (36856) · Antanana (1435) · Сергій Зінченко (17) · Blast furnace chip worker (4) · Krest0n0sec (-7) · Basio (-70) | |
1 | Мухаммад Ікбал | 3 | 36779 | Juriy tyshkun (36856) · Krest0n0sec (-7) · Basio (-70) |
2 | Урду | 3 | 1456 | Antanana (1435) · Сергій Зінченко (17) · Blast furnace chip worker (4) |