SELECT *, IF(H = 'yes','H','') AS h, DATE_FORMAT(lights.modified,'%M %d, %Y') AS date FROM lights LEFT JOIN states ON lights.stateID = states.stateID LEFT JOIN locations ON lights.location_id = locations.location_id WHERE lights.location_id = 'ALK' AND number = 14 AND H = 'no' AND suffix = ''

The information contained within the ARLHS World List of Lights is Copyright 2003-2026 ARLHS, LLC.
Visit ARLHS for usage information.

Database HTML Rendering Programs, MySQL Schema and Web Site Content (excluding the actual lighthouse data)
Copyright 2006-2026 John Huggins
PHP/MySQL Database Engine: $Revision: 1.90 $
Lighthouse Display Program: $Revision: 1.50 $