Vikikaynak teşekkürleri

SQL

USE trwikisource_p;
SELECT COUNT(*) AS "Toplam teşekkür", COUNT(DISTINCT actor_name) AS "Toplam teşekkür eden", COUNT(DISTINCT log_title) AS "Toplam teşekkür edilen"
FROM actor 
JOIN logging ON (actor.actor_id=logging.log_actor) 
WHERE log_action = "thank"
/*AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)*/;

SELECT actor_name AS "Teşekkür eden", COUNT(*) AS "Teşekkür sayısı" 
FROM actor 
JOIN logging ON (actor.actor_id=logging.log_actor) 
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY actor_name
ORDER BY COUNT(*) DESC
LIMIT 20;

SELECT log_title AS "Teşekkür edilen", COUNT(*) AS "Alınan teşekkür sayısı" 
FROM logging
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY log_title
ORDER BY COUNT(*) DESC
LIMIT 20;

SELECT actor_name AS "Teşekkür eden", log_title AS "Teşekkür edilen", COUNT(*) "Teşekkür sayısı"
FROM actor
JOIN logging ON (actor.actor_id=logging.log_actor) 
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY actor_name, log_title
ORDER BY COUNT(*) DESC
LIMIT 10;

SELECT actor_name AS "Teşekkür eden", log_title AS "Teşekkür edilen", COUNT(*) "Teşekkür sayısı"
FROM actor
JOIN logging ON (actor.actor_id=logging.log_actor) 
WHERE log_action = "thank" 
AND log_title = "Satirdan_kahraman"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY actor_name, log_title
ORDER BY COUNT(*) DESC
LIMIT 10;
SQL

Checking query status...
