مقالات لها تصانيف بنفس الاسم، ولكن لا تحتوي هذه المقالات على هذه التصانيف

SQL

use arwikiversity_p;
SELECT CONVERT(CONVERT(user_name USING BINARY) USING latin1) AS latin1 
FROM user f LEFT OUTER JOIN page ff
ON  CONVERT(CONVERT(f.user_name USING BINARY) USING latin1) AS latin1  =  CONVERT(CONVERT(ff.page_title USING BINARY) USING latin1) AS latin1  
and ff.page_namespace = 3
WHERE CONVERT(CONVERT(ff.page_title USING BINARY) USING latin1) AS latin1  IS NULL limit 30;
/*select user_name from user where ucase (user_name) not like ucase ("%BOT") collate utf8_general_ci 
and user_name not in (select ipb_address from ipblocks where ipb_address = user_name) 
and user_name not in (select page_title from page where page_namespace = 3) limit 20;*/

SQL

Checking query status...