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='2022' and PERIOD in ('Spring') and o.SLNAME='Kalakotkas' and s.NAME='Elena' 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 = '141' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Kalakotkas' and s.NAME='Vija' 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 = '156' 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='2022' 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='2022' 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='2022' 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='2022' 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='2022' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Merikotkas' and s.NAME='Kelli' 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 = '155' 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='2022' 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='2022' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Merikotkas' and s.NAME='Pieni' 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 = '175' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Merikotkas' and s.NAME='Pomo' 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 = '103' 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='2022' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Must-toonekurg' and s.NAME='Eedi' 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 = '97' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Must-toonekurg' and s.NAME='Karl II' 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 = '164' 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='2022' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Must-toonekurg' and s.NAME='Pikne' 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 = '185' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Must-toonekurg' and s.NAME='Timmu' 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 = '165' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Sookurg' and s.NAME='Ahja 6' 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 = '157' 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='2022' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Sookurg' and s.NAME='Helju' 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 = '160' 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='2022' 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='2022' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Sookurg' and s.NAME='Uko' 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 = '116' 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='2022' 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='2022' 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='2022' 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='2022' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Suur-konnakotkas' and s.NAME='Sven' 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 = '171' 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='2022' and PERIOD in ('Spring') and o.SLNAME='Suur-konnakotkas' and s.NAME='Tihon' 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 = '121' 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='2022' 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='2022' 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='2022' 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='2022' 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='2022' 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='2022' 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='2022' 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='2022' 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 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 = 'Kalakotkas'' 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 = 'Kalakotkas' 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 = '' 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 = '' 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 = '' 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 = '' 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 = '' 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._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') = '2022' and EN._PEALKIRI != '' and active=1 order by kuupaev desc Rändekaart