Avis de publicité de Marchés publics
Erreur de Base de données:
[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10061)
SELECT this.`_oid` AS this,
this_k_1.result1 AS this_k_1_1,
this.marketObject AS this_p_marketObject,
this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name,
this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation,
this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM
FROM (ocsPbm_callForTenders AS this
INNER JOIN (ocs_card AS this_z
LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog
On ((this_z.ocsCatalog = this_z_s_ocsCatalog.`_oid`) AND (this_z_s_ocsCatalog.iso_sid <> '')))
On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')))
LEFT JOIN (SELECT
c0.`_oid` AS origin,
COUNT(DISTINCT this.`_oid`) AS result1
FROM xrm_category AS this
INNER JOIN ((ocsPbm_callForTenders AS c0
INNER JOIN ocs_card_ocsVisibility AS c0_l
On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')))
INNER JOIN ocs_card AS c0_z
On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> '')))
On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> ''))
WHERE
(this.iso_sid <> '')
AND (this.`_oid` IN (-1))
GROUP BY
c0.`_oid`) AS this_k_1
On (this.`_oid` = this_k_1.origin)
WHERE
(this.iso_sid <> '')
AND (IF((this_z_s_ocsCatalog.useValidation = 1),this_z.ocsStatus,IF(((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)),this_z.ocsStatus,0)) = 2)
AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0)))
AND (this_z_s_ocsCatalog.name = 'marches_publics')
Aucune avis de publicité actuellement.
