Actions

User

Difference between revisions of "MoerkJ/List of unused images (smallest)"

From DramaWiki

< User:MoerkJ
 
m
 
(One intermediate revision by the same user not shown)
Line 3: Line 3:
 
FROM $image LEFT JOIN $imagelinks ON img_name=il_to WHERE il_to IS NULL
 
FROM $image LEFT JOIN $imagelinks ON img_name=il_to WHERE il_to IS NULL
 
ORDER BY img_size ASC LIMIT 100</pre>
 
ORDER BY img_size ASC LIMIT 100</pre>
 +
 +
The purpose of this list is to identify further [[:Category:Images for deletion|candidates for deletion]].
  
 
== List of smallest unused images ==
 
== List of smallest unused images ==
−
*[[:File:JoMinKi.jpg]] 4497 bytes, uploaded 2008-Mar-15 20:00 by [[User:Lady Zhuge|Lady Zhuge]]
+
*[[:File:YeungKaSing.jpg]] 1351 bytes, uploaded 2009-Aug-18 12:03 by [[User:YT|YT]]
 +
*[[:File:IshibashiTakaaki.jpg]] 2338 bytes, uploaded 2009-Nov-17 04:19 by [[User:Schmoejoe|Schmoejoe]]
 +
*[[:File:Tsumami_Edamame.jpg]] 2350 bytes, uploaded 2009-Nov-10 04:07 by [[User:Schmoejoe|Schmoejoe]]
 +
*[[:File:Kang_Yi_Suk.JPG]] 2661 bytes, uploaded 2007-Aug-09 15:05 by [[User:Amano|Amano]]
 +
*[[:File:Judyzhou.jpg]] 3176 bytes, uploaded 2008-Jan-15 00:34 by [[User:WaterOB|WaterOB]]
 +
*[[:File:HaPing.jpeg]] 3249 bytes, uploaded 2008-Feb-22 22:25 by [[User:Humbeggar|Humbeggar]]
 +
*[[:File:Images.jpg]] 3298 bytes, uploaded 2007-Jun-23 10:00 by [[User:Bianca|Bianca]]
 +
*[[:File:Tender.jpg]] 3875 bytes, uploaded 2008-Dec-23 09:35 by [[User:Rachelabichen|Rachelabichen]]
 +
*[[:File:Kim_Hyuk.jpg]] 3901 bytes, uploaded 2007-Nov-04 15:36 by [[User:Amano|Amano]]
 +
*[[:File:Minori222.jpg]] 3948 bytes, uploaded 2005-Sep-06 04:40 by [[User:YT|YT]]
 +
*[[:File:Maya22.jpg]] 4072 bytes, uploaded 2005-Apr-18 11:32 by [[User:YT|YT]]
 +
*[[:File:Ruito_aoyagi.jpg]] 4087 bytes, uploaded 2007-Jul-28 01:34 by [[User:Uladelz|Uladelz]]
 +
*[[:File:Yuuki222a.jpg]] 4183 bytes, uploaded 2005-Sep-03 11:02 by [[User:YT|YT]]
 +
*[[:File:Ngai_Wai_Man.jpeg]] 4601 bytes, uploaded 2009-Jul-23 13:30 by [[User:YT|YT]]
 
*[[:File:SatoJiro222.jpg]] 4967 bytes, uploaded 2005-Jun-22 06:17 by [[User:YT|YT]]
 
*[[:File:SatoJiro222.jpg]] 4967 bytes, uploaded 2005-Jun-22 06:17 by [[User:YT|YT]]
 +
*[[:File:Ehatahironori.jpg]] 5061 bytes, uploaded 2005-Jun-30 14:21 by [[User:YT|YT]]
 +
*[[:File:BelindaYan.jpg]] 5113 bytes, uploaded 2009-Aug-12 04:25 by [[User:YT|YT]]
 
