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,
DATE_FORMAT(pubdate,"%l") as pub_hour,
DATE_FORMAT(pubdate,"%i") as pub_min,
DATE_FORMAT(pubdate,"%p") as pub_ampm,
DATE_FORMAT(expdate,"%Y") as exp_year,
DATE_FORMAT(expdate,"%b") as exp_month,
DATE_FORMAT(expdate,"%e") as exp_day,
DATE_FORMAT(expdate,"%b %D %Y") as expdate,
DATE_FORMAT(expdate,"%l") as exp_hour,
DATE_FORMAT(expdate,"%i") as exp_min,
DATE_FORMAT(expdate,"%p") as exp_ampm,
authorfname,
authorlname,
authortitle,
pubdate as pub_order,
t1.permalink as permalink,
attached_image,
article_photo.filename as attached_image_filename,
page,
art_type_id,
column_name,
all_day,
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 article_id=article_id AND art_type_id in (2) AND (pubdate>=curdate() or (pubdate<=curdate() and expdate>=curdate()))
GROUP BY article_id
ORDER BY pub_order asc, article_id desc
Attribs:
Array ( )