set @tuser := "K.Venkataramana";

select page_title,rev_timestamp from revision,comment,actor,page 

where comment_id=rev_comment_id 

                  and rev_actor=actor_id

                  and page_id=rev_page

and comment_text like "%WPWPTE%"

and actor_name = @tuser

/* and page_id in (select cl_from from categorylinks where (cl_to = 'భారతదేశ_గ్రామాలు'

            OR

                cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'భారతదేశ_గ్రామాలు' and cl_type = 'subcat' )

            OR

                cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'భారతదేశ_గ్రామాలు' and cl_type = 'subcat' ) and cl_type = 'subcat' )

            OR

                cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'భారతదేశ_గ్రామాలు' and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' )

                                                         ))

*/

order by rev_timestamp