User:Gmaxwell/math fu

mysql> select concat('*',mp.page_title,' - ',ip.page_title) from page as lp join pagelinks on pl_from=lp.page_id join page as mp on (mp.page_title=pl_title and mp.page_namespace=0) join imagelinks on il_from=mp.page_id join page as ip on ip.page_title=il_to and ip.page_namespace=6 where lp.page_namespace=0 and pl_namespace=0 and lp.page_title like 'List_of_mathematics_articles%' and exists (select 1 from templatelinks where tl_from=ip.page_id and tl_namespace=10 and tl_title like 'Non-free%') and ip.page_title!='Commons-logo.svg' group by mp.page_title, ip.page_title order by mp.page_title, ip.page_title;]]

A

 * 20_(number) - Image:Tv_sesame_street_20_chairs.jpg
 * 3_(number) - Image:SicilyFlag.gif
 * 47_(number) - Image:S70.jpg
 * 70_(number) - Image:Tv_sesame_street_joe_70.jpg
 * 7_(number) - Image:Seven_Days_of_Creation_-_1765.jpg
 * 86_(number) - Image:Intel_8086.jpg
 * A_Beautiful_Mind_(book) - Image:A_Beautiful_Mind_(book).JPG
 * A_Beautiful_Mind_(film) - Image:A-beautiful-mind-3.jpg
 * A_Million_Random_Digits_with_100,000_Normal_Deviates - Image:Random_digits.png
 * American_Journal_of_Mathematics - Image:AmJM.jpg
 * American_Mathematical_Monthly - Image:A_M_Monthly.jpg
 * American_Mathematical_Society - Image:American_Mathematical_Society.gif
 * American_Regions_Mathematics_League - Image:Amercian_Regions_Math_League_logo.jpg
 * Arcadia_(play) - Image:Arcadia_book.jpg
 * Artificial_neural_network - Image:Annexample2.png
 * Artificial_neural_network - Image:LeabraScreenShot.jpg
 * Association_for_Women_in_Mathematics - Image:AssociationForWomenInMathematics.gif
 * Asymptote - Image:1-over-x-plus-x.png
 * Asymptote - Image:1-over-x.png
 * Australian_Aboriginal_enumeration - Image:Australian_Aboriginal_Flag.svg
 * Australian_Aboriginal_enumeration - Image:Torres_Strait_Islanders_Flag.svg
 * Avicenna - Image:Avicenna.jpg
 * Big_Numbers - Image:FUMBIG05.jpg
 * Binary_prefix - Image:Apple_Macintosh_Desktop.png
 * Binary_prefix - Image:Seagate_160_GB_hard_drive_box.jpg
 * Binary_prefix - Image:Windows_XP_C_partition_properties.png
 * Binary_prefix - Image:Windows_XP_Disk_management_for_160_GB_disk.png
 * Binary_prefix - Image:Windows_XP_Drive_Properties_for_160_GB_disk.png
 * Bioinformatics - Image:Genome_viewer_screenshot_small.png - its actually PD-USgov
 * Book_of_Optics - Image:Alhazen's_book.jpg
 * Book_of_Optics - Image:Ibn_haithem_portrait.jpg
 * Bézier_curve - Image:Bézier_curve_in_Adobe_Illustrator_CS2.png
 * Cabri_3D - Image:Cabri_3D.JPG
 * Calabi–Yau_manifold - Image:Calabi-Yau.jpeg
 * Calculator - Image:CRAZY_copy.gif
 * Carry_On,_Mr._Bowditch - Image:JeanLeeLatham_CarryOnMrBowditch.jpg
 * Charlie_Eppes - Image:Mathematics_and_Numb3rs.jpg
 * Charlie_Eppes - Image:Professor_Charlie_Eppes.jpg
 * Chebyshev-Markov-Stieltjes_inequalities - Image:Pafnutiy-chebyshev.jpg
 * Concrete_Mathematics - Image:Concrete_Mathematics_-_Cover.png
 * Corner - Image:Corner.jpg
 * Cryptonomicon - Image:Cryptonomicon(1stEd).jpg
 * Cube_(film) - Image:Cube_The_Movie_Poster_Art.jpg

