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,37267,44867,44685,44848,45421,4765,5259,18996,45286,16885,45518,18286,44837,17009,44873,44640,45072,6875,44674,45567,44861,44765,28313,44739,17601,18688,18237,44894,31354,18900,19057,45051,24412,44851,17492,18042,44768,45262,44866,30135,13425,44868,44531,18427,45561,45516,39676,4686,17092,13922,18446,44835,3,17657,5388,44669,36472,18650,22509,44855,44869,44870,16935,24441,17771,17981,45180,18894,45517)
Unknown column 'np.person' in 'where clause'