|
| database problems.....please try later *promu_ch*SELECT pmpieces.codepiece FROM pmpieces, pmtitres, pmpiecesformations, pmdifficultes, pmformations LEFT JOIN pmstypes ON pmpiecesformations.codestype = pmstypes.codestype WHERE pmpieces.codetitre = pmtitres.codetitre AND pmtitres.codelangue = 1 AND pmpieces.codepiece = pmpiecesformations.codepiece AND pmpiecesformations.codedifficulte = pmdifficultes.codedifficulte AND pmdifficultes.codelangue = 1 AND (pmstypes.codelangue = 1 OR ISNULL(pmstypes.codelangue)) AND pmpiecesformations.codeformation = pmformations.codeformation AND pmformations.codelangue = 1 AND pmpiecesformations.montrer AND pmpiecesformations.codeformation = 1 GROUP BY pmpieces.codepiece, pmpiecesformations.codeformation ORDER BY pmtitres.titre*Resource id #3*0: database problems.....please try later *promu_ch*SELECT pmpieces.codepiece, pmtitres.titre, pmpiecesformations.codedifficulte, pmdifficultes.difficulte, pmpiecesformations.codestype, pmstypes.stype, pmpiecesformations.codeformation, pmformations.formation, pmpiecesformations.duree FROM pmpieces, pmtitres, pmpiecesformations, pmdifficultes, pmformations LEFT JOIN pmstypes ON pmpiecesformations.codestype = pmstypes.codestype WHERE pmpieces.codetitre = pmtitres.codetitre AND pmtitres.codelangue = 1 AND pmpieces.codepiece = pmpiecesformations.codepiece AND pmpiecesformations.codedifficulte = pmdifficultes.codedifficulte AND pmdifficultes.codelangue = 1 AND (pmstypes.codelangue = 1 OR ISNULL(pmstypes.codelangue)) AND pmpiecesformations.codeformation = pmformations.codeformation AND pmformations.codelangue = 1 AND pmpiecesformations.montrer AND pmpiecesformations.codeformation = 1 GROUP BY pmpieces.codepiece, pmpiecesformations.codeformation ORDER BY pmtitres.titre LIMIT 0, 15*Resource id #3*0: ..-1] ..-1] |
|
