UN PARSEUR DE SQL (LISTER LES CHAMPS PRESENTS, ET PLUS SI AFFINITES)

try{
		$s=new SqlExpr('
	SELECT
		clients.id, clients.nom, clients.prenom,
		clients.type AS typeclient,			/*Homme Femme, Enfant*/
		clients.civilite,				/*Madamme Mademoiselle Monsieur*/
		clients.date_de_naissance,
		clients.tranche_age,
		clients.adresse,
		clients.tel,
		clients.actif,					/*oui non */
		ville.nom AS nomville,
		ville.code_postal,
		collaborateur.nom AS collaborateur_nom,
		collaborateur.prenom AS collaborateur_prenom,
		collaborateur.pseudo AS collaborateur_pseudo,
		(
			SELECT COUNT(*)
			FROM passage_liste
			WHERE passage_liste.id_client=clients.id
		) AS nbr_passages,
		(
			SELECT MAX(date_de_passage)
			FROM passage_liste
			WHERE passage_liste.id_client=clients.id
		) AS derniere_visite,
		(
			SELECT prestations.nom
			FROM passage_liste LEFT JOIN
				(passage_prestation LEFT JOIN prestations
					ON prestations.id=passage_prestation.id_prestation)
				ON passage_prestation.id_passage=passage_liste.id
			WHERE passage_liste.id_client=clients.id
			GROUP BY passage_prestation.id_prestation
			ORDER BY COUNT(*)
			LIMIT 1
		) AS prestation_best
	FROM
		(clients LEFT JOIN ville ON clients.id_ville=ville.id)
			LEFT JOIN collaborateur ON id_collaborateur_prefere=collaborateur.id
');
	echo '<ul>';
	foreach ($s->SELECT as $l)
		echo '<li>'.$s->notableorbase($l[1]).'</li>';
	echo '</ul>';
}catch (Exception $e){
	echo $e;
}