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 (18981,44863,18650,44837,18042,45043,44764,44674,45515,44878,17771,34194,18652,44849,30963,36472,4765,18688,16935,18430,45229,45561,17527,37057,19078,17981,28530,19057,44669,44861,18648,6875,45072,28313,17351,16885,18353,45051,18301,22509,18427,45177,44867,17009,5410,45516,6782,44531,9341,13,44767,17335,18237,17278,17839,44851,44868,45262,44836,45518,17703,44640,3883,44685,45286,24411,45042,18446,18894,44845)
Unknown column 'np.person' in 'where clause'