Error in query: SELECT DISTINCT(np.person) AS person, p.first_name, p.last_name, nx.id AS news_id FROM news_person AS np, person AS p, news_category AS nc LEFT JOIN news AS nx ON nx.id = (SELECT ny.id FROM news AS ny, news_person AS nyp, news_category AS nyc WHERE ny.id = nyc.news AND nyc.category = 310 AND nyp.person = np.person AND nyc.news = ny.id AND nyp.news = ny.id AND ny.entry_active = 't' ORDER BY entry_date DESC LIMIT 0, 1) WHERE np.person = p.id AND nc.category = 310 AND nc.news = np.news AND np.person = p.id AND p.id IN (44767,13922,44766,45262,44855,44894,32454,44739,44671,17835,44669,44836,4765,17237,44837,3883,44865,44764,17756,17657,14402,18900,36472,37057,45518,22509,16935,18652,18572,45229,18981,44689,17981,17278,44878,17351,45516,45286,17492,37267,44845,44765,44856,18996,18286,17839,44861,44674,18894,18648,45567,18042,17092,44868,30986,44849,17009,17527,44869,19057,44873,44870,44863,28530,44711,45043,17601,45277,17703,44867)
Unknown column 'np.person' in 'where clause'