How to form the correct sql query?

Question

PHP

Have a request

SELECT * FROM table WHERE `status` = 'maubert' and`AssosUser` in ('LAROQUE','N.C.') and `telepro` in ('DENIS','MANGEL','MORANGE')

The output is this . It is

necessary to form a query so that "DENIS" is displayed only with AssosUser = LAROQUE , and others (MANGEL','MORANGE) with AssosUser = LAROQUE and AssosUser = NC
How to do this? really need help please

Answer 1

SELECT * 
FROM `table`
WHERE `status`='maubert' 
AND (
    (`AssosUser`='LAROQUE' AND `telepro`='DENIS') OR
    (`AssosUser` IN ('LAROQUE', 'N.C.') AND `telepro` IN ('MANGEL', 'MORANGE') 
);