Untitled query #20868

SQL

/*USE enwiki_p;
SELECT page_title , p2.page_title	
FROM page
WHERE page_namespace = 14
and page_title like '%the_Republic_of_Ireland';*/
USE enwiki_p;
SELECT 
    page_title# , ll_title
  FROM
    page#, langlinks
  WHERE
	#ll_from = page_id 
	page_namespace = 14
	and page_title REGEXP '^\\d{1,3}_(st|rd|th)_century_(|_BC|_BCE)_in_.*'
	#and page_title REGEXP '^\\d\\d\\d\\d(|_BC|_BCE)_in_.*'

    ;
	#and page_title REGEXP '^20\\d+_in_.*'
	#and page_title like '1_in_%'

	#and page_title like '%the_Republic_of_Ireland'
	#and ll_lang = 'ar'
    
    #and page_id in (select ll_from from langlinks where ll_lang = 'ar') 
 # LIMIT 50;
SQL

Checking query status...
