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,44762,44671,44870,32454,6609,44851,45177,18719,34194,44848,17335,44531,44853,4686,30963,14402,9341,44640,17492,18430,44767,22509,44856,44894,44873,44768,44687,18688,44865,44884,45277,18301,44866,44868,45518,30135,3883,24412,44863,45229,45421,44745,17351,17703,44835,44765,43800,16885,18353,8753,6862,44869,44711,17904,45515,18652,44861,18237,17114,4765,13988,13922,19057,18650,14622,13425,37057,44685,45561)
Unknown column 'np.person' in 'where clause'