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