1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Merikotkas' and s.NAME='Alisa'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '174' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Merikotkas' and s.NAME='Amelia'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '173' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Merikotkas' and s.NAME='Boy'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '137' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Merikotkas' and s.NAME='Dora'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '190' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Merikotkas' and s.NAME='Hanna'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '154' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Merikotkas' and s.NAME='Maria'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '189' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Merikotkas' and s.NAME='Olev'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '148' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Merikotkas' and s.NAME='Saara'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '191' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Must-toonekurg' and s.NAME='Kergu'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '193' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Must-toonekurg' and s.NAME='Kuremari'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '204' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Must-toonekurg' and s.NAME='Nurme'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '182' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Ahjapoeg2 2020'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '177' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Elistvere 2020'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '179' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Evald 2020'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '163' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Kanepi M'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '214' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Kiir'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '216' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Kokora F'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '209' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Kriimani '  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '211' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Lootvina 2020'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '180' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Mustakurmu juv'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '210' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Paju'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '213' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Rein 2020'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '181' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Savitamme F'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '208' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Soits 1'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '143' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Soits 3'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '206' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Soits F'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '212' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Vilja'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '159' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Sookurg' and s.NAME='Võnnu'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '207' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Suur-konnakotkas' and s.NAME='Blond'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '120' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Suur-konnakotkas' and s.NAME='Denisa'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '123' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Suur-konnakotkas' and s.NAME='Linda'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '198' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Suur-konnakotkas' and s.NAME='Priit'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '150' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Suur-konnakotkas' and s.NAME='Tur'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '126' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Aire'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '188' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Holger'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '170' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Jaan'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '68' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Jaana'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '169' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Karin'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '45' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Kärsu'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '199' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Magnus'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '50' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Rita'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '168' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Sahar M'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '201' ORDER BY ORDERNO asc 1054: Unknown column 'EN._COMMENT' in 'field list' 
select g.DATE as Date, TIME as Time, YCOORD as 'Latitude(N)', XCOORD as 'Longitude(E)',
                                            '0' as Speed, '0' as Course, ALTI as 'Altitude(m)', EN._COMMENT as Notes,
                                            s.VAARTUS as Color, s.EN._DESCR as Description, e.EN._DESCR as Spdescr,
                                            s.ID as SID, b.ID as FILEID, e.ID as SPECID, b.FILENAME, s.EN._NAME as LANG_NAME, s.NAME as NAME
                                            from gpsdata g
                                            join species s on g.SPID=s.ID
                                            join spec e on s.SPID=e.ID
                                            join sp_names_sub o on e.ID=o.SPID and o.LANGID=1
                                            left join bindata b on b.ID=e.ICON
                                            where  YEAR='2024' and PERIOD in ('Spring')  and o.SLNAME='Väike-konnakotkas' and s.NAME='Taavi'  order by g.DATE, g.TIME asc  1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT concat(convert(PILT, char),'_',b.FILENAME) as FILE , EN._PILTDESCR as DESCR  FROM images i  INNER JOIN bindata b on b.ID = PILT WHERE SPID = '200' ORDER BY ORDERNO asc 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Merikotkas'' at line 2 

				SELECT
					(SELECT SLNAME FROM sp_names_sub WHERE SPID = sps.SPID AND LANGID = ) as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Merikotkas' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT
					PILT,
					b.FILENAME,
					EN._PILTDESCR as DESCR
				FROM spec_images i
				INNER JOIN bindata b on b.ID = PILT
				WHERE SPECID = ''
				ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM spec WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Must-toonekurg'' at line 2 

				SELECT
					(SELECT SLNAME FROM sp_names_sub WHERE SPID = sps.SPID AND LANGID = ) as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Must-toonekurg' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT
					PILT,
					b.FILENAME,
					EN._PILTDESCR as DESCR
				FROM spec_images i
				INNER JOIN bindata b on b.ID = PILT
				WHERE SPECID = ''
				ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM spec WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Sookurg'' at line 2 

				SELECT
					(SELECT SLNAME FROM sp_names_sub WHERE SPID = sps.SPID AND LANGID = ) as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Sookurg' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT
					PILT,
					b.FILENAME,
					EN._PILTDESCR as DESCR
				FROM spec_images i
				INNER JOIN bindata b on b.ID = PILT
				WHERE SPECID = ''
				ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM spec WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Suur-konnakotkas'' at line 2 

				SELECT
					(SELECT SLNAME FROM sp_names_sub WHERE SPID = sps.SPID AND LANGID = ) as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Suur-konnakotkas' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT
					PILT,
					b.FILENAME,
					EN._PILTDESCR as DESCR
				FROM spec_images i
				INNER JOIN bindata b on b.ID = PILT
				WHERE SPECID = ''
				ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM spec WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Väike-konnakotkas'' at line 2 

				SELECT
					(SELECT SLNAME FROM sp_names_sub WHERE SPID = sps.SPID AND LANGID = ) as SPNAME
				FROM sp_names_sub sps
				WHERE SLNAME = 'Väike-konnakotkas' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 
