SELECT content.id as content_id,content.container_id as category_id, content.html_name as content_html_name, content_tours.id as tour_id, content_tours.tour_type as tour_type, content_tours.container_id as page_id, content_tours.name as tour_name, content_tours.title as tour_title, content_tours.description as tour_description, content_tours.keywords as tour_keywords, content_tours.html_name as tour_html_name, content_tours.sort_order as sort_order, content_tour_rooms.id as room_id, content_tour_rooms.thumbnail as thumbnail, content_tour_rooms.file_size_mov as mov_size, content_tour_rooms.file_size_swf as swf_size, content_tour_rooms.file_size_java as java_size FROM content JOIN content_tours ON content.id=content_tours.container_id JOIN content_tour_rooms ON content_tours.id=content_tour_rooms.tour_id WHERE content_tour_rooms.container_id = $id AND content_tour_rooms.thumbnail != NULL AND content_tour_rooms.sort_order=5 ORDER BY content_tour_rooms.sort_order