use tewiki_p;

​

-- SELECT actor_name, count(actor_name) as PROD_count FROM revision, page, actor

SELECT actor_name, page_title FROM revision, page, actor

where rev_comment_id = 20140

    and page_id = rev_page

    and actor_id=rev_actor

/*  rev_id = ar_rev_id

    and rev_comment_id= 20140

    and ar_title = "విపణీకరణ"*/

-- group by actor_name

-- Order by PROD_count desc