SELECT
					PILT,
					b.FILENAME,
					EN._PILTDESCR as DESCR
				FROM spec_images i
				INNER JOIN bindata b on b.ID = PILT
				WHERE SPECID = ''
				ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM spec WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._PILTDESCR' in 'field list' 

			SELECT
				PILT,
				b.FILENAME,
				EN._PILTDESCR as DESCR
			FROM images i
			INNER JOIN bindata b on b.ID = PILT
			WHERE SPID = ''
			ORDER BY ORDERNO ascWarning: db_fetch_*(): supplied argument is not a valid result resource 1054: Unknown column 'EN._DESCR' in 'field list' 
SELECT EN._DESCR as DESCR FROM species WHERE ID = '' 1054: Unknown column 'EN._HEADING' in 'field list' 
SELECT EN._HEADING, EN._BODY FROM texts WHERE FUNC = 'Help' AND ACTIVE = 1  1054: Unknown column 't.EN._META_HEADING' in 'field list' 
SELECT t.EN._META_HEADING AS META_HEADING,t.EN._META_KEYS AS META_KEYS,t.EN._META_DESCR AS META_DESCR,s.INNER_LINK
												FROM texts AS t
												INNER JOIN structure as s ON t.STR_PLACE=s.ID 
												WHERE t.ACTIVE=1  AND t.ID=1  1054: Unknown column 't.EN._HEADING' in 'field list' 
select t.EN._HEADING AS HEADING
						from texts t 
						where t.ACTIVE=1 AND 
						t.ID=1
						order by t.ID DESC LIMIT 1  1054: Unknown column 'EN._PEALKIRI' in 'where clause' 
 select *,
						date_format(kuupaev,'%d.%m.%Y') as KUP,
						date_format(kuupaev,'%Y') as NYEAR
					from uudised
					where (kuni>now() or kuni='0000-00-00') and date_format(kuupaev,'%Y') = '2024' and EN._PEALKIRI != '' and active=1
					order by kuupaev desc<!DOCTYPE>
			<html>
			<head>
			<meta charset='utf-8'>
			<meta http-equiv='X-UA-Compatible' content='IE=edge'>
			<meta name='viewport' content='width=device-width, initial-scale=1'>
			<title>Rändekaart</title>
			<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />
			<meta http-equiv='Content-Language' content='ee' />
			<meta name='description' content='Rändekaart' />
			<meta name='keywords' content='rändekaart, linnud, birdmap, ränne' />
			<meta name='language' content='ee' />
			<meta name='Robots' content='index,all' />
			<meta name='Author' content='5D Vision' />
			<meta name='Revisit-After' content='1 day' />
			<link rel='shortcut icon' href='https://birdmap.5dvision.ee/favicon.ico' />
			<base href='https://birdmap.5dvision.ee/' />
			<script type='text/javascript' src='https://birdmap.5dvision.ee/js/jquery.min.js?202204261524'></script>
<script type='text/javascript' src='https://birdmap.5dvision.ee/vendors/jquery-migrate.min.js'></script>
<link href='https://birdmap.5dvision.ee/vendors/bootstrap/css/bootstrap.min.css' rel='stylesheet'>
			<link rel='stylesheet' href='https://birdmap.5dvision.ee/vendors/leaflet/leaflet.css' /><link rel='stylesheet' href='https://birdmap.5dvision.ee/vendors/malihu-custom-scrollbar-plugin-master/jquery.mCustomScrollbar.min.css' type='text/css' />
<link rel='stylesheet' href='https://birdmap.5dvision.ee/vendors/nouislider/nouislider.min.css' /><link rel='stylesheet' href='https://birdmap.5dvision.ee/vendors/nouislider/nouislider.tooltips.css' /><link rel='stylesheet' href='https://birdmap.5dvision.ee/vendors/fancybox/css/jquery.fancybox.css' /><link rel='stylesheet' href='https://birdmap.5dvision.ee/css/style.css?202204281143' type='text/css' />
<script type='text/javascript' >(function(undefined) {}).call('object' === typeof window && window || 'object' === typeof self && self || 'object' === typeof global && global || {});</script>
<script type='text/javascript' src='https://birdmap.5dvision.ee/vendors/malihu-custom-scrollbar-plugin-master/js/minified/jquery.mCustomScrollbar.min.js'></script>
<script type='text/javascript' src='https://birdmap.5dvision.ee/js/script.js'></script>
<script type='text/javascript'>var lang='EE';var url='https://birdmap.5dvision.ee/';</script>
			<script src='https://birdmap.5dvision.ee/vendors/bootstrap/js/bootstrap.min.js'></script>
			<script src='https://birdmap.5dvision.ee/vendors/leaflet/leaflet.js'></script>
			<script src='https://birdmap.5dvision.ee/vendors/MovingMarker.js'></script>
			<script src='https://birdmap.5dvision.ee/js/animatescript.js'></script>
			<script src='https://birdmap.5dvision.ee/vendors/nouislider/nouislider.min.js'></script>
			<script src='https://birdmap.5dvision.ee/vendors/fancybox/js/jquery.fancybox.js'></script>
		</head>

