SELECT broadcast_time,
news_id,
headline,
body,
published,
news.active,
documents_to_news.fk_document_id,
documents.relative_path,
documents.file_name,
news.created, summary,
media.video_id,
media.file_name AS video_file_name,
media.relative_path AS video_relative_path,
top_story,
home_page,
news.fk_client_id,
documents.title AS caption,
duration,
media.file_size,
updated_story,
developing_story,
audio,
video
FROM news
LEFT JOIN documents_to_news ON news.news_id = documents_to_news.fk_news_id
LEFT JOIN documents ON documents_to_news.fk_document_id = documents.document_id
LEFT JOIN tv.media_to_news ON news.news_id = media_to_news.fk_news_id
LEFT JOIN tv.media ON media_to_news.fk_video_id = media.video_id ,categories_to_news cn
WHERE active = true
AND news_id = cn.fk_news_id
AND date_part('day',news.created) = 13
AND date_part('month',news.created) = 6
AND date_part('year',news.created) = 2007
AND (cn.fk_category_id = 1022)
AND news.created > 'Mon, 11 Jun 2007 00:00:00 -0500' ORDER BY created DESC