Ok i edited the html file, took out doc type etc. and all the other crap in it.
I am now getting only a link of my favorites in the email.. which is great and i assume how it should work.
but i am getting an error when i click to view the link, see code here
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 ' 1,0) ) L' at line 37 SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `bsound_app_voicelink`.`id` AS `bsound_app_voicelink___id`,
`bsound_app_voicelink`.`id` AS `bsound_app_voicelink___id_raw`,
`bsound_app_voicelink`.`date_time` AS `bsound_app_voicelink___date_time`,
`bsound_app_voicelink`.`date_time` AS `bsound_app_voicelink___date_time_raw`,
`bsound_app_voicelink`.`gender` AS `bsound_app_voicelink___gender_raw`,
`bsound_com_malefemale`.`gender` AS `bsound_app_voicelink___gender`,
`bsound_app_voicelink`.`name` AS `bsound_app_voicelink___name`,
`bsound_app_voicelink`.`name` AS `bsound_app_voicelink___name_raw`,
`bsound_app_voicelink`.`status` AS `bsound_app_voicelink___status_raw`,
`bsound_com_status`.`com_status` AS `bsound_app_voicelink___status`,
(SELECT GROUP_CONCAT(lookup.com_category SEPARATOR '//..*..//') FROM bsound_app_voicelink_repeat_category
LEFT JOIN bsound_com_category AS lookup ON lookup.id = bsound_app_voicelink_repeat_category.category WHERE bsound_app_voicelink_repeat_category.parent_id = `bsound_app_voicelink`.`id`) AS bsound_app_voicelink___category,
(SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM bsound_app_voicelink_repeat_category WHERE parent_id = `bsound_app_voicelink`.`id`) AS `bsound_app_voicelink___category_raw`, (SELECT GROUP_CONCAT(category SEPARATOR '//..*..//') FROM bsound_app_voicelink_repeat_category WHERE bsound_app_voicelink_repeat_category.parent_id = `bsound_app_voicelink`.`id`) AS bsound_app_voicelink___category_id,
(SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM bsound_app_voicelink_repeat_category WHERE parent_id = `bsound_app_voicelink`.`id`) AS `bsound_app_voicelink___category___params`,
(SELECT GROUP_CONCAT(lookup.com_characteristics SEPARATOR '//..*..//') FROM bsound_app_voicelink_repeat_characteristics
LEFT JOIN bsound_com_characteristics AS lookup ON lookup.id = bsound_app_voicelink_repeat_characteristics.characteristics WHERE bsound_app_voicelink_repeat_characteristics.parent_id = `bsound_app_voicelink`.`id`) AS bsound_app_voicelink___characteristics,
(SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM bsound_app_voicelink_repeat_characteristics WHERE parent_id = `bsound_app_voicelink`.`id`) AS `bsound_app_voicelink___characteristics_raw`, (SELECT GROUP_CONCAT(characteristics SEPARATOR '//..*..//') FROM bsound_app_voicelink_repeat_characteristics WHERE bsound_app_voicelink_repeat_characteristics.parent_id = `bsound_app_voicelink`.`id`) AS bsound_app_voicelink___characteristics_id,
(SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM bsound_app_voicelink_repeat_characteristics WHERE parent_id = `bsound_app_voicelink`.`id`) AS `bsound_app_voicelink___characteristics___params`,
`bsound_app_voicelink`.`commercial` AS `bsound_app_voicelink___commercial`,
`bsound_app_voicelink`.`commercial` AS `bsound_app_voicelink___commercial_raw`,
`bsound_app_voicelink`.`narrative` AS `bsound_app_voicelink___narrative`,
`bsound_app_voicelink`.`narrative` AS `bsound_app_voicelink___narrative_raw`,
`bsound_app_voicelink`.`political` AS `bsound_app_voicelink___political`,
`bsound_app_voicelink`.`political` AS `bsound_app_voicelink___political_raw`,
`bsound_app_voicelink`.`ethnic` AS `bsound_app_voicelink___ethnic`,
`bsound_app_voicelink`.`ethnic` AS `bsound_app_voicelink___ethnic_raw`,
`bsound_app_voicelink`.`test` AS `bsound_app_voicelink___test`,
`bsound_app_voicelink`.`test` AS `bsound_app_voicelink___test_raw`,
`bsound_app_voicelink`.`bookit` AS `bsound_app_voicelink___bookit`,
`bsound_app_voicelink`.`bookit` AS `bsound_app_voicelink___bookit_raw`,
`bsound_app_voicelink`.`id` AS slug
, `bsound_app_voicelink`.`id` AS `__pk_val`
FROM `bsound_app_voicelink`
LEFT JOIN `bsound_com_malefemale` AS `bsound_com_malefemale` ON `bsound_com_malefemale`.`id` = `bsound_app_voicelink`.`gender`
LEFT JOIN `bsound_com_status` AS `bsound_com_status` ON `bsound_com_status`.`id` = `bsound_app_voicelink`.`status`
WHERE ( `bsound_app_voicelink`.`id` IN ( 1,0) ) LIMIT 0, 10