MySQL Query Error: Unknown table 'page' in where clause<BR><BR>Query: select a.intMediaID, a.strMediaTitle, a.strAuthor from Xref x, MediaLibrary a WHERE a.bitPublish = 1 AND x.intPrimaryID = page.php 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