# List all titles and text for pages containing the string "Vice President"

SELECT
    (CASE
        WHEN p.page_namespace = 0 THEN '(Main)'
        WHEN p.page_namespace = 2 THEN 'User'
        WHEN p.page_namespace = 4 THEN 'Project'
        WHEN p.page_namespace = 6 THEN 'File'
        WHEN p.page_namespace = 8 THEN 'MediaWiki'
        WHEN p.page_namespace = 10 THEN 'Template'
        WHEN p.page_namespace = 12 THEN 'Help'
        WHEN p.page_namespace = 14 THEN 'Category'
        ELSE p.page_namespace
    END) as Namespace,
    CONVERT(p.page_title USING utf8) AS Title,
    CONVERT(t.old_text USING utf8) AS 'Text'
FROM
    4mwiki_page p
JOIN 4mwiki_slots s ON
    s.slot_revision_id = p.page_latest
JOIN 4mwiki_content c ON
    c.content_id = s.slot_content_id
JOIN `4mwiki_text` t ON
    t.old_id = REPLACE(c.content_address, 'tt:', '')
WHERE t.old_text LIKE '%Vice President%' LIMIT 2;

# remove "CONVERT(t.old_text USING utf8) AS 'Text'" to just show the page
# titles



# mysql -NB -u root sf4m -e "<SQL-CALL>"
# Above line to script it from the command line

# List all message board posts with specified subject and content

SELECT post_id, post_time, post_subject, post_text 
FROM phpbb3_posts 
WHERE post_subject LIKE '%2006%' AND  post_text LIKE '%Meeting%'
ORDER BY post_time
LIMIT 2