D

 * Diffusion-limited_aggregation - Image:Lomas_aggregation_012.jpg
 * Dirk_Niblick_of_the_Math_Brigade - Image:Mr_Beasley_and_Dirk_Niblick.jpg
 * Donald_in_Mathmagic_Land - Image:Donald_mathjam.png
 * Dot_book - Image:Drill_sheet.jpg
 * Evolution_and_the_Theory_of_Games - Image:Evolution_and_the_Theory_of_Games.jpg
 * FSU_Young_Scholars_Program - Image:FSU_seal.png
 * Five-pointed_star - Image:Oes_GGC_color.PNG
 * Fundamental_theorem_of_calculus - Image:Donald_Duck_Fundamental_Theorem_Calculus.jpg
 * GEUP - Image:Geup3.png
 * GEUP - Image:Geup3_icon.png
 * GEUP - Image:Geup3_scr1.png
 * Geometry - Image:Calabi-Yau.jpeg
 * Golden_ratio - Image:Modulor-Modulor2.jpg
 * Good_Will_Hunting - Image:Good_Will_Hunting.jpg
 * Good_Will_Hunting - Image:Good_will_h.jpg
 * Gödel,_Escher,_Bach - Image:Escher_Waterfall.jpg
 * Gödel,_Escher,_Bach - Image:GEBcover.jpg
 * Hardy-Weinberg_principle - Image:Wilhelm_Weinberg.jpg
 * Hex_(board_game) - Image:Hexyscreenshot.jpg
 * Hexagon - Image:Hexagonal_mud_flats_in_Death_Valley.jpg
 * Hexagram - Image:Raelian_symbols.svg
 * Historia_Mathematica - Image:Historia_Mathematica.gif
 * How_to_Lie_with_Statistics - Image:How_to_Lie_with_Statistics.jpg
 * Hypercycle_(geometry) - Image:Escher_Circle_Limit_III.jpg
 * I.Q._(film) - Image:IQposter.jpg
 * Indian_Statistical_Institute - Image:ISI.gif
 * International_Society_for_Bayesian_Analysis - Image:ISBAlogo.gif
 * Inventiones_Mathematicae - Image:InventMath.jpg
 * Isis_(journal) - Image:Isis_(journal).gif
 * Isometric_projection - Image:ExampleSimCityCity.PNG
 * Isometric_projection - Image:Knight_lore_3.gif
 * Journal_of_Number_Theory - Image:JNumberTh.jpg
 * Journal_of_Symbolic_Computation - Image:JSC-cover.jpg
 * Journal_of_the_American_Mathematical_Society - Image:Journal_AMS.jpg

