SELECT s.*, GROUP_CONCAT(DISTINCT a.type_id) AS types FROM systems AS s LEFT JOIN systems_actions AS a ON(a.system_id = s.id) WHERE s.lang_id = 'ru' AND s.`logo_lg` != '' AND s.`url` = 'lpgenerator' AND a.`status_id` = '1' GROUP BY s.id