Search Jobs

Search Internships

Publisher Profiles

Publishing Programs

Publishing Organizations

Major/Department guide

Commonly Used Terms

Publishing Events

Bookjobs.com is sponsored by the Association of American Publishers, the leading trade association for the U.S. book and journal publishing industry.

View Job

MySQL Query Error: Unknown column 'favicon.ico' in 'where clause'

Query: SELECT a.*, UNIX_TIMESTAMP(DATE_ADD(a.dtmPubDate, INTERVAL 90 DAY)) as date, b.bitDisplayOnJobDesc, b.strDivision, b.strShortDesc, c.intPublisherID, c.strCompany FROM Jobs a LEFT OUTER JOIN Users b ON a.intUserID = b.intUserID LEFT OUTER JOIN Publishers c ON a.intPublisherID = c.intPublisherID WHERE a.intJobID = favicon.ico