skyrun
Active Member
on skyrun.com/skyforce, enter a search term in the search box (like 'cox') and press enter.
you'll get the following sql error (1064) that i can't seem to get rid of...
you'll get the following sql error (1064) that i can't seem to get rid of...
Code:
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 'DISTINCT `sf_lead`.`id` AS __pk_val0, `sf_lead_campaign`.`id` AS __pk_val1 FROM ' at line 1 SQL=SELECT DISTINCT `sf_activity`.`id` AS __pk_val0, DISTINCT `sf_lead`.`id` AS __pk_val0, `sf_lead_campaign`.`id` AS __pk_val1 FROM `sf_activity` LEFT JOIN `jos_users` AS `jos_users` ON `jos_users`.`id` = `sf_activity`.`user` LEFT JOIN `sf_lead` AS `sf_lead` ON `sf_lead`.`id` = `sf_activity`.`lead_id` ORDER BY `sf_lead`.`lead_quality_score` DESC