all-content-query.sql

SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
  FROM universes WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM characters WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM locations WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM items WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM buildings WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM conditions WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM countries WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM creatures WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM deities WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM floras WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM foods WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM governments WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM groups WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM jobs WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM landmarks WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM languages WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM magics WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM planets WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM races WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM religions WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM scenes WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM schools WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM sports WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM technologies WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM towns WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM traditions WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
UNION ALL 
  SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy 
    FROM vehicles WHERE user_id = 5 AND deleted_at IS NULL AND archived_at IS NULL 
ORDER BY page_type, id