Navigation MENU
MySQL error : 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 's_droomvakanties'' at line 3
When executing:
SELECT *,(SELECT count(challenge_id) as total FROM yol_challenges_to_charity as tb2 Where tb2.charity_id = tb1.id ) as totalchallnegs, ((COALESCE((SELECT SUM( total_raised ) AS totals FROM yol_challenges AS tb3 LEFT JOIN yol_challenges_to_charity AS tbl5 ON tb3.id = tbl5.challenge_id WHERE tb3.challenges_open_close = 'open' AND tb1.id = tbl5.charity_id),0) ) + (COALESCE((SELECT SUM( total_transferred ) AS totals FROM yol_challenges AS tb3 LEFT JOIN yol_challenges_to_charity AS tbl5 ON tb3.id = tbl5.challenge_id WHERE tb3.challenges_open_close = 'close' AND tb1.id = tbl5.charity_id),0))) as total_raised,(SELECT SUM(transferred_amount) FROM yol_challenges_to_charity as tb2 Where tb2.charity_id = tb1.id ) as charity_transferred FROM `yol_charity` as tb1 Where tb1.id = '46_menno's_droomvakanties'