*[[:File:LuShuMing.jpg]] 5173 bytes, uploaded 2007-Aug-23 01:28 by [[User:Lady Zhuge|Lady Zhuge]]
 
*[[:File:LuShuMing.jpg]] 5173 bytes, uploaded 2007-Aug-23 01:28 by [[User:Lady Zhuge|Lady Zhuge]]
 
*[[:File:Aki222aab.jpg]] 5177 bytes, uploaded 2005-Oct-23 11:20 by [[User:YT|YT]]
 
*[[:File:Aki222aab.jpg]] 5177 bytes, uploaded 2005-Oct-23 11:20 by [[User:YT|YT]]
Line 13: Line 30:
 
*[[:File:NosakiTenma.jpg]] 5212 bytes, uploaded 2005-Jun-30 14:03 by [[User:YT|YT]]
 
*[[:File:NosakiTenma.jpg]] 5212 bytes, uploaded 2005-Jun-30 14:03 by [[User:YT|YT]]
 
*[[:File:Thelastsong.jpg]] 5212 bytes, uploaded 2005-Jul-12 11:39 by [[User:YT|YT]]
 
*[[:File:Thelastsong.jpg]] 5212 bytes, uploaded 2005-Jul-12 11:39 by [[User:YT|YT]]
 +
*[[:File:Sungchihling_profile.jpg]] 5223 bytes, uploaded 2009-Sep-04 08:03 by [[User:YT|YT]]
 +
*[[:File:SeoSukHyang.jpg]] 5231 bytes, uploaded 2008-Aug-15 09:39 by [[User:Piano.lady|Piano.lady]]
 
*[[:File:Yueshawn.jpg]] 5236 bytes, uploaded 2005-Jul-25 12:41 by [[User:YT|YT]]
 
*[[:File:Yueshawn.jpg]] 5236 bytes, uploaded 2005-Jul-25 12:41 by [[User:YT|YT]]
 
*[[:File:JacquelineLi.jpg]] 5247 bytes, uploaded 2005-Jul-25 12:09 by [[User:YT|YT]]
 
*[[:File:JacquelineLi.jpg]] 5247 bytes, uploaded 2005-Jul-25 12:09 by [[User:YT|YT]]
Line 24: Line 43:
 
*[[:File:Nicky_Wu.JPG]] 5433 bytes, uploaded 2007-Oct-24 21:38 by [[User:Vivi.g|Vivi.g]]
 
*[[:File:Nicky_Wu.JPG]] 5433 bytes, uploaded 2007-Oct-24 21:38 by [[User:Vivi.g|Vivi.g]]
 
*[[:File:WangYan.jpg]] 5437 bytes, uploaded 2005-Jul-25 12:12 by [[User:YT|YT]]
 
*[[:File:WangYan.jpg]] 5437 bytes, uploaded 2005-Jul-25 12:12 by [[User:YT|YT]]
−
*[[:File:SatoRyuta.jpg]] 5441 bytes, uploaded 2005-Jun-16 09:23 by [[User:YT|YT]]
 
 
*[[:File:ShinMinHee.jpg]] 5456 bytes, uploaded 2007-Oct-09 01:08 by [[User:C51236|C51236]]
 
*[[:File:ShinMinHee.jpg]] 5456 bytes, uploaded 2007-Oct-09 01:08 by [[User:C51236|C51236]]
 
*[[:File:Hiroki.jpg]] 5468 bytes, uploaded 2006-Mar-03 02:22 by [[User:Kayoi|Kayoi]]
 
*[[:File:Hiroki.jpg]] 5468 bytes, uploaded 2006-Mar-03 02:22 by [[User:Kayoi|Kayoi]]
Line 45: Line 63:
 
*[[:File:Cheongangie.jpg]] 5748 bytes, uploaded 2005-Jul-25 12:51 by [[User:YT|YT]]
 
*[[:File:Cheongangie.jpg]] 5748 bytes, uploaded 2005-Jul-25 12:51 by [[User:YT|YT]]
 
