Certisys - bio certification
Contact Jobs FAQ Liens
fr nl de en
  Se connecter à MYcertisys
CERTISYS Commencer en BIO Réglementations Formulaires Tarifs Etiquetage Biogarantie® Ecogarantie® Autres contrôles et certifications Communication
Home Liste des certificats

Liste des certificats

Echec lors de la connexion à MySQL : Access denied for user 'www-data'@'localhost' (using password: NO)

erreur MySQL : local

()
requete
SELECT oper.noop , concat( oper.nom ,' ',IfNULL(oper.nom2,''),'
',IfNULL(oper.adres,'') ,' ',IfNULL(oper.adres2,'') ,'
',IFNULL(oper.cp,''), ' ',oper.loc,IfNULL(concat('
',oper.pays),' ')) nom , oper.cp , oper.pays from ecocert.oper WHERE oper.noop = 24188

Certificats de


erreur MySQL : local

()
requete
select oper.noop , certico.ico , oper.nom , langue.txt lalg , certtydoctxt.txt , CONCAT( doccerti.tydoc , doccerti.nodoc , doccerti.lg ) nocert , CONCAT( doccerti.tydoc , doccerti.nodoc , doccerti.lg , '.pdf') fichier ,DATE_FORMAT(doccerti.docdate , '%e/%c/%Y' ) docdate , if( doccerti.docdate < curdate(),'http://certificat.certisys.eu/' ,'http://data.certisys.eu/certificat/' ) liencert , doccerti.dfin from ecocert.oper , ecocert.sysop , ecocert.certtydoc , ecocert.certico , ecocert.doccerti left outer join ecocert.certtydoctxt on certtydoctxt.tydoc = doccerti.tydoc AND certtydoctxt.lg = 'fr' left outer join ecocert.langue on langue.lgtxt = doccerti.lg AND langue.lg = certtydoctxt.lg WHERE sysop.noop = oper.noop AND certtydoc.sycert = sysop.sycert AND doccerti.noop = sysop.noop AND ( doccerti.dfin > NOW() ) AND doccerti.tydoc = certtydoc.tydoc AND sysop.etat in ('certifie', 'actif' , 'suspend') AND certico.tydoc = doccerti.tydoc AND (doccerti.alea IS NULL OR doccerti.alea = 0 ) AND oper.noop = 24188 ORDER BY 1 , doccerti.docdate DESC
Type de certificat N° du certificat Date du certificat Langue du certificat  

erreur MySQL : local

()
requete
SELECT oper.noop from ecocert.oper , ecocert.sysop , ecocert.doccerti WHERE sysop.noop = oper.noop AND doccerti.noop = sysop.noop AND ( doccerti.dfin > NOW() ) AND sysop.etat in ('certifie', 'actif' , 'suspend') AND (doccerti.alea IS NOT NULL ) AND oper.noop = 24188 GROUP BY 1

Retour à la liste

Recherche d’Opérateurs
certifiés BIO

CERTISYS Commencer en BIO Réglementations Formulaires Tarifs Etiquetage Biogarantie® Ecogarantie® Autres contrôles et certifications Communication linkelin
Contact Jobs FAQ Liens Plan du site

Copyright Certisys 2014