Database error: Invalid SQL: SELECT DISTINCT Ip.id 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 Ic.parent_id=Ip.id 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 Ic.id IN (SELECT id FROM Items WHERE type=511 AND Ip.id=Ic.parent_id 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.

Advertisements

There are no comments on this post.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: