I don't think the ON for the join is right. What is the significance of ON `contests_profiles`.`contest_id` = '1' AND `contests_profiles`.`profile_id` = `Profile`.`id` ?
The comparison with 1 does not make any sense to me in the context of an ON condition. Did cake create that query, or did you? Ralph --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---
