Benutzer:Kylu/pei
Zur Navigation springen
Zur Suche springen
Über diese Seite
[Bearbeiten | Quelltext bearbeiten]Dies ist eine Liste der Bilder auf Deutsch suchen, können mehr Daten als das Bild. Es ist bekannt, dass eine. RAR-Archiv kann in einem versteckten. JPG-Datei zu schmuggeln Dateien wie. Mp3 Musik und andere illegale Dinge. Bilder auf dieser Liste kann auch zu viel Bild-Daten statt.
SQL-Abfrage
[Bearbeiten | Quelltext bearbeiten]Die SQL-Abfrage, die ich war:
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;
Output
[Bearbeiten | Quelltext bearbeiten]mysql> \. pei.sql
+--------------------------------------------------------------------+----------+-----------+------------+---------+-------------------------------+----------------+
| concat('*[[:Image:',img_name,']]') | img_size | img_width | img_height | ratio | img_user_text | img_timestamp |
+--------------------------------------------------------------------+----------+-----------+------------+---------+-------------------------------+----------------+
| *[[:Image:07_Staßfurt_Aufheben_der_Mitte_Doreen_Ritzau_2007.jpg]] | 1572029 | 295 | 189 | 28.1953 | Lemi-06 | 20080222163007 |
| *[[:Image:LOGO_Varan.jpg]] | 761489 | 187 | 187 | 21.7761 | MSc | 20061104100441 |
| *[[:Image:Kda_logo.jpg]] | 580480 | 199 | 197 | 14.8070 | Ahellwig | 20071007064829 |
| *[[:Image:KLUDI_Logo_72dpi.jpg]] | 133328 | 283 | 34 | 13.8566 | Nathaniel222 | 20070212121527 |
| *[[:Image:EU-Siegel_(g.U.)_geschützte_Ursprungsbezeichnung.jpg]] | 734365 | 321 | 321 | 7.1269 | Zerohund | 20061212205822 |
| *[[:Image:EU-Siegel_geschützte_geografische_Angabe.jpg]] | 733715 | 321 | 321 | 7.1206 | Zerohund | 20061212210230 |
| *[[:Image:EU-Siegel_garantiert_traditionelle_Spezialität.jpg]] | 706571 | 319 | 319 | 6.9434 | Zerohund | 20061212210850 |
| *[[:Image:U1tvlogo.jpg]] | 591336 | 533 | 220 | 5.0429 | Mblind | 20070322082214 |
| *[[:Image:Leipertitz.jpg]] | 181107 | 161 | 236 | 4.7665 | LeopoldFink | 20070331112211 |
| *[[:Image:Adam_Brandner_08.jpg]] | 1275434 | 490 | 689 | 3.7778 | Ernst Brandner | 20070806145107 |
| *[[:Image:Logo1_mit_Hintergrund.jpg]] | 724563 | 588 | 351 | 3.5107 | Gio1979 | 20070515113810 |
| *[[:Image:JCB_Minibagger_8018.jpg]] | 423749 | 340 | 391 | 3.1875 | ACC | 20061124170151 |
| *[[:Image:Baugruppentraeger.jpg]] | 453254 | 462 | 317 | 3.0949 | Maik schneider | 20070122164852 |
| *[[:Image:Selim-I.jpg]] | 177762 | 235 | 251 | 3.0137 | Martin-vogel | 20040917234939 |
| *[[:Image:Wappen_Rotberg_einzeln.jpg]] | 110470 | 178 | 206 | 3.0127 | Almrar | 20071201134847 |
| *[[:Image:Glockenweihe_im_Dechantanger.jpg]] | 255798 | 255 | 333 | 3.0124 | Marco99 | 20070901183201 |
| *[[:Image:Blue_Straggler_HRD_globular_cluster.jpg]] | 265054 | 333 | 265 | 3.0036 | Rene.andrae | 20071008091612 |
| *[[:Image:Karl_Unterkircher.jpg]] | 950678 | 650 | 487 | 3.0032 | Herbert Mussner | 20071021203734 |
| *[[:Image:Slawische_Sprachen.jpg]] | 735062 | 549 | 446 | 3.0020 | Ixitixel | 20060501120146 |
| *[[:Image:GO!Messenger_Symbol.jpg]] | 391734 | 480 | 272 | 3.0004 | Daniel Fauland | 20080201132836 |
| *[[:Image:Interstellar_extinction_curve.jpg]] | 537222 | 496 | 361 | 3.0003 | Rene.andrae | 20071008095015 |
| *[[:Image:LeMans_StrassenbahnNetz.jpg]] | 589878 | 512 | 384 | 3.0003 | GertGrer | 20071212154831 |
| *[[:Image:Afrikanisches_Einlaufklistier.jpg]] | 832445 | 478 | 613 | 2.8410 | Dr.med.M.Tschannen | 20060921080943 |
| *[[:Image:Kolpingjugend_bunt.jpg]] | 608251 | 772 | 278 | 2.8341 | Oelde | 20061213074602 |
| *[[:Image:BD_1.jpg]] | 106776 | 200 | 196 | 2.7239 | Troopers89 | 20070331114327 |
| *[[:Image:Strassenfertiger_auf_Raedern_lectura.jpg]] | 709227 | 591 | 455 | 2.6375 | Rackm4am | 20080217145337 |
| *[[:Image:LudwigThuille.jpg]] | 2513133 | 798 | 1219 | 2.5835 | Gorge72 | 20060825183924 |
| *[[:Image:Bb-Erosion.jpg]] | 155139 | 283 | 213 | 2.5737 | Furioso | 20060622210648 |
| *[[:Image:Französischer_Irrigator.jpg]] | 1477742 | 724 | 799 | 2.5545 | Dr.med.M.Tschannen | 20060920084357 |
| *[[:Image:VBMariusz_Witeck.jpg]] | 134547 | 194 | 277 | 2.5038 | Viribus unitis | 20070814093228 |
| *[[:Image:Breitscheid_1945.jpg]] | 241963 | 283 | 349 | 2.4498 | Tvwatch | 20071203160305 |
| *[[:Image:Park_griebenow.jpg]] | 1362619 | 1370 | 423 | 2.3513 | Schiwago | 20060421221848 |
| *[[:Image:Historika25_Bracht_1841.jpg]] | 1041099 | 569 | 779 | 2.3488 | Wolfgang Poguntke | 20070712102405 |
| *[[:Image:Graevenitz_Museum.jpg]] | 122715 | 283 | 186 | 2.3313 | ETES | 20070128174819 |
| *[[:Image:Historika25_Schönholthausen_1841.jpg]] | 801479 | 641 | 548 | 2.2817 | Wolfgang Poguntke | 20070717084349 |
| *[[:Image:Logo_ha'atelier.jpg]] | 262346 | 392 | 296 | 2.2610 | Ha'atelier | 20070724124352 |
| *[[:Image:Pfalz1900.jpg]] | 764765 | 598 | 572 | 2.2358 | Olbertz | 20070327170617 |
| *[[:Image:BRAbrisshausII.jpg]] | 500529 | 513 | 442 | 2.2074 | Schütze | 20061008201257 |
| *[[:Image:Angel_10.jpg]] | 429917 | 384 | 512 | 2.1867 | SteveK | 20080226190042 |
| *[[:Image:Ginsengfeld_thumb.jpg]] | 205612 | 369 | 255 | 2.1852 | Gesine Wischmann | 20070120144904 |
| *[[:Image:Klausener_1945.jpg]] | 214776 | 289 | 341 | 2.1794 | Tvwatch | 20071203155015 |
| *[[:Image:Praefektur_Loewenburg.jpg]] | 278785 | 519 | 247 | 2.1747 | Olbertz | 20070408081916 |
| *[[:Image:Qatruni.jpg]] | 732416 | 460 | 734 | 2.1692 | Peter.kremer | 20070321045936 |
| *[[:Image:Faroe_stamp_523_drunnhvÃti.jpg]] | 139894 | 283 | 228 | 2.1681 | Arne List | 20050804163752 |
| *[[:Image:Carl_Mathies_1905.jpg]] | 2337369 | 900 | 1204 | 2.1570 | Flo Beck | 20071214105819 |
| *[[:Image:Historika25_Elspe_1841.jpg]] | 1924847 | 1160 | 770 | 2.1550 | Wolfgang Poguntke | 20070712090915 |
| *[[:Image:Bbm_guido_kirsch_freiburg.jpg]] | 128660 | 283 | 211 | 2.1546 | Olafbbm | 20080106183812 |
| *[[:Image:Vancouver_Island_1900.jpg]] | 355586 | 417 | 398 | 2.1425 | Olbertz | 20070527100149 |
| *[[:Image:Historika25_Bamenohl_1840.jpg]] | 785997 | 539 | 683 | 2.1351 | Wolfgang Poguntke | 20070712083221 |
| *[[:Image:Historika25_Oedingen_1841.jpg]] | 1929931 | 1148 | 788 | 2.1334 | Wolfgang Poguntke | 20070712095137 |
| *[[:Image:Luterseeberg.jpg]] | 111083 | 283 | 184 | 2.1333 | Muntafu | 20051129201632 |
| *[[:Image:Heinrich_Christian_Sander_1905.jpg]] | 2505336 | 926 | 1269 | 2.1320 | Flo Beck | 20071126225941 |
| *[[:Image:SF_St.jpg]] | 685935 | 1170 | 275 | 2.1319 | Starfinanz | 20060830092750 |
| *[[:Image:Broeltal1905.jpg]] | 786466 | 775 | 478 | 2.1230 | Olbertz | 20070210095912 |
| *[[:Image:Hamburger_Flutdenkmal_1890.jpg]] | 2004300 | 1327 | 713 | 2.1184 | Der Bischof mit der E-Gitarre | 20070910010829 |
| *[[:Image:Julius_Engel_1905.jpg]] | 4038920 | 1174 | 1632 | 2.1080 | Flo Beck | 20070717001432 |
| *[[:Image:Herrschaft_Gimborn.jpg]] | 222041 | 337 | 313 | 2.1050 | Olbertz | 20080222192536 |
| *[[:Image:Georg_Christian_Thilenius_1905.jpg]] | 4108147 | 1209 | 1615 | 2.1040 | Flo Beck | 20070716232017 |
| *[[:Image:Historika25_Borghausen_1840.jpg]] | 1045526 | 623 | 806 | 2.0821 | Wolfgang Poguntke | 20070717081435 |
| *[[:Image:Otto_Eduard_Westphal_1905.jpg]] | 2250394 | 874 | 1237 | 2.0815 | Flo Beck | 20071214190657 |
| *[[:Image:Gustav_Ferdinand_Hertz_1904.jpg]] | 2627949 | 978 | 1295 | 2.0750 | Flo Beck | 20071126224608 |
| *[[:Image:4415402.jpg]] | 1622016 | 1024 | 768 | 2.0625 | HeizDampf | 20070820180745 |
| *[[:Image:Kangal_sally_10.jpg]] | 122871 | 300 | 199 | 2.0581 | Kangal-de | 20070901193816 |
| *[[:Image:Gottfried_Holthusen_1905.jpg]] | 2487552 | 926 | 1308 | 2.0538 | Flo Beck | 20071209224643 |
| *[[:Image:Max_Schinckel_1905.jpg]] | 2301060 | 861 | 1302 | 2.0526 | Flo Beck | 20071217004547 |
| *[[:Image:Albert_Wolffson_1905.jpg]] | 2676860 | 978 | 1334 | 2.0518 | Flo Beck | 20071126231300 |
| *[[:Image:Hugo_Schnars-Alquist_1905.jpg]] | 2338782 | 900 | 1276 | 2.0366 | Flo Beck | 20071126231736 |
| *[[:Image:Schaumwein.jpg]] | 552071 | 640 | 427 | 2.0202 | Frank Papenbroock | 20061008232800 |
| *[[:Image:Broeker_1905_jacobi.jpg]] | 4125065 | 1201 | 1701 | 2.0192 | Flo Beck | 20071015105256 |
| *[[:Image:Paul_Hoecker_-_Hoecker-Haus_-_Winter_1880.jpg]] | 4134763 | 1754 | 1172 | 2.0114 | Wikihard | 20060906203327 |
| *[[:Image:Letoon_theater_axb01.jpg]] | 1041486 | 879 | 590 | 2.0082 | Axb | 20041019213504 |
| *[[:Image:Conrad_Schemmann_1905.jpg]] | 2544214 | 1004 | 1263 | 2.0064 | Flo Beck | 20071217005014 |
| *[[:Image:Cache.jpg]] | 193040 | 450 | 214 | 2.0046 | Wastl218700 | 20070511025543 |
+--------------------------------------------------------------------+----------+-----------+------------+---------+-------------------------------+----------------+
73 rows in set (25.08 sec)