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 (19078,45286,18042,14402,18894,44767,45516,44866,17092,17351,13922,45277,44853,44775,32454,44739,17703,44687,44868,18996,45051,44851,44836,36472,34194,6609,17981,44845,44745,17601,44861,30963,44894,45180,44764,17835,44762,17278,18719,24411,16885,19057,17756,44865,5259,44858,18572,45518,6875,13,18794,5993,17848,18427,24438,45517,17237,14622,39676,5410,6862,18981,44766,44765,22509,44640,5388,31354,17755,45043)
Unknown column 'np.person' in 'where clause'