nlwiki Navy ship articles with missing flag

SQL

SELECT user_name, user_registration, il_to
FROM imagelinks, page, `user`
WHERE user_name=REGEXP_SUBSTR(page_title, '^[^/]+') AND page_id=il_from AND il_from_namespace IN (2,3) AND il_to IN (
  		'Crystal_barnstar_20_years%2B20.jpg', 'Porcelain_barnstar_for_15_years_of_service.jpg', 'Editor_-_orichalcum_star.jpg', 'Gold_barnstar_2.png')
LIMIT 100
/*
SELECT page_namespace AS ns, page_title, user_registration, il_to
FROM imagelinks, page, `user`
WHERE user_name=REGEXP_SUBSTR(page_title, '^[^/]+') AND page_id=il_from AND il_from_namespace IN (2,3) AND il_to IN (
  'Crystal_barnstar_20_years%2B20.jpg', 'Porcelain_barnstar_for_15_years_of_service.jpg', 'Editor_-_orichalcum_star.jpg', 'Gold_barnstar_2.png')
LIMIT 100*/
SQL

Checking query status...
