Selecting all locations

gistfile1.sql

SELECT L.id, L.name, L.description, L.created_at,
				GROUP_CONCAT(
					DISTINCT CONCAT(C.lat, ":", C.lng)
					ORDER BY C.coordinate_order ASC SEPARATOR ", "
				) AS coordinates,
				GROUP_CONCAT(
					DISTINCT CONCAT(M.media_type, "#", M.media_url)
				) AS media
			FROM locations AS L

			INNER JOIN locations_coordinates AS C ON L.id = C.location_id
			INNER JOIN locations_media AS M ON L.id = M.location_id
			
			WHERE L.id = C.location_id
			GROUP BY L.id, L.name, L.description, L.created_at ASC