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 (43800,13988,45043,18042,44767,6862,45515,18279,44878,17278,44856,45346,18237,6782,44669,45561,18185,17657,44685,37057,44870,44865,18688,18981,45177,45229,28313,45518,44866,44855,5259,44745,19057,44687,18900,45286,39676,17771,14622,44867,45516,17981,44764,18446,30963,8753,44836,3,24441,18650,31354,44762,44775,22509,9341,17114,44875,17835,3883,36472,17492,45180,44671,18430,18648,45262,45072,18286,44849,45567)
Unknown column 'np.person' in 'where clause'