- 'SELECT dom.id, dom.nom as domnom, asso.diminutif, asso.nom
- FROM groupex.dom
- INNER JOIN groupex.asso ON dom.id = asso.dom
- WHERE FIND_IN_SET("GroupesX", dom.cat) AND FIND_IN_SET("GroupesX", asso.cat)
- ORDER BY dom.nom, asso.nom');
+ 'SELECT dom.id, dom.nom as domnom, groups.diminutif, groups.nom
+ FROM group_dom AS dom
+ INNER JOIN groups ON dom.id = groups.dom
+ WHERE FIND_IN_SET("GroupesX", dom.cat) AND FIND_IN_SET("GroupesX", groups.cat)
+ ORDER BY dom.nom, groups.nom');