User:Jan Steinman/Lens coatings/Search

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
Line 16: Line 16:
   t.num_coatings `Coatings`,
   t.num_coatings `Coatings`,
   t.reflection_colour `Reflection`,
   t.reflection_colour `Reflection`,
 +
  t.reflection_image `Reflection Image`,
   concat('<a href="', t.URL, '">link</a>') `Link`,
   concat('<a href="', t.URL, '">link</a>') `Link`,
   t.notes `Notes`
   t.notes `Notes`
Line 24: Line 25:
|pg_rec_count=SELECT FORMAT(COUNT(*), 0) FROM Photo_OM_Lens_Coatings t LEFT JOIN Photo_Gear g ON t.Photo_Gear_ID = g.ID WHERE g.Display_name  LIKE '%%SeArCh%%'
|pg_rec_count=SELECT FORMAT(COUNT(*), 0) FROM Photo_OM_Lens_Coatings t LEFT JOIN Photo_Gear g ON t.Photo_Gear_ID = g.ID WHERE g.Display_name  LIKE '%%SeArCh%%'
|pg_count=25
|pg_count=25
 +
|image_columns=11
|long_text_column_size=30
|long_text_column_size=30
|long_text_columns=4 5 6
|long_text_columns=4 5 6
|database=Personal}}
|database=Personal}}

Revision as of 01:13, 22 November 2020

If you would like to contribute to this database, please first ensure that your lenses are not in it yet. Then please send a message containing all the fields of your lens(es) to Jan, and I will add your lenses to the database. I will use your name in the `Notes` field unless you ask that I do not. (Just your name; I will not make your email address public in any way.)

After performing a search, click on the "page" tab to initiate a different search. Enter a single space to see all records, 25 at a time.

Records

Search the `Lens Name` field for:

Share your opinion


blog comments powered by Disqus
Personal tools
Get our newsletter!
Name:
Email Address:

disturbance
entry points
help (off site)
Environmental jobs, green volunteering, good work! Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro