ERROR: 42000:1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND 
						G.hotel_Long <> '' AND
						G.hotel_Lat <> ''' at line 67  SELECT
						H.hotel_Regio as regio,
						'Spanje' as  lando,
						REGIO_OMSCHRIJVING_NL as regioo,
						(MIN(hotel_Long) + (MAX(hotel_Long) - MIN(hotel_Long)) / 2) as lon_ctr,
						(MAX(hotel_Long) - MIN(hotel_Long)) as lon_dis,
						(MIN(hotel_Lat) + (MAX(hotel_Lat) - MIN(hotel_Lat)) / 2) as lat_ctr,
						(MAX(hotel_Lat) - MIN(hotel_Lat)) as lat_dis,
						GROUP_CONCAT(
							U.UNI_HOTELCODE,
							'_',
							hotel_Lat,
							'_',
							hotel_Long,
							'_',
							U.UNI_NAAM,
							'_',
							U.UNI_CAT,
							'_',
							P.PHOTO_NAME,
							'_',
							ifnull(DDG_DISTANCE,''),
							'_',
							ifnull(DDG_DUR_HOUR,''),
							'_',
							ifnull(DDG_DUR_MIN,''),
							'_',
							if(UNI_PLAATS = '',LOWER(hotel_Village),LOWER(UNI_PLAATS)),
							'_',
							SUBSTRING(B.UNI_BEOORDELING,1,150),
							'_',
							'streek_map'
						SEPARATOR '#') as lat_lon_hotel
					FROM
						tbl_unitext U
					LEFT JOIN
						tbl_unitext_beoordeling B
					ON
						U.UNI_HOTELCODE = B.UNI_HOTELCODE AND
						U.UNI_SEASON = B.UNI_SEASON AND
						U.UNI_USER = B.UNI_USER
					LEFT JOIN
						bmt.tbl_hotel H
					ON
						H.hotel_Hotelcode_int = U.UNI_HOTELCODE
					LEFT JOIN
						geocodes.tbl_hotel_geo G
					ON
						G.hotel_Hotelcode = U.UNI_HOTELCODE
					LEFT JOIN
						dest_jet.tbl_regio
					ON
						H.hotel_Regio = REGIO_CODE
					LEFT JOIN
						(SELECT PHOTO_NAME,PHOTO_HOTELCODE,PHOTO_PRIORITY FROM tbl_photo where PHOTO_USER = 'A' AND PHOTO_SEASON = '4' GROUP BY PHOTO_HOTELCODE ORDER BY PHOTO_HOTELCODE,PHOTO_PRIORITY) as P
					ON
						P.PHOTO_HOTELCODE = U.UNI_HOTELCODE
					LEFT JOIN
						jetair.tbl_dd_google
					ON
						U.UNI_HOTELCODE = DDG_HOTELCODE
					WHERE
						USER = 'auto' AND
						U.UNI_USER = 'A' AND
						U.UNI_SEASON = '4' AND
						H.hotel_7Z <> 'N' AND
						H.hotel_Regio IN () AND 
						G.hotel_Long <> '' AND
						G.hotel_Lat <> ''