| Query: | SELECT COUNT(`T1`.`locaton`) AS `Number` , `T1`.`locaton` FROM `fl_listings` AS `T1` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` WHERE `T1`.`Status` = 'active' AND `T1`.`Sub_status` <> 'invisible' AND `T3`.`Type` = 'listings' AND `T1`.`locaton` <> '' AND `T1`.`locaton` <> '0' AND `T1`.`sale_rent` = '2' AND `T1`.`persone` = 'Piscina privata' AND `T1`.`camere_letto_testo` = '9 Camere da letto' AND ((`T1`.`Category_ID` = 18 OR FIND_IN_SET(18, `T3`.`Parent_IDs`) > 0) OR (FIND_IN_SET(18, `T1`.`Crossed`) > 0)) GROUP BY `T1`.`locaton` HAVING COUNT(`T1`.`locaton`) > 0 ORDER BY `Number` DESC |
