... 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 ...
... USING latin1) AS PageTitle,
CONVERT(wikimedia_text.old_text USING latin1) AS PageContent
FROM
wikimedia_page
LEFT JOIN (
wikimedia_revision, wikimedia_text)
ON
wikimedia_page.page_latest=wikimedia_revision.rev_id
WHERE ...
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.