*[[:File:HirayamaAya.jpg]] 5773 bytes, uploaded 2005-Jun-16 09:38 by [[User:YT|YT]]
 
*[[:File:HirayamaAya.jpg]] 5773 bytes, uploaded 2005-Jun-16 09:38 by [[User:YT|YT]]
 +
*[[:File:TakeuchiToshi.jpg]] 5793 bytes, uploaded 2010-Jan-22 03:26 by [[User:Schmoejoe|Schmoejoe]]
 
*[[:File:Akio222.jpg]] 5796 bytes, uploaded 2005-Sep-06 04:44 by [[User:YT|YT]]
 
*[[:File:Akio222.jpg]] 5796 bytes, uploaded 2005-Sep-06 04:44 by [[User:YT|YT]]
 
*[[:File:ByunHeeBOng.jpg]] 5807 bytes, uploaded 2007-Mar-13 02:33 by [[User:C51236|C51236]]
 
*[[:File:ByunHeeBOng.jpg]] 5807 bytes, uploaded 2007-Mar-13 02:33 by [[User:C51236|C51236]]
Line 56: Line 75:
 
*[[:File:Penny_lin.jpg]] 6000 bytes, uploaded 2005-Jul-10 02:23 by [[User:Lynsey|Lynsey]]
 
*[[:File:Penny_lin.jpg]] 6000 bytes, uploaded 2005-Jul-10 02:23 by [[User:Lynsey|Lynsey]]
 
*[[:File:Tanaka222ac.jpg]] 6008 bytes, uploaded 2005-Aug-13 06:33 by [[User:YT|YT]]
 
*[[:File:Tanaka222ac.jpg]] 6008 bytes, uploaded 2005-Aug-13 06:33 by [[User:YT|YT]]
 +
*[[:File:Hamada.JPG]] 6062 bytes, uploaded 2007-Apr-17 05:05 by [[User:Marienella|Marienella]]
 
*[[:File:OotakeShinobu.JPG]] 6104 bytes, uploaded 2005-Aug-02 03:31 by [[User:YT|YT]]
 
*[[:File:OotakeShinobu.JPG]] 6104 bytes, uploaded 2005-Aug-02 03:31 by [[User:YT|YT]]
 +
*[[:File:Leung_Ka_Ki.jpg]] 6120 bytes, uploaded 2009-Apr-27 13:29 by [[User:YT|YT]]
 
*[[:File:Komatsuayaka.jpg]] 6137 bytes, uploaded 2007-Jan-02 08:55 by [[User:Swanlake|Swanlake]]
 
*[[:File:Komatsuayaka.jpg]] 6137 bytes, uploaded 2007-Jan-02 08:55 by [[User:Swanlake|Swanlake]]
 
*[[:File:HoshinoAki4324.jpg]] 6155 bytes, uploaded 2006-Apr-15 16:10 by [[User:YT|YT]]
 
*[[:File:HoshinoAki4324.jpg]] 6155 bytes, uploaded 2006-Apr-15 16:10 by [[User:YT|YT]]
 
*[[:File:ShuntaNakamura.jpg]] 6182 bytes, uploaded 2005-Sep-10 13:31 by [[User:YT|YT]]
 
*[[:File:ShuntaNakamura.jpg]] 6182 bytes, uploaded 2005-Sep-10 13:31 by [[User:YT|YT]]
−
*[[:File:Yasufumi222a.jpg]] 6217 bytes, uploaded 2005-Oct-30 07:17 by [[User:YT|YT]]
+
*[[:File:KilYongWoo.jpg]] 6184 bytes, uploaded 2008-Mar-15 20:14 by [[User:Lady Zhuge|Lady Zhuge]]
−
*[[:File:Hu_Ge_2.jpg]] 6220 bytes, uploaded 2006-Mar-26 00:13 by [[User:Maddie|Maddie]]
 
 
*[[:File:Inada_nao.jpg]] 6227 bytes, uploaded 2007-Aug-24 20:28 by [[User:Niko2x|Niko2x]]
 
