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 (44873,44858,18996,44640,44851,44689,28313,4765,17092,34194,17848,28530,8753,45043,44745,44867,18286,9341,18172,45180,39676,17904,13425,37267,18981,45177,44836,44865,6862,44531,44861,18446,18719,17755,17114,45042,45051,18900,45286,44775,16935,44671,5388,32454,3,18353,18430,17278,17703,44765,44711,43800,6875,18279,44739,18650,17335,17835,17237,16885,36472,44849,24438,18042,45516,44674,45561,44687,3883,37057)
Unknown column 'np.person' in 'where clause'