testing query - Quarry

This query is marked as a draft This query has been published by Chlod.
SQL

select `log_id`,
       `log_timestamp`,
       `log_params`,
       (SELECT GROUP_CONCAT(ctd_name SEPARATOR ",")
        FROM change_tag
                 JOIN change_tag_def ON ctd_id = ct_tag_id
        WHERE ct_log_id = log_id) as ts_tags,
       `actor_id`,
       `actor_name`,
       `comment_id`,
       `comment_text`
from `logging_userindex`
         left join `actor_logging` on `log_actor` = `actor_id`
         left join `comment_logging` on `log_comment_id` = `comment_id`
where `log_type` = 'delete'
  and `log_action` = 'revision'
  and ((`log_timestamp` > 20230726125552 and `log_timestamp` < 20230726125562 and
        `log_params` LIKE "%i:1167221635;%") or
       (`log_timestamp` > 20230726124652 and `log_timestamp` < 20230726124662 and
        `log_params` LIKE "%i:1167220741;%") or
       (`log_timestamp` > 20220809083036 and `log_timestamp` < 20220809083046 and
        `log_params` LIKE "%i:1103344157;%") or
       (`log_timestamp` > 20220313150017 and `log_timestamp` < 20220313150027 and
        `log_params` LIKE "%i:1076902948;%") or
       (`log_timestamp` > 20210828113020 and `log_timestamp` < 20210828113030 and
        `log_params` LIKE "%i:1041071946;%") or
       (`log_timestamp` > 20210828112995 and `log_timestamp` < 20210828113005 and
        `log_params` LIKE "%i:1041071907;%") or
       (`log_timestamp` > 20210828112922 and `log_timestamp` < 20210828112932 and
        `log_params` LIKE "%i:1041071853;%") or
       (`log_timestamp` > 20210828112741 and `log_timestamp` < 20210828112751 and
        `log_params` LIKE "%i:1041071692;%") or
       (`log_timestamp` > 20210828112195 and `log_timestamp` < 20210828112205 and
        `log_params` LIKE "%i:1041071135;%") or
       (`log_timestamp` > 20210523074413 and `log_timestamp` < 20210523074423 and
        `log_params` LIKE "%i:1024625643;%") or
       (`log_timestamp` > 20210523074234 and `log_timestamp` < 20210523074244 and
        `log_params` LIKE "%i:1024625432;%") or
       (`log_timestamp` > 20210518164300 and `log_timestamp` < 20210518164310 and
        `log_params` LIKE "%i:1023837176;%") or
       (`log_timestamp` > 20210518162841 and `log_timestamp` < 20210518162851 and
        `log_params` LIKE "%i:1023835014;%") or
       (`log_timestamp` > 20210518160795 and `log_timestamp` < 20210518160805 and
        `log_params` LIKE "%i:1023832025;%") or
       (`log_timestamp` > 20210518153842 and `log_timestamp` < 20210518153852 and
        `log_params` LIKE "%i:1023827732;%") or
       (`log_timestamp` > 20210518153748 and `log_timestamp` < 20210518153758 and
        `log_params` LIKE "%i:1023827584;%") or
       (`log_timestamp` > 20210518153229 and `log_timestamp` < 20210518153239 and
        `log_params` LIKE "%i:1023826800;%") or
       (`log_timestamp` > 20210518114011 and `log_timestamp` < 20210518114021 and
        `log_params` LIKE "%i:1023795690;%") or
       (`log_timestamp` > 20210518044454 and `log_timestamp` < 20210518044464 and
        `log_params` LIKE "%i:1023756202;%") or
       (`log_timestamp` > 20210518044049 and `log_timestamp` < 20210518044059 and
        `log_params` LIKE "%i:1023755849;%") or
       (`log_timestamp` > 20210518020911 and `log_timestamp` < 20210518020921 and
        `log_params` LIKE "%i:1023738347;%") or
       (`log_timestamp` > 20210505005719 and `log_timestamp` < 20210505005729 and
        `log_params` LIKE "%i:1021493684;%") or
       (`log_timestamp` > 20210426030700 and `log_timestamp` < 20210426030710 and
        `log_params` LIKE "%i:1019908208;%") or
       (`log_timestamp` > 20210426030401 and `log_timestamp` < 20210426030411 and
        `log_params` LIKE "%i:1019907825;%") or
       (`log_timestamp` > 20210426030205 and `log_timestamp` < 20210426030215 and `log_params` LIKE "%i:1019907658;%"))
order by `log_timestamp` asc
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