*[[:File:Inada_nao.jpg]] 6227 bytes, uploaded 2007-Aug-24 20:28 by [[User:Niko2x|Niko2x]]
 
*[[:File:Yy02.jpg]] 6241 bytes, uploaded 2006-Oct-21 09:57 by [[User:L3lueLillie|L3lueLillie]]
 
*[[:File:Yy02.jpg]] 6241 bytes, uploaded 2006-Oct-21 09:57 by [[User:L3lueLillie|L3lueLillie]]
 +
*[[:File:Toshiya2222.jpg]] 6259 bytes, uploaded 2005-Jun-22 06:25 by [[User:YT|YT]]
 
*[[:File:Hiroko222.jpg]] 6392 bytes, uploaded 2005-Sep-03 11:36 by [[User:YT|YT]]
 
*[[:File:Hiroko222.jpg]] 6392 bytes, uploaded 2005-Sep-03 11:36 by [[User:YT|YT]]
 
*[[:File:Enouyuuya22.jpg]] 6405 bytes, uploaded 2005-Oct-29 09:10 by [[User:YT|YT]]
 
*[[:File:Enouyuuya22.jpg]] 6405 bytes, uploaded 2005-Oct-29 09:10 by [[User:YT|YT]]
 +
*[[:File:Oji_Megumi.jpg]] 6430 bytes, uploaded 2006-Mar-25 16:50 by [[User:Floaton|Floaton]]
 
*[[:File:UchimuraTeruyoshi.jpg]] 6458 bytes, uploaded 2006-Mar-02 16:27 by [[User:Floaton|Floaton]]
 
*[[:File:UchimuraTeruyoshi.jpg]] 6458 bytes, uploaded 2006-Mar-02 16:27 by [[User:Floaton|Floaton]]
−
*[[:File:Eunhye.jpg]] 6530 bytes, uploaded 2007-Mar-09 01:23 by [[User:C51236|C51236]]
 
 
*[[:File:Tomoya.jpg]] 6531 bytes, uploaded 2005-Apr-15 10:19 by [[User:YT|YT]]
 
*[[:File:Tomoya.jpg]] 6531 bytes, uploaded 2005-Apr-15 10:19 by [[User:YT|YT]]
 
*[[:File:Konno222a.jpg]] 6590 bytes, uploaded 2005-Jun-22 06:07 by [[User:YT|YT]]
 
*[[:File:Konno222a.jpg]] 6590 bytes, uploaded 2005-Jun-22 06:07 by [[User:YT|YT]]
Line 73: Line 94:
 
*[[:File:KawashimaUmika.jpg]] 6611 bytes, uploaded 2006-Dec-24 16:23 by [[User:YT|YT]]
 
*[[:File:KawashimaUmika.jpg]] 6611 bytes, uploaded 2006-Dec-24 16:23 by [[User:YT|YT]]
 
*[[:File:Shin_pic.jpg]] 6626 bytes, uploaded 2006-Dec-17 17:47 by [[User:WaterOB|WaterOB]]
 
*[[:File:Shin_pic.jpg]] 6626 bytes, uploaded 2006-Dec-17 17:47 by [[User:WaterOB|WaterOB]]
 +
*[[:File:Naoto22.JPG]] 6644 bytes, uploaded 2005-Apr-17 10:13 by [[User:YT|YT]]
 
*[[:File:Topcaster.gif]] 6649 bytes, uploaded 2006-Jul-10 06:34 by [[User:Aiscess|Aiscess]]
 
*[[:File:Topcaster.gif]] 6649 bytes, uploaded 2006-Jul-10 06:34 by [[User:Aiscess|Aiscess]]
 
*[[:File:SakaiMaki.jpg]] 6667 bytes, uploaded 2005-Jun-16 08:54 by [[User:YT|YT]]
 
