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 (30986,18572,44835,18652,13922,44674,45229,45561,8753,36472,44867,44711,44884,5388,44775,44869,4765,44854,44766,18446,17527,45517,44875,44870,18301,44671,45518,24412,17755,18894,30963,5410,6875,28530,4686,45072,18172,28313,37267,45180,14402,44762,44858,3883,6862,45262,44873,17351,10402,17492,18794,45516,18981,24441,18279,5993,44640,13425,45051,17904,45421,44845,45043,17703,45042,24438,37057,44669,6609,18688)
Unknown column 'np.person' in 'where clause'