USE trwiki_p;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
7 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
7 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
7 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
7 years ago |
USE trwiki_p;
SET @N = 5;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
7 years ago |
USE trwiki_p;
SET @N = 5;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
7 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
7 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
7 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
select *, SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
#SHOW TABLES ;
DESCRIBE flaggedimages;
DESCRIBE... |
8 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE math;
Describe archive; |
8 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE math, archive; |
8 years ago |
USE trwiki_p;
SHOW TABLES ;
|
8 years ago |
USE trwiki_p;
(SHOW TABLES ) as tablolar;
|
8 years ago |
USE trwiki_p;
SELECT * FROM (SHOW TABLES ) as tablolar;
|
8 years ago |
USE trwiki_p;
SELECT * FROM SHOW TABLES ;
|
8 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE *; |
8 years ago |
USE trwiki_p;
SHOW TABLES ;
DESCRIBE fla* |
8 years ago |
USE trwiki_p;
SHOW TABLES ;
|
8 years ago |
USE trwiki_p;
DESCRibe ;
|
8 years ago |
SHOW TABLES FROM trwiki_p;
DESCRIBE trwiki_p |
8 years ago |
SHOW TABLES FROM trwiki_p; |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
left join... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
left join... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
left join... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
left join... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
WHERE fr_tags... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
WHERE fr_tags... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
WHERE fr_tags... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
WHERE fr_tags... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
LIMIT 100
; |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
join page on... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
join page on... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
join page on... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
join page on... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
join page on... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *
FROM flaggedrevs
LIMIT 10
; |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_address, page_title,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_address, page_title,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_id, ipb_address, page_title,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_id, user_name, page_title,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_id, user_name, page_title,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_id, fr_user, page_title,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_id, page_title, fr_page_id,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *#ipb_id, page_title, fr_page_id,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *#ipb_id, page_title, fr_page_id,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *#ipb_id, page_title, fr_page_id,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *#ipb_id, page_title, fr_page_id,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT *#ipb_id, page_title, fr_page_id,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_id, page_title, fr_page_id,... |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs;
SELECT ipb_address, page_title,... |
8 years ago |
USE trwiki_p;
SELECT ipb_address, page_title, fr_page_id, rev_page,... |
8 years ago |
USE trwiki_p;
SELECT ipb_address, page_name, fr_page_id, rev_page,... |
8 years ago |
USE trwiki_p;
SELECT ipb_address, fr_page_id, rev_page, fr_rev_id,... |
8 years ago |
USE trwiki_p;
SELECT *#ipb_address, fr_page_id, fr_rev_id, fr_timestamp,... |
8 years ago |
USE trwiki_p;
SELECT ipb_address, fr_page_id, fr_rev_id, fr_timestamp,... |
8 years ago |
USE trwiki_p;
SELECT ipb_address, fr_page_id, fr_rev_id, fr_timestamp,... |
8 years ago |
USE trwiki_p;
SELECT ipb_user, fr_page_id, fr_rev_id, fr_timestamp,... |
8 years ago |
USE trwiki_p;
SELECT #ipb_user, fr_page_id, fr_rev_id, fr_timestamp,... |
8 years ago |
USE trwiki_p;
SELECT *#ipb_user, fr_page_id, fr_timestamp, fr_flags,... |
8 years ago |
USE trwiki_p;
SELECT ipb_user, fr_page_id, fr_timestamp, fr_flags,... |
8 years ago |
USE trwiki_p;
SELECT ipb_user, fr_page_id, fr_timestamp, fr_flags,... |
8 years ago |
USE trwiki_p;
SELECT *
FROM flaggedrevs
JOIN ipblocks on ipb_id = fr_user
LIMIT 10
; |
8 years ago |
USE trwiki_p;
SELECT *
FROM flaggedrevs
LIMIT 10
; |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs
; |
8 years ago |
USE trwiki_p;
DESCRIBE flaggedrevs
; |
8 years ago |
USE trwiki_p;
SELECT *
FROM flaggedrevs
; |
8 years ago |
SHOW TABLES FROM trwiki_p; |
8 years ago |
USE trwiki_p;
SELECT *
From iwlinks join page on page_id=iwl_from
WHERE... |
8 years ago |
USE trwiki_p;
SELECT *
From iwlinks join page on page_id=iwl_from
WHERE... |
8 years ago |
USE trwiki_p;
SELECT *
From iwlinks join page on page_id=iwl_from
WHERE... |
8 years ago |
USE trwiki_p;
SELECT *
From iwlinks join page on page_id=iwl_from
WHERE... |
8 years ago |
USE trwiki_p;
SELECT *
From iwlinks join page on page_id=iwl_from
WHERE... |
8 years ago |
USE trwiki_p;
SELECT *
From iwlinks join page on page_id=iwl_from
WHERE... |
8 years ago |
USE trwiki_p;
SELECT *
From iwlinks join page on page_id=iwl_from
WHERE... |
8 years ago |
USE trwiki_p;
SELECT *
From iwlinks join page on page_id=iwl_from
LIMIT 100;
|
8 years ago |
USE trwiki_p;
|
8 years ago |
USE cswiki_p; USE plwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE cswiki_p UNION plwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE cswiki_p, plwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE cswiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE plwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE cswiki_p;
USE plwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE cswiki_p
USE plwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE plwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE plwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE cswiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE enwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE enwiki_p;
SET @kacgun = -100;
SELECT up_value, COUNT(*),... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, user_name,... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, user_name,... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, user_name,... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, COUNT(*),... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, COUNT(*),... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, COUNT(*),... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, COUNT(*),... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, COUNT(*)
FROM user
LEFT... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, COUNT(*)
FROM user
LEFT... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT user_name, up_value,... |
8 years ago |
USE trwiki_p;
SET @kacgun = -10;
SELECT user_name, up_value,... |
8 years ago |
USE trwiki_p;
SET @kacgun = -100;
SELECT user_name, up_value,... |
8 years ago |
USE trwiki_p;
SET @kacgun = -100;
SELECT user_name, up_value,... |
8 years ago |
USE trwiki_p;
SELECT user_name, up_property, up_value
FROM user
JOIN... |
8 years ago |
USE trwiki_p;
SELECT user_name, up_property, up_value
FROM user
JOIN... |
8 years ago |
USE trwiki_p;
SELECT user_name, up_property, up_value
FROM user
JOIN... |
8 years ago |
USE trwiki_p;
SELECT user_name, up_property, up_value
FROM user
JOIN... |
8 years ago |
USE trwiki_p;
SELECT user_name, up_property, up_value
FROM user
LEFT JOIN... |
8 years ago |
USE cswiki_p;
SET @bas = now();
SELECT @bas as zaman;
set @sure =... |
8 years ago |
USE trwiki_p;
SET @bas = now();
SELECT @bas as zaman;
set @sure =... |
8 years ago |
USE trwiki_p;
SET @bas = now();
SELECT @bas as zaman;
set @sure =... |
8 years ago |
USE trwiki_p;
SET @bas = now();
SELECT @bas as zaman;
set @sure =... |
8 years ago |
USE trwiki_p;
SET @bas = now();
SELECT @bas as zaman;
set @sure =... |
8 years ago |
USE trwiki_p;
SET @bas = now();
SELECT @bas as zaman;
set @sure =... |
8 years ago |
USE trwiki_p;
SET @bas = now();
SELECT @bas as zaman;
set @sure =... |
8 years ago |
USE trwiki_p;
SET @bas = now();
set @sure = 100;
SELECT *
FROM (SELECT *,... |
8 years ago |
USE trwiki_p;
SET @bas = now();
set @sure = 100;
SELECT *
FROM (SELECT *,... |
8 years ago |
USE trwiki_p;
SET @bas = now();
set @sure = 100;
SELECT *
FROM (SELECT *,... |
8 years ago |
USE trwiki_p;
SET @bas = now();
set @sure = 100;
SELECT *, FROM (SELECT *,... |
8 years ago |
USE trwiki_p;
SET @bas = now();
set @sure = 100;
FROM (SELECT *,... |
8 years ago |
USE trwiki_p;
SET @bas = now();
SELECT date_add(now(),interval -3 MINUTE) as... |
8 years ago |
USE trwiki_p;
SELECT date_add(now(),interval -3 MINUTE) as zaman;
|
8 years ago |
USE trwiki_p;
SELECT date_add(now(),interval -3 HOUR) as zaman;
|
8 years ago |
USE trwiki_p;
SELECT GET_DATE() as zaman;
|
8 years ago |
USE trwiki_p;
SELECT zirt.user_name as k, datediff(NOW(),zirt.zaman) as... |
8 years ago |
USE trwiki_p;
SELECT zirt.user_name as k, datediff(NOW(),zirt.zaman) as... |
8 years ago |
USE trwiki_p;
SELECT datediff(NOW(),zirt.zaman) as fark
FROM (SELECT *,... |
8 years ago |
USE trwiki_p;
SELECT datediff(NOW(),zirt.zaman) as fark, zirt.zaman as... |
8 years ago |
USE trwiki_p;
SELECT datediff(NOW(),zirt.zaman) as fark, zirt.zaman as... |
8 years ago |
USE trwiki_p;
SELECT datediff(NOW(),zaman) as fark, zaman
FROM (SELECT *,... |
8 years ago |
USE trwiki_p;
SELECT datediff(NOW(),zaman) as fark, zaman
FROM (SELECT now()... |
8 years ago |
USE trwiki_p;
SELECT datediff(NOW(),zaman) as fark, zaman
FROM (SELECT... |
8 years ago |
USE trwiki_p;
SELECT datediff(NOW(),zaman) as fark, zaman
FROM (SELECT now()... |
8 years ago |
USE trwiki_p;
SELECT datediff(NOW(),zaman) as fark, zaman
FROM (SELECT now()... |
8 years ago |
USE trwiki_p;
SELECT now() as zaman;
SELECT *
from user
left join ... |
8 years ago |
USE trwiki_p;
SELECT datediff(zaman2,zaman) as fark
((SELECT NOW() as... |
8 years ago |
USE trwiki_p;
SELECT datediff(zaman2,zaman) as fark
(SELECT NOW() as... |
8 years ago |
USE trwiki_p;
SELECT datediff(zaman2,zaman) as fark
SELECT NOW() as... |
8 years ago |
USE trwiki_p;
SELECT datediff(zaman2,zaman) as fark
SELECT NOW() as... |
8 years ago |
USE trwiki_p;
SELECT NOW() as zaman;
SELECT *
from user
left join ... |
8 years ago |
USE trwiki_p;
SELECT zaman2-zaman as fark
SELECT NOW() as zaman;
SELECT * ... |
8 years ago |
USE trwiki_p;
SELECT NOW() as zaman;
SELECT *
from user
left join ... |
8 years ago |
USE trwiki_p;
SELECT *
from user
left join ipblocks on ipb_user... |
8 years ago |
USE trwiki_p;
SELECT *
from user
RIGHT join ipblocks on ipb_user... |
8 years ago |
USE trwiki_p;
SELECT *
from user
RIGHT join ipblocks where ipb_user... |
8 years ago |
USE trwiki_p;
SELECT * FROM ipblocks where ipb_user > 0 group by ipb_user
|
8 years ago |
USE trwiki_p;
SELECT * FROM ipblocks where ipb_user > 0 group by... |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks group by ipb_user where ipb_user >... |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks group by ipb_user where ipb_user >... |
8 years ago |
USE trwiki_p;
SELECT * FROM ipblocks group by ipb_user where ipb_user >... |
8 years ago |
USE trwiki_p;
SELECT * , FROM ipblocks group by ipb_user where ipb_user... |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks group by ipb_user
LIMIT 100; |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks
LIMIT 100; |
8 years ago |
USE trwiki_p;
SELECT *
FROM user_groups join user on user_id =... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user_groups join user on user_id =... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user_groups, user
WHERE user_name... |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks, user
WHERE user_name... |
8 years ago |
USE trwiki_p;
SELECT user_id, user_name, ipb_id
FROM user, ipblocks
... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user, ipblocks
WHERE user_name like... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user, ipblocks
WHERE user_name like... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
RIGHT JOIN ipblocks
on... |
8 years ago |
USE trwiki_p;
SELECT *
FROM revision AS latest
JOIN user
ON user_id... |
8 years ago |
USE trwiki_p;
SELECT *
FROM revision AS latest
JOIN user
ON user_id... |
8 years ago |
USE trwiki_p;
SELECT user_name, (ipb_id IS NULL ) as aa
FROM revision... |
8 years ago |
USE trwiki_p;
SELECT user_name, (ipb_id IS NULL as) aa
FROM revision AS... |
8 years ago |
USE trwiki_p;
SELECT user_name, DISTINCT ipb_id
FROM revision AS... |
8 years ago |
USE trwiki_p;
SELECT user_name, ipb_id
FROM revision AS latest
JOIN... |
8 years ago |
USE trwiki_p;
SELECT *
FROM revision AS latest
JOIN user
ON user_id... |
8 years ago |
USE trwiki_p;
SELECT *
FROM (SELECT *, MAX(rev_timestamp) AS last_edit... |
8 years ago |
USE trwiki_p;
SELECT *
FROM (SELECT *, MAX(rev_timestamp) AS last_edit... |
8 years ago |
USE trwiki_p;
SELECT *
FROM (SELECT *, MAX(rev_timestamp) AS last_edit... |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks
JOIN user
on user_id =... |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks
JOIN user
on user_id =... |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks
JOIN user
user_id =... |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks
JOIN user
user_id =... |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks
LIMIT 200; |
8 years ago |
USE trwiki_p;
SELECT *
FROM ipblocks
JOIN user
... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
WHERE user_real_name IS NOT... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
WHERE user_real_name IS NOT... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
WHERE user_real_name IS NOT... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
WHERE user_real_name IS NOT... |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
WHERE user_name ='Monsters60'
LIMIT 200; |
8 years ago |
USE trwiki_p;
SELECT *
FROM user
JOIN ipblocks
ON ipb_user =... |
8 years ago |
USE trwiki_p;
SELECT user_name, last_edit, user_editcount, ug_group,... |
8 years ago |
USE trwiki_p;
SELECT user_name, last_edit, user_editcount, ug_group,... |
8 years ago |
USE trwiki_p;
SELECT user_name, last_edit, user_editcount, ug_group,... |
8 years ago |
USE trwiki_p;
SELECT user_name, last_edit, user_editcount, ug_group,... |
8 years ago |