Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Njd-de
.
Toggle Highlighting
SQL
-- SET @page = '%OGBODSPORT%'; Select logging_userindex.*, actor.*, LOWER(CONVERT(log_title USING utf8mb4)), LOWER(CONVERT(log_params USING utf8mb4)) from logging_userindex left join actor on log_actor = actor_id where 1=1 -- and log_type = 'move' -- and log_title like '%Amir%Arsalan%' -- and LOWER(CONVERT(log_title USING utf8mb4)) like '%amir%arsalan%' /* and ( LOWER(CONVERT(log_title USING utf8mb4)) like '%amir%arsalan%' or LOWER(CONVERT(log_title USING utf8mb4)) like '%arsalan%arman%' or LOWER(CONVERT(log_params USING utf8mb4)) like '%amir%arsalan%' or LOWER(CONVERT(log_params USING utf8mb4)) like '%arsalan%arman%' ) */ -- AND UPPER(CONVERT(log_title USING utf8mb4)) like upper(@page) -- AND UPPER(CONVERT(log_title USING utf8mb4)) like upper('%Humayuni%') /** AND ( ( UPPER(CONVERT(log_title USING utf8mb4)) like upper('%Mojo%') AND UPPER(CONVERT(log_title USING utf8mb4)) like upper('%Mona%')) OR UPPER(CONVERT(log_title USING utf8mb4)) like upper('%112725347%') ) **/ -- AND UPPER(CONVERT(log_title USING utf8mb4)) like '%%' and actor_name = 'Sandysoil719' and log_timestamp > 20220101000000 -- and log_type not in ('newusers', 'thanks') -- and log_page = 4286796 order by log_timestamp desc limit 1000
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
.
Checking query status...