SQL

SELECT page_title
FROM page, revision
WHERE page_len < 500
AND page_namespace = 0
AND rev_timestamp REGEXP '^20[0-1][0-9]'
AND page_id NOT IN ( 
    SELECT cl_from 
    FROM categorylinks 
    WHERE cl_from = page_id 
  	AND ( cl_to = 'Homonymie' OR cl_to = 'Date_spécifique' )
)
AND page_id NOT IN (
  	SELECT tl_from
  	FROM templatelinks, linktarget
  	WHERE tl_from = page_id
  	AND tl_target_id = lt_id
  	AND lt_namespace = 10
  	AND lt_title = 'Une_pomme_est_un_fruit'
)
AND page_title NOT REGEXP '[0-9]{4}_(en|au)'
AND rev_id = page_latest
AND page_is_redirect = 0
GROUP BY page_title
LIMIT 5000
SQL

Checking query status...
