|
|
database problems.....please try later *promu_ch*SELECT pmpieces.codepiece FROM pmpieces, pmtitres, pmpiecesformations, pmdifficultes, pmformations, pmlienauteurspieces LEFT JOIN pmstypes ON pmpiecesformations.codestype = pmstypes.codestype WHERE pmpieces.codetitre = pmtitres.codetitre AND pmtitres.codelangue = 2 AND pmpieces.codepiece = pmpiecesformations.codepiece AND pmpiecesformations.codedifficulte = pmdifficultes.codedifficulte AND pmdifficultes.codelangue = 2 AND (pmstypes.codelangue = 2 OR ISNULL(pmstypes.codelangue)) AND pmpiecesformations.codeformation = pmformations.codeformation AND pmformations.codelangue = 2 AND pmpiecesformations.montrer AND pmlienauteurspieces.codeauteur = 40 AND pmlienauteurspieces.codepiece = pmpieces.codepiece 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, pmlienauteurspieces.codeauteur FROM pmpieces, pmtitres, pmpiecesformations, pmdifficultes, pmformations, pmlienauteurspieces LEFT JOIN pmstypes ON pmpiecesformations.codestype = pmstypes.codestype WHERE pmpieces.codetitre = pmtitres.codetitre AND pmtitres.codelangue = 2 AND pmpieces.codepiece = pmpiecesformations.codepiece AND pmpiecesformations.codedifficulte = pmdifficultes.codedifficulte AND pmdifficultes.codelangue = 2 AND (pmstypes.codelangue = 2 OR ISNULL(pmstypes.codelangue)) AND pmpiecesformations.codeformation = pmformations.codeformation AND pmformations.codelangue = 2 AND pmpiecesformations.montrer AND pmlienauteurspieces.codeauteur = 40 AND pmlienauteurspieces.codepiece = pmpieces.codepiece GROUP BY pmpieces.codepiece, pmpiecesformations.codeformation ORDER BY pmtitres.titre LIMIT 0, 15*Resource id #3*0: ..-1] ..-1] | ||||||||||||||||||||||||||||||