*[[:File:SakaiMaki.jpg]] 6667 bytes, uploaded 2005-Jun-16 08:54 by [[User:YT|YT]]
−
*[[:File:DennisOh2.jpg]] 6670 bytes, uploaded 2006-Jan-19 09:38 by [[User:Flash|Flash]]
 
 
*[[:File:VicZhou.jpg]] 6675 bytes, uploaded 2005-Mar-30 07:28 by [[User:Athida|Athida]]
 
*[[:File:VicZhou.jpg]] 6675 bytes, uploaded 2005-Mar-30 07:28 by [[User:Athida|Athida]]
 +
*[[:File:CheungYik.jpg]] 6713 bytes, uploaded 2009-May-22 13:01 by [[User:YT|YT]]
 
*[[:File:Takaoka01.jpg]] 6719 bytes, uploaded 2007-Feb-19 02:29 by [[User:Wapuro|Wapuro]]
 
*[[:File:Takaoka01.jpg]] 6719 bytes, uploaded 2007-Feb-19 02:29 by [[User:Wapuro|Wapuro]]
−
*[[:File:Cid.jpg]] 6743 bytes, uploaded 2007-Mar-10 17:56 by [[User:Forgetfoolz|Forgetfoolz]]
 
 
*[[:File:Ahn_Jung_Hoon.jpg]] 6745 bytes, uploaded 2007-Sep-21 08:28 by [[User:Aksquest|Aksquest]]
 
*[[:File:Ahn_Jung_Hoon.jpg]] 6745 bytes, uploaded 2007-Sep-21 08:28 by [[User:Aksquest|Aksquest]]
 +
*[[:File:Lutingwei.jpg]] 6746 bytes, uploaded 2006-Dec-15 03:36 by [[User:WaterOB|WaterOB]]
 
*[[:File:Joe_Ma.jpg]] 6747 bytes, uploaded 2006-Mar-22 09:13 by [[User:Floaton|Floaton]]
 
*[[:File:Joe_Ma.jpg]] 6747 bytes, uploaded 2006-Mar-22 09:13 by [[User:Floaton|Floaton]]
−
*[[:File:Zhao_Hong_Fei.JPG]] 6792 bytes, uploaded 2007-Oct-10 01:29 by [[User:Vivi.g|Vivi.g]]
+
*[[:File:Koji222aa.jpg]] 6804 bytes, uploaded 2005-Nov-01 06:10 by [[User:YT|YT]]
 
*[[:File:TerashimaShinobu.jpg]] 6812 bytes, uploaded 2005-Jun-16 09:10 by [[User:YT|YT]]
 
*[[:File:TerashimaShinobu.jpg]] 6812 bytes, uploaded 2005-Jun-16 09:10 by [[User:YT|YT]]
 
*[[:File:KurokiHitomi1.jpg]] 6845 bytes, uploaded 2005-Jun-16 09:16 by [[User:YT|YT]]
 
*[[:File:KurokiHitomi1.jpg]] 6845 bytes, uploaded 2005-Jun-16 09:16 by [[User:YT|YT]]
−
*[[:File:TanakaKei.jpg]] 6862 bytes, uploaded 2006-Oct-05 13:28 by [[User:YT|YT]]
+
*[[:File:SherenTang.jpg]] 6847 bytes, uploaded 2009-Aug-08 13:07 by [[User:YT|YT]]
−
*[[:File:Bryan.jpg]] 6863 bytes, uploaded 2006-Sep-09 21:42 by [[User:WaterOB|WaterOB]]
+
''list generated with listImages script on Wed, 2010 Aug 25 22:04:41''
−
*[[:File:Itazurana.jpg]] 6872 bytes, uploaded 2006-Mar-18 02:03 by [[User:Martina|Martina]]
+
 
