- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.pub_type, p.pub_date desc' at line 7
query: SELECT p.pub_id pid, p.name pname, p.pub_no pno, date_format(pub_date,"%M %Y") pdate, pt.long_descr pdescr,
p.title ptitle, p.by_person pby, p.large_image
FROM publications p, pub_types pt, people_publications pp
where p.pub_type = pt.pub_type
and pp.pub_id = p.pub_id
and p.pub_date >= "2010/10/23"
and pp.person_id = order by p.pub_type, p.pub_date desc in /afs/ir.stanford.edu/group/siepr/cgi-bin/siepr/sites/all/modules/peopleprofile/theme/personprofile.tpl.php on line 250.
- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by e.event_date desc' at line 4
query: SELECT e.event_id eid, date_format(e.event_date,e.date_format) edate, e.location eloc, e.event_name ename
from events e, people_events pe
where pe.event_id = e.event_id
and pe.pers_id = order by e.event_date desc in /afs/ir.stanford.edu/group/siepr/cgi-bin/siepr/sites/all/modules/peopleprofile/theme/personprofile.tpl.php on line 305.
- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.start_date desc' at line 5
query: SELECT p.org_id pid, p.org_name pname, date_format(p.start_date, "%m/%e/%y") sdate, date_format(p.end_date, "%m/%e/%y") edate
from organizations p, people_organizations po
where po.org_id = p.org_id
and p.org_type = "proj"
and po.person_id = order by p.start_date desc in /afs/ir.stanford.edu/group/siepr/cgi-bin/siepr/sites/all/modules/peopleprofile/theme/personprofile.tpl.php on line 344.
