It give a python error pointing out the misnamed columns in the SQL. It also need an extra join 'pubs.pub_id = pub_content.pub_id'. It also benefits from hints pubs USE INDEX (PRIMARY) and authors IGNORE INDEX (PRIMARY).
Join of pubs to pub_content was missing, and some column names were not right. Corrected the column names and added the missing join in pp_search.py 1.16 and pa_search.py 1.16.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Assigned to Marty.
Join of pubs to pub_content was missing, and some column names were not right. Corrected the column names and added the missing join in pp_search.py 1.16 and pa_search.py 1.16.
Implemented in r2011-30.