−
*[[:File:Mingdao.jpg]] 6886 bytes, uploaded 2007-Apr-07 21:16 by [[User:Sprixblue|Sprixblue]]
+
== See also ==
−
*[[:File:IzumiyaShigeru.JPG]] 6888 bytes, uploaded 2005-Jul-13 14:14 by [[User:YT|YT]]
+
*[[User:MoerkJ/List of unused images (largest)|List of largest unused images]]
−
*[[:File:YanagibaToshiro2.jpg]] 6894 bytes, uploaded 2005-Jun-16 08:33 by [[User:YT|YT]]
+
*[[User:MoerkJ/List of recently uploaded but unused images|List of recently uploaded but unused images]]
−
*[[:File:Asami2333.jpg]] 6903 bytes, uploaded 2005-Jun-22 06:22 by [[User:YT|YT]]
+
*[[Special:Unusedimages|List of unused images sorted by age]]
−
*[[:File:ShunShioya.jpg]] 6912 bytes, uploaded 2006-Aug-19 18:58 by [[User:YT|YT]]
+
*[[DramaWiki:Deletion policy|DramaWiki deletion policy]]
−
*[[:File:Chen_Yi_Ru.jpg]] 6936 bytes, uploaded 2006-Mar-29 05:54 by [[User:Floaton|Floaton]]
+
*[[Special:Log/delete|Deletion log]]
−
*[[:File:HwangSooJung.jpg]] 6943 bytes, uploaded 2005-Dec-27 10:30 by [[User:MoerkJ|MoerkJ]]
 
−
*[[:File:MarcoNgai.jpg]] 6956 bytes, uploaded 2007-Apr-07 18:47 by [[User:C51236|C51236]]
 
−
*[[:File:Koizora.jpg]] 6989 bytes, uploaded 2008-Jun-06 17:56 by [[User:Lady Zhuge|Lady Zhuge]]
 
−
*[[:File:Makidai2333.jpg]] 7023 bytes, uploaded 2005-Jun-22 06:27 by [[User:YT|YT]]
 
−
*[[:File:Katahira22a.jpg]] 7068 bytes, uploaded 2005-Sep-01 01:12 by [[User:YT|YT]]
 
−
*[[:File:HiraoYuki.JPG]] 7129 bytes, uploaded 2005-Jun-29 11:04 by [[User:YT|YT]]
 
−
*[[:File:ParkJungChul.jpg]] 7134 bytes, uploaded 2006-Jun-24 06:55 by [[User:Gross89|Gross89]]
 
−
*[[:File:Jun.do.yeon.jpg]] 7151 bytes, uploaded 2005-Oct-20 19:35 by [[User:Leegyep|Leegyep]]
 
−
*[[:File:Chara_ogata_f.jpg]] 7154 bytes, uploaded 2005-Jul-31 07:34 by [[User:YT|YT]]
 
−
*[[:File:Jidan3.jpg]] 7155 bytes, uploaded 2005-Jun-26 04:02 by [[User:YT|YT]]
 
−
*[[:File:Itohideaki.jpg]] 7157 bytes, uploaded 2005-Jun-16 09:29 by [[User:YT|YT]]
 
−
''list generated on Thu, 2008 Sep 11 22:03:59''
 
  
−
[[Category:DramaWiki Maintenance|Unused Images (smallest)]]
+
[[Category:DramaWiki Maintenance|List of unused images (smallest)]]

Latest revision as of 15:07, 25 August 2010

This list below is generated with a small php script. The following SQL query was used: 

SELECT img_name, img_user_text, img_timestamp, img_size
FROM $image LEFT JOIN $imagelinks ON img_name=il_to WHERE il_to IS NULL
ORDER BY img_size ASC LIMIT 100

The purpose of this list is to identify further candidates for deletion.

List of smallest unused images

list generated with listImages script on Wed, 2010 Aug 25 22:04:41

See also

Retrieved from "https://wiki.d-addicts.com/index.php?title=User:MoerkJ/List_of_unused_images_(smallest)&oldid=227873"