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 (28313,31354,44856,28530,44894,17835,18446,6862,44863,44674,17848,45567,45561,17756,17237,17335,18279,44867,45421,45517,18353,44689,17839,44869,8753,13425,44870,44835,17492,44768,18794,44878,44762,17009,44531,32454,45516,45229,14622,17556,6782,16935,44640,17278,6875,9341,17755,18981,18430,37057,39676,17527,17657,17601,44669,37267,10402,5388,44836,43800,18427,44854,18042,45051,44685,17771,44861,45072,18648,17351)
Unknown column 'np.person' in 'where clause'