K

 * K-means_algorithm - Image:Pic24.jpg This and following three images were produced by software written by User:GfxGuy and he has released them under GFDL.
 * K-means_algorithm - Image:Pic25.jpg
 * K-means_algorithm - Image:Pic26.jpg
 * K-means_algorithm - Image:Pic27.jpg
 * Kepler-Poinsot_polyhedron - Image:Gravitation.png
 * Knot_theory - Image:SnapPea-horocusp_view.png (note SnapPea is free software GPL so image OK)
 * LaTeX - Image:LaTeX_Document_in_Apple_Preview.png
 * Lateralus_(song) - Image:L4T3R4LUS.JPG
 * List_of_planar_symmetry_groups - Image:SnowflakeKenLibbrecht.jpg
 * Math_Curse - Image:Mathcurse.jpg
 * Mathcounts - Image:Mathcounts_logo.gif
 * Mathematica - Image:Spikey_v6-small.png
 * Mathematical_Kangaroo - Image:Kenguru_logotip.png
 * Mathematical_Reviews - Image:FRAMS.jpg
 * Mathematics - Image:Rubik_float.png
 * Mathematics_Magazine - Image:Mathmag.gif
 * Mathematics_education_in_New_York - Image:Matha_s.gif
 * Mathematics_education_in_New_York - Image:Ny_ab_cover.jpg
 * Mathematics_education_in_New_York - Image:Ny_b_cover.jpg
 * Mathnet - Image:Mathnet.jpg
 * Matita_proof_assistant - Image:Matita_logo.png
 * Matita_proof_assistant - Image:Matita_screenshot.png
 * Max-Planck-Institut_für_Mathematik - Image:Minerva_logo.gif
 * Max_Planck_Institute_for_Mathematics_in_the_Sciences - Image:Minerva_logo.gif
 * Men_of_Mathematics - Image:Men_of_Mathematics.JPG
 * Minitab - Image:Minitab.jpg
 * Moiré_pattern - Image:TVscreen.jpg
 * Moscow_Mathematical_Journal - Image:Moscow_Mathematical_Journal.gif
 * Moscow_Mathematical_Papyrus - Image:Mpap.JPG
 * Moscow_Mathematical_Society - Image:MMO1.jpg
 * Mu_Alpha_Theta - Image:Mu_alpha_theta.gif
 * Murderous_Maths - Image:Murderous_Maths.jpg
 * Normal_distribution - Image:1993-DM-10.jpg
 * Notices_of_the_American_Mathematical_Society - Image:NAMS.jpg
 * Numb3rs - Image:Mathematical_Model.jpg
 * Numb3rs - Image:NUMB3RS_Season2_DVD.jpg
 * Numb3rs - Image:NUMB3RS_season1_dvd_cover.jpg
 * Numb3rs - Image:Numb3rsCastorig.jpg
 * Numb3rs - Image:Numb3rs_Insignia.jpg
 * Numerical_Recipes - Image:Numerical_Recipes_in_Fortran.JPG
 * Oblique_projection - Image:Ultima_VII_The_Black_Gate_-_entry_into_Brittania.jpg
 * PARI/GP - Image:PARI-GP-Windows-XP.png
 * Pacific_Journal_of_Mathematics - Image:PacificJMath.jpg
 * Permutation_(music) - Image:Webern_concerto_tone_row.png
 * Prime95 - Image:Prime95.jpg
 * Prime_Obsession - Image:Prime_Obsession.JPG
 * Proceedings_of_the_American_Mathematical_Society - Image:PAMS.jpg
 * Professor_Moriarty - Image:Eric_Porter_as_Moriarty.jpg
 * Professor_Moriarty - Image:James_Moriarty_(The_League_of_Extraordinary_Gentlemen).jpg
 * Professor_Moriarty - Image:TV_star_trek_TNG_moriarty.jpg
 * Professor_Moriarty - Image:WITHOUT_A_CLUE_-_01hr_08min_47sec.jpg
 * Proof_(2005_film) - Image:Proof_poster.jpg
 * Proofs_and_Refutations - Image:ProofRefute.jpg
 * Quantitative_analyst - Image:Markowitz_1.jpg

