Group Users – iKnowThat!

Assign Group Members

WordPress database error: [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 'AND `group_ext_id` = ""' at line 2]
SELECT `group_name`,`group_int_id`,`parent_group`,`challenge` FROM `wp_9if2ry_groups` WHERE BINARY `comp_int_id`= AND `group_ext_id` = ""

WordPress database error: [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 'AND `group_int_id` =' at line 2]
SELECT `group_name`,`parent_group` FROM `wp_9if2ry_groups` WHERE `comp_int_id` = AND `group_int_id` =

Select from next higher group only

WordPress database error: [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 '' at line 2]
SELECT `parent_group` FROM `wp_9if2ry_groups` WHERE `group_int_id` =

WordPress database error: [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 'UNION SELECT 0 AS isassign, user.`user_int_id`,`user_nick`FROM `wp_9if2ry_partic' at line 2]
SELECT 1 AS isassign, user.`user_int_id`,`user_nick`FROM `wp_9if2ry_participant` as user, `wp_9if2ry_group_assigns` as asg WHERE BINARY user.`user_int_id` = asg.`user_int_id` AND BINARY asg.`group_int_id`= UNION SELECT 0 AS isassign, user.`user_int_id`,`user_nick`FROM `wp_9if2ry_participant` as user WHERE BINARY user.`comp_int_id` = AND user.user_int_id NOT IN (SELECT asg.user_int_id FROM `wp_9if2ry_group_assigns` as asg WHERE asg.group_int_id =) ORDER BY user_nick