SELECT agenda21france.lcl_questionnaire_carto.id_questionnaire_x_user AS questionnaire_id,
agenda21france.lcl_questionnaire_carto.type_questionnaire,
agenda21france.lcl_questionnaire_carto_x_type.type_id AS conf_id,
agenda21france.lcl_questionnaire_carto_x_type.type_id AS conf_id_2,
agenda21france.lcl_questionnaire_carto_x_type.libel AS libelle,
agenda21france.lcl_questionnaire_carto_x_type.libel AS libelle2,
agenda21france.lcl_questionnaire_carto.lng,
agenda21france.lcl_questionnaire_carto.lat,
agenda21france.lcl_questionnaire_carto.nom AS societe,
agenda21france.lcl_questionnaire_carto.cp,
UPPER(agenda21france.lcl_questionnaire_carto.ville) AS ville,
agenda21france.lcl_questionnaire_carto.adresse,
agenda21france.lcl_questionnaire_carto.dept,
agenda21france.lcl_questionnaire_carto.complement
FROM
agenda21france.lcl_questionnaire_carto
LEFT JOIN agenda21france.lcl_questionnaire_type_x_user ON (agenda21france.lcl_questionnaire_carto.id_questionnaire_x_user = agenda21france.lcl_questionnaire_type_x_user.id)
LEFT JOIN agenda21france.lcl_questionnaire_carto_x_type ON (agenda21france.lcl_questionnaire_carto_x_type.questionnaire_id = agenda21france.lcl_questionnaire_type_x_user.id)
WHERE
agenda21france.lcl_questionnaire_carto.type_questionnaire = '1'
AND agenda21france.lcl_questionnaire_carto.lat != ''
AND agenda21france.lcl_questionnaire_carto.lng != ''
AND agenda21france.lcl_questionnaire_type_x_user.status = '1'
AND agenda21france.lcl_questionnaire_carto.id_questionnaire_x_user ='663'
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /opt/dataspe/domains/agenda21france.org/gui/www/cache/agenda-21-de-territoire/cartographie/lib/lcl-cartographie.lib.php on line 882