SELECT articles.article_ID, articles.cat_ID,articles.headline,articles.photosrc,articles.content_type,articles.teaser_long, articles.url_name FROM articles WHERE tag_ID = 34  AND articles.photo_width >= 460 
AND articles.photo_landscape = 'y'
AND articles.status = 'live' 
AND articles.publish_date <= NOW() 
ORDER BY articles.publish_date DESC LIMIT 1