SELECT DISTINCT ciden.den_des, ciden.den_desd, ciden.den_desd, cicod.cod_lib, cod_lan, ciden.den_sec, ciden.den_no FROM ciden LEFT JOIN cimod ON ( ciden.den_no = cimod.den_no ) LEFT JOIN cicou ON ( cimod.mod_no = cicou.mod_no AND cimod.mod_deb = cicou.mod_deb ) LEFT JOIN cifil ON ( ciden.den_no = cifil.den_no ) LEFT JOIN civol ON ( cifil.fil_no = civol.vol_fil ) LEFT JOIN cicod ON ciden.den_sec = cicod.cod_no WHERE cod_id = 'DEN_SEC' AND cod_lib ='Lehrgänge'AND cod_lan ='D' LIMIT 0, 100 [nativecode=23 ** Out of resources when opening file './cpi/civol.MYD' (Errcode: 24 - Too many open files)] nterprofessionelles Weitebildungszentrum IWZ
SELECT DISTINCT ciden.den_des, ciden.den_desd, ciden.den_desd, cicod.cod_lib, cod_lan, ciden.den_sec, ciden.den_no FROM ciden LEFT JOIN cimod ON ( ciden.den_no = cimod.den_no ) LEFT JOIN cicou ON ( cimod.mod_no = cicou.mod_no AND cimod.mod_deb = cicou.mod_deb ) LEFT JOIN cifil ON ( ciden.den_no = cifil.den_no ) LEFT JOIN civol ON ( cifil.fil_no = civol.vol_fil ) LEFT JOIN cicod ON ciden.den_sec = cicod.cod_no WHERE cod_id = 'DEN_SEC' AND cod_lan ='D'AND den_sec ='2'AND ciden.den_no ='23' LIMIT 0, 100 [nativecode=1016 ** Can't open file: './cpi/civol.frm' (errno: 24 - Too many open files)]
Zurück  /   Unsere Ausbildungen  /  

Verfügbare Module im Sektor
« > »

Untergruppe

SELECT `cimod`.`mod_no`, `cimod`.`mod_deb`, `cimod`.`mod_fin`, `cimod`.`den_no`, `cimod`.`mod_res`, `cimod`.`mod_typ`, `cimod`.`mod_tit_d` tit, `cimod`.`xxx_vismut`, `cimod`.`xxx_datmut`, `ciden`.`den_sec`, `ciden`.`den_des`, `cicod`.`cod_lib`, `cicod`.`cod_lan` FROM `ciden` , `cimod` , `cicod` WHERE ciden.den_no = cimod.den_no AND ciden.den_sec = cicod.cod_no AND cicod.cod_id = 'DEN_SEC' AND `cimod`.`mod_dis_d`= '1' AND mod_priv_d = '0' AND (mod_fin = '0000-00-00' OR mod_fin>NOW() ) AND cimod.den_no ='23'AND den_sec ='2' GROUP BY cimod.mod_no, cimod.mod_deb ORDER BY cimod.mod_tit_d ASC LIMIT 0, 100 [nativecode=23 ** Out of resources when opening file './cpi/cicod.MYD' (Errcode: 24 - Too many open files)]

Modul


Lehrgänge