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.*, LOWER(CONVERT(log_title USING utf8mb4)), LOWER(CONVERT(log_params USING utf8mb4)) from logging 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 upper('NARESH%G%G') -- AND UPPER(CONVERT(log_title USING utf8mb4)) like upper('%%') -- AND UPPER(CONVERT(log_title USING utf8mb4)) like '%%' -- and log_timestamp > 20210801000000 and log_timestamp between 20200801000000 and 20221030000000 -- 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...