Notice: 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 'JOIN `hotels_photos` ON `hotels_photos`.`memberID` = `members`.`id` AND `hotels_' at line 11:
Here is your query: 
SELECT `members`.`id`, `members`.`logo`, `members`.`languages`, `members`.`memberType`, `members`.`headerID`, 
						   `hotels`.`onlineBooking`, 
						   `hotels_info`.`hotelName` AS `memberName`, 
						   `regions`.`name` AS `regionName`, `regions`.`weatherCode` AS `regionWeather`, 
						   `counties`.`name` AS `countyName`, `counties`.`weatherCode` AS `countyWeather`, 
						   `cities`.`name` AS `cityName`, 
						   COUNT(`hotels_photos`.`id`) AS `photosCount` 
					FROM `members` 
					LEFT JOIN `hotels` ON `hotels`.`memberID` = `members`.`id` 
					LEFT JOIN `hotels_info` ON `hotels_info`.`memberID` = `members`.`id` AND `hotels_info`.`langID` =  
					LEFT JOIN `hotels_photos` ON `hotels_photos`.`memberID` = `members`.`id` AND `hotels_photos`.` in /home/h1tc0m/public_html/objects/database.php on line 44

1