SELECT DISTINCT synthese.nfic, synthese.pole, synthese.meteo, synthese.meteo2, synthese.meteo3, synthese.meteo4, synthese.nmrs, synthese.nmrs2, synthese.nmrs3, synthese.nmrs4, synthese.valid, synthese.meteo5, synthese.nmrs5
FROM (
(
synthese
LEFT JOIN synthesex ON synthese.NFIC = synthesex.NFIC
)
LEFT JOIN suivi ON synthese.NFIC = suivi.NFIC
)
LEFT JOIN inter ON synthese.NFIC = inter.NFIC
LEFT JOIN log_chaud ON synthese.NFIC = log_chaud.JOUR
WHERE 1 AND (
synthese.NMRS
LIKE '%faure%' OR synthese.NMRS2
LIKE '%faure%' OR synthese.NMRS3
LIKE '%faure%' OR synthese.NMRS4
LIKE '%faure%' OR synthese.NMRS5
LIKE '%faure%' OR synthesex.DESO
LIKE '%faure%' OR synthesex.DESO2
LIKE '%faure%' OR synthesex.REF
LIKE '%faure%' OR synthesex.DIMPCT5
LIKE '%faure%' OR synthesex.DIMPCT5
LIKE '%faure%' OR synthesex.DESCLD5
LIKE '%faure%' OR synthesex.SPI
LIKE '%faure%' OR synthesex.APPL
LIKE '%faure%' OR inter.DESO
LIKE '%faure%' OR suivi.DESO
LIKE '%faure%'
)
ORDER BY synthese.NFIC DESC LIMIT 0 , 30
Partager