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 (19078,44863,18172,44689,44858,44674,44869,44873,30963,44856,5993,44836,17278,18688,6875,16885,6862,6609,44745,17092,18981,44767,28313,5259,4686,44640,45561,13922,44868,36472,44845,45346,18286,10402,28530,5388,18446,44878,17839,17527,13,39676,17114,16935,44739,44775,34194,45277,24441,18894,31354,45286,18279,24438,44853,14622,17835,44884,44765,17657,44854,5410,44764,18301,18794,18900,43800,17335,45517,37057)
Unknown column 'np.person' in 'where clause'