select t1.*, t2.photo_link, t2.photo_id, t2.comments
from county as t1
left join photo_table as t2 on t1.coid=t2.coid 
where t1.id='16080' and photo_link is not NULL
order by t2.date_c desc|  Species Photo Gallery for Idiodonus kennicotti No Common Name 15 | 
|  | Photo by: Ted Wilcox Watauga Co.
 Comment: unid_leafhopper
 |  | Photo by: Ted Wilcox Watauga Co.
 Comment: unid_leafhopper
 | 
|  | Photo by: Scott Bolick Montgomery Co.
 Comment:
 |  | Photo by: Scott Bolick Montgomery Co.
 Comment:
 | 
|  | Photo by: Scott Bolick Montgomery Co.
 Comment:
 |  | Photo by: Scott Bolick Montgomery Co.
 Comment:
 | 
|  | Photo by: Scott Bolick Montgomery Co.
 Comment:
 |  | Photo by:  Rob Van Epps Mecklenburg Co.
 Comment:
 | 
|  | Photo by:  Rob Van Epps Mecklenburg Co.
 Comment:
 |  | Photo by: Tracy S Feldman Scotland Co.
 Comment: unid_leafhopper
 | 
|  | Photo by: Tracy S Feldman Scotland Co.
 Comment: unid_leafhopper
 |  | Photo by: Kyle Kittelberger, Brian Bockhahn, Paul Scharf Avery Co.
 Comment: edge of grassy, brushy field-type habitat in old christmas tree farm; forest edge
 | 
|  | Photo by: Kyle Kittelberger, Brian Bockhahn, Paul Scharf Avery Co.
 Comment: edge of grassy, brushy field-type habitat in old christmas tree farm; forest edge
 |  | Photo by: Kyle Kittelberger, Brian Bockhahn, Paul Scharf Avery Co.
 Comment: edge of grassy, brushy field-type habitat in old christmas tree farm; forest edge
 | 
|  | Photo by: Kyle Kittelberger, Brian Bockhahn, Paul Scharf Avery Co.
 Comment: edge of grassy, brushy field-type habitat in old christmas tree farm; forest edge
 |