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 (45346,18900,44863,24412,37267,17556,44856,44689,45515,13425,5259,18185,16935,44674,44711,30986,44765,17839,44767,44894,18286,44851,17981,18237,28313,44768,44762,44873,17657,17904,18650,18042,18981,17601,18572,44853,17703,45561,44640,44867,17237,17009,19078,18688,16885,43800,45518,17492,44766,44875,28530,4765,45042,6609,45421,44865,44685,13,17756,45043,18430,17527,44531,17278,4686,18652,39676,44845,13988,44687)
Unknown column 'np.person' in 'where clause'