SELECT
	gArea,
	country,
	area,
	hotel,
	stars,
	room,
	roomId,
	meal,
	CAST(GROUP_CONCAT(price,":",meal SEPARATOR ",") AS CHAR) AS price
FROM
	globalArea ga
	INNER JOIN countries c ON ga.id = c.gAreaId
	INNER JOIN areas a ON c.id = a.countryId
	INNER JOIN hotels h ON a.id = h.areaId
	INNER JOIN rooms r ON h.id = r.hotelId
	INNER JOIN prices p ON r.id = p.roomId
	INNER JOIN meals m ON m.id = p.mealsId
WHERE
	ga.ok=1
	AND c.ok = 1
	AND a.ok = 1
	AND h.ok = 1
	AND r.ok = 1
	AND p.ok = 1
	AND m.ok = 1
	AND a.id = 1
	AND p.people = 1
	AND fromDate <= "2006-09-29"
	AND upToDate >= "2006-09-29"
GROUP BY roomId
ORDER BY
	BINARY hotel,
	BINARY room
LIMIT 9999