Min side2014-08-31T22:39:14+00:00

WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '=']
SELECT IF(alder>=20,'SR',alder) as Alder, TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 50 THEN tid END),''))) '50 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 100 THEN tid END),''))) '100 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 200 THEN tid END),''))) '200 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 400 THEN tid END),''))) '400 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 800 THEN tid END),''))) '800 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 1500 THEN tid END),''))) '1500 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'RY' AND lengde = 50 THEN tid END),''))) '50 Rygg', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'RY' AND lengde = 100 THEN tid END),''))) '100 Rygg', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'RY' AND lengde = 200 THEN tid END),''))) '200 Rygg', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BR' AND lengde = 50 THEN tid END),''))) '50 Bryst', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BR' AND lengde = 100 THEN tid END),''))) '100 Bryst', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BR' AND lengde = 200 THEN tid END),''))) '200 Bryst', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BU' AND lengde = 50 THEN tid END),''))) '50 Fly', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BU' AND lengde = 100 THEN tid END),''))) '100 Fly', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BU' AND lengde = 200 THEN tid END),''))) '200 Fly', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'IM' AND lengde = 100 THEN tid END),''))) '100 Medley', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'IM' AND lengde = 200 THEN tid END),''))) '200 Medley', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'IM' AND lengde = 400 THEN tid END),''))) '400 Medley' FROM `wp_sslk_klubbrekorder` WHERE bane='K' and navn='Fie Othilie S��gaard' and kjonn='K' GROUP BY IF(alder>=20,20,alder) ORDER BY IF(alder>=20,20,alder) DESC

WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '=']
SELECT IF(alder>=20,'SR',alder) as Alder, TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 50 THEN tid END),''))) '50 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 100 THEN tid END),''))) '100 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 200 THEN tid END),''))) '200 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 400 THEN tid END),''))) '400 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 800 THEN tid END),''))) '800 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'FR' AND lengde = 1500 THEN tid END),''))) '1500 Fri', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'RY' AND lengde = 50 THEN tid END),''))) '50 Rygg', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'RY' AND lengde = 100 THEN tid END),''))) '100 Rygg', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'RY' AND lengde = 200 THEN tid END),''))) '200 Rygg', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BR' AND lengde = 50 THEN tid END),''))) '50 Bryst', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BR' AND lengde = 100 THEN tid END),''))) '100 Bryst', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BR' AND lengde = 200 THEN tid END),''))) '200 Bryst', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BU' AND lengde = 50 THEN tid END),''))) '50 Fly', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BU' AND lengde = 100 THEN tid END),''))) '100 Fly', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'BU' AND lengde = 200 THEN tid END),''))) '200 Fly', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'IM' AND lengde = 100 THEN tid END),''))) '100 Medley', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'IM' AND lengde = 200 THEN tid END),''))) '200 Medley', TRIM(LEADING '0' from TRIM(LEADING '00:' from IFNULL(MIN(CASE WHEN art = 'IM' AND lengde = 400 THEN tid END),''))) '400 Medley' FROM `wp_sslk_klubbrekorder` WHERE bane='L' and navn='Fie Othilie S��gaard' and kjonn='K' GROUP BY IF(alder>=20,20,alder) ORDER BY IF(alder>=20,20,alder) DESC

WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like']
SELECT klrekT1.lengde, klrekT1.art, klrekT1.navn, klrekT1.tid, klrekT1.dato, klrekT1.plass, klrekT1.bane, klrekT1.kjonn, klrekT1.poeng, klrekT1.mesterskap, klrekT1.kvalkrav, CAST(TIMEDIFF(STR_TO_DATE(klrekT1.tid,'%i:%s.%f'),STR_TO_DATE(klrekT1.kvalkrav,'%i:%s.%f'))+0 AS DECIMAL(10,2)) as gap FROM ( SELECT klrek.* , krav.mesterskap, DATE_FORMAT(str_to_date(krav.kvaltid,'%i:%s.%f'),'%i:%s.%f') as kvalkrav, kvaltildato FROM wp_sslk_klubbrekorder as klrek, wp_sslk_kvalkrav as krav WHERE klrek.art = krav.art and klrek.lengde = krav.lengde and klrek.bane = krav.bane and klrek.alder+(YEAR(krav.kvaltildato)-YEAR(klrek.dato))<=krav.kvaltilfodtaar and klrek.alder+(YEAR(krav.kvaltildato)-YEAR(klrek.dato))>=krav.kvalfrafodtaar and LEFT(klrek.klasse,1)=krav.kjonn and TIME_TO_SEC(klrek.tid)*1000000+MICROSECOND(klrek.tid) <= TIME_TO_SEC(krav.kvaltid)*1000000+MICROSECOND(krav.kvaltid) and klrek.poeng > 0 and klrek.dato>=krav.kvalfradato and klrek.dato<=krav.kvaltildato and SUBDATE(NOW(), INTERVAL 30 DAY) < krav.kvaltildato and klrek.navn LIKE 'Fie Othilie S��gaard' and klrek.kjonn='K' ) as klrekT1 left outer join ( SELECT klrek.* , krav.mesterskap FROM wp_sslk_klubbrekorder as klrek, wp_sslk_kvalkrav as krav WHERE klrek.art = krav.art and klrek.lengde = krav.lengde and klrek.bane = krav.bane and klrek.alder+(YEAR(krav.kvaltildato)-YEAR(klrek.dato))<=krav.kvaltilfodtaar and klrek.alder+(YEAR(krav.kvaltildato)-YEAR(klrek.dato))>=krav.kvalfrafodtaar and LEFT(klrek.klasse,1)=krav.kjonn and TIME_TO_SEC(klrek.tid)*1000000+MICROSECOND(klrek.tid) <= TIME_TO_SEC(krav.kvaltid)*1000000+MICROSECOND(krav.kvaltid) and klrek.poeng > 0 and klrek.dato>=krav.kvalfradato and klrek.dato<=krav.kvaltildato and SUBDATE(NOW(), INTERVAL 30 DAY) < krav.kvaltildato and klrek.navn LIKE 'Fie Othilie S��gaard' and klrek.kjonn='K' ) as klrekT2 on ( klrekT1.art = klrekT2.art and klrekT1.lengde = klrekT2.lengde and klrekT1.navn = klrekT2.navn and klrekT1.mesterskap = klrekT2.mesterskap and TIME_TO_SEC(klrekT1.tid)*1000000+MICROSECOND(klrekT1.tid)>TIME_TO_SEC(klrekT2.tid)*1000000+MICROSECOND(klrekT2.tid) ) where klrekT2.tid is null ORDER BY klrekT1.kvaltildato, klrekT1.mesterskap, klrekT1.navn, FIELD(klrekT1.art,'FR','BR','RY','BU','IM'), klrekT1.lengde, klrekT1.poeng DESC

Fie Othilie S��gaard – 2007







X