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 (45229,18286,44669,18430,19078,18652,45051,44870,14622,44873,18719,44739,44768,14402,43800,44835,24411,17835,44766,18981,44865,17848,44640,45515,17904,24441,17601,4686,17703,4765,28313,18353,18794,18900,18237,9341,17771,44674,18172,45561,18279,36472,44855,44745,5993,17527,45421,45518,18688,45180,37267,16885,17492,18301,44671,18446,6609,18648,45517,44856,45516,44849,19057,5410,30986,17351,44868,44866,45043,44836)
Unknown column 'np.person' in 'where clause'