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 (18981,4686,17848,17351,6782,18279,45177,44689,44873,44764,39676,31354,44745,18996,3883,45262,45517,45277,5259,45042,18648,17237,6609,17657,44878,18688,44865,10402,18042,17755,44866,18446,17981,30963,19078,44861,17527,44856,14402,45561,43800,44853,18650,9341,17601,5993,44711,44835,24438,16885,45229,44775,17839,17278,18652,30986,44669,18301,44766,44739,45518,44836,45286,18894,45043,5388,45516,44762,45180,17114)
Unknown column 'np.person' in 'where clause'