Query error in SELECT p.*, DATE_FORMAT(FROM_UNIXTIME(p.last_modified), '%m/%d/%Y') as last_modified, c.category_name FROM pages AS p LEFT JOIN categories AS c ON p.category_id=c.id WHERE 1 AND p.is_posted='1' AND p.category_id!=0 ORDER BY c.category_name, p.last_modified DESC . Error #1146, [Table 'resolveservices.pages' doesn't exist]