Subversion Repositories eFlore/Applications.del

Rev

Rev 787 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 787 Rev 820
Line 124... Line 124...
124
		$requeteLiaisons = 'SELECT * '.
124
		$requeteLiaisons = 'SELECT * '.
125
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
125
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
126
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
126
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
127
						   'ON doi.id_observation = dob.id_observation '.
127
						   'ON doi.id_observation = dob.id_observation '.
128
						   'INNER JOIN del_utilisateur du '.
128
						   'INNER JOIN del_utilisateur du '.
129
						   'ON du.id_utilisateur = doi.id_utilisateur '.
129
						   'ON du.id_utilisateur = dob.ce_utilisateur '.
130
						   'WHERE doi.id_observation = '.$this->id_observation;
130
						   'WHERE doi.id_observation = '.$this->id_observation;
131
		$requeteLiaisons .=  ' GROUP BY doi.id_observation';
131
		$requeteLiaisons .=  ' GROUP BY doi.id_observation';
132
		$requeteLiaisons .= ' ORDER BY date_transmission DESC ';
132
		$requeteLiaisons .= ' ORDER BY date_transmission DESC ';
133
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
133
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();