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 (30963,44836,18185,17335,13425,5259,44855,17755,28530,18572,34194,44739,18286,13922,4686,14402,45177,44868,18301,17981,45517,24412,44845,13988,6875,44884,44869,44768,44775,44861,16885,37267,44689,5993,45286,44685,44851,44858,44853,18900,8753,18794,44767,17848,45567,17657,19078,45229,5410,10402,4765,18719,17771,32454,18688,30135,45515,18042,17492,18279,17703,44762,44856,44671,3883,45516,45043,18427,44866,28313)
Unknown column 'np.person' in 'where clause'