mysql_error on line
SELECT *, projects.id, projects.city, projects.user_id AS user_id, countries.country, countries.id AS country_id, states.state AS projectstate, beenthere.user_id AS beenthere, favorites.user_id AS favorites, projects.lat, projects.lon, users.removed AS removedUser,
(SELECT COUNT(*) AS count FROM guide LEFT JOIN r_guide ON r_guide.guide_id = guide.id WHERE guide.user_id = '' AND r_guide.project_id = projects.id) as guide
FROM projects
LEFT JOIN countries
ON countries.id = projects.country_id
LEFT JOIN states
ON states.id = projects.state_id
LEFT JOIN beenthere
ON beenthere.project_id = projects.id AND beenthere.user_id = ''
LEFT JOIN favorites
ON favorites.project_id = projects.id AND favorites.user_id = ''
LEFT JOIN users
ON users.id = projects.user_id
WHERE TRIM(countries.country) = 'France'
AND TRIM(projects.city) = 'Paris'
AND TRIM(project) = 'Cité de Refuge'
AND (projects.status = 5 OR (projects.other = 1 AND projects.showother = 1))
LIMIT 1
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='