SELECT a.id, a.article_type, a.status, a.text, a.artist_name, a.title, a.dt_pub, a.author, a.pull_quote, a.pull_quote_by, a.editor, a.editor_comments, a.edited, a.musician, a.topic_year, a.read_count, a.cd_art_url, a.artist_url, a.tracks, a.personnel, a.genre, a.is_holiday, a.is_aprilfools, a.video_tag, a.newspaper, a.to_pub_day, a.contrib_rating, a.numrecommends, DATE_FORMAT(a.dt_pub, '%M %e, %Y') pretty_dt_pub, article_type.name at_name, article_type.artarc_type at_type, p.uid c_uid, p.name c_name, p.photo_url c_photo_url, p.short_bio c_short_bio, p.salutation c_salutation, p.ad_url c_ad_url, p.ad_img c_ad_img, p.ad_text c_ad_text, p.email c_email, p.newspaper c_newspaper, newspaper.id np_id, newspaper.name np_name, newspaper.subdir np_subdir, newspaper.credit_html np_credit_html, entity.name label_name, entity.home_url label_url, entity.id label_id, genre.name genre_name, musician.name musician_name FROM article a LEFT JOIN person p ON a.author = p.id LEFT JOIN article_type ON a.article_type = article_type.id LEFT JOIN newspaper ON a.newspaper = newspaper.id LEFT JOIN genre ON a.genre = genre.id LEFT JOIN entity ON a.label = entity.id LEFT JOIN musician ON a.musician = musician.id WHERE a.year=2003 AND a.month=8 AND a.seq=12
Please go to the AAJ home page.