Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='<pre>

SELECT
	category_name,
	catch_weight,
		IF(LENGTH(user_login)>0, user_login, CONCAT("Fiskare #", fiske_user.user_id)) as namn,
		fiske_user.user_id,
		CONCAT(
			IF(trip_enddate != "" AND trip_date != trip_enddate,
				IF(YEAR(trip_date) = YEAR(trip_enddate),
					IF(MONTH(trip_date) = MONTH(trip_enddate),
						CONCAT(
							DATE_FORMAT(trip_date, "%e"),
							"-",
							DATE_FORMAT(trip_enddate, "%e %b %Y")
						),
						CONCAT(
							DATE_FORMAT(trip_date, "%e %b"),
							" - ",
							DATE_FORMAT(trip_enddate, "%e %b %Y")
						)
						
					),
					CONCAT(
						DATE_FORMAT(trip_date, "%e %b %Y"),
						" - ",
						DATE_FORMAT(trip_enddate, "%e %b %Y")
					)
				),
				DATE_FORMAT(trip_date, "%e %b %Y")
			)
			
		) as rubrik,
		trip_id,
		fiske_image.image_id
	
FROM	fiske_trip_catch
JOIN	fiske_image_category
ON		fish_id = category_id
JOIN	fiske_user
USING	(user_id)
JOIN	fiske_trip
USING	(trip_id)
LEFT JOIN	fiske_image
ON		fiske_image.image_id = fiske_trip_catch.image_id
WHERE


	(
		category_name = "Abborre"
		AND
		catch_weight >= 1000
	) 
OR 
	(
		category_name = "Björkna"
		AND
		catch_weight >= 400
	) 
OR 
	(
		category_name = "Bleka"
		AND
		catch_weight >= 3500
	) 
OR 
	(
		category_name = "Braxen"
		AND
		catch_weight >= 2600
	) 
OR 
	(
		category_name = "Färna"
		AND
		catch_weight >= 1500
	) 
OR 
	(
		category_name = "Gädda"
		AND
		catch_weight >= 7500
	) 
OR 
	(
		category_name = "Gös"
		AND
		catch_weight >= 4000
	) 
OR 
	(
		category_name = "Harr"
		AND
		catch_weight >= 900
	) 
OR 
	(
		category_name = "Havskatt"
		AND
		catch_weight >= 3000
	) 
OR 
	(
		category_name = "Havsöring"
		AND
		catch_weight >= 5000
	) 
OR 
	(
		category_name = "Hälleflundra"
		AND
		catch_weight >= 15000
	) 
OR 
	(
		category_name = "Id"
		AND
		catch_weight >= 1600
	) 
OR 
	(
		category_name = "Insjööring"
		AND
		catch_weight >= 3600
	) 
OR 
	(
		category_name = "Kolja"
		AND
		catch_weight >= 1000
	) 
OR 
	(
		category_name = "Knot"
		AND
		catch_weight >= 300
	) 
OR 
	(
		category_name = "Kungsfisk"
		AND
		catch_weight >= 1000
	) 
OR 
	(
		category_name = "Lake"
		AND
		catch_weight >= 2700
	) 
OR 
	(
		category_name = "Lax"
		AND
		catch_weight >= 8500
	) 
OR 
	(
		category_name = "Lubb"
		AND
		catch_weight >= 4000
	) 
OR 
	(
		category_name = "Makrill"
		AND
		catch_weight >= 700
	) 
OR 
	(
		category_name = "Multe"
		AND
		catch_weight >= 1200
	) 
OR 
	(
		category_name = "Mört"
		AND
		catch_weight >= 400
	) 
OR 
	(
		category_name = "Näbbgädda"
		AND
		catch_weight >= 500
	) 
OR 
	(
		category_name = "Regnbåge"
		AND
		catch_weight >= 3600
	) 
OR 
	(
		category_name = "Ruda"
		AND
		catch_weight >= 1000
	) 
OR 
	(
		category_name = "Röding"
		AND
		catch_weight >= 2400
	) 
OR 
	(
		category_name = "Sutare"
		AND
		catch_weight >= 1800
	) 
OR 
	(
		category_name = "Sej"
		AND
		catch_weight >= 5000
	) 
OR 
	(
		category_name = "Sik"
		AND
		catch_weight >= 1500
	) 
OR 
	(
		category_name = "Torsk"
		AND
		catch_weight >= 10000
	) 
OR 
	(
		category_name = "Vimma"
		AND
		catch_weight >= 700
	) 
OR 
	(
		category_name = "Vitling"
		AND
		catch_weight >= 900
	) 
OR 
	(
		category_name = "Ål"
		AND
		catch_weight >= 1100
	)
ORDER BY	category_name ASC, catch_weight DESCTillfälligt avbrott (3)</pre>