... 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 ...
Change Page Title in Website Here are some instructions on changing the page title in Joomla! CMS to display both the actual page title and other stuff. As I like doing this for this particular website ...
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.