... PageID,
CONVERT(p.page_title USING latin1) AS PageTitle,
CONVERT(t.old_text USING latin1) AS PageContent,
(SELECT GROUP_CONCAT(CONVERT(wikimedia_categorylinks.cl_to USING latin1)) FROM wikimedia_categorylinks ...
... will be based on the SQL query to get just your articles from your MediaWiki CMS:
-- to get articles from MediaWiki CMS: Let's call it STATEMENT1
SELECT
wikimedia_page.page_id AS PageID,
CONVERT(wikimedia_page.page_title ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.