<?php $sql = "SELECT r.id AS room_id, r.name AS room_name, p.id AS property_id, p.name AS
property_name, c.name AS city, region.name AS region, p.standard, rg.file, MIN(rp.price) AS min_price, GROUP_CONCAT(DISTINCT CONCAT(a.name, '*', a.icon) ORDER BY a.name SEPARATOR '|') AS attractions FROM room r LEFT JOIN property p ON r.property_id=p.id LEFT
JOIN room_gallery rg ON rg.room_id=r.id LEFT JOIN room_price rp ON rp.room_id=r.
id LEFT JOIN region ON p.region_id=region.id LEFT JOIN city c ON p.city_id=c.id L
EFT JOIN property_attraction pa ON p.id=pa.property_id LEFT OUTER JOIN attraction
a ON pa.attraction_id=a.id AND (a.is_active=1 OR a.is_active IS NULL) GROUP BY room_id;"; ?>
Czy jest możliwe zamienienie tego w Criteria dla Propela?