Array
(
[rows] => 527
[query] => SELECT SQL_CALC_FOUND_ROWS hotel.id AS id, hotel.name AS name, hotel.stars AS stars, hotel.`show` AS `show`, (SELECT name FROM #__ct_locations WHERE id = hotel.country) AS cname, (SELECT name FROM #__ct_locations WHERE id = hotel.city) AS rname, (SELECT name FROM #__ct_locations WHERE id = hotel.district) AS dname, (SELECT address FROM #__ct_addresses WHERE parent = hotel.id AND parent_type = "hotel" AND type = 2) AS address, (SELECT path FROM #__ct_photos WHERE parent = hotel.id AND parent_type = "hotel" AND type = 1) AS mini_img, MIN(prices.price) AS min_price, prices.currency AS currency, prices.`from` AS price_from, prices.`to` AS price_to, room.name AS price_room FROM #__ct_hotels AS hotel, #__ct_rooms AS room, (SELECT parent, price, currency, `from`, `to` FROM #__ct_prices WHERE assortment = 3 AND `to` >= "2012-05-22") AS prices WHERE (prices.parent = room.id AND room.hotel = hotel.id) AND hotel.country = 1 GROUP BY hotel.id ORDER BY name ASC LIMIT 0, 5
)
