The columns available here are written exclusively for our DMReview.com online readers. New column are added on Thursdays, and each writer offers expertise in several areas of business intelligence and data warehousing.
SELECT lastname, author.firstname, article.datecreated as issuedate, article.articleid, article.title, article.subtitle
FROM article, articleauthor, author,articlemeta, metavalue
WHERE article.articleid=articlemeta.articleid
AND article.articleid = articleauthor.articleid
AND articleauthor.authorid = author.authorid
AND articlemeta.avalue = metavalue.avalue
AND article.publicationid=34
AND metavalue.metavalueid=230030
AND articlemeta.metaid=1
AND metavalue.metaid=1
AND article.isactive = 'Y'
and article.datecreated < current_date + 1
AND Author.AuthorID IN (#SpecialAuthors#)
ORDER BY UPPER(lastname), article.datecreated DESC