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 (44767,13922,39676,18719,4765,18996,13988,17904,18042,18185,44768,44671,4686,17835,5259,18894,44863,17114,5388,37267,10402,44762,18286,44711,45346,44851,31354,18353,18446,44745,24441,44866,18650,44869,14622,44894,43800,45262,44856,18430,17839,45043,44884,44531,18572,6875,8753,44875,37057,19057,18900,18794,6782,13,45177,45180,5410,45042,44870,44835,17848,17009,6862,44764,44853,28313,17492,45567,17657,45421)
Unknown column 'np.person' in 'where clause'