Certisys - bio certification
Contact Jobs FAQ Links
fr nl de en
  Inloggen op MYcertisys
CERTISYS Starten met BIO Regelgeving Formulieren Tarieven Etikettering Biogarantie® Ecogarantie® Andere controles en certificaties Communicatie
Home Certificaten lijst

Certificaten lijst

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 = 23784

Certificaten van


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 = 'nl' 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 = 23784 AND certico.ico ='BIO' ORDER BY 1 , doccerti.docdate DESC
Type certificaat Nr van het certificaat Datum van het certificaat Taal van het certificaat  

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 = 23784 GROUP BY 1

Terug naar de lijst

BIO Gecertificeerde
bedrijven zoeken

CERTISYS Starten met BIO Regelgeving Formulieren Tarieven Etikettering Biogarantie® Ecogarantie® Andere controles en certificaties Communicatie linkelin
Contact Jobs FAQ Links Inhoud van de site

Copyright Certisys 2014