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 (37267,45043,44875,32454,44848,44851,45421,6782,45518,44853,17839,18172,18301,44868,30135,18353,30963,45346,5388,17237,17092,44671,24412,4686,17351,13988,17755,39676,18185,5993,28313,44865,13,17335,45177,28530,44854,44775,44764,19057,45277,30986,45051,45229,43800,44685,45516,18894,44711,18427,13425,18652,44767,17114,24411,9341,5259,6862,45042,18900,18042,44856,44866,5410,44687,44835,18430,14622,45517,44762)
Unknown column 'np.person' in 'where clause'