QueryBuilder

SELECT u.*, tu.nom as unite_nom, tu.type as unite_type FROM `unites` u
	LEFT JOIN `types_unites` tu ON u.unite_id = tu.id
	WHERE residence_id = 
	ORDER BY tu.ordre;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY tu.ordre' at line 4

QueryBuilder

SELECT
			(SELECT count( * ) FROM proximite WHERE residence = ) as proximiteCount,
			(SELECT count( * ) FROM unites WHERE residence_id = ) as unitesCount,
			(SELECT count( * ) FROM emplois INNER JOIN emplois_temp ON emplois_temp.emploi=emplois.id LEFT JOIN residences ON emplois_temp.residence = residences.id WHERE affiche=1 AND possibilite=0 AND emplois_temp.residence= AND residences.emplois_masques = 0 AND emplois.approuve=1 AND emplois.confidentiel=0 AND emplois.datePublication <= NOW() AND emplois.pasDeResidence = '0') as emploisDisponiblesCount,
			(SELECT count( * ) FROM emplois INNER JOIN emplois_temp ON emplois_temp.emploi=emplois.id LEFT JOIN residences ON emplois_temp.residence = residences.id WHERE affiche=1 AND possibilite=1 AND emplois_temp.residence= AND residences.emplois_masques = 0 AND emplois.approuve=1 AND emplois.confidentiel=0 AND emplois.datePublication <= NOW() AND emplois.pasDeResidence = '0') as emploisPossibilitesCount,
			(SELECT count( * ) from activites WHERE approuve = '1' AND aff_local = '1' AND residence_id = ) as activitesCount
		

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') as proximiteCount, (SELECT count( * ) FROM unites WHERE residence_id = ) a' at line 2

QueryBuilder

	SELECT et.id,e.titre,e.sommaire,e.datePublication,e.dateFin,e.salaire,e.categorie,e.type,e.id AS emploi_id, GROUP_CONCAT(DISTINCT qt.nom) as quarts FROM emplois_temp et

						LEFT JOIN emplois e ON et.emploi = e.id 
						LEFT JOIN residences r ON et.residence = r.id 
						LEFT JOIN emplois_quarts eq ON eq.emploi = e.id 
						LEFT JOIN quarts_travail qt ON qt.id = eq.quart

						WHERE e.affiche=1 
						AND r.emplois_masques = 0 
						AND e.possibilite=0 
						AND et.residence= 
						AND e.desapprouve=0 
						AND e.confidentiel=0 
						AND e.pasDeResidence = '0'

						GROUP BY e.id

						ORDER BY datePublication DESC
					

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND e.desapprouve=0 AND e.confidentiel=0 AND e.pasDeResidence = ' at line 12

QueryBuilder

SELECT et.id,e.titre,e.sommaire,e.datePublication,e.dateFin,e.salaire,e.categorie,e.type,e.id AS emploi_id FROM emplois_temp et

									LEFT JOIN emplois e ON et.emploi = e.id 
									LEFT JOIN residences r ON et.residence = r.id 

									WHERE e.affiche=1 
									AND r.emplois_masques = 0 
									AND e.possibilite=1 
									AND et.residence= 
									AND e.desapprouve=0 
									AND e.confidentiel=0 
									AND e.pasDeResidence = '0'

									ORDER BY datePublication DESC
								

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND e.desapprouve=0 AND e.confidentiel=0 AND e.pasDeReside' at line 10