database problems.....please try later

*promu_ch*SELECT pmtitres.titre, pmtitres.codetitre, pmcommentaires.commentaire, pmcommentaires2.commentaire AS commentaire2, pmpieces.codecommande, pmformations.formation, pmdifficultes.difficulte, pmpiecesformations.codedifficulte, pmpiecesformations.duree, pmstypes.stype, pmformats.format FROM pmpiecesformations, pmpieces, pmtitres , pmcommentaires, pmcommentaires AS pmcommentaires2, pmformations, pmdifficultes, pmformats LEFT JOIN pmstypes ON pmpiecesformations.codestype = pmstypes.codestype WHERE pmpieces.codepiece = 37 AND pmpiecesformations.codeformation = 2 AND pmpiecesformations.codepiece = pmpieces.codepiece AND (pmstypes.codelangue = 2 OR ISNULL(pmstypes.codelangue)) AND pmtitres.codelangue = 2 AND pmtitres.codetitre = pmpieces.codetitre AND pmformations.codelangue = 2 AND pmformations.codeformation = pmpiecesformations.codeformation AND pmcommentaires.codelangue = 2 AND pmcommentaires.codecommentaire = pmpieces.codecommentaire AND pmcommentaires2.codelangue = 2 AND pmcommentaires2.codecommentaire = pmpiecesformations.codecommentaire AND pmdifficultes.codelangue = 2 AND pmdifficultes.codedifficulte = pmpiecesformations.codedifficulte AND pmformats.codelangue = 2 AND pmformats.codeformat = pmpiecesformations.codeformat*Resource id #3*
0:
ERROR...
  Detailled search

Français English Español 
Show basket
Mailing list

Login

Catalog

Methods

Brass Ensemble

Brass quintet

English Brass Band

Fanfare

Solo & piano

Tuba Quartet

Various small bands

Wind band

Classical

Concert

Dance

Hit

Introduction

Light music

March

Marching

Original work

Showstopper

Slow piece

Soundtrack

Swing

Traditional

Wind quintet

Writters

Part of the author's list

Pernet, André

Favre, Pascal

Jimenez, Gerónimo

Moren, Bertrand

Complet list

Discs

List

Basket

Show basket

Make the order




Contact : info@promu.ch

37, 2 ?

Copyright © Pro Music SA 2010.
All brands are protected. All documents in this site (texts, pictures, sounds, ...) are protected by the copyright : reproduction prohibited without writted acknoweldge of the autors.