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 (45043,5259,8753,18652,24412,5410,37057,14402,6609,18981,4686,44711,44878,17981,44866,13988,44767,44669,37267,44873,16885,39676,45072,45262,44867,36472,18353,44865,44640,18042,17703,44854,28530,17335,45567,18719,6875,18185,4765,16935,44835,17351,17492,44853,18650,44855,31354,28313,24438,17237,34194,45515,44739,44766,17904,44845,17848,18172,14622,45180,17771,18427,43800,44851,44685,44875,13922,45051,45517,6782)
Unknown column 'np.person' in 'where clause'