Database error: Invalid SQL: SELECT DISTINCT AS id, Ip.title AS title, Ip.lead AS lead, Ip.writer AS writer, Ip.body AS body, DATE_FORMAT(Ip.publish_start, ‘%b %e %Y’) AS publish_date, Ic.title as alt_title, Ic.body as alt_body FROM Items Ic LEFT OUTER JOIN Items Ip ON WHERE Ip.type=510 AND status > 0 AND publish_start <= FROM_UNIXTIME(1243545300) AND (publish_end = 0 OR publish_end IS NULL OR publish_end > FROM_UNIXTIME(1243545300)) AND IN (SELECT id FROM Items WHERE type=511 AND GROUP BY parent_id ORDER BY id DESC) ORDER BY Ip.publish_start DESC LIMIT 3
MySQL Error: 1052 (Column ‘status’ in where clause is ambiguous)
Session halted.


There are no comments on this post.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: