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 (17835,17904,45421,18572,18996,44768,18719,22509,45286,8753,17092,28313,44868,13922,45177,6862,44687,17335,18185,18652,5410,24412,4765,44866,44870,24438,44836,17114,44674,18900,17756,44775,44764,6875,9341,44849,45051,39676,44531,5259,45567,45346,30963,45043,3883,44894,14622,44671,45229,44858,18237,45072,18688,17601,44669,18894,13425,17351,44878,18279,44745,18981,17009,18042,17703,44848,18353,17556,36472,45262)
Unknown column 'np.person' in 'where clause'