Benutzer:Kylu/pei

aus Wikipedia, der freien Enzyklopädie
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.

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;
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)