USE arywiki_p;
SELECT concat(actor_name) AS "المستخدم", COUNT(*) AS "عدد... |
10 months ago |
USE arywiki_p;
SELECT CONCAT("[[مستخدم:",actor_name,"|",actor_name,"]]") AS... |
10 months ago |
USE arywiki_p;
SELECT CONCAT("[[مستخدم:",actor_name,"|",actor_name,"]]") AS... |
10 months ago |
SELECT
page_title,
COUNT(*)
FROM revision
JOIN page
ON page_id =... |
10 months ago |
SELECT COUNT(*) AS "عدد المقالات"
FROM revision r
join page p on... |
10 months ago |
SELECT COUNT(*) AS "عدد القوالب"
FROM revision r
join page p on... |
10 months ago |
SELECT COUNT(*) AS "عدد التصانيف"
FROM revision r
join page p on... |
10 months ago |
select COUNT(*) from logging where log_timestamp BETWEEN 20230101000000 AND... |
10 months ago |
select COUNT(*) from logging where log_timestamp BETWEEN 20230101000000 AND... |
10 months ago |
select COUNT(*) from logging where log_timestamp BETWEEN 20230101000000 AND... |
10 months ago |
select COUNT(*) from logging where log_timestamp BETWEEN 20230101000000 AND... |
10 months ago |
select COUNT(*) from logging where log_timestamp BETWEEN 20230101000000 AND... |
10 months ago |
select COUNT(*) from logging where log_timestamp BETWEEN 20230101000000 AND... |
10 months ago |
select count(*) from revision where rev_timestamp between 20230101000000 AND... |
10 months ago |