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 (34194,44855,32454,44851,44868,44873,30986,6862,44861,45043,45517,14622,30963,44739,8753,18353,17771,5388,37267,5259,31354,18794,17755,17835,17556,17278,17848,44863,44775,14402,18652,44689,44875,6875,24441,3883,44856,44768,44858,44867,17904,10402,44640,9341,44869,18648,44745,45516,13,3,44674,18894,45518,45262,5410,18286,18688,28530,18172,28313,24412,45180,44767,30135,44849,43800,17601,16885,44766,17703)
Unknown column 'np.person' in 'where clause'