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 (17981,14402,45561,45286,45051,44869,37267,18172,16935,13425,44851,44674,6609,44894,45229,18894,44867,45072,44858,44848,44768,17237,16885,5388,18719,44766,44836,18652,24412,28313,18794,44689,45277,44687,6875,17335,18301,44765,5993,44835,13988,18286,9341,17351,24441,10402,22509,4686,44870,18353,44775,19057,44849,24411,6862,17848,44640,44764,18688,13,18650,44671,44856,17092,14622,44875,44873,18900,44669,45262)
Unknown column 'np.person' in 'where clause'