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 (44739,31354,44854,44848,17981,9341,45262,17835,19078,17657,45518,17848,17601,13425,45516,45567,17703,44765,30135,44836,13988,44764,18572,18981,6782,44687,5410,44870,18446,44766,6875,5259,14402,44762,17492,4765,17335,45515,44767,44745,18185,18688,44689,44674,44865,43800,36472,44868,44873,3,45421,44849,18996,19057,13,17556,16885,24438,24441,18430,45561,17527,28313,4686,45286,16935,17351,18427,28530,37267)
Unknown column 'np.person' in 'where clause'