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 (18572,4686,18794,8753,18286,45180,28313,18996,44766,44849,18430,44836,44865,45517,6609,44711,9341,44853,37267,45177,44669,17278,17335,18353,17756,44856,44869,5388,17703,44851,44861,17981,17092,45262,17351,22509,17771,44835,18900,18042,17848,18894,18981,45516,17839,44845,44878,45072,44765,32454,17237,18237,17492,45421,18652,44674,19078,18279,44775,44884,17527,44873,44739,18688,44866,24438,45043,18446,10402,17601)
Unknown column 'np.person' in 'where clause'