<!-- base template(Alusmall) start -->
<script type="text/javascript">var _gaq = _gaq || [];
                          	_gaq.push(['_setAccount', 'G_ANALYTICS']);
                          	_gaq.push(['_trackPageview']);
                          	
                          	(function() {
	                        	var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
	                            	ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
	                            	var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
	                        })();</script>
<body>
        <form name='form' id='form' action='https://birdmap.5dvision.ee/EE/' method='post' enctype="multipart/form-data">
        
<!-- body template(Esileht) start -->

<div id='map'></div>
			<script src='https://maps.googleapis.com/maps/api/js?key=AIzaSyCoHQlFMM00FG59wCs16lg8eEUt2T0LUig'></script>
			<script src='https://birdmap.5dvision.ee/vendors/leaflet-google.js'></script>
      <!-- <script type='text/javascript' src='http://maps.stamen.com/js/tile.stamen.js?v1.3.0'></script> -->
			 <script type='text/javascript' src='js/tile.stamen.js'></script>

			<script>
				// var basemap = L.tileLayer('http://{s}.tile.osm.org/{z}/{x}/{y}.png', {});
				var basemap = L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {});
				var satellite = new L.Google('HYBRID');
				//var terrain = new L.StamenTileLayer('terrain');

				var map = L.map('map', {
					zoomControl: false,
					renderer: L.svg()
				}).setView([58.65, 25.0], 7);

				map.addLayer(basemap);

				map.on('popupopen', function () {

					var arrGallery = [];
					$('.fancybox-gallery').each(function (i) {
						arrGallery.push({
							href: $( this ).attr('data-href'),
							title:  $( this ).attr('data-title')
						});
					});

					$('#img-gallery').click(function() {
						$.fancybox(arrGallery,{
							type: 'image',
							titlePosition: 'over'
						});
					});

				})


				var baseMaps = {
					'Aluskaart': basemap,
					'Satelliit': satellite // ,'Maastik': terrain
				};
				L.control.layers(baseMaps).addTo(map);

				if ($(window).width() >= 768) {
					L.control.scale({position: 'bottomright'}).addTo(map);
					L.control.zoom({position:'bottomright'}).addTo(map);
				} else {
					if ($(window).width() < 327) {
						L.control.zoom({position:'topright'}).addTo(map);
						L.control.scale({position: 'topleft'}).addTo(map);
					} else {
						L.control.scale({position: 'bottomleft'}).addTo(map);
					}
				}
			</script>
				<button type="button" class="btn btn-default" id="intro-btn" data-toggle="modal" data-target="#introModal" onClick="closeModal();">
					<span class="glyphicon glyphicon-info-sign"></span>
				</button>
				<div class="modal fade" role="dialog" id="introModal">
					<div class="modal-dialog" role="document">
						<div class="modal-content">
							<div class="modal-header">
								<button type="button" class="close" data-dismiss="modal" aria-label="Close"  onclick="openModal('birdsModal', true);"><span aria-hidden="true">&times;</span></button>
								<h4 class="modal-title">Tutvustus</h4>
							</div>
							<div class="modal-body">
								<p><img class="intropilt" src="https://birdmap.5dvision.ee/admin/pildid/kotkas2.jpg" alt="" width="600" height="381" /> <img class="intropilt" src="https://birdmap.5dvision.ee/admin/pildid/must-toonekurg.jpg" alt="" width="600" height="381" /></p>
