| Query: | SELECT COUNT(`T1`.`heating`) AS `Number` , `T1`.`heating` FROM `fl_listings` AS `T1` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` WHERE `T1`.`Status` = 'active' AND `T3`.`Type` = 'listings' AND `T1`.`heating` <> '' AND `T1`.`heating` <> '0' AND `T1`.`persone` = '2 Persone' AND `T1`.`camere_letto_testo` = '1 Camera da letto' AND `T1`.`locaton` = 'Cruz del Roque, Fasnia' AND `T1`.`booking_module` = '1' GROUP BY `T1`.`heating` HAVING COUNT(`T1`.`heating`) > 0 ORDER BY `Number` DESC |
