select webflatfileid, comname, sciname, webflatfile.vcode, rating, Day, height, width, spcode, photodata, country_state, locality, age, sex, month, dname, comments from webflatfile left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND country_state LIKE '%Lord% Howe% Island%'
select webflatfileid, comname, sciname, webflatfile.vcode, rating, Day, height, width, spcode, photodata, country_state, locality, age, sex, month, dname, comments from webflatfile left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND country_state LIKE '%Lord% Howe% Island%' order by spcode, comname, rating DESC LIMIT 100
|
White-bellied Storm-Petrel Fregetta grallaria |
h47/1/126 White-bellied Storm-Petrel | h47/1/125 White-bellied Storm-Petrel |
Providence Petrel Pterodroma solandri |
|
Kermadec Petrel Pterodroma neglecta |
s51/5/010 Kermadec Petrel | h47/1/044 Kermadec Petrel | h47/1/045 Kermadec Petrel |
Black-winged Petrel Pterodroma nigripennis |
s51/5/013 Black-winged Petrel | s51/5/014 Black-winged Petrel |
Flesh-footed Shearwater Puffinus carneipes |
h47/1/033 Flesh-footed Shearwater | h47/1/034 Flesh-footed Shearwater | h47/1/035 Flesh-footed Shearwater | h47/1/028 Flesh-footed Shearwater |
h47/1/029 Flesh-footed Shearwater | h47/1/030 Flesh-footed Shearwater | h47/1/031 Flesh-footed Shearwater | h47/1/032 Flesh-footed Shearwater |
h47/1/036 Flesh-footed Shearwater | h47/1/037 Flesh-footed Shearwater | h47/1/038 Flesh-footed Shearwater | h47/1/039 Flesh-footed Shearwater |
h47/1/040 Flesh-footed Shearwater |
Wedge-tailed Shearwater Puffinus pacificus |
h47/1/122 Wedge-tailed Shearwater | h47/1/121 Wedge-tailed Shearwater |
Red-tailed Tropicbird Phaethon rubricauda |
h47/1/085 Red-tailed Tropicbird | h47/1/091 Red-tailed Tropicbird | h47/1/092 Red-tailed Tropicbird | h47/1/093 Red-tailed Tropicbird |
h47/1/096 Red-tailed Tropicbird | h47/1/097 Red-tailed Tropicbird | h47/1/098 Red-tailed Tropicbird | h47/1/099 Red-tailed Tropicbird |
h47/1/100 Red-tailed Tropicbird | h47/1/101 Red-tailed Tropicbird | h47/1/102 Red-tailed Tropicbird | h47/1/086 Red-tailed Tropicbird |
h47/1/087 Red-tailed Tropicbird | h47/1/088 Red-tailed Tropicbird | h47/1/089 Red-tailed Tropicbird | h47/1/090 Red-tailed Tropicbird |
h47/1/094 Red-tailed Tropicbird | h47/1/095 Red-tailed Tropicbird |
Masked Booby Sula dactylatra |
h47/1/054 Masked Booby | h47/1/055 Masked Booby | h47/1/047 Masked Booby | h47/1/048 Masked Booby |
h47/1/049 Masked Booby | h47/1/050 Masked Booby | h47/1/051 Masked Booby | h47/1/052 Masked Booby |
h47/1/053 Masked Booby | h47/1/057 Masked Booby | h47/1/058 Masked Booby | h47/1/059 Masked Booby |
h47/1/061 Masked Booby | h47/1/062 Masked Booby | h47/1/063 Masked Booby | h47/1/064 Masked Booby |
h47/1/065 Masked Booby | h47/1/068 Masked Booby | h47/1/056 Masked Booby | h47/1/060 Masked Booby |
h47/1/066 Masked Booby | h47/1/067 Masked Booby |
Pacific Black Duck Anas superciliosa |
h47/1/070 Pacific Black Duck |
Buff-banded Rail Rallus philippensis |
h47/1/015 Buff-banded Rail | h47/1/016 Buff-banded Rail |
Lord Howe Woodhen Gallirallus sylvestris |
h47/1/142 Lord Howe Woodhen | h47/1/137 Lord Howe Woodhen | h47/1/141 Lord Howe Woodhen | h47/1/143 Lord Howe Woodhen |
s66/3/003 Lord Howe Woodhen | s66/3/003 Lord Howe Woodhen | s66/3/004 Lord Howe Woodhen | s66/3/004 Lord Howe Woodhen |
s66/3/009 Lord Howe Woodhen | s66/3/009 Lord Howe Woodhen | h47/1/138 Lord Howe Woodhen | h47/1/139 Lord Howe Woodhen |
h47/1/140 Lord Howe Woodhen | s66/3/005 Lord Howe Woodhen | s66/3/006 Lord Howe Woodhen | s66/3/007 Lord Howe Woodhen |
s66/3/008 Lord Howe Woodhen | s66/3/008 Lord Howe Woodhen | s66/3/010 Lord Howe Woodhen | s66/3/010 Lord Howe Woodhen |
|
Purple Swamphen Porphyrio porphyrio |
h47/1/023 Purple Swamphen |
Double-banded Plover Charadrius bicinctus |
h47/1/021 Double-banded Plover |
Oriental Plover Charadrius veredus |
h47/1/069 Oriental Plover |
South Island Oystercatcher Haematopus finschi |
h47/1/072 South Island Oystercatcher |