permalink lookup DB Error:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'underhil_website.article_types' doesn't existpermalink lookup DB Error:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'underhil_website.article_types' doesn't existprelimitquery DB Error:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'underhil_website.article_types' doesn't exist
Query:
SELECT
distinct article_id,
blurb,
bodytext,
title,
DATE_FORMAT(pubdate,"%Y") as pub_year,
DATE_FORMAT(pubdate,"%b") as pub_month,
DATE_FORMAT(pubdate,"%e") as pub_day,
DATE_FORMAT(pubdate,"%b %D %Y") as pubdate,
authorfname,
authorlname,
authortitle,
pubdate as pub_order,
t1.permalink as permalink,
attached_image,
article_photo.filename as attached_image_filename,
page,
art_type_id,
date(pubdate)>curdate() as future
FROM
article_types, article as t1
left join article_photo on attached_image = ap_id
WHERE
t1.art_type = article_types.art_type_id
AND (expdate>=curdate() or expdate IS NULL)
AND article_id=article_id AND art_type_id=1
GROUP BY article_id
ORDER BY pub_order desc, article_id desc
Attribs:
Array ( )