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 (14622,44767,44531,4686,44869,45177,4765,17009,17601,6782,17981,22509,17756,17114,44856,18900,18794,17703,24412,18301,18279,44671,44764,45043,28313,17839,18427,44745,14402,17278,44873,44768,44836,37057,45180,44711,16935,45262,17848,45517,18572,45277,45229,45042,28530,16885,8753,18894,18430,17771,44687,13922,44851,18237,18286,5993,32454,44835,18981,44685,17492,30963,45421,44765,17556,44870,5388,44775,44762,18648)
Unknown column 'np.person' in 'where clause'