| Query: | SELECT `T1`.`ID`, `T2`.`ID` AS `Field_ID`, `T1`.`Items`, `T1`.`Item_names`, `T1`.`Items_display_limit`, `T1`.`Mode`, `T2`.`Key`, `T2`.`Type`, `T2`.`Condition`, `T2`.`Values`, CONCAT('listing_fields+name+', `T2`.`Key`) AS `pName`, `T1`.`No_index`, `T1`.`Data_in_title`, `T1`.`Data_in_description`, `T1`.`Data_in_H1` FROM `fl_category_filter_field` AS `T1` LEFT JOIN `fl_listing_fields` AS `T2` ON `T2`.`ID` = `T1`.`Field_ID` WHERE `T1`.`Box_ID` = 20 AND `T1`.`Status` = 'active' AND `T2`.`Status` = 'active' ORDER BY `T1`.`ID` |