$sql = '
            SELECT
				l.iduser,
				u.firstname,
				u.lastname ,
				l.type_log as typeLog,
				COUNT(l.type_log) as countLog
             FROM
                logs l
             INNER JOIN
                users u ON u.iduser = l.iduser
                    AND u.iduser_delete is null
                    AND u.type != \'sadmin\'
                    AND u.type != \'dev\'
                    AND u.`is_yoomap` is null
                    AND u.no_logs <> 1
            LEFT JOIN
                relations r ON r.idrecord_destination = u.iduser
                    AND r.`iduser_delete` is null
            LEFT JOIN
                datas d ON d.`iddata` = l.`idrecord`
                    AND l.`type_record` = \'data\'
                    AND d.`iduser_delete` is null
            LEFT JOIN datas_types dt1 ON dt1.iddata_type = d.`iddata_type`
            		' . $sqlAdd1 . '
                    AND dt1.`iduser_delete` is null
            LEFT JOIN
                discussions dis ON dis.iddiscussion = l.idrecord
                    AND l.type_record = \'discussion\'
                    AND dis.type_record = \'data\'
                    AND dis.`iduser_delete` is null
            LEFT JOIN
                datas ds ON dis.idrecord = ds.iddata
                	AND ds.`iduser_delete` is null
            LEFT JOIN datas_types dt2 ON dt2.iddata_type = ds.`iddata_type`
            		' . $sqlAdd2 . '
                    AND dt2.`iduser_delete` is null
             WHERE
                l.type_log IN (\'login\', \'consult-data\', \'create-discussion\', \'post-comment\', \'create-data\', \'update-data\', \'like-discussion\')
               AND
                    CASE WHEN
                        l.`type_log` in (\'consult-data\', \'create-data\', \'update-data\', \'like-data\', \'like-discussion\')
                    THEN
                        dt1.`iddata_type` IS NOT NULL
                    ELSE
                        CASE WHEN
                            l.`type_log` in (\'create-discussion\', \'post-comment\')
                        THEN
                            dt2.`iddata_type` IS NOT NULL
                        ELSE
                            d.iddata is null AND ds.iddata is null
                        END
                    END
                AND
                    r.record_source = \'group\'
                AND
                    r.idrecord_source != 6
             GROUP BY
                    l.iduser, u.firstname, u.lastname, l.type_log
             ORDER BY
                    l.iduser ASC;';