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 (44836,44849,44875,45042,45515,8753,44687,17756,6609,45518,28313,13425,32454,44762,34194,24412,17601,3883,17114,18719,44835,45561,44856,44689,44685,30135,43800,44870,5388,18900,44711,17278,44671,16935,17703,45516,44845,45277,6862,18894,44866,18652,44858,44894,37267,18430,18042,18572,44766,13922,36472,44868,44531,44853,44851,18794,45177,14622,19078,45262,6875,14402,45286,10402,44640,31354,37057,17092,17351,45180)
Unknown column 'np.person' in 'where clause'