| 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 location automobilie avec option d'achat avec la 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 = 27833arefIdy=1650
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 10/02/2015 à 13:50 |
|
Partagez |
  |
|
|
|
|
|
L'action de groupe, les démarches avec la CNL
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, cdc_ref_idy, (+ d'infos...)
L'action de groupe, les démarches avec la CNL </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 = 27809arefIdy=1632
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 26/01/2015 à 13:50 |
|
Partagez |
|
|
|
|
|
|
|
Honoraires des agents immobiliers, ce qui change pour la location 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 = 27808arefIdy=1631
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 23/01/2015 à 13:50 |
|
Partagez |
|
|
|
|
|
|
Agences de voyages, les obligations d'information et de conseil avec la Fnaut </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 = 27804arefIdy=1628
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 20/01/2015 à 13:50 |
|
Partagez |
|
|
|
|
|
|
|
Electricité, gaz naturel : du nouveau en matière de paiement avec l'INDECOSA-CGT </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 = 27802arefIdy=1627
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 19/01/2015 à 13:50 |
|
Partagez |
|
|
|
|
|
|
Sprays et désodorisants naturels avec Que-Choisir
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, cdc_ref_idy, (+ d'infos...)
Sprays et désodorisants naturels avec Que-Choisir </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 = 27801arefIdy=1626
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 16/01/2015 à 13:50 |
|
Partagez |
|
|
|
|
|
|
|
La généralisation du tiers-payants avec l'Unaf
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, cdc_ref_idy, (+ d'infos...)
La généralisation du tiers-payants avec l'Unaf </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 = 27795arefIdy=1620
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 15/01/2015 à 13:50 |
|
Partagez |
|
|
|
|
|
|
Les diagnostics immobiliers obligatoires lors de la location avec l'INC </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 = 27731arefIdy=1597
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 30/12/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
|
Les frais bancaires pour incident avec la CLCV
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, cdc_ref_idy, (+ d'infos...)
Les frais bancaires pour incident 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 = 27730arefIdy=1596
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 29/12/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
La résiliation des contrats de télévision avec l'AFOC
</TD></TR></TABLE><B>Database error:</B> Invalid SQL: SELECT cdc_idy, (+ d'infos...)
La résiliation des contrats de télévision avec l'AFOC </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 = 27728arefIdy=1595
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 26/12/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
|
Tourisme équitable et solidaire : voyager autrement avec l'INC </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 = 27724arefIdy=1591
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 22/12/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
Le trading sur Internet avec l'Autorité des marchés financiers </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 = 27711arefIdy=1587
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 27/11/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
|
Les frais des placements financiers avec l'Autorité des marchés financiers </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 = 27709arefIdy=1586
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 26/11/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
Comment se préparer financièrement pour la retraite ? avec l'Autorité des marchés financiers </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 = 27707arefIdy=1585
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 25/11/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
|
Comment constituer une épargne salariable ? avec l'Autorité des marchés financiers </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 = 27706arefIdy=1584
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 24/11/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
L'armoire à pharmacie avec l'ordre national des pharmaciens </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 = 27704arefIdy=1582
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 20/11/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
|
La contrefaçon des médicaments avec l'ordre national des pharmaciens </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 = 27695arefIdy=1581
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 19/11/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
De nouveaux droits pour les voyageurs en train avec Familles de France </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 = 27690arefIdy=1578
AND cdc_ref_idy =
AND cdc_ctd_idy = ctd.ctd_idy
AND cdc_statut = '1'<BR>
<B>PostgreSQL ...
|
| 13/11/2014 à 13:50 |
|
Partagez |
|
|
|
|
|
|
