SELECT hotels_description language hotels_description description hote

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
SELECT
hotels_description.language,
hotels_description.description,
hotels.hotel_id,
hotels.title,
hotels.stars,
hotels.adress
FROM
hotels
INNER JOIN hotels_description ON (hotels.hotel_id = hotels_description.hotel_id AND hotels_description.language = 1)