| Query: | SELECT `T1`.`Group_ID`, `T1`.`ID`, `T1`.`Category_ID`, `T2`.`Key`, `T1`.`Fields`, `T2`.`Display`, CONCAT('listing_groups+name+', `T2`.`Key`) AS `pName`, `T2`.`ID` AS `Group` FROM `fl4_listing_relations` AS `T1` LEFT JOIN `fl4_listing_groups` AS `T2` ON `T1`.`Group_ID` = `T2`.`ID` WHERE `T1`.`Category_ID` = '198' AND (`T1`.`Group_ID` = '' OR `T2`.`Status` = 'active') ORDER BY `T1`.`Position` |