Line 178... |
Line 178... |
178 |
$champs = array('dob.id_observation as id_observation', 'nom_ret', 'nom_ret_nn', 'nt', 'famille', 'ce_zone_geo', 'zone_geo',
|
178 |
$champs = array('dob.id_observation as id_observation', 'nom_ret', 'nom_ret_nn', 'nt', 'famille', 'ce_zone_geo', 'zone_geo',
|
179 |
'lieudit', 'station', 'milieu', 'date_observation', 'dob.mots_cles_texte as mots_cles_texte', 'dob.commentaire as commentaire',
|
179 |
'lieudit', 'station', 'milieu', 'date_observation', 'dob.mots_cles_texte as mots_cles_texte', 'dob.commentaire as commentaire',
|
180 |
'di.mots_cles_texte as mots_cles_texte_image ', 'date_transmission', 'di.id_image as id_image', 'di.ce_utilisateur as ce_utilisateur',
|
180 |
'di.mots_cles_texte as mots_cles_texte_image ', 'date_transmission', 'di.id_image as id_image', 'di.ce_utilisateur as ce_utilisateur',
|
181 |
'prenom', 'nom', 'courriel', 'nom_original');
|
181 |
'prenom', 'nom', 'courriel', 'nom_original');
|
Line 182... |
Line 182... |
182 |
|
182 |
|
183 |
$requeteLiaisons = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS '.implode(', ',$champs).', '.
|
183 |
$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS '.implode(', ',$champs).', '.
|
184 |
'AVG(dvote.valeur) as moyenne_votes '.
|
184 |
'AVG(dvote.valeur) as moyenne_votes '.
|
185 |
'FROM '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
|
185 |
'FROM '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
|
186 |
'INNER JOIN del_image di '.
|
186 |
'INNER JOIN del_image di '.
|
187 |
'ON doi.id_image = di.id_image '.
|
187 |
'ON doi.id_image = di.id_image '.
|