Query: | SELECT `T1`.*, IF(`T2`.`Status` = 'active', 1, 0) AS `Advanced_search_availability` FROM `fl_listing_types` AS `T1` LEFT JOIN `fl_search_forms` AS `T2` ON `T1`.`Key` = `T2`.`Type` AND `T2`.`Mode` = 'advanced' WHERE `T1`.`Status` = 'active' ORDER BY `Order` |