Sorry this was my mistakeā¦ 
SELECT
`ID`, `C_NO`, `U_NO`,
`GIDEON_NO`, `AUX_NO`, `TITLE_G`,
`SALUT`, `FN_G`, `FN_G_SEC`,
`TITLE_A`, `FN_A`, `FN_A_SEC`,
`F_NAME`, `STR`, `POBOX`,
`PLZ`, `CITY`, `POS_LAT`,
`POS_LNG`, `FIRMA`, `JOB`,
`TELB`, `TELP`, `TELM_G`,
`TELM_A`, `FAXP`, `FAXB`,
`C_C`, `C_C_CITY`, `B_DAY_G`,
`EMAIL_G`, `CERT_G`, `LTM_G`,
`G_ED`, `CHAIRMEN_G`, `CABINET_G`,
`CABINET_G_S`, `NAT_C_G`, `NAT_C_G_S`,
`CS_S_T`, `CS_S_T_DAT`, `CS_LANG`,
`CS_S_T_AUX`, `CS_S_T_DAT_AUX`, `CS_LANG_AUX`,
`NMDM_G`, `NMDM_A`, `PAB_G`,
`PAB_A`, `B_DAY_A`, `EMAIL_A`,
`CERT_A`, `LTM_A`, `A_ED`,
`CHAIRMEN_A`, `CABINET_A`, `CABINET_A_S`,
`NAT_C_A`, `NAT_C_A_S`, `NOTE`,
`CRSP`, `INFO`, `OPT`,
`L_UPDATE`, `STAT_UPDATE`, `STAT_DEL`,
`RPL$LOCAL`
FROM
`MEMBER`
WHERE
(1 = 1)
AND C_NO IN (SELECT DISTINCT CAMP_NO FROM RPL$GROUPS_RIGHTS WHERE
GROUP_NO = 'CH' )
**AND C_NO IN** (SELECT DISTINCT CAMP_NO FROM RPL$GROUPS_RIGHTS WHERE GROUP_NO = 'CH' )
The filter Field is C_NO with this SQL in phpMyAdmin the correct filtered result but in my App i get this:
