(0)
phpMyAdmin'e girip sorguları çalıştırın. "SQL" :
Kullanıcılar Kaç Adet Özel Mesajı Arşivlemiş :
Kod:
DROP TEMPORARY TABLE IF EXISTS tmp;
CREATE TABLE tmp SELECT pm_touserid, COUNT(*) as pmcount FROM sed_pm WHERE pm_state=2 GROUP BY pm_touserid;
SELECT t.pm_touserid, u.user_name, t.pmcount FROM tmp AS t, sed_users AS u WHERE u.user_id=t.pm_touserid ORDER by t.pmcount DESC, u.user_name ASC LIMIT 500;
CREATE TABLE tmp SELECT pm_touserid, COUNT(*) as pmcount FROM sed_pm WHERE pm_state=2 GROUP BY pm_touserid;
SELECT t.pm_touserid, u.user_name, t.pmcount FROM tmp AS t, sed_users AS u WHERE u.user_id=t.pm_touserid ORDER by t.pmcount DESC, u.user_name ASC LIMIT 500;
Kaç Adet Özel Mesaj Gelen Kutusunda :
Kod:
DROP TEMPORARY TABLE IF EXISTS tmp;
CREATE TABLE tmp SELECT pm_touserid, COUNT(*) as pmcount FROM sed_pm WHERE pm_state=1 GROUP BY pm_touserid;
SELECT t.pm_touserid, u.user_name, t.pmcount FROM tmp AS t, sed_users AS u WHERE u.user_id=t.pm_touserid ORDER by t.pmcount DESC, u.user_name ASC LIMIT 500;
CREATE TABLE tmp SELECT pm_touserid, COUNT(*) as pmcount FROM sed_pm WHERE pm_state=1 GROUP BY pm_touserid;
SELECT t.pm_touserid, u.user_name, t.pmcount FROM tmp AS t, sed_users AS u WHERE u.user_id=t.pm_touserid ORDER by t.pmcount DESC, u.user_name ASC LIMIT 500;
Kaç Adet Özel Mesaj Okunmamış :
Kod:
DROP TEMPORARY TABLE IF EXISTS tmp;
CREATE TABLE tmp SELECT pm_touserid, COUNT(*) as pmcount FROM sed_pm WHERE pm_state=0 GROUP BY pm_touserid;
SELECT t.pm_touserid, u.user_name, t.pmcount FROM tmp AS t, sed_users AS u WHERE u.user_id=t.pm_touserid ORDER by t.pmcount DESC, u.user_name ASC LIMIT 500;
CREATE TABLE tmp SELECT pm_touserid, COUNT(*) as pmcount FROM sed_pm WHERE pm_state=0 GROUP BY pm_touserid;
SELECT t.pm_touserid, u.user_name, t.pmcount FROM tmp AS t, sed_users AS u WHERE u.user_id=t.pm_touserid ORDER by t.pmcount DESC, u.user_name ASC LIMIT 500;
