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='17761' and photo_link is not NULL
order by t2.date_c desc|  Species Photo Gallery for Alebra elegans No Common Name 21 | 
|  | Photo by:  Marilyn Westphal Henderson Co.
 Comment: Attracted to uv light sheet
 |  | Photo by: Scott Bolick Wilkes Co.
 Comment:
 | 
|  | Photo by: Ted Wilcox Watauga Co.
 Comment: unid_leafhopper
 |  | Photo by: Ted Wilcox Watauga Co.
 Comment: unid_leafhopper
 | 
|  | Photo by: Ted Wilcox Watauga Co.
 Comment: unid_leafhopper
 |  | Photo by: Ted Wilcox Watauga Co.
 Comment: unid_leafhopper
 | 
|  | Photo by: Ted Wilcox Watauga Co.
 Comment: unid_leafhopper
 |  | Photo by: Ted Wilcox Watauga Co.
 Comment: unid_leafhopper
 | 
|  | Photo by: Ted Wilcox Watauga Co.
 Comment: unid_leafhopper
 |  | Photo by: Scott Bolick Davie Co.
 Comment:
 | 
|  | Photo by: Scott Bolick Forsyth  Co.
 Comment:
 |  | Photo by: Scott Bolick Forsyth  Co.
 Comment:
 | 
|  | Photo by: Scott Bolick Forsyth  Co.
 Comment:
 |  | Photo by: Scott Bolick Forsyth  Co.
 Comment:
 | 
|  | Photo by: Scott Bolick Forsyth  Co.
 Comment:
 |  | Photo by: Robert Meehan Durham Co.
 Comment: Per K. Kittleberger, potentially A. elegans
 | 
|  | Photo by: Robert Meehan Durham Co.
 Comment: Per K. Kittleberger, potentially A. elegans
 |  | Photo by: Robert Meehan Durham Co.
 Comment:
 | 
|  | Photo by: Robert Meehan Durham Co.
 Comment:
 |  | Photo by: Robert Meehan Durham Co.
 Comment: Per K. Kittleberger, may represent A. elegans
 | 
|  | Photo by: Robert Meehan Durham Co.
 Comment: Per K. Kittleberger, may represent A. elegans
 |