Articles with "convicted felon" in the first sentence

SQL

SELECT
    page_title,
    LEFT(content.content, LOCATE('.', content.content) - 1) AS first_sentence
FROM
    page
JOIN
    revision ON page.page_id = revision.rev_page
JOIN
    slots ON revision.rev_id = slots.slot_revision_id
JOIN
    content ON slots.slot_content_id = content.content_id
WHERE
    page.page_namespace = 0
    AND page.page_is_redirect = 0
    AND content.content LIKE '%convicted felon%'
LIMIT 1000;

AخA
 
SELECT    page_title,    LEFT(content.content, LOCATE('.', content.content) - 1) AS first_sentenceFROM    pageJOIN    revision ON page.page_id = revision.rev_pageJOIN    slots ON revision.rev_id = slots.slot_revision_idJOIN    content ON slots.slot_content_id = content.content_idWHERE    page.page_namespace = 0    AND page.page_is_redirect = 0    AND content.content LIKE '%convicted felon%'LIMIT 1000;

SQL

Checking query status...