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,44865,44674,44867,44531,14402,16885,17835,17009,45286,45229,44878,45516,17904,18042,44870,45180,17981,18286,45421,45051,45517,17278,6609,44851,18427,17556,18688,17703,37057,18648,44689,18900,17848,30135,30963,8753,44836,18894,34194,18172,45567,44669,37267,22509,44848,18353,28313,17114,24441,45518,14622,44835,18981,24438,18794,17492,17756,44687,44861,39676,44849,19057,17335,44869,45043,18572,24412,43800,18652)
Unknown column 'np.person' in 'where clause'