SELECT article.* , DATE_FORMAT(article.dt_pub, '%M %e, %Y') AS pretty_dt_pub , article_type.name AS at_name, article_type.artarc_type AS at_type , person.uid AS c_uid, person.name AS c_name, person.photo_url AS c_photo_url, person.short_bio AS c_short_bio, person.salutation AS c_salutation , person.ad_url AS c_ad_url, person.ad_img AS c_ad_img, person.ad_text AS c_ad_text , person.email AS c_email, person.newspaper AS c_newspaper, newspaper.id AS np_id , newspaper.name AS np_name, newspaper.subdir AS np_subdir, newspaper.credit_html AS np_credit_html , entity.name AS label_name, entity.home_url AS label_url, entity.id AS label_id, genre.name AS genre_name , musician.name AS musician_name FROM article LEFT JOIN person ON article.author = person.id LEFT JOIN article_type ON article.article_type = article_type.id LEFT JOIN newspaper ON article.newspaper = newspaper.id LEFT JOIN genre ON article.genre = genre.id LEFT JOIN entity ON article.label = entity.id LEFT JOIN musician ON article.musician = musician.id WHERE article.year=2000 AND article.month=7 AND article.seq=999
Please go to home page.