SQL
AخA
SELECT page_title/*, page_namespace*/
FROM page, templatelinks, categorylinks
WHERE cl_to LIKE 'Infoboksy_–_link_w_tytule'
AND page_id = cl_from
/*AND tl_title LIKE 'Biogram_infobox'*/
AND tl_title IN (
'Instrument_muzyczny_infobox',
'Linia_metra_infobox',
'Budynek_infobox',
'Książka_infobox',
'Jednostka_wojskowa_infobox',
'Biogram_infobox',
'Jednostka_administracyjna_infobox',
'Mistrzostwa_sporty_zimowe_infobox',
'Państwo_infobox',
'Sezon_tenisowy_infobox',
'Mistrzostwa_indywidualne_infobox',
'Rozgrywki_w_piłce_ręcznej_infobox',
'Region_infobox',
'Film_infobox',
'Uczelnia_infobox',
'Góra_infobox'
)
AND tl_namespace = 10
AND page_id = tl_from
/*AND page_namespace = 0*/
AND tl_title NOT LIKE '%/%';
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.