<cfscript>
	hql1 = "
			SELECT NEW MAP(
				h.id AS ID,
				m.id AS MUSICID,
				m.name AS NAME,
				(
					SELECT COUNT( hyundai )
					from hyundai h
					WHERE exists (
						SELECT  h.id AS id,
								m.id AS musicID,
								m.name AS name
						FROM hyundai h
						JOIN h.music m
					)
				) AS total
			)
			FROM hyundai h
			JOIN h.music m
	";

	results = ormExecuteQuery(hql1,{},{ maxResults = 4, offset = 0 });
	writeDump(results);
</cfscript>