| Voici toutes les vidéos disponibles sur France2. Cliquez sur l'imagette ou sur le titre de votre choix pour lancer la vidéo. | |
plus de vidéos ... |
|
La sécurité électrique à la maison avec Macif Préventon </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 = 27428arefIdy=1547
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
16/07/2014 à 13:50 |
Partagez |
|
|
|
|
|
La prévention des intoxications avec Macif Préventon
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, (+ d'infos...)
La prévention des intoxications avec Macif Préventon </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 = 27427arefIdy=1546
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
15/07/2014 à 13:50 |
Partagez |
|
|
|
|
|
|
Comment utiliser le baby phone ? avec Familles Rurales
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, (+ d'infos...)
Comment utiliser le baby phone ? avec Familles Rurales </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 = 27421arefIdy=1543
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
10/07/2014 à 13:50 |
Partagez |
|
|
|
|
|
Faut-il se méfier des jouets électroniques pour les tout-petits ? avec Familles Rurales </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 = 27420arefIdy=1542
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
09/07/2014 à 13:50 |
Partagez |
|
|
|
|
|
|
Un droit de rétractation en toutes circonstances avec le CNAFAL </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 = 27419arefIdy=1541
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
08/07/2014 à 13:50 |
Partagez |
|
|
|
|
|
Utiliser son téléphone à l'étranger avec la CLCV
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, cdc_ref_idy, (+ d'infos...)
Utiliser son téléphone à l'étranger avec la CLCV </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 = 27407arefIdy=1539
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
30/06/2014 à 13:50 |
Partagez |
|
|
|
|
|
|
La viande dans l'alimentation avec l'Adeic
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, cdc_ref_idy, (+ d'infos...)
La viande dans l'alimentation avec l'Adeic </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 = 27406arefIdy=1538
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
20/06/2014 à 13:50 |
Partagez |
|
|
|
|
|
Comment repérer le sel et le sucre avec l'ADEIC
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, cdc_ref_idy, (+ d'infos...)
Comment repérer le sel et le sucre avec l'ADEIC </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 = 27405arefIdy=1537
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
19/06/2014 à 13:50 |
Partagez |
|
|
|
|
|
|
Les différences entre intolérance et allergies alimentaires avec l'ADEIC </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 = 27404arefIdy=1536
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
18/06/2014 à 13:50 |
Partagez |
|
|
|
|
|
Les aides pour des travaux de rénovation énergétique en copropriété avec le ministère chargé de l'Ecologie et le ministère chargé du Logement </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 = 27401arefIdy=1533
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
13/06/2014 à 13:50 |
Partagez |
|
|
|
|
|
|
Optimiser les aides financières lors de travaux de rénovation énergétique avec le ministère chargé de l'Ecologie et le ministère chargé du Logement </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 = 27398arefIdy=1531
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
11/06/2014 à 13:50 |
Partagez |
|
|
|
|
|
Entreprendre des travaux quand on se trouve en précarité énergétique Entreprendre des travaux quand on se trouve en précarité énergétique </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 = 27397arefIdy=1530
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
10/06/2014 à 13:50 |
Partagez |
|
|
|
|
|
|
Les bénéfices d'un logement rénové et les aides proposées avecministère chargé de l'Ecologie et le ministère chargé du Logement </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 = 27396arefIdy=1529
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
09/06/2014 à 13:50 |
Partagez |
|
|
|
|
|
Eloigner les maladies et les ravageurs avec l'Office national de l'eau et des milieux aquatiques </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 = 27388arefIdy=1527
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
22/05/2014 à 13:50 |
Partagez |
|
|
|
|
|
|
Eviter les mauvaises herbes avec l'Office national de l'eau et des milieux aquatiques </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 = 27387arefIdy=1526
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
21/05/2014 à 13:50 |
Partagez |
|
|
|
|
|
Jardiner nature, jardiner sans pesticides avec l'Office national de l'eau et des milieux aquatiques </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 = 27384arefIdy=1523
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
19/05/2014 à 13:50 |
Partagez |
|
|
|
|
|
|
Bien organiser son jardin avec l'Office national de l'eau et des milieux aquatiques </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 = 27385arefIdy=1524
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
19/05/2014 à 13:50 |
Partagez |
|
|
|
|
|
Acheter un voyage en ligne avec la CSF
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, cdc_ref_idy, cdc_titre, (+ d'infos...)
Acheter un voyage en ligne avec la CSF </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 = 27369arefIdy=1522
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
09/05/2014 à 13:50 |
Partagez |
|
|
|
|
|
|