MySQL Query Error: Unknown table 'page' in where clause
Query: SELECT a.*, b.strFirstName, b.strLastName, b.strThumbnail as strAuthorThumb, b.txtShortBio
FROM MediaLibrary a LEFT JOIN Authors b ON a.intAuthorID = b.intAuthorID
WHERE a.intMediaID = page.php AND
a.bitPublish = 1 AND
a.dtmPubDate <= CURDATE() AND
(a.dtmExpDate >= CURDATE() OR a.dtmExpDate IS NULL)