SELECT a.title, a.author, a.publish_dt, a.fk_section_id, a.body, p.pk_photo_id, p.path, p.description, p.thumb
FROM article a LEFT JOIN photo p
ON a.pk_article_id = p.fk_article_id
AND a.pk_article_id = %d
ORDER BY thumb DESC