-- Connection Id: 1220
-- User: mindbox
-- Host: localhost
-- DB: mindbox
-- Command: Query
-- Time: 367
-- State: Copying to tmp table
/*NO_SELECT_FOUND_ROWS*/
                SELECT
                    SQL_CALC_FOUND_ROWS
                    h.id,
                    h.logger,
                    h.level,
                    h.date,
                    h.message,
                    h.initiator,
                    h.occasionsID,
                    count(t.repeated) AS subsequentOccasions,
                    t.rep,
                    t.repeated,
                    t.occasionsIDType,
                    c1.value AS context_message_key

                FROM wp_simple_history AS h

                LEFT OUTER JOIN wp_simple_history_contexts AS c1 ON (c1.history_id = h.id AND c1.key = "_message_key")

                INNER JOIN (
                    SELECT
                        id,
                        IF(@a=occasionsID,@counter:=@counter+1,@counter:=1) AS rep,
                        IF(@counter=1,@groupby:=@groupby+1,@groupby) AS repeated,
                        @a:=occasionsID occasionsIDType
                    FROM wp_simple_history AS h2

                    # First/inner where
                    WHERE
                        1 = 1 AND logger IN ("SimpleCommentsLogger", "SimpleCoreUpdatesLogger", "SimpleExportLogger", "SimpleLegacyLogger", "SimpleLogger", "SimpleMediaLogger", "SimpleMenuLogger", "SimpleOptionsLogger", "SimplePluginLogger", "SimplePostLogger", "SimpleThemeLogger", "SimpleUserLogger", "SimpleCategoriesLogger", "AvailableUpdatesLogger", "FileEditsLogger", "SH_Privacy_Logger", "SH_Translations_Logger", "SH_Jetpack_Logger", "PluginUserSwitchingLogger", "PluginEnableMediaReplaceLogger", "Plugin_UltimateMembers_Logger", "Plugin_LimitLoginAttempts", "Plugin_Redirection", "Plugin_DuplicatePost", "Plugin_ACF")
 AND date >= "2018-11-16 00:00:00"

                    ORDER BY id DESC, date DESC
                ) AS t ON t.id = h.id

                WHERE
                    # AND DATE >= DATE(NOW()) - INTERVAL 7 DAY
                    # Outer/Second where
                    1 = 1

                GROUP BY repeated
                ORDER BY id DESC, date DESC
                LIMIT 0, 1