Secondo voi se ho una query con quete condizioni fa la ricerca di tutti i risultati che contengono il termine 'xxxx' e che contemporaneamente non contengono il termine 'zzzz'? o c'è qualcosa che non va?


SELECT patents.*, GROUP_CONCAT(DISTINCT CONCAT(applicants.name,' (',applicants.country,')') SEPARATOR '; ') AS applicants, GROUP_CONCAT(DISTINCT CONCAT(inventors.name,' (',inventors.country,')') SEPARATOR '; ') AS inventors, GROUP_CONCAT(DISTINCT CONCAT(classifications.classification,'') SEPARATOR '; ') AS classifications FROM (((patents LEFT JOIN inventors ON patents.idPatent=inventors.idPatent) LEFT JOIN applicants ON patents.idPatent=applicants.idPatent) LEFT JOIN info ON patents.idPatent=info.idPatent) LEFT JOIN priorities ON patents.idPatent=priorities.idPatent LEFT JOIN classifications ON patents.idPatent=classifications.idPatent WHERE (patents.titleEn LIKE '%xxxx%' OR info.abstractEn LIKE '%xxxx%' OR info.descriptionEn LIKE '%xxxx%' OR patents.titleFr LIKE '%xxxx%' OR info.abstractFr LIKE '%xxxx%' OR info.descriptionFr LIKE '%xxxx%' OR patents.titleDe LIKE '%xxxx%' OR info.abstractDe LIKE '%xxxx%' OR info.descriptionDe LIKE '%xxxx%' OR patents.publicationNumber LIKE '%xxxx%' OR patents.applicationNumber LIKE '%xxxx%' OR priorities.number LIKE '%xxxx%' OR patents.firstPublicationDate LIKE '%xxxx%' OR patents.publicationDate LIKE '%xxxx%' OR applicants.name LIKE '%xxxx%' OR inventors.name LIKE '%xxxx%') AND (patents.titleEn NOT LIKE '%zzzz%' OR info.abstractEn NOT LIKE '%zzzz%' OR info.descriptionEn NOT LIKE '%zzzz%' OR patents.titleFr NOT LIKE '%zzzz%' OR info.abstractFr NOT LIKE '%zzzz%' OR info.descriptionFr NOT LIKE '%zzzz%' OR patents.titleDe NOT LIKE '%zzzz%' OR info.abstractDe NOT LIKE '%zzzz%' OR info.descriptionDe NOT LIKE '%zzzz%' OR patents.publicationNumber NOT LIKE '%zzzz%' OR patents.applicationNumber NOT LIKE '%zzzz%' OR priorities.number NOT LIKE '%zzzz%' OR patents.firstPublicationDate NOT LIKE '%zzzz%' OR patents.publicationDate NOT LIKE '%zzzz%' OR applicants.name NOT LIKE '%zzzz%' OR inventors.name NOT LIKE '%zzzz%') GROUP BY patents.idPatent;