User:Jan Steinman/Lens coatings/Search

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
Line 22: Line 22:
   WHERE g.Display_name  LIKE '%%SeArCh%%'
   WHERE g.Display_name  LIKE '%%SeArCh%%'
|message=Search the `Lens Name` field for:  
|message=Search the `Lens Name` field for:  
-
|pg_rec_count=SELECT FORMAT(COUNT(*), 0) FROM Photo_OM_Lens_Coatings WHERE 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
|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 22:11, 21 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