Feedback
SELECT offer.* FROM DH_job_offer offer
INNER JOIN DH_jockey jockey ON jockey.id=offer.jockey_id
WHERE offer.user_id=
AND offer.canceled IS NULL AND offer.offered_by='user' AND offer.jockey_id=41 ORDER BY
(jockey.friendly*2+jockey.educational*2+jockey.disciplinary*2+jockey.dressage_skill+jockey.jumping_skill+jockey.racing_skill+jockey.trav_skill) DESC,
IF(offer.accepted IS NOT NULL,1,0) ASC,
IF(offer.offered_by='jockey',1,0) DESC; : 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 'AND offer.canceled IS NULL AND offer.offered_by='user' AND offer.jockey_id=41 OR' at line 4
[-Hide comments-]
Add a comment