User:Gmaxwell/possiblyevilimages

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

mysql> select concat('*Image:',img_name,''),img_size,img_width,img_height,img_size/(img_width*img_height) as ratio,img_user_text,img_timestamp from image where img_name like '%.jpg' and img_size>100000 and img_size>(2*img_width*img_height) and img_width>0 and 0<img_height order by ratio desc; --------------------------------------------------------------------------------------- ---------- ----------- ------------ --------- ------------------------------------- ---------------- | concat('*Image:',img_name,'') | img_size | img_width | img_height | ratio | img_user_text | img_timestamp | --------------------------------------------------------------------------------------- ---------- ----------- ------------ --------- ------------------------------------- ----------------

--------------------------------------------------------------------------------------- ---------- ----------- ------------ --------- ------------------------------------- ---------------- 354 rows in set (2.81 sec)