MySQL Query Error: You have an error in your SQL syntax near ': AND x.intLinkID = a.intMediaID AND x.intTypeID = 28 AND a.dtmPubDate <= CURDAT' at line 1<BR><BR>Query: select a.intMediaID, a.strMediaTitle, a.strAuthor, x.strLinkText from Xref x, MediaLibrary a WHERE a.bitPublish = 1 AND x.intPrimaryID = 192http: AND x.intLinkID = a.intMediaID AND x.intTypeID = 28 AND a.dtmPubDate <= CURDATE() AND (a.dtmExpDate >= CURDATE() OR a.dtmExpDate IS NULL) ORDER BY x.intSortOrder, a.strMediaTitle