Miscellany

SELECT
	documents.doc_id,
	documents.date_time,
	documents.title,
	documents.language,
	documents.priority,
	documents.revision_id,
	document_fixtures.fixture_key,
	document_contents.abstract,
	document_contents.sportsml
FROM
	documents,
	document_contents,
	document_fixtures,
	affiliations as la, 
	affiliations_documents as lad
WHERE
	    documents.date_time >= '1971-01-01 05:00:00'
	AND documents.date_time <= '2037-12-31 16:00:00'
	AND documents.document_fixture_id = document_fixtures.id
	AND lad.document_id = documents.id 
	AND la.affiliation_key = 'l.nfl.com' 
	AND lad.affiliation_id = la.id
	AND document_contents.document_id = documents.id
ORDER BY
	documents.date_time desc LIMIT 0, 5