<p>Rändekaardil saab näha enam kui 15 aasta jooksul kogutud andmeid saatjaga varustatud lindude rändeteede kohta. Peamiselt on siin Eestist, aga ka mitmest teisest riigist pärit linnud. Võib leida järgmisi liike: must-toonekurg, sookurg, kalakotkas, väike-konnakotkas, suur-konnakotkas, merikotkas, hiireviu, herilaseviu, hüüp, valge-toonekurg, raisakotkas. Tagamaks turvalisuste pesitsusperioodil ei näidata kaardil pesitsusaegseid liikumisi. Liikide üldiseloomustust saab lugeda vasakmenüüs liiginimel klõpsates. Ka isendite kohta võib lugeda vasakmenüüs linnu nimel klõpsates. Aastad on jagatud kevad- ja sügisrändeks, hooaja vahetus toimub <span class="il">1</span>5. veebruaril (algab kevadränne) ja <span class="il">1</span>5. juulil (algab sügisränne). Andmeid on rändekaardi taustal palju, seetõttu võib laadimine võtta pisut aega. Rändekaardi eestvedajaks on <a href="http://kotkas.ee">Kotkaklubi</a>, tehniliseks teostajaks <a href="http://5dvision.ee">5D Vision OÜ</a>.</p>
							</div>
						</div>
					</div>
				</div><script>openModal('introModal', true);</script>
			<script>
				var markers = [];
				var origmarkers = [];
				var data = [];
				var origdata = [];
				var polylines = [];
				var origpolylines = [];
				var dates = [];
				var origdates = [];setupPolylines(0, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird0-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird0-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(1, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird1-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird1-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(2, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird2-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird2-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(3, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird3-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird3-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(4, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird4-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird4-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(5, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird5-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird5-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(6, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird6-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird6-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(7, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird7-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird7-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(8, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird8-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird8-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(9, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird9-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird9-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(10, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird10-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird10-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(11, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird11-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird11-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(12, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird12-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird12-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(13, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird13-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird13-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(14, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird14-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird14-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(15, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird15-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird15-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(16, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird16-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird16-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(17, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird17-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird17-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(18, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird18-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird18-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(19, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird19-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird19-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(20, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird20-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird20-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(21, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird21-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird21-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(22, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird22-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird22-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(23, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird23-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird23-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(24, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird24-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird24-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(25, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird25-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird25-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(26, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird26-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird26-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(27, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird27-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird27-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(28, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird28-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird28-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(29, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird29-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird29-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(30, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird30-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird30-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(31, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird31-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird31-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(32, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird32-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird32-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(33, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird33-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird33-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(34, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird34-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird34-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(35, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird35-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird35-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(36, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird36-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird36-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(37, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird37-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird37-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(38, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird38-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird38-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(39, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird39-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird39-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(40, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird40-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird40-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(41, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird41-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird41-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
setupPolylines(42, [], '', '', '<h4></h4><div class="upper-body"><br><span id="bird42-loc"></span><p><b>Läbitud teekond:</b><br><span id="bird42-dist">0</span> km</p><p class="bird-last-data" style="display:none"><b>Viimased andmed:</b><br>01.01.1970</p></div>', false, '', true);
var startDatePos = '';dates = [];</script>
			<div class="sidebarModal modal left fade" id="birdsModal" role="dialog" aria-labelledby="sidebarlLabel" data-backdrop="">
				<div class="modal-dialog" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<button type="button" class="close left" data-dismiss="modal" aria-label="Close" onclick="openModal('sidemenuModal');">
								<span class="glyphicon glyphicon-menu-hamburger"></span>
							</button>
							<div class="modal-heading">
							Linnud
							<label class="switch" id="birds-switch">
								<input type="checkbox" class="ch-bird-all" id="check-all" onclick="checkAllBirds();" checked></input>
								<div class="slider round"></div>
							</label>
							</div>
							<button type="button" class="close right" data-dismiss="modal" aria-label="Close">
								<span class="glyphicon glyphicon-chevron-left"></span>
							</button>
						</div>
						<div class="modal-body mCustomScrollbar" data-mcs-theme="minimal-dark">
							<ul><li class='list-group-item no-link list-group-heading'><div class='dispinblock specname'></div><a id='specopen-0' class='dispinblock no-padding specname right ' href='javascript:;' onclick='showHideMultiple("0,1,2,3,4,5,6,7",0)'>⌵</a>
				<label class='switch right'>
					<input type='checkbox'  class='ch-bird-grp' id='merikotkas-grp' onclick='checkSomeBirds("0,1,2,3,4,5,6,7", this);' checked></input>
					<div class='slider round'></div>
				</label><input type='hidden' id='merikotkas-grp-values' value='0,1,2,3,4,5,6,7'/></li>
					<li class='list-group-item no-link hidden' id='list-bird0'>
						<input type='hidden' value='merikotkas-grp' id='bird0-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='0' class='ch-bird' id='bird0' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird1'>
						<input type='hidden' value='merikotkas-grp' id='bird1-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='1' class='ch-bird' id='bird1' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird2'>
						<input type='hidden' value='merikotkas-grp' id='bird2-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='2' class='ch-bird' id='bird2' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird3'>
						<input type='hidden' value='merikotkas-grp' id='bird3-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='3' class='ch-bird' id='bird3' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird4'>
						<input type='hidden' value='merikotkas-grp' id='bird4-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='4' class='ch-bird' id='bird4' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird5'>
						<input type='hidden' value='merikotkas-grp' id='bird5-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='5' class='ch-bird' id='bird5' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird6'>
						<input type='hidden' value='merikotkas-grp' id='bird6-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='6' class='ch-bird' id='bird6' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird7'>
						<input type='hidden' value='merikotkas-grp' id='bird7-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='7' class='ch-bird' id='bird7' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li><li class='list-group-item no-link list-group-heading'><div class='dispinblock specname'></div><a id='specopen-8' class='dispinblock no-padding specname right ' href='javascript:;' onclick='showHideMultiple("8,9,10",8)'>⌵</a>
				<label class='switch right'>
					<input type='checkbox'  class='ch-bird-grp' id='must-toonekurg-grp' onclick='checkSomeBirds("8,9,10", this);' checked></input>
					<div class='slider round'></div>
				</label><input type='hidden' id='must-toonekurg-grp-values' value='8,9,10'/></li>
					<li class='list-group-item no-link hidden' id='list-bird8'>
						<input type='hidden' value='must-toonekurg-grp' id='bird8-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='8' class='ch-bird' id='bird8' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird9'>
						<input type='hidden' value='must-toonekurg-grp' id='bird9-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='9' class='ch-bird' id='bird9' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird10'>
						<input type='hidden' value='must-toonekurg-grp' id='bird10-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='10' class='ch-bird' id='bird10' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li><li class='list-group-item no-link list-group-heading'><div class='dispinblock specname'></div><a id='specopen-11' class='dispinblock no-padding specname right ' href='javascript:;' onclick='showHideMultiple("11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27",11)'>⌵</a>
				<label class='switch right'>
					<input type='checkbox'  class='ch-bird-grp' id='sookurg-grp' onclick='checkSomeBirds("11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27", this);' checked></input>
					<div class='slider round'></div>
				</label><input type='hidden' id='sookurg-grp-values' value='11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27'/></li>
					<li class='list-group-item no-link hidden' id='list-bird11'>
						<input type='hidden' value='sookurg-grp' id='bird11-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='11' class='ch-bird' id='bird11' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird12'>
						<input type='hidden' value='sookurg-grp' id='bird12-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='12' class='ch-bird' id='bird12' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird13'>
						<input type='hidden' value='sookurg-grp' id='bird13-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='13' class='ch-bird' id='bird13' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird14'>
						<input type='hidden' value='sookurg-grp' id='bird14-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='14' class='ch-bird' id='bird14' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird15'>
						<input type='hidden' value='sookurg-grp' id='bird15-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='15' class='ch-bird' id='bird15' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird16'>
						<input type='hidden' value='sookurg-grp' id='bird16-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='16' class='ch-bird' id='bird16' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird17'>
						<input type='hidden' value='sookurg-grp' id='bird17-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='17' class='ch-bird' id='bird17' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird18'>
						<input type='hidden' value='sookurg-grp' id='bird18-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='18' class='ch-bird' id='bird18' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird19'>
						<input type='hidden' value='sookurg-grp' id='bird19-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='19' class='ch-bird' id='bird19' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird20'>
						<input type='hidden' value='sookurg-grp' id='bird20-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='20' class='ch-bird' id='bird20' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird21'>
						<input type='hidden' value='sookurg-grp' id='bird21-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='21' class='ch-bird' id='bird21' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird22'>
						<input type='hidden' value='sookurg-grp' id='bird22-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='22' class='ch-bird' id='bird22' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird23'>
						<input type='hidden' value='sookurg-grp' id='bird23-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='23' class='ch-bird' id='bird23' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird24'>
						<input type='hidden' value='sookurg-grp' id='bird24-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='24' class='ch-bird' id='bird24' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird25'>
						<input type='hidden' value='sookurg-grp' id='bird25-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='25' class='ch-bird' id='bird25' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird26'>
						<input type='hidden' value='sookurg-grp' id='bird26-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='26' class='ch-bird' id='bird26' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird27'>
						<input type='hidden' value='sookurg-grp' id='bird27-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='27' class='ch-bird' id='bird27' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li><li class='list-group-item no-link list-group-heading'><div class='dispinblock specname'></div><a id='specopen-28' class='dispinblock no-padding specname right ' href='javascript:;' onclick='showHideMultiple("28,29,30,31,32",28)'>⌵</a>
				<label class='switch right'>
					<input type='checkbox'  class='ch-bird-grp' id='suur-konnakotkas-grp' onclick='checkSomeBirds("28,29,30,31,32", this);' checked></input>
					<div class='slider round'></div>
				</label><input type='hidden' id='suur-konnakotkas-grp-values' value='28,29,30,31,32'/></li>
					<li class='list-group-item no-link hidden' id='list-bird28'>
						<input type='hidden' value='suur-konnakotkas-grp' id='bird28-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='28' class='ch-bird' id='bird28' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird29'>
						<input type='hidden' value='suur-konnakotkas-grp' id='bird29-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='29' class='ch-bird' id='bird29' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird30'>
						<input type='hidden' value='suur-konnakotkas-grp' id='bird30-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='30' class='ch-bird' id='bird30' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird31'>
						<input type='hidden' value='suur-konnakotkas-grp' id='bird31-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='31' class='ch-bird' id='bird31' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird32'>
						<input type='hidden' value='suur-konnakotkas-grp' id='bird32-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='32' class='ch-bird' id='bird32' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li><li class='list-group-item no-link list-group-heading'><div class='dispinblock specname'></div><a id='specopen-33' class='dispinblock no-padding specname right ' href='javascript:;' onclick='showHideMultiple("33,34,35,36,37,38,39,40,41,42",33)'>⌵</a>
				<label class='switch right'>
					<input type='checkbox'  class='ch-bird-grp' id='väike-konnakotkas-grp' onclick='checkSomeBirds("33,34,35,36,37,38,39,40,41,42", this);' checked></input>
					<div class='slider round'></div>
				</label><input type='hidden' id='väike-konnakotkas-grp-values' value='33,34,35,36,37,38,39,40,41,42'/></li>
					<li class='list-group-item no-link hidden' id='list-bird33'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird33-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='33' class='ch-bird' id='bird33' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird34'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird34-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='34' class='ch-bird' id='bird34' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird35'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird35-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='35' class='ch-bird' id='bird35' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird36'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird36-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='36' class='ch-bird' id='bird36' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird37'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird37-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='37' class='ch-bird' id='bird37' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird38'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird38-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='38' class='ch-bird' id='bird38' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird39'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird39-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='39' class='ch-bird' id='bird39' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird40'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird40-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='40' class='ch-bird' id='bird40' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird41'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird41-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='41' class='ch-bird' id='bird41' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li>
					<li class='list-group-item no-link hidden' id='list-bird42'>
						<input type='hidden' value='väike-konnakotkas-grp' id='bird42-grp'></input>
						<div class='bird-color' style='background: '></div><div class='dispinblock list-elem'></div>
					<label class='switch right'>
						<input type='checkbox' value='42' class='ch-bird' id='bird42' onclick='checkBirds();' checked></input>
						<div class='slider round'></div>
					</label></li></ul>
						</div>
					</div>
				</div>
			</div>
		
			<div class="sidebarModal modal left fade" id="settings" role="dialog" aria-labelledby="sidebarlLabel" style="display: none;" data-backdrop="">
				<div class="modal-dialog " role="document">
					<div class="modal-content">
						<div class="modal-header">
							<div class="modal-heading" ></div><button type="button" class="close left" aria-label="Close" onclick="closeModal('settings');openModal('sidemenuModal');">
									<span class="glyphicon glyphicon-menu-hamburger"></span>
								</button>
				<button type="button" class="close right" aria-label="Close" onclick="closeModal()">
					<span class="glyphicon glyphicon-chevron-left"></span>
				</button></div>
						<div class="modal-body-loading" style="display:none; text-align:center; margin-top: 10px;"><img src="img/bird_loading.gif" style="width:50px; opacity: 0.1;"/></div>
						<div class="modal-body" data-mcs-theme="minimal-dark">
							<span class="modal-content-area"><ul>
			<li class="list-group-item no-link">
				<div class="dispinblock">Näita teekonda</div>
				<label class="switch right"><input class="urlpart" type="checkbox" value="1" id="showPoly" name="line" checked></input>
					<div class="slider round"></div>
				</label>
			</li>
			<li class="list-group-item no-link">
				<div class="dispinblock">Jälgi teekonda</div>
				<label class="switch right">
					<input  class="urlpart" type="checkbox" value="1" id="fitBounds" name="track" ></input>
					<div class="slider round"></div>
				</label>
			</li>
			<li class="list-group-item no-link" style="float:left;width:100%;">
				<div class="dispinblock">Kiirus</div>
				<select class="form-control right dispinblock urlpart" id="animspeed" name="speed" onchange="setSpeed()">
					<option value="1">1x</option>
					<option value="2">2x</option>
					<option value="4">4x</option>
				</select>
			</li></ul></span>
						</div>
					</div>
				</div>
			</div>
			<div class="control-btns">
				<button class="btn btn-default" type="button" id="play-btn">
					<span class="glyphicon glyphicon-play"></span>
				</button>
				<div id="timeslider"></div>
				<button class="btn btn-default" id="settings-btn" type="button" href="javascript:;" onclick="closeModal();openModal('settings')">
					<span class="glyphicon glyphicon-cog"></span>
				</button>
				<br id="controls-line-break"><div class="btn-group" id="season-btns" role="group"><button class="btn btn-default active"  type="button" id="season-btn" onclick="$('#cseason').val('spring');getUrlParts();" href="javascript:;">
                                                    <img class="geoicon" src="img/n_d.png"\>
                                            </button><button class="btn btn-default " disabled type="submit" id="season-btn" href="javascript:;" onclick="$('#cseason').val('autumn');getUrlParts();">
                                                    <img class="geoicon" src="img/s_d.png"\>
                                            </button><button class="btn btn-default " disabled type="submit" id="season-btn" href="javascript:;" onclick="$('#cseason').val('allseasons');getUrlParts();">
                                                    <img class="geoicon" src="img/n_d.png"\>
                                                    <img class="geoicon" src="img/s_d.png" style="margin-left: -10px"\>
                                            </button></div><select class="form-control urlpart" name="cyear" id="controls-year" onchange="getUrlParts();$('#form').submit();"><option value="2024" selected>2024</option><option value="2023" >2023</option><option value="2022" >2022</option><option value="2021" >2021</option><option value="2020" >2020</option><option value="2019" >2019</option><option value="2018" >2018</option><option value="2017" >2017</option><option value="2016" >2016</option><option value="2015" >2015</option><option value="2014" >2014</option><option value="2013" >2013</option><option value="2012" >2012</option><option value="2011" >2011</option><option value="2010" >2010</option><option value="2009" >2009</option><option value="2008" >2008</option><option value="2007" >2007</option><option value="2006" >2006</option><option value="2005" >2005</option></select>
			<input class="urlpart" type="hidden" name="cseason" id="cseason" value="spring"></input><input class="urlpart" type="hidden" name="selspecies" value=""></input></div>
			<button type="button" id="share-btn" class="btn btn-default" data-toggle="modal" data-target="#shareModal" onclick="getShareLink('share-url')">
				<span class="glyphicon glyphicon-link" aria-hidden="true"></span>
			</button>
				<div class="modal fade" role="dialog" id="shareModal">
					<div class="modal-dialog" role="document">
						<div class="modal-content">
							<div class="modal-header">
								<button type="button" class="close" data-dismiss="modal" aria-label="Close">
									<span aria-hidden="true">&times;</span>
								</button>
							</div>
							<div class="modal-body">
								<div style="margin-right: 5px;">
									<span class="glyphicon glyphicon-link" aria-hidden="true"></span>
								</div>
								<div id="share-url-div">
									<input id="share-url" class="form-control" type="text" value="" readonly></input>
								</div>
							</div>
						</div>
					</div>
				</div><select class="form-control" id="lang-select" name="lan" onchange="$('#form').attr('action', url + $(this).val());$('#form').submit();return false;"><option value="EE" >EE</option><option value="EN" >EN</option><option value="DE" >DE</option><option value="RU" >RU</option><option value="LV" >LV</option></select><input id='compyears' type='hidden' value=''/>

			<div class="topleft-controls custom-controls">
				<button class="btn btn-default" type="button" data-toggle="modal" onclick="openModal('sidemenuModal');">
					<span class="glyphicon glyphicon-menu-hamburger" aria-hidden="true"></span>
				</button>
			</div>
			<div class="sidebarModal modal left fade" id="sidemenuModal" role="dialog" aria-labelledby="sidebarlLabel" data-backdrop="">
				<div class="modal-dialog" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<div class="modal-heading no-left-margin">APP_NAME</div>
							<button type="button" class="close right" data-dismiss="modal" aria-label="Close">
								<span class="glyphicon glyphicon-chevron-left"></span>
							</button>
						</div>
						<div class="modal-body"><ul><li class="list-group-item side-main-item"><a href="javascript:;" onclick="if (openModal('uudised_2')) {closeModal();};">Uudised</a></li><li class="list-group-item side-main-item"><a href="javascript:;" onclick="if (openModal('toetajaskond_4')) {closeModal();};">Toetajad</a></li><li class="list-group-item side-main-item"><a href="javascript:;" onclick="if (openModal('tagasiside_3')) {closeModal();};">Tagasiside</a></li></ul></div>
				</div>
			</div>
		</div>
		<div id="news-div"></div>
			<div class="sidebarModal modal left fade" id="uudised_2" role="dialog" aria-labelledby="sidebarlLabel" style="display: none;" data-backdrop="">
				<div class="modal-dialog large-modal" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<div class="modal-heading" style='font-size: 15px;white-space: inherit;'><div class="dispinblock">Uudised</div><select class="form-control" id="years-select" onchange="getYearNews('uudised_2')"><option value="2023" selected>2023</option><option value="2022" >2022</option><option value="2021" >2021</option><option value="2020" >2020</option><option value="2019" >2019</option><option value="2018" >2018</option><option value="2017" >2017</option><option value="2016" >2016</option><option value="2015" >2015</option><option value="2014" >2014</option></select></div><button type="button" class="close left" aria-label="Close" onclick="closeModal('uudised_2');openModal('sidemenuModal');">
									<span class="glyphicon glyphicon-menu-hamburger"></span>
								</button>
				<button type="button" class="close right" aria-label="Close" onclick="closeModal()">
					<span class="glyphicon glyphicon-chevron-left"></span>
				</button></div>
						<div class="modal-body-loading" style="display:none; text-align:center; margin-top: 10px;"><img src="img/bird_loading.gif" style="width:50px; opacity: 0.1;"/></div>
						<div class="modal-body" data-mcs-theme="minimal-dark">
							<span class="modal-content-area"><ul></ul><script>getYearNews("uudised_2");</script></span>
						</div>
					</div>
				</div>
			</div>
			<div class="sidebarModal modal left fade" id="toetajaskond_4" role="dialog" aria-labelledby="sidebarlLabel" style="display: none;" data-backdrop="">
				<div class="modal-dialog large-modal" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<div class="modal-heading" ><div class="dispinblock">Toetajad</div></div><button type="button" class="close left" aria-label="Close" onclick="closeModal('toetajaskond_4');openModal('sidemenuModal');">
									<span class="glyphicon glyphicon-menu-hamburger"></span>
								</button>
				<button type="button" class="close right" aria-label="Close" onclick="closeModal()">
					<span class="glyphicon glyphicon-chevron-left"></span>
				</button></div>
						<div class="modal-body-loading" style="display:none; text-align:center; margin-top: 10px;"><img src="img/bird_loading.gif" style="width:50px; opacity: 0.1;"/></div>
						<div class="modal-body" data-mcs-theme="minimal-dark">
							<span class="modal-content-area"><div class="modal-text"></div></span>
						</div>
					</div>
				</div>
			</div>
			<div class="sidebarModal modal left fade" id="tagasiside_3" role="dialog" aria-labelledby="sidebarlLabel" style="display: none;" data-backdrop="">
				<div class="modal-dialog large-modal" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<div class="modal-heading" ><div class="dispinblock">Tagasiside</div></div><button type="button" class="close left" aria-label="Close" onclick="closeModal('tagasiside_3');openModal('sidemenuModal');">
									<span class="glyphicon glyphicon-menu-hamburger"></span>
								</button>
				<button type="button" class="close right" aria-label="Close" onclick="closeModal()">
					<span class="glyphicon glyphicon-chevron-left"></span>
				</button></div>
						<div class="modal-body-loading" style="display:none; text-align:center; margin-top: 10px;"><img src="img/bird_loading.gif" style="width:50px; opacity: 0.1;"/></div>
						<div class="modal-body" data-mcs-theme="minimal-dark">
							<span class="modal-content-area"><div class="modal-text">
				<div class="alert alert-danger" role="alert" style="display:none" id="feedback-msg">Kõik väljad ei ole täidetud</div>
				<div class="form-group">
					<input type="email" id="feedback-email" class="form-control custom-input" placeholder="E-post"></input>
				</div>
				<div class="form-group">
					<textarea class="form-control custom-input" id="feedback-text" rows="3" placeholder="Tekst"></textarea>
				</div>
				<div class="form-group">
					<div id="g-recaptcha"></div>
				</div>
				<input type="hidden" id="g-recaptcha-response"/>
				<a href="javascript:;" class="btn btn-primary disabled" id="send-feedback-btn" onclick="sendFeedback(this);">Saada</a></div>
			<script>
				var verifyCallback = function(response) {
					$("#g-recaptcha-response").val(response);
					$("#send-feedback-btn").removeClass("disabled");
				};
				var onloadCallback = function() {
					grecaptcha.render("g-recaptcha", {
						"sitekey" : "6LcnIRAUAAAAAP4_6kDbzU74GZ884zuNzvsDKUI1",
						"callback" : verifyCallback,
						"theme" : "light"
					});
				};
			</script><script src="https://www.google.com/recaptcha/api.js?onload=onloadCallback&render=explicit&hl=en"></script></span>
						</div>
					</div>
				</div>
			</div>
<!-- body template(Esileht) end -->

        </form>
</body>
<!-- base template(Alusmall) end -->

</html>