m2k
Новичок
Нормален ли такой запрос ???
SELECT hotel.id, hotel.hotel, hotel.active
FROM db.tourism_hotel AS hotel
LEFT JOIN db.tourism_resort AS resort
ON resort.lang='RU' AND resort.id=hotel.id_resort
LEFT JOIN db.tourism_city AS city
ON city.lang='RU' AND city.id=hotel.id_city
WHERE
hotel.lang='RU' AND
(resort.active=1 OR hotel.id_resort=0) AND
(city.active=1 OR hotel.id_city=0)
ORDER BY resort.position DESC, city.position DESC, hotel.position DESC
SELECT hotel.id, hotel.hotel, hotel.active
FROM db.tourism_hotel AS hotel
LEFT JOIN db.tourism_resort AS resort
ON resort.lang='RU' AND resort.id=hotel.id_resort
LEFT JOIN db.tourism_city AS city
ON city.lang='RU' AND city.id=hotel.id_city
WHERE
hotel.lang='RU' AND
(resort.active=1 OR hotel.id_resort=0) AND
(city.active=1 OR hotel.id_city=0)
ORDER BY resort.position DESC, city.position DESC, hotel.position DESC