SELECT content.id as content_id,content.container_id as category_id, content.html_name as content_html_name,
content_still.id as still_id, content_still.still_type as still_type, content_still.container_id as page_id, content_still.name as still_name, content_still.title as still_title, content_still.description as still_description, content_still.keywords as still_keywords, content_still.html_name as still_html_name, content_still.sort_order as sort_order,
content_still_rooms.id as room_id
FROM content
JOIN content_still ON content.id=content_still.container_id
JOIN content_still_rooms ON content_still.id=content_still_rooms.still_id
ORDER BY content_still_rooms.sort_order