|
Logement : le diagnostic de performance énergétique (DPE) Enquête avec l'Asseco
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, cdc_ref_idy, cdc_titre, cdc_url,
CASE WHEN ctd.ctd_pere_idy is null
THEN ctd.ctd_code
ELSE ctdpere.ctd_code
END as ctd_perecode,
CASE WHEN (ctd.ctd_urlbase is null OR ctd.ctd_urlbase = '')
AND (ctdpere.ctd_urlbase is null OR ctdpere.ctd_urlbase = '')
THEN (SELECT SCT_CHM || SCT_NOM_REP FROM TD_SCT WHERE sct_idy = cdc_ref_idy)
WHEN ctdpere.ctd_urlbase is null OR ctdpere.ctd_urlbase = ''
THEN ctd.ctd_urlbase
ELSE ctdpere.ctd_urlbase
END as ctd_realurlbase,
CASE WHEN cdc_url is null OR cdc_url = ''
THEN CAST(cdc_ref_idy AS varchar)
ELSE cdc_url
END as cdc_realurl
FROM conso_doc, conso_typedoc ctd
LEFT JOIN conso_typedoc ctdpere
ON ctd.ctd_pere_idy = ctdpere.ctd_idy
WHERE cdc_idy = 25996arefIdy=1111
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
|