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 (30986,6609,24438,45042,6782,18900,5388,5410,45277,44868,44875,44894,43800,45262,18172,17657,45229,16935,37267,44669,18042,44711,5993,34194,44861,45561,17771,45516,17556,18185,13922,44854,17756,24441,19057,44853,3,44835,18996,4686,17835,22509,4765,10402,44866,28313,45517,44739,17601,45518,44640,17278,18279,17114,6875,13425,16885,24411,44775,44674,44685,18301,36472,18648,45072,31354,44858,44870,44873,45180)
Unknown column 'np.person' in 'where clause'