SELECT gArea, country, area, hotel, stars, room, roomId, meal, CAST(GROUP_CONCAT(price,":",meal SEPARATOR ",") AS CHAR) AS priceFROM 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.mealsIdWHERE 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 roomIdORDER BY BINARY hotel, BINARY roomLIMIT 9999