SQL: SELECT p.*, r.rating
FROM paysite p
JOIN paysite_category pc ON (p.ps_id = pc.ps_id AND pc.cat_id = )
LEFT JOIN rating r ON (r.ps_id = p.ps_id)
WHERE p.published=2
GROUP BY ps_id ORDER BY p.review_date DESC, r.rating DESC, p.title
ERR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') LEFT JOIN rating r ON (r.ps_id = p.ps_id) WHER' at line 3
ERR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') LEFT JOIN rating r ON (r.ps_id = p.ps_id) WHER' at line 3