SELECT DISTINCT
		   a.id,
		   a.user_id,
		   _user_id_.name                   AS `_user_id_name`,
		   _user_usergroup_map_id_.group_id AS `_user_usergroup_map_id_group_id`,
		   _usergroup_id_.title             AS `_usergroup_id_title`,
		   a.created_by,
		   a.published
	FROM   #__cook_users AS a
		   LEFT JOIN `vs4go_users` AS _user_id_
				  ON _user_id_.id = a.user_id
		   LEFT JOIN `vs4go_user_usergroup_map` AS _user_usergroup_map_id_
				  ON _user_usergroup_map_id_.user_id = a.user_id
		   LEFT JOIN `vs4go_usergroups` AS _usergroup_id_
				  ON _usergroup_id_.id = _user_usergroup_map_id_.group_id
		   LEFT JOIN `vs4go_cook_usergroups` AS _usergroups_id_
				  ON _usergroups_id_.user_id = a.id
		   LEFT JOIN `vs4go_cook_groups` AS _group_id_
				  ON _group_id_.id = _usergroups_id_.group_id
	WHERE  ( a.published = 0
			  OR a.published = 1
			  OR a.published IS NULL )
		   AND _usergroup_id_.title = 'Mrs.'
		   AND _group_id_.level >= 30
		   AND a.company_id = 1
	ORDER  BY a.user_id ASC