R

 * Rabdology - Image:Rabdology_Cover_Page.jpg
 * Random_number_table - Image:Random_digits.png
 * Regular_Division_of_the_Plane - Image:Escher,_Regular_Division_of_the_Plane_I.jpg
 * Regular_Division_of_the_Plane - Image:Escher,_Regular_Division_of_the_Plane_II.jpg
 * Regular_Division_of_the_Plane - Image:Escher,_Regular_Division_of_the_Plane_III.jpg
 * Regular_Division_of_the_Plane - Image:Regular_Division_of_the_Plane_124.jpg
 * Regular_Division_of_the_Plane - Image:Regular_Division_of_the_Plane_21.jpg
 * Regular_Division_of_the_Plane - Image:Regular_Division_of_the_Plane_42.jpg
 * Regular_Division_of_the_Plane - Image:Regular_Division_of_the_Plane_70.jpg
 * Regular_Division_of_the_Plane - Image:Regular_Division_of_the_Plane_72.jpg
 * Retired_numbers_in_football_(soccer) - Image:Flag_of_Cameroon.svg
 * Robert_Byrd - Image:7394776.jpg
 * Robert_Byrd - Image:RCB_sidewalk.jpg
 * Rough_set - Image:Rough_sets_cover.png
 * Rubik's_Cube - Image:Rubiks_cube_newsletter.jpg
 * Rubik's_Cube_group - Image:Rubik_float.png
 * S.O.S._Mathematics - Image:Logo-cyberboard.png
 * S.O.S._Mathematics - Image:Sosmath-logo.png
 * Santa_Fe_Institute - Image:SFILogo.gif
 * Simultaneous_equations - Image:Simultaneous_equations_example_1.png
 * Slashed_zero - Image:SlashedZero.png
 * Small_stellated_dodecahedron - Image:Gravitation.png
 * Soap_bubble - Image:Zubble.JPG
 * Society_for_Industrial_and_Applied_Mathematics - Image:Siam-logo.gif
 * Sophie_Neveu - Image:Picsony2006-15.jpg
 * Soviet_Student_Olympiads - Image:KazakhStudentOlympiadDiploma.jpg
 * Spaceland_(novel) - Image:Spaceland_novel.jpg
 * Sphadikam - Image:Sphadikam.jpg
 * Spreadsheet - Image:Microsoft_Office_Excel_2007.png
 * Spreadsheet - Image:VisiCalc_(IBM_PC's_Killer_Application).PNG
 * Square_One_(TV_series) - Image:Squareone_logo.jpg
 * Stand_and_Deliver - Image:Stand_and_deliver.jpg
 * Stata - Image:Stata.png
 * Steklov_Institute_of_Mathematics - Image:Mian1.jpg
 * String_theory - Image:Calabi-Yau.jpeg
 * String_theory - Image:Calabi-Yau_art.jpg
 * Sudoku - Image:SudokuLive2.jpg
 * Superconductivity - Image:Superconductor_quench.jpg
 * Symmetry - Image:Navajo_blanket.jpg
 * Symmetry_(biology) - Image:Bilateral_symmetry.png

T

 * Tessellation - Image:Escher_Circle_Limit_III.jpg
 * Tesseract - Image:Dali_Crucifixion_hypercube.jpg
 * Texas_Math_and_Science_Coaches_Association - Image:TMSCAlogo.gif
 * The_Curious_Incident_of_the_Dog_in_the_Night-time - Image:Curiousincidentofdoginnighttime.jpg
 * The_Dot_and_the_Line - Image:The_dot_and_the_line.jpg
 * The_Fourth_Dimension_(book) - Image:Rucker4d.jpg
 * The_Geometer's_Sketchpad - Image:Geometer's_Sketchpad_Icon.png
 * The_Geometer's_Sketchpad - Image:Geometer's_Sketchpad_circumcircle.png
 * The_Geometer's_Sketchpad - Image:Gsp.png
 * The_Library_of_Babel - Image:Borges_Argentine_postage_stamp.jpg
 * The_Magical_Bag_of_Mathematical_Tricks - Image:Mbmt.JPG
 * The_Mathematical_Intelligencer - Image:Mathematical_Intelligencer.jpg
 * The_Parrot's_Theorem - Image:DenisGuedj_TheParrot'sTheorem.jpg
 * The_Swallow's_Tail - Image:The_Swallowtail.jpg
 * The_Wright_3 - Image:Wright3.jpg
 * Theoretical_and_experimental_justification_for_the_Schrödinger_equation - Image:Max-Planck-und-Albert-Einstein.jpg
 * Theoretical_and_experimental_justification_for_the_Schrödinger_equation - Image:Schrdngr.jpg
 * Theory_of_Games_and_Economic_Behavior - Image:VNM-TGEB.jpg
 * Through_and_through - Image:Drypoint-prometheus.jpg
 * Tractatus_Logico-Philosophicus - Image:Wittgenstein-tractatus-ogden.JPG
 * Transactions_of_the_American_Mathematical_Society - Image:TAMS.jpg
 * Uncle_Petros_and_Goldbach's_Conjecture - Image:Petros.gif
 * University_of_Chicago_School_Mathematics_Project - Image:Ucsmp_coversjpeg.JPG
 * Vector_quantization - Image:Vector_quantization_2.gif
 * Vedic_Mathematics_(book) - Image:Vedicmathematics.jpg
 * We_All_Use_Math_Every_Day - Image:Numbers_math_promo.gif
 * White_noise - Image:Whitenoise.png
 * Wormhole - Image:Bajoran_wormhole.jpg
 * Wormhole - Image:SG-1_True_Science_Wormhole.jpg
 * Zentralblatt_MATH - Image:Zentralblatt.gif
 * Zome - Image:Zome_logo.png
 * Π_(film) - Image:Pi_DVD.jpg

204 rows in set (1.20 sec)]]