Forums

i have a simple join relation between 2 joomla tables related to users
jos_user_usergroup_map (model1)
jos_users( model2)
maped by model1->user_id, to model2->id I think it's a bug because I have it working fine in CCv5
​
the bug is only is about it's just obtained first row
​
​
[0] => SELECT `usr`.`id` AS `usr.id`, `usr`.`name` AS `usr.name`, `usr`.`username` AS `usr.username`, `usr`.`email` AS `usr.email`, `usr`.`block` AS `usr.block` FROM `jos_user_usergroup_map` AS `map` LEFT JOIN `jos_users` AS `usr` ON `map`.`user_id` = `usr`.`id` LIMIT 100;
​
its very strange because if I use another tables, all works fine
​
jos_user_usergroup_map
jos_usergroups
​
[0] => SELECT `usr`.`id` AS `usr.id` FROM `jos_user_usergroup_map` AS `map` LEFT JOIN `jos_usergroups` AS `usr` ON `map`.`group_id` = `usr`.`id` LIMIT 100;