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 (18648,44837,44851,17114,44848,18650,37267,3883,44854,31354,18446,18719,44768,4765,16935,13,16885,45043,5410,18981,17771,44775,9341,18286,6862,43800,18185,44836,18794,44866,17335,17848,30135,45286,45515,44853,44849,14402,45561,44531,34194,6609,13922,17092,45177,45072,28530,18237,44894,19078,44870,18279,45042,45346,44739,18572,44685,45516,44878,18042,5259,18996,24412,24441,17278,17601,44640,45567,45277,37057)
Unknown column 'np.person' in 'where clause'