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 'groups G ON P.pubgroup = G.code AND P.pubgroup = 'GBB' AND P.status <> 'D'  ORDE' at line 1